Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I have partial reload of 1 table with the following script:
QUALIFY *;
UNQUALIFY [Calendar*], [CurrencyRate*], [Stoma];
[LedgerTrans]:
REPLACE LOAD
OFFSETACCOUNTTYPE & '-' & ACCOUNTTYPE_TXT AS TypeOfAccount,
OFFSETACCOUNT & '-' & ACCOUNTTYPE AS TypeOfCount,
...
;
SQL EXEC sp;
But after partial reload I don't get my table LedgerTrans replaced, but duplicated with the new table LedgerTrans-1
Is it because of using QUALIFY *; ?
Thanks in advance.
Regards,
Kristina
Hi Kristina
It is I guess a behaviour of Qualify.
Because you first table was qualified fields are named like 'ledgertrans.filedname1', ...
When you replace the filed are not qualified before load but after so there is a difference between names and a second table shows up.
You shoul better use alias instead of qualify ( or tmp table, to load before replace, drop old one and rename new one.)
best regards
Chris
Hi Kristina
It is I guess a behaviour of Qualify.
Because you first table was qualified fields are named like 'ledgertrans.filedname1', ...
When you replace the filed are not qualified before load but after so there is a difference between names and a second table shows up.
You shoul better use alias instead of qualify ( or tmp table, to load before replace, drop old one and rename new one.)
best regards
Chris
Thank you, Chris!
You are absolutely right.
Thank you!