DSXchange

Thank You
I'll try that.

Hi All
I'm sorry to jump in thi topic but i'would like to know how you do that:

You can technically do this all in one transformer but beginners should stick with three transformers with one lookup apiece.

I'm not a beginner but i use severals transformers to add the missing keys.

Thank you

Hi
Can you post the CopyBook ?

Hi All First of all i'm sorry for not answering earlier. My job works fine now, there are the modifications : I doubled check the format of the datas -> two columns were wrong in the merge stage. I reduced the size of the rows (and of the files ) by selecting only the useful columns when i build the...

One of the files was 1 Go and now is 600 MO (sorry about that). The job abort at the same row but i didn't try an another sort (i'll try and keep you posted). The first stage after the merge is a transform who select the row to send to a hashFile. I tried with a Sequential after the merge and the jo...

Hi
We have/had the issue with our new projects on Oracle.
It's related to a link between the database and Ds.

Hi All I try to merge two files (100 Mo / 600 Go) , the join is COMPLETE SET. After dealing +/- 500000 rows the job abort with this messages : Function 'DSCSaveRowToBuf' failed Function 'get_next_output_row' failed Arithmetic overflow The job works fine with smaller files. Is it a size problem or ca...

Hi all I jump into that topic, i don't have problem but i want a clarification. Are you sure of this ? (the bold part) Truncate table then insert rows - Truncates the table with no transaction logging and faster performance. For IBM DB2 and Informix, this option is the same as Clear table then inser...

Hi All
I'm using TRANS now and it works perfectly.

Ray : i didn't fing the !EXIST routine ind DataStage Basic Guide or in the help.

Thank you again

Hi I changed my code to this Found=DSCheckRoutine("DSU.FERMATBale2RExecDosRename") If(NOT(Found)) Then Call DSLogFatal(" La routine DSU.FERMATBale2RExecDosRename est absente du projet",'') end I hope it was what you want me to do because i'm no longer be a premium member. The beh...

Hi Apparently the DSCheckRoutine does not work for the before/after routine. Here my code if (NOT(DSCheckRoutine("DSU.FWKCommunDSLogJournalv2"))) Then Call DSLogFatal(" La routine DSU.FWKCommunDSLogJournalv2 est absente du projet",'') end else deffun DSLogJournal (Arg1, Arg2, Arg...

The only problem is that (BTW or FYI) i'm not English.

I'll keep you posted.
What does AFAIK mean ?

Not just the designer but all the client side (admisnitrator,director).
And yes our windows speaks French too

We change the language when installing another pc and the wizard is in English but the designer stays in French.