Re: Embedded SQL Dynamic Selection -- MIDRANGE-L

Ok...I'm able to get this to compile. I still don't know what happened, but
I changed the file name and tried a compile. I received an error (the
SQL5011). I then looked at the object through debug. I was surprised to see
the new file definition. I know at one point I deleted the program object.
Is it possible that there was an SQL error but not a program creation
error, and the program object was created? I didn't really change anything
in the definition, and I've done dozens of compiles. I dunno...this was a
strange one. Something cached in WDSc 7 perhaps? Bad definitions in the
external data structure?

On Thu, Nov 8, 2012 at 2:55 PM, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

Along with having RPG date/time formats match SQL...

Make sure you don't have CVTOPT(*DATETIME) in effect.

Also note that IIRC correctly, while you can use quailified DS's at v5r4,
but you have to make sure that the subfield's unqualified names are unique
or at least if the name isn't unique the field types and sizes are the same
across all definitions.

HTH,
Charles

On Thu, Nov 8, 2012 at 1:22 PM, CRPence <CRPbottle@xxxxxxxxx> wrote:

On 08 Nov 2012 11:40, Michael Ryan wrote:

Still receiving the same error.

i.e. sql5011 on Fetch C1 For :Maxrows Rows Into :Wkinvmstp;

I seem to recall that if DATE [maybe TIME?] data type are involved,
then the RPG DATFMT and the SQL SET OPTION statement must effect
consistent settings for the Date Format betwixt.

FWiW: I seem to recall that neither the initial thread nor this one
had included both the RPG source and SQL DDL; only a couple very limited
snippets. I am sure I recall similar issues that have been discussed on
the RPG400 list; I think that was where I learned of some nuances with
DATE data typee. Also, this issue seems very likely to be specific to
the RPG, since the "host variables" are variables in the "host"
language... and so any issues would generally relate to the declarations
in that host language and the SQL pre-compiler's attempt to process the
SQL in relation to those HLL declarations.

--
Regards, Chuck
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.