DSXchange

Continuous, sort/merge or sequential Funnel? I suspect the second, and that the process that watches all inputs simultaneously to figure out which is next to preserve sorted order has taken some kind of abort. It's not totally clear why - but that's the line of investigation I'd be following, even u...

If you have 3000 jobs in the project, it will take a serious amount of time (minutes rather than seconds) to gather these data - before you disable view of categories go into Tools > Options and change the refresh interval to, say, 600 seconds. Change it back, if desired, when you've re-enabled disp...

The "tweak" is called -itag installation. Read about it in the Upgrade and Install manual.

Precede the Transformer stage with a Sort stage, in which you generate a sort key change column. Data coming into the Transformer will be sorted, and you will have a flag to indicate when a new sort key begins. Stage variables are evaluated top-down in their grid. This means, for example, that while...

Hi DSguru, U r right. I did not use it. Can u please tell me How can I use it. I just used this : DateToString(DSLink3.DATE1) Thanks! We haven't heard from U is a while, but I note that U is still a registered member. The second person personal pronoun is spelled "you". The present tense plural for...

I think that post refers to a DSX file, meaning a DataStage export file. These are stored on the client machine wherever you specify when you perform an export. What seems to have happened here is that you have imported the job but not a routine that it calls. Both of these should have been export s...

SELECT INSTANCE, DTM, MODIFIER, REASON FROM DS_AUDIT WHERE CLASS = '2' -- select only jobs AND INSTANCE = '<<Job name>>' AND DTM >= '<<yyyy-mm-dd>>' WHEN DTM >= '<<yyyy-mm-dd>>'; The WHERE clause restricts the result set to those jobs with a DTM in the specified range; the WHEN clause limits the di...

Note, too, that the representation of NULL in the Columns grid must have the same number of characters as the width of the field to which it relates.

You can set the default for all columns on the Format tab. However, the default of "" is probably better in most cases; where you want " " (that is, a space) to be the representation of NULL, I recommend doing this explicitly at the column level. Incidentally, Trim(" ") returns " ", never "". You wo...

Wrap your dsjob command in a script which catches the exit status and converts 1 (finished OK) and 2 (finished with warning) to 0 and anything else to 1. Or change the rules engine in the Tivoli scheduler so that an exit status of 1 or 2 is "good" for dsjob.

DSCRestoreRowFromBuf is an internal function. You will need to get help from your support provider on this one - possibly a patch ultimately. Try a design as follows: SeqFile ----> Aggregator -----> SeqFile In the first Sequential File stage use a Filter command that catenates the three files and pi...

I do not think this is possible, since a dictionary describes a fixed-width structure. Your first two directions could be described by the same dictionary if you use a single field for name, and a name rule set that can parse out first name, main name, etc. But the third direction is not of the same...

If you specify " " as the representation of NULL in this field, in the Columns grid, then " " will automatically be read as NULL, which IS valid as a Long, so the warning will disappear!

Do you intend for this to be used in a BASIC Transformer stage? Using a Sort stage with key change column should allow a downstream Transformer stage to use stage variables to detect when the emp changes and to compare with the previous row. This will allow you to achieve your goal. Make sure data a...

You have specified the transfer within your buildop and you have tried to use a schema variable in the same buildop. The two are mutually incompatible.