<verbatim> /* ************************************************************************** */ /* CRTCSVDTA: Create .csv data file from AS/400 database member */ /* Copyright (C) 2000 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 */ /* ************************************************************************** */ CMD PROMPT('Create .csv formatted file') PARM KWD(FROMFILE) TYPE(NAME1) MIN(1) + PROMPT('From file') PARM KWD(TOFILE) TYPE(NAME1) MIN(1) PROMPT('To + file') PARM KWD(FROMMBR) TYPE(*NAME) DFT(*FIRST) + SPCVAL((*FIRST *FIRST)) PROMPT('From member') PARM KWD(TOMBR) TYPE(*NAME) DFT(*FIRST) + SPCVAL((*FIRST *FIRST)) PROMPT('To member') PARM KWD(MBROPT) TYPE(*CHAR) LEN(8) RSTD(*YES) + DFT(*REPLACE) VALUES(*REPLACE *ADD) + PROMPT('Replace or add records') PARM KWD(COLHDG) TYPE(*CHAR) LEN(7) RSTD(*YES) + DFT(*NONE) VALUES(*COLHDG *FIELD *NONE + *TEXT) PROMPT('Column headings in To file') PARM KWD(FLDDEL) TYPE(*CHAR) LEN(1) DFT(',') + PROMPT('Field delimiter') PARM KWD(RPLFLDDEL) TYPE(*CHAR) LEN(1) DFT('.') + PROMPT('Replacement field delimiter') PARM KWD(STRDEL) TYPE(*CHAR) LEN(1) DFT('"') + PROMPT('String delimiter') PARM KWD(RPLSTRDEL) TYPE(*CHAR) LEN(1) DFT('`') + PROMPT('Replacement string delimiter') NAME1: QUAL TYPE(*NAME) LEN(10) QUAL TYPE(*CHAR) LEN(10) DFT(*LIBL) + PROMPT('Library') </verbatim> -- Main.MartinRowe - 24 Jun 2005
This topic: DBG400
>
SourceCodeList
>
CmdSource
>
CmdCRTCSVDTA
Topic revision: r1 - 24 Jun 2005 - 06:11:49 -
MartinRowe
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