Hello, Both statements below can be executed under Windows MaxDB 7.5 without problems. With Linux and SAP DB 7.4 a database exception occurs (-2003, "Output columns too long", JDBC).
There seems to be an internal limit. Is there a way to adjust this limit? Why is there a difference between Linux and Windows or 7.4./7.5? What do you suggest to circumvent this? Regards, Matthias SELECT contract.scn,contract.carrieraccessstatus,contract.containerTypes,contract.r emarks,contract.carrierstatus,contract.template,contract.durationTo,contract .originRegion,contract.vip1IsPerc,contract.clientName,contract.vip2IsPerc,co ntract.fac120,contract.destinationRegion,contract.mqc20teu,contract.isClient Contract,contract.vip2onVip1,contract.email,contract.fac1IsPerc,contract.vip 220,contract.carrierId,contract.fac140,contract.vipInfo,contract.dateOfIssue ,contract.vip120,contract.emailCc,contract.durationFrom,contract.comGrouping ,contract.activatestatus,contract.mqc40teu,contract.currency,contract.isActi ve,contract.emailBcc,contract.demurrage,contract.vip240,contract.clientcontr acttype,contract.issuedBy,contract.detention,contract.contractowner,contract .vip140 FROM contract WHERE scn=�?� select t.scn,t.carrieraccessstatus,t.containertypes,t.remarks,t.carrierstatus,t.tem plate,t.durationto, t.originregion,t.vip1isperc,t.clientname,t.vip2isperc,t.fac120,t.destination region,t.mqc20teu,t.isclientcontract, t.vip2onvip1,t.email,t.fac1isperc,t.vip220,t.carrierid,t.fac140,t.vipinfo,t. dateofissue,t.vip120,t.emailcc,t.durationfrom, t.comgrouping,t.activatestatus,t.mqc40teu,t.currency,t.isactive,t.emailbcc,t .demurrage,t.vip240,t.clientcontracttype, t.issuedby,t.detention,t.contractowner,t.vip140 from contract as t where scn=�?� com.sap.dbtech.jdbc.exceptions.DatabaseException: [-2003] (at 637): Output columns too long at com.sap.dbtech.jdbc.packet.ReplyPacket.createException(ReplyPacket.java:69) at com.sap.dbtech.jdbc.ConnectionSapDB.throwSQLError(ConnectionSapDB.java:768) at com.sap.dbtech.jdbc.ConnectionSapDB.execute(ConnectionSapDB.java:434) at com.sap.dbtech.jdbc.CallableStatementSapDB.sendCommand(CallableStatementSapD B.java:1498) at com.sap.dbtech.jdbc.StatementSapDB.sendSQL(StatementSapDB.java:725) at com.sap.dbtech.jdbc.CallableStatementSapDB.doParse(CallableStatementSapDB.ja va:224) at com.sap.dbtech.jdbc.CallableStatementSapDB.constructor(CallableStatementSapD B.java:175) at com.sap.dbtech.jdbc.CallableStatementSapDB.<init>(CallableStatementSapDB.jav a:79) at com.sap.dbtech.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:66 0) -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
