× 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.



CSV is one option. However I've discovered that XLS is often preferred.
It takes some hard searching but there are commands like SQL2XLS out there
on the internet which work like this:
SQL2XLS SQLSTMT('select iprod,idesc from iim')
TOXLS('/home/rob/ItemList.xls')
COLHDRS(*FLDNAM)
TITLE(ITEMLIST)
http://www.mcpressonline.com/microsoft/techtip-excel-on-the-fly.html
The download link seems to be broken. I am searching for another.

CSV can be fraught with errors. For example, if you try to import this
row
2" Steel rod
from CSV into XLS it goes somewhat bonkers because Excel tries to convert
that with quotes around it and it's an odd number of quotes now.

If you've got some programmers on staff there are some awesome
presentations on how to do this at:
http://www.scottklement.com/presentations/#RPGHSSF
If you want to stick with CSV and you've got programmers on staff then you
may want to look at
http://www.scottklement.com/rpg/ifs.html

There are some old deprecated commands out there: CPYTOPCD and CPYFRMPCD.
Don't use those as they are limited to what directories to stick them
into. Basically subdirectories under QDLS. There's performance issues
with that file system, and who likes the old dos 8.3 file naming
convention anyway?

I hate to mention these but there are commands CPYTOIMPF and CPYFRMIMPF. I
personally don't like them because IBM changes them with every release and
I have to modify the code that uses them. Also, writing to the IFS
directly as shown at the Scott Klement website will perform better than
IBM's commands. I've debugged IBM's commands and can understand why.
That's getting a little technical for this audience. Take this to the
midrange-l list if you want to know more.




Rob Berendt

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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.