bandisdevi

 Profile Answers by bandisdevi Questions by bandisdevi

• Oct 28th, 2009

Translate table: These values are stored on a people tools table called XLATTABLE. The field type should be character, length should be < or = 4, field values should be static. We can give more...

nsivudu

 Profile Answers by nsivudu Questions by nsivudu

• May 8th, 2008

Prompt Table are used to provide user's with validate values fromother tables, their values are generally populated by system users and are often application specificTrnslate Table is a special kind o...

Answer Question  Select Best Answer

Explain what are componentbuffer and databuffer?

bandisdevi

 Profile Answers by bandisdevi Questions by bandisdevi

• Oct 28th, 2009

Component buffer contains data of the currently active component. Data buffer contains the data of the currently active peoplesoft application, it can be from a component, an application engine or app...

tvrbala

 Profile Answers by tvrbala Questions by tvrbala

• Sep 26th, 2008

Component Buffer:  Component Buffer contains all the Data of active componentData Buffer: Data Buffer contains Data other then the Data in the Component BufferData Buffer classes are available in peopleocode, Rowset,Row,Record,Field,Array,Sql,File,chart,Drid and so on

Answer Question  Select Best Answer

Why levels are used in On-Break Logic.How does they work.Which lebel gets highest priority either level 1 or level 99.

bandisdevi

 Profile Answers by bandisdevi Questions by bandisdevi

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

sureshnelakurthi

 Profile Answers by sureshnelakurthi Questions by sureshnelakurthi

• 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)After2)before3)never4)always5)change6)change/top pageAbove options are used with Group Headings and Footings

Answer Question  Select Best Answer

bandisdevi

 Profile Answers by bandisdevi Questions by 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

Answer Question  Select Best Answer

pvkumar28

 Profile Answers by pvkumar28 Questions by 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.

Answer Question  Select Best Answer

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

elma_ae1

 Profile Answers by elma_ae1 Questions by 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

 Profile Answers by yashwanth.chaitanya Questions by yashwanth.chaitanya

• Jul 10th, 2008

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

Answer Question  Select Best Answer

cedt26

 Profile Answers by cedt26 Questions by 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.

Answer Question  Select Best Answer

Explain Conditional Debugging

sureshnelakurthi

 Profile Answers by sureshnelakurthi Questions by 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

Answer Question  Select Best Answer

What are all the steps invloved in Upgrade process?

senthildurga

 Profile Answers by senthildurga Questions by 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...

Answer Question  Select Best Answer

What is setsaveEdit?

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

Please give me answer

rajendert123

 Profile Answers by rajendert123 Questions by 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 ...

Answer Question  Select Best Answer

How to send emails using PeopleCode

rajendert123

 Profile Answers by rajendert123 Questions by rajendert123

• May 9th, 2008

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

Answer Question  Select Best Answer

What is the difference between Standard Table and Non-Standard Table

rajendert123

 Profile Answers by rajendert123 Questions by 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

Answer Question  Select Best Answer

venkat_leader

 Profile Answers by venkat_leader Questions by venkat_leader

• Mar 17th, 2008

Setup sectionheading sectionfooting sectionprogram sectionprocedure sectionthis is the structure and order of execution of SQR

Answer Question  Select Best Answer

How to generate PDF output file in SQR using code?

venkat_leader

 Profile Answers by venkat_leader Questions by venkat_leader

• Mar 17th, 2008

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

Answer Question  Select Best Answer

How to accept input dynamically using PSQuery?

jayakrishna08

 Profile Answers by jayakrishna08 Questions by 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

 Profile Answers by harish_mahanta Questions by 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.

Answer Question  Select Best Answer

jayakrishna08

 Profile Answers by jayakrishna08 Questions by 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(...

Answer Question  Select Best Answer

jayakrishna08

 Profile Answers by jayakrishna08 Questions by 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

Answer Question  Select Best Answer