DSXchange

The substr() function in DB2 only helps if you know the actual location of the characters to replace. In DS you can use the convert() function to convert certain characters to others (or to empty); but this list might be a long one unless you only have a limited number of special characters. Do you ...

Is it correct that your client and server are on the same machine, your Windows PC? Could you please post your APT Config file?

I would also like to know if "mainenance issues" are necessary, but you can "cd" into the project directory, execute {path to Engine}/dssh.exe -C "DS.REINDEX ALL" , the syntax might be off since I can't test it from here, but if you get an error message that will probab...

An urgent question on a Sunday should be addressed to your 24x7 support provider.

dssiddu - The second example makes it even more confusing than the first. "the number of zeroes before it" is not understandable as a rule since line 3 and line 4 both have 2 zeroes before. Could you explain the derivation logic in a bit more detail, please?

There are a number of ways that records are "rejected" and the answer depends upon exactly what you mean in this case. Usually the best way is to the use stage reject link (when supported) to write these rejects straight to a file.

It is an attribute in the Sequential file stage when you are reading, something like "Display progress" in the options.

dsuser7, you are on Windows, so the scheduling tool is usually "AT", you can read up on that in the documentation.

Go into the director, Menu Job -> Clear Log and then click on the check box for the Auto Purge settings for that particular job. The project default purge settings are set in the DataStage Administrator.

If you only have a percentage as input then you cannot do this from within the job unless you know how many rows you are going to get. Then you can compute the trigger number of rows and make a reject link output force the job to abort when the constraint send a row down that link.

I'm really confused now. The output DB2 stage in DataStage does not allow a "view data" to be done. Is the error message from run time? What is your output SQL?

Please read the documentation on "NextSurrogateKey" - it is not a constant, but a function that you can select from the function list in Transform stage derivations. Parallel Job Developers Guide, Chapter 11, page 183.

If the source is a sequential file, you can have DataStage report statistics to the log file, then write a job or script to examine the log file looking for the percentage figures.

If the source is a sequential file, you can have DataStage report statistics to the log file, then write a job or script to examine the log file looking for the percentage figures.

There are numerous ways to do this. How about an hourly "AT" scheduled batch script that starts a small DS job and then checks the error code / status. If the status is invalid then send a mail.