1
  • QMQRY!

    How can we run multiple select/update query via a single QMQRY?

    sgautam11105 pointsBadges:
  • CL/QMQRY

    i hav code   STRQMQRY QMQRY(SQLPROC) OUTPUT(*OUTFILE) + OUTFILE(QTEMP/SQLDT)   In SQLProc txt file i am callin a sql procedure , developed using i series navigator and return data set using cursor. i want this cursor output in qtemp/sqldt file. in sqlproc if i mentioned SELECT statment , then it...

    Sanashakeel15 pointsBadges:
  • passing variable in CL Program using QMQRY and SQL

    Hi, I'm setting up a process where I can add or delete a record in a physical file. I'm using a simple CL program that runs a couple QM Queries. QMQRY - REVEALADD INSERT INTO mylib/myfile (myfile) VALUES(user) QMQRY - REVEALDLT DELETE FROM mylib/myfile WHERE myfile = '&USER' CL code...

    Bggas400160 pointsBadges:
  • qmqry error – Help!

    Can anyone help? I have a clp application that calls a qmqry which reads a large sales transaction file and selects and creats a small summary file of certain transactions for a certain typpe of part and date range. This sales transaction file is journaled and the file it creates becomes journaled?...

    Lnspgm15 pointsBadges:
  • qmqry outfile

    I have a qmqry that we have had running in production for awhile with no problem. It is called from a cl. We create one workfile and then the second works with this file and joins to another creating a outfile in qtemp which we e-mail to user. This is the type of error we are getting now. >...

    Lnspgm15 pointsBadges:
  • Forcing AS/400 query data to respect original data order

    000012   FROM      DISACTDTA1/COGJREP T02,  000013             DISACTDTA1/COGKREP T01,  000014             DISACTDTA1/COCXREP T04,  000015             DISACTDTA1/COGDREP T03,  000016             SATACTDTA1/FINURED T05  000017  ...

    AS400 - Ask the Expert485 pointsBadges:
  • not a valid Query Management variable.

    Hi, can someone please help me, I am trying to use the QMQRY function to run an update statement. I pass it a variable from the program. Get the following error. is not a valid Query Management variable. Error found on STRQMQRY command. Function check. CPF0001 unmonitored by PGMFCTSEC at statement...

    Pmh5 pointsBadges:
  • Display “No records found” in a QMQRY

    I have a QMQRY that selects data from several files using left joins. Based on my "where" clause there is a possibility that no records will be selected. In this case, I want to be able to print "NO RECORDS FOUND" on the report. I have not been able to figure out how to get that text to print on...

    Curly5 pointsBadges:
  • QMQRY not a valid Query Management variable.

    Hi there, I am trying to pass parameters to QMQRY but get the following error. CALL PGM(JCCSTREP2) PARM(C165) 'C165' is not a valid Query Management variable. Error found on STRQMQRY command. CPF0001 received by JCCSTREP2 at 2800. (C D I R) the CL pgm that call the query is as follows: PGM...

    NormFeile25 pointsBadges:
  • Problem in CCSID converting

    I have a QM query that forms up a DB file. A physical file. A file that afterwards will be tranferred to the excel worksheet. All the source DB files (as well as all the records inside) that I use in the QM query are having the CCSID=297 (french). But the data itself stored in these DB files...

    Proturborandza25 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following