DSXchange

below is the COBOL code , please provide DS code for the same immediate reply appreciate EVALUATE CLAT-DIAGN-CD(WS-CLAT-IDX) WHEN 0.0 THROUGH 136.9 MOVE 1 TO CLAT-DIAGN-CTGRY-CD(WS-CLAT-IDX) WHEN 137.0 THROUGH 226.9 MOVE 2 TO CLAT-DIAGN-CTGRY-CD(WS-CLAT-IDX) WHEN 227.0 THROUGH 279.9 MOVE 3 TO CLAT-D...

Hi Gurus, i am working on COBOL to DS conversion project , i am facing problem with generating a code for the cobol code COMPUTE CLAT-CLMT-DSBLTY-DRTN(WS-CLAT-IDX) = (FUNCTION INTEGER-OF-DATE (WS-VLTN-DT-YYYYMMDD) - FUNCTION INTEGER-OF-DATE (WS-ONSETDT-YYYYMMDD) + 1) / 30.4375 END-COMPUTE above two ...

Hi ,

I want update my file name abcd_curdate.txt, once we ran the job
for ex : if we ran today abcd_20092012.txt
how we can achive please suggest on this
i am using server job and batch job, not parllel and sequence
thanks in advance

HI ,
i have source with null values ,i want pass the insted of null values as a "NAP"not applicable how we can we perform this
would you please help out this ...

If the source is oracle you can user analytical functions directly in the query and if it is file you can follow the below steps 1)sort the data using sort stage on scr column (desc ) in sequential mode 2)In transformer use same partition and also counter=counter+1 intialized to 0 and also it won n...

Hi woul you please provide logic to find rank on scr column by using transformer stage This is my in put data cid name scr 101 xxx 95 102 yyy 80 103 vvv 91 104 ddd 40 105 sss 92 106 eee 50 require o/p cid name scr rank 101 xxx 95 1 102 yyy 80 4 103 vvv 91 3 104 ddd 40 6 105 sss 92 2 106 eee 50 5

kandyshandy wrote:Sort and a vertical pivot. Search here & you will find many..

thanks kandyshandy ' for providing logic And is there any logic to do same by using transformer

Hello, This is My input data EID ENAME LOC 1111 SUMAN HYD 2222 MURALI DEL 3333 VENKAT CHN 1111 SUMAN BAN 2222 MURALI HYD 3333 VENKAT BAN 1111 SUMAN CHN 2222 MURALI MUM 3333 VENKAT PUN my out put should be like this EID ENAME LOC 1111 SUMAN HYD,BAN,CHN 2222 MURALI DEL,HYD,MUM 3333 VENKAT CHN,BAN,PUN ...

i am using datstage v 8.0 , and i am getting error like
1.the memory usage is exceded 100,000 bytes and expecting delimitor ;

hi ,
i have source file CSV file , and i am using seq file satge , after importing meta data when i am trying to view data it is showing error,
can uoy please guiode me
thanks in advance

hi All my data is like prod_id , prod_start date , prod_end date ,Amt_d 000440250509 01/22/2005 12/31/9999 19.98 000440250509 01/29/2005 12/31/9999 19.98 000440250509 02/05/2005 12/31/9999 19.98 000440250509 02/12/2005 12/31/9999 19.98 000440250509 02/19/2005 12/31/9999 19.98 000440250509 02/26/2005...

Can you help me to export User defined Variables defined in Admin. I believe it stores data into some Unix File

Hi friends
i am facing problem with exproting user difined environment variableas from unix environment

Any body helpout from this problem i appriciate
Vlaxmi