DSXchange

Put a call DSLogWarn({data},'') into your routine to make sure that the 3 values are being passed as expected and that it is being called when you expect it to be.

An alternative would be to use the debugger.

Kirtikumar, I just looked and stand corrected ! In our Oracle we can insert a null into an integer field and subsequently SELECT it. Since a binary representation of NULL in a normal integer field isn't possible Oracle must use a flag outside of the field's value to mark it as NULL. If a field is a ...

Kumar, integer fields cannot contain null values. Think about it for a minute, integers are represented in a binary form (often excess-128) and use every single possible combination of bits to represent positive and negative numbers. How would an SQL NULL fit in? There is no way to distinguish betwe...

Kumar,

go to the on-line PDF manuals and open up Ascential DataStage Basic Guide to page 804; it will explain the date conversion codes.

Kumar,

enter "ulimit -a" to see what your limits are, n.b. this may be different for your background DS processing than for your login UNIX session. Often the users are limited to 2Gb files even though the file system and the operating system support them.

Ray, the usual listings specify attributes such as: (1) trained Superman (2) walks on printouts without leaving wrinkles (3) 10 years Px Experience (4) 2 advanced Computer Degrees (5) 10 years specific industry experience (6) no older than 25 (7) willing to pay customer for the honour of working But...

Or read the files in with just one VARCHAR column each, then you can write as a variable length file - just don't trim the spaces.

I think many here have done similar things. Using a stage variable in a transform and working with the row number... Is this what you are asking?

If your source are fixed-width files then you have NO column delimiters. You can merge the files together if, in the column definitions for the fields that don't exist in the "shorter" file, you tell DS that they can be missing.

When you say the 2 files have different metadata, is this in the number of columns? Or do the files have the same number of columns with differing field lengths?

Field delimited if you have delimiters between the fields, record delimiters at the end of lines (usually CR or LF or both)

There are many cases where using Hash files are much better & faster. You could always write to a sequential file at the same time as writing to the hash file, that way you've got a copy which you can use for debugging purposes that is a bit more friendly than doing a 'view data'. Those of us he...

The general naming conventions at this project run to 28 fascinating and thrilling pages, of which 3 cover job nomenclature. The name is in the general Format J{Sequencer/Px/Server}{Group}{Category}{Type}{Hungarian-notation-short-desc}{[Number}. Most developers on this project have gotten very, very...

Titto, it was easier to tell you what you can't do than to figure out what you should do You could write to 3 separate sequential files and later on concatenate them. You could write to a hash file adding the transform name to the key to make sure that records aren't duplicated. You could write to O...

Titto, you can use the same file in 3 stages as output if: (a) it is not a sequential file (b) if it is a hash file, the keys must be unique, meaning if one stage uses the same key as a previous one the value is overwritten (c) if it is a direct database or ODBC connection then you need to ensure th...