DSXchange

'Any number' up to 99999, from what I recall. If you still are unclear on the concept, have a chat with your friendly neighborhood DBA.

If in fact you are using the Sequential File stage, ditch it and replace it with, say, an External Source to fetch the filename and let the XML Input stage process it directly from the passed in URL/filepath.

Pivot is not the solution, because i need to write the records into the target output file Not sure what the relevance is here, one to the other. Job reads the first record from the file and first 3 columns write into the output file as first record and next 3 columns write into the same target fil...

If the file's location does not matter, then how would a new user be able to pick those variables if we do not reference dsenv in the new user's profile I just want to touch on this, reiterate it one more time. Individual users at the command line may need to source dsenv to work in the dssh shell ...

Might be a little overwhelming for someone at the 'very raw' state but nonetheless could help get them a leg up.

I don't believe this has changed for 8.x but dsenv is located in $DSHOME. And for DataStage use, you don't need to source it at all regardless of userid.

So... the entire sql statement is passed in as a parameter? That should be fine, just wanted that clarified. However, are you saying that even putting the sql statement in as-is (with any parameterization) gets you the same error? Have you posted the entire set of messages this error generates, incl...

Well, there you go - good job!

Please mark the post as Resolved.

In that case I'd suggest you don't even think about writing directly to a database from a routine or script. Simply write your desired output to a flat file and then use a normal job to load from the flat file to your database of choice.

Please clarify what "as a parameter" means here.

Ok, now you've got two changes you've allegedly made that are 'not getting reflected' when you import the dsx file. You are doing something fundamentally wrong and I don't see how we can instinctively know what you might be doing. Right or wrong. Since there doesn't seem to be anyone else at your si...

Don't you think it might help a teensy bit if you explained how you are attempting to 'connect to the web service client' rather than making people guess or assume?

The short answer is 'no'. As noted, they are non-nullable.

Not sure how as it really should be as simple as that. Is there anyone else where you work that can double-check for you? Another set of eyes and all that...

To the best of my knowledge, it is undocumented so whatever you can find here is what you get. Happy to be proven wrong, however.