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 dencom 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: Carney123
  • Content: Threads
  • Order by date
  1. Carney123

    charindex

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

    Disable Index

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

    Foreign key

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

    sa_table_fragmentation

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

    SQL Profiler

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

    Indexing

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

    Convert SQL Server Procedure

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

    Invoke DB2 from batch file

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

    Help on load text file to db2

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

    Query

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

    Other ODBC

    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

Part and Inventory Search

Back
Top