|
View previous topic :: View next topic
|
| Author |
Message |
sri_mf
Active User
Joined: 31 Aug 2006
Posts: 218
Location: India
|
|
|
|
Hi All,
Till now i used SQLCODE in Cobol-Db2 programs for verifying the successful execution of the query or end of records and any abend etc.
But when i analyzing a program i came across SQLSTATE instead of SQLCODE. Does it has an advantage over SQLCODE?
Which one is preferred to use and why?
Seniors please provide some information.
Thanks
Sri. |
|
| Back to top |
|
 |
sushanth bobby
Senior Member
Joined: 29 Jul 2008
Posts: 1020
Location: India
|
|
|
|
Hi Sri,
| Quote: |
| Practically speaking, you should use SQLSTATE values when you are concerned about portability since SQLSTATE values are common across many database managers. |
Check this link
Thanks,
Sushanth |
|
| Back to top |
|
|
|
|
