# empsldv

    EMPSLDV(1)                                                          EMPSLDV(1)

    NAME
           empsldv - loads data from a dumpfile into an Empress table

    SYNOPSIS
           empsldv [ -c | -d [count] | -l | -r reject_file]
                           dump_file database table ["where_clause"]

    DESCRIPTION
           Empsldv  is a general purpose utility for loading fixed length or vari-
           able length data from a dumpfile into an Empress table. It accepts  the
           data in the Empress dump format and allows the user to:

           1)    Load all the data from the dumpfile into the table, or only those
                qualified the optional where clause.

           2)   Load the data into any Empress data  types,  with  automatic  data
                type conversion.

           3)    Generate a reject file for those records that could not be loaded
                due to datatype error, for example.

           4)   Examine the input file for invalid data.

           -c             To check the dumpfile for valid data. This  option  sup-
                          presses  the  actual  loading  of the data.  This option
                          only detects the errors in the format and the  datatypes
                          such  as  loading  a  character  field  into  a  decimal
                          attribute; not the errors in the table constraints  such
                          as loading duplicate values into a unique indexed key.

           -d  [count]     To  display  each  attribute  name along with the field
                          value to be loaded into the attribute  to  the  standard
                          output.   Only the first 30 characters of field value is
                          printed.  If the count (an integer) is given then  count
                          records  will be displayed. If the count is omitted then
                          all the records will be displayed.

           -l             To lock the table at table level  during  loading.   You
                          should  use  this  option if the number of records to be
                          loaded is greater than the value of the Empress variable
                          MSFILESLOCKNLOCKS. In addition, locking the table at ta-
                          ble level speeds up the loading process.

           -r reject_file To generate the reject_file containing the records  that
                          failed to be loaded. The reject_file must not exist.

           Notes

                1.    The  user  must  have  "insert" privilege on the table to be
                     loaded.

                2.   The datafile must be in the Empress  dump  format.  For  more
                     information  on  the  dumpfile,  please  refer to the Empress
                     select statement in the SQL reference manual.  You  may  also
                     want  to  refer  to  the  two  Empress  environment variables
                     MSVALSEP and MSLINECONT.

                3.   Since empsldv was designed for efficient selective loading of
                     variable  length (text, bulk) data, the where_clause must not
                     reference any variable length attribute.

                4.   Upon completion, empsldv prints  a  count  of  records  read,
                     qualified,  inserted and rejected to the standard output.  If
                     the where_clause was specified then  the  number  of  records
                     qualified   is   the  number  of  records  that  qualify  the
                     where_clause. If the where_clause was omitted, then the  num-
                     ber of records qualified is the number of records read.

    FILES
           EMPRESS database files

    SEE ALSO
           empmkdb(1), empcmd(1), empsdump(1)

    DIAGNOSTICS
           Error  diagnostics  are  printed  if no database is specified or if the
           database is not in the EMPRESS format.

    HISTORY
           Written by Empress Software Inc..   All  material  is  copyrighted  and
           licensed.  Use on non-licensed CPUs is prohibited.

    Empress 8.62                 Empress Software Inc.                  EMPSLDV(1)