Latest Answer: There are no required SQCs unless procedures (functions) are being used in the main program that require them. ...
Latest Answer: using call system command ...
Latest Answer: 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. ...
Latest Answer: (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 two fields, but by string
cancatnation we can select ...
Latest Answer: Search Record are use define the structure of dialog box , is also use to retrive and filter the data. ...
Latest Answer: Inner join: It is is the most common type of join. Inner joins return all rows from multiple tables where the join condition is met.Outerjoin: This type of join returns all rows from one table and only those rows from a secondary table where ...
Latest Answer: StatementFixed parameter valueExecute every timePrepared StatementCan supply parameter value at execution timeExecute once for ‘n’ parameter valueCallable StatementTo execute stored procedure like pl/sql ...
Latest Answer: 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. ...
Latest Answer: Yes. It is similar to use function, procedure and packages in SQR. The only difference is - Use begin-Sql Begin procedure(param1,param2) End End-Sql ...
View page << Previous 1 [2] 3 Next >>
Go Top
