CA Datacom SQL query fails with:
SQLCODE = -148, SQLSTATE=21000
MESSAGE = SUBQUERY AT LVL 1 NBR 1 RETURNED MORE THAN 1 ROW
Release : 15.1
Component : CA DATACOM SQL
CA Datacom Messages Guide documents SQLCODE -148:
-148 - SUBQUERY AT LVL aaaa NBR bbbb RETURNED MORE THAN 1 ROW
For proper evaluation, the subquery in question must return no more than one row. The level of nesting for the subquery and the total number of levels of nesting are displayed in the message text. However, it has been determined that the subquery returned more than a single row.
The SQLSTATE that equates to this SQL return code is 21000.
Ensure that the subquery is specified in such a way as to return only one row.
This is an SQL restriction. Cannot set a single column value to multiple sub query values.
Refer to CA Datacom Messages SQL Codes for the set of codes.