Case in hand: Given a PeopleSoft Data Mover exported data file (db or dat file), how to extract the DDL statements [from that data file] which gets executed as part of the Data Mover's data import process?

Here is a quick way to do it:

Insert the SET EXTRACT statements in the Data Mover script (DMS) before the IMPORT .. statement.

eg.,

% cat /tmp/retrieveddl.dms

..SET EXTRACT OUTPUT /tmp/ddl_stmts.log;SET EXTRACT DDL;..

IMPORT *;

It is mandatory that the SET EXTRACT OUPUT statement must appear before any SET EXTRACT statements.

Run the Data Mover utility with the modified DMS script as an argument.