DSXchange

We have recently implemented PCI compliance on AIX box where Information Server is installed. Situation is whever we are trying to call Db sequence(DB2) in transaformer stage it is taking ages (1.5 hrs) to generate keys for paltry 0.1 million records. For testing we have designed a simple test job R...

Thanks Andrw for the reply..
So that means if the input streams are sorted on COL1 and COL2 , so after join the sorting will be preserved on both columns in the output of join.....is this correct??

Ray,
I moved this Datastage forum

Just wanted to check, whether sort order is preserved in the output of join stage, once we join (inner,Left Outer, Right Outer or Full Outer) the two input links which are already Hash Partitioned and Sorted on the joining keys. I never faced any issue with the sort order once join operation is perf...

Just wanted to check, whether sort order is preserved in the output of join stage, once we join (inner,Left Outer, Right Outer or Full Outer) the two input links which are already Hash Partitioned and Sorted on the joining keys. I never faced any issue with the sort order once join operation is perf...

Join do not have any reject link and do not try bump your head trying to take a reject link out of it. Use outer joins in the join stage and then separate out the records using a transformer. Or else try merge stage if it suits your reject requirement.

From the designer Use Import>Table Definitions>Sequential File Definitions Select directory containing your modified file and sucessively the file and then check the format which comes then by default edit the metadata where required and save it. Use sequential file stage then to read the modified f...

Looks like you have a pipe delimited sequential file. try getting rid of the below portion before reading the entire file. ***** ABC TESTING ***** 20/08/10 at 3:43 pm SY039 F I L E L A Y O U T U T I L I T Y Page.: 1 Library: PLDUSRA File: YELBOK Selection: YELBOK____ *USRLIBL__ Record : RYELBOK Text...

You need to give the file layout snapshot and not the actual file here. For reading binay files there is a separate Cobol file definition file (not necessarily having .cfd extension) which needs to be imported using "Import Cobol file definition" option.

Can you paste some portion of the file layout......

I dont have server connection right now, otherwise would have checked at my end instead of hit and trial. The modify specification is wrong.

Just map it directly and let datastage does the automatic conversion.
ABBESTDOWNTIME=ABBESTDOWNTIME

Import the layout using COBOL file definitions....

Try putting a modify stage in between the source and target. Keep the source column datatype as dfloat and the target datatype as sfloat (as required by target SQL server). Datastage does an implicit conversion from dfloat to sfloat. Give it a try.

What is the target column data type you are putting your source column into and in which stage this error is coming? For checking which value is causing the error you can try a sample job by restricting the input rows to 10 or 20 to check it.

Please put the exact error emssage...