User Profile

Collapse

Profile Sidebar

Collapse
Rocketfuel
Rocketfuel
Last Activity: Feb 5 '08, 11:09 AM
Joined: Nov 5 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Rocketfuel
    replied to Insert from table in DB A to table in DB B
    in DB2
    Hi

    Thanks for the reply. I will definitely try your advice. I got around the problem by using MS Access and just creating a ODBC links to both databases and then executing an append query. Thanks for expanding my knowledge of DB2....
    See more | Go to post

      Leave a comment:

    • Rocketfuel
      started a topic Insert from table in DB A to table in DB B
      in DB2

      Insert from table in DB A to table in DB B

      Hi

      I know this is a stupid question but I am quite new to DB2. I need to copy data from a table in Database A to a table in Database B, the table in DB B already contains data I just want add to it. Can anyone help me with a query on how to achieve this I dont want to use the "Load Utility".

      Thanks very much.
      See more | Go to post
      • Rocketfuel
        replied to Object in a zombie state
        in Visual Basic
        Hi

        Please ignore previous post, Preserve on Commit did work, I had it in the wrong procedure. You can also use
        Code:
        Recordset.Requery()
        .

        A million thank you`s to Veena, you really did save my life.

        Regards
        Caleb...
        See more | Go to post

          Leave a comment:

        • Rocketfuel
          replied to Object in a zombie state
          in Visual Basic
          Hi

          I have tried that, I am still getting the same error message. I am using the BeginTrans and CommitTrans in the code. I suspect that I might be using the wrong provider, would
          Code:
          "Provider=SQLOLEDB;Data Source=ServerName;Initial Catalog="Playground";"Integrated Security=SSPI;"
          work with above.

          Thanks for your reply....
          See more | Go to post

            Leave a comment:

          • Rocketfuel
            started a topic Object in a zombie state
            in Visual Basic

            Object in a zombie state

            Hi

            I have a program that extract data from multiple tables into one table on DB2. Recently I have changed the program to output the extract table to SQL Server 2005. I then got the error ITransaction::C ommit or ITransaction::A bort was called, and object is in a zombie state.

            Any help on this error would be greatly appreciated.

            Thanks very much.
            See more | Go to post
            • Rocketfuel
              replied to Insert Multiple Rows
              in SQL Server
              I apologise, blame it on mouse jitters. I had to changed a program to output to SQL Server instead of DB2(current). Tangled up the SQL. I got it to work just now.
              Thanks Jim
              Thanks iburyak...
              See more | Go to post

                Leave a comment:

              • Rocketfuel
                started a topic Insert Multiple Rows
                in SQL Server

                Insert Multiple Rows

                Hi All

                I have the following query in a vb program that inserts multiple rows in a table. The database resides on a server running SQL Server 2005.

                Code:
                Insert into TableX values (val1,val2,val3),(val1,val2,val3),(val1,val2,val3),(etc)
                It processes about 12 rows and then I get the error.
                Run-time error '-2147217900 (80040e14)':
                Incorrect syntax near ',' .

                Any help would be appreciated....
                See more | Go to post
                No activity results to display
                Show More
                Working...