RE: SQL unsigned

["Wilt, Charles" <CWilt@xxxxxxxxxxxx>]

You know, I hadn't ever tried that...


Sure enough, doesn't work and it's not in the manual.

Interesting since RPG IV does support an unsigned type.

Out of curiosity, I checked an Oracle 10g reference manual; Oracle doesn't 
support an unsigned type either.


Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of brian
> Sent: Thursday, June 23, 2005 4:34 PM
> To: rpg400-l@xxxxxxxxxxxx
> Subject: SQL unsigned
> 
> 
> Is 'unsigned' missing? I need a two-byte unsigned column, so 
> I was going
> to use SMALLINT UNSIGNED, but I can't seem to. I know I could 
> use INT and
> a constraint, but ..
> -- 
> This is the RPG programming on the AS400 / iSeries (RPG400-L) 
> mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
> 
>