DSXchange

With an after-stage or after-job subroutine, or in Job Control code, you can do anything for which you have a command line interface.

This is the kind of task that the database associated with the Documentation Tool is geared towards. You can use the default (doc_tool.mdb) and generate your own queries using Microsoft Access. Or you can use your database of choice, which is accessed via ODBC from your Manager client. Scripts for c...

If you've switched on hashed file cache sharing (see Craig's post), then only one copy is cached in memory. When the next job seeks to load the hashed file, the fact that it is already in memory is detected.

If the input data are sorted on the four grouping columns, you can use stage variables to detect change. This is a much more efficient mechanism than the Aggregator stage. Search the Forum for examples. Another approach is to use a hashed file keyed on these four columns. All writes to hashed files ...

Surely, if the parameter value needs to be different for each separate invocation of the job, you don't want to use the default value in any case but, rather, an explicit value? The behaviour you are describing can occur if a job has aborted and not been reset, or if the job has been stopped by the ...

Yes, that needs to be table driven in Australia. Remember how they changed even from those rules for the 2000 Olympics? But that's no big difficulty - you could used a hashed file or UV table, or even a text file; the volume of data is not huge. Are any of your data dates (those that need conversion...

You know how the doctor says "it hurts, does it? well don't do it"? The same applies here - there appears to be something in the interface between the QS plug-in stage and the underlying Quality Stage (INTEGRITY) componentry that is failing to handle notification to shut down. Have you notified your...

38 is (probably) the precision of the underlying numeric data type. 19 is the number of characters in a TimeStamp (without sub-seconds). There are, for example, 26 characters in a TimeStamp(6) - that is, TimeStamp with microseconds. However, DataStage does not seem to recognize precision for timesta...

Welcome to the Forum. :D Your job is either a multi-instance server job, or it is a parallel job. Parallel jobs do not have, or need, multi-instance capability, because parallelism is built in to the architecture, based on the configuration file. Since you did not mention a configuration file, I wil...

DataStage BASIC has two complementary functions, ASCII (for converting from EBCDIC to ASCII), and EBCDIC (for converting from ASCII to EBCDIC).
Find them in the DataStage BASIC manual.

Have you specified grouping on just these four columns, or others as well?

Are you asking about different servers in different time zones or one server managing different time zones? Obviously a single TZ environment variable doesn't solve the second case. How are you doing it in C? (Are you able to post the C code? Someone here will probably be happy to "translate" the C ...

Looks like there's a chance Arg2 isn't one of 1, 2 or 3 in your data.
This situation would leave Ans unassigned.
Always initialize the Ans variable, even if you use Ans = @NULL.

Use a before-stage subroutine in, say, a Transformer stage. Use ExecSH as the subroutine and put the following command in your Input Value field: touch #FileName# If you want to remove the file first (in case it exists), simply extend the UNIX command. For example: rm #FileName# ; touch #FileName# o...

My suggestion is that you ask Ascential and post their response.
I am at a loss to explain it. Unless it's something to do with the fact that the tunable is system-wide (that is, a maximum for all, rather than for each, hashed file). That's just a guess.