DSXchange

Hi,

col1 7 ,6,3
col2 21,4,9

finally
col1 3,6,7
col2 21,9,4

Yes you are right

HI,

I want col1 to be in Asc and col 2 to be in Desc in table of 10 reords.how can i implement this ....by using sort stage we could do for the whole table,but how could we do .....

Thanks
sunitha

HI,

Instead of using Remove duplicate stage , is they any other way to remove duplicates from a table.

Thanks
sunitha

HI,

in parallel jobs

Thanks
sunitha

HI,

EMPNO ENAME
70 AAA
10 BBB
30 ZZZ
.......UPTO 10 ROWS

70 AAA SHOULD BE IN ASC
10 BBB SHOULD BE IN DESC

Thanks
sunitha

Hi,

How can we implement normalization in our jobs.
Thanks
Sunitha

Hi,

How can we sort the first row in asc and second row in desc in a table of ten columns.
Thanks
suniotha

Hi, moving all the 4 flat files into one flat file,so finally that file is used as input for another job. i have about 14 columns common in each of the 4 flat files,so i am manually entering the columns and assigning 'null' to the columns not required. I THINKK THEY IS OTHER OPTION TO DO IN SERVER J...

hi,

u have 4 flat files ,in thes 4 files i have 14 column names same,how could i merge them into single flat file.they are no common values in them.
Thanks
sunitha

Hi,

I am not a not a Premium member so not able to see the whole message.
Thanks
sunitha

Hi, 32001 CMP^O0010301^O^O0153 here in place upcaret 9 null charcters should be placed but Ds is reading it as 32001 CMP(HERE NINE NULL CHARACTERS SHOULD BE PLACED in tenth positon BUT IT IS READING AS"^"AND TAKING THE NEXT RECORD Into "zero" in the 11th position . Thanks sunitha

I moved files through ftp with ASCII as the transfer type and the files are fixed width in the source system. How to handle these control characters in the output so that I am able to process the data further using DataStage?

I am using datastage server

i moved my file s from as/400 to unix by using ascript and it is not "^0" ,is is only "^" ,here 0 is a record.