Hi all,
in our project we want to know which (source) version of a parallel or sequence job has carried out some data transformation. I can't find this information in the standard logging (via Director), is it available somewhere? Thanks in advance for any answer.
Paul Mulder
SELECT NAME, EVAL "@RECORD<8>" AS VERSION FROM DS_JOBOBJECTS WHERE OBJTYPE = 'J' AND OBJNAME = 'ROOT' AND OBJIDNO = (SELECT JOBNO FROM DS_JOBS WHERE NAME = '<<Job Name>>') COL.SUP COUNT.SUP;
Hamzaqk,
thanks a lot for your reply. Unfortunately my XMETA repository of Datastage v8.x I use does not know these tables. I tried to figure out which of the existing tables to use instead, but got lost. Any help would be much appreciated. Gr. Paul
Thanks again, Hamzaqk, my ignorance! But executing it from DSSH issued the error: DataStage/SQL: Table "ds_jobobjects" does not exist. Wrong VOC configuration of DSSH maybe?
Two things. First LOGTO YourProject then execute PTERM CASE NOINVERT to stop a paste from inverting the case, then paste the command as posted to the command line.
-craig
"You can never have too many knives" -- Logan Nine Fingers
The local Repository is still used (in conjunction with XMETA) in version 8.0 so this query will work. As noted, the identifiers in the SQL are case sensitive.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Paste away. The PTERM command will help there. Besides, the problem was the lack of the LOGTO to the project in question, that or launch the shell from inside the project directory.
-craig
"You can never have too many knives" -- Logan Nine Fingers