Re: SQL Question

Jeff - are you trying to set a variable using the SQL functions? Seems you don't want to populate a file.

I'm thinking of something in the VALUES INTO range - had a post on this earlier today. A SELECT statement can be used so long as it returns a single row - you could always use something like

d hostvar s 1a

values (select case when yourfield in('1', '2') then '1' else then '0' end case from sysibm/sysdummy1) into :hostvar

Rob had the syntax for the CASE - modify this if needed.

HTH
Vern

-------------- Original message ----------------------
From: Jeff Young <cooljeff913@xxxxxxxxx>

Using SQL, is there any way to test a variable for a value and return an
indicator flag?
What I would like to do is to be able to use the SQL BIF's to test a variable
for a list of values and then return a '1' or '0' (on/off) to the program.

Thanks,


Jeff Young
Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions V5R2
IBM Certified Specialist- e(logo) server i5Series Technical Solutions Designer
V5R3
IBM Certified Specialist- e(logo)server i5Series Technical Solutions
Implementer V5R3
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.