ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

CCSID Conversion from iSeries to Linux Server through FTP

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • CCSID Conversion from iSeries to Linux Server through FTP

    Friends,

    I am back after a long time hoping to solve a problem with CCSID Conversion,

    BackGround,

    From iSeries, we generate a flat file with data and FTP the file to the Linux Server. The Flat file data may contain mixed characters for different region, For example - English & Greek for Greece | English and Russian for Russia and completely English. Default CCSID for Flat file is 037 English

    So, for languages such as Greece, Russia - I will be creating file with appropriate CCSID and copy this data to the new file before FTP.

    Problem,

    I need to send the file in UTF-8 (Unicode) format to the Linux Server. When I directly send the file in 1208 format - the FTP command fails with conversion error to 819. I believe the problem is by default FTP uses ASCII. I tried changing it using the type keyword( example TYPE 1208 C) . But, it does not work.

    I tried using CPYTOIMPF file for conversion as well - but the file was received as 'Octat-stmf' format in Linux Server

    Tried several other possible ways without luck. Your inputs are much appreciated.

    Regards,
    Vinoth







  • #2
    Try using the FTP command BIN in your FTP script. That will suppress any character conversion and transfer the file as is.

    Comment


    • #3
      Yes, i have tried it - the file was sent from iSeries in Binary Mode. But, in the Linux server - it is complete unreadable. We tried to convert the file to UTF-8 in Linux - but the data does not look as expected.

      Comment


      • #4
        Originally posted by Vinoth View Post
        ... the data does not look as expected.
        "It doesn't look as expected" doesn't help us much. What does it look like?

        What did it look like before it was sent? What were the streamfile attributes? What is the system QCCSID? What was the job CCSID? What FTP commands were used? How did you try to convert it on Linux?

        To show us a view of some data, it will probably help if we can see sample lines in hex as well as simple characters.

        I tried using CPYTOIMPF file for conversion as well...
        Why? It's not clear if this should be an "import" file. Was this a database file in DB2? What database will it be "imported" into?

        Troubleshooting data transfers between platforms can involve a number of details. You will possibly need to post many of them before anyone spot the problem.
        Tom

        There are only two hard things in Computer Science: cache invalidation, naming things and off-by-one errors.

        Why is it that all of the instruments seeking intelligent life in the universe are pointed away from Earth?

        Comment

        Working...
        X