Search found 42189 matches

by chulett
Thu Aug 18, 2011 2:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sort Stage clarification
Replies: 7
Views: 3357

Hopefully there are no nulls in any of the values you are concatenating together...
by chulett
Thu Aug 18, 2011 1:23 pm
Forum: General
Topic: Starting multiple jobs using StartLoop EndLoop in a Sequence
Replies: 12
Views: 3425

The Job Activity stage runs a job and then waits for it to complete, that functionality cannot be changed. You'd have to "roll your own", say something like a routine does all of the same steps except the DSWaitForJob() call or a script that leverages dsjob without either of the wait optio...
by chulett
Thu Aug 18, 2011 1:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Specified Driver not loaded
Replies: 4
Views: 1476

Look at the dsenv file on your old server and make any corresponding changes on the new server. I would imagine your "shared library" path is not set correctly.
by chulett
Thu Aug 18, 2011 9:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: The OCI function OCIStmtFetch returned status -1
Replies: 6
Views: 4340

Have you reported this to your official support provider?
by chulett
Thu Aug 18, 2011 8:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error message :Failure during execution of operator logi
Replies: 5
Views: 2892

Is that the complete error message? If not, can you post it unedited plus any other associated errors/warnings you are getting.
by chulett
Thu Aug 18, 2011 7:29 am
Forum: General
Topic: Retrive a vlaue from one job and use that in a different job
Replies: 2
Views: 1387

Put the value in a flat file. In a Sequence job, read the file for that value and pass it as a job parameter to the job that needs it. Use it in your where clause enclosed in hash tags. Or use a Server job for the first task, save the value in USERSTATUS and then use that mechanism to pass the value...
by chulett
Thu Aug 18, 2011 6:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Issue with Server Job validation
Replies: 7
Views: 2598

Re: Issue with Server Job validation

Server Jobs always have this disadvange , it will never point out to a specific error. Try deleting the transformer and introduce a new transformer. I beg to differ on general principal, never mind the fact that they posted a very specific error. If you search the forum for "Fault type is 4&qu...
by chulett
Thu Aug 18, 2011 6:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: The OCI function OCIStmtFetch returned status -1
Replies: 6
Views: 4340

Really? That doesn't make much sense to me but I guess we'll see! :wink:
by chulett
Wed Aug 17, 2011 11:01 pm
Forum: General
Topic: Automating the export and import
Replies: 9
Views: 4142

Yes Craig!! The version controller is only accessible by the admin. I am planning to do this and give to developers so that they can import themselves. Is this an approved activity? I would counsel that this may not be the best idea in the world. Anywhere I've been had a someone (or a small group o...
by chulett
Wed Aug 17, 2011 10:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: The OCI function OCIStmtFetch returned status -1
Replies: 6
Views: 4340

There are many causes for that 3113 error as noted out in the wild, including here. If you can't get any joy from your DBAs or there's no sign of "defunct processes" then I'd suggest you contact your official support provider. Could be a bug in the stage or perhaps even in the Oracle clien...
by chulett
Wed Aug 17, 2011 10:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: index constraint
Replies: 7
Views: 2916

For any kind of "starts with" check, all you need to do is substring.

Code: Select all

to_transf._ID[1,6] = "___Req"
by chulett
Wed Aug 17, 2011 10:16 pm
Forum: General
Topic: Automating the export and import
Replies: 9
Views: 4142

Any particular reason you're not using Version Control?
by chulett
Wed Aug 17, 2011 10:03 pm
Forum: General
Topic: Exporting whole project into single file
Replies: 32
Views: 10061

Maybe... but a definite issue back in the 7.x version.
by chulett
Wed Aug 17, 2011 4:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cannot open file RT_BP6487.O
Replies: 14
Views: 4036

Hmmm... so the VOC records did exist. Not sure what the next step is, time to wait for El Queso Grande it would seem. :wink:
by chulett
Wed Aug 17, 2011 4:13 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Cannot open file RT_BP6487.O
Replies: 14
Views: 4036

I would think you should be able to create it manually (all you'll have is an empty directory) and then do the two VOC steps Ray mentioned. You could then export the job from Production and import it back into this project, the "fix" will allow this 6487 version of the job to be successful...