Import DELimited File Format Files to DB2 for OS/390 Tables with DB2 Connect 
Author Message
 Import DELimited File Format Files to DB2 for OS/390 Tables with DB2 Connect

Hello,

It sounds like a simple task- but in reality it is'nt:

Various sources provide us with data in the popular DELimited file format
and we want to import this data to tables on DB2 for OS/390 by means of DB2
Connect (V6.1). The DB2 Connect IMPORT Utility supports only IXF format for
remote (DRDA) databases, while the DB2 Connect LOAD Utility does not support
DRDA Databases at all (and in turn, the DB2 for OS/390 LOAD Utility does not
support DEL files...). We tried a work-around using MS Access, but even this
requires additional Visiual Basic coding as well as installation and
licensing MS-Access on many workstations. So my question is, if there is
another simple way or any free distributed tool to achieve loading DEL files
with DB2 Connect. Any hint & tip will be appreciated...

Walter SCHNEIDER
Telekom Austria Informations Technology



Tue, 02 Dec 2003 17:07:44 GMT
 Import DELimited File Format Files to DB2 for OS/390 Tables with DB2 Connect

Quote:

> Hello,

> It sounds like a simple task- but in reality it is'nt:

> Various sources provide us with data in the popular DELimited file format
> and we want to import this data to tables on DB2 for OS/390 by means of DB2
> Connect (V6.1). The DB2 Connect IMPORT Utility supports only IXF format for
> remote (DRDA) databases, while the DB2 Connect LOAD Utility does not support
> DRDA Databases at all (and in turn, the DB2 for OS/390 LOAD Utility does not
> support DEL files...).

Why not set up a 'transit' database on an NT workstation or suchlike
and import into this one, then write a VB program to get the data out
of the 'transit' database and insert it into the production database?

I haven't used replication myself, but replication from the 'transit'
database to the production database  might be a possibility as well.



Thu, 04 Dec 2003 12:42:12 GMT
 Import DELimited File Format Files to DB2 for OS/390 Tables with DB2 Connect
Okay, follow this through.
Use comma delimited exports from you favorite applications
FTP the file to the mainframe to get the character conversion
Have your freindly mainframe DBA code a set of control cards for the
table(s) you want, skipping the comma position between feilds
example xxx,yyy,zzz = feild1 (1,3), feild2 (5,7), feild3 (9,11), etc
load your tables using the mainframe load utility

This scenario can be a pain in the butt. It also works very well. All of the
steps involved can be automated so it very end-user proof :)

Robert Jans
DB2 for OS/390 DBA



Quote:

> > Hello,

> > It sounds like a simple task- but in reality it is'nt:

> > Various sources provide us with data in the popular DELimited file
format
> > and we want to import this data to tables on DB2 for OS/390 by means of
DB2
> > Connect (V6.1). The DB2 Connect IMPORT Utility supports only IXF format
for
> > remote (DRDA) databases, while the DB2 Connect LOAD Utility does not
support
> > DRDA Databases at all (and in turn, the DB2 for OS/390 LOAD Utility does
not
> > support DEL files...).

> Why not set up a 'transit' database on an NT workstation or suchlike
> and import into this one, then write a VB program to get the data out
> of the 'transit' database and insert it into the production database?

> I haven't used replication myself, but replication from the 'transit'
> database to the production database  might be a possibility as well.



Fri, 05 Dec 2003 13:18:39 GMT
 Import DELimited File Format Files to DB2 for OS/390 Tables with DB2 Connect
Hi Robert,
    comma delimited fields are normally variable in length. As

    field1,field..........2,field3,
    field......1, field.................2, field...3

    But you could write a simple Rexx proc to pad them out to be fixed length.

Bill

Quote:

> Okay, follow this through.
> Use comma delimited exports from you favorite applications
> FTP the file to the mainframe to get the character conversion
> Have your freindly mainframe DBA code a set of control cards for the
> table(s) you want, skipping the comma position between feilds
> example xxx,yyy,zzz = feild1 (1,3), feild2 (5,7), feild3 (9,11), etc
> load your tables using the mainframe load utility

> This scenario can be a pain in the butt. It also works very well. All of the
> steps involved can be automated so it very end-user proof :)

> Robert Jans
> DB2 for OS/390 DBA




> > > Hello,

> > > It sounds like a simple task- but in reality it is'nt:

> > > Various sources provide us with data in the popular DELimited file
> format
> > > and we want to import this data to tables on DB2 for OS/390 by means of
> DB2
> > > Connect (V6.1). The DB2 Connect IMPORT Utility supports only IXF format
> for
> > > remote (DRDA) databases, while the DB2 Connect LOAD Utility does not
> support
> > > DRDA Databases at all (and in turn, the DB2 for OS/390 LOAD Utility does
> not
> > > support DEL files...).

> > Why not set up a 'transit' database on an NT workstation or suchlike
> > and import into this one, then write a VB program to get the data out
> > of the 'transit' database and insert it into the production database?

> > I haven't used replication myself, but replication from the 'transit'
> > database to the production database  might be a possibility as well.



Fri, 05 Dec 2003 20:09:51 GMT
 Import DELimited File Format Files to DB2 for OS/390 Tables with DB2 Connect
Yes I remembered that comma delimited was variable length after I had sent
the original note but if I remember correctly, tab delimited lines your data
up in nice rows and columns. You would just need to remember to build the
load card correctly and watch for making the feilds too long..........

Robert


Quote:
> Hi Robert,
>     comma delimited fields are normally variable in length. As

>     field1,field..........2,field3,
>     field......1, field.................2, field...3

>     But you could write a simple Rexx proc to pad them out to be fixed
length.

> Bill


> > Okay, follow this through.
> > Use comma delimited exports from you favorite applications
> > FTP the file to the mainframe to get the character conversion
> > Have your freindly mainframe DBA code a set of control cards for the
> > table(s) you want, skipping the comma position between feilds
> > example xxx,yyy,zzz = feild1 (1,3), feild2 (5,7), feild3 (9,11), etc
> > load your tables using the mainframe load utility

> > This scenario can be a pain in the butt. It also works very well. All of
the
> > steps involved can be automated so it very end-user proof :)

> > Robert Jans
> > DB2 for OS/390 DBA




> > > > Hello,

> > > > It sounds like a simple task- but in reality it is'nt:

> > > > Various sources provide us with data in the popular DELimited file
> > format
> > > > and we want to import this data to tables on DB2 for OS/390 by means
of
> > DB2
> > > > Connect (V6.1). The DB2 Connect IMPORT Utility supports only IXF
format
> > for
> > > > remote (DRDA) databases, while the DB2 Connect LOAD Utility does not
> > support
> > > > DRDA Databases at all (and in turn, the DB2 for OS/390 LOAD Utility
does
> > not
> > > > support DEL files...).

> > > Why not set up a 'transit' database on an NT workstation or suchlike
> > > and import into this one, then write a VB program to get the data out
> > > of the 'transit' database and insert it into the production database?

> > > I haven't used replication myself, but replication from the 'transit'
> > > database to the production database  might be a possibility as well.



Sun, 07 Dec 2003 11:35:54 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Table Limit with DB2 Connect to DB2 for OS/390

2. Frontpage with DB2 Connect to OS/390 DB2 ?

3. MTS and DB2 Connect to DB2 OS/390

4. Access to DB2 for OS/390 via DB2 Connect

5. DB2 OS/390 crashing after connection via DB2 Connect

6. DB2 OS/390 LOG FILES

7. SQLUDF.H file for DB2 6.1 on OS/390

8. desire to move data from OS 390 DB2 to AS/400 DB2 using DTS

9. Load data from DB2 in NT to DB2 in OS/390

10. Creating DB2 SQL Procedures in DB2 version 6 on OS/390 (June 2000 PUT)

11. DB2 Conenct & DB2 on OS/390

12. Trigger working in DB2 for NT but not in DB2 on an OS/390-machine


 
Powered by phpBB® Forum Software