RE: Queries & Excel

Angela,

Check off the "Convert CCSID 65535" option in whatever package you're using to 
do
the download.

Ed Chabot
The Marlin Firearms Company
100 Kenna Drive
North Haven, CT 06743
(203)985-3254

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Angela Wawrzaszek
Sent: Thursday, April 10, 2003 2:33 PM
To: midrange-L@xxxxxxxxxxxx
Subject: Queries & Excel


     I created an as/400 query and push the results to a file.    One of
the things I do in the query is concatenate 2 fields together one is a 1
pos alpha and then I use the digits command to push a numeric to a
character and concatenate the two to make a new 5 positions field.

  When I download this file into query this field gets converted to
hexadecimal ???

D9F2F2D9F2F220030301   =   R2282   =    R ||  digits(2282)



  Any reason why?

Thanks!
_______________________________________________
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.