PeopleSoft FAQs

On-break: On-break can only be used on string and column variables. We cannot use on-break with sqr numeric variables. To perform this, we must first move its value to a string variable & then set on-...

On-break is the important Command in SQR used to Control the redundancy of data..here SQR have different options for on-break...
1)After
2)before
3)never
4)always
5)change
6)change/top page

Above options are used with Group Headings and Footings

Move: To move the contents of one field to another field with optional editing

Let: To assign the values to the variable

the basic difference between move and let areMOVEthe move command can use the edit option and can easily have the masking move date1 date2 edit yyyy-mm-dd LETLet command is only used to assign values to the variablesLet var1=var2 or 5

Set control table default value is B.U. It contains record groups and its default value is setid. So it is used to access data from different B.U.

In App Designer, create a new Image object.  It will prompt you to select what image from your computer you want to upload.  Save the image so it gets saved to the database.  From there, you can use it as an image on an HTML page or as a command button image.

Using Image tool in the Application designer, We can upload images on the pages reuired.

The Data Mover is one kind of the File Transfer System it uses the fastest data transfering  and the data must transfer reliably and must redable. The data mover is also called as the storage router because it stores the backup of the data in our computer system.

Datamover used to take back up and buisness rule updation thru sql and security purpose.

SQR provided us with two types of Debugging
1) Normal Debugging - Using one character we will debug the program

Syntax:-

-DEBUG
2)Conditional Debugging - Here we will debug the program with two types

a) Display: one variable
b) Show: more than one variable

Integration Broker is used to Transfer the data,If client is using the peoplesoft only for HR and  client is having some X legacy systems which keeps Payroll data. to send the data between these ...

You can use SendMail function, you will get the sample code in peoplebooks

Standard Tables are system tables delivered by PS which starts with PS for ex: PSOPRDEFN
Non standard tables are application tables which starts with PS.for Ex PS_JOB

setup section

heading section

footing section

program section

procedure section

this is the structure and order of execution of SQR

we can use the following command line flag -printer:PD

The main difference between Show and Display commands is-with display command we can display only one variable (or) literal (or) column name at a time.But with show command we can display any number v...

Both show & display command use for Debuging purposes. In case of show command we can use variable literal & string.But incase of display command we can only use string & literal.

If u want to add char in sqr, you make use of declare-chart(in setup section) and Print chart(in program or procedure sections) commands.In those commands you can specify which type of chart you want(...

Its because the processer cant decide which action to do first.Both actions involves the transfer of control from one place to another place.

If we use call section and SQL actions simultaneously then database deadlock will occur. That is why we cannot use at the same time

No,we cannot call one SQR from other.

no we cannot call one sqr from an other sqr.instead u can call sqc's from sqr's