RE: Converting Query Manager query output to Excel and Access

The CSV format can hold more then that just excel can't display it.  The
file produced would contain the data.  You can even open it in Notepad ;).
You would need a higher end PC Program to import it.  Something that uses an
actual database perhaps. ;)

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jake M
Sent: Thursday, June 01, 2006 4:07 PM
To: Midrange Systems Technical Discussion
Subject: Re: Converting Query Manager query output to Excel and Access

Dave and Rob,
Just a quick question. What happens when the SQL record set is more than
65536 records?

cheers,

Jake.

On 6/1/06, rob@xxxxxxxxx <rob@xxxxxxxxx> wrote:

STRSQL
CREATE TABLE QTEMP/ODOM (MYCHAR CHAR (15 ) NOT NULL WITH DEFAULT,
MYDEC DEC (7 , 2) NOT NULL WITH DEFAULT, MYDATE DATE NOT NULL WITH
DEFAULT)
INSERT INTO QTEMP/ODOM VALUES('A', 1.25, '05/31/2006')
1 rows inserted in ODOM in QTEMP.
INSERT INTO QTEMP/ODOM VALUES('B', 8.55, '05/25/2006')
1 rows inserted in ODOM in QTEMP.
INSERT INTO QTEMP/ODOM VALUES('C', 9, '05/15/2006')
1 rows inserted in ODOM in QTEMP.
F3
CPYTOIMPF FROMFILE(QTEMP/ODOM) TOSTMF('/ROB/ODOM.CSV')
STMFCODPAG(*PCASCII) RCDDLM(*CRLF) STRDLM(*DBLQUOTE) FLDDLM(',')
Start, Explorer    \\gdisys\root\rob\ODOM.CSV
A           B           C
A          1.25   5/31/2006
B          8.55   5/25/2006
C          9      5/15/2006

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Dave Odom" <Dave.Odom@xxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
06/01/2006 03:16 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
<midrange-l@xxxxxxxxxxxx>
cc

Subject
Converting Query Manager query output to Excel and Access






Rob, et al,

You mentioned once that to do what I want I should use the CPYTOIMPF
command.   Do you or anyone have any specific examples of the steps
where output of a QM query or Query/400 for that matter is "exported" to
a PC in a format for Excel and/or Access?

Thanks in advance,

Dave
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.