Hi,

Any examples for Runqry examples for list,value range etc.

Thanks...

Jerry

Here are a couple of examples




Hope this helps some - Rich

Hi,

Any examples for Runqry examples for list,value range etc.

Thanks...

Thanks and what about other "value,like eq,ne etc. Examples "  any IBM I documents link for the same ?

Thanks..

Jerry

Here are a couple of examples




Hope this helps some - Rich

Hi,

Any examples for Runqry examples for list,value range etc.

Thanks...

You can always use F1 to get more help when you are in the RUNQRY Record Selection. Put your cursor on the VALUE field, press F1 - and you'll see examples of how to do things. For details on ALL THINGS QRY/400 - see Query for i5/OS V6R1

Thanks and what about other "value,like eq,ne etc. Examples "  any IBM I documents link for the same ?

Thanks..

Jerry

Here are a couple of examples




Hope this helps some - Rich

Hi,

Any examples for Runqry examples for list,value range etc.

Thanks...

Thanks,

Let's  say field1 from file1 having multiple values and j Wan to filter records based on these multiple values then using RUNQRY how can i select such records here any example for the same please?

Thanks...

Original Message:
Sent: Thu February 27, 2025 08:12 AM
From: Rich Malloy
Subject: Runqry examples for list,value range etc.

You can always use F1 to get more help when you are in the RUNQRY Record Selection. Put your cursor on the VALUE field, press F1 - and you'll see examples of how to do things. For details on ALL THINGS QRY/400 - see Query for i5/OS V6R1

------------------------------
Rich Malloy
Principal Systems Engineer - IBMi
Cox Automotive
Draper UT

Original Message:
Sent: Thu February 27, 2025 01:22 AM
From: jerry ven
Subject: Runqry examples for list,value range etc.

Thanks and what about other "value,like eq,ne etc. Examples "  any IBM I documents link for the same ?

Thanks..

Original Message:
Sent: Wed February 26, 2025 08:59 AM
From: Rich Malloy
Subject: Runqry examples for list,value range etc.

Jerry

Here are a couple of examples




Hope this helps some - Rich

------------------------------
Rich Malloy
Principal Systems Engineer - IBMi
Cox Automotive
Draper UT

Original Message:
Sent: Wed February 26, 2025 04:02 AM
From: jerry ven
Subject: Runqry examples for list,value range etc.

Hi,

Any examples for Runqry examples for list,value range etc.

Thanks...

------------------------------
jerry ven
------------------------------

Jerry - That was the first example I gave you. It shows selecting values using a LIST for a field.  You had wanted to have documentation on QRY/400...I gave you a link for it...Did you read the PDF or try searching for what you are asking.  Your answer is on page 95-96. 

------------------------------
Rich Malloy
Principal Systems Engineer - IBMi
Cox Automotive
Draper UT

Original Message:
Sent: Tue March 04, 2025 03:13 AM
From: jerry ven
Subject: Runqry examples for list,value range etc.

Thanks,

Let's  say field1 from file1 having multiple values and j Wan to filter records based on these multiple values then using RUNQRY how can i select such records here any example for the same please?

Thanks...

Original Message:
Sent: Thu February 27, 2025 08:12 AM
From: Rich Malloy
Subject: Runqry examples for list,value range etc.

You can always use F1 to get more help when you are in the RUNQRY Record Selection. Put your cursor on the VALUE field, press F1 - and you'll see examples of how to do things. For details on ALL THINGS QRY/400 - see Query for i5/OS V6R1

------------------------------
Rich Malloy
Principal Systems Engineer - IBMi
Cox Automotive
Draper UT

Original Message:
Sent: Thu February 27, 2025 01:22 AM
From: jerry ven
Subject: Runqry examples for list,value range etc.

Thanks and what about other "value,like eq,ne etc. Examples "  any IBM I documents link for the same ?

Thanks..

Original Message:
Sent: Wed February 26, 2025 08:59 AM
From: Rich Malloy
Subject: Runqry examples for list,value range etc.

Jerry

Here are a couple of examples




Hope this helps some - Rich

------------------------------
Rich Malloy
Principal Systems Engineer - IBMi
Cox Automotive
Draper UT

Original Message:
Sent: Wed February 26, 2025 04:02 AM
From: jerry ven
Subject: Runqry examples for list,value range etc.

Hi,

Any examples for Runqry examples for list,value range etc.

Thanks...

------------------------------
jerry ven
------------------------------

Ok, Thanks.

So using RUNQRY can we do almost all the things which can be done using SQL queries inside STRSQL Session ?

Thanks...

Jerry - That was the first example I gave you. It shows selecting values using a LIST for a field.  You had wanted to have documentation on QRY/400...I gave you a link for it...Did you read the PDF or try searching for what you are asking.  Your answer is on page 95-96. 

------------------------------
Rich Malloy
Principal Systems Engineer - IBMi
Cox Automotive
Draper UT

Original Message:
Sent: Tue March 04, 2025 03:13 AM
From: jerry ven
Subject: Runqry examples for list,value range etc.

Thanks,

Let's  say field1 from file1 having multiple values and j Wan to filter records based on these multiple values then using RUNQRY how can i select such records here any example for the same please?

Thanks...

Original Message:
Sent: Thu February 27, 2025 08:12 AM
From: Rich Malloy
Subject: Runqry examples for list,value range etc.

You can always use F1 to get more help when you are in the RUNQRY Record Selection. Put your cursor on the VALUE field, press F1 - and you'll see examples of how to do things. For details on ALL THINGS QRY/400 - see Query for i5/OS V6R1

------------------------------
Rich Malloy
Principal Systems Engineer - IBMi
Cox Automotive
Draper UT

Original Message:
Sent: Thu February 27, 2025 01:22 AM
From: jerry ven
Subject: Runqry examples for list,value range etc.

Thanks and what about other "value,like eq,ne etc. Examples "  any IBM I documents link for the same ?

Thanks..

Original Message:
Sent: Wed February 26, 2025 08:59 AM
From: Rich Malloy
Subject: Runqry examples for list,value range etc.

Jerry

Here are a couple of examples




Hope this helps some - Rich

------------------------------
Rich Malloy
Principal Systems Engineer - IBMi
Cox Automotive
Draper UT

Original Message:
Sent: Wed February 26, 2025 04:02 AM
From: jerry ven
Subject: Runqry examples for list,value range etc.

Hi,

Any examples for Runqry examples for list,value range etc.

Thanks...

------------------------------
jerry ven
------------------------------

I don't know that I would go "that far" but if all you're interested in is selecting records from one or more files and putting the result set into an OUTFILE, Printer, or Display - then yes, you can use RUNQRY all day long for that, but..at some point..you  may want to learn how to either use SQL or at least use Query Manager Queries instead of using QRY/400

 System i: Query Management Programming

Ok, Thanks.

So using RUNQRY can we do almost all the things which can be done using SQL queries inside STRSQL Session ?

Thanks...

Jerry - That was the first example I gave you. It shows selecting values using a LIST for a field.  You had wanted to have documentation on QRY/400...I gave you a link for it...Did you read the PDF or try searching for what you are asking.  Your answer is on page 95-96. 

------------------------------
Rich Malloy
Principal Systems Engineer - IBMi
Cox Automotive
Draper UT

Original Message:
Sent: Tue March 04, 2025 03:13 AM
From: jerry ven
Subject: Runqry examples for list,value range etc.

Thanks,

Let's  say field1 from file1 having multiple values and j Wan to filter records based on these multiple values then using RUNQRY how can i select such records here any example for the same please?

Thanks...

Original Message:
Sent: Thu February 27, 2025 08:12 AM
From: Rich Malloy
Subject: Runqry examples for list,value range etc.

You can always use F1 to get more help when you are in the RUNQRY Record Selection. Put your cursor on the VALUE field, press F1 - and you'll see examples of how to do things. For details on ALL THINGS QRY/400 - see Query for i5/OS V6R1

------------------------------
Rich Malloy
Principal Systems Engineer - IBMi
Cox Automotive
Draper UT

Original Message:
Sent: Thu February 27, 2025 01:22 AM
From: jerry ven
Subject: Runqry examples for list,value range etc.

Thanks and what about other "value,like eq,ne etc. Examples "  any IBM I documents link for the same ?

Thanks..

Original Message:
Sent: Wed February 26, 2025 08:59 AM
From: Rich Malloy
Subject: Runqry examples for list,value range etc.

Jerry

Here are a couple of examples




Hope this helps some - Rich

------------------------------
Rich Malloy
Principal Systems Engineer - IBMi
Cox Automotive
Draper UT

Original Message:
Sent: Wed February 26, 2025 04:02 AM
From: jerry ven
Subject: Runqry examples for list,value range etc.

Hi,

Any examples for Runqry examples for list,value range etc.

Thanks...

------------------------------
jerry ven
------------------------------

Let's  say we need to select all the distinct values for a field using this RUNQRY then how to get such records ? Like we get in SQL : Select distinct(field name) from file name.

Thanks...

I don't know that I would go "that far" but if all you're interested in is selecting records from one or more files and putting the result set into an OUTFILE, Printer, or Display - then yes, you can use RUNQRY all day long for that, but..at some point..you  may want to learn how to either use SQL or at least use Query Manager Queries instead of using QRY/400

 System i: Query Management Programming

Ok, Thanks.

So using RUNQRY can we do almost all the things which can be done using SQL queries inside STRSQL Session ?

Thanks...

Jerry - That was the first example I gave you. It shows selecting values using a LIST for a field.  You had wanted to have documentation on QRY/400...I gave you a link for it...Did you read the PDF or try searching for what you are asking.  Your answer is on page 95-96. 

------------------------------
Rich Malloy
Principal Systems Engineer - IBMi
Cox Automotive
Draper UT

Original Message:
Sent: Tue March 04, 2025 03:13 AM
From: jerry ven
Subject: Runqry examples for list,value range etc.

Thanks,

Let's  say field1 from file1 having multiple values and j Wan to filter records based on these multiple values then using RUNQRY how can i select such records here any example for the same please?

Thanks...

Original Message:
Sent: Thu February 27, 2025 08:12 AM
From: Rich Malloy
Subject: Runqry examples for list,value range etc.

You can always use F1 to get more help when you are in the RUNQRY Record Selection. Put your cursor on the VALUE field, press F1 - and you'll see examples of how to do things. For details on ALL THINGS QRY/400 - see Query for i5/OS V6R1

------------------------------
Rich Malloy
Principal Systems Engineer - IBMi
Cox Automotive
Draper UT

Original Message:
Sent: Thu February 27, 2025 01:22 AM
From: jerry ven
Subject: Runqry examples for list,value range etc.

Thanks and what about other "value,like eq,ne etc. Examples "  any IBM I documents link for the same ?

Thanks..

Original Message:
Sent: Wed February 26, 2025 08:59 AM
From: Rich Malloy
Subject: Runqry examples for list,value range etc.

Jerry

Here are a couple of examples




Hope this helps some - Rich

------------------------------
Rich Malloy
Principal Systems Engineer - IBMi
Cox Automotive
Draper UT

Original Message:
Sent: Wed February 26, 2025 04:02 AM
From: jerry ven
Subject: Runqry examples for list,value range etc.

Hi,

Any examples for Runqry examples for list,value range etc.

Thanks...

------------------------------
jerry ven
------------------------------

Let's  say we need to select all the distinct values for a field using this RUNQRY then how to get such records ? Like we get in SQL : Select distinct(field name) from file name.

Thanks...

I don't know that I would go "that far" but if all you're interested in is selecting records from one or more files and putting the result set into an OUTFILE, Printer, or Display - then yes, you can use RUNQRY all day long for that, but..at some point..you  may want to learn how to either use SQL or at least use Query Manager Queries instead of using QRY/400

 System i: Query Management Programming

Ok, Thanks.

So using RUNQRY can we do almost all the things which can be done using SQL queries inside STRSQL Session ?

Thanks...

Jerry - That was the first example I gave you. It shows selecting values using a LIST for a field.  You had wanted to have documentation on QRY/400...I gave you a link for it...Did you read the PDF or try searching for what you are asking.  Your answer is on page 95-96. 

------------------------------
Rich Malloy
Principal Systems Engineer - IBMi
Cox Automotive
Draper UT

Original Message:
Sent: Tue March 04, 2025 03:13 AM
From: jerry ven
Subject: Runqry examples for list,value range etc.

Thanks,

Let's  say field1 from file1 having multiple values and j Wan to filter records based on these multiple values then using RUNQRY how can i select such records here any example for the same please?

Thanks...

Original Message:
Sent: Thu February 27, 2025 08:12 AM
From: Rich Malloy
Subject: Runqry examples for list,value range etc.

You can always use F1 to get more help when you are in the RUNQRY Record Selection. Put your cursor on the VALUE field, press F1 - and you'll see examples of how to do things. For details on ALL THINGS QRY/400 - see Query for i5/OS V6R1

------------------------------
Rich Malloy
Principal Systems Engineer - IBMi
Cox Automotive
Draper UT

Original Message:
Sent: Thu February 27, 2025 01:22 AM
From: jerry ven
Subject: Runqry examples for list,value range etc.

Thanks and what about other "value,like eq,ne etc. Examples "  any IBM I documents link for the same ?

Thanks..

Original Message:
Sent: Wed February 26, 2025 08:59 AM
From: Rich Malloy
Subject: Runqry examples for list,value range etc.

Jerry

Here are a couple of examples




Hope this helps some - Rich

------------------------------
Rich Malloy
Principal Systems Engineer - IBMi
Cox Automotive
Draper UT

Original Message:
Sent: Wed February 26, 2025 04:02 AM
From: jerry ven
Subject: Runqry examples for list,value range etc.

Hi,

Any examples for Runqry examples for list,value range etc.

Thanks...

------------------------------
jerry ven
------------------------------