"WITH NO DATA" is mandatory in CREATE TABLE from full-select on DB2 for LUW.
Please see syntax diagram of CREATE TABLE in "DB2 Version 9.5 for LUW SQL Reference Volume 2"
So, you can't CREATE TABLE and populate data in it by one statement.
After CREATE TABLE, you can INSERT data in it from recursive query.
Like this:
INSERT INTO MYDB.T_HIER
WITH TEMPTAB(...) AS (.....) SELECT * FROM TEMPTAB;