problem with a trigger - DB2 Database

rdudejr

Hey guys quick question:

Ive got the following trigger and error message Im having problems with

CREATE TRIGGER DB2INST1."AI_DOPORDM0" AFTER INSERT ON
DB2INST1.HMILDVL1_MCCSDTA_DOPORDM0
REFERENCING NEW_TABLE AS NTAB
FOR EACH STATEMENT MODE DB2SQL
MERGE INTO DB2INST1."HMILDVL1_MCCSDTA_DOPORDM0_TEMP" USING NTAB
ON DB2INST1."HMILDVL1_MCCSDTA_DOPORDM0_TEMP".REF_ID = NTAB.REF_ID
WHEN NOT MATCHED THEN INSERT (NTAB.REF_ID)
WHEN MATCHED THEN UPDATE DB2INST1."HMILDVL1_MCCSDTA_DOPORDM0_TEMP" SET
REF_ID = NTAB.REF_ID

DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL0104N An unexpected token "WHEN" was found following "NSERT
(NTAB.REF_ID)
". Expected tokens may include: "<merge_value_spec>". LINE NUMBER=6.
SQLSTATE=42601

Im not sure what Im doing wrong, as I thought I followed the post of
syntax from here http://www.thescripts.com/forum/thread184082.html

Someone please help (and im on V8 FP 11)

Aug 9 '06 #1

Subscribe Post Reply

1081

Serge Rielau

INSERT _VALUES_ (NTAB.REF_ID)

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/

Aug 9 '06 #2

rdudejr

thanks worked great!
Serge Rielau wrote:

INSERT _VALUES_ (NTAB.REF_ID)

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/

Aug 9 '06 #3

Similar topics

Trigger porting problem

by: gustavo_randich | last post by:

Hi :-) I'm porting a project from Oracle to DB2 and now I'm trying to avoid error SQL0746N in a trigger which reads the same table in which the trigger is defined. Below is Oracle's...

DB2 Database

Trigger problem no rowlevel support, please help!

by: SUKRU | last post by:

Hello everybody. Unfortunately I am pretty new to sql-server 2000 I need some help with a Trigger I created. I created a trigger witch takes the id of the affected row and does a update on a...

Microsoft SQL Server

same trigger problem

by: mob1012 via DBMonster.com | last post by:

Hi All, I wrote last week about a trigger problem I was having. I want a trigger to produce a unique id to be used as a primary key for my table. I used the advice I received, but the trigger is...

DB2 Database

Trigger problem DB2LUW

by: dean.cochrane | last post by:

I have inherited a large application. I have a table which contains a hierarchy, like this CREATE TABLE sample_table( sample_id int NOT NULL parent_sample_id int NOT NULL ....lots of other...

DB2 Database

GridView on Delete Method problem

by: Ed Dror | last post by:

Hi there, I'm using ASP.NET 2.0 and SQL Server 2005 with VS 2005 Pro. I have a Price page (my website require login) with GridView with the following columns PriceID, Amount, Approved,...

ASP.NET

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA