Re: Extract SQL statement used to create table

So, the OP wanted to know if there was a system view which would show if a
file was created from DDS or DDL.

First, you may often see that on a PF with DSPFD. Ones created with DDL
will show

Data Base File Attributes
Externally described file . . . . . . . . . : Yes
SQL file type . . . . . . . . . . . . . . . : TABLE

While ones created with DDS will not show "SQL file type".

But, back to the OP's question, see the following:

Select
Table_Type,
System_Table_Name,
System_Table_Schema

From qsys2.systables

Where System_Table_Schema = 'ROB'
Order by System_Table_Name
;

https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/db2/rbafzcatsystbls.htm

T A ROB
P AAAKEY ROB
T AAAKEYC ROB
V AAAKEYL01 ROB
P AB ROB
T ABXYZ ROB
T AB2 ROB
P ACTIVEDB ROB
T ADAM ROB
...

Rob Berendt