-
What are the differences between move and let commands in SQR??
bandisdevi
- Sep 15th, 2009
Move: To move the contents of one field to another field with optional editingLet: To assign the values to the variable
kamal
- Feb 12th, 2007
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
-
What is SET CONTROL TABLE ?
pvkumar28
- Dec 9th, 2008
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.
-
Upload images in Peoplesoft
How to upload image in Peoplesoft database and present same image in output window?
elma_ae1
- Oct 1st, 2008
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.
yashwanth.chaitanya
- Jul 10th, 2008
Using Image tool in the Application designer, We can upload images on the pages reuired.
-
Data Mover questions.....where did you use etc?
cedt26
- Sep 6th, 2008
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.
Kannan
- Oct 4th, 2005
Datamover used to take back up and buisness rule updation thru sql and security purpose.
-
Conditional Debugging
Explain Conditional Debugging
sureshnelakurthi
- Aug 22nd, 2008
SQR provided us with two types of Debugging1) Normal Debugging - Using one character we will debug the programSyntax:--DEBUG2)Conditional Debugging - Here we will debug the program with two typesa) Display: one variableb) Show: more than one variable
-
Upgrade Process
What are all the steps invloved in Upgrade process?
senthildurga
- Aug 14th, 2008
• Plan the Upgrade • Prepare Copy of Production Database• Install New Release • Upgrade PeopleTools • Run and Review Compare Reports • Apply Application Changes • Co...
-
What is Integration Broker and how it is used in PeopleSoft?
Please give me answer
rajendert123
- May 9th, 2008
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 ...
-
Send emails using PeopleCode
How to send emails using PeopleCode
rajendert123
- May 9th, 2008
You can use SendMail function, you will get the sample code in peoplebooks
-
Standard Table and Non-Standard Table
What is the difference between Standard Table and Non-Standard Table
rajendert123
- May 9th, 2008
Standard Tables are system tables delivered by PS which starts with PS for ex: PSOPRDEFNNon standard tables are application tables which starts with PS.for Ex PS_JOB
-
What is the structure of an SQR program
venkat_leader
- Mar 17th, 2008
Setup sectionheading sectionfooting sectionprogram sectionprocedure sectionthis is the structure and order of execution of SQR
-
Generate PDF output using SQR
How to generate PDF output file in SQR using code?
-
What is the difference between show and display, explain with ex?
jayakrishna08
- Feb 27th, 2008
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...
harish_mahanta
- Mar 3rd, 2007
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.
-
How can we add Line, bar, pie, and other charts in the SQR reports?
jayakrishna08
- Feb 27th, 2008
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(...
-
Why call section and SQL are mutually exclusive in application engine
jayakrishna08
- Feb 27th, 2008
Its because the processer cant decide which action to do first.Both actions involves the transfer of control from one place to another place.
Madhusudan Reddy
- Nov 20th, 2007
If we use call section and SQL actions simultaneously then database deadlock will occur. That is why we cannot use at the same time
-
Can we call 1 sqr from another sqr? If Yes, How?
peoplesoft45
- Dec 14th, 2007
No we cannot call one sqr from an other sqr.instead u can call sqc's from sqr's
-
What is Activity TypeWhat is Cost Center.What is GAP Analysis. Explain with real time scenario
StanleyMorgan2007
- Nov 29th, 2007
Activity type is the nature of "action comitted or happened" and nature depends on the environment.The all value paid or bear is located in small center is called Cost Center.GAP Analysis is finding out the "Deficiency or gap" between ideal system or standard system and existing or current system.?
-
-
Is there any way to have access to the database of FINSYS8 AND HRSYS8 in a single application at one time
vcramachandran1979
- Jan 18th, 2007
Possible by opening two session from a single application whether it is sql-plus or db2 or sql-server
R Krishna Prasadh
- Aug 20th, 2006
Yes, but you need to have two different connections in your application. This is also known an Con-current connections, where in more than one connection, accessing a Server for different Databases.
-
How do you create a multi-select drop down list in peoplesoft?. I am new to this software and I have searched all moring on the net with no success...I did find the dynamic drop down list and a way to do it with visual basic.Thanks, Lucy
vcramachandran1979
- Jan 18th, 2007
Dont compare Visual Basic with Peoplesoft.visual Basc supports multiple select drop down box,but it is not supported in peoplesoft.Use drop down list
Peoplesoft Interview Questions
Sub Category
Questions
Answers
Last Updated
Ans