RE: SQL Question

["Chevalier, Rick" <Rick.Chevalier@xxxxxxxxxxxxxxx>]

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.