Search found 17 matches
- Thu Mar 12, 2015 10:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Required a Generic Job to load 100 tables
- Replies: 2
- Views: 1774
Required a Generic Job to load 100 tables
Hi All, There is a requirement in my Project, we have source Oracle and Target SQL server. In both tables metadata same. Say in Oracle table 1 having columns Table 1 ------------------- A NUM 10 B Varchar 20 ------------------ Table 2 -------------- A Num 10 B Varchar 20 C Char 10 --------------- an...
- Mon Jan 05, 2015 12:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Load MS Access DataBase using ODBC connecter
- Replies: 1
- Views: 1619
Load MS Access DataBase using ODBC connecter
Please let us know how to configure MS Access DataBase using ODBC connecter. is it possible to connect MS Acces using ODBC?
This is a new requirment in my project.
This is a new requirment in my project.
- Mon Apr 22, 2013 3:44 am
- Forum: General
- Topic: Move Files from Host server source to Host server Target
- Replies: 2
- Views: 2000
Move Files from Host server source to Host server Target
Hi All, Is it possbile to move files from Host server source to Host server target in datastage execute command stage or before or after subroutine. i am trying in my project but no luck. below is the code. mv source server path/*.txt Target server path | sftp -o StrictHostKeyChecking=no User@server...
- Thu Feb 21, 2013 12:26 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Phantom Error 28984
- Replies: 1
- Views: 1675
Phantom Error 28984
Hi All, receivng below error when running from ABAP stage --> Tans -->FTP(stage). DataStage Job 1 Phantom 28984 Program "JOB.141697444.DT.1531745292.TRANS1": Line 134, Exponentiation overflow, zero returned. Program "JOB.141697444.DT.1531745292.TRANS1": Line 135, Exponentiation o...
- Thu Feb 14, 2013 1:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: compare two records in DataStage
- Replies: 4
- Views: 5164
compare two records in DataStage
Hi All, Is it possible to compare two records in DataStage, then decide what value to add to a new field on each record? For example, if Record 1 has an 'A' and Record 2 has a 'B' then, add a new field with 'Z' for Record 1 and 'Y' for Record 2. But, if Record 1 has an 'A' and Record 2 has a 'C', th...
- Wed Feb 13, 2013 11:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ABAP Stage error
- Replies: 2
- Views: 2581
- Wed Feb 13, 2013 11:56 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: 'row_to_external()' failed issue
- Replies: 0
- Views: 1509
'row_to_external()' failed issue
Hi All, My job is like ABAP stage --->Trans'r--->FTP stage when running this part running fine in Dev, but when iam running in QA got following error. "IntransitShpmntSKU..XIntransitShpmntSKU: Internal error: function 'row_to_external()' failed" Any one have any idea please share. Thanks
- Tue Feb 12, 2013 5:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ABAP Stage error
- Replies: 2
- Views: 2581
ABAP Stage error
Hi All, In my project, i am extracting records from SAP- with ABAP stage. when i am running job failed with error as below. Please help on this error to resolve. APT_CombinedOperatorController(1),0: Fatal Error: Fatal: ABAP_E_00007`:`Error while retrieving link property ABAP_E_00598`:`DSSAP Logical ...
- Thu Jan 17, 2013 12:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Funnel Operation
- Replies: 2
- Views: 2488
Funnel Operation
Hi All, I have a requirement like, haveing three operations 10,20,30(3 inputs) i want funnel and store into target. o/p is row1: 10,material number,-,-,-.......... row2: 20,material number,-,-,-............ and 30 operation will include when certain Material Number will match and o/p will be otherwi...
- Tue Nov 27, 2012 11:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ABAP stage CPI-C error
- Replies: 4
- Views: 2753
ABAP stage CPI-C error
Not yet... not sure whats going wrong in QA.. other jobs of same format are running fine in QA....
- Mon Nov 26, 2012 1:17 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ABAP stage CPI-C error
- Replies: 4
- Views: 2753
ABAP stage CPI-C error
Thanks..
DS is 8.1 and parallel . server is in UNIX.
DS is 8.1 and parallel . server is in UNIX.
- Mon Nov 26, 2012 9:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ABAP stage CPI-C error
- Replies: 4
- Views: 2753
ABAP stage CPI-C error
Hi All, For me also getting this issue but when iam running in Dev its working, but in QA giving below error, Please suggest... ABAPExtr_R3_MAST,0: Warning: ECC6_Extract_MAST_Dset.ABAPExtr_R3_MAST: ABAP_W_00220`:`CPI-C Login Error ABAPExtr_R3_MAST,0: Info: ECC6_Extract_MAST_Dset.ABAPExtr_R3_MAST: AB...
- Wed Nov 07, 2012 8:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to print below requirement
- Replies: 14
- Views: 7286
- Wed Nov 07, 2012 7:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to print below requirement
- Replies: 14
- Views: 7286
- Wed Nov 07, 2012 3:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to print below requirement
- Replies: 14
- Views: 7286