DSXchange

You will develop your routine, and it will work. After 30 days from first use, it will stop working. At this point, you will need to pay money to license your ODBC driver. This is not money to Ascential; this is money to the driver vendor. If you're not prepared to go this route, don't even start de...

It's a good day, I've learned something new. Yay!

Priority is a number from 1 to 4 (used to be 1 to 5). Priority 1 is critical, site down, costing megabucks. Please be honest about these, as your way of being nice to the rest of the Ascential client community. Ask the support person to explain the exact meanings of the others. If you can find a wor...

At the TCL prompt, type HELP BCI.

You can download the BASIC SQL Client Interface manual from IBM.

It's not a statement you can generalize to say that a DataStage job will use only one CPU. For starters, the job runs in one process, an active stage will run in a child process. The likelihood is that they will get different CPUs. Further, independent active stages (for example separate processing ...

Check out the DB2 help on TRIM - it may only remove "extraneous" spaces (leaving a single space). In this case, and if the pieces either side of the space are of known size, you could use substring and concatenation techniques. SELECT SUBSTRING(Product FROM 1 FOR 2) || SUBSTRING(Product ...

PDFs for all plug-in stages are on your DataStage CD in the Packages folder. Go there and search for pivot.pdf; it will be there!

The "lib" routines are those in the DataStage BASIC SQL Client Interface (BCI). They mimic programming using the ODBC API. Search the Forum for BCI. To use these requires that you have a licensed ODBC driver for connecting to your Oracle (or other) database. The drivers shipped with DataStage are no...

Look in the Routines branch of your Repository, where you will find the source code for ExecSH, complete with documentation (comments) that explain how to use it. You need the command (the pathname of the script), with any command line arguments) in the Input Value field of the caller. If you have t...

You would need a complex OR condition to detect all possible job status values that would potentially benefit from being reset. These include 3 (job failed), 13 (validation failed), 97 (stopped) and 99 (other). In the last case, there is no guarantee that the reset will work; you really need to chec...

It doesn't write it anywhere in the link properties, in the same way that it doesn't write COMMIT or ROLLBACK in the link properties. Instead, these govern the behaviour when the job connects to the data source; if this property is set, then a TRUNCATE TABLE statement (or whatever equivalent is appr...

There has been a long-term glitch in some of the controls used in DataStage clients. I always make sure that I don't click OK while still positioned in any field where I've made a change - always move to a different row of a grid (it's the LostFocus event the triggers the change back to the design),...

This shows that the timestamp actually in the log (it's stored as a Char(19)) is the same as the one dsjob reports with -logsum. Something is adding one hour when using -logdetail. It does kinda look like a daylight saving shift, but it does kinda look also like a bug. Has anyone else reproduced thi...

Read the on-line help for the Compare() function. The justifiction argument is optional; if used it must be "L" or "R" (if not given, "L" is assumed). The square brackets are not part of the syntax; they serve only to indicate that the argument is optional. This is a very common convention in IT doc...

The lock is set even if the ELSE clause is taken in OpenSeq, as you may be opening a non-existent file for writing. Your GoTo EXITJOB statement bypasses your CloseSeq statement, so the lock would not be released in this case. You should also code ON ERROR and LOCKED clauses for your OpenSeq statemen...