Re: sql5011 error

[Charles Wilt <charles.wilt@xxxxxxxxx>]

It's giving you the reason:
Reason: The host variable is not defined or is  not a valid structure. A
valid host structure must have at least one valid member.

Do you have a typo in the record name?

Has the record name been renamed on the f-spec?

Try compiling as just an RPG program to see what the RPG compiler says.

Charles

On Tue, May 25, 2021 at 7:34 AM Alan Cassidy <cfuture@xxxxxxxxxxx> wrote:

> 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
>
>
>
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com