RE: SQL Acting Strangely -- MIDRANGE-L

Jonathan,

When using the "," as parameter separator in SQL, I always put a blank behind it.

So in your case it would be

update TVBJREP
set BJOAT2 = substr(BJOAT2, 8, 8) concat substr(BJOAT2, 1, 7)
where BJJ4S8 = '0'
and BJJ4S3 = '0'
and substr(BJOAT2, 1, 7)='TSTDATA'

HTH,

Peter Colpaert
Software Engineer - PLM Development Team
Philips Consumer Luminaires
Tel: (+32) 3/459 13 17
Fax: (+32) 3/450 74 33
Address: Industrieterrein Satenrozen 11, 2550 Kontich, Belgium
Email: Peter.Colpaert@xxxxxxxxxxx

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-
bounces@xxxxxxxxxxxx] On Behalf Of Jonathan Mason
Sent: woensdag 10 februari 2010 14:04
To: 'Midrange Systems Technical Discussion'
Subject: RE: SQL Acting Strangely

Hi Dennis

It's the first ",8" - if I try a select on the file using the same
where
clause it reports ",1" as being in error.

The exact message is SQL0104 "Token ,8 is not valid. Valid tokens: )
,."

Thanks

Jonathan

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dennis Lovelady
Sent: 10 February 2010 12:33
To: 'Midrange Systems Technical Discussion'
Subject: RE: SQL Acting Strangely

update TVBJREP
set BJOAT2 = substr(BJOAT2,8,8) concat substr(BJOAT2,1,7)
where BJJ4S8 = '0'
and BJJ4S3 = '0'
and substr(BJOAT2,1,7)='TSTDATA'

When I run this on our Development box it finds and updates the

records

without a problem. However, when it's run on the Test box it falls
over
with a message that it doesn't like the ",8" in the first substr
function.

What is the exact error message, Jonathan? How about SQLCODE,
SQLSTATE?

There are two ",8" in that expression, so the information you provided
is
somewhat ambiguous.

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"The most remarkable thing about my mother is that for thirty years she
served the family nothing but leftovers. The original meal has never
been
found."
-- Calvin Trillin

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"The most remarkable thing about my mother is that for thirty years she
served the family nothing but leftovers. The original meal has never
been
found."
-- Calvin Trillin

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

The information contained in this message may be confidential and legally protected under applicable law. The message is intended solely for the addressee(s). If you are not the intended recipient, you are hereby notified that any use, forwarding, dissemination, or reproduction of this message is strictly prohibited and may be unlawful. If you are not the intended recipient, please contact the sender by return e-mail and destroy all copies of the original message.