Re: Table Definition in System i Navigator V6R1

On 25 May 2012 06:48, Adam Mills wrote:

<<SNIP>> I tried several other SCHEMAs and got the same two data
types CHARACTER and ROWID when adding a new column.

I can run SQL scripts but there is nothing about data types in the
resulting job log. <<SNIP>>

Not sure how dependent the feature is on the SQL catalog data versus hard-coded information, but the effects as described could be related to the data in SYSTYPES. Maybe the results of the following query might be indicative of a problem [with the installation of OPTION(1) Extended Base support for the OS]?:

SELECT systname
FROM QSYS2/SYSTYPES
WHERE typeschema='QSYS2' and metatype='S'
and systschema='QSYS2' and definer ='QSYS'
and typename=systname
and ifnull(srcschema, 'QSYS2')='QSYS2'
order by 1

On v5r3, the output I believe should be the 20 rows:

....+....1
SYSTNAME
BIGINT
BINARY
BLOB
CHARACTER
CLOB
DATALINK
DATE
DBCLOB
DECIMAL
FLOAT
GRAPHIC
INTEGER
NUMERIC
ROWID
SMALLINT
TIME
TIMESTAMP
VARBINARY
VARCHAR
VARGRAPHIC
******** End of data ********

Regards, Chuck