Display one of the selected fields in the spool(in Sysout

patriot · New User Joined: 01 Dec 2006 Posts: 8 Location: chennai

I am using a card which has the select query and my jcl takes that card as input and runs. Now i have to display one of the selected fields in the spool(in Sysout). Is it possible?

murmohk1 · Posted: Wed Mar 14, 2007 3:52 pm

I dint your get post properly. But this may help you.

Does your JCL is creating OP file? If yes, replace the OP dsn=..... with sysout=*.

patriot · New User Joined: 01 Dec 2006 Posts: 8 Location: chennai

Thanks.But the following select query is an example to print the selected field into spool or O/P file:
SELECT '===RECORDS BEFORE '
|| CHAR(DATE(CURRENT_DATE - 396 DAY))
|| ' WERE DELETED=== ' FROM SYSIBM.SYSDUMMY1;

The O/P display in ur sysout/File will be:
===RECORDS BEFORE 02/11/2006 WERE DELETED===

William Thompson · Posted: Wed Mar 14, 2007 5:21 pm