Re: Constant and SQL (in SQLRPG)

["Alan Cassidy" <acassidy@xxxxxxxxxxxxxxxxx>]

I like having constants to use but see them as useful when the name the same
or almost so as the value.

Early on, I got used to simply defining them as variables anyway, with
INZ(--value--). When you're debugging, you can go look at the D-specs, but
if it's a var you just look at the value right there to confirm the correct
value. And so can the next programmer. (I'm open to change, though).

--Alan


----- Original Message -----
From: "Simon Coulter" <shc@flybynight.com.au>
To: <rpg400-l@midrange.com>
Sent: Monday, August 19, 2002 10:43 PM
Subject: Re: Constant and SQL (in SQLRPG)


>
> Hello Michel,
>
> You wrote:
>
> >There seems to be a problem using a constant into an SQL statement in a
> >SQLRPG program. The easy solution is to use a variable instead of a
> >constant. But I'd like to know if there is a way to use a constant and
> >if not, why this is not possible.
>
> Two reasons:
>
> a) The SQL pre-compiler is a piece of junk and is very restricive
> regarding the HLL constructs it will support.
>
> b) c+        WHERE zone1 = :cst
>
> The colon (:) indicates a HOST VARIABLE which is not the same
> thing as a constant.
>
> Accept the limitations of the SQL pre-compiler and code:
>
> c+        WHERE zone1 = '001'
>
> Regards,
> Simon Coulter.
> --------------------------------------------------------------------
>    FlyByNight Software         AS/400 Technical Specialists
>    http://www.flybynight.com.au/
>
>    Phone: +61 3 9419 0175   Mobile: +61 0411 091 400        /"\
>    Fax:   +61 3 9419 0175   mailto: shc@flybynight.com.au   \ /
>                                                              X
>                  ASCII Ribbon campaign against HTML E-Mail  / \
> --------------------------------------------------------------------
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>