1
  • 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:
  • 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:
  • 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.

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