DSXchange

Lookup fileset are preferred as
1) Indexing details of columns are preserved
2) The lookup column details are also stored.

Hello All, We have a requirement for reading a Pipe Delimited, Variable Length, EBCDIC file. I am using a CFF stage for the same. Things done 1) File layout imported 2) Record Type set as "Variable" 3) Character Set kept as "EBCDIC" But where do we specify the Field delimiter in ...

We will be getting a records of say length 20. In this record, one field(or one column) will be of type packed decimal and the starting position and the ending position of this field's going to be variable.

Hi All,

We have a requirement in our project, wherein we need to read a variable length packed decimal field from a mainframe file , which is FTPed into our Unix box.

Any ideas on how this could be read?

yes.. Used the below query /opt/IBM/IIS/InfoSrv81/Server/DSEngine/bin/dsjob -server SERVER-user UN-password PWD-run -wait 'Path1=/home/cdhuser/USERNAME/file.txt''Path2=/home/cdhuser/USERNAME/reconfile.txt''Dsnsource=DSN_dv''Dsnusername=USERNAME''Dsnpassword=PASSWORD''RejPath=/home/cdhuser/USERNAME/r...

I have cded into the directory where the dsjob is stored. i am trying to run it from there. Is this not right??

Tried that as well. Again getting the same issue. Even
dsjob -lprojects
doesnt work

Sainath.Srinivasan wrote: If you are new to DataStage, why are you tasked with putting together such a 'performance tips and coding standards document' !!??

Exactly my thoughts!

why do you want to transfer env variables?
They will be common for all the projects. You can modify them by including them as part of your job design.

Have you specified same partition to the data coming from the dataset?

Use tail stage to get the last 'n' number of records

You can use the "Before Job" , "After job" properties available in the stages.

The irrelevant result must be due to blank spaces.

Try using

If NullToEmpty(col1) = trim(col1) then '' else col1

I have faced similar issues. Mine was a 300+ column transformer and it did take a performance hit. Best bet is to try and use the modify stage.

Check with the below guide for help

http://www.scribd.com/doc/25520167/Data ... oper-Guide