DSXchange

Post your code again.

Change the DSLogFatal() to a DSLogInfo().

I would not use the dictionary of the VOC. You should have a better dictionary on the hash file. If that works then use it but there is a better way.

LIST DICT HashFile

The instance id is stored in 2 places. One is in the log file RT_LOGnnn. The other is in RT_STATUSnnn. You could run a SQL delete to get rid of both. I will do some research.

If I understand your question correctly then delete the lines with "Abort" on them. This will keep the main job from aborting.

Next time mark your code with the Code button and not the Quote button.

You can download all these scripts plus the jobs that use them on my tips page. DsRepository20050222.zip is the zip file with these files.

D types are dangerous for the untrained. These will only work for OLETYPE = 'ROOT'. Someone may try to update with these.

I prefer I-types plus they work for multiple OLETYPEs. I have the job to figure out most of this. I am trying to post it now but ftp is not working. Maybe tomorrow.

Are you trying to source a URL? I am not sure I understand the question.

Not sure. It maybe only on mine.

Now I can run this script or source DS_JOBOBJECTS with a UV stage in a job. select ColNames, ColDesc, ColSqlType, ColPrecision, ColScale, ColFieldPos, ColKeyPos, ColNullable, ColDerivation, ColParsedDerivation from DS_JOBOBJECTS, DS_JOBS where DS_JOBOBJECTS.OLETYPE LIKE '%Output' and DS_JOBOBJECTS.O...

Next I created all these dictionary items. INSERT INTO DICT DS_JOBOBJECTS ( FIELD, CODE, EXP, NAME, FORMAT, SM, ASSOC ) VALUES ( 'ColDerivation', 'I', '@RECORD<(IF TRANS("EtlOleTypeHash",OLETYPE,1,"X") = "" THEN 999 ELSE (TRANS("EtlO...

Ray I got more. I wanted to be able to extract column names using a DataStage job and create my own job metadata. In order to do this I need to create dictionary items on DS_JOBOBJECTS. As you know this file has different record types based on the field OLETYPE. Only the OLETYPEs ending in Output wi...

Craig

If you downloaded my version then it does an UNLOCK ALL.

You need to load the tutorial. It is on the DataStage CD.

Ray

This is just a rough estimate (WAG). If you want to make it more accurate then go for it. I have never been that precise.