Problems with resident load and binary!

Fri, 31 Oct 2014 14:50:37 GMT

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!

Re: Problems with resident load and binary!

Fri, 31 Oct 2014 15:13:33 GMT

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

topic Problems with resident load and binary! in QlikView

Problems with resident load and binary!

Re: Problems with resident load and binary!