PeopleSoft instance from DB2 to Oracle

You have moved a PeopleSoft instance from DB2 to Oracle and when trying to build tables and indices, you notice that the SQLs generated by the Application designer are wrong / unacceptable, What could be the possible issue ?
which is the best option
a) Issues with PSDDLMODEL
b) Definitely not any one of the above
c) Issues with Application Designer
d) Issues with PSOPTION
e) Issues with PSDDLTEMPLATE

Questions by dorsalad

Showing Answers 1 - 3 of 3 Answers

Reena

  • Jan 18th, 2017
 

a) Issues with PSDDLMODEL
This table holds the Oracle DDL templates (i.e how the syntax of table , index etc should be in a particular DB )
There is a delivered DMS script (psddl.dms) that can be run to reset the structure of the objects

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions