Concatenating values in a column: ASE 12.0 vs 12.5

Has anyone else encountered a change in behaviour of the following code
to concatenate all the values from a column and return a single row,
when going from ASE 12.0 to 12.5?

declare @temp varchar(255)

select @temp = ""

set rowcount 22
select @temp = @temp + station_number from location_tbl
/* select @temp = @temp + (case 1 when 1 then station_number end) from
location_tbl */
set rowcount 0

select @temp

Both selects do what we need under 12.0, but only return the last
station number under 12.5. Is this a configuration problem? Is there a
workaround not involving row processing?

- Alan
0
Alan
4/15/2003 5:13:24 PM
sybase.ase.general 8655 articles. 0 followers. Follow

3 Replies
591 Views

Similar Articles

[PageSpeed] 16

This was fixed in 12.5.0.1 under CR 210688.

Mark

"Alan Raskin" <araskin@agricoreunited.com> wrote in message
news:3E9C3DB4.6F63CAC8@agricoreunited.com...
Has anyone else encountered a change in behaviour of the following code
to concatenate all the values from a column and return a single row,
when going from ASE 12.0 to 12.5?

declare @temp varchar(255)

select @temp = ""

set rowcount 22
select @temp = @temp + station_number from location_tbl
/* select @temp = @temp + (case 1 when 1 then station_number end) from
location_tbl */
set rowcount 0

select @temp

Both selects do what we need under 12.0, but only return the last
station number under 12.5. Is this a configuration problem? Is there a
workaround not involving row processing?

- Alan


0
Mark
4/15/2003 5:33:12 PM

Alan Raskin wrote:
> 
> Has anyone else encountered a change in behaviour of the following code
> to concatenate all the values from a column and return a single row,
> when going from ASE 12.0 to 12.5?
> 
> declare @temp varchar(255)
> 
> select @temp = ""
> 
> set rowcount 22
> select @temp = @temp + station_number from location_tbl
> /* select @temp = @temp + (case 1 when 1 then station_number end) from
> location_tbl */
> set rowcount 0
> 
> select @temp
> 
> Both selects do what we need under 12.0, but only return the last
> station number under 12.5. Is this a configuration problem? Is there a
> workaround not involving row processing?
> 
> - Alan


This change in behavior is due to the fix of CR 210688, the 12.0
behavior was incorrect.
The documented behavior (Reference Manual, "SELECT") for variable
assignment is:

    "If a select statement that assigns a value to a variable returns
more than
     one row, the last returned value is assigned to the variable. "

Row processing is probably necessary going forward.

-bret
0
Bret
4/15/2003 5:34:36 PM
If you check the 12.5 P&T Guide Volume 2, page 534 explains this.

Mark

"Mark K" <xxxx> wrote in message news:eYpQGY3ADHA.233@forums-2-dub...
This was fixed in 12.5.0.1 under CR 210688.

Mark

"Alan Raskin" <araskin@agricoreunited.com> wrote in message
news:3E9C3DB4.6F63CAC8@agricoreunited.com...
Has anyone else encountered a change in behaviour of the following code
to concatenate all the values from a column and return a single row,
when going from ASE 12.0 to 12.5?

declare @temp varchar(255)

select @temp = ""

set rowcount 22
select @temp = @temp + station_number from location_tbl
/* select @temp = @temp + (case 1 when 1 then station_number end) from
location_tbl */
set rowcount 0

select @temp

Both selects do what we need under 12.0, but only return the last
station number under 12.5. Is this a configuration problem? Is there a
workaround not involving row processing?

- Alan




0
Mark
4/15/2003 5:43:29 PM
Reply:

Similar Artilces:

Dump/Load (from ASE 12.5.4 to ASE 15.x) - VS.
Hi All, We are in the process of planning the upgrade of our ASE 12.5.4 dataservers to ASE 15.x. What is the most recommended way to upgrade ASE dataservers from ASE 12.5.4 to ASE 15.x? Potential options: 1) Install new instances of ASE 15.x and load database dumps from our ASE 12.5.4 dataservers to the newly installed ASE 15.x dataservers. - OR - 2) Use the ASE upgrade utility (sqlupgrade) to upgrade our existing ASE 12.5.4 dataservers to ASE 15.x. What are the Pros vs. Cons for loading a 12.5.4 database into a 15.x ASE dataserver versus performing an ASE dataserv...

ASE 12.0.0.6 to ASE 12.5 and Rep Server 12.1
We are planning the upgrade of our ASE 12.0.0.6 64bit on AIX 4.3.3 to ASE 12.5 64bit on AIX 4.3.3. We are also using Rep Server 12.1 with these two servers. My question is do I need to upgrade Rep Server as well, or will 12.1 Rep Server Work with ASE 12.5. Also, we will be upgrading AIX to 5.1 as well. Any advice is appreciated. Thanks, Troy It will work, however you wont be able to use any of the 12.5 new datatypes, and the rep_agents will spit out annoying error/warning messages everytime they are restarted. Our production system has been running that way for about ye...

ASE Workplace 12.5 vs ASE Enterprise 12.5
Can anyone tell me what are the differences in the 2 packaging of ASE? TIA Himadri Hi Himadri, The main and I guess the only difference is price which is for WP ~= 4 times less. Category depends from machine level, for example for Sun the upper bound for WP is Sun E450 + 3 new XXXR. Go to http://eshop.sybase.com where you can see prices and in the help the up-to-date list of machines with category HTH, Eugene Himadri Laifangbam wrote: > Can anyone tell me what are the differences in the 2 packaging of ASE? > > TIA > Himadri For NT any machines up t...

ASE 12.5.2 to ASE 12.5.0.3
Hello, I have to return to ASE 12.5.0.3 from ASE 12.5.2. I created a new server and did a dump/load of a user database and that seems to be fine. Is this a safe way to downgrade ? Is it necessary to create a new server (master database) or should it also be possible to shutdown the 12.5.2 server and start it again with the 12.5.0.3 binary ? Thanks, Luc. ...

Upgrade from ASE 12.5.0.3 to ASE 12.5.1
This is a multi-part message in MIME format. ---=_forums-2-dub3ff97039 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi, I've just upgraded from ASE 12.5.0.3 to ASE 12.5.1. I tried to start the server, but it won't startup. Here is the message: sybase(ASE1250)328 /app/sybase/ASE-12_5/install --> startserver -f RUN_AMXDB sybase(ASE1250)329 /app/sybase/ASE-12_5/install --> 00:00000:00000:2004/01/05 21:37:44.10 kernel Use license file /app/sybase/SYSAM-1_0/licenses/license.dat. 00:00000:00000:2004/01/05 21:37:44.10 ker...

ASE 12.5 Small Business vs. ASE 12.5 Enterprise
Hi, Does anyone know the Technical offering different between these 2 products. Looking for docs on limitations of this ASE Small Business edition. Is it available on all platforms ? I have worked with the ASE Eneterprise editions but may have a new project that won't require the full blown Enterprise edition. thanks "Robert Furlong" <rfurlong@fame.com> wrote in message news:3E305851.80AA820@fame.com... > Hi, > > Does anyone know the Technical offering different between these 2 > products. > Looking for docs on limitations of this ASE Sm...

ASE 12.5.0.3 to ASE 12.5.4 upgrade path
I would like to know if the migration from ASE 12.5.0.3 to 12.5.4 a direct migration or is there an intermediate upgrade to be performed in between? Take a look at the release bulletins and installation guides for your platform. These are the first steps to any upgrade. http://sybooks.sybase.com/nav/detail.do?docset=1287 <passerby> wrote in message news:484e9ca8.3f0d.1681692777@sybase.com... >I would like to know if the migration from ASE 12.5.0.3 to > 12.5.4 a direct migration or is there an intermediate > upgrade to be performed in between? ...

Vulnerability of ASE 12.5.2 vs ASE 12.5.3 ESD#3
Recently, Application Security, Inc. has run a vulnerability test on our ASE12.5.2. The program gave a 'high risk' on the ASE12.5.2 and suggested we install the latest Sybase patch 12.5.3 ESD#3. I have some question on the recommendation. 1. The latest patch is definitely not 12.5.3 ESD#3. Why did the program recommend 12.5.3 ESD#3? Isn't 12.5.4 better than 12.5.3? 2. Is it practical to keep up with the latest releases or patches? Now if we upgrade to 12.5.4 and then rerun the vulnerability test, will the program suggest that newer version is better with respect to s...

Migration from ASE-64 bits 12.5.0.2 to ASE 64 bits 12.5.3 for AIX 5.3
Here there someone to indicate me the road tasks in order to migrate an ASE 12.5.0.2 to ASE 12.5.3 on unix 5.3 ? (64 bits) Thank you kamel wrote: > Here there someone to indicate me the road tasks in order to > migrate an ASE 12.5.0.2 to ASE 12.5.3 on unix 5.3 ? (64 > bits) > > Thank you Apply 12.5.2 IR then 12.5.3 esd 5. -- Jason L. Froebe http://jfroebe.livejournal.com http://www.propsmart.com Team Sybase On Tue, 31 Jan 2006 07:18:22 -0800, kamel wrote: > Here there someone to indicate me the road tasks in order to migrate an > ASE 12.5.0.2 ...

ASE 12.0 and ASE 12.5 optional features
Dear all, Can anyone knows what are the optional features of ASE 12.0 and ASE 12.5?? Thanks ~Riverwind ASE 12.0 : * DTM (distribute transaction management) * HA (High availability) * JAVA (Java support in the database) * Security services. ASE 12.5 * EJB support in the database. * XFS (extended file system support) * Directory services * Extended full text search * Java option now includes xml support in ASE. HTH -girish Thanks... ~Riverwind <girish@sybase.com> wrote in message news:43D8F27AA65DE95800085C1785256C0C.00123C3785256C0A@webforums... ...

Upgrading from ASE 12.0 to ASE 12.5.2
Hi everyone, I am basically thinking of upgrading ASE 12.0.x to ASE 12.5.2. How would the migration process be. Is it straight dump and load or otherwise ?? regards Paresh. Paresh wrote: > Hi everyone, > > I am basically thinking of upgrading ASE 12.0.x to ASE 12.5.2. > > How would the migration process be. Is it straight dump and load or > otherwise ?? > > regards > > Paresh. > > see the upgrade/installation guide joop -- Senior Consultant Sybase Professional Services New address per 21 November 2005: Zo...

ASE 12.5 to ASE 12.5.3
One of our client is having 3 no license for ASE 12.5 on Win2K (running 3 production servers) and not in the support/AMC with Sybase.. is client eligible to use ASE 12.5.3 ? Thanks KRV ...

ASE 12.5 vs 12.0 on Win
Hello, Could anybody share your experience of using ASE 12.5 in comparison with 12.0. What about their reliability and robustness, bugs? Is it possible to migrate back from 12.5 to 12.0 ? Thanks, Andrey Hi, Following are the major differences in 12.5, Hope these might helpful. Java - SQLJ, Java Stored Procedures - XML Support; pushed off from 12.0 SQL - Unions in views - Relaxation of conventional sybase limitations. You can now increase from varchar(255) to larger sizes. Max size dependent on the page size configured... varchar(1960) on a 2k page install, 16k f...

Same machine: ASE 12.5.3 Linux vs ASE 12.5.3 Windows
We had a report from one of our clients recently that our Sybase ASE-based app was running slowly on their new Linux box. As we develop internally against ASE on Windows we thought it would be an interesting test to install both the Windows and Linux flavors of ASE 12.5.3 onto the same server and look at the relative performance. We used a Dell PowerEdge 1950 with 2 x Intel Xeon 3.73GHz dual core processors. On one drive we put SuSE Enterprise Linux Server 10 x86-64, and on the other we put Windows Server 2003 Std R2 64-bit edition. Both were fresh-off-the-CD OS installs. ...

Web resources about - Concatenating values in a column: ASE 12.0 vs 12.5 - sybase.ase.general

Resources last updated: 12/1/2015 8:13:33 AM