RE: CPYTOIMPF & trailing blanks

["Nicholas Reading" <nreading@xxxxxxxxxxxxxx>]

I agree - RPG would be my preferred coding language, but our application is
governed by SMART/400 which insists on COBOL or CL programs !
(thanx for the SQL suggestion - unfortunately we're dealing with 200+ fields
in a file & 100,000+ records !)

How about a CL command, API, or other short cut ???

Ta

Nick

-----Original Message-----
From: owner-midrange-l@midrange.com [mailto:owner-midrange-l@midrange.com]On
Behalf Of D.BALE@handleman.com
Sent: Thursday, 26 October 2000 12:27 AM
To: MIDRANGE-L@midrange.com
Subject: RE: Creating a DDE-link between

Why not RPG?  With a combination of using %trim( %editc( #FIELD :
editcode ))
and easy concatenation, you'll have an easy time dropping the trailing or
leading blanks.

Dan Bale
IT - AS/400
Handleman Company
248-362-4400  Ext. 4952

-------------------------- Original Message --------------------------
Hi,

I have seen a number of informative mails on this list referring to creation
of CSV files using the CPYTOIMPF command - this command will greatly reduce
our development costs for an upcoming project, BUT, the client is concerned
with the size of the file due to fixed length fields/records and of course
trailing blanks. Whereas their previous manual solution using Rumba, created
true delimited files with variable length records and no trailing blanks for
individual fields ...
So, my question is, does anyone have a smart/efficient way of creating a CSV
file with No trailing blanks esp. for the packed numeric fields which in
some cases are defined as 18,5 in the database but contain very small
values - hence a great deal of wasted space in the CSV file !
Of course we can write a relatively simple COBOL program (not allowed to use
RPG !) to examine each record, but I'm hoping for an easier way out ???
Thanx
Nick
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---