The two hyphens in front of a line indicate that the line is a comment and the text will be ignored by the compiler.
The optional "OR action" conflict clause that follows the UPDATE keyword allows the user to nominate a specific constraint conflict resolution algorithm to use during this one UPDATE command.
Refer to the section entitled ON CONFLICT for additional information.
But the 2nd Where clause simply return the message of `more than one row is return', since the id is unpredictable and this create a `many to many' relationship in both tables. Many Thanks, (script) REM* the where-clause of the update cannot work UPDATE table b SET column_b1 = ( SELECT MAX(column_a1) FROM table_a a, table_b b WHERE a.id=GROUP BY a.id) WHERE table_IN (SELECT MIN(id) FROM table_a GROUP BY id); Your example is somewhat confusing -- you ask "update column a1 in table a where data in column b1 in table b" but your update shows you updating column b1 in table B with some data from table a. Every month the client office is to give data(NEW & EDITED) "BY DATE RANGWISE" to the headoffice in CD. Now, you "two step" it: insert into gtt select b.id, count(*) cnt from tabb b, taba a where = and a.cycle = b.cycle and b.site_id = 44 and b.rel_cd in ( 'code1', 'code2', 'code3' ) and b.groupid = '123' and is null group by / that gets all of the id/cnts for only the rows of interest.
Additionally -- given the way the where and set clauses are CODED in the above -- it would succeed. The Headoffice is merge the data into their system. For migration data first of all i create another temporary user named VISTEMP then cotinuing this kinds of code insert into VISTEMP. Now we can update the join: update ( select a.pop, from taba a, gtt b where = ) set pop = cnt / and thats it. Hi Tom, Im selecting approximately 1 million records from some tables and populating another set of tables.
Hi , Is there a function module to update EABL table automatically.i have tried to update it with ISU_DB_EABL_UPDATE , however the records are not updating the table as a result.