DSXchange

I have 2 routines which will work on small sequential files because it reads the whole sequential file into one record. If you have large sequential files then you need to change this to openseq and readseq. * ----------------------------------------------------------------- * KgdParseSeqFile(Pa...

The whole section starting with if (EventType = 'Warning' or EventType = 'Fatal' or EventType = 'Error') then is not needed. I used this to pull out the column names on a metadata mismatch error. I do not use this routine in any production jobs. I use it for debuging purposes. The same is tr...

I would bet that the LD_LIBRARY_PATH needs to point to DataStage first. This path is usually pointing to Oracle first. The order is important. It usually is set in dsenv. LD_LIBRARY_PATH=$DSHOME/java/jre/lib/sparc/client:$DSHOME/java/jre/lib/s parc:`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$DSH...

Ray and others have posted the SQL to get the list of hash files. Look for OLETYPE = 'CHashInput' or 'CHashOutput'. The easiest way to create the hahs files is to validate every job. You could script this with dsjob at the UNIX level or do it in BASIC. I do not have this script written but I am sure...

Ray is talking about Reporting Assistant. It does not pick up sequences. I fixed that with DwNav. The JobReport needs some help in in getting all the pices. JobReport and DwNav both generate html documents. I added routines to JobReport and it generates an All_Index html document to link to all the ...

When you get it working then please post your solution.

You should just read the '//JOB.STARTED.NO' record and place the value in the SELECT statement. open 'RT_LOG1' to RtLog else call DsLogWarn() end read RtLogRec from RtLog, '//JOB.STARTED.NO' else RtLogRec = 0 end StartNo = RtLogRec<1> Cmd = 'SSELECT RT_LOG':JobNo:' WITH @ID >= ':StartNo:' BY...

You really need to start a new topic. This is a whole new question.

In BASIC there are 2 types of SELECT statements. One is a SQL SELECT. It has to end with a semicolon ";". The other has a syntax which does resemble a SQL statement. It has the form: SELECT MyHashFile WITH field = "VALUE" AND WITH field2 = "VALUE" fieldlist BY field1 BY field2 Th...

All the transformation routines just return Ans. Most do not write the results to a file. You would need to add that functionality. If it was me then I would write it to a hash file. I would then run a job and push the results to a table in the data warehouse. If you did this in a shell script then ...

Sorry but I think there have been several routines posted which will get row counts. These routines are included with DwNav. You can download a copy from my web site and email me for a free 30 day eval copy. Otherwise you need to do a search to get the code to do it in BASIC. RunHandle = DSAttachJob...

The uv command is the same as sqlplus for Oracle. It is the command line way to interface with the Universe database. It is also called TCL. The Universe database is owned by IBM now. You can downlaod the manuals and even the database itself on their site. Ray posts the links for all these. You can ...

Here is oen more. If you have populated ETL_JOB then it may have a bug in the KgdIsJobSequence routine. In the last few lines it sets Ans = ErrMsg. Comment this out. Compile the routine and job and rerun. Here is the SQL for listing how long each sequence ran on its last run. select LAST_RUN.JOB_NAM...

You can run these commands in Administrator but I prefer to telnet into the DataStage server and run them at TCL. Do a search this has been explained before. All you need to do is run the uv command in the DataStage server bin directory. You will need to be in the project directory. You could also u...

Another method would be to search for the job name in all other jobs. You would need to modify this SQL. SELECT DS_JOBS.NAME AS JOB_NAME, DS_JOBS.CATEGORY, DS_JOBOBJECTS.NAME AS OBJECT_NAME, DS_JOBOBJECTS.OLETYPE, EVAL DS_JOBOBJECTS."if index(upcase(@RECORD),'KGD',1) > 0 then 'F...