December 15, 2008, 11:56 AM
<Vijaya_settu>Thank you all of you
Ginny - Just like you said , I tried the following example it did work. "TEST" is hold file of my oracle table . But Currenlty we have two oracle database one is production and another one is test. Currently this code is putting into my production. But i want the hold oracle in "Test" environment . is it possible can I put the hold oracle file in "Test" environent. Do i have to write the oracle connection somewhere in the code to point to "Test" environment.
TABLE FILE SQLSERVERTABLENAME
PRINT *
ON TABLE HOLD AS TEST FORMAT SQLORA
END
December 15, 2008, 12:11 PM
GinnyJakesquote:
Do i have to write the oracle connection somewhere in the code to point to "Test" environment.
Yes, you can put in right in front of the code you have in your post.