You are here:
DBG/400
>
DBG400 Web
>
SourceCodeList
>
PnlGrpSource
>
PnlGrpCVTNULFLD
(revision 1) (raw view)
Edit
Attach
<verbatim> .********************************************************************** .* 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. </verbatim> -- Main.MartinRowe - 24 Jun 2005
Edit
|
Attach
|
P
rint version
|
H
istory
:
r2
<
r1
|
B
acklinks
|
V
iew topic
|
Edit WikiText
|
More topic actions...
Topic revision: r1 - 24 Jun 2005 - 05:53:15 -
MartinRowe
DBG400
Log In
DBG400 Web
Index
Search
Changes
Notifications
Statistics
Site Map
Downloads
Webs
DBG400
Jamaro
Main
Sandbox
Sandtub
System
Send a link to this page
Copyright © 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