Download from iSeries to PC (TAB delimited text)

5 pts.
Tags:
AS/400 Transfer
Data Transfer from iSeries
iSeries to PC
Tab Delimited Text Files
Hi,

1.  I would like to download a file from AS/400 to PC as a TAB delimited text.  However, I realised number decimal appears as '20000.' where it should be '20000.00'.  Is there somewhere to define the format during data transfer ?

2.  Can a delimitter be changed to '|' instead of TAB ?

 

Thanks,

Shir

Answer Wiki

Thanks. We'll let you know when a new response is added.

To download a file from AS/400 to PC as a TAB delimited text using iSeries Access:

Click on Actions then Receive file from host
Click on Details
From file type, select Tab delimited text

________________________________

1. How are you doing this transfer?
2. What is the structure of the field in your as/400 file?
Phil

Discuss This Question: 6  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
  • Gabe9527
    You could try using FTP to GET the file from the AS400...... Please note that you have to change the downloud to BINARY format before you start. This can be done in the command line (type "bin" hit enter)
    10,955 pointsBadges:
    report
  • Yorkshireman
    the number 20000 is the same as 20000.00 so the transfer is correct. You may wish to look at the presentation of the number to use an edit code/format which displays with 2 places of decimals. Client access allows download to csv format. THis will allow spreadsheets and db products to import correctly
    5,580 pointsBadges:
    report
  • christinec

    I am interested in the answer to question #2 above.

    1.  I would like to download a file from AS/400 to PC as a TAB delimited text.  However, I realised number decimal appears as '20000.' where it should be '20000.00'.  Is there somewhere to define the format during data transfer ?

    2.  Can a delimitter be changed to '|' instead of TAB ?  Any answers on this one please??

    10 pointsBadges:
    report
  • philpl1jb

    1. How are you doing this transfer?
    2. What is the structure of the field in your as/400 file?
    Phil

    49,540 pointsBadges:
    report
  • philpl1jb

    If this is a "pull" by your pc .. then on your pc go to control panel - regional and Language Options - Regional Options - Customize - List Separator and change it to |.

    Now pull the data down. 

    You will probably want to change the list separator back to ,

     

    49,540 pointsBadges:
    report
  • CharlieBrowne
    On the CPYTOIMPF command use STRDLM   '|'  
    41,370 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