Home Ask Login Register

Developers Planet

Your answer is one click away!

Binu February 2016

Sysbase IQ Export and Import

I am Sybase BO Developer.

Looking for possible option top copy data from Sybase IQ production and load to QA/UAT.

Need only subset of data(based on dates), not full table.

What are the possible options.

Thank You Binu Varghese


Kimon February 2016

Check this http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00170.1540/doc/html/san1288042643642.html and the examples at http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00170.1540/doc/html/san1288042645377.html

The idea is that you set temp options for file name, directory etc, then run a query and the result set is sent to a file. Then you must write a load command in order to load this file. It seems a bit confusing at first but it is very fast

Post Status

Asked in February 2016
Viewed 1,758 times
Voted 5
Answered 1 times


Leave an answer

Quote of the day: live life