Re: SQLl5011 error again

[Alan Cassidy <cfuture@xxxxxxxxxxx>]

Spoke too soon. That was a different source that compiled, a previous 
version of the same program.

so back again to :

SQL0511.
"Host structure not defined or not usable. Reason: *The datetime format 
of a member of the host structure array does not match the SQL datetime 
format.*"

I have put DATFMT(*ISO) into the CTL-OPT parameters  in RPG, and added 
_EXEC SQL SET OPTION DATFRM(*ISO)_ to the SQL options.

How about it?

--Alan


On 6/9/2021 9:16 AM, Alan Cassidy wrote:
> I finally thought about putting DATFMT(*ISO) into the CTL-OPT 
> parameters and using EXEC SQL SET OPTION DATFRM(*ISO).
>
> Okay, now it compiled.
>
> The proof of the pudding will be in testing the program.
>
> Thanks to everybody!!
>
> Alan Cassidy
>
>
> On 6/9/2021 8:40 AM, Alan Cassidy wrote:
> > I noted that this issue was resolved before,  and the way it got 
> > resolved was I compiled the QSQLSRC output of the program and saw 
> > what was wrong.
> >
> > I inadvertently overlaid that code from the previous version of it 
> > (from Production) and now I'm getting a different error message 
> > Reason with SQL5011.:
> >
> > "Host structure not defined or not usable. Reason: *The datetime 
> > format of a member of the host structure array does not match the SQL 
> > datetime format.*"
> >
> > Is there an SQL option or an RPG pre-compiler value that can help for 
> > this one. I compiled the SQLRPGLE with RPGPPOPT(*LVL2) and then 
> > compiled the QSQLSRC-RPG output but that didn't help either, it
> >
> > Is there a solution to handling the "datetime /*format*/ matching" 
> > issue here? It's happening at the cursor open statement, not the fetch.
> >
> > I /think/ it had been working but I'm not sure now... Compiling the 
> > QSQLSRC output, searching IBM's web pages about it, searching 
> > midrange list archives, isn't helping.... :(
> >
> > --Alan (aec)