Data from a DB2 table can be unloaded mainly using two DB2 utilities, the latest high performance unload utility (HPU) which is supported by DB2 version 10 and above or the good old DSNTIAUL. Let’s take a look at DSNTIAUL parameters and a sample JCL to execute the an unload //STP001 EXEC PGM=IKJEFT01 //STEPLIB […]
DB2
DB2 Multi Row Fetch
Multi row fetch is one of the most powerful features of DB2 V8, which can give significant performance improvements to of your DB2 application. So what is multi row fetch or MRF , as the name suggests it simply mean fetching multiple rows at a time using your cursor. When you use a […]
How to Encrypt Data using DB2
Thought most of us who are working, as application programmer may never use this feature of DB2 at a program level it is an interesting upgrade in DB2 V8 and is worth understanding. DB2 provides encryption and decryption of data at a column level and provides a number of built in functions to facilitate this. […]