Re: sql error

[rob@xxxxxxxxx]

Try pasting in your statement instead of rekeying it.  I tried it on our 
V5R3 machine

SELECT substr(TABLE_NAME,1,10), substr(TBL_SCHEMA,1,10), "CCSID"
FROM syscols WHERE "CCSID" <> '37' and TBL_SCHEMA = 'AB36F' 
SYSCOLS in *LIBL type *FILE not found. 

SELECT substr(TABLE_NAME,1,10), substr(TBL_SCHEMA,1,10), "CCSID" 
FROM qsys2/syscols WHERE "CCSID" <> '37' and TBL_SCHEMA = 'AB36F'
SYSCOLS in QSYS2 type *FILE not found. 

SELECT substr(TABLE_NAME,1,10), substr(TBL_SCHEMA,1,10), "CCSID"
FROM syscolumns WHERE "CCSID" <> '37' and TBL_SCHEMA = 'AB36F' 
Column TBL_SCHEMA not in specified tables. 

But I think I got it with:
SELECT substr(TABLE_NAME,1,10), substr(TABLE_SCHEMA,1,10), "CCSID"
FROM syscolumns WHERE "CCSID" <> '37' and TABLE_SCHEMA = 'AB36F' 
SQL system error. 

So, yes, I can duplicate it here.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Muralidhar Narayana" <Muralidhar_Narayana@xxxxxxxxxxx> 
Sent by: rpg400-l-bounces+rob=dekko.com@xxxxxxxxxxxx
01/18/2005 11:39 AM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
<rpg400-l@xxxxxxxxxxxx>
cc

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?

-- 
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.