topic Re: Problem in database script in QlikView

Re: Problem in database script

pavansonu99 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have database IBM DB2 ,so i have small doubt whether i have to write SQL to fetch data from database or i have to use IBM BD2.

what script i have to use in QV script editor (IBM DB2 or SQL)

Re: Problem in database script

vishsaggi — Wed, 01 Mar 2017 19:14:05 GMT

Once you connect to your IBM DB2 database.

Just use a preceding load with Select statement.

LOAD *;

SELECT Col1, Col2, Co3

FROM table1

INNER JOIN

table2 ON .....

Where ...... ;

Re: Problem in database script

maxgro — Wed, 01 Mar 2017 19:23:30 GMT

you have to write SQL to fetch data (SQL for IBM DB2)

SQL

SELECT ......................;

if you want to add some transformation you can use a preceding load

Preceding Load

Re: Problem in database script

Peter_Cammaert — Wed, 01 Mar 2017 19:27:14 GMT

IBM DB2 is the über-RDBMS, so SQL will be its native query language. Actually IBM invented SQL as a database query language so I think you will be safe when using SQL to extract information from DB2.