Shruti

• Jul 27th, 2017

SQR is not an application designer object but APP ENGINE is an Application designer object

Tej Bhaskar

• Jun 24th, 2015

You can generate Reports in AE.

Answer Question  Select Best Answer

If we will write an update statement in SqlExec , whether it will update all rows or single row satisfying the where condition?

Reddy

• Apr 28th, 2016

It will update multiple rows at a time. While retrieving data it will retrieve single row at a time.

John

• Aug 28th, 2015

None...SQLEXEC is a function of peoplecode not SQR. Read the thread title people!

Answer Question  Select Best Answer

In how many formats u can print a sqr report using only one instance of the sqr program???

lakshmi

• Apr 20th, 2015

One

RAMYA.S

• Feb 18th, 2015

One

Answer Question  Select Best Answer

How will you create Business Units in PeopleSoft Finance and how will you use the same?

srinivas

• May 15th, 2014

Its a logical unit for organisations

Answer Question  Select Best Answer

bandisdevi

 Profile Answers by bandisdevi Questions by bandisdevi

• Dec 10th, 2012

SQT : Runtime file

SQC i: Library file - it contains commonly included procedures that are called by other SQR programs

Devang Shah

 Profile Answers by Devang Shah Questions by Devang Shah

• Apr 6th, 2009

sqc are the files which can be considered as header file which can be included in the header file simillar to c when we include header filesqt ::  we can have command line parameter for  the...

Answer Question  Select Best Answer

rkrajnishraj

 Profile Answers by rkrajnishraj Questions by rkrajnishraj

• Jan 17th, 2011

PreparedStatement provides facility of parameterized queries while Statement does not.P.S is pre-compiled while Statement is not hence Statement is compiled everytime for each query request.Statement is fast then P.S?

Rajasekar

• Nov 21st, 2006

StatementFixed parameter valueExecute every timePrepared StatementCan supply parameter value at execution timeExecute once for ?n? parameter valueCallable StatementTo execute stored procedure like pl/sql

Answer Question  Select Best Answer

bandisdevi

 Profile Answers by bandisdevi Questions by bandisdevi

• Nov 16th, 2010

Simplify complex select statements.We can use load-lookup to simplify joins.Use dynamic sql instead of a condition in a select statement.One program can create multiple reports simultaneously.We can save compiled programs and return them with sqr execute.

sandeep

• Apr 4th, 2007

For performance tuning in SQR first we need to tune up the sql,use appropriate joins with nessasary conditions.Then use nessasary functions for low execution time and use temp tables for bulk data transactions.

Answer Question  Select Best Answer

Explain the difference between Translate & Prompt tables. What are the occasions when to use Translate values instead of Prompt table? What is the advantage of one over the other?

bandisdevi

 Profile Answers by bandisdevi Questions by bandisdevi

• Oct 12th, 2010

Translate table 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 than o...

nagururisivanandareddy

 Profile Answers by nagururisivanandareddy Questions by nagururisivanandareddy

• Mar 14th, 2008

Translate Table:            Translate table is a special kind of table that is limited to  validating data of four characters or less.The tr...

Answer Question  Select Best Answer

What are the validation is done in SQR program before loading in to the database?

SreejaSasidharan

 Profile Answers by SreejaSasidharan Questions by SreejaSasidharan

• Jul 20th, 2010

No specific validations will be carried out by SQR before loading the data into the database except:1. Any specific validations code written by the programmer.2. Table edits - for example, if the field in the record is number and you try to insert character, it will throw error.SS

Answer Question  Select Best Answer

Can we include SETENV.SQC at the end of the SQR program? If "NO" then why?

SickCowPie

 Profile Answers by SickCowPie Questions by SickCowPie

• May 11th, 2010

No.  Setenv needs to be at the top of the program in order for the program to use the environments specified.

sumeet9888

 Profile Answers by sumeet9888 Questions by sumeet9888

• Jul 20th, 2009

Yes, we can include at the end of sqr program also

Answer Question  Select Best Answer

shyampeoplesoft

 Profile Answers by shyampeoplesoft Questions by shyampeoplesoft

• Sep 23rd, 2009

I think this example may help youbegin-heading 4print $current-date (1,1) Edit 'Mon-DD-YYYY'print 'EMPLID' (3,1)print 'COUNTRY' (,10)print 'STATE' (,17)print 'CITY' (,26)print '-' (4,1,9) fillprint '-...

freakydipu

 Profile Answers by freakydipu Questions by freakydipu

• Dec 26th, 2007

By using both after and before option in on-break.Ex. on-break  print = none before = procedure 1(arg1, arg2,....) after = precedure2

Answer Question  Select Best Answer

facinater

 Profile Answers by facinater Questions by facinater

• Aug 20th, 2008

(1) Load-lookup:----------------------- 1) Load-lookup will be populated at compilation time 2) We can adjust the size of load-lookup 3) It is only for text datatype 4) We can only select tw...

Bhaskar Boddupally

• Jul 14th, 2006

Good Answer Jiju

Answer Question  Select Best Answer

What is the program flow of SQR?

sandeep05

 Profile Answers by sandeep05 Questions by sandeep05

• Aug 12th, 2008

When SQR Program starts executing. There are two stages in the Program Flow. 1) Compile stage 2) Execution Stage ) Compile Stage. All the Preprocessor directives are compiled ( which starts wit...

venkat_leader

 Profile Answers by venkat_leader Questions by venkat_leader

• Mar 17th, 2008

Setup sectionheading sectionfooting sectionprogram sectionprocedure section

Answer Question  Select Best Answer

jayakrishna08

 Profile Answers by jayakrishna08 Questions by jayakrishna08

• Feb 27th, 2008

These are the three important SQCs that should be attached to make ur SQR API aware#include 'setenv.sqc'#include 'stdapi.sqc'

jagadish

• Sep 29th, 2006

 #include 'setenv.sqc'#include 'stdapi.sqc'#include 'prcsdefn.sqc'#include 'prcsapi.sqc'#include 'curdttim.sqc'#include 'hrctlnld.sqc'#include 'datwtime.sqc'these are the some sqc's we r used in our sqr program

Answer Question  Select Best Answer

sharry

 Profile Answers by sharry Questions by sharry

• Dec 13th, 2007

Yes they can be included..using the conventional method we use to include SQC's

Answer Question  Select Best Answer

rahul_96k

 Profile Answers by rahul_96k Questions by rahul_96k

• Dec 7th, 2007

 Search Record are use define the structure of dialog box , is also use to retrive and filter the data.

pradeep

• Nov 19th, 2007

This is the example!! of SQC and SQRwrite procedure in a note pad and save it ex1.sqcbegin-procedure mainbegin-selectemplidnamefrom ps_personal_dataend-selectend-procedureafter that select new notpad and save ex2.sqr#include 'ex1.sqc'begin-programdo mainend-programrun the ex2.sqr file

Answer Question  Select Best Answer

Muralikrishna Anugu

• Oct 2nd, 2007

The major goals of Normalization are 1) Eliminating redundant data (for example, storing the same data in more than one table)?2) Ensuring data dependencies make sense (only storing related data in a table).

prashant

• Sep 11th, 2007

Normalization is the process of strucuring the data in such a way that there should not be any redundancy of data

Answer Question  Select Best Answer

DMilbo

• Jun 11th, 2007

There are no required SQCs unless procedures (functions) are being used in the main program that require them.

MOHAN

• Oct 6th, 2006

And we also used sethdg01.sqc(Standard heading sqr include file), ptps1177.sqc (Printer & Page-size initialization useprntr.sqc (select printer type)

Answer Question  Select Best Answer

Harish Mahanta

• Nov 9th, 2006

Object:An object is a software bundle of related state and behavior. A real world entity that you find in everyday life.           &nbs...

Answer Question  Select Best Answer

Nataraj

• Nov 8th, 2006

For Reports you can use-report to generate mutiple reports.For reading and writing data to files we have SQR commands like For-read and For-write.

vardhan

• May 12th, 2006

using create report you can create multiple reports in one single SQR report

Answer Question  Select Best Answer