DB2 SQL-Error: -20129

Short Description: LOCAL SPECIAL REGISTER IS NOT VALID AS USED C E SQL S T P S A SET

Local special registers cannot be referenced in an assignment statement (SET or VALUES INTO) that assigns multiple values. For example, the following special registers are local: CURRENT SERVER and CURRENT PACKAGESET. Additionally, the local special registers cannot be referenced in a SET host-variable statement that has parenthesis around the special register. The following statements are not valid: SET (:hv1) = (CURRENT SERVER); SET (:hv1,:hv2) = (CURRENT SERVER,CURRENT PATH); VALUES CURRENT SERVER, CURRENT DATE INTO :c1, :c2;Severity: 8 (error)

 <-  BACK TO INDEX