DSXchange

Set the query type to 'User-defined SQL query file' and then put the full path to the file where the sql itself would normally be.

Sometimes the 'reinstall' need to be complete. As in the old installation needs to be nuked. If you want to try that, it woudl involve these steps: 1) Uninstall the client. 2) Delete any leftover 'Ascential' directories. 3) Use regedit to remove any leftover 'Ascential' keywords. 4) Reboot. 5) Reins...

While I'm sure there is a limit, I sincerely doubt you will run afoul of it.

Yah, as noted there are many ways to accomplish this and they've all been discussed here. Ad Nauseum. Searching the forums for things like ETLStats, any of the 'DSGetLog' functions or 'dsjob' will turn them up. Then you need to decide on your preferred methodology - via DataStage jobs and/or custom ...

That would be the first thing I'd try - a reinstallation of the client.

Typically, long filenames with spaces in them need to be quoted so the spaces don't confuse things. Is that not another option here?

Thank goodness for still having 8.3 under the covers, though.

I was wondering what the answer would be to this. I for one have never heard of a 'virtual' hashed file but doesn't mean much so waited for an official Wurlod answer to see. Distributed hashed files, however, are a Known Thing and something I've experimented with a number of years ago after seeing a...

Wow... now I'm being compared to Rube Goldberg. Cool - I love that guy! :D Moreover the OP has not mentioned that the data to be processed is mutually exclusive. That was the impression I got from this part of his requirements: Now based on each record column value, I need to call different jobs say...

For an Oracle DATE field and generated sql, the date format the sql will be expecting is YYYY-MM-DD HH24:MI:SS. So you would first use IConv with a mask to match the input format to get the date into internal format, and then OConv with a date mask to get you what you see here, matching the TO_DATE(...

Multiple minutes? Yah, or so I'm told. Getting useful information from them can be like pulling teeth, so much of the time I... punt. Usually I get 'requests are timing out' and they send me examples of the 'problem XML', which I proceed to run standalone without issue. As to the actual volumes, ori...

Post the complete error message.

Thanks for the information.

Oh, and in case anyone's interested, had to look that one up.

Spit the dummy.

Hmmm... here I thought we were talking about zoned decimal, but the substitutions are wrong for that. Never mind.

Land them. A routine can then build the delimited list that the UserVariables and/or Start Loop stages are looking for. Perhaps by something as simple as cat'ing them to standard out and capturing that output. You could also use a function like Convert() to flatten the dynamic array into a comma del...

Thanks, I'll give that a shot.