Hey Gustav,
Thanks a lot!! This worked. But, isn't this a bug in the documentation
Suraj.
-Original Message-
From: Gustav Brock [mailto:[EMAIL PROTECTED]
Sent: Saturday, August 23, 2003 4:27 PM
To: [EMAIL PROTECTED]
Subject: Re: Imoprt Batch SQL Statements
Hi Suraj
Try
Hi Suraj
Try with double-slashes:
create table test(name varchar(30), age integer)
//
create table test1(name varchar(10))
/gustav
> Date: 2003-08-23 12:46
> Hello,
> I'm using the latest version of SapDB(version 7.4), and I'm facing the
> following problem whi
Hello,
I'm using the latest version of SapDB(version 7.4), and I'm facing the
following problem while importing batch sql statements using repmcli :
I used the following command ;
prompt> repmcli -d sampledb -u suraj,suraj -b cre
> Gesendet am: Samstag, 2. August 2003 04:16
> An: Sapdb General List
> Betreff: Re: Solved: SQL Studio crashes by using saved SQL-statements
>
> Where i can find newest version 7.4.3.28, i only see version 7.4.3.27 ?
>
> Regards
> Eko Subagio
>
>
> --
Where i can find newest version 7.4.3.28, i only see version 7.4.3.27 ?
Regards
Eko Subagio
- Original Message -
From: "Hübschen, Peter" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 31, 2003 8:11 PM
Subject: Solved: SQL Studio crashes by usin
etreff: SQL Studio crashes by using saved SQL-statements
>
> Hello,
>
> I'm trying to configure a complete new installation of a SAPDB through
> SQL-Studio. The DB-Server is located on a RedHat-9 Box and it runs SAPDB
> 7.4.03.25 and SQL-Studio (Version: 7.4.3.17) o
Hello,
I'm trying to configure a complete new installation of a SAPDB through
SQL-Studio. The DB-Server is located on a RedHat-9 Box and it runs SAPDB
7.4.03.25 and SQL-Studio (Version: 7.4.3.17) on a Win2k-SP2 Workstation.
I've saved some SQL-Statements for creating new tables, grant
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
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
Hello Matthias,
SQL Studio uses 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 execute long SQL
[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
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
Matthias
___
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
;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
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
--- 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
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.
>
Hi,
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 with DBMCLI's sql_execute it throws an error:
ERR
-24988,ER
Gerald Nowitzky wrote:
> Using SAPDB 7.4.3.17 on W2K, I am trying to get a log of all
> executed sql
> statements. Therefore I switched on kernel trace for
> "SELECT,INSERT,UPDATE,DELETE". According to a thread on the
> list, I tried to
> decode the trace using
&
Hello!
Using SAPDB 7.4.3.17 on W2K, I am trying to get a log of all executed sql
statements. Therefore I switched on kernel trace for
"SELECT,INSERT,UPDATE,DELETE". According to a thread on the list, I tried to
decode the trace using
xkernprot -d AK
it says
reading: \knltrace.da
t;
> is it possible to execute multiple SQL-Statements at one time using
SQL-Studio ? How could this be accomplished ?
>
> Thanks in advance for your help.
>
> Best regards,
>
>
>
> Sven Scholz
> Professional Services
> [EMAIL PROTECTED]
>
> STRATOS CRM Solut
Hello,
is it possible to execute multiple SQL-Statements at one time using SQL-Studio ? How
could this be accomplished ?
Thanks in advance for your help.
Best regards,
Sven Scholz
Professional Services
[EMAIL PROTECTED]
STRATOS CRM Solutions GmbH
Geschäftsstelle Leipzig
Spenglerallee 3
RY KEY (odc_volontario_id) )
//
//
...
should work.
BTW, this is exactly what the SQL Studio documentation says :
"To separate SQL statements from one another, specify a separator line. To be
identified as a separator line, the line must start with //. "
regards,
Markus Stausberg
SAP L
Stefano Mainardi wrote:
I tried to make a sql sript run to create tables for a simple test DB;
it included drop,create and alter table statements; to make SQL Studio
7.4 to execute multiple statements I followed the instructions I got on
the relevant manual for the 7.3 version (I have found non
Try "//" or "--" instead of "\\"
I also think "--" is depreciated in the more recent releases.
Ron.
Stefano Mainardi wrote:
I tried to make a sql sript run to create tables for a simple test DB;
it included drop,create and alter table statements; to make SQL Studio
7.4 to execute multiple
SQL Studio 7.4 and multiple SQL StatementsHi!
I had the same problem, but it worked with a comment line with "--" after
each statement.
Hope that helps.
Marcel
"Stefano Mainardi" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED].
..
I tried to make a sql sript
Title: SQL Studio 7.4 and multiple SQL Statements
I tried to make a sql sript run to create tables for a simple test DB; it included drop,create and alter table statements; to make SQL Studio 7.4 to execute multiple statements I followed the instructions I got on the relevant manual for the
Hi Alexander,
From: "Schroeder, Alexander" <[EMAIL PROTECTED]>
> try to check your statements and the amount of data they return,
> e.g. by executing them over ISDN using SQL-Studio. Don't expect
> too much from such a network connection - 32KBytes of data
> (one *full* packet of the default packe
Hi Andreas,
"Andreas Fuchs" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
atpq0l$7jr$[EMAIL PROTECTED]">news:atpq0l$7jr$[EMAIL PROTECTED]...
> if it works fine in your LAN, then you can't optimize the statements
> except the amount of data that ist transferred (e.g dont use "select *
> from ..." but
Salve,
if it works fine in your LAN, then you can't optimize the statements
except the amount of data that ist transferred (e.g dont use "select *
from ..." but "select neededcol1,neededcol2, from ...". For working
with small connections its best to write a server which transfers the
data
esult sets.
Regards
Alexander Schröder
SAP Labs Berlin
> -Original Message-
> From: Andre Heine [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 18, 2002 1:09 PM
> To: Marcin P; [EMAIL PROTECTED]
> Subject: Re: Optimize SQL-Statements for 64-k ISDN ??
>
>
&
Hi Marcin,
"Marcin P" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
atpkll$kii$[EMAIL PROTECTED]">news:atpkll$kii$[EMAIL PROTECTED]...
> Could You give us more information?
My application works fine in our local net. The SQLStudio work fine, too (
It works fine but slow over ISDN)!
In our local net
Could You give us more information?
When your connection is finally done, and
your app is running, do the operations take a long time?
Because if the only problem is only with connecting it seems
to be rather a network problem.
When I first installed SAP DB (oh, it was more than year ago...;) )
I h
Hi all,
I've written an Java application with JDBC and SAP DB.
All functions work fine with SAP-DB, but sometime I need
an SAP-DB connection over ISDN.
In these case, my application works very slowly ;(
I can't work with the application over 64k-ISDN,
my menu's only opened after a few minutes!
H
ilto:[EMAIL PROTECTED]]
Enviado el: Monday, June 17, 2002 8:26 AM
Para: '[EMAIL PROTECTED]'
CC: [EMAIL PROTECTED]
Asunto: RE: sql statements
Osvaldo DEMIERRE wrote
> How is possible the view of SQL statements of the users in the Database?
> (like "V$SQLTEXT" of Oracle).
>
Hi,
How is possible the view of SQL statements of the users in the Database?
(like "V$SQLTEXT" of Oracle).
Is there trace with storage of parsed SQL statements in SapDB? How?
Thank you.
___
sapdb.general mailing list
[EMAIL PROTE
36 matches
Mail list logo
