DSXchange

Ray, biggens is NOT Texan. Bigguns is.

Nah, he is just picky.

You can export one job with this post http://www.dsxchange.com/viewtopic.php?t=98137 using dsexport.exe instead of dscmdexport.exe.

Please edit your post and put code tags around your code so the indentation is kept. Your code looks fine. If your sequential file is small then there are other ways to search it. I think the openseq is blocking you from processing this in another job. You can easily solve this if the file is small....

I posted a script http://www.dsxchange.com/viewtopic.php?t=95242 which will find all files greater than 500mb. This is a good starting place.

Agreed! This client is stupid.

I would do the update on job name one at a time instead of renaming from the old name. Get one to work first before trying the rename.

Ray is saying that this is closer

The new EtlStats includes a few jobs which extract ETL metadata like the table names associated with the link name. This is only for output links but this becomes very useful. You can now tie row counts to table names. Here is the SQL. You need to find the right jobs to run to populate the tables. T...

'CHashedOutput','CHashedInput' determine input and output but what we think of as input DataStage thinks is output. Take the SQL and either use one value or print this field.

http://www.dsxchange.com/viewtopic.php?t=93363&start=0 will show you the SQL. You need to add CATEGORY to this.

Vincent Loved the blog on DataStage Simplicity. Very cool. My thought process completely. DwNav and all my tools are aimed at reducing the complexity of ETL to help understand the overall data flow within ETL. Simplicity also means consistancy. ParameterNavigator is aimed at consistancy and simplify...

I had a feeling you might think that.

I guess the second question too. Huh Arnd?

Probably manually. By searching for the tags you want to change. I would think stage variables would be needed to aggregate a field by catenating values across lines.