DB2 table to store special format data



IBM's flagship relational database management system

DB2 table to store special format data

Postby pgandhi671 » Tue Sep 15, 2009 11:11 pm

Hi,

My requirement is I am going to get flat file with all flavor like packed, date format, occurs 60 times and I have to create the table to store all the data how do I define or handle those special format?
pgandhi671
 
Posts: 2
Joined: Tue Sep 15, 2009 10:49 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 table to store special format data

 

Re: DB2

Postby dick scherrer » Wed Sep 16, 2009 1:08 am

Hello and welcome to the forum,

Leave the occurs behind - db2 doesn't support repeating groups. . .

You need to map the contents of the flat file to one or more database tables (if this has not already been done).

After creating the table(s), you would run a LOAD for each table. Will you create your own database tables or will the dba do this? Usually, developers do not have the proper permissions granted to create/drop tables. . .

Here is a link to the db2 info about creating a table (which also explains about data types):
http://publibz.boulder.ibm.com/cgi-bin/ ... sqj10/5.38

From the same manual, here is more info on data types:
http://publibz.boulder.ibm.com/cgi-bin/ ... nsqj10/2.9

The open book near the top-left of the page is the Table of Contents (which you'll want to bookmark).
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: DB2

Postby pgandhi671 » Wed Sep 16, 2009 1:40 am

Thank you so much
pgandhi671
 
Posts: 2
Joined: Tue Sep 15, 2009 10:49 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DB2

Postby dick scherrer » Wed Sep 16, 2009 1:45 am

You're welcome - good luck :)

d
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post