PeopleSoft Enterprise Applications Interview Questions.
1. Define Data Move?Data Mover is People Tool that provides a convenient way to:
0. Transfer application data between People soft data tables
0. Move People soft database across Operating systems and database plat forms.
0. Create release specific archives of People soft database or individual People soft records.
0. Execute SQL statements against any People soft database, regardless of the underlying operating systems or database plat form.
0. Control database security and access.
2. What is the usage of Data mover?
Data mover is used to create edit and run scripts. These scripts may include any combination of SQL commands and Data mover commands for exporting and importing database contents.
3. What is Trace SQL?
Trace SQL logs a variety of information about SQL activity called from People tools and from batch COBOL on a client or server.
OR
SQL Trace records information about the actual API (Application Process Interface)
Calls both our GUI (Graphic User Interface) and COBOL Programs send to the
Database. This tool is useful for debugging SQL
Note: While operating with the Data Mover utility, the trace option should be disabled.
Use SET NO TRACE statement to disable the SQL Trace.
4. What is BOOTSTRAP MODE?
When the Data Mover is launched using the Database Access ID and Password, it is called BOOTSTRAP MODE.
Typically, using Bootstrap mode is necessary for database loading, because there are no People soft security tables established yet. It is also helpful for accomplishing other security-related tasks, such as running Grant_Users and Encrypt_password scripts.
In Bootstrap mode the following commands are not valid export, rename and replace
View.
5. Explain the types of commands in the Data Mover?
A Data Mover script can contain two types of commands.
0. Data Mover commands: Used to export and import database information and to otherwise modify database. Also, used to control script execution, call other Data Mover files and to enter commands.
0. SQL commands: These include both standard and non-standard SQL commands and are used to modify the database.
6. What is SQR? Features of SQR?
*SQR (Structured Query Reports) is a programming language used in data processing and data reporting. SQR program can execute multiple queries.*
Features:
0. More flexible
0. Scalability for Client and Server architecture.
0. Multiple platform portability
0. Multiple RDBMS portability
7. What is a FLAG?
It is an attribute given to programming for processing and generating output destination file.
8. What is difference between .LIS and .SPF file?
. LIS (list file) is used for line printer execution. Normally it is used for printing cheques.
.SPF file is portable format, this is used for all window-based applications with any printer. Normally it is used for MSPAINT, Image, and Graphics.
9. How many types of SQR files are there?
There are 5 types of SQR files….
5. SQC: SQC program files contain commonly included procedures that are called by other SQR programs.
5. . LIS when an SQR reports generate output it is sent to a file with an. LIS extension.
5. . LOG: SQR.LOG file is the output file used by People soft. This file contains all information such as errors and displays statements. That is output to the terminal during the execution of SQR.
5. . MAX: SQR does not dynamically allocate memory. The default program allocations (which were coded for lower DOS memory) usually have to be increased for complex SQR programs.
Note: People soft uses a .MAX file to increase any SQR parameter where default is not adequate for the program. There is one main .MAX file for processing under SQR W (windows) called ALLMAXES.MAX
5. SQT: These program files are precompiled SQR programs. As a People soft 5+ there are no delivered precompiled SQR programs.
10. Explain briefly about flags?
The SQR command supports several flags. Each flag begins with a dash (-). Flags with arguments must be followed directly by the argument with no intervening space.
SQR Command-Line Flags
Flag Description
-A Causes the report output to be appended to an existing file of the user name
-Bnn (Oracle,SYBASE CT-Lib) indicates how many rows to buffer each time data
is retrieved from the database. The default is 10 rows.
-C Specifies that the cancel dialog box appear while the program.
-CB (Callable SQR) forces the communication box to be used.
-DEBUG (xxx) (Sybase) Causes lines preceded by #DEBUG to be compared. Without this
flag, these lines are ignored.
-E(file) Causes error messages to be directed to the named file, or to the default file
report errs. If no errors occur, no file is created.
-F (file) (Directory) overrides the default output file name program .lis
-KEEP In addition to .LIS files, creates an .SPF file for each report that your
program generates.
- LOCK(RR]CS]RO]RL]XX] (SQL Base) Defines the types of locking (isolation level
for the session.
-NR (SQL Base) specifies that the No Recovery mode is used when connecting to the database.
-XCB Do not use the communication box.
-XL Prevents SQR from logging on to the database. Programs run in this
mode cannot contain any SQL statements.
-XMB Disables the error message display so that a program can be run without
interruption by error message boxes.
-XP (SYBASE DB-Lib) Prevents SQR from creating temporary stored pro-
cedures.
-XTB Preserves the trailing blanks in an LIS file.
-ZIV Invokes the SPF viewer after generating program .spf file. Using this flag
implicitly invokes the –KEEP flag to create program .spf file.
-ZMF(File) specifies the full path and name of the SQR Error Message file. The Sqr
err.dat located in the directory indicated by the SQR DIR environment
Variable is the default.
Related Posts
No comments :