GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Peoplesoft  >  PeopleCode
Go To First  |  Previous Question  |  Next Question 
 PeopleCode  |  Question 23 of 30    Print  
what is a query view and dynamic view ?

  
Total Answers and Comments: 1 Last Update: June 08, 2008     Asked by: homealone363 
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: ksllavanya
 
Dynamic View:This is selected to define a record definition that can be used like a view in pages and PeopleCode,but is not actually stored as a SQL view in the database.Instead, the system uses the view text as a base for the SQL Select that is performed at runtime.

Query View:This is Selected to define the record definition as a view that is constructed using the PeopleSoft Query tool. Before you can create the view, PeopleSoft Application Designer prompts you to save the definition.

Above answer was rated as good by the following members:
kishore.kummr
June 08, 2008 23:44:23   #1  
ksllavanya Member Since: June 2008   Contribution: 3    

RE: what is a query view and dynamic view ?
Dynamic View:This is selected to define a record definition that can be used like a view in pages and PeopleCode but is not actually stored as a SQL view in the database.Instead the system uses the view text as a base for the SQL Select that is performed at runtime.

Query View:This is Selected to define the record definition as a view that is constructed using the PeopleSoft Query tool. Before you can create the view PeopleSoft Application Designer prompts you to save the definition.

 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 1Overall Rating: -N/A-    

 Related Questions

adv: no need to write query just want to build dis: we cant view queries 
Latest Answer : Also, SQLExec will open a new session on database, so if anything has been updated in Comp Buffer, will not be available in that session as COMMIT might not have happened. Also, if we have selected some value in Comp Buffer and then change the same after ...
Read Answers (7) | Asked by : ajith

Latest Answer : Dynamic View:This is selected to define a record definition that can be used like a view in pages and PeopleCode,but is not actually stored as a SQL view in the database.Instead, the system uses the view text as a base for the SQL Select that is performed ...
Read Answers (1) | Asked by : homealone363


 Sponsored Links

 
Related Articles

What is an Ad Hoc Query

An Ad-Hoc Query is a query that cannot be determined prior to the moment the query is issued. It is created in order to get information when need arises and it consists of dynamically constructed SQL which is usually constructed by desktop-resident query tools. This is in contrast to any query which
 

What is a view

A view is nothing but a window of an existing table by which one can view and can also change the values in tables. The main point aspect of view is views have no storage space. For this reason views are also called as virtual tables. Thus in other words a view is a database object that gives a logi
 

The Interview Snafu

How to turn someone else’s mistake to your advantage Your dream job is about to become reality. A recruiter gave you the heads up about the perfect position at Humungous Conglomerate, Inc. You went through five interviews as well as a battery of psychological tests mandated by their HR de
 

Winning a Job Interview with a Winning Resume

Does your resume unlock your potential, take your skills to the highest level and win you the interview and the job you want now? The job market today is highly competitive and even if you think you have what it takes to get an interview you won’t get over the line without a polished, prof
 

Importance of Proper English during Job Interview

Importance of Proper English during Job Interview Your job interview is crucially important and it will determine whether or not you will get the job Depending on the type of job you re going for it is very important for you to use proper English In most cases jobs which offer higher salaries will h
 

HR Interview - HR Interview Mistakes You Will Want To Avoid

HR Interview Mistakes You Will Want To Avoid The job interview can be a stressful process This is especially true for those who are going after a competitive position Your nonverbal communication combined with the answers you give during the interview will determine if you are hired mosgoogle While
 

HR Interview - Behavioral HR Interviews

Behavioral HR Interviews As the name implies a behavioral interview is an interview that is held by a human resources department to determine if an applicant has the behaviors that are appropriate for a job The company must know how an applicant will behave in a certain situations mosgoogle The logi
 

HR Interview - How To Prepare For Your HR Interview

How To Prepare For Your HR Interview Before you begin thinking about how you are going to dress for the interview it is important to do your research first You should learn everything you can about the company you wish to work for When you have detailed information about your employer you will conve
 

Structured Query Language (SQL) - Basic Concepts

Structured Query Language SQL Basic Concepts Having query about what a SQL is It is Structured Query language It is a non procedural language and it is a database language mosgoogle Categories in SQL commands There are 3 broad categories in SQL commands They are namely Data Definition language DDL
 

HR Interview - Telephone Interview Etiquette

Telephone Interview Etiquette When you conduct a telephone interview for a job it is important to show the proper etiquette Not only is it important it is critical is you wish to be hired by the company There are a number of things you will want to do and other things should never be done mosgoogle
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape