DSXchange

Your question is not clear. What do you want to do - record the file as being something on which the job depends (in the Dependencies tab), or to use the file somehow in a Transformer stage?

Please describe with much greater clarity what you are proposing or desiring to do.

Well, we still have no idea whether this is a server job question or a parallel job question. Therefore we still have no way to answer it, apart from "yes", or "maybe (it depends where)".

There's always this one but it's currently only available with an instructor. You might also approach your support provider to arrange on-site training from IBM. Perhaps you could approach IBM Learning Services directly. The course code you want is DX434 for version 7.x or DX444 for version 8.x.

Do you have an entry for edwdev in your uvodbc.config file?

Whichever is named first is tried first then, if it fails because of a primary key violation, the other is tried. For best performance (fastest finish) split the data into two separate streams - the rows to be inserted and the rows to be updated. Use direct write to handle the former, use "Update on...

DataStage's data browser (View Data) always displays decimal numbers with leading and trailing zeroes, so that you can check that the precision and scale are being handled correctly. Neither 130 nor 1460 can be represented as decimal[5,3] because that data type allows for not more than two digits to...

Before concatenation are you converting the timestamp into a string, and providing "%yyyy-%mm-%dd %hh:%nn:%ss.2" as the format string so as to overload the default timestamp format string (specified in Administrator client) that has no fractional seconds? Incidentally, the ".2" means hundredths of a...

This message is probably simply an alert because your target expects fractional sections in timestamps yet your string does not supply the same.

i install the datastage in the windows platform,so it can not run the parallel job Then you don't need the Filter stage. Even if you only have server jobs, you can read the Parallel Job Developer's Guide - it is one of the standard manuals set. There is a version of DataStage (7.5x2) that supports ...

With a script or BAT file, executed from the client machine, that runs dscmdexport. Search the forum for examples.

With a script, executed from the client machine, that runs dscmdexport.

Place a dynamic array, derived as follows, into a stage variable. Fmt(InLink.TheString,"40T") Then use Field() functions with @TM as the delimiter to extract the four lines. For example, to extract the second line: Field(svChoppedLine, @TM, 2, 1) The only change for the oth...

By default on some variants of UNIX, /tmp is not big enough. Make sure that you specify a directory where there is plenty of free disk space.

Many possibilities, including a corrupted DS_RESENU or SYS.MESSAGE file or insufficient permission on them. Involve your support provider if you're not confident with performing the detective work.

CLEAR.FILE can not readily be executed from a BAT file or from an operating system shell. It must be executed from an operating system shell. However, what you can do from a BAT file is delete the files from within the &PH& directory. Be very careful with the ampersands.