Load mainframe data 
Author Message
 Load mainframe data
I am new to UDB.  I am trying to load data from OS390 DB2 v5 data into
UDB v5.  The data was transferred to PC thru EXTRA!. But when I tried
to import or load data to UDB it always says not valid PC format. I
tried to transfer the data with different setting as text or binary.
Both got the same error message. Also what is the differences between
import and load?  Any help is appreciated.  Thanks.

Fred

Sent via Deja.com http://www.***.com/
Before you buy.



Sat, 24 Aug 2002 03:00:00 GMT
 Load mainframe data

Hello my Fred.

Try this:

CONNECT TO remote-OS390-DB; [with same userid and psw as net]
EXPORT TO local_disk\TMP\???.IXF OF IXF SELECT * FROM os390db.table; [or special-where-bedingung]
CONNECT RESET;
CONNECT TO local-instance; [bzw. Database]
LOAD FROM local_disk\TMP\???.IXF OF IXF INSERT INTO local-db.table-name;
TERMINATE;

Quote:

> I am new to UDB.  I am trying to load data from OS390 DB2 v5 data into
> UDB v5.  The data was transferred to PC thru EXTRA!. But when I tried
> to import or load data to UDB it always says not valid PC format. I
> tried to transfer the data with different setting as text or binary.
> Both got the same error message. Also what is the differences between
> import and load?  Any help is appreciated.  Thanks.

> Fred

> Sent via Deja.com http://www.deja.com/
> Before you buy.

  sven.schubert.vcf
< 1K Download


Sat, 24 Aug 2002 03:00:00 GMT
 Load mainframe data
The best way to do this is with DB2 Connect (which comes with DB2 UDB v5)
and export the data from OS390 in IXF format, and load or import this IXF
file on the workstation.
Quote:

> I am new to UDB.  I am trying to load data from OS390 DB2 v5 data into
> UDB v5.  The data was transferred to PC thru EXTRA!. But when I tried
> to import or load data to UDB it always says not valid PC format. I
> tried to transfer the data with different setting as text or binary.
> Both got the same error message. Also what is the differences between
> import and load?  Any help is appreciated.  Thanks.

> Fred

> Sent via Deja.com http://www.deja.com/
> Before you buy.



Sat, 24 Aug 2002 03:00:00 GMT
 Load mainframe data
How do I find out the location code? for installing DB2 connect.
Thanks.
Fred

Quote:

> The best way to do this is with DB2 Connect (which comes with DB2 UDB
v5)
> and export the data from OS390 in IXF format, and load or import this
IXF
> file on the workstation.


> > I am new to UDB.  I am trying to load data from OS390 DB2 v5 data
into
> > UDB v5.  The data was transferred to PC thru EXTRA!. But when I
tried
> > to import or load data to UDB it always says not valid PC format. I
> > tried to transfer the data with different setting as text or binary.
> > Both got the same error message. Also what is the differences
between
> > import and load?  Any help is appreciated.  Thanks.

> > Fred

> > Sent via Deja.com http://www.deja.com/
> > Before you buy.

Sent via Deja.com http://www.deja.com/
Before you buy.


Sun, 25 Aug 2002 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Mainframe DB2 Crawls During DTS Load

2. Loading mainframe files with more than 254 columns ?

3. Problems loading data: LOAD vs. DTS

4. Loading Xml Data returned from the query loaded into recordset

5. loading data dump from ASE 11.9 to ASE 12.0 sets it to offline after load

6. Error loading data via BUTIL -LOAD

7. MA-Boston-247978--Mainframe-ORACLE-COBOL-JCL-SAS-ORACLE-MVS-Mainframe Consultant

8. VA-Herndon-93524--COBOL II-DB2-IMS DB/DC-JCL-Mainframe-IBM Mainframe-MVS-ESA-ORA

9. VA-Herndon-93524--COBOL II-DB2-IMS DB/DC-JCL-Mainframe-IBM Mainframe-MVS-ESA-ORA

10. VA-Herndon-93524--COBOL II-DB2-IMS DB/DC-JCL-Mainframe-IBM Mainframe-MVS-ESA-ORA

11. VA-Herndon-93524--COBOL II-DB2-IMS DB/DC-JCL-Mainframe-IBM Mainframe-MVS-ESA-ORA

12. VA-Herndon-93524--COBOL II-DB2-IMS DB/DC-JCL-Mainframe-IBM Mainframe-MVS-ESA-ORA


 
Powered by phpBB® Forum Software