Problems with resident load and binary!

[#1]

Hi everybody.

i have this code

(I loaded the table LT with a binary)

TEP:

LOAD *

RESIDENT LT;

LINK_TABLE:

LOAD *

RESIDENT TEP;

DROP TABLE TEP;

DROP TABLE LT;

EXIT SCRIPT;

And when i reload, this text is showed

What is happening?

Cheers!

[#2 · Accepted solution]

Hi Jeremias,

There's no text attached to your question.

Nonetheless, viewing the script, the tables are auto-concatenating.

Using "load *" from a resident table (and without "Qualify") will duplicate the records in the initial table LT.

TEP and LINK_TABLE will not be created, thus cannot be dropped.

If you need to create the tables TEP and LINK_TABLE separately, you'll need to use the "noconcatenate" before loading them:

Noconcatenate

TEP:

load *

resident LT;

Noconcatenate

LINK_TABLE:

load *

resident TEP;

This is only to explain what's happening.

Actually, as per your script, you don't need to load TEP and LINK_TABLE (since you're dropping them and without any modification done). But you can judge best according to what your real script may look like.

Hope this helps