.**********************************************************************
.* CVTNULFLD: Help text for Convert Null to non-null defaults
.* Copyright (C) 2002  Martin Rowe  <martin@dbg400.net>
.*
.* This program is free software; you can redistribute it and/or modify
.* it under the terms of the GNU General Public License as published by
.* the Free Software Foundation; either version 2 of the License, or
.* (at your option) any later version.
.*
.* This program is distributed in the hope that it will be useful,
.* but WITHOUT ANY WARRANTY; without even the implied warranty of
.* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
.* GNU General Public License for more details.
.*
.* You should have received a copy of the GNU General Public License
.* along with this program; if not, write to the Free Software Foundation,
.* Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307   USA
.**********************************************************************
.* First panel
:PNLGRP.
.**********************************************************************
:HELP NAME=CVTNULFLD.
Convert Null to Non-Null defaults - Help.
:P.
This command updates null-capable fields in the target file with a non-null
default value if that field is set to null. Non-null capable fields, or those
that have a non-null value will be left untouched. For Date fields a value of
0001-01-01 is used, Time fields are set to 00.00.00, Timestamps are set to
0001-01-01-00.00.00.000000. Character fields are set to blank and numeric
fields (packed, zoned, binary, float) are set to zero.
:P.
This command requires that the EXCSQL (Execute SQL statement) command is
installed and in the job's *LIBL. This and other free utilities are available
from :HP1.http://www.dbg400.net:EHP1.
:EHELP.
:HELP NAME='CVTNULFLD/FILE'.
From file (FILE) - Help.
:P.
:HP3. FILE :EHP3.
The file to update. A valid database file is required.
:P.
:HP2. File Library :EHP2.
:P.
The file's library, or *LIBL, is required.
:EHELP.
:HELP NAME='CVTNULFLD/MBR'.
Member (MBR) - Help.
:P.
:HP3. MBR :EHP3.
The database file member that contains the data to be converted.
*FIRST may be used to pick the first (or only) file member.
:EHELP.
:EPNLGRP.