DSXchange

Thanks John,

But where Can I find this option :

you can get direct access to the schema version of definition by clicking [Show schema] on the Parallel tab.

Pey

Hi Everybody, I import the definition of my Oracle Database in using : Table Definitions/Orchestrate Schema Definitions and after I choose Database table. But when I import the structure in DataStage, it translates Number by BigInt or Decimal(38,10). I would like to modify my schema but I don't know...

Thank you Chulett, it's logic.
The next time I reflect two time before putting a question.

Thanks again

Pey

Hello everybody,

In the administrator, I selected the option "Log report messages after each job run" and I would like to know where and How can I retrieve these informations?

Thanks for your help and your time,

Regards,

Pey

Hello Mat,

In my case, I work around : 2 possibilities
- In adding a field in mu lookup file Set with a default value. After the lookup, I test the value in my transform.
- In using the option "reject" in the look up stage.

Regards,

Pey

Thank you and Happy Christmas.

Pey

Hi,

I know with the version 7.5, I can remove acceptable warning messages with the message handler functionality but how can I do that? And which file keep all these informations and where?

Thank you for the answers,

Regards,

Pey

If the job is cipmiled, you can see it in the director

Pey

Hi,
the signification of the stars is the PX StringToTimestamp function cannot interpret the timestamp input format that I'm trying to convert.

We have to found the good format if it exists with PX else to use a Server job.

Regards,

Pey

Arnd,

The result I have is in putting the result into a flat file. I will investigate better your point today.

Thank you

Sorry ArndW. I come from Lyon but I have a mandate in Canada. Good word game, I never thought it. Concerning your answer, I try it but in my Output, I have stars in place of the timestamp. In input, I have the value "6/1/2002 01:00:00.000 PM" defined as Varchar(25) and in output, I have &q...

Hi,

I can't find the solution, that's why I need your help.

My input is a file and the format of my timestamps is:
"6/1/2002 01:00:00.000 PM"

I need to transform it to the following format:
"2002-01-06 13:00:00"

How can I do this with PX?

Thank you,

Pey

Ray,

Yes, It's really PX.

But In the input stages (Sequential Files), my field A1 and B1 are NOT NULL.
After the Join Stage they are always NOT NULL so I think that DataStage puts a default but I don't know which default.

If Already try : IF ISNULL(A1) Then B1 Else A1 but it doesn't working.

Pey

Hello Everybody, Is anaybody can help me: I have Two Input Sequential Files: File A with Field A1 as Key, FieldA2 File B with Field B1 as Key, FiledB2 I do a full Join on FileA.FieldA1 and FileB.FieldB1. In transform, depending on the source, I would like to put the good key A1 or B1: If A1 exist th...