> I have now created my first executaeable proceedure but it does not return any records...

That's right, because _executable_ procedures don't return records.
They can return only values.
What you need is _selectable_ procedure. It means that it must:
1) have output variables;
2) assign values to them;
3) call SUSPEND statement.

Every call of SUSPEND returns one record to client. You must call it
as many times as many records you want to return. Loops also are useful.

SY, SD.