Naming ...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joan - 12 Apr 2006 12:22 GMT

Please,
I'm an Oracle user (ooohhh!!! :-P ) but I have practices with DB/2.
My question it's very simple.

In Oracle I write procedures with PL/SQL.

In SQLServer I write procedures with TransactSQL.

In DB/2 I write procedure with .....¿¿¿??? (exists a name that
identify db/2 sentences scripting)

Thanks.

Reply to this Message

Serge Rielau - 12 Apr 2006 12:38 GMT

> Please,
> I'm an Oracle user (ooohhh!!! :-P ) but I have practices with DB/2.
[quoted text clipped - 6 lines]
> In DB/2 I write procedure with .....¿¿¿??? (exists a name that
> identify db/2 sentences scripting)

SQL PL (SQL Procedural Language).
Really there wasn't supposed to be a name since all DB2 does is
implement the SQL/PSM section of the standard (i.e. it's "just SQL").
Therefore sometimes you will hear users talk about PSM.

There is also "inline" SQL PL which is the subset of SQL PL used in
dynamic compounds (anonymous block in your world), triggers and SQL
Functions

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

Joan - 12 Apr 2006 13:01 GMT

Thanks a lot. Perfect.

Reply to this Message