1.Can we insert sub record into another subrecord?
Ans:Yes,we can insert a Sub-record into another Sub-record.When a Sub-record definition is opened goto Insert and Sub-record.
2.Difference between Save Prechange & Save Postchange?
Ans: In Save Prechange we can get the data from Component Buffer for that particular Component where as in SavePost change Component Buffer is cleared we have to get data from Database and this is used to update values outside the database.
3.What is naming convention of SQR program?
Ans:The program must End with ‘.SQR’ extension and the length of name must be <=8 characters.
4.Can we run SQR program through a push button from a page? Ans: Yes we can run using properties of Push Button. That are Specifying Destination = Process Process Type = SQR Report and Name = SQR report name.
5.Order of Execution of Deferred processing? Ans: This is similar to Interactive Processing where as in this Field Change, Field Edit Peoplecode events & System edits will be differed until we press the Save Button.
6.What are Data Buffer Classes in Peoplesoft? Ans: There are totally 4 Data Buffer Classes in Peoplesoft. They are 1.Row Class 3.Field Class 2.Rowset Class 4.Record Class.
7.Define Signon Process?
8.What are Different Functions in PeopleCode?
Ans: There Are Totally 4 types of Functions in Peoplecode. They are 1.BuiltinFunctions 2.Internal Peoplecode Functions
3.External Peoplecode Functions & 4.External Non-Peoplecode functions
9.Does Save Edit & Save Prechange Are in Component Level or Comp[onent Record Level?
Ans: These are available in Component Level.
10.What are Heading And Footing SQC’s?
Ans: These SQC’s are useful for Heading & Footing Sections of an Report. One of the important Footing SQC is ‘RESET.SQC’ . Some of Heading SQC’s are some “PATxxHDG.SQC’.
11.What is Application Messaging?
Ans: This is mainly used to publish or subscribe Messages to other Systems . This is kind of communication as per my knowledge.
12.Where and when do we use SQR?
Ans: 1.Where the Programing logic is more.
2.If We need to Generate different kinds of reports.
3.Background SQL processing.
4.File Interfacing. Etc…
13.People Code Event sequence Execution
Ans: 1.Search Init
2.Search Save
3.Row Select
4.Prebuild
5.Field Default
6.Field Formula
7.Row Init
8.Postbuild
9.Activate
10.Field Edit
11.Field Change
12.Row Insert
13.Row Delete
14.Save Edit
15.SavePrechange
16.Work Flow
17.SavePostchange
14.Steps for Running SQR in PeopleSoft Environment?
Ans: There are mailnly 3 steps for running SQR in PeopleSoft Environment.
1. Making our SQR program API aware.
2. Creating Run Control Table and Run Control Page (Using PRCSRUNCNTL_SBP subpage). 3. Scheduling our program in Process Scheduler. (PATH: Peopletools -> Process Scheduler -> Processes).
15.How to change the prompt table Dynamically?
Ans: Using PeopleCode function “%Edit Table”.
16. How do you perform People Code Debugging?
Ans:1.First we have to set the Debugger mode by selecting “Enter Debugger Mode” in “Debugg” menu in the ApplicationDesigner.
2.Next we have find which variables we need to Debugg,this we can do by selecting local,component or Global variables from the “Debugg ” menu.
3.Next we have to set the BreakPoints using “Toggle Break at Cursor” or “Break Point at Start” from the menu items of the “Debug” menu
17.How do you conect to Client Database?
Ans: Using VPN (Virtual Protocol Network) Protocol. In our company we use ‘Cytrix’ or ‘Terminal Software’ Softwares.
18. What is PS Enterprize Portal?
19.What is Effective Date?
Ans: This is an important Concept for an ERP using this we can enter more than one values to row for the same key fields depending on date. Here we can maintain History, Current & future rows. We can also maintain more number of rows for same effective date using Effective Sequence. This concept is minly used in most of the Control Tables.
20.What is SETID & BUSINESSUNIT?
Ans: These are two high level key fields for Control tables & Transaction Tables respectively. These fields play a vital role in Peoplesioft.
21.How to build customer indexes?
Ans; By using Key fields & Alternate search key we can create system indexes. Where as we can create User defined indexes using App. Designer. Path is: In menus Tools -> Data Administration -> create indexes.
22.What are types of instances in which you are working?
Ans: In our company we have Development & Tesing Instances of databases. I worked on Development Instance.
23.How do you interact with client and how do you deliver output to client?
Ans:
24.Current Version working?
Ans; I am presently working on Tools 8.42 & HRMS Application 8.8 .
25 Purpose of Upgrade Tab?
Ans: This is mainly used for version upgradation.
26.How do you send project to client and How do you test the project?
27.How to Debug AE program and Ways of running AE Program?
28.Which Server do you use & What are the views purposes and different between Search Views & Fast Views?
29.How do you solve Bugs?
Ans: Using Debugging Techniques and Messaging in that particular area.
30.Difference between Query Views & Dynamic Views?
Ans: 1.Query Views are designed using Query Manager Tool where as we write SQL in Dynamic Views.
2.Query View is Built and Exists in the Database where as Dynamic View can’t be build so it doesnot exists in Database.
31.How work will be assigned in Production Envoronment?
Ans: Actually I don’t know because I am in Development Environment.
32.How do you assign Search Record to Component?
Ans: By going to the component properties , Use Tab and Specifying the search record in that particular area ie; ‘Add Search Record’ Property.
33.How do you move data from legacy system to Peoplesoft?
Ans: We can use some Integration Tools such as Component Interface, File Layout & Integration Broker and alse using Flat files in SQR. We have some specific commands in Flat files handking in SQR such as OPEN, CLOSE, FOR WRITING, FOR READNG & FOR APPENDING, WRITE and Finally READ commands.
34. Interaction with client?
35. What is your Team size?
36.Say about your team?
37.What is your Role in the Current Project?
38.How will be the interaction with the Team Leader?
39.How do you open a file?
Ans: In SQR the Syntax is OPEN ‘filepath’ AS number FOR READING/FOR-WRITING/FOR-APPENDING…
40.Can we use multiple printers in SQR?
Ans: Yes we can use. In SETUP section By Defining printers what we need . we have some SQC’s.
41.What are the variables used in peoplecode?
Ans: System Variables, User Defined Variables. & Derived Work record Fields
42.How can we Know whether we are in a particular mode?
Ans: Using ‘%Mode’ Built in function.
43.How to Execute App.Engine Program?
44.What are Record Types?
Ans: There are totally 7 Record Types. They are
1.SQL Table. 5.Query View
2.SQL View 6.Subrecord
3.Derived/work Record 7.Temporary Table.
4.Dynamic View
45.Difference between Interface, Report & Process?
Ans: Interface: This is used to interact with other system may be PS or Legacy Syatem
Report: This has an user interaction to execute or generate.
Process: This is Scheduled in Batch Server so ther is no need for the user to especially run it. It Automatically Executes.
46.What is State Record?
Ans: These are Used in Application Engine Programs to pass values between Actions & Sections.
47.How many actions are there in App. Engine?
Ans: There are Totally 9 Actions. They are
1.Do When 4.Do Select 7.SQL
2.Do While 5.People Code 8.Log Messages
3.Do Untill 6.Call Section 9.XLAT
48.Difference between Do Select & Do When?
Ans: Do Select is like FOR Loop in C. How many rows it retrives that many times it performs the Do When & SQl actions below it. Where as Do When is like a condition operator such as IF statement in C.
49.Pupose of App. Engine?
Ans: 1.Backgroung SQL processing.
2.To pass data between Modules.
3.To pass data between Databases.
4.To populate Reporting tables using data in Transaction Tables.
5.For integration purpose.
6.Validation of data
7.Data Manipulations.
8.For Version Up gradation.
9.Archive Data .Etc….
50.Performance Tuning in SQR?
Ans: 1.Using LOAD-LOOKUP & LOOKUP.
2.Using ARRAYS.
3.Multiple Reports.
4.Using –S & -Bnn.
5.Using SQT file.
6.Running on Batch Server.
7.Using Proper programming logic in sQR such as BREAK statement in Evaluate.
8.Using proper SQL Statements.
51.File types in SQR?
Ans:1. “.SQR”=This is nothing but the SQR source file.
2. “.SQC”=This is a used as functional Libraries.
3. “.Lis”=This is Line Printer Output file.
4. “.SPF”=This is a Portable format file.
5. “.SQT”=This is Complied time file.
6. “.INI”=These files are used to set the default Environment for our SQR Report.
7. “.MAX”=These are used to increase the memory size.
8. “.ERR,.LOG,.DAT”=These are used for Error Handling purpose.
52.List Out some CommandLine Flags in SQR?
Ans:-S,-A,-KEEP,-ZIV,-XMB,-ZMF,-E,-O,-Debug,-RS,-RT etc…
53.Purpose of the Arguments in the LOAD-LOOKUP?
Ans:To Create a Load-Lookup array as per requirement in the arguments.
54.Commands in the File-Handling?
Ans:1.Open for-Reading
For-Writing
For-Appeding.
2.Close
3.Read
4.Write
55.Diff between ASK & INPUT Commands?
Ans:”ASK”
1.This is used in the Setup section i.e . Compile Time Variable.
2.This prompts for the values during the compilation time.
3.This does not have the datatype and length.
“INPUT”
1.This can be used in other than the Setup section i.e. Run tTime Variable
2.This prompts for the values during the Execution Time.
3.Here,we can specify the datatype and the length.
56.Debugging in SQR?
Ans: Using Debugging commands we can do debugging in SQR.They are
1.Display(to display only one variable)
` 2.Show(to display more than one variable)
3.#IF Debug
#END-IF
57.Effdt and EffSeq Quries?
Ans:Select * from Table1 A where A.EffDt= (Select Max (B.EffDt) from Table1 B where A.keys B.keys AND A.EffDt<= as of Date)
Select * from Table1 A where A.EffDt= (Select Max (B.EffDt from Table1 B where A.keys B.keys AND A.EffDt<= as of Date AND B.EffSeq=(Select Max(C.EffSeq from Table1 C where B.keys=C.keys AND B.EffDt=C.EffDt AND B.EffSeq=C.EffSeq)
58What is SQC , List out some of them?
Ans: SQC is used as Functional Library mainly used to re-use code and get some predefined functionalities used for our SQR programs.
Some of the Important SQC are STDAPI.SQC,SETENV.SQC,RESET.SQC,SETUPxx.SQC,NUMBER.SQC,STRING.SQC,DATETIME.SQC etc..
59.What is ProcessScheduler?
Ans: This is a Peopletool used to Schedule and monitor the Execution of any Process or Report or Program in Peoplesoft Environment.
62.What is Scroll Area ? How many can we keep on a Page?
Ans: Scroll Area is a Page Control which contains Child Records’-Fields which is used to maintain the Parent-Child Relationship between Tables. We can place any number of scroll areas on a page.
63.Duration of the Project?
64.What is DataMover?
Ans: DataMover is a Peopletool which is used to move Data between different DataBases.
65.Diff between Migration , Import and Export?
66.What are Upgrade Instances of Databases?.
67.To Whom you will Report ? Who Will give Specification to you?
68.Why you are Leaving Current Organization?
69.Where is the Location of the Current Organization?
70.Can we send SQR Output to Ms-Word or Crystal Reports?
Ans: Yes.
71.How do we refer Component Buffer in the Object-Based or Procedural-Based PeopleCode?
Ans:In Procedural Based Peoplecode by using scrollpath we can refer. In Object-Oriented Peoplecode by Instantiating Objects to Record , Row , Row Set ,Field we can refer the Component Buffer.
72.Limitaion of SQL Exec function in Peoplecode?
Ans:1.Used in only SavePrechange , WorkFlow , SavePostchange, and for DML commands and for Select statements used other Event types.
2.Results only one Single row of data.
73.What is the StateRecord?
Ans: State Record is used to pass values between Sections.
74.What are the Actions available in the AE Program?
75.How will you read Data from the CSV file or Excel file and Upload it into the Database using AE Progrm?
Ans: Using File Layout Integration Tool.
76.Why are SQC files used in SQR?
77.Which SQC is used to read Data from the Translate table?
Ans: ReadXlat.SQC
79.How will get the SystemDate in Oracle?
Ans:
80.Effective Date Event in SQR?
81.What is a Sub-Query? Why it is used?
82.Why is Load-Lookup used in SQR?
Ans: Used to increase the performance mainly in the case of Master Detail Reports.
83.Why are Field Edit and Field Change Events Used?
Ans:
84.Why is Save Edit Event Used?
85.Why is SQLExec function is used and how many rows you can retrive using it?
Ans:This is mainly used to Directly access the Database by-passing the ComponentBuffer.
86.What is a Sub-Page? Why it is used?
Ans:Sub-Page is a Page control which is mainly used to insert Sub-Records.
87.Why is Derived Work record used?
Ans:DerivedWork record is mainly used for the Online page calculations and also used as Functional Libraries in PeopleCode.
91.How will you delete the button [Add,Update/Display,Update/DisplayAll and Correction] from a Page on the Browser?
Ans:By going to the Internet tab of the Component properties in the App.Designer and disabling the checkboxes as per our requirements.
93.Diff between the User-Profiles,Roles and the Permission Lists?
Ans:
94.What is the Diff between the Prompt Table and the Translate Table?
Ans:
95.What is the Purpose of the State-Record?
96.What is the diff between the Local and the Component Variables in the PeopleCode?
Ans:Local variable scope is upto that particular program where as the Component variable scope is upto the particular Component.
97.What are the Steps in the Implementation?
98.What are the types of the Table Joins?
Ans:1.Self Join
2.Cartesian Join
3.EquiJoin
4.OuterJoin
5.Inner Join
99.How many Objects are there in the PeopleSoft 7.5, 8.1.2 & 8.4.2?
100.How many Events are there in the PeopleCode,When do they get Fired?
101.What is the Architecture of the PIA? What are its Components?
102. How will you read Data from the CSV file or Excel file and Upload it into the
Database using SQR?
Ans:Using File-Handling and Unstring Commands.
103.Why is On-Break used?
Ans:1.To reduce the Redundancy of Printing the data.
2.For Group-Footing and Group-Headings.
104.Why is the Process Definition in Process Scheduler used and What are the options available in it?
105.What are the Object Classes available in the PeopleCode?
Ans:1.Field Class 2.Row Class 3.Record Class
4.Rowset Class 5.File Class 6.Array Class
7.SQL Class 8.Page Class 9.AE Class
10.Application Class 11.Component Interface Class
12.Bussiness Interlink Class 13.Grid Class 14.Query Class
15.Java Class
107.Diff between Update/Display,UpdateAll and the Correction modes?
Ans:
108.How will you display an Image in SQR?
Ans:Using Declare-Image Command.
109.Which Sql Commands can be used in the SQL-Paragraph?
Ans:Except Select command We can use DDL,DMLand DCL.
110.In which section Select Paragrarph Statement be used?
Ans:In the Setup,Program and the Procedure sections we can use the Select Paragraphs.
111.What is Effdt and the EffSeq?
112.SQR Debugging?
113.How will perform Error-Handling in SQR?
Ans:Using the command line flags –O,-L,-ZMF and –XMB
Using SQR commands ON-ERROR=Skip/Warn/Stop, ON-ERROR=Procedure_name
114.How are Multiple-Reports Generated in SQR?
115.What are the ways of Performance Tuning in PeopleCode?
Ans: Using Object-Oriented programming and Proper programming logic.
116.Why is ‘SETENV.SQC’ is used?
Ans: To set the default Environment for the SQR Report.
117.Why is Process Monitor used and in What is that Which Updates the Status of the Process Monitor?
118.What are the Key-Fields in the PS_JOB and the PS_EMPLOYMENT?
119.In Which record is the Status of the Employee Stored?
Ans: PS_JOB.
120.How will you draw a Line of Hyphens in SQR?
Ans: Using Fill argument in the Print Command.
121.When an incorrect value is entered in a Field and the Field turned Red then what is the action to be taken?
Ans: To Enter the Appropriate value which does not Violate the Field Edit & System Edits of that perticula Fields.
122.Can u Declare Multiple Heading sections in one SQR Program?
Ans: Yes, In Multiple Reports we can do that.
123.What are the Compile-Time Variables ? How to refer them?
124.What are the Run-Time Variables?
125.What is Dynamic Query Variable ? How to refer?
126.What is SQC ? Purpose of the ‘STDAPI.SQC’?
Ans: SQC is nothing but a Piece of REusabler code, just like a External function. STQAPI.sqc is used to make the SQR Program API aware.
127.What are the Debugging Commands in the SQR ?
Ans: -DEBUG xxx & #IF-DEBUG
128.What is Load-Lookup?In Which situation you use this Technique?
Ans: Load Look up is nothing but an Array, a temporary location for storing the data. This is used if we are retrieving data from more than one table.
129.What are the File-Manipulation Commands in the SQR?
Ans: Open, Close, Write & Read.
130.Is there any Limitations to Opening a File?
Ans:To Open a file we have to specify the mode of file, Path and the file must exists.
131.What are the Before and the After Procedures?How is the Execution Sequence?
Ans:Before Procedure Level Execution is from 1 to n Level and the
After Procedure Level Execution is from n to 1 level.
132.I want the Previous value of the On-Break ? Which is the Command Used?
Ans: ‘SAVE=Variable’
133.How to Identify the Document Variables?
Ans:By @.
134.What is the SPF File?What are the Flags required to make a file to SPF?
Ans:SPF is a PortableFormatFile and the command line flag used is –KEEP.
135.How to refer a Global Variables in the Local Procedures?
Ans.By prefixing the “_” underscore for the Variablename.
136.How the Output variables denote in the Local Procedures?
Ans:
137.What is –Bnn,--Tnn,--RS & --Rt Flags?
Ans: --Bnn for specifying default number rows to retrive from the database.
--Tnn used for Testing Which specifies the number of pages we want to test.
--RS is used to create an .SQT file.
--RT is used to run .SQT file.
139.What is Debug Command Line Flag?
Ans: -DEBUGxx.
140.How to Place and Appropiate Logo in SQR?
Ans: Using ‘Declare Image’ Command.
141.Diff between SavePreChange and the SavePostChange?
142.How to get the Most Current EffDt Row and the EffSeq Row?
Ans: select * from PS_ACTUAL_TBL A
Where A.EFFDT = ( select max(B.EFFDT) from PS_ACTUAL_TBL b
Where A.KEY1 = B.KEY1 ….(Upt o all Keys Above EFFDT field) and B.EFFDT <= sysdate)
AND A.EFFSEQ = (select max(C.EFFSEQ) from PS_ACTUAL_TBL C
Where A.KEY1 = C.KEY1 ….(Upt o all Keys Above EFFDT field including EFFDT))
143.When the Work-Flow Events fires?
Ans: After the successful Execution of the SavePrechange.
144.What are the DataBuffer Classes?
Ans: 1.Field Class
2.Record Class.
3.Row Class.
4.Rowset Class.
145.How to refer a SecondLevel Field value?
146.What is the Component Buffer?
Ans: Tempory memory area to Store data related to ‘Current Active Component’.
147.Can you write Error-Messaging in the FieldChange event?
148.What is the FieldFormula and the FieldDefault events?
149.What is the MessageGetFunction?What is the diff between MessageGet and the
MessageGetText functions?
Ans:
150.What are the Meta-Sql Commands?
151.How many SQR’s you modified Explain?
152.Why do we use SQR ? Explain them?
Ans: 1.Where ever Programming Logic is more.
2.For BackGroung SQL Processing.
3.For Interfacing.
4.Mainly it is a Powerful Reporting Tool.
153.What is the diff between Including the SQC’s at the Page-Header and the Page- Footer?
154.How can we use DML and the DDL Commands in the SQR?
Ans: Directly writing those commands in ‘Begin-SQL’ Paragraph.
155.How can you know the Status of the SQR Report?For that any SQC is needed or not?
Ans: We can Know by verifying in Process Monitor the SQC needed for it is ‘STDAPI.SQC’.
156.How can you Export or Import the Data in the Flat File to PSDatabase?
Ans: Using File Layout & Using File Handling Commands in SQR.
157.Diff between Load-Lookup and Arrays
158.Diff between ASK and the INPUT Command?
159.What is PIA?Explain each part?Functions of the AppServer?
160.Diff between Search-Record and the AddSearch-Record?
161.What are the events associated with the other events?
Ans:
162.How can you define Global variables and impact of it ?
163.Diff types of Functions in the PeopleCode?
Ans: 1.Built in Functions
2.Internal People Code Functions.
3.External People Code Functions
4.External Non-Peoplecode Functions
164. What is the difference between SQL Object and SQL Exec?
SQL Object can be used with Fetch to return multiple rows, whereas SQLExec can fetch only one row.
165.What is the difference between User defined and System Defined Variables?
User-defined variables
These variable names are preceded by an & character wherever they appear in a program. Variable names can be 1 to 1000 characters, consisting of letters A-Z and a-z, digits 0-9, and characters #, @, $, and _.
System variables
System variables provide access to system information. System variables have a prefix of the % character, rather than the & character. Use these variables wherever you can use a constant, passing them as parameters to functions or assigning their values to fields or to temporary variables.
166. What are various types of User Defined Variables?
Global
The variable is valid for the entire session. A global variable must be declared, however, in each PeopleCode program where it’s used. Use global variables rarely, because they are difficult to maintain.
Component
The variable is valid while any page in the component in which the variable is defined stays active. Similar to a global variable, a component variable must be declared in each PeopleCode program where it’s used.
Local
The variable is valid for the duration of the PeopleCode program or function in which the variable is defined. If you do not declare a variable, it’s automatically declared with the scope Local and the data type Any.
You can declare variables using the Global, Local, or Component statements, or you can use local variables without declaring them. Here are some examples:
Local Number &AGE;
Global String &OPER_NICKNAME;
Component Rowset &MY_ROWSET;
Local Any &SOME_FIELD;
Local ApiObject &MYTREE;
Local Boolean &Compare = True;
Variable declarations are usually placed above the main body of a PeopleCode program (along with function declarations and definitions). The exception is the Local declaration, which you can use within a function or the main section of a program.
167. What is the difference between Get and Create functions in Instantiating Objects?
Get functions, which include functions such as GetField, GetRecord, and so on, generally provide access to data that already exists, whether in the data buffers or from an existing definition.
Create functions, which include functions such as CreateObject, CreateArray, CreateRecord, generally create defined objects that do not yet exist in the data buffer. Create functions create only a buffer structure. They do not populate it with data. For example, the following function returns a record object for a record that already exists in the component buffer:
&REC = GetRecord();
The following example creates a standalone record. However, there is no data in &REC2. The specified record definition must be created previously, but the record does not have to exist in either the component or data buffer:
&REC2 = CreateRecord(EMP_CHKLST_ITM);
168.Explain Component Buffer
Component buffer is the area in memory that stores data for the currently active component. The component buffer consists of rows of buffer fields that hold data for the records associated with page controls, including primary scroll records, related display records, derived/work records, and Translate table records. PeopleCode can reference buffer fields associated with page controls and other buffer fields from the primary scroll record and related display records.
169.How many records can you have in one scroll level?
Each scroll level can have only one primary scroll record, but can have related display records, derived/work records and Translate table buffer fields.
The primary record on a level one scroll area must be a child of the primary record on level zero, the primary record on a level two scroll area must be a child of the primary record on its enclosing level one scroll area, and the primary record on a level three scroll area must be a child of the primary record on its enclosing level two scroll area.
170.What event is associated with a Page?
The only event for Peoplecode to be written on a Page = Activate Event (not supported by Sub-pages)
171.How are external Peoplecode functions stored?
These are stored in FieldFormula event in the record with the prefix FUNCLIB_. Internet scripts are stored as WEBLIB_. To use a function in a program, it must be declared at the top of the program.
172.Explain difference between Assignment by Value and Assignment by Reference?
Assignment by Value = the result of the right-hand expression is assigned to the variable as a newly created value, in its own allocated memory area
Assignment by Reference = When both sides of an assignment statement are object variables, the result of the assignment is not a copy of the object. You’re making a copy of the reference only. The variable names do not refer to separate and distinct objects; they both refer to the same object. Variables are passed by Reference to functions.
173.Which are the Think-Time functions in PeopleSoft?
Think-time functions suspend processing either until the user has taken some action (such as clicking a button in a message box) or until an external process has run to completion (for example, a remote process).
Call to external DLL, DoCancel, DoModal, InsertImage, AttachFile, RemoteCall., RevalidatePassword., WinExec (think-time only when synchronous), WinMessage, MessageBox (depending on the style parameter) etc.
174.Which event is triggered when we click a button on a page in PeopleSoft?
PeopleCode programs started by button are placed in the FieldChange event.
175.In which events, we should not write any error or warning?
Errors and warnings should not be used in FieldDefault, FieldFormula, RowInit, FieldChange, RowInsert, SavePreChange, WorkFlow, and SavePostChange PeopleCode events. An error or warning in these events causes a runtime error that forces cancellation of the component.
176.Which function is used to force Save on a page?
DoSave()
177.How can we place the focus on the field that caused the error or warning condition on an Error or Warning function in SaveEdit within the current component?
178.what is the purpose of multiple reports? In what situation u use this?
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.
179.can u declare multiple heading sections in one sqr program?
Yes,we can declare multiple headings in the Multiple Reports.
180.what is the compile time variables?How to refer?
Ask variables are compile time variables.
181.What is run time variables?
Input variables are run time variables.
182.What is sqc?what is the purpose of stdapi.sqc?
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.
183.What are the steps to run an sqr program from people soft environment?
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
184.what are the debugging commands in sqr?
Show & Display are debugging commands
185.what is the difference between them?
Show is used to display more than one variable at a time.
Display is used to display only one variable at a time
186.what is load lookup?in what situations you use this technique?
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.
187.what are the steps in performance tuning?
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.
188.What are the file manipulation commands in sqr?
Open,Close,For-Reading,For-Writing,For-Appending,Read & Write.
189.Is there any limitations to opening an file?
We can Open at a time a liited number of files that is 256
190.What are before and after procedures?How the execution sequence?
For group headings before and for group footings we use after .
191.I want to get previous value of on-break? what is the command?
Save command
192.How to identify document variables?
By seeing the Document Marker Symbol ie;@.
193.What is spf file?what are the flags exists to make a file to an spf?
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.
194.How to refer a global variable in local procedure?
After special character (ex.#,&) we use underscore(_) after that variable name
195. What is -Bnn flag?
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.
196..What is -Tnn flag?
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.
197. What is -RS & -RT Flags?
-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.
198. What are the sections in Sqr?which one is necessary?
Setup, Heading , Footing, Program & Procedure Sections. Program section is the Mandatory section.
199.What is -debug command line flag?
This is used for Debugging in SQR.
200. How to place an corporate logo in sqr?
Using “Declare Image” command
No comments:
Post a Comment