Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004

    Lightbulb Unanswered: java jdbc informix unload

    Im looking to see if i can get any help on how to execute an unload from my informix database table.

    Im tryint to execute this code getting a syntax error SQLException:


    Statement st = con.createStatement();
    st.execute( "unload to 'seriesNumericas' select * from serie_prueba_temp ");

    }catch(SQLException e){

    stacktrace :

    java.sql.SQLException: A syntax error has occurred.
    at com.informix.util.IfxErrMsg.getSQLException(IfxErr
    at com.informix.jdbc.IfxSqli.addException(IfxSqli.jav a:3086)
    at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.jav a:3396)
    at com.informix.jdbc.IfxSqli.dispatchMsg( :2259)
    at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.j ava:2179)
    at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.j ava:2067)
    at com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.j ava:2042)
    at com.informix.jdbc.IfxResultSet.executeExecute(IfxR
    at com.informix.jdbc.IfxStatement.executeImpl(IfxStat
    at com.informix.jdbc.IfxStatement.execute(IfxStatemen
    at MyProg.respaldaDatos(
    at MyProg.main(

    thanks in advance

    Ricardo L

  2. #2
    Join Date
    May 2004

    The UNLOAD command is not part of the Informix SQL DML, it is only understood from Informix tools such as dbaccess, sqleditor400 and isql and perhaps 4GL. You'll have to create your own using JDBC.
    Keith Brownlow
    ServerMetrics DB Monitoring (

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts