October 15, 2014, 07:41 PM
Waz[Case Opened] Issues with using SAME_DB
Has anyone has issues using SAME_DB multile times in a fex ?
I have a procedure where I create several temp tables with FORMAT SAME_DB PERSISTENCE GLOBAL_TEMPORARY.
The Db is Oracle.
Something in the creation of the second temp table clears the records in the first. Then the third clears the second and so on.
October 15, 2014, 08:41 PM
Francis MarianiStupid question: do you have -RUN statements between each TABLE FILE statement?
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
October 15, 2014, 09:38 PM
WazShould have added that, tried with and without -RUN
Also tried setting AUTOCOMMIT to ON FIN
October 16, 2014, 07:44 PM
StuBouyerHave you tried using AS name?
i.e.
ON TABLE HOLD AS TAB_ONE FORMAT SAME_DB PERSISTENCE GLOBAL_TEMPORARY
...
ON TABLE HOLD AS TAB_TWO FORMAT SAME_DB PERSISTENCE GLOBAL_TEMPORARY
I have vague memories of doing this previously
Regards
Stu
October 16, 2014, 07:51 PM
WazYes, they are unique names.
The process for SAME_DB issues a CREATE, it would have failed.