DSXchange

None that I know of; even DirecConnect only supports it on Windoze.

But if you have an Oracle database you could load your data into that and use the method described to convert the data on reading. It is simpler than coding your program which is the only other alternative discussed so far.

Your project might be corrupted. First thing is to make a UNIX backup of the project directory immediately if you haven't done that already. Try executing the TCL command "COUNT DS_JOBS" from a shell if you know how to do that, or as a command from the DataStage Administrator. If you get a number th...

Write your data to a sequential file and read it from that file. That will give you the effective speed of all stages leading to the file stage and also the effective speed of all stages after the file stage. This will help you narrow down the cause of the speed slowdown. You can continue doing this...

Nagesh, there really isn't a (DataStage) problem here. When DS needs to perform padding it will use the APT_STRING_PADCHAR value unless you override it. The job will use the current APT_STRING_PADCHAR, that value is set to a default value at project level but can be changed or set at a job level. It...

The APT_STRING_PADCHAR is used anytime a string needs to get padded and not only for DB/2 EE stages. So if you changed the pad char to "x" and do a transform or implicit conversion from a varchar(3) to a CHAR(10) column then it will use 'x'. If this is wrong in the specific job, add APT_STRING_PADCH...

Most databases have a command line SQL interface. You would access this through the DSExecute() command. How you do this depends upon what database you have. Usually the easiest method is to write a script that accepts such things as database, instance, schema, userid, password and SQL command and d...

deepesh, ...The job failed in the ABC stage as it was unable to create a temporary file. Suspect that the SQL is returning so many rows that the hash file overflows (possibly). No, if the hashed file overflowed past the 2Gb boundary you would get a hashed file write error and a possible corrupt hash...

You need to start by looking at the documentation.

The DataStage Designer guide to begin with and search for "mail".

There are many ways to do this, either directly in a sequence or via a routine call to DSSendMail()

...even though those jobs are not using this environment variable... The fact that the environment variable is not explicitly declared does not mean that the EE jobs don't use it. The same applies to ALL environment variables. If they are not explicitly set in the parameters of a job then their val...

That was not (directly) a question. Many, if not most, of us have seen that error at some time or another. The term "phantom" is just DataStage's way of referring to a background process; in this case a running DataStage job. If you do a "reset" of this job in the director you will get a new entry i...

Sam, since you are creating this file you can strip out or replace the offending non-displayable characters yourself. You can even write a simple DataStage job to read a file and do this. Do you know the ASCII code(s) of the characters that are getting inserted into the file? You've stated "low char...

Edward, start off with getting the command stage to work. The "dir /b" command returns the directory contents in brief form, that is just one filename per line. When this gets stored in a single variable in the sequence the DOS <cr><lf> combination gets replaced by a single character in DataSTage wh...

Edward, the "ren {originalfile} {newfile}" syntax is correct and works. If you have embedded spaces in your filename you will have to double-quote them. If you write a sequence that starts with a command stage to get your directory contents into the variable, i.e. by using "dir {path} /b". Then do a...

If your code uses the documented APIs then you are in luck. If the programs/routines/function have include statements for some of the internal insert file definitions and make use of COMMON/{InternalNamedCommonBlock}/ then you will encounter problems.