×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
