Yes, you would use a SELECT INTO statement with the BULK COLLECT clause.
https://www.ibm.com/docs/en/db2/11.5.x?topic=plsql-bulk-collect-into-clause