DSXchange

Is your Array size and commit set to 1? Strange behaviour indeed - the reject link should be receiving rows. Are you certain that is correctly specified? Can you force a different type of error to see if that works, i.e. put an invalid date into a date field?

No stage variables required for what you wish to do.

Since DS_JOBOBJECTS is corrupted, you don't need exclusive access. In the following, everything in red is what I entered: . $ dssh DataStage Command Language 8.0 Licensed Materials - Property of IBM (c) Copyright IBM Corp. 1997, 2006 All Rights Reserved. DSEngine logged on: Monday, June 15, 2009 14:...

If you google "sqlplus with no password" you should get some hits on how this might be done. Most likely the quickest is to use a very restricted user and password that can be made public, i.e. User "restricted", password "restricted" that can only do those queries that...

I would stick with the IBM recommendation and then ensure that your Oracle DDL specifies character lengths in characters, not in bytes, i.e. "VarChar(32 Char)" instead of "VarChar(32 Byte)" or by specifying "alter {session/system} set nls_length_semantics=char;"

Since you aren't doing wave processing you can ignore the warning; but the failure message(s) in the logs do contain additional information on the actual cause, could you post the complete and unabridged error messages please?

Can you work backwards and see why those records aren't being written (try doing a manual SQL insert with the data). Why are the being rejected by the database - i.e. constraint integrity or some other reason. Once that cause is known we might be able to see if this is a bug.

Please post the full and complete error message, that also contains the text describing why the stage aborted. Without that we would just be guessing.

If you have a string with the value of "1,2,3,4,5" then the function "FIELD(In.String,',',2) will return the 2nd field as delimited by commas.

This has often been done in Server jobs and is, once you understand the method, quite easy to do. You would need to add a transform stage that outputs to a sequential file (defined as a named pipe) and a link out of the named pipe to the rest of the job. The transform stage outputs the 3 columns to ...

If you re-import the .dsx file into another project, can you then do a dscmdexport on it? If no, then you have a reproduceable test case to submit to IBM support (or to whomever you use for support). If yes, then something is wrong with the job's internals and you might as well import the .dsx file ...

I just re-read your initial post and see that I misunderstood what you want to do. There are some DataStage functions that are available in the API, but those string and other functions you alluded to are not available. The TRIM() function is identical in scope in PX, but the "FIELD()" fun...

Can you do an export of that job from the client? Perhaps it is not the command line export that is broken, but the job itself.

From UNIX, make 2 backup copies of your DS_JOBOBJECTS file. One backup is so that you have an unchanged backup, the second is to experiment with. Assume you call your copy "DSPLAY" at UNIX. From the TCL prompt, enter "ED VOC DSPLAY", then in the editor "I" to enter inse...

Looks like a null pointer somewhere. Does it happen only with this job?