Most common Format commands in SQR:CENTER: Center textEDIT: uses masks to control the format of the outputFILL: fills the specified length with characters specified.ON-BREAK: Allow you to specify an action/procedure in tabular reports when break occurs in the value of the field.BEGIN-SETUP includes following commands:Ask: Prompts the user for substitution variable.BEGIN-SQL: Begins an SQL paragraph.CREATE-ARRAY: Creates ...
June 17, 2005
Peoplesoft Technical Interview Questions & Answers
Posted by Dineshkumar R | ALL POSTS, PS Interview Questions,
1.Can we insert sub record into another subrecord?Ans:Yes,we can insert a Sub-record into another Sub-record.When a Sub-record definition is opened goto Insert and Sub-record.2.Difference between Save Prechange & Save Postchange?Ans: In Save Prechange we can get the data from Component Buffer for that particular Component where as in SavePost change Component Buffer is cleared we have to get data from Database and ...
June 16, 2005
Which of the following links are found in PeopleBook Customer Connection, Process Scheduler, People Code Language Reference Developer’s Portal, Query, Tree Manager Query, Process Scheduler, Application Engine None of the above All of the above Ans. e Which of the following two servers used by Process scheduler to run a process PSPRCSRV PSDSTSRV PSAESRV PSMSTPRCS None of the above All of the above Ans. Which of the following ...
June 16, 2005
Differences between State and temporary records?1. State record at any point of time has only single line information, as it's driven by the Process_Instance a skey field. While temp table can have multiple rows.2. State record had only single instance, while the temp table can have maximum of 99 instance.3. State record is used for restart logic.4. State record can be used for dynamically calling AE section, by adding ...
June 16, 2005
Sometimes you would like to hide fields from some users and not others. The only way that I know of is by creating a new role and assigns it to users who should not be seeing the fields.This is how to go about doing that:1. Create a role and add the users that should not see the fields to this role. The role doesn't have to have any permission list(s), although it could if you want to, it really doesn't matter for what ...
June 16, 2005
Why state records are needed?State records are used in Application engine development and customization. Basically they are used to pass the values(variables, database field) from from section to another section, from action to another action.Each application engine can have multiple state record but there will be only one default state record. It can be a SQL table or derived table. All state record ends with _AET.The ...
June 16, 2005
Function ImportSegment(&RS2 As Rowset)Local string &RecordName;Local Record &REC2;Local SQL &SQL1;Local integer &I;&SQL1 = CreateSQL("%Insert(:1)");&RecordName = "RECORD." | &RS2.DBRecordName;&REC2 = CreateRecord(@(&RecordName));For &I = 1 To &RS2.ActiveRowCount&RS2(&I).GetRecord(1).CopyFieldsTo(&REC2);&SQL1.Execute(&REC2);End-For;End-Function;rem *****************************************************************;rem ...
January 01, 2005
Very Good Day!,This is my first post in my blog, Hope you are busy with your daily work schedule and task, even in this busy schedule you've spent some time in reading my blog, first let me thank you for spending your $$$$ hours.Since this is my first post i want to make it short and crisp for the user. This Blog will have the LKG and the PhD in Peoplesoft, as i grow and learn stuff, this blog will grow and will in ...
