Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using just one App to load all my data from Oracle into my QVDs, then loading other apps from the QVDs. the issue it trys to create loads of synthetic keys and runs for hours, i dont need it to do this.
how can i stop the script running?
I have tried a simple End; or Exit Script; and neither seem to work
I would recommend you to drop tables when you have no more use for them in your db extract application.
Eg
Account:
SQL LOAD * FROM DB.dbo.ACCOUNTTABLE;
STORE Account into Account.qvd;
Drop table Account;
Location:
SQL LOAD * FROM DB.dbo.LOCATIONTABLE;
STORE Location into Location.qvd;
Drop table Location;
I would recommend you to drop tables when you have no more use for them in your db extract application.
Eg
Account:
SQL LOAD * FROM DB.dbo.ACCOUNTTABLE;
STORE Account into Account.qvd;
Drop table Account;
Location:
SQL LOAD * FROM DB.dbo.LOCATIONTABLE;
STORE Location into Location.qvd;
Drop table Location;