Search found 42189 matches

by chulett
Wed Jan 02, 2008 12:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Issue with Job sequencer
Replies: 7
Views: 1212

In the Sequence job, before the FTP step, check the size of the file and don't trigger the FTP if the file is empty. Or check in your FTP script.
by chulett
Wed Jan 02, 2008 11:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error with Xml jobs
Replies: 2
Views: 1088

Take the error to a SysAdmin.
by chulett
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.
by chulett
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...
by chulett
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

Pretty much what I said as well, just didn't use all the right words I guess. :wink:
by chulett
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

:? What 'steps' are you looking for? Something that's not in the official documentation?
by chulett
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

Error -12 is DSJE_BADNAME as in a job name is wrong. Without seeing your code, I'm assuming you are not using DSJ.ME for the 'current job' but rather an explicit name, and you've gotten it wrong.
by chulett
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

From what I recall, you'd need to use it in a BASIC Transformer, with all the caveats that brings to the table. You would pass $UserStatus as a job parameter to use it 'in the table'.
by chulett
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

From the Status view in the Director, Control-T or View/Filter Entries will show you all of the available options to filter the display of jobs there.
by chulett
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...
by chulett
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...
by chulett
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

Actually, you can resolve this. Search the forum for "has import error and no default value" - this has been asked and answered quite a number of times already.
by chulett
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...
by chulett
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

I would think it wouldn't matter, either could be just as 'fast'. The question would come down to what you were more comfortable with supporting or perhaps were 'required' to use. IMHO.
by chulett
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...