dbmodify - Modify Database

dbmodify -A [OPTIONS] DataArea [name]

dbmodify changes the data in a file based on the instructions in a field assignment file.

Program Option Description
-A FieldAssignmentFile or --faf=FieldAssignmentFile

Use information in a specified file to change field or file names, or initialize field values in the destination file. FieldAssignmentFile is the field assignment file name.

See the Infor Landmark Technology Data Access guide for your database for more information on the field assignment file.

-b or --brief Brief mode - do not display progress while the copy is in operation.
-B
-f "FilterString" or --filter=FilterString

Limit the output based on the specified filter value for the index keys of the file. The filter can be a conditional expression, such as Use the business class parser when filtering. The default is to parse against the dictionary rather than the business class spec repository. However, if filtering on such things as derived fields, the business class parser may be necessary.

-f "FileName.FieldName=123"

or

-f "Relationship.FieldName=123"

--gridstatus= ID

Publish progress to grid. You can then use

managegrid getprogress

to see a list of all running programs, or you can use

managegrid getprogress ID

Use the business class parser when filtering. The default is to parse against the dictionary rather than the business class spec repository. However, if filtering on such things as derived fields, the business class parser may be necessary.to see the status of this program. The value you specify for ID must be unique across the system for any programs being run with the gridstatus option.

-i IndexName or --index=indexName

Exports the data using an index sequence (for example, -iGLMSET1). The index name must follow the -i.
-q or --quiet Quiet mode (do not print informational messages)
--showrules Display the field assignment file rules that will be used.
DataArea Specify the data area containing the data to modify.
name

A list of names of dictionary files, business classes, modules, database spaces, or business class patterns to execute the command against.

Use the prefixes file-, pattern-, space-, or module- to resolve ambiguity. Use prefix- and type- to select files by prefix name or types used. File names can be the long or classic name and can include ? and *. Specifying "!" anywhere in the list will complement the selected files. Specifying @path reads names from the file, one per line. A hyphen ( - ) indicates stdin. Wildcard characters may need to be quoted in the command line or they will be interpreted by the command processor. A :L on a file name selects the lobs table. A :B on a file name selects the base table.