RE: SQL CAST with Common Table Expression

The guys in the white coats are usually very helpful as well.
They are always wanting to help me put on a jacket


Alan Shore
Programmer/Analyst, Distribution
E:AShore@xxxxxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill



"Christen, Duane"
<Duane.Christen@P
AETEC.com> To
Sent by: RPG programming on the IBM i /
rpg400-l-bounces@ System i <rpg400-l@xxxxxxxxxxxx>
midrange.com cc

Subject
09/04/2009 09:37 RE: SQL CAST with Common Table
AM Expression


Please respond to
RPG programming
on the IBM i /
System i
<rpg400-l@midrang
e.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.

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