Question about Computers & Internet
I want to convert the CSV File to AS/400 so pls give the steps to do it. And moreover i have completed 50% of the work by File transfering protocol and when i use the command cpyfrmimpf it says error 11 and file not copied so pls clarify a clear steps to proceed. thx...
FTP is "line oriented." It has no concept of 'database record formats.' It transfers strings of characters with essentially no knowledge of 'fields' or 'columns' that make up 'records.' A 'record' to FTP is usually just whatever string of characters that is found between record delimiters.
Trying to FTP into a DB2 externally-described database file requires having strings of characters that are (1) laid out to match the receiving record format and (2) either are already converted to the proper CCSID and transferred as BINARY, or are ASCII characters that would result in conversions to all the right characters and transferred as ASCII.
Regardless of which alternative is chosen for "(2)", the handling of record format positions that would match up with packed-decimal or other non-character type fields would be very tricky.
That's where a somewhat 'standard' file format such as .CSV comes in.
However, you don't transfer the .CSV file directly over the top of the DB2 file. Instead, you transfer the .CSV file into a simple directory on your AS/400 and then use it as the source for a DB2 import function. On your AS/400, the import function is most often the CPYFRMIMPF command.
The import takes the .CSV file and handles all of the mappings for field positions and data types.
As such, the sequence becomes (1) FTP the .CSV file to the AS/400, and (2) run CPYFRMIMPF on the AS/400.
Note that the format of the .CSV file makes a difference. You need to ensure proper CCSID settings, proper quoting where necessary, proper record separators, etc. Make sure that you generate a .CSV that can be converted to the record format of the eventual target database file. Lots of possible details, but _far_ easier than trying to construct a matching DB2 record format on a different platform.
Posted on Sep 16, 2009
If you have an ODBC driver for your database on the AS400 and MS SQL server?s tools installed, you can use SSIS from SQL server to parse and import the CSV file into a table in your AS400. IF you do not have access to SQL server, contact me I have tools to do this with out SQL Server, but you will need an ODBC driver, and it would help to know what you are putting the data in on an AS400, but you could be running many different platforms and storing the data in many formats. Good Luck
Posted on Oct 01, 2007
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Nov 07, 2014 | Computers & Internet
Sep 06, 2013 | Panduit PanTher LS8E-KIT Hand-Held Thermal...
Jan 02, 2011 | Clickaction MyMailList & AddressBook...
Oct 03, 2017 | Computers & Internet
Jun 10, 2010 | HP LaserJet M5035 MFP Printer
Nov 13, 2009 | Microsoft Computers & Internet
Aug 21, 2009 | Canon imageRUNNER C3200 Copier
Apr 27, 2009 | Microsoft Office Excel 2003 for PC
Jan 11, 2008 | Symbol MC9060
Mar 22, 2018 | The Computers & Internet
2,595 people viewed this question
Usually answered in minutes!