RE: SQL CAST with Common Table Expression

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.