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.

sql dialect

4 posts in General Discussion Last posting was on 2009-03-29 12:51:52.0Z
Alex Posted on 2009-03-27 14:56:13.0Z
Sender: 402.49cce821.1804289383@sybase.com
From: Alex
Newsgroups: ianywhere.public.general
Subject: sql dialect
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49cce90d.41b.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 27 Mar 2009 06:56:13 -0800
X-Trace: forums-1-dub 1238165773 10.22.241.41 (27 Mar 2009 06:56:13 -0800)
X-Original-Trace: 27 Mar 2009 06:56:13 -0800, 10.22.241.41
Lines: 6
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7444
Article PK: 5859

asa 11.0.0.1511

which way can trigger be created in transact sql dialect?

btw, before it was tool to convert sp from/to wtacom
dialect, where is it now?


Josh Savill [Sybase] Posted on 2009-03-27 18:38:30.0Z
From: "Josh Savill [Sybase]" <no_spam_jsavill_no_spam@sybase.com>
Organization: Sybase iAnywhere
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: sql dialect
References: <49cce90d.41b.1681692777@sybase.com>
In-Reply-To: <49cce90d.41b.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49cd1d26$1@forums-1-dub>
Date: 27 Mar 2009 10:38:30 -0800
X-Trace: forums-1-dub 1238179110 10.22.241.152 (27 Mar 2009 10:38:30 -0800)
X-Original-Trace: 27 Mar 2009 10:38:30 -0800, vip152.sybase.com
Lines: 15
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7447
Article PK: 5860

CREATE TRIGGER statement [T-SQL]:
http://dcx.sybase.com/index.php#http%3A%2F%2Fdcx.sybase.com%2F1101en%2Fdbreference_en11%2Fcreate-trigger-tsql-statement.html

--
Joshua Savill
Sybase Inc. - Product Manager

Alex wrote:
> asa 11.0.0.1511
>
> which way can trigger be created in transact sql dialect?
>
> btw, before it was tool to convert sp from/to wtacom
> dialect, where is it now?


"Nick Elson [Sybase iAnywhere]" < Posted on 2009-03-27 20:29:39.0Z
From: "Nick Elson [Sybase iAnywhere]" <@nick@.@elson@@sybase@.@com@>
Newsgroups: ianywhere.public.general
References: <49cce90d.41b.1681692777@sybase.com> <49cd1d26$1@forums-1-dub>
Subject: Re: sql dialect
Lines: 36
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49cd3733$1@forums-1-dub>
Date: 27 Mar 2009 12:29:39 -0800
X-Trace: forums-1-dub 1238185779 10.22.241.152 (27 Mar 2009 12:29:39 -0800)
X-Original-Trace: 27 Mar 2009 12:29:39 -0800, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7450
Article PK: 5863

Watcom-dialect triggers are very often
row level triggers (either before or after
timing but row-level). Transact SQL
trigger are always statement level and
there is no T-SQL mechanism to
create row level triggers.

As such, automatic dialect conversion is
(generally) not possible. Stored procedures
are doable, triggers ... not so easy to do ...
As such, it usually takes some hand crafting
to get the logic right anyway.

Finally, I suspect you may be remembering the way
SCView worked with stored procedures.

"Josh Savill [Sybase]" <no_spam_jsavill_no_spam@sybase.com> wrote in message
news:49cd1d26$1@forums-1-dub...
> CREATE TRIGGER statement [T-SQL]:
> http://dcx.sybase.com/index.php#http%3A%2F%2Fdcx.sybase.com%2F1101en%2Fdbreference_en11%2Fcreate-trigger-tsql-statement.html
>
> --
> Joshua Savill
> Sybase Inc. - Product Manager
>
>
> Alex wrote:
>> asa 11.0.0.1511
>>
>> which way can trigger be created in transact sql dialect?
>>
>> btw, before it was tool to convert sp from/to wtacom
>> dialect, where is it now?


Breck Carter [TeamSybase] Posted on 2009-03-29 12:51:52.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__breck.carter@gmail.com>
Newsgroups: ianywhere.public.general
Subject: Re: sql dialect
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__breck.carter@gmail.com
Message-ID: <rerus49d4bnng574gvq194vb18eb2tj76t@4ax.com>
References: <49cce90d.41b.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: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 29 Mar 2009 04:51:52 -0800
X-Trace: forums-1-dub 1238331112 10.22.241.152 (29 Mar 2009 04:51:52 -0800)
X-Original-Trace: 29 Mar 2009 04:51:52 -0800, vip152.sybase.com
Lines: 30
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7452
Article PK: 5866

Open the trigger in Sybase Central.

Move the mouse over the trigger code in the right pane.

Press the right mouse button, click on one of "Translate to
Watcom-SQL" or "Translate to Transact-SQL".

Not every translation is possible; watch for code that is placed
inside comments because it could not be translated (like FOR EACH
ROW).

See the Help for these functions: SQLDIALECT, TRANSACTSQL, WATCOMSQL.

Breck

On 27 Mar 2009 06:56:13 -0800, Alex wrote:

>asa 11.0.0.1511
>
>which way can trigger be created in transact sql dialect?
>
>btw, before it was tool to convert sp from/to wtacom
>dialect, where is it now?

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter@risingroad.com