RE: how can i execute long SQL-Statements via DBMCLI

2003-06-18 Thread Schroeder, Alexander
8, 2003 9:58 AM > To: [EMAIL PROTECTED] > Subject: Re: how can i execute long SQL-Statements via DBMCLI > > > thanks Alexander, > > but one thing i've got forgotten to ask: > How can i solve RIGHT(s,i)? This function is also in my SQL-Statement. > > Greet

Re: how can i execute long SQL-Statements via DBMCLI

2003-06-18 Thread Matthias Suttner
ODBC. > > Regards > Alexander Schröder > SAP DB, SAP Labs Berlin > > > -Original Message- > > From: Matthias Suttner [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, June 18, 2003 9:36 AM > > To: [EMAIL PROTECTED] > > Subject: Re: how can i exec

RE: how can i execute long SQL-Statements via DBMCLI

2003-06-18 Thread Schroeder, Alexander
from dbmcli or > loadercli, the suggestion > > using SUBSTR is still the valid workaround. > > > > Sorry for any inconvenience caused, > > Alexander Schröder > > SAP DB, SAP Labs Berlin > > > > > > > > > -Original Message- > &g

RE: how can i execute long SQL-Statements via DBMCLI

2003-06-18 Thread Knappke, Christian
[quoting fixed] > > However, always beware that these functions are only supported in > > JDBC and ODBC, and if they are not listed in the SAP DB > > documentation, they will probably not work when used from dbm, > > loader or C precompiler. > and why does this SQL-Statement works in the SQL-St

Re: how can i execute long SQL-Statements via DBMCLI

2003-06-18 Thread Matthias Suttner
From: Schroeder, Alexander > > Sent: Tuesday, June 17, 2003 6:27 PM > > To: 'Matthias Suttner'; [EMAIL PROTECTED] > > Subject: RE: how can i execute long SQL-Statements via DBMCLI > > > > > > Hello Matthias, > > > > the answer here is re

Re: how can i execute long SQL-Statements via DBMCLI (Thanks @ all)

2003-06-17 Thread Matthias Suttner
Matthias ___ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general

RE: how can i execute long SQL-Statements via DBMCLI

2003-06-17 Thread Schroeder, Alexander
;Matthias Suttner'; [EMAIL PROTECTED] > Subject: RE: how can i execute long SQL-Statements via DBMCLI > > > Hello Matthias, > > the answer here is relatively easy - you didn't hit any length limit. > > There is no such thing like a string function called LEFT in SAP

RE: how can i execute long SQL-Statements via DBMCLI

2003-06-17 Thread Schroeder, Alexander
r SAP DB, SAP Labs Berlin > -Original Message- > From: Matthias Suttner [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 17, 2003 6:14 PM > To: [EMAIL PROTECTED] > Subject: Re: how can i execute long SQL-Statements via DBMCLI > > > --- In [EMAIL PROTECTED], &qu

Re: how can i execute long SQL-Statements via DBMCLI

2003-06-17 Thread Matthias Suttner
--- In [EMAIL PROTECTED], "Schildberg, Steffen" <[EMAIL PROTECTED]> wrote: > Hi Matthias, > > Matthias Suttner [mailto:[EMAIL PROTECTED] wrote: > > > > I'd like to execute SQL-Statements (INSERT, DELETE) once each day. > > > > So far no problem for DBMCLI if the statement is short enough. Bu

RE: how can i execute long SQL-Statements via DBMCLI

2003-06-17 Thread Schildberg, Steffen
Hi Matthias, Matthias Suttner [mailto:[EMAIL PROTECTED] wrote: > > I'd like to execute SQL-Statements (INSERT, DELETE) once each day. > > So far no problem for DBMCLI if the statement is short enough. But I > have to execute a few that have approx. 1300 characters. > > When I execute these wi