DSXchange

The product ships with all kinds of "sample" code, pretty much every routine includes the source code. Find them and start examining them, one of the best way to learn how things work is to study working things.

I already moved it there... we're here right now. And replied as well. I'm no Arnd but I think I can hold my own.

Decided to push this over to the General forum where we can discuss all aspects of routine creation. And why create a routine that already exists and ships with the product? It's called "KeyMgtGetNextValue". :wink: If you find it and open it up as if you were going to edit it (don't) you'l...

As far as I know, those routines would still need to use the appropriate dBase ODBC drivers as well, so you might as well stick to writing a job. You might trying Googling to see what other conversions are possible. Hmmm... "convert dbf to csv" returned lots of hits but you'll need to get ...

For grins... what database vendor?

In the meantime, I assume you've contacted your official support provider - yes?

Ah... good. Glad I could help, somehow.

Now on:

No, I mean the "code tags" that are available on any web board like this and which you have buttons for right above where you type when composing a text. I'm going to enable the "Disable BBCode in this post" option here so you can see what they look like when editing. Leave the o...

Raftsman wrote:We could use the "dsjob -run -warn 1" but it will pass if only one warning is thrown.

Actually, that means abort on the first warning.

You should be aware by now that all of your examples need

As noted.

You'd have to unzip it, perform the edit and then zip it back up again. Is that not possible? I have no way to test any of this, hence the question.

Because of the underlying software DataStage uses, you can still use 'UNIX' scripts on a Windows DataStage server. That or replace all occurrences of "shell script" in my response with "batch file".

Welcome aboard. As you've found, the WFF stage does not support wildcards so you'll need some other mechanism. How are your shell scripting skills? You could script something equivalent and then use an Execute Command stage to run it. Some other approaches inside DataStage are noted here and here.