DSXchange

Sorry for this late reply.

The sum is stored in FLOAT field in a table.
DS replace the number by zero when there is job phantom

I change the input from DECIMAL to FLOAT.
Then, there is no problem.

Hi, I have a strange problem. I put in a stage variable : NullToZero(A)+NullToZero(B)+NullToZero(C) But A is in type DECIMAL and B,C in FLOAT A,B and C come from table (oracle) When the job run, sometimes, I have some job phantoms (non numeric when numeric required). If I change the stage variable t...

hi us1aslam1us and ray.wurlod,

ok, i save this page in my pc and will try it later.

Thanks.

Chulet and DSGuru2B, thank you very much.
Very excellent solution !!

Hey, doesn't it exist applauding emoticon in DSX Forums ?...
Thank a lot !

Hi, We've found a new problem in the CSV file (Excel) : when the last column doesn't have value, Excel doesn't generate correct CSV file (especially after the 16th row...). For exemple line1 name1;name2;name3 line2 data21;data22;data23 line3 data31;data32;data33 ... line16 data161;data162 line17 dat...

Thanks a lot !
I replace Decimal Type by Float for the decimal and it work perfectly (with Oracle 9i plugin)
:D

Hi, Our DS server/client version is 7.1r1 All our input file are in CSV format (; as separator). They are generated by excel (french version) which put ',' for decimal number and sometimes with spaces. But, in datastage, decimal must be with comma '.' So, for all decimal derivations, I'va to use TRI...

Thanks chulett and DSGuru2B,

I find the problem. I think i did a mistake Propagate column" from file to colum. So there was some supplement columns at the end of the description of the table.

Hi,

I've a strange warning. My job is very simple :

FileSeq (in)
||
Transformer => Table (out)
||
HashFile (in)

I've ORA-00904 (invalid identifier).
I'm looking for errors but find nothing to change.

Do you know where this problem come from or have any idea ?

Thanks.

Yes, I use this constraints : Doublon file: (table.REJECTED and table.DBMSCODE = 'ORA-00001' ) Filter file : (table.REJECTED and table.DBMSCODE <> 'ORA-00001' ) So i can catch every error from table. But, DS generate some also warning in the log (in Director). Here, some routine use this to generate...

Hey,
you didn't give me help for my second question about the log
=================
....

2. Is-it possible to insert in table without warnings (option : No warning ?). Because, warning stops global batch...

I think it's no...

Thanks Kumar !

WHY didn't I use DSX to solve my previous DS problems ??

WHHYYYY ???

Great, DSGuru2B. Filter command = SORT /+2 (you needn't specify the input) This command sort the input by the 2nd character but not on the 2nd fields. So for file with invariable format, it's OK But for CSV file (fields separated by ;), the sort doesn't work because the number column doesn't corresp...

Very quick

But can we sort on specific fields on the input file ?

Sorry, I should miss something in the previous reply... :roll: If you use Sort, you have 6 stages : SeqFile - Sort - SeqFile - Transformer - File1 + File2 (doublon) If you use agregator, you have also 6 stages : SeqFile - Agregator - HFile - Transformer - File1 + File2(Doublon) Can we do quicker wit...