Search found 41 matches
- Fri Aug 07, 2015 12:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: RFC Connection drop with error CALL_FUNCTION_OPEN_ERROR
- Replies: 1
- Views: 2518
RFC Connection drop with error CALL_FUNCTION_OPEN_ERROR
Some of the jobs doing ABAP extracts from DataStage have a dump in SAP in ST22. This is during the extract from SAP. So the job is running from 3.08AM and there are 18 mil rows to be pulled. The dump says it has come across a communication error at 5.14. The exact error is Error when opening an RFC ...
- Thu Sep 27, 2012 12:24 pm
- Forum: General
- Topic: File merge
- Replies: 4
- Views: 2307
File merge
Can we do any merge like this automatically? All the Audit.txt into a single Audit.txt? I need to remove the headers and trailers in each file too. This is now being done manually and want to implement an automated way either using any shell script or Perl or Nant as we use Nant. The files are appea...
- Wed Aug 22, 2012 7:17 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Pivot dynamic columns to rows
- Replies: 5
- Views: 3532
- Tue Aug 21, 2012 12:36 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Pivot dynamic columns to rows
- Replies: 5
- Views: 3532
Pivot dynamic columns to rows
I have a unique problem. Securities data looks like this: Credit Family BB Internal PP or CUSIP 1166 AVENUE OF THE AMERICAS COMMERICAL MTG TRUST 682439AC8 1166 AVENUE OF THE AMERICAS COMMERICAL MTG TRUST 682439AE4 1166 AVENUE OF THE AMERICAS COMMERICAL MTG TRUST 682439AJ3 1166 AVENUE OF THE AMERICAS...
- Fri May 18, 2012 6:16 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: UtilityHashLookup fails when the hash path is different
- Replies: 3
- Views: 2404
- Wed May 16, 2012 12:11 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: UtilityHashLookup fails when the hash path is different
- Replies: 3
- Views: 2404
UtilityHashLookup fails when the hash path is different
I have been having issues with the Routine UtilityHashLookup in 8.5 server jobs. When the Hash files are created under /data/<Project_Name>/hash directory, the routine is not find the hash file when testing the UtilityHashLookup. But when the path is changed to /Projects/<Project_Name> then it is wo...
- Fri Apr 20, 2012 10:28 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: MQ stage error libmqm.so
- Replies: 1
- Views: 2118
MQ stage error libmqm.so
We are in the process of migration from 7.5 to 8.5. Some of the jobs are calling a MQ Sequence in 7.5. I am able to compile them after migration to 8.5 but at run time getting the fatal error: ds_loadlibrary: error in dlopen of mqs.so - libmqm.so: cannot open shared object file: No such file or dire...
- Fri Feb 17, 2012 7:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: MODIFY OPERATOR DROP
- Replies: 5
- Views: 2215
- Thu Feb 16, 2012 4:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: MODIFY OPERATOR DROP
- Replies: 5
- Views: 2215
MODIFY OPERATOR DROP
Is there a shortcut to DROP multiple columns.
Like if we want to drop column number 100 to 120 from the input link. Is there some notation we can do for that in Modify Operator?
Like if we want to drop column number 100 to 120 from the input link. Is there some notation we can do for that in Modify Operator?
- Thu Feb 16, 2012 3:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SQL*Loader truncation error
- Replies: 0
- Views: 1240
SQL*Loader truncation error
I am trying to load to a Oracle table which has 150 columns and the control file for SQL loader is incomplete. I am seeing posts that refer to a patch but could not find any. So can anyone please post the link to the fixpatch or Patch number for this error? SQL*Loader-350: Syntax error at line 128. ...
- Thu Feb 09, 2012 8:21 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup value 0
- Replies: 9
- Views: 6499
- Thu Feb 09, 2012 8:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup value 0
- Replies: 9
- Views: 6499
- Wed Feb 08, 2012 4:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup value 0
- Replies: 9
- Views: 6499
- Wed Feb 08, 2012 4:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup value 0
- Replies: 9
- Views: 6499
- Wed Feb 08, 2012 3:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup value 0
- Replies: 9
- Views: 6499
Lookup value 0
What does a resulting value of 0 mean when we do a lookup? I have an Underwriter_id(char 10) in Source. User_id(carchar 10) in lookup table. The data types are different. But the lookup is failing. But if I do it from the database then the match is there. So if the lookup action is drop then the rec...