Did those variables have values you expected at the time it executed the
open C1? Remember that values of host variables take effect at the time
the cursor open.
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Doug Palme
Sent: Thursday, August 02, 2007 8:38 AM
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: MIR signature version 1
My apologies for making this more difficult.......you are correct I am
typing out the values in strsql, but I did not think that was an issue
since I have the variables defined as d specs and have verified I am
passing in the values BEFORE the sql statement is run.
Here is EXACTLY what I am typing in strsql:
SELECT SUM(SLEXT$) FROM SLSTRNL5 WHERE SLTDAT >20070722 AND SLTDAT <
=20070801 AND SLSHRT=' ' AND SLCLAS > 1 AND SLACCT = 10103900
Now the order of criteria fields has varied some, but in the end I am
using the same fields and the same values between both the rpg and the
strsql
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of qsrvbas@xxxxxxxxxxxx
Sent: Wednesday, August 01, 2007 9:41 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Re: MIR signature version 1
rpg400-l-request@xxxxxxxxxxxx wrote:
1. RE: MIR signature version 1 (Doug Palme)
because it should be returning 110.45.....I know that is beyond the
scope of this forum, but the same statement runs in strsql......
Doug:
Please note that "the same statement" CANNOT run in STRSQL.
That is, the statement that you are showing us has host-variables.
You can't use host variables in STRSQL. Therefore, you must be typing
constant values in.
We can't see how those values are being typed in and we don't see what
the definitions of host variables are in the program.
Perhaps if you showed us precisely what statement 'works', we could
suggest things to look for in your program.
Tom Liotta
--
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone 253-872-7788 x313
253-479-1416
Fax 253-872-7904
http://www.powertech.com
--
This is the RPG programming on the AS400 / iSeries (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 transmission may contain information that is privileged,
Confidential and/or exempt from disclosure under applicable law.
If you are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution, or use of the information contained
herein (including any reliance thereon) is STRICTLY PROHIBITED. If you
received this transmission in error, please immediately contact the
sender and destroy the material in its entirety, whether in electronic
or hard copy format. Thank you.
************************************************************************
****
--
This is the RPG programming on the AS400 / iSeries (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.
midrange.com
