I hv a table that contains a column which contains unformated data .
Like
          Col1    varchar(35)      col1  varchar(35)
          AS PD FT                 AS-PD-FT

Hi, all.
Here's approximate design with which I have to work. At source I have:
create table source(some_id integer, iterations integer);
And I should make:

ASE is dropping plan for my procedure too frequently. This causes
procedure to take up more than double the time required to run. how can
i force server to NOT drop the cached plan??
Please help.

Thanks for responding to my earlier query about retrieving the password
for a locked SA account.I was just curious if someone knows a stored
procedure for restarting the server without actually rebooting it.Please
respond if anyone has any idea about it.

I have an existing SQL 7 server named HHARBR. HHARBR has a database named
SPR with a table named "reportname" in it, the table has the name HHARBR
embedded the table data.
I migrated the HHARBR database SPR to a second server called HHARBR2. When I

Currently I must manually complete the following commands to set a new value
for the "open objects" and "open indexes". I need a way script this process
in a batch file.
COMMANDS RAN: This is nothing to script, these commands obtain the current

Any recommendations for a log sniffer tool that intelligently sends
email notifications based on errors in the sybase errorlog?
By intelligent, I mean the tool would be able to deduplicate messages
over a specified time period and say, "this error has occurred NNNNN

Hi all
I have a server running on a unix box to which the sa login has been
locked and password forgotten.The box also has a replication server on
it.I have tried trace flag 4044 but it has'nt worked.If anybody has an

I am creating this view:
create view
    pfw_19_rsybtest_h
as

Error message:
com.sybase.jdbc2.jdbc.SybBatchUpdateException: JZ0BE:
BatchUpdateException: Error occurred while executing batch statement:
Can't allocate space for object 'TMP_TABLE' in database 'tempdb'

Is there a method to get more information about the query tree then I can
get from simply querying the sysprocedures table?
For instance:
select * from sysprocedures where id=OBJECT_ID("test2");

Kindly enlighten me as to who a Sybase Developer is:
Is it that a Sybase Developer is involved in:
-- Application development using Sybase as the backend (and using some
other tool as frontend)?

Hi all..
I need to change the following Select statement to an update statement
which updates hf.active to 'N' where all the hf.active found is 'n'.. I
am finding difficulties of re-writting this because of the recursive

Is there any kind of functionality, similar to a dynamic row ID, that I
could use to retrieve a subset of rows from the middle of a result set,
based simply on the position of the rows within the result set?  For
example, I'd like to be able to say, "Give me only the 100th through

Hello friends,
excuse me if my question is too simple , but I am relatively new to
Sybase.
Is there any function in Sybase SQL to check whether a value or a