a2zinterviews

61.	How do you stop the retrieval of the DW immediately?
	DBCancel()
	Discuss Your Name Your Email-ID Your Answer

62.	If the source for a DW is a stored procedure and this stored procedure has parameters, where do we have to pass these parameters?
	In the RETRIEVE().
	Discuss Your Name Your Email-ID Your Answer

63.	What is the BLOB data type?
	Unbound data type that stands for binary large object. Usually used to hold pictures in database, window’s wave sound file or MIDI music.
	Discuss Your Name Your Email-ID Your Answer

64.	Can you call batch SQL from your DataWindow?
	Yes
	Discuss Your Name Your Email-ID Your Answer

65.	Explain the difference between SetTrans() and SetTransObject()?
	SetTransObject() works faster because it doesn’t perform Connect and Disconnect each time we call it. When we specify SetTrans() system Does all transaction Automatically. When we specify SetTransObject() we have to manage all Transaction by ourselves. When we use SetTrans( ) in a script, the DataWindow uses its internal transaction object and automatically connects and disconnects as needed; any errors that occur cause an automatic rollback. Use SetTrans() when we want PowerBuilder to manage the database connections automatically because we have a limited number of available connections or will be used the application from a remote location. SetTrans() is appropriate when we are only retrieving data and do not need to hold database locks on records the user is modifying. However, for better performance, we should use SetTransObject().
	Discuss Your Name Your Email-ID Your Answer