Search found 42189 matches

by chulett
Tue Feb 24, 2009 6:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unix command to export DS job
Replies: 1
Views: 1999

Time for a new requirement, it seems, as there is no Server side export facility in your version.
by chulett
Tue Feb 24, 2009 6:33 am
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Web service invocation error -Service invocation exception:
Replies: 6
Views: 6897

Hard to say... did you capture the webservice metadata and load it properly into the WSTransformer stage?
by chulett
Tue Feb 24, 2009 6:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: dsjob command not working
Replies: 2
Views: 3967

Correct your syntax and let us know if it works more better. First suggestion, ditch the "sh" and just execute "dsjob": data/IBM/InformationServer/Server/DSEngine/bin/dsjob Then make sure the rest are in the proper order - for example, the project and job names must be the last t...
by chulett
Tue Feb 24, 2009 6:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Set Project to Compile before execute
Replies: 37
Views: 9234

Yup, I know just what little bit of advice you are referring to and also thought it was amusing that they didn't really seem to follow it. :wink:

[wanders off, waiting to rue the day, still hearing that maniacal laughter ringing in his ears]
by chulett
Mon Feb 23, 2009 10:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Set Project to Compile before execute
Replies: 37
Views: 9234

Interesting. I've basically adopted the same code that the 'Add Job' button or a Sequence job will generate for a Job Activity: hJob1 = DSAttachJob(<JobName>, DSJ.<errorlevel>) If Not(hJob1) Then <Error handling here> End Else hJob1 = DSPrepare(hJob1) <etc> End Rather than explicitly testing the val...
by chulett
Mon Feb 23, 2009 4:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Set Project to Compile before execute
Replies: 37
Views: 9234

You need to put a little effort into figuring this out. Add some calls to DSLogInfo() after each step. The second step will fail if the first is not successful and you need to check to see that the handle returned is valid before proceeding to the next step. Don't write code that lives in fantasy la...
by chulett
Mon Feb 23, 2009 2:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Set Project to Compile before execute
Replies: 37
Views: 9234

:? Then your job name doesn't exist.
by chulett
Mon Feb 23, 2009 2:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Set Project to Compile before execute
Replies: 37
Views: 9234

Which statement generated the error? I'd hazard a guess that your attach failed.
by chulett
Mon Feb 23, 2009 2:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting Job Elapsed time for all datastage jobs
Replies: 2
Views: 3641

dsjob -ljobs

Then use the output from that to drive a loop where you do like you are doing now, one at a time.
by chulett
Mon Feb 23, 2009 11:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: cursor lookup
Replies: 5
Views: 1390

That would be where the UV stage comes in. You can use one to access a hashed file as long as the hashed file was created in an account or you manually create a VOC record for it. After that, it's a matter of creating the hashed files with enough keys to ensure all records get loaded and then using ...
by chulett
Mon Feb 23, 2009 11:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to retrive the data from CLOB Column through datastage
Replies: 11
Views: 7569

You really need to start your own post for this. :?
by chulett
Mon Feb 23, 2009 10:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Set Project to Compile before execute
Replies: 37
Views: 9234

Perhaps something specific to that plug-in, I don't recall ever having a time where a reset didn't work and I had to fall back on a recompile. For whatever that is worth.
by chulett
Mon Feb 23, 2009 10:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Is dscc.exe reliable?
Replies: 16
Views: 5887

Phil "Judge Dredd" Hibbs. :wink:

Good catch.
by chulett
Mon Feb 23, 2009 10:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: cursor lookup
Replies: 5
Views: 1390

Unless something has changed in 8.x the only Server stages that support multiple row returns from reference lookups are the ODBC and UV stages.
by chulett
Mon Feb 23, 2009 9:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ORA-01410: invalid ROWID Error
Replies: 10
Views: 11049

No, there is a specific ORA error for that - the dreaded 'snapshot too old'.