ASE 12.0 Text columns
I have a need to combine many varchar(255) rows into one singular text
I am using ASE 12.0 so I cannot take advantage of ASE 12.5's varchar(255+)
Is there any way to append to an existing text column???? I have been all
over the newsgroups... Surely there must be a way to do this. If I combine
multiple local variables it truncates them down to 255 characters!
Somebody please help me! :)
Shawn Nesser, ENS USCG
> Sybase Guru's,
> I have a need to combine many va...text columns in ASE 12.0
Are text columns in ASE 12.0 problematic? We are creating a new ASE 12.0
database that will reside on a RS6000 box running AIX 4.3.2. We've avoided
using text columns in SqlServer databases because of incidents of database
corruption related to:
- text data that exceeds 2K page
- text data moved to data cache with pools that are larger than 2K
Are there any known bugs or issues related to text columns in ASE 12.0
AFAIK, the difference with 11.9 is that text/image columns are now
stored differently so that the contents can be a...ASE 188.8.131.52 / SWR 8775 UPGRADE TO ASE 184.108.40.206/EBF 10628 PERFORMANCE PROBLEM
We recently upgraded ASE 220.127.116.11/SWR 8775 to ASE 18.104.22.168/EBF 10628.
Some queries stopped returning resultsets. Recompiled the stored procs which
fixed the issue.
But the queries are running slower now. The overall performance of the app
has become sluggish.
The CPU is generally running higher as well!
Have also set LD_LIBRARY_PATH_64 to include the new Solaris 8 threads
Anybody any insights into this? How can we get back to the pre-upgrade
performance levels short of rolling back the EBF.
I guess 22.214.171.124 requires some Solaris ...ASE 126.96.36.199 Error 216 followed by Error 1204
I am running on ASE 188.8.131.52 EBF 10048, on AIX 4.3.3.
Last week I received a Error 216 (temp table failed to clean up) and from
that point on occassional out of lock messages (error 1204), even though I
have 90K locks configured.
The number of locks had been increase from 40K to 90K quite awhile ago for a
previous out of lock support case. (It wasn't the problem, but I couldn't
get tech support to look any further into my issue without increasing the
number of locks. The actual error was caused by the LPM manager, but as the
memory used by the extra locks is small, I went a...ASE 184.108.40.206 to ASE 12.5 and Rep Server 12.1
We are planning the upgrade of our ASE 220.127.116.11 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.
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...Upgrade ASE 18.104.22.168 to 22.214.171.124
I upgraded my ASE to version 126.96.36.199. Now one of the application get
a permanent error: "Not enough procedure cache". I increased the proc
cache to 40% (total memory: 1 GB) - no success. When I rolled back to
188.8.131.52 everything works fine (with less procedure cache).
The ASE is running on Solaris 7. The application connects thru the
Merant ODBC driver. I gave the application already back to development
Any help how this can be avoided by a change on the host/server is
I always recommend dropping/recreating all of the stored...Can't construct query plan in ASE 12.0
Error 325 is being returned when trying to execute a stored procedure on
Adaptive Server Enterprise/12.0/P/SWR 8773 ESD 1/RS6000/AIX
4.3.2/1580/64bit/FBO/Tue Dec 7 03:29:32 1999 ...
this is the code causing the error when running on version listed above...
it's a sub-query within a stored proc
AND SBSB.HIST_ROW_ID = (select
SBSB2.SBSB_CK = SBSB.SBSB_CK
AND CONVERT(CHAR(10),SBEL.SBEL_INSQ_DT,101) = CONVERT(CHAR
When executing same stored procedure on AS...Migrating from ASE 12.0 32-bit to ASE 12.0 64-bit
Has anyone run into any problems migrating from 32-bit to 64-bit?
...Migrating from ASE 12.0 32-bit to ASE 12.0 64-bit
Has anyone run into any problems migrating from 32-bit to 64-bit?
...ASE patch 184.108.40.206 ebf10980 but still meet "kernel timeslice -501, current process infected" error!
kernel: 2.4.9-e.9,glibc:2.2.4-29.1,ASE 220.127.116.11 EBF10980. When ct try
to create a talbe,
dataserver meet "kernel timeslice -501, current process infected", and all
the client cannot connect to server . I had ask ct to add -T1639 traceflag
and increase 'cpu grace time' parameter. But the problem cannot be resolved.
Any help will be appreciated
00:00000:00012:2003/06/25 10:30:42.40 kernel
00:00000:00012:2003/06/25 10:30:42.40 kernel SQL causing error : create
TABLE wzg_temp_tab (
...Error 11051 on ASE 18.104.22.168 NT
When I try to execute this command:
alter table tablename modify birthday null
I get this error:
Server Message: Number 11051, Severity 16
ALTER TABLE 'documentos_extraviados' failed. Table is currently being used
by one or more other tasks.
I'm find in manuals, web, forums and I'm can get information.
Is this on a system that is currently being used?
> When I try to execute this command:
> alter table tablename modify birthday null
> I get this error:
> Server Message: ...any issues to restore dump file of ASE 12.0 (32bit) to a ASE 12.0 (64bit) system ?
Does anyone know whether there is an issue that we restore
the dump file (not master and system db) of ASE 12.0 (32bit)
to a ASE 12.0 (64bit) system ? Assume that both system DBs
are the same.
> Does anyone know whether there is an issue that we restore
> the dump file (not master and system db) of ASE 12.0
> (32bit) to a ASE 12.0 (64bit) system ? Assume that both
> system DBs are the same.
If you have a recent ebf of ASE 12.0 (say 22.214.171.124 or later)
than no problem. Earlier ebfs had a few problems....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
set rowcount 0
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 involvin...PB 8 and ASE 126.96.36.199. return error
We currently are using powerscript to execute a stored proc in sybase and
don't appear to be getting any results back from the database.
If we run the stored proc through another tool, we get the results
Through powerbuilder we are getting a return value of 0 for anything we
check coming back from the stored proc.
Also here is our declaration, are we doing something wrong?
DECLARE DeleteCartonHdr PROCEDURE FOR @return_value = pldDeleteCartonHdr