Re: Constant and SQL (in SQLRPG)

["Simon Coulter" <shc@xxxxxxxxxxxxxxxxx>]

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  / \
--------------------------------------------------------------------