DSXchange

An alternative for the FMT function is to use a background. FMT(number, "R%9") lays down a background of nine zeroes then superimposes the value of number, right justified, over that background. I believe this is marginally more efficient (in terms of machine cycles) than using a fill character. Ray...

In general, no. The Sequential File stage works with files. However, if you need to create a directory you can set up ExecSH (or ExecDOS on a Windows platform) as a before-stage subroutine with an appropriate mkdir command in the InputArg field. You can use job parameters and macros here too. You mi...

By default the Sequential File stage will treat a zero length string ("") as NULL. This behaviour can be overridden on the Format tab of the stage. On the Columns tab, if you scroll the grid to the right, you will discover that you can affect this behaviour on a column by column basis, as well as se...

quote: Originally posted by Ray.Wurlod [br]If you're running Bourne shell, you will need to export the environment variable. To find out what shell you're using, echo $SHELL - the Bourne shell returns /bin/sh To set and export the environment variable, set its value then use the export command. ENV=...

If you're running Bourne shell, you will need to export the environment variable. To find out what shell you're using, echo $SHELL To set and export the environment variable, set its value then use the export command. ENV=New value for this variable export ENV Ray Wurlod Education and Consulting Ser...

A solution with two Transformer stages is the easiest way to solve this particular problem. One lookup is performed by each Transformer stage. The reference key expression for the second lookup is built from values from either or both of the stream input or the first lookup. It is possible, of cours...

If the XML document in each line isn't too long, perhaps a DIY approach where you have a Sequential File stage writing a single column that contains the document, the document having been produced by an expression in a preceding Transformer stage? (An obviously quick response without a lot of though...

The syntax looks OK, provided that the references to job parameters or macros are properly spelled and cased. The parameter type can be String or Pathname. I'd recommend Pathname, because (a) you can then locate the text file anywhere in the file system, and (b) the operator gets a browser when bein...

Next time you've got one of these stages open, click on the Help button. The description provided there is quite reasonable, imho.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

Does your DataStage job deliver exactly the same number of columns (52) as there are parameter markers in the query? A mismatch here is the most usual cause of "parameter not bound" messages being generated.

Plug-in stages have their own versioning strategy, and do not depend on the DataStage version number. Plug-in stages written correctly according to the API are guaranteed to be forwards compatible. Right now I don't have access to a DataStage machine, perhaps someone with version 7 could post the ve...

Note that the ODBC driver for Excel regards worksheets as system tables. [:0] This means:
(a) you must check "system tables" when importing metadata
(b) the "table names" come in prefixed by "$"

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

As the first argument to DSAttachJob specify the job name, a dot and the invocation ID. For example: JobName = "TestJob" InvocationID = 1 ; * generate this however you like UniqueJobName = JobName : "." : InvocationID hJob1 = DSAttachJob(UniqueJobName, DSJ.ERRWARN) * Set parameter values for invocat...

In fact part of installing the DS 7.0 client is installing .NET framework if it's not already in place!

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

There is a small logic fault in Ken's code, which will prevent it from working. LOCATE searches for a "whole element" match; as soon as you add a second value to the field, LOCATE won't find the first value. One alternative is to use FIND rather than LOCATE. The other alternative is to use two field...