SQR Interview Questions

PreparedStatement provides facility of parameterized queries while Statement does not.

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.

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

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

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

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

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

(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

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

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

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

 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

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)

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

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