Answer Posted / sridevi bandi
simplify complex select statements.we can use load-lookup
to simplify joins.use dynamic sql instead of a condition in
a select statement.one program can create multiple reports
simultaneously.we can save compiled programs and return
them with sqr execute.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is the Tux IPC Helper?
How do you regenerate PSTUXCFG after manually changing psappsrv.cfg?
How to refresh PeopleSoft security from one Instance to another?
What file created when you choose to create a domain in psadmin? From what order files is it created? Where is it located?
What is the difference between logging into Data Mover in bootstrap mode and logging-in in Regular Mode?
What is nVision Tab?
What are the client names when you execute a client status in psadmin?
Describe two SQR reports you can run to check the integrity of the database?
What is IVT?
Name the Tuxedo / Jolt Process and describe their functions?
What is Application Designer?
What does port 3050 resolve to as hexadecimal?
What do you ‘run’ the Database Wizard?
What is the difference between a Listener process and a Handler process?
What are the three logical sets of tables that make up a PeopleSoft database and what is the purpose of each?