Re: SQL - Create table Stmt

["Wes" <destaw@xxxxxxxxxxxxxxxxxxx>]

Joe and Mark,

Thanks for your help.

Wes



"Wes" <destaw@xxxxxxxxxxxxxxxxxxx> wrote in
message news:egmfqb$uo0$1@xxxxxxxxxxxxxxxx
> I'm creating a SQL table using the follwoing SQL statment...
>
> Create table F55RULE (
> RUGROP VARCHAR(50) NOT NULL,
> RULOB VARCHAR(3),
> RULT VARCHAR(3) NOT NULL,
> RUVALR VARCHAR(1) NOT NULL,
> RUOBJS VARCHAR(6) NOT NULL,
> RUSUBS VARCHAR(8) NOT NULL,
> RUOBJE VARCHAR(6),
> RUSUBE VARCHAR(8) NOT NULL);
>
> Once the table is created though, the size of each column had been
expanded
> by 2 char...
>
> FIELD     Position    Length  D Ty. File      Libra
> RUGROP          1         52  0  A  F55RULE   QGPL
> RULOB          53          5  0  A  F55RULE   QGPL
> RULT           58          5  0  A  F55RULE   QGPL
> RUVALR         63          3  0  A  F55RULE   QGPL
> RUOBJS         66          8  0  A  F55RULE   QGPL
> RUSUBS         74         10  0  A  F55RULE   QGPL
> RUOBJE         84          8  0  A  F55RULE   QGPL
> RUSUBE         92         10  0  A  F55RULE   QGPL
>
> Does anybody know why this is?
>
> Thanks,
> Wes
>
>
>
>
>
>
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email:
MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.