Trigger Advice ? - Thnx

Question posted by: Terry Hampton (Guest) on November 12th, 2005 06:01 AM

Hello,

I'm a long time user of ORACLE, postgreSQL
and Informix. One of my clients uses DB2 and
I'm now ready to take the plunge.

My first need is to create various DB2 triggers.

Can anyone suggest a good book for an experienced
data base person, but new to DB2 ?

many thanx,
Terry

Quote | Subscribe

2 Answers Posted

Gert van der Kooij November 12th, 2005 06:01 AM

Guest - n/a Posts

#2: Re: Trigger Advice ? - Thnx

In article <3FD495E6.8060002@LimaCorp.com>, Join Bytes!
says...[color=blue]
>
>
> Hello,
>
> I'm a long time user of ORACLE, postgreSQL
> and Informix. One of my clients uses DB2 and
> I'm now ready to take the plunge.
>
> My first need is to create various DB2 triggers.
>
> Can anyone suggest a good book for an experienced
> data base person, but new to DB2 ?
>
>
> many thanx,
> Terry
>
>[/color]

The Application Development Guide contains a chapter about triggers.

The complete PDF link:
ftp.software.ibm.com/ps/products/db2/info/vr8/pdf/letter/db2a2e80.pdf

Paul Reddin November 12th, 2005 06:02 AM

Guest - n/a Posts

#3: Re: Trigger Advice ? - Thnx

Hi,

If you are going to do any SQL/PL in your triggers, I would suggest
you also get the following book

DB2 SQL Procedural Language for Linux, Unix and Windows
Author:Paul Yip.

We have found it invaluable for our Procedures/UDFs/Triggers.

Paul.

Not the answer you were looking for? Post your question . . .
196,829 members ready to help you find a solution.
Join Bytes.com

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 196,829 network members.

Post your question now . . .
It's fast and it's free

Top Community Contributors

Trigger Advice ? - Thnx

What is Bytes?

Popular Articles

Top Community Contributors