<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><SPAN style="RIGHT: auto"><FONT style="RIGHT: auto" face=Calibri>
<div style="MARGIN: 0in 0in 10pt" class=MsoNormal>Hi Brian,</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>I have migrated powerhouse applications to windows <SPAN style="mso-spacerun: yes"> </SPAN>pointing to an oracle data on a unix platform</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>And <SPAN style="mso-spacerun: yes"> </SPAN>using ODBC to connect to it.</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p></div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>I have also done this with MS SQL Server</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing><o:p> </o:p></div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>Qshow looks at the database metadata area to display the table layouts</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing><o:p> </o:p></div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>Quiz will create a SQL statement to send thru the ODBC connection to the data base</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>And will display the result back and this will read the database table</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing><o:p> </o:p></div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>So setting up the tables in DB2 with the right user access is critical</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>User have to be granted access and user may have default access workspaces</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>Understanding how the DB2 works<SPAN style="mso-spacerun: yes"> </SPAN>and what is possible will let<SPAN style="mso-spacerun: yes"> </SPAN>determine what you can do</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing><o:p> </o:p></div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>If you can create a sql statement in db2 that does not need the in workspace syntax to retrieve data</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>This may be a combination of what workspace or no workspace <SPAN style="mso-spacerun: yes"> </SPAN>setup and the user rights /defaults</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing><o:p> </o:p></div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>On my reading of DB2 the tables are created in a workspace and users need to be granted access to this workspace in order to get at these tables</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>It seems that tables can be created without the workspace command</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>(you should try this as well – that may solve your problem)</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing><o:p> </o:p></div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>There is also a workspace PUBLIC – which may allow easier access to</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing><o:p> </o:p></div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>My suggestion:</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing><o:p> </o:p></div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>Create a table in DB2 using SQL statements</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>Insert some data into it</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>Create a user or use a user that has access to this workspace</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing><o:p> </o:p></div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>Create the ODBC connection in windows<SPAN style="mso-spacerun: yes"> </SPAN>-<SPAN style="mso-spacerun: yes"> </SPAN>with that user </div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>ODBC connection <SPAN style="mso-spacerun: yes"> </SPAN>can have default database or schema <SPAN style="mso-spacerun: yes"> </SPAN>setup in an advance tab area</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing><o:p> </o:p></div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>Determine if the odbc connection can retrieve data by using it as a data source for excel</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing><o:p> </o:p></div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>Add this odbc connection to the powerhouse dictionary using the user that has access to this area</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>Users may in DB2 have a default access to a workspace if one is not selected</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing><o:p> </o:p></div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>You may want to setup a user with access to only 1 workspace and public may have lower security thend others</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing><o:p> </o:p></div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>If this testing works, then look at how the powerhouse tables were setup in DB2 and what users</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>Were assigned and change this to the working solution</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing><o:p> </o:p></div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>You may also want to try the following:</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>-set a data base in MS SQL Server with some tables</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>- create the database and tables using dbo</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>- the ODBC connection to SQL Server can be set to a default database and the user could be sa</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>- add this connection to the powerhouse dictionary</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing><o:p> </o:p></div>
<div style="MARGIN: 0in 0in 0pt; RIGHT: auto" class=MsoNoSpacing>You can have many ODBC connections, name differently with a different default set for each one</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing><o:p> </o:p></div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>DB2 has a way to connect to external non-DB2 data bases, and you may be able to do this</div>
<div style="MARGIN: 0in 0in 0pt; RIGHT: auto" class=MsoNoSpacing>With the MS SQL Server</div>
<div style="MARGIN: 0in 0in 0pt; RIGHT: auto" class=MsoNoSpacing> </div>
<div style="MARGIN: 0in 0in 0pt; RIGHT: auto" class=MsoNoSpacing>in windows, users can be given their startup commands, that could point to their own dictionary</div>
<div style="MARGIN: 0in 0in 0pt; RIGHT: auto" class=MsoNoSpacing>that has the odbc connection for them - this is very easy to do<VAR id=yui-ie-cursor></VAR></div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing><o:p> </o:p></div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>If you want to contact me directly, you can email<SPAN style="mso-spacerun: yes"> </SPAN>at <A href="mailto:ken_weiland@yahoo.com">ken_weiland@yahoo.com</A></div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>Let me know how you make out</div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing><o:p> </o:p></div>
<div style="MARGIN: 0in 0in 0pt" class=MsoNoSpacing>Ken</div>
<div style="MARGIN: 0in 0in 10pt; RIGHT: auto" class=MsoNormal></FONT></div></SPAN></div></body></html>