Search results for query: *

I have SELECT CHARINDEX('vital', @document, 5) in SQL and I want to equivalent command in Sybase can anyone help on this. If I do same thing it throws an error. Function CHARINDEX invoked with wrong number or type of argument(s). Is there equivalent start_location parameter in Sybase? thanks...

How Do I disable and enable an index in sybase 12.x.. Thanks for any help.

I need a script to enable Enforce relationship for INSERTs and UPDATES check box. My foreign key is already established but this check box was unchecked, now I need to check this box using scripts. I need to send the script to client and also there are about 2000 tables involved. Any help is...

when I try to execute CALL sa_table_fragmentation ('account') throws an error Incorrect syntax near '('. I tried with many options, SELECT * FROM sa_table_fragmentation ( owner_name = 'dbo' ); SELECT * FROM sa_table_fragmentation ('dbo'); SELECT * FROM sa_table_fragmentation() I couldn't...

I want to capture the queries and stored procedures when application is running. In SQL I can run the profile and capture the queries. Same way I want to do it in Sybase.

Is there Equivalent tool in Sybase which does the SQL Server 2000 SQL Profiler does?

How do we check the query is using correct indexes. Thanks for any help

I have SQL Server Procedure which has a query using UDF and I want convert this procedure into Sybase procedure. But Sybase doesn't support UDF's. How shall I convert into Sybase.

I want to execute multiple DB2 commands like import from the batch file. I can do it from command prompt manually, but I want automatically run all the commands from the .exe file. Any help will be appreciated.

My goal is to load all text file data into temp table and from there Update base tables. This can be easily achivable in Oracle and SQL, I am not familiar in DB2. My client uses DB2, I don't want to be novice in DB2 but it is unfortunate.

Thank you for your reply. I want to load this file from stored procedure instead of doing it from control center. Is there any command line? I try to see online help, but no luck. Can you give me any ideas on this. Thanks again

I have a text file which has following format and I want to load into multiple tables in db2. A,'Abcd',12344,'89','Cad' B,09122008,04 C,'Unit','Unit Number 3899','Institute',2002-11-10 A,'Cabd',88388,'90','DAC' B,08112007,03 C,'Unit','Unit Number 3939','Institute',2001-10-05 All A's goes to...

Thanks a lot. That helps.

I have following table Type Description Amount I Cash 100 I Cash 200 I Cash 300 I Express 1000 I Express 1000 M Money 200 M Money 200 N Net 10000 N Net 500 L Loan 200 L Loan...

I have DTS package in SQL 2000 and needs to migrate into SQL 2005 SSIS. I used Other ODBC daa source in SQL 2000 and didn't find equivalent in SQL 2005 SSIS. How I shall do that? Any help appreciated