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 difference between a Listener process and a Handler process?
Does Tuxedo use psappsrv.cfg in text form to determine run-time parameters for the domain? If not, what does it use?
What is the Tux IPC Helper?
What is nVision Tab?
What is the difference between logging into Data Mover in bootstrap mode and logging-in in Regular Mode?
What ID is used to establish the initial connection to the database?
What is the importance of the queue status?
What is an Application Server Domain?
What is the order for installing the application, tools, and third party products?
What are the various documents you need to become familiar with prior to the installation?
What do you ‘run’ the Database Wizard?
You’ve manually edited the psappsrv.cfg file. Will the domain recognize the changes?
What must be installed prior to running the PeopleSoft installer?
What file created when you choose to create a domain in psadmin? From what order files is it created? Where is it located?
What areas of your organization need to be involved in the install process?