Announcement

Announcement Module
Collapse
No announcement yet.

Pass a parameter to a query created using WRKQRY on AS400

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Pass a parameter to a query created using WRKQRY on AS400

    This is done by using the record select (RCDSLT) parameter on the Run Query (RUNQRY) command. Dave

  • #2
    Pass a parameter to a query created using WRKQRY on AS400

    You have to save the parameter to a file. then use that file in 'specify file selections'. use a join of type 2 and enter *none the field tests. The field is now available to be used in the record selection. I do this to pass in dates to a query.

    Comment


    • #3
      Pass a parameter to a query created using WRKQRY on AS400

      I have a query which I created and saved using Query/400 on AS/400. How can I pass a parameter to this query for its Select records? For example: I want the customer Id to be passed through a CL. Is this posible? Thanks, Panayiotis Panayi Information Systems Laiki Group email: ppanayi@laiki.com

      Comment


      • #4
        Pass a parameter to a query created using WRKQRY on AS400

        You can pass the parameter by using the STRQMQRY command to execute your query. See http://faq.midrange.com/data/cache/106.html for details.

        Comment

        Working...
        X