GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Peoplesoft  >  PS Mixed
Go To First  |  Previous Question  |  Next Question 
 PS Mixed  |  Question 191 of 200    Print  
What are the limitations of PS query?

  
Total Answers and Comments: 4 Last Update: January 10, 2008     Asked by: SaiKr 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
May 06, 2007 10:51:29   #1  
h        

RE: What are the limitations of PS query?
You cannot use temp tables in PS query.
 
Is this answer useful? Yes | No
December 19, 2007 01:58:49   #2  
sharry Member Since: July 2007   Contribution: 5    

RE: What are the limitations of PS query?
The biggest disadvantage is that PS queries cannot be used to perform DML(update,insert,detele) operations. It can only fetch data(Select).
Further, as the use of temp table was mentioned in one of the answers, I will like to add - how many times our temp records have data in database, arent they cleaned before our prog ends......so y will we use temp tables in a select query.

 
Is this answer useful? Yes | No
January 10, 2008 08:58:02   #3  
mmtani Member Since: January 2008   Contribution: 2    

RE: What are the limitations of PS query?
Many more recent App Engine programs clear out the tao tables at the beginning, and leave the data in there at the end, so that you can use it (until another program instance picks up those tables and uses them) to debug.
 
Is this answer useful? Yes | No
January 10, 2008 09:04:04   #4  
sharry Member Since: July 2007   Contribution: 5    

RE: What are the limitations of PS query?
@ mmtani

You are absolutely correct in your statement, but leaving the temp table with data and clearing it before next use is not a good programming practice isint it.
This is the reason I wrote the above thing.

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape