AS400 – FTP transfer converts lower to upper case

310 pts.
Tags:
Hi, Actually I transferred 10,000 lines of SQL scripts from Desktop to iSeries server.But when I try to ftp the notepad.txt file. All the lower case letters from notepad.txt file will be converted to upper case letters. Since Java is using these scripts from front end and its also case sensitive. So it creates a huge issue always. Do we have any solution to overcome this? Thanks, P.Amutha

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 8  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta

    In general, FTP won't convert anything from lower-case to upper-case, so something else is going on. The only reason I can think of is that you have English uppercase DBCS (feature 2938) installed as a language, and that's being used for your transfers. In such circumstances, lower-case letters don't exist. But that's complete guesswork since I don't have a setup to test and I have never tried it.

    Please show exactly how you make the transfers. Also show some of the text before the transfer and after the transfer. We need to see exactly what is happening. A description is not enough information for us for this problem.

    Tom

    125,585 pointsBadges:
    report
  • As400pgmmer

    Hi,

    1. We will have notepad say n1.txt which will have below 2 scripts.It will be saved in our desktop

    Delete from schema/Table;

    INSERT INTO Table(                                     
    FLD1, FLD2, FLD3, FLD4, FLD5, FLD6,
    FLD7, FLD8, FLD9, FLD10, FLD11,      
    FLD14, FLD13, FLD12) VALUES (                                                 
    '33', 'SOME_CHK', 'ROW', '5', '', '&', '&', 'Y', '',      
    CURRENT_TIMESTAMP, 'VVV', 'VVV', '5', 'SYSTEM');     

    2. Later we will type CMD in command prompt. It will go  to c:\windows\syste32\cmd.exe

    3.Then we will type 'cd desktop' in cmd prompt and hit enter

    4. Then we will type ftp 10.1.1.1 in cmd propmt and hit enter

    5.Then we will type user id and pwd in cmd prompt

    6. Then we will type PUT n1.txt  schema/Sourcephysicalfile.n1script

    After this n1script will be created as source under schema/sourcephysicalfile which will have lower case values converted to upper case

    Pls suggest your thoughts on this.We dont need any conversion actually

     

    Thanks,

    P.Amutha

     

     

    310 pointsBadges:
    report
  • As400pgmmer

    Exactly to say after FTP below will the scripts format

    schema/sourcephysicalfile.txt will have below(changes highlighted in green color)

    DELETE FROM SCHEMA/TABLE;

    INSERT INTO TABLE(                                     
    FLD1, FLD2, FLD3, FLD4, FLD5, FLD6,
    FLD7, FLD8, FLD9, FLD10, FLD11,      
    FLD14, FLD13, FLD12) VALUES (                                                 
    '33', 'SOME_CHK', 'ROW', '5', '', '&', '&', 'Y', '',      
    CURRENT_TIMESTAMP, 'VVV', 'VVV', '5', 'SYSTEM');   

    310 pointsBadges:
    report
  • TomLiotta

    In order to eliminate a couple possibilities, please show results of these two tests:

    1. Prompt the CHGFTPA command on the server. Look at the value specified for the 'Incoming ASCII/EBCDIC table' (TBLFTPIN) parameter.

    2. Run DSPFD for your "schema/sourcephysicalfile". When the file description is displayed, find where [ CCSID ] shows and note the value. You have to find CCSID by typing it in upper-case.

    What is the TBLFTPIN parameter value? And what is the source file CCSID value?

    Tom

    125,585 pointsBadges:
    report
  • As400pgmmer

    Hi,

    Please find below the test result

    1.'Incoming ASCII/EBCDIC table' (TBLFTPIN) parameter  -*CCSID

    2. DSPFD- Schema/sourcephysicalfile -Coded character set identifier  . . . . . . : CCSID         37

     

    Thanks

    P.Amutha

     

     

    310 pointsBadges:
    report
  • TomLiotta

    Okay, those are fine. We still need to see examples of text before and after transfer. Show a text example that demonstrates a change in case. For the 'after' text, you'll to show output from DSPPFM that has some changed text in the window. And you should show it using F10='Display hexadecimal'.

    By show hex along with the actual characters, it will eliminate another possibility.

    Tom

    125,585 pointsBadges:
    report
  • As400pgmmer

    Hi Tom, I am surprised now.Just now transfered one .txt file. Lower case letters are not converted.It remains the same. Dont know how it is happening really

    Thanks,

    Amutha

     

    310 pointsBadges:
    report
  • TomLiotta
    That is why we need to see actual examples rather than seeing only descriptions of what happens. If you discover that it is still happening, make sure you can capture the example. Run the same sequence over again and store before and after copies of the data. It's necessary to have an example that can be examined to avoid multiple guesses. -- Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following