Re: problem in execute dynamic SQL statemen

> Without seeing your query, I can Only guee at the problem. But when you are using dynamic SQL we define the query as follows: Update <table name> set col1 = ?, col2 = ? where col3 = ? then use a describe to describe the statement into sqlda structure, then assign sqlvar to point to the values we want. 1st sqlvar points to col1 information and data 2nd sqlvar points to col2 information and data 3rd sqlvar points to col3 information and data. How do we update only the records which have col3 as NULL. We just need to set sqlind in sqlvar structure to -1. We did that but when it executes the statement it does not update the record(s). Do i need to set anything else also in sqlvar to indicat a null value. Sorry about the version #, we use ESQL version 5.00 UC4. Thank You Shyam