DSXchange

Close. The 'compress' command does not create a file with a .zip extension. And since qutesanju hijacked the thread, we have no clue if they are on UNIX or Windows.

Been too long - what do the ampersands and "EXIT" do here? Get rid of them if there's any chance they let the command release control before it has actually completed.

That would be where to start.

NLS not installed. Right, but still would be good to know the characterset in use in both the source and target as you can still accomplish much by correctly setting NLS_LANG and perhaps LC_CTYPE in the job's environment. Both source and target seem to be Oracle databases, unless they are landed du...

You cannot directly. You could think about generating a list of the job names in that specific category, landing them and then looping though the list and compiling them one-by-one.

New question / issue = time to start a new post.

How so? There's really not that much to elaborate on, do you have a specific question?

No, you want to pass just the filename to the XML Input stage and set it to "URL/File path" so that it reads the data. Trying to "pass the data" via the External Source stage is your problem.

Were you able to connect in the past and cannot now, or is this the first time you are attempting this and you cannot make it work? For the latter, as I noted, you need to ensure you have an Oracle client on the DataStage server and that it has been configured properly for DataStage. Do you? Have yo...

vennam445 wrote:I tried even ./orchadmin.It doesnt work:(

Define "doesn't work". That tells us nothing.

Define 'migration' and let us know what the NLS characterset is for both the source and the target.

Why you? Because you are The Man!

Not much command line experience, it seems. If you cd to the directory a command 'lives in' then preface it with 'dot slash' i.e. "./orchadmin delete filename.ds" - assuming that syntax is correct. Or fully pathing a command works from anywhere.

How is this condition checked? Seems like an easy task for a Sequence job with perhaps a Nested Condition stage.

There is, and a search for "file pattern" turned up a number of conversations, including this one which looks like it should help.