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

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

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

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

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

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

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

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