Search found 13 matches
- Thu Feb 28, 2013 3:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: please provide replica DS transformer code of below code
- Replies: 7
- Views: 2735
please provide replica DS transformer code of below code
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...
- Thu Feb 28, 2013 3:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: equalent datastage transaformer code
- Replies: 3
- Views: 1766
equalent datastage transaformer code
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 ...
- Thu Sep 20, 2012 4:30 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: how to pass current date as filename in datastage server
- Replies: 7
- Views: 16587
how to pass current date as filename in datastage server
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
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
- Tue Apr 24, 2012 4:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to pass Null to default value wit out using transformer
- Replies: 1
- Views: 1224
how to pass Null to default value wit out using transformer
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 ...
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 ...
- Thu Apr 19, 2012 4:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: provide logic to find rank
- Replies: 17
- Views: 7839
logic for rank
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...
- Thu Apr 19, 2012 1:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: provide logic to find rank
- Replies: 17
- Views: 7839
provide logic to find rank
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
- Wed Apr 18, 2012 12:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: please provide logic for this
- Replies: 5
- Views: 2623
- Tue Apr 17, 2012 11:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: please provide logic for this
- Replies: 5
- Views: 2623
please provide logic for this
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 ...
- Thu Nov 10, 2011 11:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: unable to view data from CSV file
- Replies: 4
- Views: 2393
- Thu Nov 10, 2011 12:56 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: unable to view data from CSV file
- Replies: 4
- Views: 2393
unable to view data from CSV file
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
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
- Wed Mar 02, 2011 2:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: i have prob with effectve date and end date
- Replies: 3
- Views: 1983
i have prob with effectve date and end date
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...
- Thu Aug 12, 2010 4:36 am
- Forum: General
- Topic: How to export user difined environment variables in ds admin
- Replies: 4
- Views: 2134
- Thu Aug 12, 2010 4:12 am
- Forum: General
- Topic: How to export user difined environment variables in ds admin
- Replies: 4
- Views: 2134
How to export user difined environment variables in ds admin
Hi friends
i am facing problem with exproting user difined environment variableas from unix environment
Any body helpout from this problem i appriciate
Vlaxmi
i am facing problem with exproting user difined environment variableas from unix environment
Any body helpout from this problem i appriciate
Vlaxmi