Here I have a problem with an sql query involving a VARCHAR variable.
Eg: select count(*) from table_name where
sample_text <> : host-variable;
Here sample_text is a varchar variable of max lenght 500;
while executing this query I am getting -134 as SQL RETURN code.
Please help me out to over come this situation. I need to execute this query in a COBOL program using host-variable (COBOL host variables) in the condition against the sample_text (DB2 variable). Please give me the declaration for the COBOL host variable and how can I use this in my program.