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 logging into Data Mover in bootstrap mode and logging-in in Regular Mode?
What areas of your organization need to be involved in the install process?
What file created when you choose to create a domain in psadmin? From what order files is it created? Where is it located?
What Web Service software is currently supported in PeopleSoft 8.4?
What is the difference between the 7.5X Vs 8X security?
What do you ‘run’ the Database Wizard?
You configure and boot the domain from the command line. Why did more processes than expected start when the domain was booted?
What is the difference between a Listener process and a Handler process?
You Migrate some page changes from development to test environment but still the user complaints the changes are still not reflected in the test environment. What could be the problem and how will you resolve it?
Describe two SQR reports you can run to check the integrity of the database?
What is PeopleSoft Internet E-Business?
You want to change a Application Server name and the WebServer which file will you modify and where?
When is the psappsrv.ubb file created and how is it used?
What are the three logical sets of tables that make up a PeopleSoft database and what is the purpose of each?
What other files are copied to this directory? What is the purpose of each?