.* 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
.* 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
Convert Null to Non-Null defaults - Help.
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- Character fields are set to blank and numeric
fields (packed, zoned, binary, float) are set to zero.
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.
From file (FILE) - Help.
The file to update. A valid database file is required.
:HP2. File Library :EHP2.
The file's library, or *LIBL, is required.
Member (MBR) - Help.
: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.

-- MartinRowe - 24 Jun 2005
Topic revision: r2 - 01 Oct 2014 - 19:37:00 - UnknownUser
This site is powered by FoswikiCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding DBG/400? Send feedback