1
  • Passing variables from CL to QMQRY

    Hi, I have a CL that get parameter and run QMQRY. When I run it, I get a prompt: "Type a value for variable "x" and press enter". Why I get it even though I pass the parameter? The CL: " PGM PARAM(&X) DCL VAR(&X) TYPE(*CHAR) LEN(8) STRQMQR QMQR(LIB1/QRY1) OUTPUT(*OUTFILE)...

    felixb95 pointsBadges:
  • Edit codes using Strqmqry

    I am passing a date field to a query via strqmqry command. However, my numeric edit codes are not what I defined them in the query definition. Seems a default code for numerics is used. What am I doing wrong?

    Fonz15 pointsBadges:
  • STRQMQRY

    If you use a CLP to pass parameters to a STRQMQRY command. How do you disable prompting this command.

    sorella85 pointsBadges:
  • How can I retrieve the source of a STRQMQRY?

    In my CL program I have a STRQMQRY. How can I get the source file name were this QMQRY resides?

    RamvishakRamesh2,505 pointsBadges:
  • Storing a date as *mdy from an *outfile when executing strqmqry

    I have a date coming in to a query in *iso format. when I put it into a date field it comes back as y/m/d despite the fact my datfmt is set to *mdy

    matis75 pointsBadges:
  • AS/400 SQL Procedure call from CL program

    I am calling an SQL stored procedure (counts records for a value) from a CL program. I want to send the value to compare to the CL SQL pricedure and get back the count. How do I define the count variable (&COUNT ?) in the CL program? I am using STRQMQRY to call.

    Burmanr10 pointsBadges:
  • STRQMQRY: The variable should appear without quotes

    In my cl the strqmqry I am passing 2 variables that are character but should be numeric when the query runs.............now they have the quotes around them.................how do I get the quotes out of there so they are treated as numeric????

    Harrigan5 pointsBadges:
  • STRQMQRY require compile if add new field

    I add field to a physical file, should i compile the STRQMQRY source, although inside STRQMQRY don’t use the new field. I test STRQMQRY old object, can run on in amend physical file. I juz want to double confirm from expert.

    Felixmaskx5 pointsBadges:
  • Qry Mgmt losing edit word specs

    My 400 query has edit words specified for proper printing of the dates in my report, but I am passing parameters to select the correct data using STRQMQRY. My output is ignoring the edit words specified in the query

    smKny5 pointsBadges:
  • STRQMQRY in batch on i5

    Can STRQMQRY be run in batch? I am getting error message: Global variable prompting is not allowed in batch mode. I am passing 2 parameters from a display screen

    TOASTY35 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:
  • trapping an empty dataset on strqmqry

    I used strqmqry to select records from a database file. i provide selection criteria. sometimes the query returns with no records. if no records are returned i want to bypass the display and end the program. if records are returned i want to bypass any display and call another program. how can i do...

    matis75 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:
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.

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

Following