error while loading data

[Former Member]

Hi,

I am getting this error while loading data between two IQ servers.

Thanks in advance,

Santosh Negalur

[tayeb_hadjou · Accepted solution]

Hi Santosh,

Insert LOCATION syntax is used with open client connections, which means remote IQ server should be referenced in interfaces file (or sql.ini file for Windows).

That's why the origin error is an Open client error (Ctlibrary), not IQ native error.

If you intended to copy using declared remote IQ server, you need create proxy table in IQ_local db mapped to IQ_remote table, then copy using another syntax:

/* create IQ_loc_table and copy in one statement */

select * into IQ_loc_table from proxy_IQ_table.., ;

/* copy to existing IQ table */

insert into IQ_loc_table select * from proxy_IQ_table ;

Keep in mind that insert/location is much more performant, than copying via proxy tables.

Regards,

Tayeb.

[Former Member · Accepted solution]

Thanks Tayeb,

Now its working, I forgotten to add remote server name in .sql file.

Regards,

Santosh Negalur