RXSQL does not allow the hexadecimal value X'00' in the authorization-name or password in the CONNECT or CREATE PACKAGE statement.
When the STATE command is issued, the variable RXSQLSTATE is now set with two words indicating the type and state of the statement. In previous releases this variable was set with integers indicating the type and state of the statement.
The NAMES command has been enhanced to support a new feature, cursor-names declared for dynamic prepared statements. When the NAMES command is issued, if a statement has a prepare-name and a cursor-name associated with it, RXSQLNAMES will include both names. However, the cursor-name will be enclosed in brackets and immediately follow the prepare-name. Previously, the NAMES command returned all names prepared or declared as a string of names.
The DATETIME defaults are retrieved from the LASTING GLOBALV file instead of the SYSTEM.SYSOPTIONS table in response to SQL/DS Version 3 Release 3 Modification 0 changes.
Many of the error messages have been changed to support the extensions to RXSQL. Different RXSQL error codes and messages may be returned to your programs when run in this release of RXSQL.
DB2 RXSQL was modified to correctly retrieve DATE and TIME defaults in Version 3 Release 2; however no DB2 RXSQL statements may be executed between a COMMIT RELEASE (or ROLLBACK RELEASE) statement and the invocation of the SQLINIT EXEC.
For additional information on this restriction, see:
Some of the REXX Variables that RXSQL sets are renamed as
outlined in following table.
| Variable Name in Version 3 Release 1 | Variable Name in Program Offering |
|---|---|
| RXSQLSTATE | SQLSTATE |
| RXSQLNAMES | SQLNAMES |
| RXSQLSTMT | SQLSTMT |