DSXchange

You DO have BASIC Transformer. At worst, find it under Stage Types in Repository (Stage Types > All > Processing). You can customise your Palette (right mouse click in background area of Palette), choose Custom > Customize.

Where is the column value stored? Apparently you've collected data from all processing nodes into a sequentially executed stage type, so that there's only one location. If this is a sequential file or a one-node File Set, you should be able simply to read it from there. As a general observation, the...

What happens if you run an after-job subroutine from the job sequence in which you call DSGetJobInfo(DSJ.ME, DSJ.JOBINTERIMSTATUS)? Perhaps log this result using DSLogInfo().

You can define more than enough columns for any row, with generic names (Field001 through Field200 for example), and set the missing and incomplete columns rules in the Columns grid to a rule such as "Replace".

There's an even simpler explanation here

Can't be done from UNIX. Job logs are database tables in the Repository database. Therefore you would need to be working in the database environment ( dssh ). Second, you would need knowledge of how instances are identified in the RT_STATUSnn and RT_LOGnn tables; this knowledge is not in the public ...

Open Designer Help. Find OCONV. Find the hyperlink to D. Read on...

Up. They (the Ascential reseller network) just got their foot in the door with government in a more than paltry way, and now have the IBM nametags to go with it.

I bet you don't even worry about the Y10K problem caused by having a four digit year either!

ds_is_fun wrote:Char to numeric conversion. Any suggestions?

int32_from_string in Modify stage. Just be very sure that every value can accurately be converted.

Welcome aboard! :D When shared libraries can't be found it's usually the environment variable that specifies the search path for shared libraries (this is variously called LD_LIBRARY_PATH, SHLIB_PATH or LIBPATH, depending what kind of UNIX your DataStage server runs on). DataStage processes set thei...

The statistics report what DataStage sent, not necessarily what the database server accepted. You must look in the job log (for upsert) or in the bulk loader's "bad" file (for load) to see whether there were any problems getting data into the table. For bulk load, in particular, once the bulk loader...

Any reason you didn't install server as well as Enterprise Edition? It's no greater cost. The "server" engine has to be present anyway, since that's how job sequences are implemented.

If you're going to work with DataStage BASIC internal format dates, then you can modify my earlier formula to take account of the fact that Mod(TheDate,7) returns 0 for Sunday and 6 for Saturday to replace the constant 3 in the addition. If it's Wednesday through Friday you need to add 5; otherwise ...

Of course you can! You are streaming data from the hashed file. It feeds the link that is a solid line into your Transformer stage. To effect multi-row return you connect an ODBC stage to the Transformer stage; it's link is painted as a dashed line, indicating a reference input link. That's your joi...