Re: Queries & Excel

You need to specify convert CCSID 65535 = yes on whatever transfer tool
you're using.


Thanks,

Mark


Mark Walter
Sr. Programmer/Analyst
Hanover Wire Cloth a div of CCX, Inc.
mwalter@xxxxxxxxxxxxxxx
http://www.hanoverwire.com
717.637.3795 Ext.3040
/"\
\ /
 X
/ \



                                                                                
                                                                      
                    "Angela Wawrzaszek"                                         
                                                                      
                    <awawrzaszek@xxxxxxxx        To:     
<midrange-L@xxxxxxxxxxxx>                                                       
             
                    urn.com>                     cc:                            
                                                                      
                    Sent by:                     Subject:     Queries & Excel   
                                                                      
                    midrange-l-bounces@xx                                       
                                                                      
                    drange.com                                                  
                                                                      
                                                                                
                                                                      
                                                                                
                                                                      
                    04/10/2003 02:32 PM                                         
                                                                      
                    Please respond to                                           
                                                                      
                    Midrange Systems                                            
                                                                      
                    Technical Discussion                                        
                                                                      
                                                                                
                                                                      
                                                                                
                                                                      




     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.