Dear Gurus,

I have following with me.
1> My-Sql (version 5.0.24)
2> Sybase 12.5 (ASE)
3> Windows platform
4> Exp. in Oracle 9i (Sql, pl-sql)

I want to do connectivity(Heterogenious) between My-SQL and Sybase.
I have done similar thing with Oracle 9i and MS-SQL Server 2000
(Heterogenious Connectivity).

I need to know how much data (in GigaByte/Terabyte) mysql(version
5.0.24) can handle?
Does mysql(version 5.0.24) support Stored Procedure/function/trigger
etc. ?
Is there any job scheduling facility in mysql(version 5.0.24)? (Like
job sheduler in oracle)
i.e. job will run/execute Stored procedure in periodic manner.

Could anyone me in above.

Thanking in advance
Sanjeev



..

On Mar 31, 9:37 am, Sanjeev <sanjeev.atvan...@gmail.com> wrote:
> Dear Gurus,
>
> I have following with me.
> 1> My-Sql (version 5.0.24)
> 2> Sybase 12.5 (ASE)
> 3> Windows platform
> 4> Exp. in Oracle 9i (Sql, pl-sql)
>
> I want to do connectivity(Heterogenious) between My-SQL and Sybase.
> I have done similar thing with Oracle 9i and MS-SQL Server 2000
> (Heterogenious Connectivity).
>
> I need to know how much data (in GigaByte/Terabyte) mysql(version
> 5.0.24) can handle?
> Does mysql(version 5.0.24) support Stored Procedure/function/trigger
> etc. ?
> Is there any job scheduling facility in mysql(version 5.0.24)? (Like
> job sheduler in oracle)
> i.e. job will run/execute Stored procedure in periodic manner.
>
> Could anyone me in above.
>
> Thanking in advance
> Sanjeev
>
> .

hi sanjeev,

mysql 5.0.24 will support stored procedure /function and trigger .

Job scheduling is not available in 5.0.

Sanjeev wrote:
> Dear Gurus,
>
> I have following with me.
> 1> My-Sql (version 5.0.24)
> 2> Sybase 12.5 (ASE)
> 3> Windows platform
> 4> Exp. in Oracle 9i (Sql, pl-sql)
>
> I want to do connectivity(Heterogenious) between My-SQL and Sybase.
> I have done similar thing with Oracle 9i and MS-SQL Server 2000
> (Heterogenious Connectivity).
>
> I need to know how much data (in GigaByte/Terabyte) mysql(version
> 5.0.24) can handle?

Multiple TB's. File size may be more of a problem, depending on your
architecture.

> Does mysql(version 5.0.24) support Stored Procedure/function/trigger
> etc. ?

Yes.

> Is there any job scheduling facility in mysql(version 5.0.24)? (Like
> job sheduler in oracle)
> i.e. job will run/execute Stored procedure in periodic manner.
>

No, but the OS has cron, which is much more efficient than Oracle's job
scheduler.

> Could anyone me in above.
>
> Thanking in advance
> Sanjeev
>
>
>
> .
>
>


--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================