Verifying/Updating Field Data for SQL Portability

User this datamaint option to verify and update field data so that it can ported to an SQL database. By default, this option identifies embedded NULLs in alpha and text fields, and replaces these with u+0020. You can also supply regular expressions to identify other bad data in alpha and text fields.

datamaint --baddata -V|-U [OPTIONS] dataarea [busClass ...]

datamaint --baddata -V|-U [OPTIONS] --prodline prodLine [busClass ...]

datamaint --baddata -V|-U [OPTIONS] --tenant tenant [busClass ...]

datamaint --baddata -V|-U [OPTIONS] --all [busClass ...]

datamaint --baddata -H

  1. At a Landmark command prompt, type of of the above command syntax choices.
  2. Specify this information:
    Program Option Description
    -V Verify field data (no update).
    -U Update field data for SQL portability.
    -H Access help for this command.
    dataarea Run this datamaint option for the specified data area.
    --all Run this datamaint option for all active data areas.
    --prodline prodLine Run this datamaint option for all active data areas within the specified product line.
    --tenant tenant Run this datamaint option for all active data areas within the specified tenant.
    businessClass Specify a specific business class to work with.
    --badalphafilter STRING To identify bad characters in alpha fields, specify a quoted regular expression filter (for example, ".[^\p{Graph}\u0020]"). The default is ".[\u0000]".
    --badtextfilter STRING To identify bad characters in text fields, specify a quoted regular expression filter (for example, ".[^\p{Graph}\u0020\t\n\r]"). The default is ".[\u0000]".
    -d FILE_PREFIX or --dump FILE_PREFIX Specify a prefix for the name of the zip file to dump bad records to. For example, if you specify baddata as the prefix, the file name will be baddata_<dataArea>.zip.
    --filter STRING If you want to filter which data to run this datamaint option against, specify a filter expression.
    --nonulldetectoptimize Do not optimize the detection of embedded NULLs via database level filtering.
    --quiet Show only errors
    --replacecharhex HEX If you want to replace bad characters with a different value than the default of u+0020, specify that hex value.
    --showbadchar Send message with unicode value of each bad character to stderr (not logged).
    --skiplobs

    Do not check LOBs

    --threads=N

    Maximum active threads for processing, for example, --threads=3. If you use multiple threads, you may see a performance improvement. However, performance depends on other factors as well. Note that a very large table will be processed in a single thread.

    The default number of threads is four.

    -v displayoptions

    errorlevel, tracelevel, and verbose specified in any order, where:

    • errorlevel = {n}none | {f}atal | {e}rror | {w}arning (warning is the default)

    • tracelevel = 0:6 where 0 is no message and 6 is everything

    • verbose = whether to display exception stacktrace