PowerBuilder Interview Question and Answers

41. What is the difference between nested and composite reports?
  In a Nested report each report has its own data source. Composite report does not have its own data source-it is just a container for other reports.
 
Your Name Your Email-ID
Your Answer
42. Descibe DataWindow Item Status?
 
STATUS
NUMERIC VALUE
APPLIES TO
NEW!
2
Rows
NEWMODIFIED!
3
Rows
NOTMODIFIED!
0
Rows/Columns
DATAMODIFIED!
1
Rows/Columns
 
Your Name Your Email-ID
Your Answer
43. When Insert statement applied in DataWindow what status will be occurred?
  NEWMODIFIED! When a row is inserted into a DataWindow it is initially has a row status of NEW!, and all columns in a row initially have a column status of NOTMODIFIED!.
 
Your Name Your Email-ID
Your Answer
44. When Update statement applied in DataWindow what status will be occurred?
  DATAMODIFIED!
 
Your Name Your Email-ID
Your Answer
45. What Data Sources do you know and how do you use them?
  The Data Source determines how we select the data that will be used in the DW object. If the data for the DataWindow object is retrieved from a database, we may choose one of the following Data Sources:

Quick Select is a select from one or multiple tables that are joined through foreign keys and may include simple selection criteria which appear on the WHERE clause. We can only choose columns, selection criteria, and sorting. We cannot specify grouping before rows retrieved, include computed columns, or specify retrieval arguments.

SQL Select is an SQL Select statement from one or more tables in a relational database and may include selection criteria that appear on any of the possible Select statement clauses (can include selection criteria (WHERE clause), sorting criteria (ORDER BY clause), grouping criteria (GROUP BY and HAVING clauses), computed columns, one or more arguments to be supplied during execution.

Query is a predefined SQL Select statement, which must be previously constructed and saved as a Query object.
Stored Procedure indicates that the DataWindow will execute a Stored Procedure and display the data in the first result set. This Data Source only appears if the DBMS to which PowerBuilder is connected and which supports Stored Procedures. We can specify that the data for a DataWindow object is retrieved through a stored procedure if our DBMS supports Stored Procedures.

External is used when the data is not in the database and the DataWindow object will be populated from a script or data will be imported from a DDE application. If the data is not in the DB, we select External as the Data Source. This includes the following situations:
If the DataWindow object is populated from a script
If data is imported from a DDE application
If data is imported from an external file, such as a tab-separated text file (.TXT file) or a dBASE file (.DBF file).

Externalindicates that we have coded a script that supplies the DataWindow object with its data. We use this Data Source when the data is in a .TXT or .DBF file or obtained through DDE. We may also use it when we plan to obtain the data by embedding our own SQL Select statement in a script. With this Data Source the DataWindow object does not issue its own SQL statement. We specify the data columns and their types so that PB can build an appropriate

DataWindow object to hold the data. These columns make up the result set. In a script, we will need to tell PowerBuilder how to get data into the DataWindow in our application. Typically, we will import data during execution using a PowerScript Import function (such as ImportFile() and ImportString() or do some data manipulation and use the SetItem() function to populate the DataWindow.
 
Your Name Your Email-ID
Your Answer