Re: INTEGER SQL data type and RPG

[Alan Campin <alan0307d@xxxxxxxxx>]

9 b 0 I believe.


On Mon, May 20, 2013 at 1:40 PM, Matt Olson <Matt.Olson@xxxxxxxx> wrote:

> Folks,
>
> We have DDS defined files and we need to add an INTEGER column to the file
> so we can do a SQL JOIN statement without data type conversions from a DDS
> defined file to a SQL DDL define file.
>
> The problem we have is if we use a DDL (SQL) generated table that has an
> integer column defined on it and do a DSPFFD on that file we get the
> following:
>
> Data Type: BINARY
> Field Length: 9  0
> Buffer Length: 4
> Buffer Position: 1
>
> We so far have been unable to replicate this type of field with a DDS Spec.
>
> How do we represent an INTEGER in DDS or are we required to convert this
> to SQL DDL defined file and get rid of the DDS Spec?
>
> Thanks,
>
> Matt
>
>
> --
> 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.