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 derfloh 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: *

  1. ChrisRutherford

    Should I use an update cursor for this and if so how?

    Oops, almost gave you the star SQLSister, but I realised my almost mistake and gave the star to George. Thanks again team, excellent solution. Kind regards, Chris
  2. ChrisRutherford

    Should I use an update cursor for this and if so how?

    Hi there, Totally agree however I'm not sure how to do that. I notice there is a link to "Thank SQLSister", I'll try that. Kind regards, Chris
  3. ChrisRutherford

    Should I use an update cursor for this and if so how?

    Hi there, Thanks for the post George, this worked first time and is very efficent! There are close on 700,000 records in this table which I was a little worried about however things are perfect. It takes about 2 minutes to update records so again thank you. Appreciate the time you took to...
  4. ChrisRutherford

    Should I use an update cursor for this and if so how?

    Oh, slight P.S. that may help. The Coverage table also has a row called Product_Code (varchar(10)). This is unique for each Policy_Number, Coverage_Number combination. For example... Policy_Number Coverage_Number, Product_Code 123456 01 001 123456 02...
  5. ChrisRutherford

    Should I use an update cursor for this and if so how?

    Hi there, I have a problem with populating a field in a table as there are a few records. I have a table called Coverage. In there we have two fields, Policy_Number (varchar(20)) and Coverage_Number (varchar(10)). There could be up to four records per policy in this table. Currently the...
  6. ChrisRutherford

    Delete query goes on for ever...

    Hi Marc, Thanks for the reply and now I've indeed learnt the need for indexes even on small tables. Once I put an index on both tables everything worked fine. The delete statements took less than a second. Huge difference considering I cancelled the job last time after it had been processing...
  7. ChrisRutherford

    Delete query goes on for ever...

    Hello, I have two tables in my DB2 7.2 fixpack 5 database... Table Name - zz_caa_data Columns id int account_id int first_name char(50) last_name char(50) * There is no primary key defined. Table name - zz_caa_delete Columns id int * There is no primary key defined. The table...
  8. ChrisRutherford

    Querying the AS400, how???

    Hi there, Thanks for those links, much appreciated. Cheers, Chris
  9. ChrisRutherford

    Querying the AS400, how???

    Hello, I know next to nothing about AS400 so I need a starting point. Microsoft SQL Server has a program called Query Analyser, IBM DB2 ver 7 has a program called Command Center. They both do much the same thing, i.e. you can query the database using DDL, DML etc. Does AS400 have this as...
  10. ChrisRutherford

    Update commad, DB2 novice question...

    Thanks T Blom for your reply, much appreciated. Cheers, Chris
  11. ChrisRutherford

    Update commad, DB2 novice question...

    Hello, Thanks Stoggers that worked perfectly, thanks. T. Blom, thanks for your help but you never directed me to the tools menu to fix this issue, you mentioned to put a ; at the end of the statement which I did but this did not work. I make a point of reading all information. Cheers, Chris
  12. ChrisRutherford

    Update commad, DB2 novice question...

    Hello, Thanks again for your reply. The object lja_split is definitley a table with the schema name admin. I've gone into Control Center and verified this. I can perform a normal Select statement with the same where clause and it return's what it should, the one row that needs updating...
  13. ChrisRutherford

    Update commad, DB2 novice question...

    Hello, Thanks for your reply. I've also droped the admin. off the update command and still get the same kind of error message... SQL0104N An unexpected token "update" was found following "BEGIN-OF-STATEMENT" Expected tokens may include "EXPAND". SQLSTATE=42601...
  14. ChrisRutherford

    Update commad, DB2 novice question...

    Hello, I come form the world of SQL 7 / 2000. I'm trying to run an undate command in DB2 ver 7 command center but I keep getting a mad error. My command is the following... update admin.lja_split set spl_pol_trans = '01' where spl_fy = '02' and spl_campaign = '0083' and spl_split = '01' I...

Part and Inventory Search

Back
Top