db2 - When a sql returns more than one value, what value will be stored in the host variable -

db2 - When a sql returns more than one value, what value will be stored in the host variable -

in coboldb2 program, value stored in host variable after getting -811 sqlcode. (i.e multiple rows returned query).

no info fetched host variable because sqlcode < 0 means there error. please refer link: ibm sql tutorial

you can utilize statements of kind retrieve single rows of info host variables. single row can have many columns desired. if query produces more 1 row of data, database server cannot homecoming data. returns error code instead.

db2 cobol mainframe