Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
somdeb_bec
Starting Member
1 Post |
 Posted - 2007-12-07 : 07:23:54
|
| I am in a migration project from Mainframe to Windows using Microfocus IDE.The current DB2 databases will be converted to SQL Server 2005. The Cobol pgms on Mainframe have embedded SQL queries which will now have to go against the SQL server DB. As a part of error handling, the COBOL pgms evaluate the SQLCODE from each query.Is there a mapping of the SQLCODES between DB2 and SQL Server 2005? I understand that SQL server uses a different approach for error handling (using TRY/CATCH and ERROR NUMBER).Any help will be greatly appreciated.ThanksSomdeb |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-12-09 : 01:23:40
|
I don't know of any such mapping. however you can get all the error msgs stored on the server from this:select * from sys.messages where language_id=1033and match them up yourself. fun!
elsasoft.org |
 |
|
|
|
|
|
SQLCODES from SQL server