Re: IS there a way to display a table definition from the STRSQL command line

[Darryl Freinkel <dhfreinkel@xxxxxxxxx>]

@Darren
Due to differences in the systems, SELECT fail;s because the system did not
convert a MS SQL field to IBM i values.

I am trying to track this down with involving a DBA.

Darryl


On Thu, Sep 8, 2016 at 2:16 PM, Joe Roden <joejoe5161@xxxxxxx> wrote:

> I always keep this in my .sql files to use in Run SQL Scripts.
>
> Select system_column_name, column_name, data_type, dds_type, length,
> numeric_scale, column_text, column_heading, table_schema, table_name  From
> SYSCOLUMNS2
> Where table_name = 'FILE'  and  table_schema = 'LIBRARY';
>
> --
> 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.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.