GeekInterview.com
Series: Subject:

PeopleSoft FAQs

Showing Questions 21 - 40 of 50 Questions
First | Prev | | Next | Last Page
Sort by: 
 | 

Levels in on-break in SQR

Asked By: anil bingumalla | Asked On: Jan 25th, 2008

Why levels are used in on-break logic.How does they work.Which lebel gets highest priority EIther level 1 or level 99.

Answered by: bandisdevi on: Oct 25th, 2009

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-...

Answered by: sureshnelakurthi on: Aug 22nd, 2008

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

What are the differences between move and let commands in SQR??

Asked By: krisvamsi2005 | Asked On: Nov 20th, 2006

Answered by: bandisdevi on: Sep 15th, 2009

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

Let: To assign the values to the variable

Answered by: kamal on: 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

Change prompt table

Asked By: misha2m | Asked On: Mar 12th, 2009

How to change prompt table with edit to prompt table with no edit dynamically using peoplecode?

What is set control table ?

Asked By: rameshraju6 | Asked On: Dec 9th, 2007

Answered by: pvkumar28 on: 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

Asked By: govardhan508 | Asked On: Jun 7th, 2008

How to upload image in peoplesoft database and present same image in output window?

Answered by: elma_ae1 on: 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.

Answered by: yashwanth.chaitanya on: 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?

Asked By: Interview Candidate | Asked On: Jul 20th, 2005

Answered by: cedt26 on: 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.

Answered by: Kannan on: Oct 4th, 2005

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

Conditional debugging

Asked By: bandisdevi | Asked On: Apr 15th, 2008

Explain conditional debugging

Answered by: sureshnelakurthi on: Aug 22nd, 2008

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

Setsaveedit

Asked By: balanps | Asked On: Aug 6th, 2008

What is setsaveedit?

Stop SQR at runtime

Asked By: rajesh.t | Asked On: Jul 31st, 2008

How can you stop SQR for 2 min. At runtime?

What is integration broker and how it is used in peoplesoft?

Asked By: Kiran | Asked On: Jun 7th, 2007

Please give me answer

Answered by: rajendert123 on: 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

Asked By: madhu.ps16 | Asked On: Dec 25th, 2007

How to send emails using peoplecode

Answered by: rajendert123 on: May 9th, 2008

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

Standard table and non-standard table

Asked By: venkat_leader | Asked On: Mar 12th, 2008

What is the difference between standard table and non-standard table

Answered by: rajendert123 on: May 9th, 2008

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

What is the structure of an SQR program

Asked By: gnana | Asked On: Apr 25th, 2007

Answered by: venkat_leader on: Mar 16th, 2008

setup section

heading section

footing section

program section

procedure section

this is the structure and order of execution of SQR

Generate pdf output using SQR

Asked By: jayakrishna08 | Asked On: Mar 8th, 2008

How to generate pdf output file in SQR using code?

Answered by: venkat_leader on: Mar 16th, 2008

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

Dynamic input using psquery

Asked By: jayakrishna08 | Asked On: Mar 8th, 2008

How to accept input dynamically using psquery?

What is the difference between show and display, explain with ex?

Asked By: srirekha | Asked On: Mar 2nd, 2007

Answered by: jayakrishna08 on: 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...

Answered by: harish_mahanta on: 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?

Asked By: Devadatta | Asked On: Sep 10th, 2007

Answered by: jayakrishna08 on: 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

Asked By: Narendranatha Reddy | Asked On: May 31st, 2007

Answered by: jayakrishna08 on: 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.

Answered by: Madhusudan Reddy on: 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?

Asked By: lakshmi | Asked On: Nov 22nd, 2007

Answered by: jayakrishna08 on: Feb 27th, 2008

No,we cannot call one SQR from other.

Answered by: peoplesoft45 on: Dec 14th, 2007

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

Post the vochure

Asked By: balachander | Asked On: Jan 7th, 2008

How and where to post the vochure in peoplesoft

First | Prev | | Next | Last Page

 

 

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Ads

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.