DSXchange

You mean they are garbage and unreadable, or you don't understand them? Post an example in either case and let's see...

Same answer as in your other thread. Yes?

Ha! Me too! I'm still (mostly) talking to the same people I've always talked to, some for years, when I call support. Sure, there's new ones but it's nice to hear a familiar voice. However, every time I've had to do something licensing related they've porked it up. Going through that right now as a ...

Not a DataStage setting issue, should be an issue with your sort command. More that likely, running it from the command line (outside of DataStage) will generate the same error.

Pretty much echoes what I said - assume nothing in your script: where you are, what environment variables are available, path settings - nothing.

You don't need to "change the path". Your script needs some tweakage to use absolute paths I would bet. Easiest way to resolve this is to post your script, wrapped in 'code' tags to preserve formatting. Then we can make more specific 'suggestions' for changes.

[sigh] Any error in particular or do we have to guess?

Your problem isn't with how you are calling the script but the script itself, I would bet. Make sure you are using absolute paths in your script or are cd'ing to the appropriate directory before attempting to work with any files. Make no assumptions about anything in your script - environment variab...

Common 'problem'. As noted, the monitor shows update requests - it's up to your job to ensure they are valid updates. Keep in mind the fact that Oracle updates that update zero records are not considered to have failed - they successfully update nothing. Same with deletes. So DataStage has nothing b...

"Doesn't work" in what sense? What does the job's log say when the command is execute?

Not sure what you are asking about the parameters. There is a specific 'box' for them as well, put any you need there. It will combine the two before the command is executed.

Who manages / administers your Autosys system? Have they not been able to provide you with a solution to this, other than the one you are currently using that is?

Yes, you can force it to work in a single link by using custom / user-defined sql and hard-coding any 'missing' values as you've found. I, for one, would never take that approach but if others are comfortable with it... You are much better off using two links and specifically handling inserts versus...

I'm curious if these commands actually work for anyone. The -lic_report always shows the following information regardless of usage: 0 license seats are in use 8 license seats are available Note: we're licensed for 22 seats. The -info command seems a little more useful but shows active 'User segments...

That's good... care to share the solution? That way others with the same questions searching the forum can benefit from your efforts.

Typically, one would do a File/Save As and change the type. Excel does the rest. Are you looking for something other than that?