DSXchange

As Craig already noted, the INDEX() function will solve your problem. What have you tried to enter?

Have you monitored /tmp (and the other drives) while the job is running to see if any grows to 100% and, after the jobs abort, shrinks rapidly again?

From your csh or ksh or whatever shell you use, type in "ftp" and then see if you can connect to your host.

I didn't say the commands were invalid - but thought it unlikely that anyone would want to create indices on hashed-file-tables and more likely that they wanted to execute a database command line series of commands. But we'll see what the poster responds to your post. The DSExecute call looks correc...

Please post the actual error message.

If you add the environment variable APT_DISABLE_COMBINATION and set it to true, what stage is associated with the error? Do you have a "apt_matrix" used? Could that be your default APT_CONFIG file name?

This looks suspiciously like the problem I was asked to look at yesterday. Was the 2-node APT_CONFIG file that I recommended used, one which cross-mapped the /u03 and /u04 partitions for dataset and scratch directories? What does "300 partitions on the disk" mean? Also, why do you say that the job i...

You are executing "UV" commands, but the queries you are sending are database SQL ones so they won't work.

increase that limit with the ulimit -s {size} command; this can be done in the dsenv file so that it affects all DataStage users.

There is a whole course on coding in the BASIC language, so it is difficult to suggest where to begin.

In your case, try to solve it using UNIX commands first; it is easy to call UNIX shell scripts from DataStage.

The error indicates that you do not have the c++ compiler installed or configured per the DataStage installation instructions.

Avik - you neglected to tell us what database you wish to connect to.

An integer field does not contain leading zeroes. If you convert your integer to a string then you can use the str function as you mentioned. If you write this integer column to a text file you can also prepend leading zeroes (basically because everything going into a text file is a string). So in o...

To add to what Aakash has said - your program is doing a mathematical operation using a value that isn't a number at lines 122 & 123. The actual line numbers can be off by several lines - but just search your source code as Aakash suggested and look a little further past those 2 lines and you'll...

Put a RETURN statement before ErrorExit: