Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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