Search found 66 matches
- Thu Nov 10, 2011 6:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: crazy requirement in DataStage
- Replies: 8
- Views: 5111
hello all sorry My Input Data in table only with 4 fields as below : ID, ParentID,ChildID,NAME 111, 100, 200,MDC 222, 200, 300, AAA---> 333, 300, 400,ABC 444, 400, 500,BCD Basically AAA is one special value and need to get always AAA id (it may differ for other set of records). Ex: If record BCD got...
- Wed Nov 09, 2011 8:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: crazy requirement in DataStage
- Replies: 8
- Views: 5111
- Wed Nov 09, 2011 7:28 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: crazy requirement in DataStage
- Replies: 8
- Views: 5111
crazy requirement in DataStage
Hi All Here is the crazy requirement, just let me know your inputs Input Data: 111, 100, 200,MDC 222, 200, 300, AAA---> 333, 300, 400,ABC 444, 400, 500,BCD Ex: record BCD got changed to DCB then i have to get the 222 from navigating 500 -> 400-> 300 -> 200 ->222 Note: No SQL, everything have to do i...
- Wed Mar 02, 2011 6:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Parse Issue
- Replies: 6
- Views: 5157
- Wed Mar 02, 2011 6:14 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Parse Issue
- Replies: 6
- Views: 5157
- Tue Mar 01, 2011 7:00 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML Parse Issue
- Replies: 6
- Views: 5157
XML Parse Issue
Hello all The below example explains the issue XML Structure like as below ns0:Element1 ns1:Element2< Elements3,4,5> ns1;Element2<Elements3,4,5> Issues : 1)when we import in Datastage to XML input stage will get ??? for ns1 in the xpaths. 2) when we run it we wont get the values for Elements3,4,5 3)...
- Fri Oct 08, 2010 12:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored procedure guide
- Replies: 2
- Views: 2845
- Wed Oct 06, 2010 4:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage Login issue
- Replies: 6
- Views: 3894
- Tue Oct 05, 2010 11:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage Login issue
- Replies: 6
- Views: 3894
Datastage Login issue
When I try to login Datastage designer , gettting following error. But I can select the project from drop down list. And also I can login Unix server where datastage has installed. Error as below. Datastage Repository Interface Record EC784FEC-515E-4E28-874C-8C021FAECAE2-TCWDIWTS06P:5890350 ON FILE ...
- Thu Sep 30, 2010 8:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to Call DB2 Stored Procedure in 7.5.x2
- Replies: 5
- Views: 3934
HI Ray Thanks a lot for your resp But I used the call stmt also but it doesn't work for me getting the error msg saying that Invalid no of argumetns even i have given the exact number of parameters. BTW how to give in and out parameter in ODBC stage. when we call SP using the stored procedure option...
- Wed Sep 29, 2010 2:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to Call DB2 Stored Procedure in 7.5.x2
- Replies: 5
- Views: 3934
- Wed Sep 29, 2010 2:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to Call DB2 Stored Procedure in 7.5.x2
- Replies: 5
- Views: 3934
How to Call DB2 Stored Procedure in 7.5.x2
Hi DS Guys
I want to call the DB2 stored procedure in Ver 7.5x2 with input and output parameters.
The SP stage is there but its only for Oracle.So any other stages can use to call DB2 SP.
Adv thanks for your Information...
Thanks
SP
I want to call the DB2 stored procedure in Ver 7.5x2 with input and output parameters.
The SP stage is there but its only for Oracle.So any other stages can use to call DB2 SP.
Adv thanks for your Information...
Thanks
SP
- Thu Jul 29, 2010 3:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Getting the source file & table count
- Replies: 8
- Views: 4715
Re: Getting the source file & table count
HI Kris thanks, But if my source is table then i need to call 1 script in that i need to connect db then i will get some record count as the output command along with the db connection information.It does't give the only number to output command. Basically i need to use the output of the script in ...
- Thu Jul 29, 2010 2:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Getting the source file & table count
- Replies: 8
- Views: 4715
Re: Getting the source file & table count
HI Kris thanks, But if my source is table then i need to call 1 script in that i need to connect db then i will get some record count as the output command along with the db connection information.It does't give the only number to output command. Hope its clear.. Thanks Hello Kris But just 1 questio...
- Thu Jul 29, 2010 1:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Getting the source file & table count
- Replies: 8
- Views: 4715
Re: Getting the source file & table count
Hello Kris Thanks a lot for your info But just 1 question when we execute the shell script from the Execute command stage we will get the connection information also in the command output how to remove that please...I want only count in the output command. If the source is a file you can use somethi...