DBD::MaxDB problem: repeatedly executed statement fails to return records

Hi, I have been faced with a problem that is mindboggling, and I do not know how to further pursue it. Setup: maxdb 7.600.12 DBD::Maxdb 7.6.00.16, SUSE 9.3, Perl 5.8.6 as it came on Suse The program that I have this problem with has 4 statement handles open that are used sequentially. In the

Oracle VARCHAR datatype is replaced by MAXDB VARCHS datatype

Dear Sir, I wonder why the 'cpc' pre-compiler has replaced all VARCHAR data types with VARCHS which is not accepted by the Microsoft C Compiler. I checked the documentation of the pre-compiler , but the data type VARCHS is mentioned at all. I need to compile the generated C code using

RE: MAXDB cpc precompiler

Dear Thomas , Thanks for the info. , actually , Oracle Pre-compiler can do that and that's why we need this functionality in order to move our programs to use 'cpc' of MAXDB in case we want to replace Oracle DB by MAXDB. Oracle replaces EXEC SQL cursor statements with "static cons

RE: MAXDB cpc precompiler

Dear Rami, It is not possible to declare a cursor outside a C function. Since every EXEC SQL DECLARE call is mapped to a C Precompiler library function call that is surrounded with { }, you will always get a syntax error if you use that call outside a function. In general global embedded sql stat

MAXDB cpc precompiler

Dear Sir, Can I declare cursor as global ( outside the main() )? I tried to do it , but it gives an error when I compile the generated C code. If I can do it , tell me how ? and what's the general rules to declare global embedded sql statement? Thanks Rami

here is the example

Dear Thomas, You can find the hello world example @ http://www.sapdb.org/7.4/htmhelp/e7/ff8685dcd111d5994600508b6b8b11/content.h tm Thanks Rami

FW: I couldn't copy you the sample program cuz ur email server refused a msg more than 4000 and also I sent you but I got my email back !

Dear Thomas, I did , and the mail server returned back the msg,,. Thanks Rami Your message cannot be delivered to the following recipients: Recipient address: [EMAIL PROTECTED] Reason: Server rejected MAIL FROM address. Diagnostic code: smtp;550 Access denied Remote system: dns;smtpde0

Re: [BUG] SQLDBC and binding utf8 parameters

> the issue is known and was fixed already, however I have no schedule yet for > the next release > of MaxDB 7.6 on the MySQL web site. (and the next release will contain a > Perl DBI that > supports Unicode too, so you won't need the patched version anymore then > ...) Thank you. I'm looking for

RE: [BUG] SQLDBC and binding utf8 parameters

Hello Sven, the issue is known and was fixed already, however I have no schedule yet for the next release of MaxDB 7.6 on the MySQL web site. (and the next release will contain a Perl DBI that supports Unicode too, so you won't need the patched version anymore then ...) Regards Alexander Schröde

I couldn't copy you the sample program cuz ur email server refused a msg more than 4000 and also I sent you but I got my email back !

Dear Thomas As per your request , I've copied the sample program in my previous email , but the email server generated an error , >4000 char. I also tried to send you back , but access is denied !! Now tell me how you can help me ! Hope you can get this message Thanks Rami

Re: [BUG] SQLDBC and binding utf8 parameters

> I think you forgot to attach the trace. I think the attachement was removed by the list. Let's see, if it arrives this time. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MAXDB C pre-compie problem

Dear Sir, The list server filters the attatchments, so could you please send the HelloWorld example within the e-mail body? Did you try to precompile the program without the -c option? In this case an object file is generated by cpc and the correct include paths for compiling are used. Be

MAXDB C pre-compie problem

Dear Sir,   I tried to compile a HelloWorld example (attached) using the ‘cpc’ pre-compiler     cpc  -E cansi  -H nocheck -o -c -u dbadmin,rami123 -d maxdb1 HelloUnicodeDB   and it generated the .c file successfully , however , the c file does not compile and gives the following error

problem with trigger after update

Hello list, I'm trying to run a trigger on the following table T_PHARMACOECONOMICS id serial(10)... ... visit_date date oneyear_date date fiveyear_date date ... I need the values of oneyear_date and fiveyear_date be automatically generated from the visit_date column. I wrote a trigger for insert

RE: MAXDB C precompiler issues !!!

No you cannot. You have to use MaxDB's precompiler ('cpc') to precompile your embedded SQL program to a C program that contains the calls to the MaxDB database. Regards Alexander Schröder SAP DB, SAP Labs Berlin -Original Message- From: Rami AL-SAHHAR [mailto:[EMAIL PROTECTED] Sent: M

MAXDB C precompiler issues !!!

Dear Sir , I have a small question , Can I connect Oracle Pro*C program - written in ANSI C / ANSI SQL - to SAP DB? , the output program is C program with embedded SQL ? Thanks Rami AL-SAHHAR International Turnkey Systems (ITS), www.its.ws Dear Sir, We

RE: [BUG] SQLDBC and binding utf8 parameters

Hello Sven, I think you forgot to attach the trace. Regards Alexander Schröder SAP DB, SAP Labs Berlin -Original Message- From: news [mailto:[EMAIL PROTECTED] On Behalf Of Sven Köhler Sent: Mittwoch, 8. Februar 2006 08:08 To: maxdb@lists.mysql.com Subject: [BUG] SQLDBC and binding utf8