DSXchange

Why the fascination with notepad? How do you expect your script to edit something and then close out the GUI window? Test what you are doing with something appropriate for execution in the background - something other than Notepad. As I said, I don't see anything grieviously wrong with what you are ...

Or simply: CREATE TABLE AS (your query) Two birds, one stone. DataStage is perfectly capable of creating any table you have the grants to create in TOAD. As to if you should use DataStage, that depends somewhat on what you are accomplishing here. A one time 'staging' of data? No, you're fine...

If that really works for you (I didn't check it) there's no need for a routine. You can inline all that and save all those intermediate variables:

Ok, in that case you need to replace the Execute Command stage with another Routine Activity stage. You'll also need to write a generic routine that runs an operating system command using DSExecute. In that routine you can ensure that all of the parameter arguments get evaluated properly. Or a speci...

vijayrc wrote:I guess I don't need to re-install the Client Components again w/ the new License details.

Actually, that's exactly what you need to do.

But I am not able to view the Routine stage output in the Execute command stage. No idea what this means. Nothing should be stopping you from using the output of the routine in the Execute Command stage just like you could in any downstream stage. #YourRoutineStageName.$ReturnValue# That would equa...

Pick something that doesn't want to open a window and run in the foreground. Maybe just 'echo' or 'type' something... otherwise you're in the ballpark.

Is there always just one decimal point? Is is alright to take everything after it or just literally the first three characters?

Use the FIELD function to take the second field based on the dot as the delimiter. Substring afterwards to 3 if that's all you need.

Ok, now that that's out of the way - it didn't work with -dsadm as that's not a legitimate option for 'uv'. As you noted, you needed to be logged in as dsadm and then use -admin in the command.

Simple as that.

Soon.

Go with your original idea - just don't try to put colons in the filename. As noted, best to create the file with a fixed name and then write a BAT file to rename the file 'after job' to include the current date/time or whatever else you'd like to include to make it unique... You may also be able to...

Use the Designer one - the one that ends with DSDES. It allows full access to the client tools while the 'Director' one is restrictive and only for Operators. It will accept either as long as they are input correctly - all pieces: serial number (including the -DSDES part), User Limit, Expiration Dat...

Ok... help us help you here. Just to make sure we're all on the same page, when you say 'packed format' what exactly do you mean? COMP-3? Signed or Unsigned? Don't forget, packed is packed (neither EBCDIC nor ASCII) and requires no 'conversion', mearly unpacking. As noted, some transfer mechanisms ...

Yah, the nuances of this will be dictated by Vivek coming back and letting us know exactly what he could encounter in this delimited data.

You mean like Trim()?