Re: Question on using variables in a SQL script

[VERNON HAMBERG Owner <vhamberg@xxxxxxxxxxxxxxx>]

Good to hear it worked!


Cheers
Vern


On Fri, 27 Oct, 2023 at 12:43 PM, a4g atl <a4ginatl2@xxxxxxxxx> wrote:
 

To: midrange systems technical discussion

Vern, thanks, that worked. I also found SET VARIABLE = (Select...) worked.

Thank you. Darryl.


On Fri, Oct 27, 2023 at 1:14 PM VERNON HAMBERG Owner via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>> wrote:

> Hi Darryl
>
>
> I recommend using VALUES INTO - such as this, assuming testvalue is
> created - used this -
>
>
> create variable testvalue char(10);
>
>
> The SELECT statement has to return a single row
>
>
> values (select min(state) from qiws/qcustcdt) into testvalue;
>
>
> That worked - what SQLCOD or SQLSTATE are you getting? Or what SQLxxxx
> message is in your job log?
>
>
> Cheers
> Vern
>
>
> On Fri, 27 Oct, 2023 at 12:05 PM, a4g atl <a4ginatl2@xxxxxxxxx<mailto:a4ginatl2@xxxxxxxxx>> wrote:
>
>
> To: midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>
>
> I am writing a SQL script that retrieves an order number from the order
> header file filtered by BOL. The next statement uses the order number to
> retrieve data from another file.
>
> I have
> - used CREATE VARIABLE
> - Select Order into VARIABLE from table
>
> The select fails and will not populate the VARIABLE field.
>
> How do I achieve this?
>
> TIA, Darryl Freinkel.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx><mailto:
> MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx>>
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx><mailto:
> MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>>
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx><mailto:
> support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx>> for any subscription related questions.
>
> .
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx>
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx> for any subscription related
> questions.