Posts

Showing posts from November, 2012

Using ADRDSSU to dump and restore datasets

Image
Wondered if you have the concept of zipping files and transferring them to a different system - available in mainframe domain? Yes, You have a similar concept of dumping datasets to a dump file and use it to store or transfer to a different mainframe system and later restore the dumped datasets. Here is how You can do it. Dump multiple datasets to a single dump: //AIWCDMP  JOB  (WA2,,'ADMIN',GM,0085,),                                00010006 //             'JCL MANAGEMENT 10.0',                                   00020000 //             MSGCLASS=V,                                              00030000 //         ...

Shiva Samudram Falls, Karnataka

Image
The Shivanasamudra Waterfalls, literally meaning Shiva's Sea are situated at a distance of 85 kms from Mysore and 139 kms from Bangalore. The route to this segmented falls from bangalore is fantastic and well maintained. The island town of Shivanasamudra divides the river Cauvery into two different falls which display a captivating sight. On the one side, it forms the Gaganachukki falls shaped like a large horsetail and on the other side are the Bharachukki Falls. The sight of these two falls is enchanting. The Gaganachukki waterfalls are best viewed from the Shivanasamudra watch tower. There is another approach to the Gaganachukki falls from the Darga Hazrath Mardane Gaib. Bharachukki falls are situated at distance of approximately one km from the Dargah. These falls are best during the monsoons, nevertheless their beauty mesmerizes tourists throughout the year. Shivanasamudra is home to the first Hydro-electric Power station in Asia, which was set up in the year 19...

SPLICE of ICETOOL - Merge two or more flat files

Image
The Splice operator of ICETOOL is a very useful utility for matching and merging files based on a key. Now lets say we have two files with a common key as shown below: File 1:  Y12 89503 MKT Y12 57301 MKT Z35 02316 DEV Y12 91073 MKT Z35 18693 DEV File 2: 89503 27M $9,185,354 SAN JOSE CA 72135 08M   $317,632 BOSTON   MA 18693 10M $8,732,105 BUFFALO  NY 57301 50M    $30,000 NEWARK   NJ Now lets say we want the output file to have the information for a particular key value which consists of data from both the files. Lets say the output file should something like this. Output: Y12 89503 MKT  27M $9,185,354 CA Y12 57301 MKT  50M    $30,000 NJ Z35 02316 DEV Y12 91073 MKT Z35 18693 DEV  10M $8,732,105 NY We can do this using simple Splice tricks. The point that needs to be noted here is just that both the files should have the key field in the same position. In this process both the files are merged to ...