Invisible tables in ODBC connection

[#1]

Dear All,

I've prepared a qv report that sources data from sql tables through two ODBCs i.e:

ODBC1

SQL database 1 CONCATENATE

SQL database 2 CONCATENATE

SQL database 3 CONCATENATE

ODBC2

SQL database 4 CONCATENATE

SQL database 5 CONCATENATE

SQL database 6

For some reason only tables from ODBC1 are sourced, tables from second ODBC2 are omitted. I've swapped the order i.e. ODBC2 went before ODBC1 and then only tables from ODBC2 were sourced. No error is shown after reload.

Any idea how to fix it?

BR,

Przemek

[spsrk_84]

Hi,

Check the cloud once the data is reloaded whether the tables what u got in data cloud contains data the data from both the ODBC connections,Since u r using the Concatenate Statement without any hint to which it has to be concatenated.else use this sort of syntax

A:

load * from Xyz.qvd;

Concatenate(A)

Load * from Pqr.qvd;

Please let me know if u r not clear with what i said to u.........

[#3]

I don't really know what you mean by data cloud - if this is all the data sourced by the script then there no records from the other ODBC dbs. I've changed to Concatenate (Tab) but still not working.

Any idea what else to do?

BR,

Przemek