Disconnect the internal links when more than one tables are in the script???

[#1]

Hi All,

I have one document where i am calling so many tables in the script.

The script automatically creates the joins for which i am getting the wrong result.

Can i avoid the links / disconnect the links by any way?

(Note: I know i can create alias by different names, but thats not the solution for me, as for security i want the keys to be there as well.)

I dont know what could be the solution,but please provide me some solution for the same.

Thanks,

Mahasweta

[#2]

hi

just add "qualify * ; " on the beginning of your script

this will add table name as prefix to the field names, hence there will be no linkage

regards

peter

[#3]

please use keyword NoConcatenate

[#4]

Hi Peter,

Thanks a ton for the quick reply.

This helped the way you said ,but that was not the exact solution for my issue.

This way there is no relation in between the keys at all ,which is not fetching any combination records for me.

i want some keys to be there as well.

Like i have some Product_num, location_num ,Date_id which needs to be a key through out.

So how i will achieve the same?

Thanks,

Mahasweta

[#5]

Hi Ashish,

Thanks a ton for the quick reply.

i have implemented the same but i didnt get the exact solution.

Will you please tell me what i am missing ?

Thanks,

Mahasweta

[#6]

try if below helps

qualify *;

Table1:

load f1,f2,f3 from file1;

Table2:

load f1,f2,f3 from file2;

load Table1.f1 as Key, Table1.f2, Table1.f3 resident Table1;

load Table2.f1 as Key, Table2.f2, Table2.f3 resident Table2;

drop table Table1;

drop table Table2;

[#7]

Reply Suggest as Answer More

csavgssc replied on 11-30-2009 7:45

corrected one

qualify *;

Table1:

load f1,f2,f3 from file1;

Table2:

unqualify *;

load f1,f2,f3 from file2;

load Table1.f1 as Key, Table1.f2, Table1.f3 resident Table1;

load Table2.f1 as Key, Table2.f2, Table2.f3 resident Table2;

drop table Table1;

drop table Table2;

[#8]

Hi Peter,

One more quick check please?

Do i need to load all the fields from the resident table?

as you said

load Table1.f1 as Key, Table1.f2, Table1.f3 resident Table1; ---line 1

load Table2.f1 as Key, Table2.f2, Table2.f3 resident Table2;

drop table Table1;

drop table Table2;

So for the line 1 do i need to call all my feilds here or only the key is okay, like load table1.f1 as key from resident table1; i hope yes i need to call all these as its throwing error.

Can i write load table1.f1 as key, table1.f2 as key resident table1;

I mean can i keep multiple keys in the load statement.as i have to keep more than 3 keys through out the script.

Thanks,

Mahasweta