DSXchange

Please do Alt-C around your code to save formating. You will need to add the EVAL to your WITH clause. Here is the SQL: select @ID, TIMESTAMP, SEVERITY, EVAL "@RECORD<7>" AS INSTANCE_NAME, FULL.TEXT from RT_LOG657 where EVAL "@ID" NOT LIKE '//%' AND INSTANCE_NAME = 'Load1Telecast...

Craig

That is the correct one. I wrote a wrapper for it to do all jobs or all jobs in a category called KgdGenHtml. It will also do routines. It is on ADN and my tips page.

Here it is http://www.dsxchange.com/viewtopic.php?t=87241

Craig

Ken Bland posted one somewhere.

How are getting the log for a regular job? Post your code.

Siva

Nice signature.

I want to make sure people understand you can use these queries in a job. You need to use a UV stage instead of a hash file. You may need to put the SQL all on one line. I noticed I could not execute a multiple line SQL statement in BASIC. Try it and let us know. I would love it if someone would tak...

Michael Here it is: select DS_JOBS.NAME AS JOB_NAME FMT '35L', DS_JOBS.CATEGORY, DS_JOBOBJECTS.NAME AS LINK_NAME FMT '35L', EVAL DS_JOBOBJECTS."IF OLETYPE = 'CODBCInput' THEN @RECORD<23> ELSE ''" AS ARRAYSIZE FMT '8R', EVAL DS_JOBOBJECTS."IF OLETYPE = 'CODBCInput' THEN @RECORD<22> ELS...

Thanks a lot. This got flipped on me. I tried to trick Ray into doing all this work but once again Michael is too smart for me.

I will figure it out latter.

If you LIST DICT DS_JOBS then you can see the published fields in DS_JOBS. This is the equivilent of DESCRIBE in Oracle. Most of what you want is hidden. Ex-employees of ASCL have access to what these fields are and what they do but the rest of us have learned the hard way by hacking into the data. ...

The instance id is a field in the RT_LOG file.

Michael Where are array size and transaction size stored in ODBC? For custom stages: select DS_JOBS.NAME AS JOB_NAME FMT '35L', DS_JOBS.CATEGORY, DS_JOBOBJECTS.NAME AS LINK_NAME FMT '35L', EVAL DS_JOBOBJECTS."IF @RECORD<13,7> = 'ARRAYSIZE' THEN @RECORD<14,7> ELSE IF @RECORD<14,6> = 'ARRAYSIZE' ...

You will need to get your JOBNO but here is the SQL: select TIMESTAMP, SEVERITY, FULL.TEXT from RT_LOG1370 where EVAL "@ID" NOT LIKE '//%' AND @ID > CAST(EVAL "FIELD(TRANS('RT_LOG1370','//JOB.STARTED.NO',1,'X'), @SVM, 1)" AS DECIMAL) order by TIMESTAMP ;

You can use ExecSH or execute. In a routine



The variable Output has what would of went to the screen. RtnValue is the exit code of the Perl script.

Good luck. I doubt if Ray could get all that easily. Job and category are easy. They are already been posted. Do a search. I am sure some of the rest may be in Reporting Assistant or MetaStage. JobReport may pull that out as well. I would almost think an XML export or using Perl against the DSX file...