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