Re: table schema

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?