IMDBB

IMDBB is a batch form that provides the same functionality as the importdb utility. This enables you to perform an import to the database via Lawson Portal rather than from the command line. For information on importdb, see importdb - Import Comma-Delimited File.

  1. In Lawson Portal, access IMDBB by using the search box. (IMDBB is in the IF system code within the application product line.)
  2. Define a new job.
  3. Specify options for the job:
    Program Option Description
    a Overwrite all duplicate records. Replaces existing database records with duplicate records in the flat file. If the flat file has multiple occurrences of a record, the last occurrence is stored in the database.
    n Do not overwrite duplicate records. Does not replace existing database records with the duplicate records from the flat file. It ignores the duplicate records in the flat file.
    b Batch inserts based on INSERTBUFSIZE.
    r Report on duplicate records. Prints duplicate records between the flat file and the database.
    l Log duplicate records.
    L Log modified and duplicate records.
    f File has field headers.
    t Tabs treated as separator value; default is Space.
    u Update records; valid with f option only.
    d Do not reformat dates. Files in database format.
    c

    Correct records. Valid with the u and f options only.

    Enforces strict data type casting. For example, the data type alpha converts to uppercase, and a leading zero is added to floating point fields (.12 ? 0.12). The default enforces strict data type casting.
    w Generate data type casting warnings. Overwrites the c option.
    e Halt program on any data or database error.
    V Display the version number of this utility.
    C

    Configures importdb to use the date format, decimal separator, and thousands separator set in locdef.

    Valid with the f option only.
    S

    Specifies the delimiter used in the import file if the default delimiter is not used.

    Requires the delimiter to be in a two-digit hexadecimal ASCII value. For example, if the user used a semicolon as the delimiter, the syntax would be S3B. The delimiter must also be a different character from the one used for the decimal and thousands separator.
  4. Specify the product line.
  5. Specify the DB file name, that is, the name of the file in the database into which you want to import data..
  6. Specify the full path and name of the CSV file whose data you want to import. This must be a path on the Infor Lawson System Foundation server. When specifying the path, you can include environment variables such as %GENDIR% and %LAWDIR%.
  7. Add and submit the job.