Re: Wrong resultset in MaxDB 7.6.0.27 with using UDF

Can somebody help me? select getQuant('155') from dbadmin.dual returns correct value without exception The statement SELECT * FROM invest WHERE cartnum=6280 and i.dateres='2006-05-25' returns one record but why SELECT getQuant('155') FROM invest WHERE cartnum=6280 and i.dateres='2006-05-2

Re: MaxDB 7.6.00.27 fetching UTF8 data from LONG column

Sven Köhler пишет: I have the same problem with UTF8 as with 7.6.00.16. I try to fetch LONG column in UTF-8 from Perl::DBD. The first LONG column in the first row is fetched wrong. I have 412 symbols but SQLDBC returns only 216 symbols. For this column SQLDBC returns indicator == SQLDBC_NO_TOTAL.

RE: How to Insert linefeed chatacter in a string

It's LONG, so I think that is really a "LONG VARCHAR". Anyway, I ended up doing it via a loadercli script. In there, I can insert the EOLN character by simply putting a newline in the script where I want the character to appear. Derek > Sorry, I did not read that you want to fill a LONG column

RE: How to Insert linefeed chatacter in a string

> It is sometime astonishing for us, that customer uses LONG-columns and > want to handle them with string literals and scripts, where usually > values are not that long. > You are sure that you need LONG-column and that no VARCHAR-column would > be convenient? It's not my choice. I'm using the

RE: JDBC 7.6.00.24.5241 error fetching timestamp fields

This is not an issue in the JDBC driver, but it looks whether it is some malfunction of the database kernel, returning illegal data for the time stamp. Would you mind posting the statement or procedure that raises this error? Regards Alexander Schröder SAP DB, SAP Labs Berlin -Original Mes

RE: -MaxDB error when trying to get online-

> I got the following error message when I tried to connect to > my database. > > ( -24988 SQL error [db_online -f]; -902,I/O error ) Check knlidag and dbmsrv.prt - and send them to the list if in doubts. Greetz, SIEGENIA-AUBI KG Informationswesen i.A. Markus Döhr SAP-CC/BC, SAPDB-DBA T

RE: How to Insert linefeed chatacter in a string

Sorry, I did not read that you want to fill a LONG column. The method I suggested only works for VARCHAR/CHAR columns. Sorry, for LONG values there is no such way. Regards Alexander Schröder -Original Message- From: Schroeder, Alexander [mailto:[EMAIL PROTECTED] Sent: Freitag, 2. Juni 2

RE: How to Insert linefeed chatacter in a string

Hello Derek, use something like INSERT INTO ABCDE VALUES ('ABC' || ASCII(x'0A') || 'DEF') (which obviously looks so strange that it can only be suggested if there's really no other alternative). Regards Alexander Schröder SAP DB, SAP Labs Berlin -Original Message- From: Derek M. A.

-MaxDB error when trying to get online-

Hello! I got the following error message when I tried to connect to my database. ( -24988 SQL error [db_online -f]; -902,I/O error ) Looked for a solution at: http://www.mysql.com/search/?q=-24988+SQL+error+%5Bdb_online+-f%5D%3B+-902%2CI%2FO+error&charset= and found this line... (If the error

Re: JDBC 7.6.00.24.5241 error fetching timestamp fields

Can somebody help? What does this exception mean? How can I fetch timestamp fields with JDBC 7.6.00.24.5241? Alexey Gaidukov пишет: org.medfoster.dbms.SQLCachedException: nanos > 9 or < 0 medorder_archive_model at java.sql.Timestamp.(Unknown Source) at com.sap.dbtech.jdbc.translators.