topic May you help me with the script generator for db2? in QlikView

May you help me with the script generator for db2?

Wed, 07 Dec 2011 08:25:29 GMT

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

May you help me with the script generator for db2?

Wed, 07 Dec 2011 16:55:38 GMT

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

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

Silly of me...

Fabio

Re: May you help me with the script generator for db2?

llauses243 — Wed, 07 Dec 2011 17:23:15 GMT

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