DSXchange

I had a similar problem with Oracle only the number of rows was over 10 million. I still say it is a memory leak. It was an OCI 8 stage too. Oracle was 9i. Could never convince support of the issue. I just split my thread into multiple threads and made a multiple instance job out of it. Now it is fa...

Unless you have a really old version of DataStage then Craig is correct.

We still need a full Wurlod.

No it should not count. The auth code is loaded on the client. Some clients could have an old auth code and complain because you did not load the new auth code on that client.

I knew there was a reason I did it the way Ken did. I am used to Ultimate flavor.

JobReport is a routine which you can download from ADN. It was written by an Ascential employee named Tony Curcio. It will generate html documentation on one job. I wanted to document all jobs and all routines. So I wrote several jobs to do this. SeqGenAllHtml -> sequence Param: CategoryToDoc -> use...

You could do it in a routine or job as well. Lots of routines posted. To do this in a job, you would need to parameterize the job number. You have to use a UV stage to go against the repository files. Importing the metadata is tricky as well. You need to do a q-pointer. Ray will explain. UV stage SE...

openpath "MyDir" to MyDir else stop delete MyDir, "Filename" else stop You can do this in a routine. I would suggest you do some error logic instead of using "stop" or Ray will be upset. I would pass the directory and filename as arguments. You could also do this in job control ...

Nice. Thanks.

I would use a shell script. I think it would be easier. You could also do this in routine. You can open any directory with "openpath".

I received this email and thought others may benefit from my answer. This routine has been posted on this site, ADN and my tips page. If you cannot find it then I will post it again. Gaurav DsMetadataId is the ID of DS_METADATA. So you will need to import your table definitions. If you know how to S...

Please post your solution.

I did a search for DSGetJobInfo and got 236 hits. Lots with code in them.

This may help: http://www.dsxchange.com/viewtopic.php?t=84630

Also

http://www.dsxchange.com/viewtopic.php?t=85329

If you want to extract all the columns using a DataStage job then download DsRepository.zip on my tips page. There are dsx files in there and some setup work to make of it work but the next time you have this issue then you can get an answer a lot quicker.

If you use Reporting Assistant then the table is DSColumns.