Re: Blobs - Now is Field Reference File

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxx>]

Rob Berendt wrote:
> 
> What clause would I use on a CREATE TABLE command to access these
> UDF's?  Are these promptable when using the CREATE TABLE command
> from within STRSQL?

First you create the UD Field as a distinct type:

CREATE DISTINCT TYPE MONEY AS DECIMAL(15,2)

Then in the create table, you specify the type as MONEY:

CREATE TABLE DOLLARS (AMOUNT MONEY, WHEN TIMESTAMP)

Done.

-- 
===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified AS/400 Professional System Administrator
 -- IBM Certified AS/400 Professional Network Administrator

"The sum of all human knowledge is a fixed constant.
    It's the population that keeps growing!"
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---