Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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 ...... ;
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
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.