# Decompressed unload file for Employee and vehicle file

**URL:** <https://techcommunity.softwareag.com/t/decompressed-unload-file-for-employee-and-vehicle-file/202227>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas, Adabas-on-Mainframes, Adabas-Utilities-on-Mainframes\
**Created:** [December 21, 2018, 11:05am UTC](https://techcommunity.softwareag.com/t/decompressed-unload-file-for-employee-and-vehicle-file/202227 "2018-12-21T11:05:01Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sindhu\_Jose](https://avatars.discourse-cdn.com/v4/letter/s/f0a364/32.png) [@Sindhu\_Jose](https://techcommunity.softwareag.com/u/Sindhu_Jose)\
**Post date:** [December 21, 2018, 11:05am UTC](https://techcommunity.softwareag.com/t/decompressed-unload-file-for-employee-and-vehicle-file/202227/1 "2018-12-21T11:05:01Z")

</div>

Dear Team,

Can I Please get a copy of Decompressed version (ADACMP DECOMPRESS) of the sample ADABAS files i.e Employee and Vehicle file in mainframe format(UARC =2 i.e high-order byte first, EBCDIC encoding family,IBM370 floating-point format)

Thanks,  
Sindhu Jose

---

<div class="post-metadata">

**Author:** ![Claudemar\_Martins](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/claudemar_martins/32/322_2.png) [@Claudemar\_Martins](https://techcommunity.softwareag.com/u/Claudemar_Martins)\
**Post date:** [January 2, 2019, 9:27am UTC](https://techcommunity.softwareag.com/t/decompressed-unload-file-for-employee-and-vehicle-file/202227/2 "2019-01-02T09:27:04Z")

</div>

ADAULD FILE - Employee and Vehicle (my file is 5)

```auto
 //AAFPSAVE JOB (AAFP,DIBD),DBA,CLASS=S,MSGCLASS=A TYPRUN=HOLD                 
 //*UQ ALLOW                                                                    
 //* --------------------------------------------------------------             
 //* SALVANDO OS DADOS DO FILE ADABAS                              
 //* --------------------------------------------------------------             
 //ADAULD EXEC AAFAU003,TIME=1440                                            
 //DDOUT1 DD DSN=AAF.S.F5.DB003.COMPR,DISP=(,CATLG,DELETE),                 
 // VOL=SER=PRD27A,SPACE=(CYL,(2,4)),UNIT=SYSDA,                       
 // DCB=(RECFM=VB,BLKSIZE=0,LRECL=0,DSORG=PS)                          
 //* --------------------------------------------------------------             
 //DDCARD DD *                                                               
 ADARUN PROG=ADAULD,DBID=003                                                    
 //DDKARTE DD *                                                               
 ADAULD FILE=5                                                                  
 /*                                                                             
```

Dataset Compress

```auto
                                                                      R=00000001
DSN=AAF.S.F5.DB003.COMPR VOL=PRD27A UNIT=3100    
....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8
{. . H. K ..AA... ..AB.. ..AC... ..CD .. .AD.
.. ..AE.. ..AF... ..AG... ..AH... *.AI.. ..AJ... ..AK . :.AL.
. d.AM.. . . . . AA .AE .AI *AM d.. . ..AN... . .... .....AO... . .... ..
.. 
```

JCL for Decompress

```auto
 //AAFPC050 JOB (AAFA,DIBD),DBA,CLASS=S,MSGCLASS=A,TYPRUN=HOLD                  
 //*UQ ALLOW                                                                    
 //* --------------------------------------------------------------             
 //* ADACMP DECOMPRESS FILE 50                                   
 //* --------------------------------------------------------------             
 //ADACMP EXEC AAFAU003                                                       
 //DDEBAND DD DSN=AAF.S.F5.DB003.COMPR, ===> ENTRADA                  
 // DISP=OLD,UNIT=SYSDA,                                                
 // VOL=SER=PRD27A                                                      
 //* --------------------------------------------------------------             
 //DDAUSBA DD DSN=AAF.S.F5.DB003.DECOM, ===> DESCOMPRESS              
 // UNIT=SYSDA,                                                         
 // DISP=(NEW,CATLG,DELETE),                                            
 // VOL=SER=PRD27A,SPACE=(CYL,(10,5)),                                  
 // DCB=(LRECL=80,BLKSIZE=6160,RECFM=VB,DSORG=PS)                       
 //* --------------------------------------------------------------             
 //DDFEHL DD DSN=&&FEHL,UNIT=SYSDA,DISP=(NEW,DELETE),                         
 // SPACE=(TRK,1)                                                       
 //DDCARD DD *                                                                
 ADARUN PROG=ADACMP,DBID=003                                                    
 //DDKARTE DD *                                                                
 ADACMP DECOMPRESS                                                              
 /*                                                                             
```

Dataset Decompress

```auto
                                                                      R=00000001
DSN=AAF.S.F5.DB003.DECOM VOL=PRD27A UNIT=3100    
....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8
AZU-L0031231638 $.50000100RENAULT CLIO SEDAN AZUL 80E
P801101FRA. . .                                                                 
BXZ-A0031231881 .<50000200RENAULT SENIC AMARELO 80E
P801101FRA. . .                                                                 
VER-M0031231992 .<50000300PEUGEOT 206 VERMELHO 80E
P801101FRA. . .                                                                 
BXZ-A0031232103 .b.50000400PEUGEOT 306 PRETO 85E
P851101FRA. . .                                                                 
BXZ-A0031232214 ...50000500FIAT TIPO BRANCO 84E
P851201FRA. . .                                                                 
BXZ-A0031232325 ).50000600RENAULT SENIC ALIZE PRATA 82E
P821201FRA. . .                                                                 
BXZ-A0031232436 ...50000700RENAULT CLIO CINZA 82E
P821201FRA. . .                                                                 
BXZ-A0031232547 ..t50000800PEUGEOT 405 VINHO 82E
P821201FRA. . .                                                                 
BXZ-A0031232658 ..50000900FIAT PREMIO VERDE 82E
P821201FRA. . .                                                                 
BXZ-A0031232769 a.50001000FIAT ELBA AZUL 80E
P801011FRA. . .                                                                 
```

FTP for your DATASET - AAF.S.F5.DB003.DECOM - PC

---

<div class="post-metadata">

**Author:** ![Sindhu\_Jose](https://avatars.discourse-cdn.com/v4/letter/s/f0a364/32.png) [@Sindhu\_Jose](https://techcommunity.softwareag.com/u/Sindhu_Jose)\
**Post date:** [January 2, 2019, 10:29am UTC](https://techcommunity.softwareag.com/t/decompressed-unload-file-for-employee-and-vehicle-file/202227/3 "2019-01-02T10:29:35Z")

</div>

Thanks a lot Claudemar Martins !!!.. This would definitely help me.

---

<div class="post-metadata">

**Author:** ![Sindhu\_Jose](https://avatars.discourse-cdn.com/v4/letter/s/f0a364/32.png) [@Sindhu\_Jose](https://techcommunity.softwareag.com/u/Sindhu_Jose)\
**Post date:** [January 2, 2019, 11:13am UTC](https://techcommunity.softwareag.com/t/decompressed-unload-file-for-employee-and-vehicle-file/202227/4 "2019-01-02T11:13:39Z")

</div>

> [@Sindhu Jose](#):
>
> Thanks a lot Claudemar Martins !!!.. This would definitely help me.
> 
> Dear Claudemar Martins,
> 
> Would you be able to share an FTPed version of the decompressed file in a notepad along with the FDT. Just wanted to have a feel of the data along with the mapping.
> 
> Regards,  
> Sindhu Jose

---

<div class="post-metadata">

**Author:** ![Claudemar\_Martins](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/claudemar_martins/32/322_2.png) [@Claudemar\_Martins](https://techcommunity.softwareag.com/u/Claudemar_Martins)\
**Post date:** [January 2, 2019, 1:27pm UTC](https://techcommunity.softwareag.com/t/decompressed-unload-file-for-employee-and-vehicle-file/202227/5 "2019-01-02T13:27:11Z")

</div>

I do not know if Software AG allows sharing? If the moderator says that sharing is allowed.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 2, 2021, 3:42pm UTC](https://techcommunity.softwareag.com/t/decompressed-unload-file-for-employee-and-vehicle-file/202227/6 "2021-04-02T15:42:02Z")

</div>