DSXchange

Find out what sqlcode -1390 means, then address that.

Do you mean
1 a b
2 c

Search for "vertical pivot". It can be done.

Simple DataStage job - read each line as VarChar and output as Char. Your filler is now done.

Add environment variables to the project using Administrator client. You can set default values while doing so.

If Madhu has a solution why do you want U to post what the solution was?

Was the requirement to delete tables or to delete records from tables.

You can install dsjob and its associated liraries wherever you like. However, you can only execute dsjob from somewhere where it is installed (and may need to adjust PATH and LD_LIBRARY_PATH environment variables). Details may be found in the manuals.

This simply means that SDKSequences does not exist, because none of the key management routines has been executed in the new project. You could test any of these routines, or execute the following command. CREATE.FILE SDKSequences 2 1 4 or, if you prefer CREATE TABLE "SDKSequences" (TY...

What symptom suggests that the job is a server job?

Have you been hacking in the Repository, particularly DS_JOBS table?

When's the interview?

Given the high job number, you might also have hit the operating system's limit of number of subdirectories in a directory.

The data record DOES have a null value, in column number 7.

Dump your results into a file and have the script read that file.

You can not rename categories. They are more deeply embedded than you suspect.

You must create a new category, move all the objects to the new category, then delete the old category.