Search found 151 matches
- Sat Nov 04, 2017 9:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sharepoint Access from DataStage
- Replies: 2
- Views: 3666
- Wed Aug 24, 2016 11:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML
- Replies: 5
- Views: 4242
Re:
xml
- Tue Aug 23, 2016 3:14 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML
- Replies: 5
- Views: 4242
- Thu Aug 18, 2016 9:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML
- Replies: 5
- Views: 4242
XML
xml
- Thu Jun 16, 2016 6:14 am
- Forum: IBM QualityStage
- Topic: AVI - administrativearea_qsav
- Replies: 3
- Views: 14703
AVI - administrativearea_qsav
Processing Type: Parse The administrativearea_qsav is inconsistent. The matchscore AdministrativeAreaMatchScore_QSAV for both are 100 But AdministrativeAreaStatus_QSAV is 6 for one and 8 for another. For both the accuracy code is U00-I44-P2-100 I gave one Colorado address and other Illinois address....
- Wed Feb 03, 2016 2:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Help Needed in calling DB2 Stored Procedure
- Replies: 8
- Views: 5259
I could able to achieve it. Just did trial and error methods and could able to get it after like 20 trials. Maybe I didn't got it in first place as my dsxchange account expired and I renewed just for this to see if I can get help immediately. bummer.. need to be more patience from next time before r...
- Wed Feb 03, 2016 12:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Help Needed in calling DB2 Stored Procedure
- Replies: 8
- Views: 5259
- Tue Feb 02, 2016 2:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Help Needed in calling DB2 Stored Procedure
- Replies: 8
- Views: 5259
The parameters do come from input. This Stored Procedure will be in middle of the job. Should I need to use Generate Procedure Call. So on the input tab, the columns should be only two (Parm, Input) - I/O Type Input On the output tab, should all the in and out type columns present. There are also tw...
- Mon Feb 01, 2016 5:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Help Needed in calling DB2 Stored Procedure
- Replies: 8
- Views: 5259
My job design would be Stored Procedure Stage ---------> DataSet I am using stored procedure transform type, import all the parameters and column mapping has to be done based on what you said, is that right? What about the default proccode and procmess fields created, should I map them to any fields...
- Mon Feb 01, 2016 4:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Help Needed in calling DB2 Stored Procedure
- Replies: 8
- Views: 5259
Help Needed in calling DB2 Stored Procedure
I have searched a lot and tried few trial and error methods with stored procedure stage but not able to be success in calling a DB2 Stored Procedure I have 12 parameters, one Input, One Input/Output and 10 Output types. Like; Column_Names|SQL_Type|I/O Type|Length PARM|Char|IN|23 MSG|Char|OUT|193 INP...
- Thu May 07, 2015 9:37 pm
- Forum: General
- Topic: Command Stage
- Replies: 1
- Views: 2116
Command Stage
Recently I had an issue with using Cat command in datastage which triggered me this question. Our datastage server is installed on Linux. We can use unix commands in command stage right? Does it work exactly as commands written on Unix box. We can only write one line commands, right? The below infor...
- Tue Jan 13, 2015 1:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Pivoting with Number of iterations
- Replies: 2
- Views: 2654
Thank you!
Found a similar post in DSxchange. Initially my search didn't pull any as subject is not appropriate for the other post.
If someone opens this message, here is the solution link.
Found a similar post in DSxchange. Initially my search didn't pull any as subject is not appropriate for the other post.
If someone opens this message, here is the solution link.
- Tue Jan 13, 2015 10:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Pivoting with Number of iterations
- Replies: 2
- Views: 2654
Pivoting with Number of iterations
Need help with code Source Data code address a1 xyz a1 abc b1 a23 b1 xmn b1 dkl c1 lmo a2 pqs a2 sfo d1 dnm d1 knm d1 gnm Required Output code address a1 xyz abc b1 a23 xmn dkl c1 lmo a2 pqs sfp d1 dnm knm gnm The number of times the code may repeat is unknown. So need to pivot based on the no. of t...
- Tue Jun 24, 2014 5:53 pm
- Forum: General
- Topic: Oracle Database Parameter Help
- Replies: 5
- Views: 3109
- Tue Jun 24, 2014 5:20 pm
- Forum: General
- Topic: Oracle Database Parameter Help
- Replies: 5
- Views: 3109