Preparing for the LOBs (Large OBjects) samples

While the basic samples use the well-known 'Emplyoees' file delivered with Adabas, the LOBs demo programs require loading of a small Adabas file containing LOB fields.

Note:
LOB access requires a minimum Adabas version of v6 on OpenSystems platforms, Adabas v8 on mainframe platforms.


Loading the LOB file into an OpenSystems database

These are the steps to load the demo LOB file into an OpenSystems (Windows, *IX) Adabas database:

  • Save FILE90.FDT on the target system.

  • Save FILE90.FDU on the target system, adjust the dbid, file and lobfile parameters according to your needs.

  • Set the environment variable FDUFDT, for example on a Linux system: export FDUFDT=FILE90.FDT

  • Run the command: adafdu <FILE90.FDU

The demo 'base' and 'LOB' files are now loaded, which can be verified with the adarep utility: adarep db=<yourdbid>,cont

The LOB demo file is now ready to be used.

Loading the LOB file into a Mainframe database

The steps to create the LOB demo file in a mainframe Adabas database are as follows:

  • Use this FDT as input to ADACMP, specifying dummy input (DDEBAND). Sample JCL can be found on the ADAvrm.JOBS library distributed with Adabas.

  • Run the ADALOD utility, these parameters may serve as template input to the utility. Adjust the file number and size specifications based on your requirements.

Important:
Note that Adabas space / buffer parameters may need to be increased for LOB access, please consult the Adabas documentation for a description of required changes to your Adabas nucleus parameters.