Problem is, I have 15 tables to pump.
For now I made a list of table names
char *stbl[]={"TAB1","MYTAB","BLA","DOM_PAY"};
char *dtbl[]={"TAB1","MYTAB","BLA","DOM_PAY_LV"};
Then in separate function (DoPump) I had
char * format="Select * from %s"
and I pumped
for(int i=0; i<15;i++)
DoPump(stbl[i],dtbl[i]);

Simple and easy. Well as it now seems - too easy.
But why can the DataPump mach columns during design time, when I double-click on this component , enter the select* statements directly there and press Prepare?


Riho-Rene Ellermaa
senior programmer



The main thing is to replace that SELECT statement in the destination
ib_cursor.

Helen



[Non-text portions of this message have been removed]