Re: sql error

["Dave Boettcher" <DBoettch@xxxxxxxxxxxxxxxx>]

I ran the following on our V5R3 system and received an SQL error as
well.
SQL system error.                                            
SELECT substr( TABLE_NAME,1,10), substr( TABLE_SCHEMA,1,10), 
"CCSID" FROM WISACWIS/SYSCOLUMNS WHERE "CCSID" <> '37' and   
TaBLe_SCHEMA = 'AB36F'                                       

Had to spell out the TABLE to get ti to even try.

Since V5R3 we have had problems with embedded SQL.

My suggestion would be to call IBM and ask, they may have seen this
before.

HTH, 

Dave Boettcher

>>> Muralidhar_Narayana@xxxxxxxxxxx 01/18/2005 10:39:27 AM >>>
Hi folks,
SELECT substr(TABLE_NAME,1,10), substr(TBL_SCHEMA,1,10), "CCSID" 
FROM syscols WHERE "CCSID" <> '37' and TBL_SCHEMA = 'AB36F'   
 
I get SQL system error.It creates  a dump file in QTEMP.We have
recently upgraded from V5R2 to V5R3.
what is the solution?

-- 
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx 
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l 
or email: RPG400-L-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.