Re: SQLl5011 error again

[Alan Cassidy <cfuture@xxxxxxxxxxx>]

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)