Re: Loading Fixed Length ASCII / EBCDIC

This is a multi-part message in MIME format. --------------13A2258A540E Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit John Cokos wrote: > > Thanks to everyone who responded to my earlier questions...now I have some new ones... > > Importing ASCII Files > I am able to convert and load from Delimited Ascii, and DBF files via 4gl > and Perl... > but I am having a lot of difficulty with Fixed Length and EBCDIC Files. > Has anyone solved this? > How? > Is there some common utility for this that I am not seeing? I don't know about EBCDIC, what about converting to ASCII first with something like dd? Have you looked at dbload? > One more thing > Is there an *easy* way to save a variable to a file? As I am trying to write > the code for the above, I was trying to create an Awk statement for use with > the RUN command. The variable cAwk in my code is about 250 bytes long, so I > cannot display it on screen. I would like to be able to store the variable in > a text file so I can take a look at it and see where the bugs are. Do I have > to OUTPUT TO REPORT to do this? Yes. A report will generate your file for you. Remember to issue the FINISH REPORT before you issue the RUN command. You may have to set the execute permissions as well, if you are executing it. Hope that helps, -- --------------13A2258A540E Content-Type: text/plain; charset=us-ascii; name="ATT_SIG.TXT" Content-Transfer-Encoding: 7bit Content-Disposition: inline; filename="ATT_SIG.TXT" Mark. +------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +-----------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work, force it! | |Fax: +27 11 803 2189 |If it breaks, it needed replacing anyway!| |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+-----------------------------------------+ --------------13A2258A540E--