DSXchange

Better late than never.

Actually... yes.

Not sure how common 'common sense' is any more, Kim.

All great advice. From a reading standpoint, I highly recommend this IBM Redbook: InfoSphere DataStage Parallel Framework Standard Practices.

Clarify something for us... this third job that fails, does it run ok if you run it outside of the sequence?

Doesn't change my answer. Did you carefully check both logs?

Meaning, it runs fine when you start it but when you use a Job Activity stage in a Sequence job to launch it, it fails? And the connection information your stored procedure uses are parameterized? The obvious first thing to check is to verify that your parameters and values are A) correct in the Seq...

Thank you for posting this.

I'd probably end up writting a routine so that I could use DSExecute() to run sqlplus and have full function access to parse out what I wanted from the returned values afterwards.

Glad you got it sorted out!

How are you calling sqlplus? Have you tried the "-s" command line option to run in 'silent' mode? I know I've done this in the past but I don't recall the gory details, I'll see if I can turn anything up on my PC. Another option: since everything is returned in a dynamic array, you can tes...

Allegedly, yes. I mean, that is functionality that the MKS Toolkit brings to the table.

I would suggest talking to your DBA. Here is an explanation of that error.

The port is optional (which is why it is in square brackets) and generally not needed. And the hostname is the name of the remote server your file resides on, the one where you say you can cat. If you're really not sure what that name is, run hostname from the UNIX command line.

Ray's illustrated technique is akin to a "Dynamic Lookup" in Informatica, if that helps or means anything to anyone playing along from home.

Did you try searching yet? An exact search here for "Non-pipe (or non-virtual data set) with .v in its name" returned 34 matches...