Precompiler refuse int type in EXEC SQL BEGIN DECLARE SECTION

Dave Rush · #1 (**permalink**) 07-06-04, 08:30

I have a problem compiling my embedded sql:

db2 prep Dbprog.sqc bindfile gave me the following error.

172 SQL0008N The token "int" found in a host variable
declaration is not valid.

Is seems that the precompiler do not accept the int declarations, it accept only short or long. Is there a way to tell the precompiler to accept int variable like this

EXEC SQL BEGIN DECLARE SECTION;
int maj = 0;
int min = 0;
char pch = 0;
EXEC SQL END DECLARE SECTION;

Thanks

J Petruk · #2 (**permalink**) 07-06-04, 12:07

Quote:

Originally Posted by Dave Rush

I have a problem compiling my embedded sql:

db2 prep Dbprog.sqc bindfile gave me the following error.

172 SQL0008N The token "int" found in a host variable
declaration is not valid.

Is seems that the precompiler do not accept the int declarations, it accept only short or long. Is there a way to tell the precompiler to accept int variable like this

EXEC SQL BEGIN DECLARE SECTION;
int maj = 0;
int min = 0;
char pch = 0;
EXEC SQL END DECLARE SECTION;

Thanks

No, long and short only. I assume this is because "int" can be different things to different compilers, etc.