Synametrics Technologies

The database type is DB2. When a table is selected and I choose 'Generate CREATE TABLE statement', the dialog box that appears contains only the word 'GO'. No SQL statement is displayed. What am I doing wrong?

Thanks, David.

David,

This could happen if your user ID does not have permission to query system tables in the database. WinSQL uses two ways to generate the CREATE TABLE statement:

1. By manually creating the statement based on the columns
2. Using the SQL script specified in the Database Plugin. These scripts query some system tables in the back-end to fetch additional meta-data for the columns.

If you chose the "Generic ODBC" plugin when connecting to DB2, WinSQL will always use method number 1, which works in most cases. On the other hand, it will use method #2 if a plugin is selected.

Try running WinSQL in debug mode. This will log the exact error in the log file that will help you understand why it is not able to generate the CREATE TABLE statement. Check http://web.synametrics.com/DebugMode.htm for details about debug mode.

Regards,

Imran