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.

*= operator

4 posts in General Discussion Last posting was on 2010-12-02 15:00:47.0Z
KS Posted on 2010-11-30 11:01:29.0Z
Sender: 3061.4cf4d819.1804289383@sybase.com
From: KS
Newsgroups: sybase.public.ase.general
Subject: *= operator
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4cf4d989.30a7.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 30 Nov 2010 03:01:29 -0800
X-Trace: forums-1-dub 1291114889 10.22.241.41 (30 Nov 2010 03:01:29 -0800)
X-Original-Trace: 30 Nov 2010 03:01:29 -0800, 10.22.241.41
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29743
Article PK: 78972

Hi,

I'm pretty new to Sybase and I'm writing some procedures
with
T-SQL.

I came across a piece of code that was somewhat like this:

update #t1 set column1 = isnull(t2.columnA,'value') from t2
where #t1.ssm_id *= t2.ssm_id

I have the following q's with reference to this piece:
1) What does the *= operator mean?
2) is ssm_id something that is internal to sybase or
something that has been written by a developer? If it is
internal, please explain what it does mean.

Cheers,
KS


KS Posted on 2010-11-30 11:04:42.0Z
Sender: 3061.4cf4d819.1804289383@sybase.com
From: KS
Newsgroups: sybase.public.ase.general
Subject: Re: *= operator
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4cf4da4a.30ce.1681692777@sybase.com>
References: <4cf4d989.30a7.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 30 Nov 2010 03:04:42 -0800
X-Trace: forums-1-dub 1291115082 10.22.241.41 (30 Nov 2010 03:04:42 -0800)
X-Original-Trace: 30 Nov 2010 03:04:42 -0800, 10.22.241.41
Lines: 2
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29744
Article PK: 78973

I just want to add that I'm using Sybase ASE (Adaptive
Server Enterprise), if that helps.


Rob V [ Sybase ] Posted on 2010-11-30 14:28:52.0Z
From: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Reply-To: robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY
Organization: Sypron BV / TeamSybase / Sybase
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.12) Gecko/20101027 Thunderbird/3.1.6
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: *= operator
References: <4cf4d989.30a7.1681692777@sybase.com>
In-Reply-To: <4cf4d989.30a7.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: <4cf50a24$1@forums-1-dub>
Date: 30 Nov 2010 06:28:52 -0800
X-Trace: forums-1-dub 1291127332 10.22.241.152 (30 Nov 2010 06:28:52 -0800)
X-Original-Trace: 30 Nov 2010 06:28:52 -0800, vip152.sybase.com
Lines: 48
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29745
Article PK: 78975


On 30-Nov-2010 12:01, KS wrote:
> Hi,
>
> I'm pretty new to Sybase and I'm writing some procedures
> with
> T-SQL.
>
> I came across a piece of code that was somewhat like this:
>
> update #t1 set column1 = isnull(t2.columnA,'value') from t2
> where #t1.ssm_id *= t2.ssm_id
>
> I have the following q's with reference to this piece:
> 1) What does the *= operator mean?
> 2) is ssm_id something that is internal to sybase or
> something that has been written by a developer? If it is
> internal, please explain what it does mean.
>
> Cheers,
> KS

*= is an outer join operator, but in a T-SQL-specific syntax.
You can also use ANSI join syntax in ASE. Assuming you're familiar with
ANSI syntax, *= is identical to a "left [outer] join" and =* is a "right
[outer] join".

As for ssm_id: that's a column name in table #t1. This is a name that
was chosen by a developer; it is not Sybase-specific. Same for the
identifiers columnA, column1, #t1 and t2.

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks& Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------


KS Posted on 2010-12-02 15:00:47.0Z
Sender: 3061.4cf4d819.1804289383@sybase.com
From: KS
Newsgroups: sybase.public.ase.general
Subject: Re: *= operator
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4cf7b49f.563a.1681692777@sybase.com>
References: <4cf50a24$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 2 Dec 2010 07:00:47 -0800
X-Trace: forums-1-dub 1291302047 10.22.241.41 (2 Dec 2010 07:00:47 -0800)
X-Original-Trace: 2 Dec 2010 07:00:47 -0800, 10.22.241.41
Lines: 55
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29753
Article PK: 78983

Thanks Rob!

> On 30-Nov-2010 12:01, KS wrote:
> > Hi,
> >
> > I'm pretty new to Sybase and I'm writing some procedures
> > with
> > T-SQL.
> >
> > I came across a piece of code that was somewhat like
> this: >
> > update #t1 set column1 = isnull(t2.columnA,'value') from
> > t2 where #t1.ssm_id *= t2.ssm_id
> >
> > I have the following q's with reference to this piece:
> > 1) What does the *= operator mean?
> > 2) is ssm_id something that is internal to sybase or
> > something that has been written by a developer? If it is
> > internal, please explain what it does mean.
> >
> > Cheers,
> > KS
>
> *= is an outer join operator, but in a T-SQL-specific
> syntax. You can also use ANSI join syntax in ASE. Assuming
> you're familiar with ANSI syntax, *= is identical to a
> "left [outer] join" and =* is a "right [outer] join".
>
> As for ssm_id: that's a column name in table #t1. This is
> a name that was chosen by a developer; it is not
> Sybase-specific. Same for the identifiers columnA,
> column1, #t1 and t2.
>
> HTH,
>
> Rob V.
> ----------------------------------------------------------
> ------- Rob Verschoor
>
> Certified Sybase Professional DBA for ASE
> 15.0/12.5/12.0/11.5/11.0 and Replication Server
> 15.0.1/12.5 // TeamSybase
>
> Author of Sybase books (order online at
> www.sypron.nl/shop): "Tips, Tricks& Recipes for Sybase
> ASE" (ASE 15 edition) "The Complete Sybase ASE Quick
> Reference Guide" "The Complete Sybase Replication Server
> Quick Reference Guide"
>
> rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter:
> @rob_verschoor Sypron B.V., The Netherlands | Chamber of
> Commerce 27138666
> ----------------------------------------------------------
> -------
>