Search found 42189 matches
- Wed Jan 02, 2008 12:36 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Issue with Job sequencer
- Replies: 7
- Views: 1212
- Wed Jan 02, 2008 11:07 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error with Xml jobs
- Replies: 2
- Views: 1088
- Wed Jan 02, 2008 10:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Return Code from dsjob -run OR use dsjob -jobinfo
- Replies: 2
- Views: 1163
I stick with -jobstatus rather than interogate the job again after it finishes. Perhaps this recent post would help.
- Wed Jan 02, 2008 9:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: dsjob (status code)
- Replies: 21
- Views: 11245
Add -jobstatus to your command line so you get more information on the status of the job. Look in $DSHOME/include/dsapi.h for the error codes to check for: /* 'jobStatus' values... */ #define DSJS_RUNNING 0 /* Job running */ #define DSJS_RUNOK 1 /* Job finished a normal run with no warnings */ #defi...
- Wed Jan 02, 2008 8:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Regarding the performance of datastage and SQL Loader
- Replies: 12
- Views: 5934
- Wed Jan 02, 2008 8:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Steps for OracleEnterprizeStage
- Replies: 2
- Views: 770
- Wed Jan 02, 2008 8:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Getting Error-12
- Replies: 3
- Views: 1056
- Wed Jan 02, 2008 8:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DSSetUserStatus, unable to use in parallel
- Replies: 5
- Views: 5180
- Tue Jan 01, 2008 8:35 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Avoid Multiple Instances of Jobs in Director Log.
- Replies: 8
- Views: 2927
- Tue Jan 01, 2008 8:26 am
- Forum: General
- Topic: Job parameters
- Replies: 6
- Views: 1808
First suggestion would be to get a Premium membership, either yourself or via your company. You've been here for awhile, so you've seen the value of the information here. A little something I stole from Ray: For less than 30c per day you can purchase premium membership which, among other things, all...
- Mon Dec 31, 2007 2:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Exception handler & Wait For File
- Replies: 1
- Views: 1328
You should be able to add a link to the WFF stage to handle that 'failure' - your 'file not found' situation. For example, an 'OK' link for when the file arrives and an 'Otherwise' link / trigger that will fire when the stage times out. Then you can do something other than go to the Exception Handle...
- Mon Dec 31, 2007 12:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: null and duplicate
- Replies: 5
- Views: 1365
- Mon Dec 31, 2007 8:07 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Current Date
- Replies: 2
- Views: 817
The 'issue' with the system variables is their format - internal. Meaning, they typically need to be futzed with to get them into the external format that you need. I prefer the DSGetJobTimestamp macro since it delivers an ISO standard timestamp and the issue of efficiency is easily resolved by call...
- Mon Dec 31, 2007 7:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Regarding the performance of datastage and SQL Loader
- Replies: 12
- Views: 5934
- Mon Dec 31, 2007 7:36 am
- Forum: General
- Topic: Job parameters
- Replies: 6
- Views: 1808
Several ways... most would involve 'landing' the data in some fashion and then using a form of job control to pick the values up and pass them to the jobs that required them. Simplest would probably be putting the value in a flat file and then using 'cat' to capture the content. This can either be d...