auto extraction of data

[sanketr]

hi everyone!!
i was just wondering if it is possible to extract data automatically from some 'standard' file format and putting it under the DB2 database fields.its just a vague idea but i think it might be possible...if u have ever heard of anything like this ever please let me know about it....the slightest of guidance from all u pro's can help me find what i am looking forward...
thanks for ur help
take care
sanket

 

[stevexff]

Do you have any particular 'standard' format in mind? The question is a little too abstract without this information.

 

[blom0344]

Such as scheduling an import of a textfile to a certain database (table)?

T. Blom
Information analyst
tbl@shimano-eu.com

 

[McRickFSU]

DB2 UDB v8:
If the source data is in DB2 you can load from a cursor:

declare mycursor cursor for select * from my.table1
load from mycursor of cursor method P(1,2,3) insert into
my.table2(one,two,three)
(Not sure if that would work with a federated table to Oracle or not - seems like it would.)

Or look at the EXPORT utility - it will do a lot in this area.