Sqr's
1. what is the purpose of multiple reports? In what situation u use this?
Ans.Multiple reports are mainly used to increase the performance of sqr program.This is used when we are generating different reports for the same source i.e; for same tables.
2. can u declare multiple heading sections in one sqr program?
Ans.Yes,we can declare multiple headings in the Multiple Reports.
3. what is the compile time variables?How to refer?
Ans.Ask variables are compile time variables.
4.What is run time variables?
Ans.Input variables are run time variables.
4. what is dynamic query variable?How to refer?
Ans.
5. What is sqc?what is the purpose of stdapi.sqc?
Ans.SQC’s are nothing but some functions in SQR.here, we have reusable code.by including those SQC’s and calling those functions in our SQR program we can get the functionality of that fu8nction.This is mainly used to make our SQR program API aware.ie; we can see the status of that SQR program in process monitor.
6. What are the steps to run an sqr program from people soft environment?
Ans.1.Make the program API aware.
2.Create run control table to pass variables in runtime,create a page,and component.
3.Schedule the program in process Scheduler
7. what are the debugging commands in sqr?
Ans.Show & Display are debugging commands
8. what is the difference between them?
Ans.Show is used to display more than one variable at a time.
Display is used to display only one variable at a time
9. what is load lookup?in what situations you use this technique?
Ans.Load lookup is like an array in C Language.This is mainly used to increase the performance of our program.Mainly used in Master Detail Reports where the number of rows are more in the table.
11.what are the steps in performance tuning?
Ans.Using Loadlookup & Arrays, Using Command line flags such as –bnn & -s, Using proper programming in our SQR program, Using Proper SQL in our SQR program, Using Multiple Reports, Using SQT files and Running on Batch Server.
12. What are the file manipulation commands in sqr?
Ans.Open,Close,For-Reading,For-Writing,For-Appending,Read & Write.
13. Is there any limitations to opening an file?
Ans.We can Open at a time a liited number of files that is 256
14. What are before and after procedures?How the execution sequence?
Ans.For group headings before and for group footings we use after .
15. I want to get previous value of on-break? what is the command?
Ans. Save command
16.How to identify document variables?
Ans.By seeing the Document Marker Symbol ie;@.
17.What is spf file?what are the flags exists to make a file to an spf?
Ans.The Output File after the compilation is SPF file.we can create it using ‘-Rs’ command line Flag and we can run it using ‘-RT’ command Line Flag.
18. How to refer a global variable in local procedure?
Ans.after special character (ex.#,&) we use underscore(_) after that variable name
19.How the output variable denotes in a local procedure?
Ans.
20.what is -Bnn flag?
Ans.This is used to specift the number of rows that are to be taken from Dbase to the Buffer because defaultly the system takes 10 rows at a time.
21.What is -Tnn flag?
Ans. This is mainly used for testing purpose. We can restrict the system to generate only a specific number of pages instead of generating all pages for testing. This is used in Windows Environment.
22. What is -RS & -RT Flags?
Ans.-RS is used to generate SPF file ie; stopping the program after the comilation. _RT is used to run the SPF file .This is also one kind of Performance increasing technique by saving the compilation time.
23. What are the sections in Sqr?which one is necessary?
Ans. Setup, Heading , Footing, Program & Procedure Sections. Program section is the Mandatory section.
24.What is -debug command line flag?
Ans.This is used for Debugging in SQR.
25. How to place an corporate logo in sqr?
Ans.Using “Declare Image” command
26. How to get most current effdt row & most effseq row?
Ans.
1. what is the purpose of multiple reports? In what situation u use this?
Ans.Multiple reports are mainly used to increase the performance of sqr program.This is used when we are generating different reports for the same source i.e; for same tables.
2. can u declare multiple heading sections in one sqr program?
Ans.Yes,we can declare multiple headings in the Multiple Reports.
3. what is the compile time variables?How to refer?
Ans.Ask variables are compile time variables.
4.What is run time variables?
Ans.Input variables are run time variables.
4. what is dynamic query variable?How to refer?
Ans.
5. What is sqc?what is the purpose of stdapi.sqc?
Ans.SQC’s are nothing but some functions in SQR.here, we have reusable code.by including those SQC’s and calling those functions in our SQR program we can get the functionality of that fu8nction.This is mainly used to make our SQR program API aware.ie; we can see the status of that SQR program in process monitor.
6. What are the steps to run an sqr program from people soft environment?
Ans.1.Make the program API aware.
2.Create run control table to pass variables in runtime,create a page,and component.
3.Schedule the program in process Scheduler
7. what are the debugging commands in sqr?
Ans.Show & Display are debugging commands
8. what is the difference between them?
Ans.Show is used to display more than one variable at a time.
Display is used to display only one variable at a time
9. what is load lookup?in what situations you use this technique?
Ans.Load lookup is like an array in C Language.This is mainly used to increase the performance of our program.Mainly used in Master Detail Reports where the number of rows are more in the table.
11.what are the steps in performance tuning?
Ans.Using Loadlookup & Arrays, Using Command line flags such as –bnn & -s, Using proper programming in our SQR program, Using Proper SQL in our SQR program, Using Multiple Reports, Using SQT files and Running on Batch Server.
12. What are the file manipulation commands in sqr?
Ans.Open,Close,For-Reading,For-Writing,For-Appending,Read & Write.
13. Is there any limitations to opening an file?
Ans.We can Open at a time a liited number of files that is 256
14. What are before and after procedures?How the execution sequence?
Ans.For group headings before and for group footings we use after .
15. I want to get previous value of on-break? what is the command?
Ans. Save command
16.How to identify document variables?
Ans.By seeing the Document Marker Symbol ie;@.
17.What is spf file?what are the flags exists to make a file to an spf?
Ans.The Output File after the compilation is SPF file.we can create it using ‘-Rs’ command line Flag and we can run it using ‘-RT’ command Line Flag.
18. How to refer a global variable in local procedure?
Ans.after special character (ex.#,&) we use underscore(_) after that variable name
19.How the output variable denotes in a local procedure?
Ans.
20.what is -Bnn flag?
Ans.This is used to specift the number of rows that are to be taken from Dbase to the Buffer because defaultly the system takes 10 rows at a time.
21.What is -Tnn flag?
Ans. This is mainly used for testing purpose. We can restrict the system to generate only a specific number of pages instead of generating all pages for testing. This is used in Windows Environment.
22. What is -RS & -RT Flags?
Ans.-RS is used to generate SPF file ie; stopping the program after the comilation. _RT is used to run the SPF file .This is also one kind of Performance increasing technique by saving the compilation time.
23. What are the sections in Sqr?which one is necessary?
Ans. Setup, Heading , Footing, Program & Procedure Sections. Program section is the Mandatory section.
24.What is -debug command line flag?
Ans.This is used for Debugging in SQR.
25. How to place an corporate logo in sqr?
Ans.Using “Declare Image” command
26. How to get most current effdt row & most effseq row?
Ans.
