Problems Converting T-SQL code to SQL PL

[Adam Greifer]

I have the following T-SQL code:

SELECT @ErrorDiagInfo = name + ': ' + @ErrorDiagInfo
FROM sysobjects WHERE id = @@PROCID

How can you return a stored procedure identifier in DB2?

Another question:

In T-SQL I have the following:

BEGIN TRAN x
--update code goes here
IF ERROR<> 0
ROLLBACK TRAN x

DB2 errors out with "A rollback to to a savepoint or a named BEGIN
TRANSACTION is not supported."

I know DB2 has a SAVEPOINT command and a BEGIN ATOMIC ... END. Which would
be a better solution here?

Thanks for your help.

Adamco

[Mark A]

"Adam Greifer" <ag******@adamzapple.com> wrote in message
news:4_dPb.106842$I06.614565@attbi_s01...

I have the following T-SQL code:

SELECT @ErrorDiagInfo = name + ': ' + @ErrorDiagInfo
FROM sysobjects WHERE id = @@PROCID

How can you return a stored procedure identifier in DB2?

Another question:

In T-SQL I have the following:

BEGIN TRAN x
--update code goes here
IF ERROR<> 0
ROLLBACK TRAN x

DB2 errors out with "A rollback to to a savepoint or a named BEGIN
TRANSACTION is not supported."

I know DB2 has a SAVEPOINT command and a BEGIN ATOMIC ... END. Which would
be a better solution here?

Thanks for your help.

Adamco

Do you have an SQL Reference manual? Try looking at the concat function.

[Serge Rielau]

This question hasn't been asked in a while:
http://groups.google.ca/groups?q=pro...ibm.com&rnum=1
the procid is served up in DBINFO.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[Knut Stolze]

Serge Rielau <sr*****@ca.eye-bee-m.com> wrote:

This question hasn't been asked in a while:
http://groups.google.ca/groups?q=pro...ibm.com&rnum=1 the procid is served up in DBINFO.

And here is an article describing how you can implement the function along
with a bunch of various scenarios where it might be used:

http://www-106.ibm.com/developerwork...302stolze.html

The download in that article contains the C code and the compiled libraries
for pretty much all the different platforms DB2 runs on. There is also a
Java version available.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena