Open query file - IBM AS400

This is a discussion on Open query file - IBM AS400 ; How can I do a select by a range or a list with in open query file?...

+ Reply to Thread
Results 1 to 2 of 2

Thread: Open query file

  1. Open query file

    How can I do a select by a range or a list with in open query file?

  2. Re: Open query file

    eknight wrote:
    > How can I do a select by a range or a list with in open query file?


    List of values:
    opnqryf file(mylib/myfile) qryslt('field1 = %values("value1" "value2"
    .... "valuen")')


    Range of values:
    opnqryf file(mylib/myfile) qryslt('field1 = %range("lowvalue" "highvalue")')

+ Reply to Thread