DSXchange

DataStage was originally developed precisely for loading star schemas (the preferred implementation for data warehouses and data marts). It works brilliantly. As with any other load sequence you need to load the tables in the correct order so that referential integrity is preserved - outriders first...

There are thousands of error codes. Your database documentation should have a manual that describes them, and probably has a utility that decodes them. For example the Oracle utility is the oerr command.

Never, because Ascential no longer exists.

If enough people ask for it, IBM may do so. Submit enhancement requests through your support provider or through DSXchange or through DeveloperWorks (if it still exists).

But does if you truncate Arg1. Let stage variable svArg1 be defined as Right(Arg1,16).

Remember that you must have no clients open when you make the switch.

With or without NLS enabled?

Either way it should be OK, but remember that 247 through 255 are reserved for dynamic array delimiters. If NLS is enabled these "European" accented characters are re-mapped to the Unicode private use area.

What motivated your question? Have you tried it?

Putting an IPC stage in every job will indeed create extra processes - that is its function. As for "kill the CPU" that depends on total load, but other posts from you and from your site suggest that you are doing that already. In short - everything in moderation. I suspect someone went on a class o...

You can not set job parameter values once a job is running. That rules out a before-job subroutine. You must set job parameter values before the job starts. This is most easily accomplished from a job sequence (which is a GUI for writing job control code). Or, of course, you could write your own job...

"31-Dec-2006" is NOT "the format in the table". Oracle stores dates as a binary value. What you've described is the default date picture at your site. I can not understand how you can get an integer from the TO_CHAR function you have described - are you sure you have not then applied an Iconv() func...

As far as I am aware no-one has succeeded in installing any version of DataStage on Vista. It's not a supported OS. You can request XP when you buy your Dell. Curiously they refuse to install Windows 2003 Server.

Don't know if U could help with the problem. He's fairly new to DataStage, according to his profile.

What IS "the source"? What data type is your date column? The answers to those questions will help a more targeted response to your questions.

NEVER kill DataStage processes - it's almost certainly because of this practice that the licences are not being freed. You have a tool in the DataStage bin directory for cleaning up licences. It's called dslictool and has two modes. dslictool report_lic lists the current licensing state dslictool cl...

Send the results to a text file with no transformations. Use a hex editor, such as UltraEdit, to view the file as a dump of hex characters. In that way you will learn what the actual characters you believe to be line terminators actually are. After all, you have to use Ctrl-Enter or Alt-Enter to get...