DSXchange

Try to read EBCDIC Data File Using Sequential Stage and Pass the Metadata using Schema File(You can parameter the Schema file Name ).

SELECT code, seq_no, ref_date from <TABLE NAME> OUTT
WHERE ref_date =(SELECT MAX( ref_date ) from <TABLE NAME> INN
WHERE INN.code=OUTT.code )

1) Creat 'HEADER' record using 'CAT' command in job sequencer or before job routine. 2)append 'DETAIL' records in to XYZ.txt file 3)Create and append 'TRAILER' record in job sequencer or in same job it self. if you want create TRAILER in same job then get row num from source file as column,if you ha...

convert into julian date and minus number of days you want and reconvert into date format.

I think you can achieve this by splitting the job into two jobs, In first job get distinct of Column1 values. in second job use this values to crate file and filter the data on Column1. in sequencer job call JOb1 then use a loop activity and call JOB2. if distinct list of COLUMN1 in JOB1 is 1,2........

Hi,

1)You can find the occurrence of sub string in string using offsetOfSubstring() function, It is a APT_STRING function.
2)If sub string is found then find the index of sub string using occurrences() function,it is also a APT_STRING function.[/i]

Hi

fields "STORE_AGE_CLS_NUM" and "STORE_AGE_CLS_NUM" read as Varchar from source and cover to decimal using StringToDecimal.

Useing SequentialfileStage with Filltercommand(use Unix(HEAD or TAIL) Command to cut first two lines) and deffine single column in metadat(to read file as a single column)

there is no diff.. in working but... Filterstage as good performance compare to Trans..

you can use DSJobStartTimestamp OR DSJobStartDate

Hi, I am looking for documents for the following : a) guidelines to design and development of Data stage jobs (ETL standards document) b) Change Management processes c) Templates for Data stage design The client has chosen datastage as the ETL tool and I have to come up with the above mentioned doc...

Latha1919 wrote:Does Windows 2003 supports DataStage 6.0 ?

yes,it supports DataStage6.0 and 7.x

i think there is no limit