× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



"I am working on a project where we will be sending data to a banking
institution (which shall remain unnamed). The bank's systems apparently
require that the first record in the file they receive must contain column
headings!

Anybody know of a way to accomplish this without having to do RPG
programming? The client wants to avoid using programs wherever possible."

I do this a lot, you have to create a text file with the headings in it
with a text editor, and copy the file over. Here's the CL to do it.

RMVLNK OBJLNK('/BONEYARD.CSV')
MONMSG MSGID(CPFA0A9)
CPY OBJ('/BONEYARDHDG.CSV') TOOBJ('/BONEYARD.CSV')

CPYTOIMPF FROMFILE(BONEYARD) TOSTMF('/BONEYARD.CSV') +
MBROPT(*ADD) RCDDLM(*CR)


The BONEYARDHDG.CSB looks like:

************Beginning of data**************
BONEYARD,Units currently in the Boneyard
Item#,Item Description,Qty
************End of Data********************

This is a very basic example, and provides a two line header for a
spreadsheet with 3 columns. Use the EDTF command to create the heading
file.


Dale Gindlesperger
IT Manager/Special Projects Leader
Fleetwood Folding Trailers, Inc.
258 Beacon Street
Somerset, PA 15501



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.