difference between temporary table and sql view in peoplesoft
Latest Answer: Temporary Table: Temporary tables are used for running PeopleSoft Application Engine batch processes. Temporary tables can store specific data to update without risking the main application table.
SQL View: It is not a physical SQL table in the database, ...
i want to store the output of a query say select EMPLID from Job;the output of this column should be stored in a variable. how it can be done?
Latest Answer: You can use SQLExec to do the same.SQLExec("SELECT EMPLID FROM JOB",&Emplid);The value of EMPLID gets stored in the variable &Emplid. ...
What is meant by application package?
Latest Answer: Application Package is Used to create Application Classes, which could be used to either extend the functionality of existing PeopleTools classes (Rowset, Array, and so on) or to create your own classes. ...
Latest Answer: 1. Main is the required section in Application Engine.
2. There can be multiple steps in single application engine, but atleast one step should be part of AE.
3. Similarly you can have multiple actions in AE but you should have minimum 1 action part ...
Is this possible.. If yes, Please explain
Latest Answer: it is not possible normaly.. but u can write a people code by which u can insert the field data into the records ...
Latest Answer: Temporary table: To allow other users to access the same table that has been using by the AE program. These are mainly used in batch processing. These can store specific data to update without affecting the main application table. This is a database ...
Latest Answer: Indexing tables on the database side helps in batch processing a great deal. Analysing tables helps. If there is custom code, make sure the SQL queries used are written well with the use of proper keys and joins are correct as well. ...
Latest Answer: Peopletools: windows, Unix (Red Hat, SLES)Database: Oracle, SqlServer, DB2PIA: IE 5.0 or greater ...
View page [1] 2 3 4 Next >>
Go Top
