DSXchange

If it's not too large a number of records (say fewer than 10 million (1 crore)) I would use a server job. Vertical pivot with an arbitrary number of columns is much easier in a server job. Some of the server job techniques could also be used in a BASIC Transformer stage in a parallel job. Splice(Reu...

AL32UTF8 is an Oracle map name. Oracle chooses to use different names from the rest of the world.

Try using UTF-8 as the DataStage map name.

They are not stored at all in UNIX. They are stored in a database. Worse (for your purposes), SQL data types are not stored directly as such, but rather are stored as an enumerated value. Unless you know these values, you can not effect a change of data type even with an SQL query against the databa...

No way for us to know, because we can't monitor your AIX system. You (or your UNIX admin) must do that. How busy is the system?

Pressing Esc is good. I've always uncovered modal dialog box that doesn't have focus by minimizing all other windows. Sometimes you can be lucky and it will have an icon in the task bar, but this is never guaranteed.

And, indeed, has been discussed in the most recent Webinar on the DSXchange Learning Center.

Basically, though, you need to handle the line terminators in the output of the command, which DataStage translates into field marks before loading into the activity variable $CommandOutput.

What Craig said is correct. Reinstate the UV.ACCOUNT record and delete using the GUI. There are too many interconnected components to try to re-invent that particular wheel.

That's what the Favorites folder is for.

Use the Fmt() function to add leading zeroes. Beware, however, that this will give "strange" results if your count goes over the number of digits you specify in your format string.

Do you get a specific error message that might show why this process is failing to start? If so can you please post that message?

You confused me with "inputs to my job". Yes you can use an External Filter stage for this, or you can (if the source is a file) use the Filter command property of the Sequential File stage that reads the file, in which case stdout of the Filter command is read by the Sequential File stage...

Welcome aboard.

Check that you have write permission (a) to all direcories shown as resource disk in your configuration file and (b) to the directory in which the Data Set descriptor file is to be written.

Try it.

Let us know.

Yes, simply refer to the same state file.

Where are you doing this from, and what have you tried?

I neglected, earlier, to mention that Director has a Print option under the Project menu, and that the print dialog has a Print to File choice available. This may do it for you.