DSXchange

/H is the Host aka Server name so do not include that again with the Project name.


No clue what /D is, perhaps it's new with 8.x.

XMS or XML? You've mentioned both, which is it?

Assuming you can trust what was posted, which seems to be hand-typed based on the misspelling of "returened".

Ah... like I said, been waaaay too long since I've done anything at the DOS level but now that you say it I do recall you need to check ERRORLEVEL in descending order.

No clue about your DB2 specifics, but understand that a job must abort for any rollback of uncommitted records to happen.

Why would anyone be specifically installing the old 1.0 version of the pack nowadays?

Excellent. Picking the correct 'key' aka repetition element is a little bit of a Black Art, it seems. Well, except for Ernie I imagine.

Why... write a routine, of course. Use that instead.

Full disclosure, peoples, full disclosure. Saves much chasing of the wild gooses.

I had a conversation with DBA, the Oracle Default Date format is MM/DD/YYYY and when using TO_DATE() in custom sql the data is populated into target table with data type DATE. Never worry about what the 'default date' (NLS_DATE) format is. When you use TO_DATE() all that matters is that your mask/p...

Stop exporting in XML format, stick with 'dsx'.

At least you stopped shouting.

I'm writing some custom Job Control and I need to be able to get the handle of a job's controller. I'm curious... why do you think you need that? What are you planning on doing with it? There's no handle you can access unless you establish one, so returning the name of the controlling job seems per...

Keep in mind the fact that, with that option, you'll never get a zero return code for a successful job run but instead it will return a 1. And a 2 if the job finishes with warnings, a 3 if aborted, etc etc. Not that that's a bad thing, just something that needed to be clarified. No clue, however, if...

just4geeks wrote:nls_read_delimited() - row 4, too many columns in record

This is not an error writing to a sequential file, this is an error reading one. Why not post a sample of your incoming data?