Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jhonty

    stored proc takes too long time for processing

    HI, It seems that you have changed the search condition in the proc? Use SET SHOWPLAN ON and then SET NOEXEC ON and exec the proc. , check if it is doing table scan, correct the where condition so that it will use proper index on column then OFF both SET option command, and then reexecute the...
  2. jhonty

    append to existing data

    Hi, Its character field so no need to worry just do update <tab_name> set <field> = '1'+<field name> where <condition_if_required> all the best.
  3. jhonty

    cannot run dataserver and backup server at same time

    You can reinstall the backup server and try again, probabily you'll be succeed. All the best.
  4. jhonty

    retrieving data from different servers

    Hi, Another simpler way is accessing thru the remote server configuration, u need to add the server1 into server2 by using sp_addserver command (see the syntax) add in its interface file, give proper access to any of the user then write this query within one small proc in server2 by calling...
  5. jhonty

    Simple questions for the gurus -- need your help

    1. How can I get the list of all databases in sybase ver 12? sp_helpdb 2. How to get a list of tabels from a database? select name from sysobjects where type = 'U' order by name 3. How to list all the table defenitions from a table? sp_help <table_name> 4. How to List all views from a database...
  6. jhonty

    Calling Stored Procedure Using Date Variables

    How are you using BeginDate, EndDate variable in the query? try out with <Date_field> between @BeginDate and @EndDate else <Date_field> >= @BeginDate and <Date_field> <= @EndDate
  7. jhonty

    error log

    Hi Marvin, They might be talking abt. syslog table i.e. transaction log table which is getting full, there is only errorlog file in sybase I know, check for errorlog file for exact error message. &quot;DUMP TRAN WITH TRUNCATE_ONLY&quot; will work for clearing the log, check for the other...
  8. jhonty

    SQL stmt. for debug?

    Hi JMCraig, Thanks for your response and efforts. Its like user can configure their own debug level, higer level would return (in log)only SP name, intermediate level will tell little more (user defined error msg. and desc.) and lowest level will tell the actual sql stmt. where error occured...
  9. jhonty

    Free port??

    Thanks Ged, its more effective.
  10. jhonty

    Hi all, Can we directly migrate

    DO u mean I can upgrade directly from 10.X,11.X to 12.5 without doing migration???
  11. jhonty

    Hi all, Can we directly migrate

    Hi all, 1. Can we directly migrate from Sybase version 10.X to 12.5? 11.0.X to 12.5 ? 11.9.X to 12.5 ? 2. Is anybody have wright up for problem faced during migration between different versions and 12.5? or the know problems (syntax / behavior changed) and there fixes while...
  12. jhonty

    Editor (Notepad)?

    Hi, How can I use notepad as a isql -Enotepad editor? I've Sybase 11.X (solaris 2.X) server and Windows2000 client. What setting would be required? Thanks in advance.
  13. jhonty

    Add table problem

    Who is owner of the DB? The login which you are using for creating table, is it having the right permission to do so just check it out.
  14. jhonty

    SQL stmt. for debug?

    Hi guys, How anyone can set/code the debug level, so that he can see the actual sql stmt. where error has occured? One thing I've think that I should take stmt. in one variable and if return is error print that variable. Is there any other way Sybase provides or any body can suggest. Thanks...
  15. jhonty

    Free port??

    Thanks feroz now i can see.
  16. jhonty

    Free port??

    Hi All, How I can identify in Solaris that which ports are in used and which ports are free? Thanks in advance.
  17. jhonty

    Log Reader / Agent ?

    How do I keep a data cache (in C++) keep the data in memory including any changes that can happen to the database? The Sybase server is System 11. I want to create a data chache in C++ but how can I get the change that happenes to the log to the C++ program. I am looking for an agent that will...

Part and Inventory Search

Back
Top