what is dynamic view?

Answer Posted / venkat

BY USING DYNAMIC VIEW WE CAN CHANGE OUR SQL QUERY
DYNAMICALLY AT RUNTIME BY USING SQLTEXT PROPERTY.SO WE CAN
GET DYNAMIC RESULTS ACCORDING TO OUR REQUIREMENT.

BUT IN SQL VIEW WE CAN NOT CHANGE THE SQL QUERY ONCE SAVED.
SO WE CAN GET STATIC RESULTS WHEN USING SQL VIEWS.

Is This Answer Correct ?    12 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is application package?

538


Can a PeopleTools 8.4 and a PeopleTools 8.1x application server run on the same machine?

1577


Tell me the use of set control field in record field properties?

497


Is WebSphere certified on PeopleTools 8.1x?

2011


How to give access to the records that are to be used in a query?

518






For the servlet layer on the web server, what version of the Java Servlet API are the PIA Java Servlets coded to with PeopleTools 8.4?

2425


Where do you write the peoplecode?

544


What is differed processing and its advantages?

572


In which events error & warning are used most extensively?

583


How the output of a sql query be stored in a variable using peoplecode?

509


What is html & image meta data?

522


What is application engine meta data?

533


What is the purpose of the sqlexec function? What are its benefits and draw backs?

490


What is page meta data?

484


Write the syntax to access third level record field using object oriented peoplecode?

584