Missing Job Names in DSODB...

kaps · Post by **kaps** » Mon Jun 18, 2012 11:37 am

SELECT R.JOBID, J.JOBNAME, RUNSTARTTIMESTAMP, RUNENDTIMESTAMP,  ELAPSEDRUNSECS, RUNMAJORSTATUS, TOTALROWSCONSUMED, TOTALROWSPRODUCED
FROM
"DSODB"."JOBEXEC" J,
"DSODB"."JOBRUN" R
WHERE
R.JOBID = J.JOBID
AND J.JOBNAME = 'MyJob'

When I execute the above SQL, I get all the columns except Job Name. Why is it not printing just the Job NAme ? Am I missing something here ?

Thanks

kaps · Post by **kaps** » Wed Jun 20, 2012 8:58 am

I am not asking for fast response here but just wondering if I explained my question properly...Does anyone else have the issue or is it just on my side ?

Thanks for your time...

chulett · Post by **chulett** » Wed Jun 20, 2012 9:57 am

Your question is fine, it's just that I for one have no idea what the answer might be. I thought the name of the job was only in the DSJOB table as the NAME field, I'm not familiar with the gory details of the JOBRUN and JOBEXEC tables. If your filter is working it must be present there in some fashion, however.

Hopefully one of the Universe experts like Ray or Kim will know the why of it...

kaps · Post by **kaps** » Wed Jun 20, 2012 12:25 pm

Found the issue...'Job Name' column is defined as vargraphic data type so the query tool I was using was not able to display it. I converted to char and it works now...

Thanks...

chulett · Post by **chulett** » Wed Jun 20, 2012 1:20 pm

Vargraphic? That's... interesting. Glad you figured it out.

ray.wurlod · Post by **ray.wurlod** » Wed Jun 20, 2012 4:48 pm

All keys in XMETA, XMETASR and DSODB are defined as VARGRAPHIC. (At least when DB2 is used.)

chulett · Post by **chulett** » Wed Jun 20, 2012 5:49 pm

... just had to go google up what exactly a "VARGRAPHIC" field might be. Not something I've run across before.