Re: sql5011 error

[Alan Cassidy <cfuture@xxxxxxxxxxx>]

Justin,

I appreciate your reply. I tried compiling with the RPGPPOPT(*LVL2) and 
got the same message with the same reason text. And the reference page 
at IBM for the error says this is the modified SQL5011 with the 
clarification of a reason..

--Alan



On 5/25/2021 2:11 PM, Justin Taylor wrote:
> I'd guess the precompiler doesn't see the LikeRec().  I always compile
> SQLRPGLE with the RPGPPOPT(*LVL2) parameter, because it often helps in
> situations like this.
>
> HTH
>
>
> date: Tue, 25 May 2021 09:34:05 -0400
> > from: Alan Cassidy <cfuture@xxxxxxxxxxx>
> > subject: Fwd: sql5011 error
> >
> > See below the SQL precompiler errors I'm getting. The SQL5011 is the
> > most obstinate for figuring out.
> >
> > I searched the archives and it was not specific enough to the reason
> > text or my situation.
> >
> > My best guess WAS an incompatibility between RPG and DDS date types and
> > SQL date types, because there are about five DDS fields defined as
> > having DATE type.
> >
> > A couple of those dates have almost all default dates (0001-01-01). I
> > may list out only the fields that are actually used in the program, but
> > I'd first like to have a better idea about this. One of the issues in
> > the archives I saw noted that the pre-compiler pointed the finger at the
> > first subfield brought in from the file).
> >
> > --Alan
> >
> >
> > dcl-DS MT LikeRec( CS15R) DIM( 500 ) ;
> > .? . .
> >
> >   ?1080????????? exec sql SET OPTION DATFMT = *ISO ;
> >   ?1081????????? exec sql SET OPTION CLOSQLCSR = *ENDMOD ;
> >   ?1082????????? exec sql SET OPTION COMMIT = *NONE ;
> >   ?3692?? c024??? exec sql Fetch next from CK for :Rows_to_fetch rows
> > into :MT ;
> >   ?3709?? c024?????? exec sql Fetch next from CK for :Rows_to_fetch rows
> > into :MT ;
> >
> > DIAGNOSTIC MESSAGES
> > SG ID? SEV? RECORD TEXT
> > SQL5066?? 0??? 1080? Precompile option DATFMT changed by SET OPTION
> > statement.
> > SQL5066?? 0??? 1081? Precompile option CLOSQLCSR changed by SET OPTION
> > statement.
> > SQL5066?? 0??? 1082? Precompile option COMMIT changed by SET OPTION
> > statement.
> > SQL5011? 30??? 3692? Position 67 Host structure array MT not defined or not
> >   ??????????????????? usable. Reason: The host variable is not defined or is
> >   ??????????????????? not a valid structure. A valid host structure must
> > have
> >   ??????????????????? at least one valid member.
> > SQL5011? 30??? 3709? Position 70 Host structure array MT not defined or not
> >   ??????????????????? usable. Reason: The host variable is not defined or is
> >   ??????????????????? not a valid structure. A valid host structure must
> > have
> >   ??????????????????? at least one valid member.
> > SQL0104? 30??? 3709? Position 72 Token ( was not valid. Valid tokens:
> > <END-OF-STATEMENT>.
> >   ?????????????????? Message Summary