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

    check the cursors result set in a stored procedure

    Hi all, I am basically an Oracle Developer trying to migrate oracle procedures to DB2 procedures. I am having a problem checking the result set of the cursor. in oracle we use cursor attributes such as cursor-name NOT FOUND etc...., but how do I check the same in DB2 if the cursor retrived any...
  2. dataforums

    check existence of a stored procedure

    Does anyone know how to check if a DB2 stored Procedure exists in the database?
  3. dataforums

    LONG VARCHAR in DB2

    Can anyone plz tell me what is worng in the following statement? I am trying to declare a LONG varable to hold a very large string. DECLARE str LONG VARCHAR(8000); THX:)
  4. dataforums

    Displaying error messages in DB2 procedures

    can anyone plz tell me how to display the error messages in DB2 stored procedures? I need to catch the error message and insert into a status table to check the success of the program(stored procedure). Thanks!!!
  5. dataforums

    Truncate in DB2

    Does anyone know how to 'truncate' a table in DB2? Truncate in Oracle and SQL server is used to completely delete all rows in a table without any logging. But this doesn't seem to work in DB2. Please Help!! Thanks!
  6. dataforums

    Sample stored procedures

    Can someone post simple stored procedures in DB2? Thanks!
  7. dataforums

    Print command in DB2

    I am completely new to DB2. Can anyone plz tell me the command in DB2 to print a string? And also any refernce to DB2 books would be great!!! Thanks in advance!
  8. dataforums

    insert values using dynamic t-sql

    Hi, I am trying to insert data from a temperory table to an permanent table based on some business rules in T-sql procedure using dyanmic t-sql. The temperory and the permanent tables has the same columns. When i am doing the following Insert, it is only working if the temperory table has all...
  9. dataforums

    log error messages in a table

    Hi, Can anyone plz. tell me how to print the error number and the error message and insert them into a log table. And also do I need to check for errors after every DML statement or can I just handle them at the end of each block?? Thanks in advance.
  10. dataforums

    Check if a table exists in the database

    Hi, I am trying to create dynamic tables but I want to check if they already exists in the database. Can anyone please tell me how to check if a table already exists in a sql server database?? Thanks in advance.
  11. dataforums

    Error using cursor within a cursor in t-sql

    Hi guys, I think this a simple error but i haven't been able to figure out what's wrong with the code below: Declare temp_cur CURSOR FOR select table_name from INFORMATION_SCHEMA.TABLES where table_name like 'SAMP_TMP_%' OPEN temp_cur FETCH NEXT FROM temp_cur into @temp_tab WHILE...
  12. dataforums

    ref cursors in T-sql

    Hi All, I have a requirement that the STORED PROCEDURE should return records same like storedprocedure in sqlserver. In oracle ref cursors are used to return multiple values, is there anything in t-sql that can perform this.
  13. dataforums

    Can anyone plz. let me know what the following error means?

    I get an error message for the foll. dynamic sql code: ******************************************************** Declare temp_cur CURSOR FOR select table_name from INFORMATION_SCHEMA.TABLES where table_name like 'SAMP_TMP_%' OPEN temp_cur FETCH NEXT FROM temp_cur into @temp_tab PRINT 'Record...
  14. dataforums

    Bind variables in t-sql

    How do I declare/use bind variables in t-sql? Thanks in advance!!
  15. dataforums

    declare string that can hold more than 8000 characters in T-sql

    Hi, I need to declare a variable that can hold a string of more than 8000 characters. Like oracle provides LONG data type, does t-sql have an equivalent data type. Thanks in advance

Part and Inventory Search

Back
Top