Art Kagel: runtime error using myschema
Art,
I get a Informix -217 error using your myschema,
which I just downloaded from IIUG, when I use
it with IDS 10.0 on HPUX Itanium. I built it
with cc and not gcc.
The entire error output is pasted below.
I can easily see why I get the -217 error at
Character 245 when trying to prepare a select
stmt involving the Syscolumns table (alias "csc"
and its column named " colattr" because this
system table in my IDS 10.0.FC6 has no column by that
name!
Most likely I have missed something in the README
or Comments in the *.ec files which indicate that
I should or should not use one of the numerous
command-line options.
Any ideas?
I need to use your myexport utility soon in order unload
a data base that has user connections all day long
to it, and I believe that your schema utility is
required by myexport.
Thanks in advance,
Jim Cramer
University of Iowa
server08$ myschema -d stores7
Writing full schema DDL to: stdout
Cannot PREPARE select statement for table data, error: -217.
Error at character 245.
Statement is:
SELECT a.tabname, a.owner, a.tabid, a.partnum, a.fextsize, a.nextsize,
a.locklevel, b.colname, b.colno, b.coltype, b.collength, a.npused,a.tabtype, colmin, colmax, a.nrows, (SELECT count(*) FROM syscolumns csc
WHERE csc.tabid = a.tabid AND csc.colattr IN (0,128)), a.rowsize, a.flags, '
', ' ', 0, 0, 0,a.pagesize, b.extended_id, am.am_owner, am.am_name,
sx.owner, sx.name, p.owner, p.tabname , 0 , replace( a.tabtype, 'S', 'Z' )
as taborder FROM "informix".systables a, outer "informix".syscolumns b,
outer ("informix".sysinherits i, "informix".systables p), outer
"informix".sysxtdtypes sx, outer "informix".sysams am WHERE a.tabid =
b.tabid AND a.tabtype != 'Q' AND a.tabname NOT MATCHES
'cdr_deltab_[0-9][0-9][0-9][0-9][0-9][0-9]*' AND a.tabid >= 100 AND a.tabid
NOT IN (SELECT viotid FROM "informix".sysviolations ) AND a.tabid NOT IN
(SELECT diatid FROM "informix".sysviolations ) AND a.tabname MATCHES ? AND
i.child = a.tabid AND i.parent = p.tabid AND a.type_xid = sx.extended_id AND
a.am_id = am.am_id ORDER BY taborder, a.tabid, b.colno;
errp=, errm=colattr