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



An old professor (Physics) used to say, "To understand a problem it is always helpful to discuss it with someone smarter than yourself, your wife, children, pets, and in many cases a brick wall."

Duane Christen


--


Duane Christen
Senior Software Engineer
(319) 790-7162
Duane.Christen@xxxxxxxxxx

Visit PAETEC.COM


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Vern Hamberg
Sent: Friday, September 04, 2009 7:57 AM
To: RPG programming on the IBM i / System i
Subject: Re: SQL CAST with Common Table Expression

This list is the ultimate blank wall - talking to a blank wall is what usually helps me get the answer.

:-)

Vern

Dennis Lovelady wrote:
I have the following code in an ILE RPG program at V5R4, and it fails
at the FETCH with an SQL0420 error (Character in CAST argument not
valid). I have added the CAST() functions as you see here in an
effort to eliminate the error, but no go. I am sure that I'm
overlooking something, but it evades me completely. Can you help? I
believe that everything pertinent to this question is below.


Never mind. I see the mismatch in number of columns. :( I stared at
this all evening yesterday, slept on it... came back fresh, and it
wasn't until I had sent this message.... Well, balderdash! :)

Sorry, folks!

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"A bore is a man who, when you ask him how he is, tells you."
-- Bert Leston Taylor


--
This is the RPG programming on the IBM i / System i (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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.