Re: SQL error causes all batch jobs to fail -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

David

You really need to get off of 65535 - but that is not the problem, I believe. That would not help here. The issue is, the vertical bar shortcut is NOT an invariant character - so you cannot rely on it being the same "character" in a different code page.

I would check the new scheduler, as to its CCSID and how it relates to you. Ask them about the QCCSID value, also.

HTH
Vern

David FOXWELL wrote:

-----Message d'origine-----
[mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de rob@xxxxxxxxx
SELECT DIGITS(myfield)!!'_'DIGITS(myotherfield) FROM mytable
You're missing the second concat between '_' and DIGITS(myotherfield).

No, we had the other concat but in the frenzy I forgot it. As you can imagine when I arrived this the shop was like a beehive that had just been kicked.

Thanks to all, we've seen that there IS a difference in CCSID, and I'm trying to get CONCAT to work instead of the short hand. Actually, before today I didn't even KNOW the shorthand. Is part of the problem that normally we're on CCSID = 65535?

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.