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

On Sep 8, 2016, at 3:10 PM, Rob Berendt <rob@xxxxxxxxx> wrote:

I find it confusing when you reply to someone using someone else's email.
Perhaps it is a digest thing?

But have you tried the selection below?

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';

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Darryl Freinkel <dhfreinkel@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 09/08/2016 02:58 PM
Subject: Re: IS there a way to display a table definition from the
STRSQL command line
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



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

--
Darryl Freinkel
--
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.


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