Archives
09.04   10.04   11.04   12.04   01.05   02.05   03.05   04.05   05.05   06.05   07.05   08.05   09.05   10.05   11.05   12.05   01.06   02.06   03.06   04.06   05.06   06.06   07.06   08.06   09.06   10.06   11.06   12.06   01.07   02.07   03.07   04.07   05.07   06.07   08.07   09.07   10.07   11.07   12.07   01.08   02.08   03.08   04.08   05.08   06.08   07.08   08.08   09.08   10.08   11.08   12.08   01.09   02.09   03.09   04.09   05.09   06.09   07.09   08.09   09.09   10.09   11.09   12.09   01.10   02.10   03.10   04.10   05.10   06.10   07.10   08.10   09.10   10.10   11.10   12.10   01.11   02.11   03.11   04.11   05.11   07.11   08.11   09.11   10.11   11.11   12.11   01.12  

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:

1. 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.
   
   
2. Run the Data Mover utility with the modified DMS script as an argument.
   
   eg., OS: Solaris
   
   

   
   % psdmtx -CT ORACLE -CD NAP11 -CO NAP11 -CP NAP11 -CI people -CW peop1e -FP /tmp/retrieveddl.dms
   
   

   
   On successful completion, you will find the DDL statements in /tmp/retrieveddl.dms file.
   

Check chapter #2 "Using PeopleSoft Data Mover" in Enterprise PeopleTools x.xx PeopleBook: Data Management document for more ideas.

______
(Originally posted on blogs.sun.com at:
http://blogs.sun.com/mandalika/entry/extracting_ddl_statements_from_a)

Posted by: Giri Mandalika.    # 1:07 AM 0 comments.     Links to this post