Go Mobile Log In
       Where ERP Meets the Web



CRTCSV *cmd for IBM i
TechCrystals Code Package

v3.1 has great new and convenient heading line options for .csv!  (and start and end tags for XML)

A ready-to-go command line option for downloading Db2 for i data (and meta-data) into the IFS in CSV, Tab-Delimited and XML formats

We hope our new column heading options will work well for you and your company's personnel.  In this release, we have focused on compatibility with  Db2 for i meta-data usage standards being used in businesses today, young and old.  For example, we have options in place for handling meta-data from DDS and SQL, and also combinations of the two using ALIAS or COLHDG.

CRTCSV IBM i *CMD v3.1 concept picture

Effectively justify use of ad-hoc spreadsheet functions on DB2 for i data for data owners, with this quick export tool requiring virtually no set up.  For small to medium sized files, set up simple menu options for authorized users using only CLP. 

Works great for developers and Q/C folks doing ad-hoc testing with a character-based PC file comparison tool, such as when verifying before and after data versions by row...

To get started a free trial of Tegratecs CRTCSV *cmd running on your machine (IBM i 7.2 OS or greater) in 30 minutes using RSTLIB from a standard CD in the optical drive, click below on CD image or "Prompt" link (you will be prompted prior to download).  Get serial number based 7 day license code from here (web page).  


Prompt for a Zip File Download containing a single SAVF image of TDCRTCSV *lib v3.1!
     

Intended Recipient:  Application Software Developer,  QA Tester,  Data Owner Users, Knowledge Workers

$95 subscription per year per machine partition
Get 7 day code immediately from our website

Read further down for instructions on how to get a free trial running on your machine in short order.

(1)  ** no longer required ** Join this website (to download or ask us to mail you a CD)    Go to Contact Us page (not required!)

(1)  Download (save) this .zip file  to your PC, unzip it (SAVF has no extension) and burn "TDCRTCSV" file to a blank CD
(2)  Insert the CD into an IBM i optical device
(3)  RSTLIB SAVLIB(TDCRTCSV) DEV(OPTxx) OUTPUT(*PRINT)

(4)  Visit page CreateCSVNativeIBMiCommand2.aspx  for a 7 day authorization code for evaluation (extendable)
-  Then run 2 CHGDTAARA commands to update EXPCDE and EXPDTE data areas with license codes

(5)  To run, enter "TDCRTCSV/CRTCSV" at the command line and and press F4 to prompt. 

I have questions or need assistance




Pictures & videos...
(command interface images shown with smartclient and Financial Portrait repository)

To open the tab-delimited .txt file created in this example ("Performance Data.txt") using Excel from your desktop, simply right click and select Open with Excel.  In this example, the headings rows will be based on the field/column descriptions (TEXT attribute) as opposed to the SQL, field or Alias names.

CRTCSV v3.1 *cmd Example 1

Watch - Play CRTCSV *cmd Demo - Field Text Attribute in heading row of tab-delimited text file output (1:42)



For example, to open the comma-delimited .csv file created in this example ("Payment Terms Master File.csv") using Excel from your desktop, double-click on the .csv file (within a mapped drive on your IFS).  In this example, you can see the use of the column headings meta-data, which are stacked in to 1, 2 or 3 lines based on the source meta-data for each field/column.

CRTCSV v3.1 *cmd Example 2

Watch - Play CRTCSV *cmd Demo - COLHDG attributes in CSV output (4:47)




Continue to Next Page in Series


CD Contents Listing
DSPOPT VOL(*MOUNTED) DEV(OPT01) DATA(*SAVRST) OUTPUT(*print) PATH(*ALL)

                                              Saved Object Information
 5770SS1 V7R2M0  140418
  Device file:
    Device . . . . . . . . . . . . . . . :   OPT01
    Volume . . . . . . . . . . . . . . . :   TDCRTCSV_3_1
    Optical file . . . . . . . . . . . . :   /TDCRTCSV
    Expiration date  . . . . . . . . . . :   *NONE
  Save operation:
    Save command . . . . . . . . . . . . :   SAVLIB
    Save date/time . . . . . . . . . . . :   01/21/19  02:58:01
    Save while active  . . . . . . . . . :   *NO
    Data compressed  . . . . . . . . . . :   No
    Release level  . . . . . . . . . . . :   V7R2M0
  Data saved:
    Library  . . . . . . . . . . . . . . :   xxxxxxxx
    ASP  . . . . . . . . . . . . . . . . :   1
    System name  . . . . . . . . . . . . :   xxxxxxxx
    System serial number . . . . . . . . :   xx-xxxxx
    Private authorities  . . . . . . . . :   No
                                  Objects
  Object       Type       Attribute    Owner           Size (K)   Data       Text
  TDCRTCSV     *LIB       PROD         QPGMR                 88   YES        CRTCSV *cmd Copyright Tegratecs Development Corp.
  CRTCSVCPP    *PGM       CLP          QPGMR                192   YES        Create .CSV Vers from DB File - Cmd Processing Pgm
  CRTCSV1      *PGM       RPGLE        QPGMR                104   YES        Calculate Heading Length
  CRTCSV2      *PGM       RPGLE        QPGMR                100   YES        Condense .CSV IMPF
  CRTCSV3      *PGM       RPGLE        QPGMR                112   YES        Condense .CSV IMPF
  CRTCSV4      *PGM       RPGLE        QPGMR                116   YES        Check Expiration Date and Serial Number
  CRTCSV       *CMD                    QPGMR                  8   YES        CRTCSV *CMD © 2019 Tegratecs Development Corp.
  EXPCDE       *DTAARA                 QPGMR                  8   YES        Expiration Code
  EXPDTE       *DTAARA                 QPGMR                  8   YES        Expiration Date
  CRTCSVP1     *FILE      PF           QPGMR                 44   YES        .CSV Conversion Interim Workfile
  CRTCSVP2     *FILE      PF           QPGMR                 44   YES        .CSV Conversion Interim Workfile
  CRTCSVP3     *FILE      PF           QPGMR                 68   YES        .CSV Conversion Interim Workfile
  CRTCSVP5     *FILE      PF           QPGMR                 68   YES        .CSV Conversion Interim Workfile

                                                        Database File Members
               File            Members
  File         Type             Saved    Member       Member       Member       Member       Member       Member       Member
  CRTCSVP1     PF                    1   CRTCSVP1
  CRTCSVP2     PF                    1   CRTCSVP2
  CRTCSVP3     PF                    1   CRTCSVP3
  CRTCSVP5     PF                    1   CRTCSVP5

                                                               Summary
  Number of objects saved  . . . . . . . :   13
  Members  . . . . . . . . . . . . . . . :   4
  Access paths . . . . . . . . . . . . . :   0
  Spooled files  . . . . . . . . . . . . :   0
                                         * * * * *   E N D   O F   L I S T I N G   * * * * *


        Top of TechCrystal Code Packages     go to next series page     Site Map     Switch to
Mobile View

You are at the web site of Tegratecs Development Corp.  Click here to go to the home page of this site...
Integrity, Integration and ROI from Your Software
Our contact information:
Tegratecs Development Corp.
1320 Tower Road
Schaumburg, IL 60173
800-739-3777
( please register or sign-in )
© 2019 Tegratecs Development Corp.