Xref: utzoo comp.databases:5264 comp.sys.ibm.pc:47001
Path: utzoo!utgpu!news-server.csri.toronto.edu!clyde.concordia.ca!mcgill-vision!bloom-beacon!eru!luth!sunic!mcsun!hp4nl!star.cs.vu.nl!aramich@cs.vu.nl
From: aramich@cs.vu.nl (Michielse ARA)
Newsgroups: comp.databases,comp.sys.ibm.pc
Subject: Getting DB2 tables to Data Manager
Message-ID: <6110@star.cs.vu.nl>
Date: 23 Mar 90 11:14:54 GMT
Sender: news@cs.vu.nl
Organization: Fac. Wiskunde & Informatica, VU, Amsterdam
Lines: 40


I'm looking for someone who's familiar with Data Manager (Query Manager)
running on IBM's PS/2, and who's willing to help me out on some
problems.

We run three DB2-(sub)systems in a MVS environment (IBM 3090 maninframe)
We allow  endusers to run queries against some databases using QMF
or SPUFI.

For cpu-consuming queries (we have a lot of them) we would
like to be able to download a DB2 table to DM (on PS/2).

In the OS/2 manual the following strategy is suggested :
      
 1 - export the data (using QMF) in QMF-format.
 2 - start a host-session (from the PS/2).
 3 - download the data using SQLQMFM  
 4 - import the data in Data Manager

Our problem with this strategy is that you'd have to create
a table in Data Maganager first which is an exact copy of the
DB2-table. (I'm talking about tables consisting of 50-150 columns).

An acceptable solution would be to EXPORT the CREATE-statements
as well and IMPORT them in Data Manager. (We can easily generate
them from our Data Dictionary or even the DB2-catalog).    
Is there an easy way to do this ?

Better would be to be able to update Data Managers catalog
to avoid executing a lot of CREATE statements.

Is there anyone who has tried this (succesfully) or knows
how the Data Manager catalog is physically stored ?
 
Any other information concerning Data Manager is also welcome.

Toine Michielse
Fac. Math. & Computer Sciences
V.U. Amsterdam.