468,321 Members | 1,639 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,321 developers. It's quick & easy.

Naming ...

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.

Apr 12 '06 #1
2 1314
Joan wrote:
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)

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
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Apr 12 '06 #2
Thanks a lot. Perfect.

Apr 12 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

27 posts views Thread by Derek | last post: by
7 posts views Thread by DEX | last post: by
4 posts views Thread by Mark Broadbent | last post: by
3 posts views Thread by clintonG | last post: by
8 posts views Thread by Jason | last post: by
114 posts views Thread by Jonathan Wood | last post: by
35 posts views Thread by Smithers | last post: by
9 posts views Thread by BillCo | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by howard w | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.