RE: SQL Question

[rob@xxxxxxxxx]

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
On Rick's idea, see also PREPARE and EXECUTE.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin




"Chevalier, Rick" <Rick.Chevalier@americredit.com>
Sent by: midrange-l-admin@midrange.com
01/02/2003 12:31 PM
Please respond to midrange-l


        To:     "'midrange-l@midrange.com'" <midrange-l@midrange.com>
        cc:
        Fax to:
        Subject:        RE: SQL Question


Cyndi,

I think what you are referring to is a parameter-marker.  The iSeries
parameter-marker is '?'.  Information on parameter markers can be found in
the manual 'DB2 UDB for iSeries SQL Reference' at the IBM Information
Center.

For example:
UPDATE EMPLOYEE
SET LASTNAME = TRANSLATE(CAST(? AS VARCHAR(12)))
WHERE EMPNO = ?

Rick

 -----Original Message-----
From:            Cyndi Bradberry [mailto:CyndiB@IHFA.ORG]
Sent:            Thursday, January 02, 2003 11:08 AM
To:              'MIDRANGE-L@midrange. Com' (E-mail)
Subject:                 SQL Question

A co-worker has just asked what to use as a variable replacement character
in a select statement.  I can't find anything in any manual. Is there such
a
thing ?

For example in dos you could type DEL *.* and it would delete everything.
What do you use in SQL to imitate the * in the previous dos statement ?

Thanks,

Cyndi B.
Boise, ID
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.