SELECT Statements in Embedded SQL
The rules and restrictions are:
Status Parameter |
Assigned Value |
SQLSTATE |
‘02000’ |
SQLCODE |
+100 |
Values are not assigned to the host variables specified in the INTO clause.
Status Parameter |
Assigned Value |
SQLSTATE |
‘21000’ |
SQLCODE |
-811 |
Values are not assigned to the host variables specified in the INTO clause.
Status Parameter |
Assigned Value |
SQLSTATE |
‘22509’ |
SQLCODE |
-303 |
SQLSTATE |
‘22003’ |
SQLCODE |
-304 |
SQLSTATE |
‘22003’ |
SQLCODE |
-413 |
Values are not assigned to the host variables specified in the INTO clause.
If no corresponding indicator host variable is specified, then Teradata Database assigns these values to the status parameters:
Status Parameter |
Assigned Value |
SQLSTATE |
‘22002’ |
SQLCODE |
-305 |
Values are not assigned to the host variables specified in the INTO clause.
Status Parameter |
Assigned Value |
SQLSTATE |
‘00000’ |
SQLCODE |
0 |