Re: RE: Int Size

["MURALI DHAR" <nmuralidhar@xxxxxxxxxxxxxx>]

Can you please differentiate btw create duplicate object and copy
file...Can we get only selected records by using copyfile
command(Is there any possibility)?where this create duplicate
object will be used?
Thanks for the earlier answers ..Iam thankful to you..
Murali

On Thu, 05 Sep 2002 Buck Calabro wrote :
> >If I create a table with a SMALLINT it is
> >shown as being defined as being 4 digits long.
> >I can insert a 5 digit long number via SQL
> >but RPG does not support this length of data.
>
> Use h extbinint.  This works for me on V5R1 compiled
> TGTRLS(V4R4).
>
> Test environment:
>
> strsql
>   CREATE TABLE SQLTABLE (SMALLINT SMALLINT
>     INT INT, BIGINT BIGINT, FLOAT FLOAT,
>     CHARFLD CHAR (10 ), NUMERIC NUMERIC (11 , 2),
>     DECIMAL DECIMAL (11 , 2)
>   insert into sqltable values(12345,12345,12345,
>     12345,'12345',12345,12345)
>
> dspffd sqltable
>              Data        Field
>   Field      Type       Length
>   SMALLINT   BINARY       4  0
>   INT        BINARY       9  0
>   BIGINT     BINARY      18  0
>   FLOAT      FLTDBL      16 15
>   CHARFLD    CHAR           10
>   NUMERIC    ZONED       11  2
>   DECIMAL    PACKED      11  2
>
> rpg program included I specs
>   B    1    2 0SMALLINT
>   B    3    6 0INT
>   I    7   14 0BIGINT
>   F   15   22  FLOAT
>   A   23   32  CHARFLD
>   S   33   43 2NUMERIC
>   P   44   49 2DECIMAL
>
> I presume that RPG IV includes these fields as 'B' datatype for
> backward
> compatibility with RPG III unless the header option extbinint is
> specified,
> in which case they are typed as
>
> I    1    2 0SMALLINT
> I    3    6 0INT
> I    7   14 0BIGINT
> F   15   22  FLOAT
> A   23   32  CHARFLD
> S   33   43 2NUMERIC
> P   44   49 2DECIMAL
>
>   --buck
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L)
> mailing list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
__________________________________________________________
Give your Company an email address like
ravi @ ravi-exports.com.  Sign up for Rediffmail Pro today!
Know more. http://www.rediffmailpro.com/signup/