Thanks for giving reply..
Can you please explain me clearly
Kind Regards
Search found 30 matches
- Fri Oct 24, 2008 11:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to extract Header and Detail Records separately
- Replies: 5
- Views: 2790
- Fri Oct 24, 2008 10:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to extract Header and Detail Records separately
- Replies: 5
- Views: 2790
How to extract Header and Detail Records separately
Hi All I need to extract the header of the file and its detail records separately and do some validations and after that again I need to merge them together. Soure data ------------- ID|COUNTRY_ID|F2400|F2500|F2600 101|1|1001|1002|1003 102|2||1004|1006 103|3|1005||1008 I want to extract the header a...
- Thu Oct 23, 2008 9:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Columns into values
- Replies: 3
- Views: 1906
Hi, I tried with your option but I am not able to do the same. source: ID,COUNTRY,2400 Ref data: NAME,VALUE 2400,BANK 2500,CON I was able to read the source columns as a record using hashfile and when I am trying to match it with lookup colunm name ..it gives me the result as below RESULT: ID,COUNTR...
- Mon Oct 20, 2008 11:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Columns into values
- Replies: 3
- Views: 1906
Columns into values
Hi All, I have the following requirement some one please help me out.. I am Having a source records as followed. ID,ID1,2400,2500,2600 ------------------------------------------- 1234,1,100,,102 and I have a reference table with the following data NAME,VALUE --------------- 2400,BANK 2500,EDU 2600,F...
- Tue Oct 07, 2008 7:25 am
- Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- Topic: Problem with the header part
- Replies: 5
- Views: 4544
- Tue Oct 07, 2008 7:21 am
- Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- Topic: Webservices
- Replies: 8
- Views: 6595
Thanks a lot for your input. First time I was working on this stuff. Could you please help me out how to generate a header in XML output stage?? I was able to see the header option on the stage properties...and it's need to be a check box enabled ..then its asking for Load(client).. Could you please...
- Tue Oct 07, 2008 6:13 am
- Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- Topic: Webservices
- Replies: 8
- Views: 6595
- Tue Oct 07, 2008 4:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem with Web service Header when we use Datastge
- Replies: 1
- Views: 1713
Problem with Web service Header when we use Datastge
Hi All, We have a requirement to call the webservice to extract data using datastage. We are not able to generate header from the datastge which webservice can accept. But when we comment the header in the webservice I am able to extract the response from the service..... Any help...how to generate ...
- Tue Oct 07, 2008 4:50 am
- Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- Topic: Problem with the header part
- Replies: 5
- Views: 4544
Problem with the header part
Hi All, We have a requirement to call the webservice to extract data using datastage. We are not able to generate header from the datastge which webservice can accept. But when we comment the header in the webservice I am able to extract the response from the service..... Any help...how to generate ...
- Mon Oct 06, 2008 11:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Record count
- Replies: 5
- Views: 4142
- Mon Oct 06, 2008 10:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Record count
- Replies: 5
- Views: 4142
- Thu Oct 02, 2008 6:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Record count
- Replies: 5
- Views: 4142
Record count
Hi All,
I want to extract the record count of the data loaded into the target.
Some body can help me how to get the info by using a routine..some thing like as below.
pJobStatus = DSGetJobInfo (DSJ.ME,DSJ.JOBINTERIMSTATUS)
Could you pls help me.
Kind Regards
I want to extract the record count of the data loaded into the target.
Some body can help me how to get the info by using a routine..some thing like as below.
pJobStatus = DSGetJobInfo (DSJ.ME,DSJ.JOBINTERIMSTATUS)
Could you pls help me.
Kind Regards
- Mon Sep 15, 2008 11:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Default value problem
- Replies: 7
- Views: 2930
- Mon Sep 15, 2008 11:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Default value problem
- Replies: 7
- Views: 2930
- Mon Sep 15, 2008 10:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Default value problem
- Replies: 7
- Views: 2930
Hi, I need to check the file status using 'Wait for file activity' If the file is available ..I will process the logic. If the file is not available I nedd to insert a record into the error table by logging 'File is not available use previous day's data' for that I need to desing the job without sou...