DSXchange

If you cannot get it done then I will add it to EtlStats soon.

You need to create UV stage and use the dictionary items in this thread http://www.dsxchange.com/viewtopic.php? ... ght=JobAct

This file has been in my downloads directory for a while now but there was no link on my tips page until yesterday. Sorry Craig. Craig, let me know if there are other links needed.

Sorry but wouldn't it be better if you knew these emails are real? Maybe someone has done this. If you email then you should get a return saying undeliverable. Has anybody figured out how to process this? This is taking this issue to the next level. If you have an email address that is kim@hotmail.c...

Passing is 75% of the points allowed. The questions do not all have the same point value.

Ray is correct. I think if you have warnings because the database complained about an insert or update. I do not care about metadata mismatches because of some shared container being setup wrong. I won't the database issue to finish with warnings and the sequence to stop but I do not want the sequen...

Can anybody validate this further or if you email these then tell me which ones failed?

Ray, isn't there a parameter you can set at the project level which can tell DataStage to ignore these types of warnings?

Ray has gone from Full Wurlods to Full Groaners.

Geez, Craig they were in my downloads folder but there was no link on my tips page. There is now. I hope nobody minds me giving these out. They look pretty valuable.

Okay it is a hack. How else can you do this? The only other way is to recompile this job.

There is also a Perl script which someone posted to split a full export into one per job. I think it is called DsxParse.pl.

I posted some new scripts on the 2 links below my sig. The new script was DataStageExport.bat. Do a search for this. Basically it requires a JobList.txt file to be setup in a folder with the project name. This list of jobs will get exported one at a time. There is a similar command for importing the...

To integrate this information into EtlStats then you would need to read fields these directly. That would be difficult plus it will break on version 8 but it might be useful in the mean time. I extracted a lot of this information because of Parameter Navigator or PNav for short. When you take a proj...

I forgot. You asked about instance ids. INSERT INTO DICT DS_JOBOBJECTS ( FIELD, CODE, EXP, NAME, FORMAT, SM ) VALUES ( 'JobAct2JobAct2InstanceIdsCount', 'I', 'field(@RECORD<14>, "/", 2)', 'JobAct2JobAct2InstanceIdsCount', '3R', 'S' ) ; INSERT INTO DICT DS_JOBOBJECTS...