Re: CA/400 File Transfer Problem

["Goins, Kirk : CO IR" <KGoins@xxxxxxx>]

You were right. All the orignal fields were codepage 37 and the results were
all 65535. I used the the MIDRANGE-L ARCHIVES and found that a ini file
"cwbtfr.ini" with a parm set to 1 forces CA to translate the data correctly.

Thanks for your help.
 ----------
From: Rob Berendt
To: MIDRANGE-L@midrange.com
Subject: Re: CA/400 File Transfer Problem
Date: Tuesday, May 04, 1999 6:58AM

Yea, this one has been covered a few times on this list.  It has to do with
the
CCSID on the file, (I bet it is 65535).  There are three usual methods of
getting
around this problem.  One, change the CCSID of the file.  Two, check out all
the
options of the download and look at the CCSID option.  Three, there is a way
to
set up a default for this, but, hey, I forget.  Good luck.





kgoins@ix.netcom.com on 05/03/99 08:32:39 PM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     midrange-l@midrange.com@Internet
cc:     

Subject:        CA/400 File Transfer Problem

I am helping a client setup some automated downloads using runrmtcmd and
CA/400.
We've got the auto part down pretty good,  but we are having a data
translation
problem.

The source file has a couple dates stored as numbers not as dates and we
want to
get yesterday's transactions so... using the
Define Results in query we do the following

                            Define Result Fields


 Field       Expression                         COMMENT
 SHIPDATE    digits(04251999)                   # Number to CHAR

 SHIPDATEMM  substr(shipdate, 1, 2)             # Get Month

 SHIPDATEDD  substr(shipdate, 3, 2)             # Get Year

 SHIPDATEYY  substr(shipdate, 5, 4)             # Get Year

 SHIPDATECH  shipdatemm  || '/' || shipdatedd   # Build Char field that is a
date
             || '/' || shipdateyy

Plus some more stuff

Now if we use CA/400 to download SHIPDATECH or a couple other fields built
using
the method for SHIPDATECH CA wants to call them "HEX" and when downloaded
the
date of
04251999 downloads as F0F4F2F5F1F9F9F9.

If the client uses ETU400 to download the data it comes down in char format
04251999.
displaying the data file on the 400 shows the fields as char and query
displays
the correct format.

What are we doing wrong??


 --
Kirk Goins
Blue Heron Consulting,Inc
2418 SE Burnside Rd #321
Gresham, OR 97080
503-618-1493
EMAIL kgoins@ix.netcom.com              
                kirkgoins@aol.com
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---