upload a pc file to as/400 iseries

25 pts.
Tags:
AS/400 DB2
i wnat to upload a pc file of length 311 with 25 fields to iseries. I followed the steps specified in waltz400 on july 13th 2005.But i got a messags saying "CWBTF0005-data in this field incorrect(row1,colomn1)or does not match the pc data type" . sINCE THE FILE SIZE IS BIGGER I COULDN'T SAVE IT AS A TEXT FILE AND UPLOAD. PLS HELP ON THIS

Answer Wiki

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

I have had the same troubles. is the file an Excel .xls format?

If so the problem is if you have alpha and fields that are all numerics in the same column.

Try saving it as a .CSV format and try teh upload again.

I have better results this way.

Discuss This Question: 7  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
    I followed the steps specified in waltz400 on july 13th 2005. Waltz400 probably said some useful things. If you let us know where he said them, maybe we could see how they relate to your problem. Could you supply us with a link? But i got a messags saying "CWBTF0005-data in this field incorrect(row1,colomn1)or does not match the pc data type" . The definition of the database file doesn't match the data you're trying to upload. We need to see at least one of the rows you're trying to upload and the definition of the database file. Without those, we can't tell anything more than what you already were told -- the data in the PC file doesn't match the description of the database. We can't guess why that's true. sINCE THE FILE SIZE IS BIGGER I COULDN'T SAVE IT AS A TEXT FILE AND UPLOAD. Since the file size is "bigger" than... what? What is it bigger than? How does that stop you from saving it as a text file? Does an error message appear? (What message? Where do you see it? When do you see it?) Tom
    125,585 pointsBadges:
    report
  • philpl1jb
    Waltz400 instructions will work 1.. create as/400 file 2. download that file to your pc using client access transfer to a cvs file format. That gives you an .fdf file with the description of the transfer 3. save you xls file as a cvs file -- doesn't matter how big it is. Make sure that there aren't any column heading text or other stray text on the sheet..especially in numeric columns 4. use client access to upload the cvs file to the 400 using the .fdf file you created in step 2. Phil
    50,205 pointsBadges:
    report
  • Pc1964
    thanks phil. I tried with .csv file as well as .cvs files. But same message is comming. Yes and the excel file consists of alpha as well as numeric columns in the same record. Pls tell me how to overcome with this problem.
    25 pointsBadges:
    report
  • devan
    Hi create your spreasheet as a .prn and make sure you have a .fdf file and try to upload that way... if you still having a problem then email me on dmaistry@sn.co.za send me your excell file and I will give you detailed step by step mon how to sort this problem out.. Cheers
    390 pointsBadges:
    report
  • Vatchy
    Did you make sure that the fields in the file that you created matched the fields in the spreadsheet? All 25 fields? Also, if you are using iSeries Access, there is an add-in for Excel that lets you transfer files directly to and from the AS/400.
    1,410 pointsBadges:
    report
  • philpl1jb
    We are just guesing at your proble but if you provide these we maybe able to help more. 1 please post the dds of your file 2. the fdf that you are using 3. a copy of the first 2 lines of the .cvs file Phil
    50,205 pointsBadges:
    report
  • Pc1964
    thank you for all the help I was able to upload the file through the excel add-in. It is easy no need to save the excel file as.prn or .cvs. For your information the steps are as follows Excel - Data - data transfer to iseries thank you again priyantha
    25 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