ESQLC --- Function Parameters as Host Variables

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • N.V.Dev

    ESQLC --- Function Parameters as Host Variables

    Hi,


    Would like to know if I could define function parameters as Host
    variables; This can be defined in Informix as below

    int
    print_table_inf o ( table_name )
    EXEC SQL BEGIN DECLARE SECTION;
    PARAMETER char *table_name;
    EXEC SQL END DECLARE SECTION;

    ......

    Tried incorporting the above syntax in DB2 but in vain. Compiler error
    is pasted below

    "db2_schema.sqc ", line 384.3: 1506-276 (S) Syntax error: possible
    missing '{'?


    Any help would be appreciated,
    Thanks,
    Dev
Working...