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.

ASA Truncate to ASE

5 posts in General Discussion Last posting was on 2005-03-23 17:10:42.0Z
George Posted on 2005-03-23 15:38:24.0Z
Sender: 3465.42418829.1804289383@sybase.com
From: George
Newsgroups: ianywhere.public.general
Subject: ASA Truncate to ASE
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <42418d70.34e3.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 23 Mar 2005 07:38:24 -0800
X-Trace: forums-1-dub 1111592304 10.22.241.41 (23 Mar 2005 07:38:24 -0800)
X-Original-Trace: 23 Mar 2005 07:38:24 -0800, 10.22.241.41
Lines: 8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4242
Article PK: 8110

Hi everybody:

There is a ASA command TRUNCATE, I'd like to have an
equivalent in ASE or how can we do the same in ASE ???.

Thank You.

George


Joshua Savill Posted on 2005-03-23 15:54:29.0Z
From: "Joshua Savill" <jsavill@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <42418d70.34e3.1681692777@sybase.com>
Subject: Re: ASA Truncate to ASE
Lines: 23
Organization: iAnywhere Solutions
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: jsavill-pc.sybase.com
X-Original-NNTP-Posting-Host: jsavill-pc.sybase.com
Message-ID: <42419135@forums-1-dub>
Date: 23 Mar 2005 07:54:29 -0800
X-Trace: forums-1-dub 1111593269 10.25.98.205 (23 Mar 2005 07:54:29 -0800)
X-Original-Trace: 23 Mar 2005 07:54:29 -0800, jsavill-pc.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4244
Article PK: 8109

George,

This newsgroup is specifically for SQL Anywhere Studio's questions. ASE is
not a SQL Anywhere product. I recommend posting your question in the
sybase.public.ase.general newsgroup. They will be able to answer your
question.

Cheers,
--
Joshua Savill
iAnywhere Solutions - Product Support Analyst

<George> wrote in message news:42418d70.34e3.1681692777@sybase.com...
> Hi everybody:
>
> There is a ASA command TRUNCATE, I'd like to have an
> equivalent in ASE or how can we do the same in ASE ???.
>
> Thank You.
>
> George


Chris Keating (iAnywhere Solutions) Posted on 2005-03-23 16:09:40.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <Spam_NoThanks_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <42418d70.34e3.1681692777@sybase.com>
Subject: Re: ASA Truncate to ASE
Lines: 14
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: keating-xp2.sybase.com
X-Original-NNTP-Posting-Host: keating-xp2.sybase.com
Message-ID: <424194c4$1@forums-1-dub>
Date: 23 Mar 2005 08:09:40 -0800
X-Trace: forums-1-dub 1111594180 10.25.98.199 (23 Mar 2005 08:09:40 -0800)
X-Original-Trace: 23 Mar 2005 08:09:40 -0800, keating-xp2.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4245
Article PK: 8111

Have you tried TRUNCATE TABLE <table_name>?

<George> wrote in message news:42418d70.34e3.1681692777@sybase.com...
> Hi everybody:
>
> There is a ASA command TRUNCATE, I'd like to have an
> equivalent in ASE or how can we do the same in ASE ???.
>
> Thank You.
>
> George


George Posted on 2005-03-23 16:19:58.0Z
Sender: 3465.42418829.1804289383@sybase.com
From: George
Newsgroups: ianywhere.public.general
Subject: Re: ASA Truncate to ASE
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4241972e.3643.1681692777@sybase.com>
References: <424194c4$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 23 Mar 2005 08:19:58 -0800
X-Trace: forums-1-dub 1111594798 10.22.241.41 (23 Mar 2005 08:19:58 -0800)
X-Original-Trace: 23 Mar 2005 08:19:58 -0800, 10.22.241.41
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4246
Article PK: 8113

In ASA TRUNCATE is for using with decimals numbers.

Thank You

George

> Have you tried TRUNCATE TABLE <table_name>?
>
>
> <George> wrote in message
> > news:42418d70.34e3.1681692777@sybase.com... Hi
> everybody: >
> > There is a ASA command TRUNCATE, I'd like to have an
> > equivalent in ASE or how can we do the same in ASE ???.
> >
> > Thank You.
> >
> > George
>
>


Breck Carter [TeamSybase] Posted on 2005-03-23 17:10:42.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: ASA Truncate to ASE
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <6m8341pp8v4o6ti27vn0gbf08cf076fv7g@4ax.com>
References: <42418d70.34e3.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 23 Mar 2005 09:10:42 -0800
X-Trace: forums-1-dub 1111597842 64.7.134.118 (23 Mar 2005 09:10:42 -0800)
X-Original-Trace: 23 Mar 2005 09:10:42 -0800, bcarter.sentex.ca
Lines: 27
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4247
Article PK: 8112

If you are talking about TRUNCNUM (the new name for "TRUNCATE"), try
this in ASE...

SIGN ( @x ) * FLOOR ( ABS ( @x ) )

If you are talking about TRUNCATE TABLE, that exists in both ASE and
ASA.

Breck

On 23 Mar 2005 07:38:24 -0800, George wrote:

>Hi everybody:
>
>There is a ASA command TRUNCATE, I'd like to have an
>equivalent in ASE or how can we do the same in ASE ???.
>
>Thank You.
>
>George

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