>The error i got is "Function sequence error", my sample is just for illustration purpose, I do not hard code the connection handle. One of my colleague came across some interesting information, he said the problem is within the microsoft OBDC driver installed with xp driver and not with DB2. Do you know is there a way to call or use a specific OBDC driver within vfp?

Sure. You specify which ODBC driver to use when you create DSN or use SQLSTRINGCONNECT().