Guide or tutorial to write Datastage Routines
Posted: Tue Aug 04, 2009 10:21 pm
Hi,
Could anybody help me with Guides or tutorials for writing and using Datastage routines.
Or could anybody suggest to do this without routines >
source: oracle
target: tab delimited sequential file
requirement:I need to break a line into two rows if text in a row is more than 132 chars.
col1: key value
col2: notes
if notes are longer than 132 then terget should look like:
key1<tab>notes1(1-132 chars)
key1<tab>notes1(133-265 chars)
key1<tab>notes1(266-531 chars)
.... so on
Regards,
Satish
Could anybody help me with Guides or tutorials for writing and using Datastage routines.
Or could anybody suggest to do this without routines >
source: oracle
target: tab delimited sequential file
requirement:I need to break a line into two rows if text in a row is more than 132 chars.
col1: key value
col2: notes
if notes are longer than 132 then terget should look like:
key1<tab>notes1(1-132 chars)
key1<tab>notes1(133-265 chars)
key1<tab>notes1(266-531 chars)
.... so on
Regards,
Satish