CI is a web core component based technology of peoplesoft. CI is nothing but the shadow of underlined component without pages. CI is mainly used in the case of validating the data (business logic) wit...
Narendar Reddy K.
Sep 15th, 2005
Component Interface(CI) is used to populate the data in component level automatically while we enter data and save in another component.
If data needs to be validated well before updating records and to make parent child records synchronous with respect to data, use AE/CI. When there is huge data to be manipulated, better use SQRs (run on server if possible).
Inner Join is the cartesian product of two or more tables.Its a join of two or more tables that returns only those rows that satisfy the join condition.Outer Join returns all rows that satisfy the joi...
Inner join: It is is the most common type of join. Inner joins return all rows from multiple tables where the join condition is met.Outerjoin: This type of join returns all rows from one t...
Sriram Kammisetty
Jan 17th, 2006
Inner join : An inner join (sometimes called a "simple join") is ajoin of two or more tables that returns only those rows that satisfy the join condition.Outer Joins : An outer join extends the r...
BI - Business Interlinks (Call from PS to Other application) . Using this technology , we can use/call other application business logic from PS. it's a depricated technology.PS recommends that not to ...
The major goals of Normalization are 1) Eliminating redundant data (for example, storing the same data in more than one table)?2) Ensuring data dependencies make sense (only storing related data in a table).
prashant
Sep 11th, 2007
Normalization is the process of strucuring the data in such a way that there should not be any redundancy of data
Search Record are use define the structure of dialog box , is also use to retrive and filter the data.
pradeep
Nov 19th, 2007
This is the example!! of SQC and SQRwrite procedure in a note pad and save it ex1.sqcbegin-procedure mainbegin-selectemplidnamefrom ps_personal_dataend-selectend-procedureafter that select new notpad and save ex2.sqr#include 'ex1.sqc'begin-programdo mainend-programrun the ex2.sqr file
These are the three important SQCs that should be attached to make ur SQR API aware#include 'setenv.sqc'#include 'stdapi.sqc'
jagadish
Sep 29th, 2006
#include 'setenv.sqc'#include 'stdapi.sqc'#include 'prcsdefn.sqc'#include 'prcsapi.sqc'#include 'curdttim.sqc'#include 'hrctlnld.sqc'#include 'datwtime.sqc'these are the some sqc's we r used in our sqr program
When SQR Program starts executing. There are two stages in the Program Flow.
1) Compile stage
2) Execution Stage
) Compile Stage.
All the Preprocessor directives are compiled ( which starts wit...
(1) Load-lookup:----------------------- 1) Load-lookup will be populated at compilation time 2) We can adjust the size of load-lookup 3)
It is only for text datatype 4) We can only select tw...
I think this example may help youbegin-heading 4print $current-date (1,1) Edit 'Mon-DD-YYYY'print 'EMPLID' (3,1)print 'COUNTRY' (,10)print 'STATE' (,17)print 'CITY' (,26)print '-' (4,1,9) fillprint '-...
Ans