× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Murali:

1)  YOU ARE POSTING TO THE WRONG LIST - USE MIDRANGE-L@MIDRANGE.COM

2)  You need to do more research before asking questions like this.  Please
search the midrange-l archives OR go the IBM web site
(http://as400bks.rochester.ibm.com)
and look up the CPYF command and the CRTDUPOBJ commands and see the
parameters available.  You might also try prompting the commands and READ
THE HELP TEXT.

3) I don't mind helping you out, but you need to help yourself before you
start asking questions like this....


----- Original Message -----
From: "MURALI DHAR" <nmuralidhar@rediffmail.com>
To: <rpg400-l@midrange.com>
Sent: Thursday, September 05, 2002 11:35 AM
Subject: copyfile and create duplicate object


> 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/
>
> _______________________________________________
> 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.
>


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.