The dbfhdeploy Command Line Utility

Use the dbfhdeploy command line utility to deploy files to your datastore databases.

Syntax:

dbfhdeploy [Options][Category] ActionParameters 

Options

Refer to the running of the command as a whole:

• -nobanner - display minimal output.
• -urlhelp - display information about the URL syntax.
• -verbose - displays additional information, such as the MFDBFH.cfg configuration file and script folder locations in effect, for the current operation.

Category

Defines the item to be acted upon. Valid values are:

data

The item to be acted on is a data file.

For an add, delete, or extract action, the URL must be of the form: sql://host[/instance]/datastore/filename[?folder=/path]

For a create or list operation, the URL must be of the form: sql://host[/instance]/datastore[?folder=/path]

ActionParameters

Action to perform and the data store to perform it on. Valid values are:

list URL

Lists data files that are located in the specified URL.

For example, the following command lists all the data files and sub-folders stored in the VSAM folder of the ESDEMO datastore:

dbfhdeploy data list sql://svr-mydb/ESDEMO?folder=/VSAM

create URL

Create a datastore in the specified URL.

For example, the following command creates the NEWDEMO datastore in the svr-mydb instance:

dbfhdeploy data create sql://svr-mydb/NEWDEMO

add path URL;attribs

Add data file specified in path to the datastore specified in URL.

Some file types require additional attributes, which can be:

type=seq|lseq

The type of file (other than a VSAM file) that is being added.

reclen=min,max

The minimum and maximum length of each record within the file.

recterm=windows|linux|unix

The type of record terminator used in the file. This is used primarily for RRDS files, and is only required for files that have been created on a different platform to the one on which it is currently being deployed.

For example, the following command adds the sequential file file.dat to the USRA folder, in the NEWDEMO datastore in svr-mydb, where it is referred to as mydat and has a (minimum and maximum) record length of 80:

dbfhdeploy data add file.dat sql://svr-mydb/NEWDEMO/mydat?folder=/USRA;type=seq;reclen=80,80

delete URL

Delete data file from datastore specified in URL.

For example, the following command deletes the mydat data file stored in the USRA folder, in the NEWDEMO datastore:

dbfhdeploy delete sql://svr-mydb/NEWDEMO/mydat?folder=/USRA

extract URL path

Extracts a copy of the data file specified in URL to the path specified by path.

For example, the following command extracts a copy of mydat from the USRA folder of the NEWDEMO datastore, and saves it as my-extract.dat:

dbfhdeploy data extract sql://svr-mydb/NEWDEMO/mydat?folder=/USRA my-extract.dat

upgrade URL

Note: Only use this option when instructed to by a Micro Focus SupportLine representative.

Upgrades the stored procedures associated with the data file specified in URL.

For example, the following command upgrades any stored procedures associated with the mydat2 data file stored in the USRB folder of the NEWDEMO datastore:

dbfhdeploy upgrade sql://svr-mydb/NEWDEMO/mydat2?folder=/USRB