May you help me with the script generator for db2?

[#1]

I cannot use this scripte generator: sql_db2_script_generator.qvw (You can find it in this forum).

I put my Odbc connection in the pannel control, odbc etc...

I got these messages:

SQL##f - SqlState: S0002, ErrorCode: 4294967092, ErrorMsg: [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0204 - TABLES in SYSCAT di tipo *FILE non trovato.

"DB2 Tables":

SELECT

TABNAME AS DB2_TABLE_NAME,

TYPE AS DB2_TYPE,

TABSCHEMA

FROM syscat.tables

SQL##f - SqlState: S0002, ErrorCode: 4294967092, ErrorMsg: [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0204 - COLUMNS in SYSCAT di tipo *FILE non trovato.

"DB2 Columns":

SELECT

    TABNAME AS DB2_TABLE_NAME,

    COLNAME AS DB2_COLUMN_NAME

FROM SYSCAT.COLUMNS

What is neccessary to change?

Mine is a standard AS400 with the common libraries etc...

Thanks in advance

[#2 · Accepted solution]

Problems solved.... different names of tables and columns ....

Sometime is just necessary to connect the brain....

Silly of me...

Fabio

[llauses243]

Hi tode,

This is my offer ...

.  Left sequence with error & ok, pls to see .rar attached

.  Pls to check if exists syscat library and columns selected

Good luck, Luis