Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

A few thoughts

2 posts in Product Futures Discussion Last posting was on 2004-01-22 18:43:00.0Z
olivier Posted on 2004-01-22 13:28:14.0Z
From: "olivier" <ociteau-NOSPAM@yahoo.fr>
Newsgroups: sybase.public.ase.product_futures_discussion
Organization: 81.255.44.23
X-Newsreader: AspNNTP 1.50 (Takeshi Eto)
Subject: A few thoughts
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 64.79.161.46
X-Original-NNTP-Posting-Host: 64.79.161.46
Message-ID: <400fcfee@forums-1-dub>
Date: 22 Jan 2004 05:28:14 -0800
X-Trace: forums-1-dub 1074778094 64.79.161.46 (22 Jan 2004 05:28:14 -0800)
X-Original-Trace: 22 Jan 2004 05:28:14 -0800, 64.79.161.46
Lines: 29
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1484
Article PK: 96485

Hi, i belong to an e-mail group for powerbuilder developers.
Someone asked "Can we call java object in sybase procedures, triggers (ver.
11.5)".
What do you think were his final goal (aim) ?
He wrote :
"I want to generate flat file from Sybase, since Sybase 11.5 does not support
java can any one give me idea how to generate that .. I don't want to use
front-end tool pb,vb etc ,,,,,
"
Of course, i wrote about BCP.

BCP is in the utility guide, but there should be a few words about it in THE
reference manual.


Have a look at a few white papers from IBM :
http://www-306.ibm.com/software/data/highlights/techpapers.html
IBM makes heavy shoots on Oracle.

Read "You Probably Don't Need RAC" and "A Technical Discussion of Multi Version
Read Consistency"

Sybase company should be as agressive with his competitors than IBM.
For example, when i write a stored procedure in ASE i never use cursors because
of the #temp feature. It can be "60 *" slower with Cursors. But with Oracle you
need Cursors.

---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp


Ryan Putnam Posted on 2004-01-22 18:43:00.0Z
Sender: 67d5.40101b63.1804289383@sybase.com
From: Ryan Putnam
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Re: A few thoughts
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <40101bfe.67e2.846930886@sybase.com>
References: <400fcfee@forums-1-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 22 Jan 2004 10:52:46 -0800, 10.22.241.42
Lines: 62
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 22 Jan 2004 10:27:02 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 22 Jan 2004 10:43:00 -0800
X-Trace: forums-1-dub 1074796980 10.22.108.75 (22 Jan 2004 10:43:00 -0800)
X-Original-Trace: 22 Jan 2004 10:43:00 -0800, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1485
Article PK: 96486

I believe that they should be aggressive as well, however I
do not agree with your statement about #temp tables. Yes,
batch oriented processing is faster than using cursors,
however, batch processing does have significant overheads as
well. In your case, you could have significant problems
with tempdb or one of your tempdb databases. In addition,
you could have transaction log growth problems due to long
transactions which maybe which possibly could have been
broken down into smaller batches or by using cursor logic.
If you went with your approach I would not use tempdb, but a
permanent table in a permanent database. Those are just my
thoughts. And sorry for critizing.

Sybase should of course, exploit the ease of development vs.
Oracle or UDB. The ease of installation, upgrades, and
maintenance as well. Sybase requires significantly less
development time vs. Oracle or UDB. Also, Sybase offers the
best replication solution, with the fewest number of
dependencies. In addition, using sybase replication offers
a much more change tolerant environment than does Oracle,
UDB, or MSSQL. A UDB procedure is limited to 64K, names to
18 characters. That is just BS and lends to more procedures
and truncated names which do not represent the object well.
UDB also has a BS management server to administor as well as
Oracle. In mind, that is just garbage. Every server should
be standalone and should be able to administor/heal itself.
I am certified in Sybase ASE, Replication, Oracle, and UDB.

Thanks,
Ryan

> Hi, i belong to an e-mail group for powerbuilder
> developers. Someone asked "Can we call java object in
> sybase procedures, triggers (ver. 11.5)".
> What do you think were his final goal (aim) ?
> He wrote :
> "I want to generate flat file from Sybase, since Sybase
> 11.5 does not support java can any one give me idea how to
> generate that .. I don't want to use front-end tool pb,vb
> etc ,,,,, "
> Of course, i wrote about BCP.
>
> BCP is in the utility guide, but there should be a few
> words about it in THE reference manual.
>
>
> Have a look at a few white papers from IBM :
>
http://www-306.ibm.com/software/data/highlights/techpapers.html
> IBM makes heavy shoots on Oracle.
>
> Read "You Probably Don't Need RAC" and "A Technical
> Discussion of Multi Version Read Consistency"
>
> Sybase company should be as agressive with his competitors
> than IBM. For example, when i write a stored procedure in
> ASE i never use cursors because of the #temp feature. It
> can be "60 *" slower with Cursors. But with Oracle you
> need Cursors.
>
> ---== Posted via the PFCGuide Web Newsreader ==---
> http://www.pfcguide.com/_newsgroups/group_list.asp