DSXchange

Yes. Supported databases for the common Repository are:

DB2 version 9

Oracle version 10g

SQL Server 2003

It may be possible in a long, nested If..Then..Else expression - I have not spent any time analyzing your specification. But a routine (possibly with a CASE construct) would, in my opinion, be easier to read and to maintain.

Quod erat demonstrandum.

Well done for finding it. Now perhaps you could mark the thread as resolved?

You can pay IBM for their conversion service which, as far as I can tell, involves taking your server jobs and shipping them offshore to be converted by people who apply their brains to the task; analyzing the logic of the server job and implementing the same in a parallel job.

Interview question, methinks.

Possibly seeking knowledge about how one goes about using configured node pools in particular stage types.

Please get to the operating system prompt on your DataStage server machine and execute the hostname command, posting the result here. I am interested in verifying the machine name used in the fastname property in your configuration file.

There is also the "UniVerse" command ENV (that you might execute using DSExecute subroutine), which will return all environment variables, and you could process that string with FINDSTR to locate the one(s) in which you're interested.

Have you searched the forum for "internal file corruption"?

You can clear the log, which will clear the corruption, or you can attempt to repair the database table (hashed file) that is the job log.

Techniques will be revealed by your search.

will reveal the correct column names that you may use in a query. They are case sensitive. You can use only the ones whose type is "D" or "I" in a query.

Do you mean generically, or just for the USA when changeover date is mandated by law (except for those states in which it is ignored)? Search the forum for other discussions around this question.

Then do it in a Routine. Shell = "UNIX" Command = "grep -v Country_Code " : argSourceFilePath : " > " : argSourceFilePath : "_noheader" Call DSExecute(Shell, Command, Result, ExitStatus) If ExitStatus <> 0 Then Call DSLogWarn("Error ("...

You missed granting SELECT privilege on the DB2 system catalog tables to the user ID from which you connect from DataStage.

Run your data through a Sort stage to generate a Key Change column (which is 1 if the sort key changes, 0 otherwise). Use this value in a downstream Transformer stage it increment a stage variable (that was initialized to 0) if the key change column is 1.

Every job has a number. Did you provide a valid job name? They are case sensitive and must be spelled correctly.

Or are these problems arising even before you try to use the Build stage in a job?