the closest equivalent would be to write a stored procedure in SQL Procedure Language.

db2 "call myschema.procname (p1, p2)"

I once used a Migration Tool from IBM which converted Oracle PL/SQL to SQL Procedure Language. Check their website.

Best, Hal Steiner




-----Original Message-----
From: db2udbdba-ezmlmshield-x84406630.[Email address protected]
To: [Email address protected]
Sent: Wed, 22 Nov 2006 3:54 PM
Subject: example of (execute PL/SQL in DB2) ???


Hi gurú's.

in Oracle:
execute procedure_name

i need example of (execute PL/SQL in DB2) please.

thank's

k=)

Atte.
Daniel Manque.
Analista de sistemas.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
________________________________________________________________________
Check out the new AOL. Most comprehensive set of free safety and security tools, free access to millions of high-quality videos from across the web, free AOL Mail and more.

DB2 & UDB email list listserv db2-l LazyDBA home page