RE: Table Definition in System i Navigator V6R1

Chuck,

I think you have identified the problem.

When I run your query on my V6R1 partition I only have one result row as follows.

SYSTEM_TYPE_NAME
ROWID
******** End of data ********

On my V5R4 partition I see all the types as per your list.

What should I do to correctly populate the SYSTYPES table in V6R1?

Many thanks for this

Adam Mills
Snr Technical Consultant, Island Pacific
Direct: +44 (0)7739 941855
Any reference to or discussion regarding existing contracts in the body of this email will not otherwise alter the terms and conditions of our existing contracts - which other than any temporary change described in the body of this email remains in full force




-----Original Message-----
From: CRPence [mailto:CRPbottle@xxxxxxxxx]
Sent: 25 May 2012 15:49
To: midrange-l@xxxxxxxxxxxx
Subject: 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