RE: Downloading AS/400 file into Excel with negative values

I really have no idea how these new commands work (stuck at V5R1 for now),
but why are you using QDLS?  That's possibly the worst file system in the
IFS, and you may be having issues related to that environment....  I'd try
to use a real IFS file system.  I generally use the
/home/username/tmp/filename... path for temporary data.

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: Dwayne Allison [mailto:Dwayne.Allison@xxxxxxxxx]
Sent: Wednesday, September 15, 2004 9:46 AM
To: Midrange Systems Technical Discussion
Subject: RE: Downloading AS/400 file into Excel with negative values


 We use the command CVTPFXLS to convert AS400 file to Excel format then
e-mail to the user.

CVTPFXLS     FROMFILE(FINNB/BIBYMTH713) +            
             TOSTMF('/QDLS/CHACKOA/BIBY713.XLS') +   
             FLDHDR(*TEXT)                           
                                                  
SNDDST     TYPE(*DOC) +                                   
             TOINTNET((john.doe@xxxxxxxx)) +          
             DSTD('sent excel doc from 400') MSG('send +  
             xls file to email from 400 that was +        
             converted from a physical file') +           
             DOC(BIBY713.XLS) FLR(CHACKOA)                
                                            

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of DeLong, Eric
Sent: Wednesday, September 15, 2004 9:21 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Downloading AS/400 file into Excel with negative values


Sorry, never heard of that one....  How are you converting the data to be
imported into excel?  

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: Dwayne Allison [mailto:Dwayne.Allison@xxxxxxxxx]
Sent: Wednesday, September 15, 2004 8:10 AM
To: Midrange Systems Technical Discussion
Subject: Downloading AS/400 file into Excel with negative values



We are downloading our AS/400 files into Excel format, but when we have
negative number they are converted to positive numbers.  Anyone had this
problem?

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


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