Re: SQL CTE with no results

Buck,

Had been doing that. Each and every step. Turns out it works
as designed. Wrong file was in play. Timing is everything.
I was intrigued by CAST. I'll try that and see if the sql error
goes away.
Thanks for the suggestions to you and Rob. Sometimes you
just need to step back. That had me puzzled for 3 hours.
I'm too old for that kind of nonsense.


Bill




From: Buck Calabro <kc2hiz@xxxxxxxxx>
To: midrange-l@xxxxxxxxxxxx
Date: 12/20/2016 04:46 PM
Subject: Re: SQL CTE with no results
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



On 12/20/2016 4:40 PM, broehmer@xxxxxxxxxxxxxxx
wrote:

Yep, state is 02000. Both the item (spitm1 thru 5) are all 6S 0
externally defined
as well as FXITEM (6s 0). The only message I get while I am stepping

thru

is that
SQL7919 shows up with reason 2-Host variable GROSS is a numeric type

that

is different than the type of the value being retrieved....hmm. But it
also says the
statement ran correctly. I've now run it with GROSS defined as int as
well as
decimal. Both give same 0 results.

This error is because SUM(TOTAL) doesn't match GROSS. Just
CAST(SUM(TOTAL), len, precision) and that will go away.

To get some more info on your situation, take Rob's advice and
dump/inspect/print SQLSTATE after each and every SQL statement.