× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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 thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.