Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to retain a pre loaded table when running a script?
If possible I would like to retain a table without having to reloaded it from source files when I run a full load.
Have a look at the addload, partial reload and resident load.
I have tried to use the resident load but have not got it to work.
If the table is table1, what is the syntax in the script fi I want to keep table1 and not lose it when I run a load script.
I have tried Load * resident table1, but get an error.
if the table you want to keep is a slow changing table you can use buffer.
I.E, this table values will be kept for 10 days in buffer after the first reload with the buffer fucntion
buffer (stale after 10 days)
LOAD TaskUID,
TaskParentUID,
ProjectUID,
TaskName,
text( "WBS Code") as "WBS Code",
"Task Status";
SQL SELECT *
FROM "ProjectServer6516_Reporting".dbo."MSP_EpmTask_UserView";
I hope this is what you need