Interview Questions.

Top 100+ Powerbuilder Programmer Interview Questions And Answers

fluid

Top 100+ Powerbuilder Programmer Interview Questions And Answers

Question 1. What Is The User-described Function?

Answer :

A consumer define characteristic is a group of energy script statements that perform a few processing.

Two types of user outline characteristic :

Global function : Accessible any whare within the software.

Object Level characteristic :Object Level features are defined for a window, menu, user item or utility object.

Question 2. What Are The Passing Arguments?

Answer :

PassByValue : When an argument is exceeded via cost the function can accesses the temperory nearby reproduction of the arguments and might alternate the price of the neighborhood replica.

PassByRef: When an argument is handed by using reference the function can accesses the original price of the argument and may exchange it at once.

PassbyReadOnly: When a controversy is handed with the aid of read-best we are able to’t change its value but we will alternate the fee of the argument however we will’t assign any other item to that object.

Informatica Interview Questions
Question three. What Are The Scope Variables?

Answer :

Local: Local variable is a brief variable handiest declared in the script itself and they're available most effective within the script in which they have been declared, while the script is finished execution the local variable is destroyed.

Instance: Intance variable that belongs to an item and associated with an instance of item. It allows values to be shared between scripts in the equal item.

Shared: Shared variable retain their price when an object is closed and opened once more.

Global: Global variabl can get right of entry to everywhere within the utility. Can access any object within the application. It has public get entry to level.

Question 4. What Events Do You Know For The Application Object?

Answer :

OPEN: the user starts utility.

IDLE: No mouse or keyboard hobby occurs in a distinct range of seconds SystemError - A serious blunders passed off all through execution.

CLOSE: The person closes the application

ConnectionBegin: In a distributed computing environment, happens at the server while a consumer establishes a connection to the server via calling the ConnectToServer characteristic.

ConnectionEnd: In a allotted computing surroundings, happens at the server whilst a patron disconnects from the server by using calling the DisconnectServer function.

Informatica Tutorial
Question five. How Can You Run Another Application From Within Powerbuilder?

Answer :

We ought to do it using PB characteristic Run(). Run(string, WindowState), in which string is a string whose price is the filename of the program we want to execute. Optionally, the string can contain one or greater parameters of the program; WindowState (optional) is a price of the WindowState enumerated statistics type indicating the nation in which we need to run the program.

E.G., Run(“c:windowsnotepad.Exe”, Maximized!)

PL/SQL Interview Questions
Question 6. How Do You Avoid Messagebox “software Is Already Running”?

Answer :

Use Handle() characteristic. Handle() returns the object’s name if the object exists.

Question 7. What Do You Mean Structures And Types?

Answer :

A shape is a set of one or more related variable of the equal or exceptional records sorts grouped below a unmarried name.

Global:

Not related to any gadgets.

Object Level:

Associated with precise styles of home windows, menu or person object.

SQL Server 2008 Tutorial SQL Server 2008 Interview Questions
Question 8. What Are The Two Structures Every Application Has?

Answer :

Every PowerBuilder software has the MessageObject and the ErrorObject. ErrorObject is used to document mistakes for the duration of execution. MessageObject to technique messages that aren't PowerBuilder-defined activities, and bypass parameters among windows.

Question 9. What Are The Ways To Close Your Application?

Answer :

HALT
HALT CLOSE
CLOSE
Software Engineering Interview Questions
Question 10. What Is Halt? Halt Close? What Is The Difference Between Them?

Answer :

HALT : 

Halt announcement forces the utility to terminate at once. This is most often used to close down the application after a serious errors occurred.

HALT CLOSE : 

Halt Close does the same component but triggers the utility object’s Close occasion before terminating.

Software Engineering Tutorial
Question 11. What Is The Purpose Of The Pb.Ini Files?

Answer :

INI stands for “initialization”. They are mainly meant to be a trendy layout that programs can make use of to keep information from one run to the following. Rather than difficult-coding the values of transaction properties in scripts, that is too inflexible for maximum real-international applications, you’ll need your scripts to examine a few or all of them from an .INI record. You should use PB.INI .INIs are usually within the same format:

[Database]
DBMS = Sybase
Database = Video Store DB
User Id =
DB Password =
Log Password =
Server Name =
Log Id=
Lock =
DBParm=ConnectString=‘DSN=VideoStore DB;UID=dba’

Hadoop Interview Questions
Question 12. How Do You Manipulate .Ini File Through Powerbuilder Functions?

Answer :

Set Profile String()
ProfileString()
ProfileInt()
Informatica Interview Questions
Question thirteen. What Is The Datawindowchild?

Answer :

A DropDownDataWindow behaves a infant of the DataWindow Object that incorporates it.

Hadoop Tutorial
Question 14. What Do You Mean About Data Window?

Answer :

A datawindow item is an object which you use to retrieve, present and control records from a relational database or other facts supply(Such as EXCEL worksheet or DBASE document).

Retrieves information from a database and present it to the person in a extensive variety of patterns. 

We can use datawindow objects in purchaser/server, web-bsed and mult-itier programs.

The report we can create in Infomaker and the Datawindow gadgets. We can create in powerbuilder and the equal gadgets.

Question 15. Explain Types Of Presentation Styles Available In Datawindow?

Answer :

Composite
Crosstab
Freeform
Graph
Grid
Group
Label
N-up
OLE-2.0
Richtext
Tabular
Sybase Interview Questions
Question sixteen. Define Datawindow Buffers?

Answer :

PRIMARY BUFFER:

When information is retrieved from the databse by using the usage of retrieve() feature, it's far retrieved into the Primary Buffer and it's miles the content of this buffer which are displayed within the datawindow.

Powerbuilder constantly shows the information in datawindow manipulate from the Primary Buffer. Data from different buffers aren't visible to the consumer.

ORIGINAL BUFFER

When consumer modifies a row within the DataWindow the row inside the Primary Buffer is changed and the original fee is copied into the Original Buffer from the Primary Buffer. Copies statistics handiest while the user adjust the row for the first time.

DELTED BUFFER

When the user deletes a row with the DeleteRow() feature, rows are transferred from Primary Buffer to Deleted Buffer.

FILTERED BUFFER

When rows are filtered the use of the SetFilter() feature, the filtered rows are display inside the DataWindow and don’t suit the filterd conditions are moved to the Filtered Buffer. 

EDIT CONTROL OR DATA BUFFER

Edit DataWindow Control has one edit manipulate. It contains the present day column’s facts. When the person regulate the facts in a column adjust facts is copied in Edit Control Buffer. The regulate facts at the display and the content material of the Edit Control are same. But the cost in the Primary Buffer has the antique records.

Question 17. Define Data Store?

Answer :

DataStore is a non-visible DataWindow manage. DataStore used for Background processing, processing Embeded SQL and Distributed gadgets.

Background Processing: 

Sometimes we use multiple DataWindow control at the display to show one unmarried record. But those DataWindows are not usable for printing. So we use hidden DataWindow manipulate for printing.

Processing Embedded SQL:

Lot of instances we want to apply embedded SQL to test whether a selected report is current within the databse or no longer. So we can test for the existing file the usage of DataStore.

Distrubuted Objects:

We can use DataStore inside the server application when we are developing a allotted software.

Database Administration Interview Questions
Question 18. Under What Circumstances Will Powerbuilder Automatically Join Tables That You Select In The Select Painter?

Answer :

If we select tables that have one or extra columns with equal names, the Select painter routinely displays the join, assuming equality among the 2 columns.

PL/SQL Interview Questions
Question 19. What Presentation Styles Do You Know And When Do You Use Them?

Answer :

The Tabular presentation style gives facts with the data columns going throughout the page and headers above each column. As many rows from the database will display at one time as can fit within the DataWindow item. We can reorganize the Tabular presentation style any way we need by using moving columns and text. Tabular style is often used while we need to organization information.

The Freeform fashion provides statistics with the information columns going down the web page and labels subsequent to every column. We can reorganize the default layout any way we want via transferring columns and text. Freeform style is often used for data entry form.

The Grid fashion provides information in a row-and-column format with grid lines isolating rows and columns. Everything we area in a grid DataWindow object need to suit in one cell in the grid. We can't pass columns and headings round as we can within the Tabular and Freeform styles. But, unlike the others styles, users can reorder and resize columns with the mouse in a grid DataWindow item in the course of execution.

The Label style affords information as labels. We select this fashion to create mailing labels or other styles of labels. If we choose the Label fashion, we are requested to specify the attributes for the label within the Specify Label Specification.

The N-Up style presents  or greater rows of facts next to every other. It is just like the Label style. We can have records from numerous rows inside the database throughout the page, however the data isn't always revealed on labels. The N-Up presentational style is beneficial if we've got periodic statistics; we are able to set it up so each duration repeats in a row..

The Group presentation style offers an smooth way to create grouped DW gadgets, wherein rows are divided into agencies, each of which could have information calculated for it. It generates a tabular DW that has one organization stage and a few other grouping properties defined. We can customise the DataWindow in the DataWindow painter workspace.

The Composite presentation fashion permits us to mix more than one DWs inside the equal object. It is on hand if we need to print multiple DataWindow on a page.

The Graph presentation fashion creates a DataWindow object this is only a graph the underlying statistics is not displayed. As the data modifications, the graph is mechanically up to date to reflect the brand new values. We use a graph to beautify the display of facts inside the DataWindow item including a tabular or freeform DataWindow.

Crosstab tactics all of the records and provides the precis statistics that we've got described for it. We use if we want to analyse information. Crosstab analyses data in a spreadsheet. Instead of seeing a long series of rows and columns, users can study a Crosstab that summarises the facts.

OLE 2.Zero presentation style the usage of a procedure called uniform information switch; information from PB supported information assets can be despatched to an OLE 2.Zero server utility. The OLE 2-compliant application makes use of the PB supplied statistics to formulate a graph, map, a spreadsheet or the like to be displayed inside the DW.

RichText presentation style the usage of a RichText DW, you may create letters of other files by merging data in your DB right into a formatted DW. Master word processing orientated features such as headers, footers and multiple fonts are available in an easy-to-use format.

Question 20. Describe The Difference Between The Grid And Tabular Presentation Styles.?

Answer :

In the Grid presentation fashion, we can't pass columns and headings around as we are able to inside the Tabular presentation style however in Grid presentation style users can reorder and resize columns with the mouse in the course of execution.

Hadoop Administration Interview Questions
Question 21. Describe The Difference Between The Labels And N-up Presentation Styles.?

Answer :

In N-up fashion, we can also have information from numerous rows in the database across the web page, but the records isn't always revealed on labels.

Question 22. How Often Must You Set The Transaction Object ?

Answer :

Just as soon as when we outline the DW manipulate. If we change the association of a DataWindow item with a DataWindow manipulate in a script, we should re-difficulty the SetTransObject () before the subsequent retrieval or update.

Question 23. What Function Changes The Current Row?

Answer :

ScrollToRow()

Informatica Admin Interview Questions
Question 24. How Would You Define Validation Rules For The Datawindow Object?

Answer :

We can outline validation guidelines in the DataWindow painter. We can use the SetValidate() characteristic in a script to set validation policies dynamically (at run time) in a script for DW.

SQL Server 2008 Interview Questions
Question 25. What Is The Difference Between A Datawindow Control And Object?

Answer :

DataWindow manipulate is a field for a DW item and is placed at the window. DW manage has characteristic and capabilities. DataWindow object is a PB item which has connection to database and GUI. DW object has attributes. DataWindow item represents the statistics source. It encapsulates your database get right of entry to into a high level item that handles the retrieval and manipulation of statistics use for showing records and taking pictures user input. DataWindow object encompass :

facts intelligence (perform test validation policies)
person interface (presentation style)
It is used to display statistics or capture user input. DW is an item that we use to retrieve, present and manipulate data from a relational DB or different facts supply in an wise manner. (The DW manage is the box for the DW item. The DW item is created the usage of the DW painter; a DW manage is located on the window. A DW item has attributes. A DW manipulate has attributes and features. A DW item represents the records supply. It encapsulates your database get right of entry to right into a high level object that handles the retrieval and manipulation of information. It is used for showing information and capturing the person input. A DW item consists of statistics intelligence (plays check validation policies) and person interface (presentation fashion).

Question 26. What Are The Strongest Points Of Using The Datawindow Control?

Answer :

Displaying statistics.
Entering information.
Scrolling.
Reporting.
Hadoop Testing Interview Questions
Question 27. What Is The Difference Between Sqlca.Sqlcode And The Value Returned By The Dberrorcode() Function?

Answer :

The DBErrorCode() feature (no longer SQLCA.SQLCode) assessments the results of Database get entry to performed by using a DataWindow. We take a look at SQLCA.SQLCode after explicitly issuing embedded SQL statements, together with Commit.

Software Engineering Interview Questions
Question 28. Which Feature Of The Datawindow Painter Greatly Simplifies The Creation Of A Report Having Only One Group?

Answer :

The simplest way to create a record that has a single organization is to pick the Group presentation style from the New DataWindow dialog field.

Question 29. Where Is A Query Stored?

Answer :

In a .PBL report.

Microsoft square server notification services Interview Questions
Question 30. How Do You Create A Datawindow Object Dynamically?

Answer :

We use SyntaxFromSQL() and Create() 

functions:

SQLCA.SyntaxFromSQL(choose string, presentation string, Error string)
dw_1.Create(syntax, Error string)
dw_1.SetTransObject(SQLCA)
dw_1.Rerieve()

To create a DataWindow dynamically we must:

construct a string to hold a SQL Select assertion;
construct a string to specify the presentation traits of the DataWindow object;
partner the syntax and description with an present DataWindow control;
accomplice the DataWindow manipulate with a transaction item, and carry out a retrieval.
The DataWindow this is created exists best for the lifestyles of the DataWindow manipulate, except we use the LibraryImport() characteristic to shop it in a library. Dynamic DW items permit us to create and modify DW gadgets on the fly. To create a DW dynamically, use the Create() function.

Creating takes two arguments: the name of the DataWindow item a good way to get replaced by the brand new DW object, and the syntax for developing the brand new DW object. We can create the DW object syntax in a script, but it's miles simpler to use the SyntaxFromSQL() to generate the syntax from a SELECT announcement.

Question 31. Why Must You Specify The Transaction Object For A Datawindow Control After Creating The Datawindow Object?

Answer :

The Create() characteristic ought to be followed via SetTransObject() feature because Create() destroys any preceding affiliation among the DataWindow and a transaction object. Then, we are able to problem a Retrieve().

Question 32. Can You Dynamically Assign A Datawindow Object?

Answer :

Yes, using DataWindow’s manage characteristic “DataObject”. DataWindow control has the characteristic DataObject. If we want to trade an associated DataWindow object at runtime we need to place a line within the script that adjustments the fee of the DataObject characteristic.

For instance:

dw_1.DataObject = “d_name”

Question 33. Let’s Say, You Share Two Dw Buffers And The Primary Dw Has Some Dddw Columns. Will This Dddw Be Shared Automatically As Well?

Answer :

NO. After we have shared 2 DataWindows, we have to share all DropDowns as well. First, we should get the reference for the Child DataWindow the use of GetChild() function and then do sharing by way of using ShareData() function.

DataWindowChild dwc_1, dwc_2
dw_1.Getchild(“worker”, dwc_1)
dwc_1.SetTransObject(sqlca)
dwc_1.Retrieve()
dw_2.Getchild(“worker”, dwc_2)
dwc_1.ShareData(dwc_2)

Hadoop Interview Questions
Question 34. How Can You Update Multiple Database Tables From One Datawindow?

Answer :

Using Modify() characteristic. When a DataWindow is based on a be a part of of more than one tables, we will replace all of these tables by way of enhancing attributes DataWindow.Table, UpdateTable and column attributes Update and Key the use of Modify() characteristic. For instance, if the records to start with came from DEPARTMENT and EMPLOYEE tables, and DEPARTMENT desk become distinctive as an Update Table whilst we painted the DataWindow, we need to:

1. Update the DEPARTMENT table the use of the Update() feature:

iRet = dw_1.Update (TRUE (AcceptText(), FALSE (ResetBuffer))

2.Modify the Update traits of the DataWindow to factor to the Employee desk:

IF iRet = 1 THEN
dw_1.Modify(“Dep_id.Update = NO”) dw_1.Modify(“Dep_name.Update = NO”)
dw_1.Modify(“Dep_id.Key = NO”)
dw_1.Modify(“DataWindow.Table.Updatetable = ‘employee’”)
dw_1.Modify(“Dep_id.Update = YES”)
dw_1.Modify(“Dep_name.Update = YES”)
dw_1.Modify(“Dep_id.Key = YES”)
dw_1.Update()
END IF

Question 35. What Is The Method To Validate A Numeric Column In A Datawindow?

Answer :

SetValidate()

Question 36. In What Attribute Of The Transaction Object Are The Database-precise Error Codes For Connect/replace/retrieve Stored?

Answer :

SQLDBCode

Sybase Interview Questions
Question 37. How Can You Change A Select Statement Of The Datawindow At Runtime?

Answer :

We can change the pick out declaration through the usage of features SetSQLSelect() or by means of converting the records attributes Table.Select via calling feature Modify().

Modify() is most advantageous as it works quicker.

Dw_1.Modify(“datawindow.Table.Select = ‘Select * from customer’”)

Question 38. What Is An Update Flag?

Answer :

We use them while we want to update more than one DataBase tables from one DataWindow.

Question 39. What Is The Difference Between Nested And Composite Reports?

Answer :

In a Nested file each document has its own records supply. Composite record does not have its very own facts source-it's far just a field for different reviews.

Question forty. When Insert Statement Applied In Datawindow What Status Will Be Occurred?

Answer :

NEWMODIFIED! When a row is inserted right into a DataWindow it's far to begin with has a row reputation of NEW!, and all columns in a row to begin with have a column popularity of NOTMODIFIED!.

Database Administration Interview Questions
Question forty one. What Data Sources Do You Know And How Do You Use Them?

Answer :

The Data Source determines how we pick the facts in order to be used inside the DW object. If the information for the DataWindow object is retrieved from a database, we can also select one of the following Data Sources:

Quick Select is a select from one or more than one tables which are joined via foreign keys and might encompass simple choice criteria which appear at the WHERE clause. We can only pick columns, selection standards, and sorting. We cannot specify grouping before rows retrieved, encompass computed columns, or specify retrieval arguments.

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

Query is a predefined SQL Select assertion, which need to be formerly constructed and stored as a Query item.

Stored Procedure shows that the DataWindow will execute a Stored Procedure and display the data within the first end result set. This Data Source only appears if the DBMS to which PowerBuilder is connected and which helps Stored Procedures. We can specify that the records for a DataWindow object is retrieved via a saved process if our DBMS helps Stored Procedures.

External is used whilst the records isn't always in the database and the DataWindow object can be populated from a script or facts will be imported from a DDE application. If the facts is not within the DB, we select External because the Data Source. This consists of the following conditions:

If the DataWindow item is populated from a script
If information is imported from a DDE application
If records is imported from an external report, together with a tab-separated text record (.TXT report) or a dBASE document (.DBF record).
Externalindicates that we have coded a script that resources the DataWindow item with its statistics. We use this Data Source when the records is in a .TXT or .DBF document or received through DDE. We might also use it when we plan to gain the information via embedding our own SQL Select assertion in a script. With this Data Source the DataWindow object does no longer difficulty its personal SQL statement. We specify the facts columns and their sorts so that PB can construct the correct

DataWindow object to hold the records. These columns make up the result set. In a script, we are able to want to tell PowerBuilder a way to get information into the DataWindow in our software. Typically, we will import information in the course of execution the usage of a PowerScript Import function (which includes ImportFile() and ImportString() or do some information manipulation and use the SetItem() feature to populate the DataWindow.

Question forty two. What Functions Do You Use To Change The Row Status?

Answer :

dw_1.SetUpdateStatus()
dw_1.SetItemStatus()
dw_1.GetUpdateStatus()
dw_1.GetItemStatus()

Hadoop Administration Interview Questions
Question 43. How Do You Stop The User From Editing Data That Is Displayed In A Field Of A Datawindow?

Answer :

Change the tab cost of the sector to zero in the DataWindow painter.

Question forty four. In Order To Sort The Contents Of A Datawindow, Two Commands Must Be Used. What Are They And What Does Each Do?

Answer :

SetSort() and Sort().

SetSort() defines the type standards (primary, secondary type files - ascending or descending order, etc.).

Sort() performs the real kind.

Question 45. What Is The Difference Between Computed Columns And Computed Fields In A Datawindow Object?

Answer :

Computed columns are created due to a SQL question at the server facet.

Computed fieldsas a end result of inner processing via DataWindow at the customer facet.

Question forty six. When You Implement Incremental Search, There Is No Current Row, So How Do You Highlight The Row You Are Looking For?

Answer :

SelectRow()
ll_row = Find()
if ll_row > 0 then SelectRow (ll_row)

Question forty seven. What Are Extended Column Attributes? How Can You Change Them Dynamically?

Answer :

It’s DataWindow object property (Expressions) which we are able to alternate dynamically the usage of Modify() characteristic.

Question 48. What Is A Code Table?

Answer :

Specifies whether or not PowerBuilder uses the code table for the column to validate statistics.

Values are Boolean: True–Uses code table to validate records; False–Does now not use code table to validate records.

The appearance of the textual content is distinctive by way of the edit masks.

Each row within the Code Table is a couple of corresponding values: a display price that person sees and facts values-the ones which are saved within the database.

Code Tables are used with DropDownListBox and RadioButtons. 

Question 49. How Can You Modify A Code Table During Execution?

Answer :

Using GETVALUE() and SETVALUE() features.

Question 50. How Do You Get The Name Of A Dropdowndatawindow?

Answer :

GetChild()

Question fifty one. How Do You Trap Errors From The Database In The Datawindow?

Answer :

Write some code inside the DBError Event

For example:

IF SQLCA.SQLCode <> zero THEN
MessageBox()
return 1
END IF

Question 52. What Two Types Of Computed Columns Are Allowed In A Datawindow?

Answer :

One from the database aspect
One from the customer facet
Question fifty three. How Can You Print Multiple Datawindows?

Answer :

We need to open the print task by calling the PrintOpen() feature. After that, we are able to print DWs with the aid of the usage of PrintDataWindow() function. After that, we near the print process by way of calling PrintClose(). When we use PrintDataWindow() with PrintOpen() and PrintClose(), we are able to print several DataWindows in a single print task. The information in each DataWindow manipulate begins printing on a brand new web page. 

Example:

lengthy job
process = PrintOpen() //Each DataWindow starts offevolved printing on a brand new web page.
PrintDataWindow(activity, dw_EmpHeader)
PrintDataWindow(activity, dw_EmpDetail)
PrintDataWindow(process, dw_EmpDptSum)
PrintClose()

Question fifty four. What Do You Use Computed Fields For?

Answer :

We use computed fields if we need a few calculation based on column facts that alternate for each retrieved row, some precis records gadget data (as modern date and time).

Question fifty five. How Do You Assign The Transaction Object To The Dw Control?

Answer :

We use SETTRANS() or SETTRANSOBJECT().

When we use SETTRANS(), the DW manage makes use of its personal Transaction item and robotically plays connect, disconnect, commit and rollback. The SetTransObject() tells the DW manipulate to share the transaction object with different DW controls. We must control the database processing and we are answerable for handling database transactions. Application performance is better while we use SetTransObject().

Question 56. How Do You Stop The Retrieval Of The Dw Immediately?

Answer :

DBCancel()

Question 57. If The Source For A Dw Is A Stored Procedure And This Stored Procedure Has Parameters, Where Do We Have To Pass These Parameters?

Answer :

In the RETRIEVE().

Question fifty eight. What Is The Blob Data Type?

Answer :

Unbound records type that stands for binary large item. Usually used to preserve snap shots in database, window’s wave sound file or MIDI music.

Question fifty nine. Explain The Difference Between Settrans() And Settransobject()?

Answer :

SetTransObject() works quicker because it doesn’t perform Connect and Disconnect whenever we call it. When we specify SetTrans() device Does all transaction Automatically. When we specify SetTransObject() we must manipulate all Transaction with the aid of ourselves. When we use SetTrans( ) in a script, the DataWindow uses its inner transaction object and robotically connects and disconnects as wished; any errors that occur cause an automated rollback.

Use SetTrans() whilst we need PowerBuilder to manipulate the database connections robotically because we have a constrained variety of available connections or can be used the application from a faraway location. SetTrans() is suitable whilst we're handiest retrieving records and do no longer want to keep database locks on information the user is editing. However, for higher performance, we ought to use SetTransObject().

Question 60. When Would You Use Settrans()?

Answer :

We use SetTrans() whilst simplest a constrained No. Of connections to the DB is authorized or we are handiest retrieving statistics and do no longer want to preserve DB locks on information the user is modifying.

Question sixty one. Define ‘retrieve Only As Needed’?

Answer :

PowerBuilder displays the first row at the display screen when its entire retrieveing. When we scroll downward extra rows are retrieved.

Question 62. Explain Dberror() & Error() Event.?

Answer :

DBERROR() occasion is fired whilst a database associated mistakes takes place.

ERROR() event on the DataWindow control degree is caused, while a incorrect expression is encountered within the item notaiton.

Question sixty three. Explain Computed Column?

Answer :

Computed clumn is a column that we outline as a part of the SELECT statement. This values are calculated by using the database and ship to the PowerBuilder.

Question 64. Explain Computed Field?

Answer :

Computed fields are described in DataWindow bands and PowerBuilder calculates these values, now not the database server.

Question sixty five. What Is Dde?

Answer :

DDE method Dynamic Data Exchange. This technology allows  one of a kind programs communicate to every different under MS-Windows surroundings and alternate data between them.

Question sixty six. Explain Triggerevent()?

Answer :

TriggerEvent() executes the specifed occasion’s script proper manner. All pre-described activities are defined as enumerated information types beneath TriggerEvent().

TriggerEvent() function executes synchronously, the following command after this command will now not be carried out untill thios command is carried out completly.

Return kind is :

Return 1 Successfully Executed.
Return -1 Invalid.

Question 67. Explain Postevent()?

Answer :

PostEvent() may be executed after finishing the current script execution. PostEvent() executes asychronously. PostEvent() scripts are bending inside the message queue.

Question sixty eight. Explain Different Levels Of Attribute Method Protections?

Answer :

Public, Protected, Private, PrivateRead, PrivateWrite, ProtectedRead, ProtectedWrite.

Question sixty nine. Explain Transaction Objects?

Answer :

Transaction item contains the necessery informaiton wished to connect with a database. Like person identification , password..

SETTRANSOBJECT()

SetTransObject tells the DataWindow to apply targeted transaciton item.

SETTRANS()

The DataWindow manage connects and disconnects after each Retrieve or Update function at the same time as using SetTrans

When we use SetTrans we can’t update a couple of DataWindow item.

Question 70. Explain Sqlsa?

Answer :

Dynamic Staging Area is internally utilized by PowerBuilder and is the connection between execution of a declaration and Transaction object. SQLSA consists of no.Of parameters and SQL statements.

Question seventy one. Explain Sqlda?

Answer :

Dynamic Description Area stores records about input and output parameters. The two principle of dynamic SQL are PREPARE and EXECUTE.

Question seventy two. Explain Types Of Windows In Pb?

Answer :

MAIN: A standlone overlaped window that may be independed of all other home windows. Used for unmarried window application.

CHILD: A window that is depending on a first-rate window and can best exist within the essential(PARENT) window. If minimize the primary window as well as the kid window is minimizsed. A infant window can't beyond the parent window.

MDI: MDI window permits to open more than one window as sheet internal it. When a window within the MDI window it reduce and maximized wheet icon is displayed at the bottom of the MDI window.

MDIHELP: MDIHELP window has additional feature of a status bar at the lowest of the MDIHELP window. This repute bar used to display assist text like run time.

POPUP: POPUP window depends on it figure window. POPUP window will behave like a main window. IT the figure window is minimized POPUP window may be hidden.

RESPONSE: RESPONSE window equalent of a window conversation box. When a response window is opened from another window the reaction window can’t decrease and maximize untill the user offers response to the window can»t get every other window.

Question 73. Explain Helt Close Keyword?

Answer :

When PB encounters HALT without the key-word CLOSE, it right now terminates the utility.

When PB encouters HALT with the keyword CLOSE, it right now finished the script for the close event for the utility and then terminates the applicaiton.

Question 74. Explain Mdi?

Answer :

MDI stand for Multiple Document Interface. It is an software style that allows users to open multiple windows(referred to as sheets) in a unmarried window(referred to as MDI Frame) and to move freely amongst these sheet.

MDI has two PB window styles:

MDI Frame
MDI Frame with MicroHelp
MDI Frame has three components:

Frame
Client Area
Sheets
Question seventy five. When Do You Need To Use .Pbd?

Answer :

We use .PBD while the wide variety and length of the objects in our application could otherwise make a very huge .EXE (1.2 to 1.5 megabytes). We want to percentage components amongst several packages. Distribute utility components selectively, as an instance, to upgrade an application or restore a bug.

Question seventy six. When Do You Need To Use A .Pbr?

Answer :

We create .PBR if we've any dynamically assigned items, bitmaps or icons and to reduce the quantity of documents we want to distribute with the .EXE. We commonly use a .PBR while we've scripts in our utility in which we dynamically assign sources to attributes of items or controls within the utility. If we do no longer use a .PBR, we ought to distribute various .BMP, .RLE, .ICO files with the software. We need to place in .PBD’s any objects that we reference dynamically in scripts in the software.

Question 77. What Is .Pbr File?

Answer :

PBR record is an ASCII File in which we listing resource names or DW item names that had been referenced dynamically inside the script.

Question 78. What Types Of Menus Available In Powerbuilder?

Answer :

DropDown
Cascading
Pop-up
Question 79. What Is Regenerate Option In The Library Painter? When Is It Most Useful?

Answer :

It compiles all codes of an object(s). Regeneration is critical in the course of the development of our PB software. Regeneration is useful :

whilst we've an errors message with no purpose for it;

When we improve to a new edition of PB, the new version need to regenerate all its supply code to replace it;

When we make a alternate to an ancestor window that has many descendants, the adjustments can be straight away rippled at some point of all child window through regeneration. Regenerating could be called “recompiling”. When you regenerate an access, PowerBuilder recompiles the supply shape stored in the library and replaces the prevailing compiled shape with the recompiled shape.

Question 80. What Are Non-visual User Objects?

Answer :

Non-visual user object is an item that encapsulates attributes and features however is not visible to the person. NVO is a set of commercial enterprise user functions. They may be Custom Class and Standard Class. NVOs are beneficial because they allow you to encapsulate software operations into gadgets making them less difficult to broaden, control and preserve and additionally to encapsulate all safety control for an utility into a single item.

Question eighty one. What Are Facilities Of The User Objects?

Answer :

We define a thing as soon as, then reuse it typically as we want without any extra paintings.

Question 82. What Does Openuserobject() Do?

Answer :

OpenUserObject() provides a person object to the required window and makes all its homes and controls to be had to scripts. Windowname.OpenUserObject ( userobjectvar, userobjecttype , x, y  ) This feature is used whilst you need dynamically, at runtime area some user items on a window. This function presentations this user object, makes all its attributes to be had to scripts. You should open a user object earlier than you can access the attributes of the consumer item. If you get admission to the consumer object’s attributes before you open it, it's going to purpose an execution error.

Question eighty three. How Can You Dynamically Place An User Object On The Window?

Answer :

By the use of functions : OpenUserObject( ), OpenUserObjectWithParm( )

Question eighty four. What Events Does The Custom Class Have?

Answer :

Constructor and Destructor

Question 85. How Is A Custom Visual Userobject Different From A Standard Userobject?

Answer :

A custom visible consumer item is an item that has numerous controls that work as a unit. A popular visible person object inherits its definition from a popular control. We regulate the definition to make the control unique to our packages.




CFG