Hi There,

I'm working on a webFocus report to merge data from two Oracle databases (on different server hosts). I tested each SQL Query separately, they work fine.
But if I put them in one procedure file, they don't work, just hang there.

My environment
==============
WebFOCUS:5.3
os server: UNIX
Oracle DBs: both Oracle Database are 9i


Sample Code
===========
-*-----------------------
SET SQLENGINE=SQLORA
SQL SET SERVER db_server1
SQL
select * from table1
;
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS SQLtmp1
END
-RUN
-*-----------------------
SET SQLENGINE=SQLORA
SQL SET SERVER db_server2
SQL
select * from table2
;
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS SQLtmp2
END
-RUN

TABLE FILE SQLtmp2
PRINT
*
END
-RUN

========================


Could someone tell me why the above code don't work?

Thanks,
Yi (William)Zhu

This message has been edited. Last edited by: Kerry,

Yi

where does it hang?

if you add some lines like

-SET &ECHO=ALL;
APP HOLD BASEAPP

You may see where it hangs and if one or two of the hold files will be created.

What happens if you restrict the the selection to less records?

Hi,

It's my fault. Actually, It works.

Working Code
===========
-*-----------------------
SET SQLENGINE=SQLORA
SQL SET SERVER db_server1
SQL
select * from table1
;
TABLE ON TABLE HOLD AS SQLtmp1
END
-RUN
-*-----------------------
SET SQLENGINE=SQLORA
SQL SET SERVER db_server2
SQL
select * from table2
;
TABLE ON TABLE HOLD AS SQLtmp2
END
-RUN

TABLE FILE SQLtmp2
PRINT
*
END
-RUN

========================

Thanks,