× 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.



Why does this:

CREATE TABLE QTEMP/TESTF (TESTFIELD INTEGER)

display this in DSPFFD:
            Data        Field  Buffer   Buffer
 Field      Type       Length  Length Position
 TESTFIELD  BINARY       9  0       4        1

And this in the compile listing:

*--------------------------------------------------
* RPG record format  . . . . :  X
* External format  . . . . . :  TESTF : QTEMP/TESTF
*--------------------------------------------------
4=I (ALWNULL)                   B    1    4 0TESTFIELD

Also,
 a standalone binary field:
BINFIELD          B(9,0)

 a standalone integer field:
INTFIELD          I(10,0)

 the integer field from the table:
TESTFIELD         P(9,0)

It's no wonder there is confusion about this.

Phil

>
> This means that you can't use the full (integer)
> size of the field - big
> binary numbers get truncated.
>   --buck


__________________________________________________
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
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.