Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    15

    Unanswered: Precompiler refuse int type in EXEC SQL BEGIN DECLARE SECTION

    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
    Last edited by Dave Rush; 07-06-04 at 10:04.

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    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.
    --
    Jonathan Petruk
    DB2 Database Consultant

  3. #3
    Join Date
    Jun 2004
    Posts
    15

    Following Thread

    Hello Jonathan,

    Thanks for the killing answer I am dead know

    Ok, Is it possible to change the precompiler for one that accept the int type ??

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •