In article <[log in to unmask]>, "Gopalakrishnan, Thiyagarajan
(Cognizant)"              <[log in to unmask]> writes:

>,
>   I had been facing one problem regarding Suprtool Extraction.Whether it is
>possible to extract the entire data base and put it into the flat
>file(instead of doing it for each and every dataset in the database)..If
>possible..how we can do it???..where i can get information regarding this...
>

I don't think you want to put it in one file ... you may however wish to run a
batch job which extracts all of the files into separate flatfiles each named
differently ... or you could be looking at UDACentral from MBFoster to build
the same structure in Oracle or Sql Server and then move the data between
platforms ....

It is useful to consider why you are moving the data and what needs to be moved
... you may not want to convert some of the older history at the detail level
.... rather convert it to a summarized by LOB or date range, sales territory
eetc.

You will also probably have to think about dates 99999999 is not a valid date
if you are importing to Eloquence, and spaces in numeric fields won't move over
either ... you really need to think about how you Extract, Transform, Clean,
and Load.

Birket

PS there are lots of ways to do this see our website at MBFoster.com or the
spreadshet of products a www.hp.com/go/e3000partners


Birket Foster
M. B. Foster Associates .. the 1-800-ANSWERS people!
Supplying UDALink w/cross-platform ODBCLink Option (3000,9000&NT)
See how DataExpress has evolved www.MBFoster.com
EC/EDI(3000,9000,NT) Phone (613) 448-2333 or (613) 448-2588(FAX)

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *