Re: sql error

[rob@xxxxxxxxx]

Actually what fixed it is when you changed from
WHERE "CCSID" <> '37'
to
"CCSID" <> 37


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





"Richard ECUYER" <recuyer@xxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
01/18/2005 12:25 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
"RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
cc

Subject
Re: sql error






hi,

On V5R2,

i put some spaces between position and lenght (in substr) and CCSID is an
integer field.
So it become :

SELECT substr( TABLE_NAME, 1 , 10 ), substr( TABLE_SCHEMA, 1 , 10
),"CCSID" FROM SYSCOLUMNS WHERE "CCSID" <> 37 and TaBLe_SCHEMA =
'AB36F'
and it works

----- Original Message -----
From: <rob@xxxxxxxxx>
To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
Sent: Tuesday, January 18, 2005 6:02 PM
Subject: Re: sql error


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

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