Search found 66 matches
- Thu Apr 19, 2012 9:53 am
- Forum: General
- Topic: special characters in column names in Oracle Enterprise
- Replies: 0
- Views: 1619
special characters in column names in Oracle Enterprise
I am trying to use special characters for column names in Oracle Enterprise stage, and I get errors. I have set DS_ENABLE_RESERVED_CHAR_CONVERT to true using administrator, and have imported the metadata for a table, but I don't see the internal column names. I believe _036_ is substituted for $. In...
- Sun Oct 17, 2010 1:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Proc Stage
- Replies: 10
- Views: 6002
OK, here's the solution that I came up with. In the parallel job described earlier, instead of writing to a peek stage, the return code (-1 for failure, 0 for success) is written to a text file only if the return code is less than 0. In a sequencer the text file is interrogated for word count using ...
- Sat Oct 16, 2010 10:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Proc Stage
- Replies: 10
- Views: 6002
- Sat Oct 16, 2010 10:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Proc Stage
- Replies: 10
- Views: 6002
I created an output link from the stppx stage which gave me the ability to capture the return code from the stored procedure, (set to -1 in the sp if it fails). I can now do one of 2 things. I can configure a transform having the output link of the sttpx stage as its input, and an output link to a p...
- Fri Oct 15, 2010 2:28 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Proc Stage
- Replies: 10
- Views: 6002
- Fri Oct 15, 2010 2:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Proc Stage
- Replies: 10
- Views: 6002
- Fri Oct 15, 2010 2:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Proc Stage
- Replies: 10
- Views: 6002
- Wed Oct 13, 2010 9:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Proc Stage
- Replies: 10
- Views: 6002
- Tue Oct 12, 2010 3:04 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Stored Proc Stage
- Replies: 10
- Views: 6002
Stored Proc Stage
Hello,
I am executing a stored procedure using a stored proc stage. The stored procedure fails (for example while inserting a duplicate primary key value), yet the DataStage job finishes with an OK status. How can I make the DS job finish with an abort status?
Thanks
AL
I am executing a stored procedure using a stored proc stage. The stored procedure fails (for example while inserting a duplicate primary key value), yet the DataStage job finishes with an OK status. How can I make the DS job finish with an abort status?
Thanks
AL
- Fri Dec 04, 2009 3:27 pm
- Forum: General
- Topic: User inserted sort does not fulfill sort requirements
- Replies: 1
- Views: 7712
User inserted sort does not fulfill sort requirements
I have a sort stage in a job to sort incoming data by column A, then B and then C. The receiving stage is a remove duplicates stage where the job picks up the last row. It removes all duplicates with the same values of A and B, except the last row, which happens to be the last value of C within the ...
- Mon Nov 02, 2009 5:24 pm
- Forum: General
- Topic: Mapping failed to find or create the target instance
- Replies: 3
- Views: 2972
Mapping failed to find or create the target instance
Does any one know what this error means, or what may have caused it? This occurred while importing dsx objects frrom one environement to another. Line 126560: Mapping failed to find or create the target instance: JobDefn -> DSJobDef (EObject: c2e76d84.43058877.61935f.123c4e5f08b.1129f80.873f0, JobDe...
- Tue Oct 27, 2009 11:57 am
- Forum: General
- Topic: Passing job parm to body of notification activity
- Replies: 2
- Views: 1688
- Tue Oct 27, 2009 11:53 am
- Forum: General
- Topic: Passing job parm to body of notification activity
- Replies: 2
- Views: 1688
Passing job parm to body of notification activity
Hello
Can any one tell me how one can pass a job parmater to the body of an notification activity? It works in the "Subject"
Thanks
Anil
Can any one tell me how one can pass a job parmater to the body of an notification activity? It works in the "Subject"
Thanks
Anil
- Mon Oct 26, 2009 7:43 am
- Forum: General
- Topic: Lookup warning-Ignoring duplicate entry at table record
- Replies: 7
- Views: 36417
- Mon Oct 26, 2009 6:55 am
- Forum: General
- Topic: Lookup warning-Ignoring duplicate entry at table record
- Replies: 7
- Views: 36417
Thanks for the response. As I mentioned, I know what the message means, and what I need to do to fix it. The question was, in case there are more than one row returned for lookup, as it did here, does DS ignore the lookup value, or it looks up the value from the first available reference row, and ig...