RE: DDS specs for RPG INFDS available? plus defining Binary in DDS

[Buck Calabro <Buck.Calabro@xxxxxxxxxxxx>]

>Does anyone have the DDS specs for INFDS for
>database, printer, and display files that
>they'd be willing to share?

Both DDS and D specs have been posted to this list and the MIDRANGE-L list
several times.  Search the archive at http://archive.midrange.com  Search
for "INFDS" and "INFDS EXTNAME".  You can use D specs in a /copy member if
you wish.

>The data management guide is calling for
>a binary data type with a length of 4,
>which I've defined in DDS as '4B 0', but
>this defines a 2-byte field.
>Should binary fields with length = 4 be defined as '10B 0'?
>Should binary fields with length = 2 be defined as ' 5B 0'?
>
>The DDS manual doesn't give much guidance on this
>and I've never defined a binary data type in DDS before.

As far as D specs go, this has been discussed before too, and is even in the
FAQ at http://faq.midrange.com.  Search for binary (link in lower left).

As far as DDS goes, it matches RPG III.  That is, you define the field
length, not the number of bytes.  And before you ask, it probably will NOT
be enhanced to support the current database capabilities.  SQL has an INT
data type though.  You can script SQL by use of a source member and
RUNSQLSTM.
  --buck