Re: table schema

[Sam_L <lennon_s_j@xxxxxxxxxxx>]

If he is looking for how the table is defined using SQL DDL maybe you 
could just click "Open in Run SQL Scripts" and copy and paste it into 
Word or a PC editor.

Or you could change the "File type" drop down to "PC File" and save it 
to your local PC...

Sam

I pasted this from Run SQL script:

--  Generate SQL
--  Version:                   	V5R3M0 040528
--  Generated on:              	06/02/15 23:26:25
--  Relational Database:       	PUB1
--  Standards Option:          	DB2 UDB iSeries
CREATE TABLE LENNONS1.ORDLINP (
--  SQL150B   10   REUSEDLT(*NO) in table ORDLINP in LENNONS1 ignored.
--  SQL1509   10   Format name ORDLINF for ORDLINP in LENNONS1 ignored.
	ORDNUM DECIMAL(7, 0) NOT NULL DEFAULT 0 ,
	ORDLIN DECIMAL(3, 0) NOT NULL DEFAULT 0 ,
	DELAYSTS CHAR(1) CCSID 273 NOT NULL DEFAULT '' ,
	DELAYDTE DATE NOT NULL DEFAULT '0001-01-01' ,
	SKU DECIMAL(11, 0) NOT NULL DEFAULT 0 ,
	QTYORD DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
	QTYRCV DECIMAL(5, 0) NOT NULL DEFAULT 0 ,
	LASTRCV DATE NOT NULL DEFAULT CURRENT_DATE ) ;

LABEL ON TABLE LENNONS1.ORDLINP
	IS 'Order Detail' ;


On 6/2/2015 2:43 PM, Hoteltravelfundotcom wrote:
> We have an SQL Server developer to write some queries he is asking for
> tables schema.
>
> I went to the I serier Navigator  - i want to generate sql for the table in
> question.
>
> then it says to write it or not, i want to write it. then it says where to
> put,
>
> Do i put in the same library as the file resides?