Hello Group,
I've to get data from some tables with similar structure. So I decided
to write an
Unix shellscript to mask SQL staments (like: SELECT G.$

Can anyone help me insert an "infinity" value into a float column?
- I moved a table with bcp - and can't get two of the rows into the
new table..
the 2 lines in the bcp'd file look like

I want to execute sybase query using VC++. Can anyone give me a sample
program in VC++?
Thanks in advance

Hi me again, well now i think that i am really looser jejee, how can i
do this whitout pass the table 8 f.cking times!!!, i'm sorry but i am
really angry because at this moment i cannot visualize the solution,
help me please:

I desperately need a small example that shows how to call a simple
stored procedure that returns an integer. I need  a solution in C that
uses dblib. I am in an environment that is using an ancient mix of
technologies. We have an old version of solaris, an ancient sun C++

The customer is running the application that uses Sybase database. It
works fine on all the computers but one, where on startup he gets an
error: "Provider cannot be found. it may not be properly installed".
The user is an administrator on that computer. Is there any settings

I've a Sybase running on my Sun OS server, and i need to access him.
How i do that??
On informix DB, i use the dbaccess to access.. and what about sybase??
tks

Recently one of our server database went down.
We are having HP OVPI applicaion installed on that, which got
corrupted.
We tried to restore the db using a dmp file as follows,

Hi Manish Negandhi, thank you for the previous response, i have some
doubts about this:
(1)Remove "cursor" from the stored proc and apply temp table logic
there. i.e. write a code to apply the logic using temp table instead

I'm kinda new to this DBA lark, so this may seem like a stupid question,
but the ASE Replicator docco for 12.5.4 doesn't say anything one way or
the other.
I've been asked to replicate a database from one machine to another.

Can I get the following by querying the sybase data or (more likely)
backup server:
1. An online database's last dumped transaction log file name and
timestamp

Hi i need Ideas for making faster this store procedure, first Let me
tell you the scenario:
I have 2 tables, origin(i lookup and calculate information) and
destiny(insert or update the calculated information), this are the

I get an error when using sp_getmessage on a message that were put into
sysusermessages with sp_addmessage.
The sql is like this:
create proc kpTest as

If this is impossible, I will be gobsmacked.
Can someone *please* tell me how to disable transaction logging in
tempdb? We have absolutely zero interest in point in time recovery on
this DB, and all the transaction log is doing is causing us

For monitoring a sybase disaster recovery site I am trying to get the
following information from the sybase server:
       1. Last DUMPED transaction id and its timestamp from an online
database.