We have a requirement of loading the data from mainframe DB2 to AIX.
One way of loading the data across platforms is by using DB2 connect we can export and import the data from DB2 mainframe to aix and vice versa .
What are the other possible ways to load the data from DB2 mainframe to AIX.
Please provide me suggestions if any.
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
When downloading data from mainframe database, one way that works well is to create a delimited file (the tab character works well - x'05') and make sure all numeric values are converted to an edited value that contains the decimal point (if appropriate) and the minus sign for negative numbers.
Once the file has been created, downloading to the target system may be done using ftp.