Sybase IQ export/import

[Former Member]

Hey guys,

I am a SAP BO developer.

Looking for some options to copy data from IQ16 production db to QA/UAT environments.

I only need subsets of data(specific dates), not full table.

Can some one suggest practical options possible?

Thank You

Binu Varghese

[tayeb_hadjou · Accepted solution]

Hi Binu,

A- Insert/location method :

1- In interfaces file (or sql.ini for windows) of QA/UAT environement, you need add IQ prod name and host/port of the IQ Prod server

2- a user in QA should exist also in Prod with same username/password

3- in QA env Execute.

INSERT INTO QA_table

LOCATION 'Prod_IQ_eng_name.IQ_Prod_db_name'

{ SELECT col1, col2, col3,... FROM owner.IQ_Prod_table where ...}

More info (import from IQ or ASE):

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc01773.1604/doc/html/wil1288127021315...

B- Extract/load method:

See sample example provided here  https://scn.sap.com/thread/3655796

Regards,

[Former Member · Accepted solution]

Hi Tayeb,

Thank you for a comprehensive reply, I will evaluate and confirm.

One more query, does BCP work with Sybase IQ(15/16)?

Regards,

Binu

[tayeb_hadjou · Accepted solution]

No it does not.  At least it is not supported with IQ.

However, if you have data exported in format bcp character (eg. "bcp out -c"  from ASE db), use

Load Table .. FORMAT BCP

Regards, Tayeb.