/* ************************************************************************** */
/* 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')

-- MartinRowe - 24 Jun 2005


This topic: DBG400 > SourceCodeList > CmdSource > CmdCRTCSVDTA
Topic revision: r1 - 24 Jun 2005 - 06:11:49 - MartinRowe
 
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