topic Looping multi DBs like PHP in QlikView

Looping multi DBs like PHP

Mon, 16 Apr 2012 15:00:54 GMT

Hello Friends.

I have 2 DBs (CLIENTS, RENT), with two different ODBC connections.

When I try to connect in PHP do the following way:

PHP SINT
//FIRST ODBC CONECTIONS NEW() ODBC1; ODBC1->QUERY("SELECT * FROM CLIENTS.ACTIVES"); while( $A = ODBC->FETCHARRAY()){ //SECOND ODBC CONECTIONS NEW() ODBC2; ODBC2->QUERY("SELECT * FROM RENT.DEBTOR WHERE CLIENT_ID = '".$A[ID]."' "); BLA BLA BLA } PRINT CLIENTS ACTIVES AND RENT DEBTOR....

PHP SINT

//FIRST ODBC CONECTIONS

NEW() ODBC1;

ODBC1->QUERY("SELECT * FROM CLIENTS.ACTIVES");

while( $A = ODBC->FETCHARRAY()){

//SECOND ODBC CONECTIONS

NEW() ODBC2;

ODBC2->QUERY("SELECT * FROM RENT.DEBTOR WHERE CLIENT_ID = '".$A[ID]."' ");

BLA BLA BLA

}

PRINT CLIENTS ACTIVES AND RENT DEBTOR....

I can do something similar in QlikView?

Looping multi DBs like PHP

Jason_Michaelides — Mon, 16 Apr 2012 16:41:35 GMT

I don't know PHP so can't tell what the above code is doing, but what do you want to achieve in QV, exactly?

Looping multi DBs like PHP

Thu, 26 Apr 2012 12:22:09 GMT

Ok.

I solved.

//CONNECT TO DATA BASE 1
ODBC CONNECT TO DATABASE1
SELECT1:
LOAD *;
SQL SELECT * FROM DATABASE1.TABLE1;
//CONNECT TO DATA BASE 2
ODBC CONNECT TO DATABASE2
//LOOP
FOR i=1 TO NoOfRows('SELECT1')
LET ID=FieldValue('ID',$(i) );
SELECT2:
LOAD *;
SQL SELECT * FROM DATABASE2.TABLE2 WHERE ID=$(ID);

NEXT