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 Chriss Miller 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: *

  • Users: morsi
  • Order by date
  1. morsi

    Multi-DBMS report

    HI, I'm using an application which connects to Sybase and Oracle databases (same model). It uses crpe32.dll to launch crystal report (7.0) at runtime. To ensure designing the same file ".rpt" for both databases, I use PELogOnServer function and pass P2SSYB10.DLL or P2SORA7.DLL as first...
  2. morsi

    Drop Index

    I have some index descriptions in a table : INDEX_NAME, TABLE_NAME, COLUMNS (as varchar eg. 'COL1, COL3'), IND_UNIQUE and IND_CLUSTEED. I would like fetching this table in a ps to create indexes with exec command. I must deleting indexes before creation but tables are located in database...
  3. morsi

    Sybase Error Message

    What i wnat to get is for exmaple the message : [Attempt to insert duplicate key row in object 'BOOK' with unique index 'BOOK_PK' ] like it appear in SqlAdvantage but in sysmessages i found only the template of the message 2601 : [Attempt to insert duplicate key row in object '%.*s' with unique...
  4. morsi

    Drop Index

    The drop of index that i like to do is in ps dynamically with "exec". I can't use "use namedb_db" in ps ! The second solution is hard to implement dynamically in a ps but if no other solution is possible i will try this. A+
  5. morsi

    Drop Index

    Hi, I would like to drop index in a databse different from the current db. In creation the syntax "create index index_name on dbname_db..table_name(..)" is ok but "drop index dbname_db..table_name.index_name" don't work ? Besides, deleting line from sysindexes isn't possible...
  6. morsi

    Sybase Error Message

    Hi, How to get Sybase Error Message in a procedure. With @@error, i can only get the description in master..sysmessages but i want to insert the full message (formatted with the right objects) in a table of log. Thanks
  7. morsi

    A Simpe Join Which Madden Quey Optimiser

    Good, I have been always deleted the statistics' TABLE_JOB. No result. But when use set forceplan on, i have the good plan. I can't using set forceplan everywhere im my sql codes : it's size is 500 Ko !!!
  8. morsi

    A Simpe Join Which Madden Quey Optimiser

    Hello, I'm looking a strange behaviour on my Sybase 12.5 when executing a simple query : select T.* from TABLE1 T, TABLE_JOB J where J.SESSID = 0 and T.ELEMENTID = J.ELEMENTID TABLE1 is a table of 80.000 rows, have an non-custered index on ELEMENTID TABLE_JOB is a table of 1 to 100 rows, have...

Part and Inventory Search

Back
Top