Search results for query: *

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...

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...

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...

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+

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...

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

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 !!!

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...