The problem here is not about syntax. I know to use SQL PASS THROUGH and connect and create databases in SQL SERVER from VFP. But for DB2, once you are connected to a database it does not allow to access other database or create a new database. So when i use SQLEXEC to issue a command to the backend(DB2), I am supposed to issue commands which apply to the database name given in the DSN. If I issue a command say "CREATE DATABASE TEST..." using SQLEXEC() function, it returns an error saying that "there is already a connection to existing database". So is there any way out to handle such a situation. Hope I am clear.