Issue with loading data from one table and dropping the same table from where data has been loaded

[#1]

Hi All,

I am retrieving the admin login from from different table(mfac_mst) which i want to insert into the below table and drop the table(mfac_mst) to avoid the synthetic key. Let me know how to do that. If I follow the below method though the table has been dropped synthetic key has been formed. Some one let me know how to over come this problem.

TempTab:
LOAD DISTINCT
 account,
 mfaccode,
 [userid],
 [password]
resident items;

// Loading admin login from mfac_mst

CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=mercury;Initial Catalog=VPDPL-1;Data
Source=GL28;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=GL28;Use Encryption for
Data=False;Tag with column collation when possible=False];

Tab1:

select * from mfac_mst;

select rtrim(c_account_code)+rtrim(c_loginid) as userid,rtrim(c_password) as password,c_account_code as SecurityAccount,
'*' as SecurityMfa from mfac_mst where c_loginid in('vadmin','admin');

drop table Tab1;

//////////////////////////////////////////////

Thanks and Regards,

Rikab

[#2]

Hello Oleg!

Any update? I am waiting for your reply!

Thanks and Regards,

Rikab

[#3]

Hello Oleg

Please provide some solution for me. It's been very long since I am waiting for your solution.

Thanks and Regards,

Rikab

[#4]

Hello Oleg!

Did you find any solution for this issue. Please help me out when you get free time.

Thanks and Regards,

Rikab