Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Partner
Partner

Write from Qlikview to DB2?

Hello,

I'm trying to perform insertion into AS400/DB2. I've created a system DNS into ODBC Data Source Administrator with the following configuration.

0.D54.gif

I have write permissions with my userid but when I launch the reload with QlikView the permission to write is denied, because "the connection is set to read-only"

In QlikView I've just put the settings like this but still doesn't work.

167709_QV3 (1).jpg

I think should be some setting of the DNS that should allow to write on db. Any suggestion?

1 Solution

Accepted Solutions
Partner
Partner

Re: Write from Qlikview to DB2?

It seems a problem with ODBC driver configuration.

The solution is to set a OLE DB connection putting the IP address of the DB.

View solution in original post

1 Reply
Partner
Partner

Re: Write from Qlikview to DB2?

It seems a problem with ODBC driver configuration.

The solution is to set a OLE DB connection putting the IP address of the DB.

View solution in original post