1
  • AS/400 QMQRY: How to pass values at runtime

    Hi, I am trying to pass file name to a QMQRY object in a CL program at run time.I was facing some error,which I posted below. I request you to kindly go through the below code & correct me to, if I am wrong. QMQRY object:         ************ 0001.00 &SELECT      0002.00 &FIELDS...

    HABBIE820 pointsBadges:
  • AS/400 QMQRY: Table Lateral Identifier Error

    Hi, I have a file.That comprises of all the file names(Only one column).Now  I am reading this file through a RPG program & passing this file name to a QMQRY object on a CL program. On the QMQRY, I'm facing the below error, as it is not accepting the '&' symbol. These are the two programs....

    HABBIE820 pointsBadges:
  • QMQRY ERROR : FILE in *LIBL type *FILE not found

    Hi,I am trying to call the QMQRY interactively. I am facing some kind of issue,which I am unable to get through.Kindly look let me know, what does this for.This is the error from DSPJOBLOG:STRQMQRY QMQRY(MENTIS1/QMQRY102) FILE in *LIBL type *FILE not found. RUN QUERY command failed with SQLCODE...

    HABBIE820 pointsBadges:
  • QMQRY ERROR

    Hi, I am new to this technology. I coded some CL program with QMQRY. every thing goes well. Object has created. If I run manually using STRQMQRY. I can view my expected result. If I run Through a CL program , I was facing some error. Please go through the be-lowed program & its corresponding...

    HABBIE820 pointsBadges:
  • QMQRY!

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

    sgautam11110 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