DSXchange

So, would you mind sharing with us what control characters you found and your final Convert statement? That and mark the topic as 'Resolved'. Both would help future searches with a similar problem.

Thanks.

You 'call' an Oracle function in DataStage the same way you would in normal SQL - just select it as part of your query. The stage can generate it for you if you put the function (etc) in the Derivation for the column.

That's because you are using mixed case and it is trying to preserve it. Just type the tablename in all UPPER CASE, you'll avoid all kinds of problems mixed-case tables names bring in Oracle.

No, wildcards in the Filter option of the Server Sequential File stage.

There's no such thing as a 'script' written in C. You're probably seeing example C code from the dsjob application itself or how some of the functions themselves are implemented in it. There are no script examples in the Guide from what I recall, but descriptions of all of the functions available as...

Your problem is the fact that the job is Stopped and not Aborted. To me this is a bug in DataStage and something you should query IBM Support regarding, but the '/Restartable' part in this case is simply not true. As you are finding, it must be reset before it can be run again and you lose the check...

I pull a single .dsx file with source from an entire project and load that. Simplest that way.

Doing the table metadata after the fact is too late.

For Chuck's utility, I load the output into a database table. Then you can simply query the field that contains your table (FILETABLENAME?) with a case insensitive wildcard match.

DataStage is a 32bit application on most platforms. I doubt you'll find they are truly incompatible, but instead you must use the 32bit libraries to access it rather than the 64bit ones. You do this by ensuring the proper libraries are listed first in the appropriate 'library path' environment varia...

Why in the world butcher your original post like that, or change the subject from 'awk' to 'u'? There really was no need for that. It's fine to come here with questions like yours about what awk is, just don't expect long involved answers when the subject isn't specific to DataStage. Best to link yo...

The pros and cons of XML? Sounds like a Roger Waters album.

I've never pondered it, really. All things have limits but I've only ended up using XML when required to, not because I had a choice in the matter.

Google. Found this old Ascential Whitepaper which mentions MQ Series integration as one example of what can be had out there.

You need to do a better job of explaining what you are trying to do and what you are expecting. Examples are always good.

You also need to verify the connection daemon is up and running:


Should return one line.

Why not just check '/etc/services'? The default port for DataStage is 31538 but I'd suggest you verify there.