I need to extract some data from db2 to a fixed length file so that it can be read by some Microsoft Access macros.
I don't think I'll have to join two or more tables - it may be coming all from one table.
(I'll post more info later, if this is the case.)
I need to be able to set the starting and ending positions of these fields so that the macro from access can move the data into its matching fields in the access tables.
Is there a way to do this from db2?
I was thinking of using the export utility to create a text file but I don't know too much about it.
The main thing is that I need to specify the column positions.
Thanks in Advance.
John
I don't think I'll have to join two or more tables - it may be coming all from one table.
(I'll post more info later, if this is the case.)
I need to be able to set the starting and ending positions of these fields so that the macro from access can move the data into its matching fields in the access tables.
Is there a way to do this from db2?
I was thinking of using the export utility to create a text file but I don't know too much about it.
The main thing is that I need to specify the column positions.
Thanks in Advance.
John