bonjour a tous.
S'il vous plait quelqu'un pourrait il m'aider a trouver ou se trouve l'erreur de syntaxe dans cette requete :

Code : Sélectionner tout - Visualiser dans une fenêtre à part
UNLOAD to liste_RtoN_00001.txt SELECT arretN.age,dev,ncp,clc,nom[1,20],pre[1,15],dco,ddm,arr,sde,arretN.aut,mvtcm,mvtcm_1,mvtcm_2,mvtdm,mvtdm_1,mvtdm_2,agiom_1,agiom_2,ges,lib1 from arretN,bkcli,bknom where arretN.age=bkcli.age and arretN.ncp[1,7]=bkcli.cli and ctab=035 and cacc=bkcli.ges and arr="R";
arretN, bkcli et bknom sont des tables de ma base.

voici l'exception que l'execution de cette requete souleve :

java.sql.SQLException: A syntax error has occurred.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:373)
at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3207)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3517)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2352)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2268)
at com.informix.jdbc.IfxSqli.executePrepare(IfxSqli.java:1152)
at com.informix.jdbc.IfxPreparedStatement.e(IfxPreparedStatement.java:318)
at com.informix.jdbc.IfxPreparedStatement.a(IfxPreparedStatement.java:295)
at com.informix.jdbc.IfxPreparedStatement.<init>(IfxPreparedStatement.java:165)
at com.informix.jdbc.IfxSqliConnect.h(IfxSqliConnect.java:5880)
at com.informix.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java:1991)
at logiquemetier.Traitement_scriptsql.processquery(Traitement_scriptsql.java:230)
at mainpackage.ArreteFrame.actionPerformed(ArreteFrame.java:302)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
je vous remerci grandement pour votre aide.