RE: sql error

[Alan Campin <Alan.Campin@xxxxxxx>]

I got this to work. CCSID is binary 9/0 and TBL_SCHEMA is spelled out

SELECT substr(TABLE_NAME,1,10), substr(Table_SCHEMA,1,10), CCSID  
FROM syscolumns WHERE CCSID <> 37 and Table_SCHEMA = 'QSYS'       

-----Original Message-----
From: Muralidhar Narayana [mailto:Muralidhar_Narayana@xxxxxxxxxxx]
Sent: Tuesday, January 18, 2005 9:39 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: sql error


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?