WIN SQL is the normal editor used by most of the users .But we can't download large amount of data using winsql . So I have written a tutorial how to connect with a new Java based editor called Squirrel SQL which can easily download or export data in excel or any other formats. Also I included a Java JCBC connection program to connect with the IRIS database especially a mirroring/failover server.
SQL Java based Editor to Export large amount of data and Java JDBC program for IRIS connection
SQL Java based Editor to Export large amount of data
WinSql is the editor used normally to extract data