SQL Anywhere Mobile - very big script of event in sql server or oracle

Author

very big script of event in sql server or oracle

Luis Ponce Ibarra - Hotmail

2005-10-27, 8:21 am

I use like base consolidated sybase sql anywhere, sql server or oracle. When
I enter the sentences of a script in an event of the mobilink in the
consolidated database I don't have problem if it is sybase sql anywhere, but
if I use sql server or oracle I have problem when the sentence is very big
it doesn't allow me to record and I have to take it store procedure.
Some way exists of overcoming the topic of the one it limits of the sentence
when it is sql server or oracle?
That has spent with sybase 7.0.4 and sybase 9.0.2.

Greg Fenton

2005-10-27, 8:21 am

Luis Ponce Ibarra - Hotmail wrote:
> When
> I enter the sentences of a script in an event of the mobilink in the
> consolidated database I don't have problem if it is sybase sql anywhere, but
> if I use sql server or oracle I have problem when the sentence is very big
> it doesn't allow me to record and I have to take it store procedure.

I believe the problem is with a limitation with passing parameters to
stored procedures via the ODBC drivers.

How are you trying to create these events, via Sybase Central or by
directly calling the stored procedures using an interactive SQL tool?

One approach I've taken in the past (haven't tried this for quite some
time) is to insert a "dummy" script with Sybase Central and then
manually updating that script in the ML_SCRIPTS table directly with an
interactive SQL tool (e.g. SQL/Plus).

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Breck Carter [TeamSybase]

2005-10-27, 8:21 am

You may be stepping on a flaw in syncora.sql, wherein the scripts are
stored in a CLOB column but the stored procedures you call expect only
a VARCHAR parameter (see below). Personally, I use stored procedures,
but you could try fixing syncora.sql yourself and see if it helps.
I've been told this has been fixed in Jasper.

create table ml_script (
script_id integer
not null,
script clob not null,
script_language varc
har( 128 ) default 'sql' not null
,
primary key (script_id)
)
/
....
create procedure ml_add_table_script(

p_version in varchar,
p_name in varchar,
p_event in varchar,
p_script in varchar ) as
begin
ml_add_lang_table_sc
ript( p_version, p_name, p_event, 'sql',
p_script );
end;
/

Breck

On 18 Oct 2005 16:29:24 -0700, "Luis Ponce Ibarra - Hotmail"
< luisponceibarra@hotm
ail.com> wrote:

>I use like base consolidated sybase sql anywhere, sql server or oracle. When
>I enter the sentences of a script in an event of the mobilink in the
>consolidated database I don't have problem if it is sybase sql anywhere, but
>if I use sql server or oracle I have problem when the sentence is very big
>it doesn't allow me to record and I have to take it store procedure.
>Some way exists of overcoming the topic of the one it limits of the sentence
>when it is sql server or oracle?
>That has spent with sybase 7.0.4 and sybase 9.0.2.
>
>
>

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Graham Hurst

2005-10-27, 8:21 am

As well as what Greg and Breck say, which company's SQL Server are you
referring to? Sybase SQL Server was renamed to Adaptive Server
Enterprise (ASE) many years ago.

For ASE 12.5 and newer, the script length limit is 16384. On earlier
versions of ASE it is 255.

Why is it a problem for you to use stored procedures?

Cheers,

Graham

Luis Ponce Ibarra - Hotmail wrote:
> I use like base consolidated sybase sql anywhere, sql server or oracle. When
> I enter the sentences of a script in an event of the mobilink in the
> consolidated database I don't have problem if it is sybase sql anywhere, but
> if I use sql server or oracle I have problem when the sentence is very big
> it doesn't allow me to record and I have to take it store procedure.
> Some way exists of overcoming the topic of the one it limits of the sentence
> when it is sql server or oracle?
> That has spent with sybase 7.0.4 and sybase 9.0.2.
>
>
>
>

Sponsored Links