IBM Mainframe Forum

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?

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).

Thank you so much

You're welcome - good luck

d