scottklement.com

I hope when we say ''it works without problem' then meaning was something with respect to modification of that SQL query posted in my last post :

"SELECT *
FROM TABLE(QSYS2.JOB_INFO(
JOB_STATUS_FILTER => '*ALL',
JOB_TYPE_FILTER => '*ALL',
JOB_SUBSYSTEM_FILTER => '*ALL',
JOB_USER_FILTER => '*ALL ...

Ok, I got it.

SELECT *
FROM TABLE(QSYS2.JOB_INFO(
JOB_STATUS_FILTER => '*ALL',
JOB_TYPE_FILTER => '*ALL',
JOB_SUBSYSTEM_FILTER => '*ALL',
JOB_USER_FILTER => '*ALL',
JOB_SUBMITTER_FILTER => '*ALL'
)) X;

is it something we can trim down to filter our records as this takes too much time to run ...

Ok, if we do not know why (why SQL query does not display the desired results here) is it happening then at least can we confirm that this is something which can't be captured through SQL query at all (?) so that i should not try capturing these details through SQL query way?

The reason I am ...

I mean for the jobs which are no longer active in the system just for example let's say we had a production issue 5 days back at that time all job details were there when we did DSPJOB for that job. But after 5 days if someone want to track that job details so the same details can we capture here ...

Could someone please reply?

Thanks...

yes it was 'track', sorry for typo.

i meant the jobs which i can see using DSPJOB command i can not see using sql query i mentioned and status of these jobs is in OUTQ.
and i can see their spool files when i do DSPJOB--then option 5 then option 4 to see spool file and in spool file also QPJOBLOG ...

Hi,

I simply want to tracj all failed, completed jobs using standard IBM i SQL query "SELECT * FROM TABLE(QSYS2.JOB_INFO() " but not sure why the jobs which i can see using DSPJOB command after selecting 1 then option 4 to view spool files from ther we check QPJOBLOG where we have most of the ...

Hi,

Could someone please help to answer my queries here ?

Also, could someone please help by modifying this SQL query so that I should be able to find out my job which was earlier in 'MSGW' but after providing appropriate reply to that job it was no longer in MSGW. But I want to capture all those ...

Hi,

Apart from that concatenation of the fields i want some fields to be referred from fiel1 some from fiel2 and some from file 3 likewise and these files could be sometime in same library and may be in different library plus i want to add some custom fields with my choice of data type and length ...

Ok, If i try SQL table for the same my tjis SQL query does not work:-
"CREATE TABLE NewTable AS
SELECT
Field1 AS NewField1,
Field2 AS NewField2,
Field3 AS NewField3,
CASE
WHEN Field2 <> '' THEN Field1 || Field2
ELSE Field3 || Field4
END AS ConcatenatedField
FROM File1"

any corrected version ...