Thursday 15 November 2012

Creating a folder from SQR

Creating a folder from SQR

There are no system commands in SQR which allows creation of a folder. If a folder has to be created from a SQR then we can use call system to accomplish this.

Let us say if MyFolder is what needs to be created in 'C' drive then the Sample code to Create a folder from SQR is:

Let $folder = 'C:\MyFolder'
Let $cmd = 'mkdir ' $folder
call system using $cmd #status

Wednesday 7 November 2012

PeopleSoft: People Code for out_Bound for Parent & Child Table...

PeopleSoft: People Code for out_Bound for Parent & Child Table...: People Code for out_Bound for Parent & Child Tables   Parent Table as ' IS_DEPT_TBL ' (department no, name , location ) Child table a...

Tuesday 6 November 2012

people code questions



1) Where peoplecode get stored?
A) In Database Server(PSPCMPROG table)

2) Suppose if there is same component X in two different menus, menu1 and menu2 and if u want to assign a different search record for each menu, then which people code function do u use and where do u write the code?
A )  Instead of using PeopleCode, Directly we can assign the search record at the menu level which will override the search Record specified at the component level.

  3)        What is Component Processor?
  A)     The Component Processor is the PeopleTools runtime engine that controls processing of an application from the time that a user requests a component from an application menu until the database is updated and processing of the component is complete.

4) Explain How to send email to the all employeee from the peoplesoft application when a certain event is true? What is the event used to trigger?
A) Create a workflow. In the workflow, use a query with active employees and their email ids as inputs. On the successful occurrence of the event, trigger this workflow using TriggerBusinessEvent. 

5) Explain about component Buffer?

A) Component Buffer is the area in memory that stores data for the currently active component. 

6) Explain the advantage and disadvantage of sqlexe in peoplecode?

A) By using SQLExec function we can do the manipulation to the database. we can write insert, update, delete sql commands. But drawback while selecting the data using sqlexec, it will return only one at a time another drawback, if the name of the records changed, then you have to make the changes in the code as the query will in the quotes inside sqlexec 

7) Tell me Where can we write the peoplecode?

A)      
                               1.Record field level
                               2.Page people code
                               3.Component level people code
                               4.Component record people code
                               5.Component record field people code
                               6.menu item people code
                               7.Application engine people code
                               8.Component interface people code
                               9.Messaging people code
                             10.Application package people code 

 8)  Tell me Is there any function exist in peoplecode which stops the processing of whole component?

A) i think, it is "Error" Function. Use the Error function in FieldEdit or SaveEdit PeopleCode to stop whole processing and display an error message. It is distinct from Warning, which displays a warning message, but does not stop processing. Error is also used in RowDelete and RowSelect PeopleCode events. 

9) Tell me What is the difference between SQl Object and SQl Exec?

 

A) SQL Object is a peopletool definition which can be created using app designer as well as using peoplecode command CREATESQL( ) , it is mainly used for reuseablility of the sql statements. so whenever this statement is required no need to hard code, just create an sql object of the same and use where ever it is required.
sqlexec is a peoplesoft delivered function used to retrieve only one row and u can update multiple rows of data. It directly interacts with the database.

 

10) Tell me What is the diff between component level peoplecode and record level peoplecode?

A) Record Level peoplecode:
The peoplecode written on the Record level Peoplecode will affect all the Components in which that particular record is used.

Component Level Peoplecode:
The component level Peoplecode works only for that particular component and if any record in the component is referenced by component level peoplecode then it would not effect any other component where same record is used as it was doing in above case.
Sequence: first Record level peoplecode will fire and then Component level peoplecode.


11) Can you explain about component Buffer?

  A)  When you open any page in a component, the system retrieves all of the data records for the entire component and stores them in one set of record buffers, organized by scroll level and then by page level. This component buffer consists of rows of buffer fields that hold data for the various records that are associated with page controls, including the primary records; related display records, derived work records, and translate table records.
PeopleCode frequently must refer to data in the Component Buffer, that is, the area in memory that stores data for the currently active component.
There are two methods of specifying a piece of data in the Component Buffer from within PeopleCode:
-------- Contextual references, which refer to data relative to the location of the currently executing PeopleCode program.
-------- References using scroll path syntax, which provide a complete, or absolute, path through the Component Buffer to the referenced component.

The component buffer contain current active component data it is temporary memory area . 

12) what is the sequence of events fired when a page is saved.

A) SaveEdit,
    SavePreChange, 
   Workflow,
   SavePostChange

13) How to store output of sql query in a variable using peoplecode?
A) using SQLExec() function
        SQLExec(“select EMPLID, NAME from PS_PERSONAL_DATA”, &emplid,&name);

14)what is an array in people code?
A) An Array is a collection of data storage locations, each of which holds the same type of data.
    The maximum depth of a peoplecode array is 15 dimensions. Push and UnShift are the functions of    the array used to add the elements into the array one from the end of the array and one from the    beginning. Pop is a function of array used to select and delete an element  from the end of the array.