DSXchange

In Director, select the job and then go to Job menu and then "Clear Status File" which will reset the status of the job to compiled.

Thanks Tom.

"What I have done to circumvent this limitation is to create several MetaStage repositories and then use the SendToDB feature to export critical meta data from each to a DB2 Central Repository which holds a custom meta model. " Tom, How did you get the send to database to go to one central...

Do you mean an empty closing tag: <balance/>

If so, in the xmloutput stage, stage/transformation setting tab, set replace nulls with empty values and set empty element style to single tag(<tag/>)

For DataStage 6 and later, there is a XMLPack with XMLInput, XMLOutput and XMLTranform stages. You may have to install this separately. There are also two older versions, XMLReader and XMLWriter which should have been installed with the product.

Pipe any non repeating data to a hashed file stage, using serialno for the key. Then pipe repeating tags to the an xmloutput stage, and then to another hashed file stage to which you will write the repeating tags as xml chunks and use the serialno as key. It may look like this SerialNo:1 TotalPaymen...

In addtion to copying the hash files, don't forget to copy the DICT for each file ( i.e., D_APM.VERSION).
You will need to create VOC entries for the three files, for example for APM.VERSION :

Line 1: F
Line 2: APM.VERSION
Line 3: D_APM.VERSION

I have been using DataStage with Clearcase to handle promotions from development to integration testing, user acceptance ( and eventually production). We have been checking in DataStage components by functional categories into Clearcase using XML. XML gives better visibility as to what has been chec...

Try: If Not(Arg1 Matches "2N":"/":"2N":"/":"4N") Then...

The Tools4DataStage Discussion Forum has just been upgraded. The primary reason for the upgrade, other than keeping up with latest version, was password encryption.

If you run into any issues, please email forum@tools4datastage.com.

Please excuse the downtime and thank you for your participation.

Yes, that is correct.

There is no way I know of to access the result set of a before job command. You may try running that routine/command in a transformer stage variable using : IF @INROWNUM = 1 THEN ...run my routine...the result set then could be accessed through the stage variable or using named commons in DataStage ...

@INROWNUM is the number of rows coming in and @OUTROWNUM is the number coming out per link.If all rows go through then they will be the same. But if you put a constraint for example on an output link, then they will be different.

The sort specification in the sort stage is case sensitive, check your input sequential stage, specifically 'DSLink3.date'.

The normal command for accessing hashed files require that they have a pointer in the project VOC file. Below, is a routine that takes the path of the hashed file as argument, then creates a temporary entry in the VOC, counts the hashed file and then deletes the pointer. I tried using the openpath s...