File Download problem Through AS/400 Console

365 pts.
Tags:
AS/400 Transfer
I have problem while opening my files in *.dtt format. My IT team member have installed IBM client/access Express DB file software in my PC. In green console I am selecting data transfer from system I.Then iam saving the file to my desktop. Iam giving the file name in as/400 and then I am going to File and selecting Save us .and saving the format as *.dtt in my local desktop. The file is saving in my desktop. If I try to open the sheet Iam getting the error “It is either not a transfer file request type, or the file has been corrupted” .But in my old PC I have “IBM client/access for XP ecore 3.02” using this I can open the file without problem .Do we need to change any setting in IBM client/access Express DB file ? .Or do I need to uninstall the software and go back to IBM client/access for XP ecore 3.02 .Could you kindly advice Version using : V5R3 OS: Windows XP

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
    IBM client/access Express DB Can you clarify what that is? Is that the iSeries Access Data Transfer component? What version of iSeries Access do you have installed? What service pack level do you have installed? Go through the PC's Startup-> Programs menu into the iSeries Access portion and run iSeries Access for Windows Properties to see the version and the SP level. Tom
    125,585 pointsBadges:
    report
  • DoneThat
    .dtt & .fdf files are straight text. Here is an example of each for a typical Excel upload. Examine yours and make sure they are similar.
    [DataTransferToAS400]
    Version=1.0
    [HostInfo]
    HostName=192.168.52.26
    HostFile=RAP002001/PRODTRAN
    FRFFile=
    CrtOpt=2
    HostFileType=1
    ObjAuth=0
    RecLen=92
    FileText=
    MbrText=
    [ClientInfo]
    PCFile=\SeeligserverSharedOperationsCustomersPriceQuotesProdno Translation To AS400.xls
    UseFDF=1
    PCFileType=16
    FDFFile=\SeeligserverSharedOperationsCustomersPriceQuotesProdno Translation To AS400.FDF
    ConvType=0
    SendExtraSheets=31
    [Properties]
    Check4Untrans=0
    Convert65535=0
    ConvertTabs=0
    Notify=1
    AutoRun=0
    AutoClose=0
    ShowWarnings=0
    UserOption=0
    
    PCFDF
    PCFT 16
    PCFO 1,1,1,1,1
    PCFL pxl_Compno 1 6
    PCFL pxl_ExtPro 1 20
    PCFL pxl_ExtGAF 1 20
    PCFL pxl_GAFPro 2 9
    PCFL pxl_ExtPr2 1 20
    PCFL pxl_ExtDsc 1 50
    PCFL pxl_ExtVol 1 20
    PCFL pxl_ExtSBy 1 20
    PCFL pxl_ExtUOM 1 2
    PCFL pxl_ExtBrd 1 20
    PCFL pxl_GAFDsc 1 18
    PCFL pxl_GAFVol 1 8
    PCFL pxl_GAFSBy 1 9
    PCFL pxl_ToExtF 2 11/5
    
    Gary
    830 pointsBadges:
    report
  • naresh1984
    Yes .. its is iSeries Access Data Transfer component ..
    365 pointsBadges:
    report
  • naresh1984
    Gary .. we are trying to download from As/400 to local PC in the excel format .The given answer is not clear ..
    365 pointsBadges:
    report
  • naresh1984
    Hi Tom,,,, Kinldy find the version details ... V5 R1 M0 .. SI01907 IBM AS/400 Client Access Express for Windows
    365 pointsBadges:
    report
  • DoneThat
    "we are trying to download from As/400 to local PC in the excel format " Not sure I understand the question now. A *.DTT file is a def file meaning Data Transfer TO AS400...I.E. UPloading. The associated *.FDF is a File Definition File for Client Express to parse each field. I remember when trying to create/save these files using Client Express, the sequence was very obtuse and I would end up with invalid DTT files. I gave you an example of each so you could examine your DTT & FDF to make sure you have valid forms of each. When you double click a DTT file, a data file will be UPloaded to the AS400. If you truly want to DOWNload FROM the AS400 to the PC - that's a DTF file. Same principle. If you need and example - I'll post it. BTW: I create them all manually now by copying working DTF, DTT & FDF files & changing them. I find it much easier to create & faster to test. Gary
    830 pointsBadges:
    report
  • TomLiotta
    I am going to File and selecting Save us .and saving the format as *.dtt in my local desktop. The file is saving in my desktop. If I try to open the sheet Iam getting the error “It is either not a transfer file request type, or the file has been corrupted” This is part that is confusing -- "saving the format as *.dtt". Are you trying to save the downloaded data as a .DTT file? Or are you saving the transfer request as a .DTT file? Gary is also correct that a .DTT file is expected to be an upload request, not a download request. This error -- "It is either not a transfer file request type, or the file has been corrupted" -- implies that the data is being saved with a .DTT extension. A different extension should be used. V5 R1 M0 .. SI01907 And that indicates the first service pack after V5R1 Client Access was available, from just over ten years ago. It is very out of date. Tom
    125,585 pointsBadges:
    report
  • naresh1984
    Yes tom. Thats correct .the problem is with verstion .We have installed the latest client access and tried .its working ...
    365 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