20120918_221134 72760: Setting Cursor for SQL Statement: set transaction isolation level READ UNCOMMITTED
20120918_221134 72760: Executing Direct SQL Statement: set transaction isolation level READ UNCOMMITTED
20120918_221134 72760: Freeing Cursor for SQL Statement: set transaction isolation level READ UNCOMMITTED
20120918_221134 72760: Setting Cursor for SQL Statement: CALL PRO_CATALOG_SCHEMA('select decode(0,1,'' ''), owner, tbl, rtrim(decode (tbltype, ''C'', ''VIEW'', ''V'', ''VIEW'', ''S'', ''SYSTEM TABLE'', ''T'',''TABLE''),'' ''), decode(0,1,'' '')from sysprogress.systables where tbltype in (''D'',''T'',''S'',''V'',''C'') AND owner = ''PUB'' AND tbl = ''admdat'' UNION select decode(0,1,'' ''), sowner, sname, ''SYNONYM'', decode(0,1,'' '')from sysprogress.syssynonyms where 0=0 AND sowner = ''PUB'' AND sname = ''admdat''',439,'exactcs',7)
20120918_221134 72760: Preparing SQL Statement: CALL PRO_CATALOG_SCHEMA('select decode(0,1,'' ''), owner, tbl, rtrim(decode (tbltype, ''C'', ''VIEW'', ''V'', ''VIEW'', ''S'', ''SYSTEM TABLE'', ''T'',''TABLE''),'' ''), decode(0,1,'' '')from sysprogress.systables where tbltype in (''D'',''T'',''S'',''V'',''C'') AND owner = ''PUB'' AND tbl = ''admdat'' UNION select decode(0,1,'' ''), sowner, sname, ''SYNONYM'', decode(0,1,'' '')from sysprogress.syssynonyms where 0=0 AND sowner = ''PUB'' AND sname = ''admdat''',439,'exactcs',7)
20120918_221134 72760: Executing SQL Statement: CALL PRO_CATALOG_SCHEMA('select decode(0,1,'' ''), owner, tbl, rtrim(decode (tbltype, ''C'', ''VIEW'', ''V'', ''VIEW'', ''S'', ''SYSTEM TABLE'', ''T'',''TABLE''),'' ''), decode(0,1,'' '')from sysprogress.systables where tbltype in (''D'',''T'',''S'',''V'',''C'') AND owner = ''PUB'' AND tbl = ''admdat'' UNION select decode(0,1,'' ''), sowner, sname, ''SYNONYM'', decode(0,1,'' '')from sysprogress.syssynonyms where 0=0 AND sowner = ''PUB'' AND sname = ''admdat''',439,'exactcs',7)
20120918_221134 72760: Opening SQL Statement: CALL PRO_CATALOG_SCHEMA('select decode(0,1,'' ''), owner, tbl, rtrim(decode (tbltype, ''C'', ''VIEW'', ''V'', ''VIEW'', ''S'', ''SYSTEM TABLE'', ''T'',''TABLE''),'' ''), decode(0,1,'' '')from sysprogress.systables where tbltype in (''D'',''T'',''S'',''V'',''C'') AND owner = ''PUB'' AND tbl = ''admdat'' UNION select decode(0,1,'' ''), sowner, sname, ''SYNONYM'', decode(0,1,'' '')from sysprogress.syssynonyms where 0=0 AND sowner = ''PUB'' AND sname = ''admdat''',439,'exactcs',7)
20120918_221134 72760: Describing SQL Statement: CALL PRO_CATALOG_SCHEMA('select decode(0,1,'' ''), owner, tbl, rtrim(decode (tbltype, ''C'', ''VIEW'', ''V'', ''VIEW'', ''S'', ''SYSTEM TABLE'', ''T'',''TABLE''),'' ''), decode(0,1,'' '')from sysprogress.systables where tbltype in (''D'',''T'',''S'',''V'',''C'') AND owner = ''PUB'' AND tbl = ''admdat'' UNION select decode(0,1,'' ''), sowner, sname, ''SYNONYM'', decode(0,1,'' '')from sysprogress.syssynonyms where 0=0 AND sowner = ''PUB'' AND sname = ''admdat''',439,'exactcs',7)
20120918_221134 72760: Fetching SQL Statement: CALL PRO_CATALOG_SCHEMA('select decode(0,1,'' ''), owner, tbl, rtrim(decode (tbltype, ''C'', ''VIEW'', ''V'', ''VIEW'', ''S'', ''SYSTEM TABLE'', ''T'',''TABLE''),'' ''), decode(0,1,'' '')from sysprogress.systables where tbltype in (''D'',''T'',''S'',''V'',''C'') AND owner = ''PUB'' AND tbl = ''admdat'' UNION select decode(0,1,'' ''), sowner, sname, ''SYNONYM'', decode(0,1,'' '')from sysprogress.syssynonyms where 0=0 AND sowner = ''PUB'' AND sname = ''admdat''',439,'exactcs',7)
20120918_221134 72760: Fetching SQL Statement: CALL PRO_CATALOG_SCHEMA('select decode(0,1,'' ''), owner, tbl, rtrim(decode (tbltype, ''C'', ''VIEW'', ''V'', ''VIEW'', ''S'', ''SYSTEM TABLE'', ''T'',''TABLE''),'' ''), decode(0,1,'' '')from sysprogress.systables where tbltype in (''D'',''T'',''S'',''V'',''C'') AND owner = ''PUB'' AND tbl = ''admdat'' UNION select decode(0,1,'' ''), sowner, sname, ''SYNONYM'', decode(0,1,'' '')from sysprogress.syssynonyms where 0=0 AND sowner = ''PUB'' AND sname = ''admdat''',439,'exactcs',7)
20120918_221134 72760: Freeing Cursor for SQL Statement: CALL PRO_CATALOG_SCHEMA('select decode(0,1,'' ''), owner, tbl, rtrim(decode (tbltype, ''C'', ''VIEW'', ''V'', ''VIEW'', ''S'', ''SYSTEM TABLE'', ''T'',''TABLE''),'' ''), decode(0,1,'' '')from sysprogress.systables where tbltype in (''D'',''T'',''S'',''V'',''C'') AND owner = ''PUB'' AND tbl = ''admdat'' UNION select decode(0,1,'' ''), sowner, sname, ''SYNONYM'', decode(0,1,'' '')from sysprogress.syssynonyms where 0=0 AND sowner = ''PUB'' AND sname = ''admdat''',439,'exactcs',7)
20120918_221135 72760: Setting Cursor for SQL Statement: CALL PRO_CATALOG_SCHEMA('select decode(0,1,''''), owner, tbl,col ''COLUMN_NAME'', decode(odbcinfo(coltype,0,''datatype''),9,91,10,92,11,93,odbcinfo(coltype,0,''datatype'')), rtrim(decode(coltype,''double'',''double precision'',coltype),'' '') , decode(coltype,''time'',12,''timestamp'',23,''timestamp_timezone'',32,''bigint'',19,width), odbcinfo(coltype,width,''length''), decode(coltype,''time'',3,''timestamp'',3,''timestamp_timezone'',0,odbcinfo(coltype,ifnull(scale,0),''scale'')), odbcinfo(coltype,0,''radix''), convert(''integer'',decode(nullflag,''Y'',1,''N'',0)), decode(0,1,''''), rtrim(decode(nvl(dflt_value,''N''),''N'',''NULL'',dflt_value)), decode (odbcinfo (coltype,0,''data_type''),7,9,9,9,10,9,odbcinfo (coltype,0,''data_type'')), decode (odbcinfo (coltype,0,''data_type''),7,1,9,2,10,3,0), convert(''integer'',decode(coltype,''character'',width,''varchar'',width,0)), id-1, decode(nullflag,''YES'',1,''NO'',0) from sysprogress.syscolumns where 0=0 AND owner = ''PUB'' AND tbl = ''admdat'' UNION select decode(0,1,''''), sowner, sname,col, decode(odbcinfo(coltype,0,''datatype''),9,91,10,92,11,93,odbcinfo(coltype,0,''datatype'')), rtrim(decode(coltype,''double'',''double precision'',coltype),'' ''), width, odbcinfo(coltype,width,''length''), odbcinfo(coltype,ifnull(scale,0),''scale''), odbcinfo(coltype,0,''radix''), convert(''integer'',decode(nullflag,''Y'',1,''N'',0)), decode(0,1,'''') , rtrim(decode(nvl(dflt_value,''N''),''N'',''NULL'',dflt_value)), decode (odbcinfo (coltype,0,''data_type''),7,9,9,9,10,9,odbcinfo (coltype,0,''data_type'')), decode (odbcinfo (coltype,0,''data_type''),7,1,9,2,10,3,0), convert(''integer'',decode(coltype,''character'',width,''varchar'',width,0)), id-1, decode(nullflag,''YES'',1,''NO'',0) from {oj sysprogress.syssynonyms left outer join sysprogress.syscolumns on tbl = stbl} where 0=0 AND sowner = ''PUB'' AND sname = ''admdat''',1870,'exactcs',7)
20120918_221135 72760: Preparing SQL Statement: CALL PRO_CATALOG_SCHEMA('select decode(0,1,''''), owner, tbl,col ''COLUMN_NAME'', decode(odbcinfo(coltype,0,''datatype''),9,91,10,92,11,93,odbcinfo(coltype,0,''datatype'')), rtrim(decode(coltype,''double'',''double precision'',coltype),'' '') , decode(coltype,''time'',12,''timestamp'',23,''timestamp_timezone'',32,''bigint'',19,width), odbcinfo(coltype,width,''length''), decode(coltype,''time'',3,''timestamp'',3,''timestamp_timezone'',0,odbcinfo(coltype,ifnull(scale,0),''scale'')), odbcinfo(coltype,0,''radix''), convert(''integer'',decode(nullflag,''Y'',1,''N'',0)), decode(0,1,''''), rtrim(decode(nvl(dflt_value,''N''),''N'',''NULL'',dflt_value)), decode (odbcinfo (coltype,0,''data_type''),7,9,9,9,10,9,odbcinfo (coltype,0,''data_type'')), decode (odbcinfo (coltype,0,''data_type''),7,1,9,2,10,3,0), convert(''integer'',decode(coltype,''character'',width,''varchar'',width,0)), id-1, decode(nullflag,''YES'',1,''NO'',0) from sysprogress.syscolumns where 0=0 AND owner = ''PUB'' AND tbl = ''admdat'' UNION select decode(0,1,''''), sowner, sname,col, decode(odbcinfo(coltype,0,''datatype''),9,91,10,92,11,93,odbcinfo(coltype,0,''datatype'')), rtrim(decode(coltype,''double'',''double precision'',coltype),'' ''), width, odbcinfo(coltype,width,''length''), odbcinfo(coltype,ifnull(scale,0),''scale''), odbcinfo(coltype,0,''radix''), convert(''integer'',decode(nullflag,''Y'',1,''N'',0)), decode(0,1,'''') , rtrim(decode(nvl(dflt_value,''N''),''N'',''NULL'',dflt_value)), decode (odbcinfo (coltype,0,''data_type''),7,9,9,9,10,9,odbcinfo (coltype,0,''data_type'')), decode (odbcinfo (coltype,0,''data_type''),7,1,9,2,10,3,0), convert(''integer'',decode(coltype,''character'',width,''varchar'',width,0)), id-1, decode(nullflag,''YES'',1,''NO'',0) from {oj sysprogress.syssynonyms left outer join sysprogress.syscolumns on tbl = stbl} where 0=0 AND sowner = ''PUB'' AND sname = ''admdat''',1870,'exactcs',7)
20120918_221135 72760: Executing SQL Statement: CALL PRO_CATALOG_SCHEMA('select decode(0,1,''''), owner, tbl,col ''COLUMN_NAME'', decode(odbcinfo(coltype,0,''datatype''),9,91,10,92,11,93,odbcinfo(coltype,0,''datatype'')), rtrim(decode(coltype,''double'',''double precision'',coltype),'' '') , decode(coltype,''time'',12,''timestamp'',23,''timestamp_timezone'',32,''bigint'',19,width), odbcinfo(coltype,width,''length''), decode(coltype,''time'',3,''timestamp'',3,''timestamp_timezone'',0,odbcinfo(coltype,ifnull(scale,0),''scale'')), odbcinfo(coltype,0,''radix''), convert(''integer'',decode(nullflag,''Y'',1,''N'',0)), decode(0,1,''''), rtrim(decode(nvl(dflt_value,''N''),''N'',''NULL'',dflt_value)), decode (odbcinfo (coltype,0,''data_type''),7,9,9,9,10,9,odbcinfo (coltype,0,''data_type'')), decode (odbcinfo (coltype,0,''data_type''),7,1,9,2,10,3,0), convert(''integer'',decode(coltype,''character'',width,''varchar'',width,0)), id-1, decode(nullflag,''YES'',1,''NO'',0) from sysprogress.syscolumns where 0=0 AND owner = ''PUB'' AND tbl = ''admdat'' UNION select decode(0,1,''''), sowner, sname,col, decode(odbcinfo(coltype,0,''datatype''),9,91,10,92,11,93,odbcinfo(coltype,0,''datatype'')), rtrim(decode(coltype,''double'',''double precision'',coltype),'' ''), width, odbcinfo(coltype,width,''length''), odbcinfo(coltype,ifnull(scale,0),''scale''), odbcinfo(coltype,0,''radix''), convert(''integer'',decode(nullflag,''Y'',1,''N'',0)), decode(0,1,'''') , rtrim(decode(nvl(dflt_value,''N''),''N'',''NULL'',dflt_value)), decode (odbcinfo (coltype,0,''data_type''),7,9,9,9,10,9,odbcinfo (coltype,0,''data_type'')), decode (odbcinfo (coltype,0,''data_type''),7,1,9,2,10,3,0), convert(''integer'',decode(coltype,''character'',width,''varchar'',width,0)), id-1, decode(nullflag,''YES'',1,''NO'',0) from {oj sysprogress.syssynonyms left outer join sysprogress.syscolumns on tbl = stbl} where 0=0 AND sowner = ''PUB'' AND sname = ''admdat''',1870,'exactcs',7)
20120918_221135 72760: Opening SQL Statement: CALL PRO_CATALOG_SCHEMA('select decode(0,1,''''), owner, tbl,col ''COLUMN_NAME'', decode(odbcinfo(coltype,0,''datatype''),9,91,10,92,11,93,odbcinfo(coltype,0,''datatype'')), rtrim(decode(coltype,''double'',''double precision'',coltype),'' '') , decode(coltype,''time'',12,''timestamp'',23,''timestamp_timezone'',32,''bigint'',19,width), odbcinfo(coltype,width,''length''), decode(coltype,''time'',3,''timestamp'',3,''timestamp_timezone'',0,odbcinfo(coltype,ifnull(scale,0),''scale'')), odbcinfo(coltype,0,''radix''), convert(''integer'',decode(nullflag,''Y'',1,''N'',0)), decode(0,1,''''), rtrim(decode(nvl(dflt_value,''N''),''N'',''NULL'',dflt_value)), decode (odbcinfo (coltype,0,''data_type''),7,9,9,9,10,9,odbcinfo (coltype,0,''data_type'')), decode (odbcinfo (coltype,0,''data_type''),7,1,9,2,10,3,0), convert(''integer'',decode(coltype,''character'',width,''varchar'',width,0)), id-1, decode(nullflag,''YES'',1,''NO'',0) from sysprogress.syscolumns where 0=0 AND owner = ''PUB'' AND tbl = ''admdat'' UNION select decode(0,1,''''), sowner, sname,col, decode(odbcinfo(coltype,0,''datatype''),9,91,10,92,11,93,odbcinfo(coltype,0,''datatype'')), rtrim(decode(coltype,''double'',''double precision'',coltype),'' ''), width, odbcinfo(coltype,width,''length''), odbcinfo(coltype,ifnull(scale,0),''scale''), odbcinfo(coltype,0,''radix''), convert(''integer'',decode(nullflag,''Y'',1,''N'',0)), decode(0,1,'''') , rtrim(decode(nvl(dflt_value,''N''),''N'',''NULL'',dflt_value)), decode (odbcinfo (coltype,0,''data_type''),7,9,9,9,10,9,odbcinfo (coltype,0,''data_type'')), decode (odbcinfo (coltype,0,''data_type''),7,1,9,2,10,3,0), convert(''integer'',decode(coltype,''character'',width,''varchar'',width,0)), id-1, decode(nullflag,''YES'',1,''NO'',0) from {oj sysprogress.syssynonyms left outer join sysprogress.syscolumns on tbl = stbl} where 0=0 AND sowner = ''PUB'' AND sname = ''admdat''',1870,'exactcs',7)
20120918_221135 72760: Describing SQL Statement: CALL PRO_CATALOG_SCHEMA('select decode(0,1,''''), owner, tbl,col ''COLUMN_NAME'', decode(odbcinfo(coltype,0,''datatype''),9,91,10,92,11,93,odbcinfo(coltype,0,''datatype'')), rtrim(decode(coltype,''double'',''double precision'',coltype),'' '') , decode(coltype,''time'',12,''timestamp'',23,''timestamp_timezone'',32,''bigint'',19,width), odbcinfo(coltype,width,''length''), decode(coltype,''time'',3,''timestamp'',3,''timestamp_timezone'',0,odbcinfo(coltype,ifnull(scale,0),''scale'')), odbcinfo(coltype,0,''radix''), convert(''integer'',decode(nullflag,''Y'',1,''N'',0)), decode(0,1,''''), rtrim(decode(nvl(dflt_value,''N''),''N'',''NULL'',dflt_value)), decode (odbcinfo (coltype,0,''data_type''),7,9,9,9,10,9,odbcinfo (coltype,0,''data_type'')), decode (odbcinfo (coltype,0,''data_type''),7,1,9,2,10,3,0), convert(''integer'',decode(coltype,''character'',width,''varchar'',width,0)), id-1, decode(nullflag,''YES'',1,''NO'',0) from sysprogress.syscolumns where 0=0 AND owner = ''PUB'' AND tbl = ''admdat'' UNION select decode(0,1,''''), sowner, sname,col, decode(odbcinfo(coltype,0,''datatype''),9,91,10,92,11,93,odbcinfo(coltype,0,''datatype'')), rtrim(decode(coltype,''double'',''double precision'',coltype),'' ''), width, odbcinfo(coltype,width,''length''), odbcinfo(coltype,ifnull(scale,0),''scale''), odbcinfo(coltype,0,''radix''), convert(''integer'',decode(nullflag,''Y'',1,''N'',0)), decode(0,1,'''') , rtrim(decode(nvl(dflt_value,''N''),''N'',''NULL'',dflt_value)), decode (odbcinfo (coltype,0,''data_type''),7,9,9,9,10,9,odbcinfo (coltype,0,''data_type'')), decode (odbcinfo (coltype,0,''data_type''),7,1,9,2,10,3,0), convert(''integer'',decode(coltype,''character'',width,''varchar'',width,0)), id-1, decode(nullflag,''YES'',1,''NO'',0) from {oj sysprogress.syssynonyms left outer join sysprogress.syscolumns on tbl = stbl} where 0=0 AND sowner = ''PUB'' AND sname = ''admdat''',1870,'exactcs',7)
20120918_221135 72760: Fetching SQL Statement: CALL PRO_CATALOG_SCHEMA('select decode(0,1,''''), owner, tbl,col ''COLUMN_NAME'', decode(odbcinfo(coltype,0,''datatype''),9,91,10,92,11,93,odbcinfo(coltype,0,''datatype'')), rtrim(decode(coltype,''double'',''double precision'',coltype),'' '') , decode(coltype,''time'',12,''timestamp'',23,''timestamp_timezone'',32,''bigint'',19,width), odbcinfo(coltype,width,''length''), decode(coltype,''time'',3,''timestamp'',3,''timestamp_timezone'',0,odbcinfo(coltype,ifnull(scale,0),''scale'')), odbcinfo(coltype,0,''radix''), convert(''integer'',decode(nullflag,''Y'',1,''N'',0)), decode(0,1,''''), rtrim(decode(nvl(dflt_value,''N''),''N'',''NULL'',dflt_value)), decode (odbcinfo (coltype,0,''data_type''),7,9,9,9,10,9,odbcinfo (coltype,0,''data_type'')), decode (odbcinfo (coltype,0,''data_type''),7,1,9,2,10,3,0), convert(''integer'',decode(coltype,''character'',width,''varchar'',width,0)), id-1, decode(nullflag,''YES'',1,''NO'',0) from sysprogress.syscolumns where 0=0 AND owner = ''PUB'' AND tbl = ''admdat'' UNION select decode(0,1,''''), sowner, sname,col, decode(odbcinfo(coltype,0,''datatype''),9,91,10,92,11,93,odbcinfo(coltype,0,''datatype'')), rtrim(decode(coltype,''double'',''double precision'',coltype),'' ''), width, odbcinfo(coltype,width,''length''), odbcinfo(coltype,ifnull(scale,0),''scale''), odbcinfo(coltype,0,''radix''), convert(''integer'',decode(nullflag,''Y'',1,''N'',0)), decode(0,1,'''') , rtrim(decode(nvl(dflt_value,''N''),''N'',''NULL'',dflt_value)), decode (odbcinfo (coltype,0,''data_type''),7,9,9,9,10,9,odbcinfo (coltype,0,''data_type'')), decode (odbcinfo (coltype,0,''data_type''),7,1,9,2,10,3,0), convert(''integer'',decode(coltype,''character'',width,''varchar'',width,0)), id-1, decode(nullflag,''YES'',1,''NO'',0) from {oj sysprogress.syssynonyms left outer join sysprogress.syscolumns on tbl = stbl} where 0=0 AND sowner = ''PUB'' AND sname = ''admdat''',1870,'exactcs',7)
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching...
20120918_221135 72760: Fetching SQL Statement: CALL PRO_CATALOG_SCHEMA('select decode(0,1,''''), owner, tbl,col ''COLUMN_NAME'', decode(odbcinfo(coltype,0,''datatype''),9,91,10,92,11,93,odbcinfo(coltype,0,''datatype'')), rtrim(decode(coltype,''double'',''double precision'',coltype),'' '') , decode(coltype,''time'',12,''timestamp'',23,''timestamp_timezone'',32,''bigint'',19,width), odbcinfo(coltype,width,''length''), decode(coltype,''time'',3,''timestamp'',3,''timestamp_timezone'',0,odbcinfo(coltype,ifnull(scale,0),''scale'')), odbcinfo(coltype,0,''radix''), convert(''integer'',decode(nullflag,''Y'',1,''N'',0)), decode(0,1,''''), rtrim(decode(nvl(dflt_value,''N''),''N'',''NULL'',dflt_value)), decode (odbcinfo (coltype,0,''data_type''),7,9,9,9,10,9,odbcinfo (coltype,0,''data_type'')), decode (odbcinfo (coltype,0,''data_type''),7,1,9,2,10,3,0), convert(''integer'',decode(coltype,''character'',width,''varchar'',width,0)), id-1, decode(nullflag,''YES'',1,''NO'',0) from sysprogress.syscolumns where 0=0 AND owner = ''PUB'' AND tbl = ''admdat'' UNION select decode(0,1,''''), sowner, sname,col, decode(odbcinfo(coltype,0,''datatype''),9,91,10,92,11,93,odbcinfo(coltype,0,''datatype'')), rtrim(decode(coltype,''double'',''double precision'',coltype),'' ''), width, odbcinfo(coltype,width,''length''), odbcinfo(coltype,ifnull(scale,0),''scale''), odbcinfo(coltype,0,''radix''), convert(''integer'',decode(nullflag,''Y'',1,''N'',0)), decode(0,1,'''') , rtrim(decode(nvl(dflt_value,''N''),''N'',''NULL'',dflt_value)), decode (odbcinfo (coltype,0,''data_type''),7,9,9,9,10,9,odbcinfo (coltype,0,''data_type'')), decode (odbcinfo (coltype,0,''data_type''),7,1,9,2,10,3,0), convert(''integer'',decode(coltype,''character'',width,''varchar'',width,0)), id-1, decode(nullflag,''YES'',1,''NO'',0) from {oj sysprogress.syssynonyms left outer join sysprogress.syscolumns on tbl = stbl} where 0=0 AND sowner = ''PUB'' AND sname = ''admdat''',1870,'exactcs',7)
20120918_221135 72760: Freeing Cursor for SQL Statement: CALL PRO_CATALOG_SCHEMA('select decode(0,1,''''), owner, tbl,col ''COLUMN_NAME'', decode(odbcinfo(coltype,0,''datatype''),9,91,10,92,11,93,odbcinfo(coltype,0,''datatype'')), rtrim(decode(coltype,''double'',''double precision'',coltype),'' '') , decode(coltype,''time'',12,''timestamp'',23,''timestamp_timezone'',32,''bigint'',19,width), odbcinfo(coltype,width,''length''), decode(coltype,''time'',3,''timestamp'',3,''timestamp_timezone'',0,odbcinfo(coltype,ifnull(scale,0),''scale'')), odbcinfo(coltype,0,''radix''), convert(''integer'',decode(nullflag,''Y'',1,''N'',0)), decode(0,1,''''), rtrim(decode(nvl(dflt_value,''N''),''N'',''NULL'',dflt_value)), decode (odbcinfo (coltype,0,''data_type''),7,9,9,9,10,9,odbcinfo (coltype,0,''data_type'')), decode (odbcinfo (coltype,0,''data_type''),7,1,9,2,10,3,0), convert(''integer'',decode(coltype,''character'',width,''varchar'',width,0)), id-1, decode(nullflag,''YES'',1,''NO'',0) from sysprogress.syscolumns where 0=0 AND owner = ''PUB'' AND tbl = ''admdat'' UNION select decode(0,1,''''), sowner, sname,col, decode(odbcinfo(coltype,0,''datatype''),9,91,10,92,11,93,odbcinfo(coltype,0,''datatype'')), rtrim(decode(coltype,''double'',''double precision'',coltype),'' ''), width, odbcinfo(coltype,width,''length''), odbcinfo(coltype,ifnull(scale,0),''scale''), odbcinfo(coltype,0,''radix''), convert(''integer'',decode(nullflag,''Y'',1,''N'',0)), decode(0,1,'''') , rtrim(decode(nvl(dflt_value,''N''),''N'',''NULL'',dflt_value)), decode (odbcinfo (coltype,0,''data_type''),7,9,9,9,10,9,odbcinfo (coltype,0,''data_type'')), decode (odbcinfo (coltype,0,''data_type''),7,1,9,2,10,3,0), convert(''integer'',decode(coltype,''character'',width,''varchar'',width,0)), id-1, decode(nullflag,''YES'',1,''NO'',0) from {oj sysprogress.syssynonyms left outer join sysprogress.syscolumns on tbl = stbl} where 0=0 AND sowner = ''PUB'' AND sname = ''admdat''',1870,'exactcs',7)
20120918_221135 72760: Setting Cursor for SQL Statement: select * from "exactcs"."PUB"."admdat"
20120918_221135 72760: Preparing SQL Statement: select * from "exactcs"."PUB"."admdat"
20120918_221135 72760: Describing SQL Statement: select * from "exactcs"."PUB"."admdat"
20120918_221135 72760: Opening SQL Statement: select * from "exactcs"."PUB"."admdat"
20120918_221135 72760: Fetching SQL Statement: select * from "exactcs"."PUB"."admdat"
20120918_221135 72760: Fetching SQL Statement: select * from "exactcs"."PUB"."admdat"
20120918_221136 72760: Fetching SQL Statement: select * from "exactcs"."PUB"."admdat"
20120918_221136 72760: Freeing Cursor for SQL Statement: select * from "exactcs"."PUB"."admdat"
20120918_221136 72760: Setting Cursor for SQL Statement: CALL PRO_CATALOG_SCHEMA('select decode(0,1,''''), sysprogress.systables.owner TABLE_SCHEM, sysprogress.systables.tbl TABLE_NAME,convert(''smallint'',decode (0, 1, '''')) NON_UNIQUE, decode (0, 1, sysprogress.systables.owner) INDEX_QUALIFIER, decode (0, 1, sysprogress.systables.owner) INDEX_NAME, convert(''smallint'',0), convert(''smallint'',decode (0, 1, '''')) ORDINAL_POSITION, decode (0, 1, sysprogress.systables.owner) COLUMN_NAME, decode (0, 1, sysprogress.systables.owner) COLLATION, decode (0, 1, '''') CARDINALITY, decode (0, 1, '''') PAGES, decode (0, 1, '''') from sysprogress.systables where sysprogress.systables.tbl = ''admdat'' AND sysprogress.systables.owner = ''PUB'' union all select decode(0,1,'''') TABLE_QUALIFIER, sysprogress.sysindexes.tblowner TABLE_OWNER, sysprogress.sysindexes.tbl TABLE_NAME, convert(''smallint'',decode (sysprogress.sysindexes.idxtype, ''U'',0 , ''D'', 1)) NON_UNIQUE, sysprogress.sysindexes.idxowner INDEX_QUALIFIER, sysprogress.sysindexes.idxname INDEX_NAME, convert(''smallint'',decode(sysprogress.sysindexes.idxmethod,''H'',2,3 )), convert(''smallint'',sysprogress.sysindexes.idxseq + 1) SEQ_IN_INDEX, sysprogress.sysindexes.colname COLUMN_NAME, cast(sysprogress.sysindexes.idxorder as char(1)) ASC_OR_DESC, decode(0,1,'''') CARDINALITY, decode(0,1,'''') PAGES,decode (0, 1, '''') from sysprogress.sysindexes where sysprogress.sysindexes.tbl = ''admdat'' AND sysprogress.sysindexes.idxowner = ''PUB''',1427,'exactcs',7)
20120918_221136 72760: Preparing SQL Statement: CALL PRO_CATALOG_SCHEMA('select decode(0,1,''''), sysprogress.systables.owner TABLE_SCHEM, sysprogress.systables.tbl TABLE_NAME,convert(''smallint'',decode (0, 1, '''')) NON_UNIQUE, decode (0, 1, sysprogress.systables.owner) INDEX_QUALIFIER, decode (0, 1, sysprogress.systables.owner) INDEX_NAME, convert(''smallint'',0), convert(''smallint'',decode (0, 1, '''')) ORDINAL_POSITION, decode (0, 1, sysprogress.systables.owner) COLUMN_NAME, decode (0, 1, sysprogress.systables.owner) COLLATION, decode (0, 1, '''') CARDINALITY, decode (0, 1, '''') PAGES, decode (0, 1, '''') from sysprogress.systables where sysprogress.systables.tbl = ''admdat'' AND sysprogress.systables.owner = ''PUB'' union all select decode(0,1,'''') TABLE_QUALIFIER, sysprogress.sysindexes.tblowner TABLE_OWNER, sysprogress.sysindexes.tbl TABLE_NAME, convert(''smallint'',decode (sysprogress.sysindexes.idxtype, ''U'',0 , ''D'', 1)) NON_UNIQUE, sysprogress.sysindexes.idxowner INDEX_QUALIFIER, sysprogress.sysindexes.idxname INDEX_NAME, convert(''smallint'',decode(sysprogress.sysindexes.idxmethod,''H'',2,3 )), convert(''smallint'',sysprogress.sysindexes.idxseq + 1) SEQ_IN_INDEX, sysprogress.sysindexes.colname COLUMN_NAME, cast(sysprogress.sysindexes.idxorder as char(1)) ASC_OR_DESC, decode(0,1,'''') CARDINALITY, decode(0,1,'''') PAGES,decode (0, 1, '''') from sysprogress.sysindexes where sysprogress.sysindexes.tbl = ''admdat'' AND sysprogress.sysindexes.idxowner = ''PUB''',1427,'exactcs',7)
20120918_221136 72760: Executing SQL Statement: CALL PRO_CATALOG_SCHEMA('select decode(0,1,''''), sysprogress.systables.owner TABLE_SCHEM, sysprogress.systables.tbl TABLE_NAME,convert(''smallint'',decode (0, 1, '''')) NON_UNIQUE, decode (0, 1, sysprogress.systables.owner) INDEX_QUALIFIER, decode (0, 1, sysprogress.systables.owner) INDEX_NAME, convert(''smallint'',0), convert(''smallint'',decode (0, 1, '''')) ORDINAL_POSITION, decode (0, 1, sysprogress.systables.owner) COLUMN_NAME, decode (0, 1, sysprogress.systables.owner) COLLATION, decode (0, 1, '''') CARDINALITY, decode (0, 1, '''') PAGES, decode (0, 1, '''') from sysprogress.systables where sysprogress.systables.tbl = ''admdat'' AND sysprogress.systables.owner = ''PUB'' union all select decode(0,1,'''') TABLE_QUALIFIER, sysprogress.sysindexes.tblowner TABLE_OWNER, sysprogress.sysindexes.tbl TABLE_NAME, convert(''smallint'',decode (sysprogress.sysindexes.idxtype, ''U'',0 , ''D'', 1)) NON_UNIQUE, sysprogress.sysindexes.idxowner INDEX_QUALIFIER, sysprogress.sysindexes.idxname INDEX_NAME, convert(''smallint'',decode(sysprogress.sysindexes.idxmethod,''H'',2,3 )), convert(''smallint'',sysprogress.sysindexes.idxseq + 1) SEQ_IN_INDEX, sysprogress.sysindexes.colname COLUMN_NAME, cast(sysprogress.sysindexes.idxorder as char(1)) ASC_OR_DESC, decode(0,1,'''') CARDINALITY, decode(0,1,'''') PAGES,decode (0, 1, '''') from sysprogress.sysindexes where sysprogress.sysindexes.tbl = ''admdat'' AND sysprogress.sysindexes.idxowner = ''PUB''',1427,'exactcs',7)
20120918_221136 72760: Opening SQL Statement: CALL PRO_CATALOG_SCHEMA('select decode(0,1,''''), sysprogress.systables.owner TABLE_SCHEM, sysprogress.systables.tbl TABLE_NAME,convert(''smallint'',decode (0, 1, '''')) NON_UNIQUE, decode (0, 1, sysprogress.systables.owner) INDEX_QUALIFIER, decode (0, 1, sysprogress.systables.owner) INDEX_NAME, convert(''smallint'',0), convert(''smallint'',decode (0, 1, '''')) ORDINAL_POSITION, decode (0, 1, sysprogress.systables.owner) COLUMN_NAME, decode (0, 1, sysprogress.systables.owner) COLLATION, decode (0, 1, '''') CARDINALITY, decode (0, 1, '''') PAGES, decode (0, 1, '''') from sysprogress.systables where sysprogress.systables.tbl = ''admdat'' AND sysprogress.systables.owner = ''PUB'' union all select decode(0,1,'''') TABLE_QUALIFIER, sysprogress.sysindexes.tblowner TABLE_OWNER, sysprogress.sysindexes.tbl TABLE_NAME, convert(''smallint'',decode (sysprogress.sysindexes.idxtype, ''U'',0 , ''D'', 1)) NON_UNIQUE, sysprogress.sysindexes.idxowner INDEX_QUALIFIER, sysprogress.sysindexes.idxname INDEX_NAME, convert(''smallint'',decode(sysprogress.sysindexes.idxmethod,''H'',2,3 )), convert(''smallint'',sysprogress.sysindexes.idxseq + 1) SEQ_IN_INDEX, sysprogress.sysindexes.colname COLUMN_NAME, cast(sysprogress.sysindexes.idxorder as char(1)) ASC_OR_DESC, decode(0,1,'''') CARDINALITY, decode(0,1,'''') PAGES,decode (0, 1, '''') from sysprogress.sysindexes where sysprogress.sysindexes.tbl = ''admdat'' AND sysprogress.sysindexes.idxowner = ''PUB''',1427,'exactcs',7)
20120918_221136 72760: Describing SQL Statement: CALL PRO_CATALOG_SCHEMA('select decode(0,1,''''), sysprogress.systables.owner TABLE_SCHEM, sysprogress.systables.tbl TABLE_NAME,convert(''smallint'',decode (0, 1, '''')) NON_UNIQUE, decode (0, 1, sysprogress.systables.owner) INDEX_QUALIFIER, decode (0, 1, sysprogress.systables.owner) INDEX_NAME, convert(''smallint'',0), convert(''smallint'',decode (0, 1, '''')) ORDINAL_POSITION, decode (0, 1, sysprogress.systables.owner) COLUMN_NAME, decode (0, 1, sysprogress.systables.owner) COLLATION, decode (0, 1, '''') CARDINALITY, decode (0, 1, '''') PAGES, decode (0, 1, '''') from sysprogress.systables where sysprogress.systables.tbl = ''admdat'' AND sysprogress.systables.owner = ''PUB'' union all select decode(0,1,'''') TABLE_QUALIFIER, sysprogress.sysindexes.tblowner TABLE_OWNER, sysprogress.sysindexes.tbl TABLE_NAME, convert(''smallint'',decode (sysprogress.sysindexes.idxtype, ''U'',0 , ''D'', 1)) NON_UNIQUE, sysprogress.sysindexes.idxowner INDEX_QUALIFIER, sysprogress.sysindexes.idxname INDEX_NAME, convert(''smallint'',decode(sysprogress.sysindexes.idxmethod,''H'',2,3 )), convert(''smallint'',sysprogress.sysindexes.idxseq + 1) SEQ_IN_INDEX, sysprogress.sysindexes.colname COLUMN_NAME, cast(sysprogress.sysindexes.idxorder as char(1)) ASC_OR_DESC, decode(0,1,'''') CARDINALITY, decode(0,1,'''') PAGES,decode (0, 1, '''') from sysprogress.sysindexes where sysprogress.sysindexes.tbl = ''admdat'' AND sysprogress.sysindexes.idxowner = ''PUB''',1427,'exactcs',7)
20120918_221136 72760: Fetching SQL Statement: CALL PRO_CATALOG_SCHEMA('select decode(0,1,''''), sysprogress.systables.owner TABLE_SCHEM, sysprogress.systables.tbl TABLE_NAME,convert(''smallint'',decode (0, 1, '''')) NON_UNIQUE, decode (0, 1, sysprogress.systables.owner) INDEX_QUALIFIER, decode (0, 1, sysprogress.systables.owner) INDEX_NAME, convert(''smallint'',0), convert(''smallint'',decode (0, 1, '''')) ORDINAL_POSITION, decode (0, 1, sysprogress.systables.owner) COLUMN_NAME, decode (0, 1, sysprogress.systables.owner) COLLATION, decode (0, 1, '''') CARDINALITY, decode (0, 1, '''') PAGES, decode (0, 1, '''') from sysprogress.systables where sysprogress.systables.tbl = ''admdat'' AND sysprogress.systables.owner = ''PUB'' union all select decode(0,1,'''') TABLE_QUALIFIER, sysprogress.sysindexes.tblowner TABLE_OWNER, sysprogress.sysindexes.tbl TABLE_NAME, convert(''smallint'',decode (sysprogress.sysindexes.idxtype, ''U'',0 , ''D'', 1)) NON_UNIQUE, sysprogress.sysindexes.idxowner INDEX_QUALIFIER, sysprogress.sysindexes.idxname INDEX_NAME, convert(''smallint'',decode(sysprogress.sysindexes.idxmethod,''H'',2,3 )), convert(''smallint'',sysprogress.sysindexes.idxseq + 1) SEQ_IN_INDEX, sysprogress.sysindexes.colname COLUMN_NAME, cast(sysprogress.sysindexes.idxorder as char(1)) ASC_OR_DESC, decode(0,1,'''') CARDINALITY, decode(0,1,'''') PAGES,decode (0, 1, '''') from sysprogress.sysindexes where sysprogress.sysindexes.tbl = ''admdat'' AND sysprogress.sysindexes.idxowner = ''PUB''',1427,'exactcs',7)
20120918_221136 72760: Fetching...
20120918_221136 72760: Fetching...
20120918_221136 72760: Fetching...
20120918_221136 72760: Fetching SQL Statement: CALL PRO_CATALOG_SCHEMA('select decode(0,1,''''), sysprogress.systables.owner TABLE_SCHEM, sysprogress.systables.tbl TABLE_NAME,convert(''smallint'',decode (0, 1, '''')) NON_UNIQUE, decode (0, 1, sysprogress.systables.owner) INDEX_QUALIFIER, decode (0, 1, sysprogress.systables.owner) INDEX_NAME, convert(''smallint'',0), convert(''smallint'',decode (0, 1, '''')) ORDINAL_POSITION, decode (0, 1, sysprogress.systables.owner) COLUMN_NAME, decode (0, 1, sysprogress.systables.owner) COLLATION, decode (0, 1, '''') CARDINALITY, decode (0, 1, '''') PAGES, decode (0, 1, '''') from sysprogress.systables where sysprogress.systables.tbl = ''admdat'' AND sysprogress.systables.owner = ''PUB'' union all select decode(0,1,'''') TABLE_QUALIFIER, sysprogress.sysindexes.tblowner TABLE_OWNER, sysprogress.sysindexes.tbl TABLE_NAME, convert(''smallint'',decode (sysprogress.sysindexes.idxtype, ''U'',0 , ''D'', 1)) NON_UNIQUE, sysprogress.sysindexes.idxowner INDEX_QUALIFIER, sysprogress.sysindexes.idxname INDEX_NAME, convert(''smallint'',decode(sysprogress.sysindexes.idxmethod,''H'',2,3 )), convert(''smallint'',sysprogress.sysindexes.idxseq + 1) SEQ_IN_INDEX, sysprogress.sysindexes.colname COLUMN_NAME, cast(sysprogress.sysindexes.idxorder as char(1)) ASC_OR_DESC, decode(0,1,'''') CARDINALITY, decode(0,1,'''') PAGES,decode (0, 1, '''') from sysprogress.sysindexes where sysprogress.sysindexes.tbl = ''admdat'' AND sysprogress.sysindexes.idxowner = ''PUB''',1427,'exactcs',7)
20120918_221136 72760: Freeing Cursor for SQL Statement: CALL PRO_CATALOG_SCHEMA('select decode(0,1,''''), sysprogress.systables.owner TABLE_SCHEM, sysprogress.systables.tbl TABLE_NAME,convert(''smallint'',decode (0, 1, '''')) NON_UNIQUE, decode (0, 1, sysprogress.systables.owner) INDEX_QUALIFIER, decode (0, 1, sysprogress.systables.owner) INDEX_NAME, convert(''smallint'',0), convert(''smallint'',decode (0, 1, '''')) ORDINAL_POSITION, decode (0, 1, sysprogress.systables.owner) COLUMN_NAME, decode (0, 1, sysprogress.systables.owner) COLLATION, decode (0, 1, '''') CARDINALITY, decode (0, 1, '''') PAGES, decode (0, 1, '''') from sysprogress.systables where sysprogress.systables.tbl = ''admdat'' AND sysprogress.systables.owner = ''PUB'' union all select decode(0,1,'''') TABLE_QUALIFIER, sysprogress.sysindexes.tblowner TABLE_OWNER, sysprogress.sysindexes.tbl TABLE_NAME, convert(''smallint'',decode (sysprogress.sysindexes.idxtype, ''U'',0 , ''D'', 1)) NON_UNIQUE, sysprogress.sysindexes.idxowner INDEX_QUALIFIER, sysprogress.sysindexes.idxname INDEX_NAME, convert(''smallint'',decode(sysprogress.sysindexes.idxmethod,''H'',2,3 )), convert(''smallint'',sysprogress.sysindexes.idxseq + 1) SEQ_IN_INDEX, sysprogress.sysindexes.colname COLUMN_NAME, cast(sysprogress.sysindexes.idxorder as char(1)) ASC_OR_DESC, decode(0,1,'''') CARDINALITY, decode(0,1,'''') PAGES,decode (0, 1, '''') from sysprogress.sysindexes where sysprogress.sysindexes.tbl = ''admdat'' AND sysprogress.sysindexes.idxowner = ''PUB''',1427,'exactcs',7)
20120918_221136 72760: Setting Cursor for SQL Statement: set catalog exactcs
20120918_221136 72760: Executing Direct SQL Statement: set catalog exactcs
20120918_221136 72760: Freeing Cursor for SQL Statement: set catalog exactcs
20120918_221136 72760: Setting Cursor for SQL Statement: set catalog exactcs
20120918_221136 72760: Executing Direct SQL Statement: set catalog exactcs
20120918_221136 72760: Freeing Cursor for SQL Statement: set catalog exactcs
20120918_221136 72760: Setting Cursor for SQL Statement: select * from "exactcs"."PUB"."admdat"
20120918_221136 72760: Preparing SQL Statement: select * from "exactcs"."PUB"."admdat"
20120918_221136 72760: Describing SQL Statement: select * from "exactcs"."PUB"."admdat"
20120918_221136 72760: Opening SQL Statement: select * from "exactcs"."PUB"."admdat"
20120918_221136 72760: Freeing Cursor for SQL Statement: select * from "exactcs"."PUB"."admdat"