Need to write the commit command after getting the values. After that we have to delete the values. So I need to write the commit command.
Difference between prepared statement and statement?
PreparedStatement provides facility of parameterized queries while Statement does not.
Statement Fixed parameter value Execute every time | Prepared Statement Can supply parameter value at execution time Execute once for n parameter value | Callable Statement To execute stored procedure like pl/sql |
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.
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.
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?
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...
Translate Table: Translate table is a special kind of table that is limited to validating data of four characters or less.The tr...
How will you create business units in peoplesoft finance and how will you use the same?
What is the main difference between SQR and app engine?
SetProcessing the major difference between Application Engine and SQR. There is no such facility in SQR which makes Application Engine a winner for data validations.
AE is very systematic as it is structured as Section, step and Action. While SQR is not systematic. AE flow is easy to read and understand, while SQR is not that easy. AE is easy to debug as you...
What are the validation is done in SQR program before loading in to the database?
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
Can we include setenv.Sqc at the end of the SQR program? If "no" then why?
No. Setenv needs to be at the top of the program in order for the program to use the environments specified.
Yes, we can include at the end of sqr program also
Can we call two procedures in on-break? If yes then how?
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 '-...
By using both after and before option in on-break.
Ex. on-break print = none before = procedure 1(arg1, arg2,....) after = precedure2
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...
.SQC is a Fuction Library file. It is lke a sub program is saved by extension .SQC and this program can be called in the SQR program.SQT is compile time/Run time file. When a file with XXX.SQR is...
What is difference between load look up and array?
(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...
good Answer Jiju
What is the program flow of SQR?
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...
setup section
heading section
footing section
program section
procedure section
What are the important sqc are need to be attached?
These are the three important SQCs that should be attached to make ur SQR API aware
#include 'setenv.sqc'
#include 'stdapi.sqc'
#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
How do you include sqcs in middle of the program? Is it possible ?
yes they can be included..using the conventional method we use to include SQC's
What is search record?How to create sqc? How to connect other application in component interface?
Search Record are use define the structure of dialog box , is also use to retrive and filter the data.
this is the example!! of SQC and SQR
write procedure in a note pad and save it ex1.sqc
begin-procedure main
begin-select
emplid
name
from ps_personal_data
end-select
end-procedure
after that select new notpad and save ex2.sqr
#include 'ex1.sqc'
begin-program
do main
end-program
run the ex2.sqr file
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).
Normalization is the process of strucuring the data in such a way that there should not be any redundancy of data
What are the compulsory sqc's that should be used in SQR program?
There are no required SQCs unless procedures (functions) are being used in the main program that require them.
and we also used sethdg01.sqc(Standard heading sqr include file), ptps1177.sqc (Printer & Page-size initialization useprntr.sqc (select printer type)
Experience in object oriented programme?
Object:An object is a software bundle of related state and behavior. A real world entity that you find in everyday life. &nbs...
How do you generate two output files from one SQR?
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.
using create report you can create multiple reports in one single SQR report