RCP is disables in our environment , I was checking if there was any other workaround .
Thanks
Search found 70 matches
- Wed May 09, 2012 2:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Rejects from DB2 Connector
- Replies: 4
- Views: 4494
- Tue May 08, 2012 3:13 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Rejects from DB2 Connector
- Replies: 4
- Views: 4494
Re: Rejects from DB2 Connector
There is no reject option in DB2 connector , you have to select the reject link and in the column definition all it shows are the error codes no input column , so the rejected records only have the error code but not the rejected data . Putting the reject link through transform doesnt make any diffe...
- Tue May 08, 2012 8:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Rejects from DB2 Connector
- Replies: 4
- Views: 4494
Rejects from DB2 Connector
I am trying to capture the records rejected while loading a db2 table due to a unique key violation error . The DB2 Connector stage is rejecting the records when array size and record size are set to 1, but the rejected records only has error_code and error_text , it doesn't show the rejected record...
- Fri Mar 02, 2012 5:45 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Decimal formatting
- Replies: 1
- Views: 2316
Decimal formatting
Hello , I have a requirement to convert the decimals values (generated as an output of aggregator ) to standarformat of xx.xx. Example : .32 -> 00.32 -1.5 -> -01.50 8 -> 00.80 I can do this in sql query , but as soon as the data gets processed by datastage aggregator , the decimal formatting just va...
- Tue Jan 04, 2011 11:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: create multiple files in parallel based on values
- Replies: 6
- Views: 4329
Re: Create multiple files parallel by using dynamic values
Create a work table, load the list of values there, join with your table. ... Could you please elaborate the logic. Which part is unclear? Your p ... Not able to view the whole message. How do I join to work table and populate files which is not clear to me. Example: My list file has 50 dept. numbe...
- Tue Jan 04, 2011 10:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: create multiple files in parallel based on values
- Replies: 6
- Views: 4329
create multiple files in parallel based on values
Could you please explain me how to run the multiple instance sequence for the dynamic list of values.srinivas.g wrote:Or you can use Allow multiple instance option
Thanks
- Tue Jan 04, 2011 10:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: create multiple files in parallel based on values
- Replies: 6
- Views: 4329
Create multiple files parallel by using dynamic values
Could you please elaborate the logic.chulett wrote:Create a work table, load the list of values there, join with your table. ...
Thanks.
- Mon Jan 03, 2011 9:57 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: create multiple files in parallel based on values
- Replies: 6
- Views: 4329
create multiple files in parallel based on values
Need an approach to implement multiple files creation based on values which are dynamic. The value is used in SELECT clause of a query. Have to create all the files parallel. Used loop activity stage which is consuming more time because it takes one value at a time and runs the query. Example: SELEC...
- Thu Dec 10, 2009 5:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: after job subroutine to reset a failed independent job
- Replies: 10
- Views: 7132
- Fri Dec 04, 2009 12:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: after job subroutine to reset a failed independent job
- Replies: 10
- Views: 7132
There are some 15-20 SAP BW Pack Load jobs which are triggered by SAP developers manually. For these jobs, if aborted, the subroutine should reset the jobs for the next run instead of SAP developers doing it. For this requirement, need to write a subroutine and call it in before/after job subroutine...
- Fri Dec 04, 2009 7:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: after job subroutine to reset a failed independent job
- Replies: 10
- Views: 7132
- Thu Dec 03, 2009 2:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: after job subroutine to reset a failed independent job
- Replies: 10
- Views: 7132
after job subroutine to reset a failed independent job
Hi, Need help in resolving after job subroutine to reset a failed individual job. Requirement is not to use sequencers. Calling this routine in after job subroutine. But job aborts and doesn't reset itself. In the director state of the job is still running. $INCLUDE DSINCLUDE DSJ_XFUNCS.H $INCLUDE D...
- Wed Aug 19, 2009 4:18 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Multiinstance subbatch calling multiinstance job
- Replies: 1
- Views: 2162
Multiinstance subbatch calling multiinstance job
Hi I am trying to call a multi instance job with the same invocation Id used to run the calling multi instance sub - batch job. while calling the job from sub batch I tried to use the code hJob10 = DSAttachJob("EOA1010LdIncidentTable.DSJobInvocationId", DSJ.ERRFATAL) If NOT(hJob10) Then Ca...
- Tue Dec 30, 2008 4:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Can DataStage Operator log into designer
- Replies: 3
- Views: 2121
Can DataStage Operator log into designer
Can DataStage operator log onto DataStage designer.
- Sat Dec 20, 2008 1:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: job aborting without errors
- Replies: 3
- Views: 2611