|
I have revised this topic on the archives but nothing on this specific point. I run my CL with my four STRQMQRY commands. I am sending parameters to Queries/400 and those are creating work files on QTEMP. If I run it interactivelly, no problem. When I submit the job to batch, the first STRQMQRY works and created the file in QTEMP. The second one uses this file and is there where I have my exmplosion: Message ID . . . . . . : QWM1201 Severity . . . . . . . : 40 Date sent . . . . . . : 08/20/02 Time sent . . . . . . : 16:40:40 Message type . . . . . : Information >From program . . . . . . . . . : QQXSNDMG From library . . . . . . . . : QSYS Instruction . . . . . . . . : 004F To program . . . . . . . . . . : QQXCPIME To library . . . . . . . . . : QSYS Instruction . . . . . . . . : 0365 Coded character set ID . . . . : 65535 Message . . . . : RUN QUERY command failed with SQLCODE -204. Cause . . . . . : The SQLCODE is -204. The SQLSTATE is 42704. The DB2 SQL OS/400 message text for this error is: FI041Q1F in QTEMP type *FILE not found. Recovery . . . : Check the job log for more information, correct the error and try the request again. I changed the queries to create the files in a work library and it worked great! Why it will not work for QTEMP? Thanks in advance! PETER VIDAL PALL Aeropower Corp. / SR Programmer Analyst Website: www.pall.com / Email: Peter_Vidal@Pall.com Phone: 727-539-8448, x2414
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.