Synametrics Technologies

I love this program to death. Waiting on accounting to approve the $$$ to get a few copies of it. In the meantime I do have 1 question regarding the VIEW DDL within a "View" (or object) for SQL Server 2005. How is this being done? Within SSMS (SQL Server Management Studio) you cannot view system created objects. Yet WinSQL has no issues with them. Click on "View DDL" and BOOM...there's the code. I can do it, somewhat, withing a query but I don't get as much information as WinSQL does. Is there any way to tell me how that is done within WinSQL? Thanks again for a great product!

John, WinSQL queries system tables in MS SQL Server. The definition for every view is stored in these tables. SSMS just does not display the DDL from these tables. Peter. >I love this program to death. Waiting on accounting to approve the $$$ to get a few >copies of it. In the meantime I do have 1 question regarding the VIEW DDL within >a "View" (or object) for SQL Server 2005. > >How is this being done? Within SSMS (SQL Server Management Studio) you cannot view >system created objects. Yet WinSQL has no issues with them. Click on "View DDL" >and BOOM...there's the code. I can do it, somewhat, withing a query but I don't get >as much information as WinSQL does. Is there any way to tell me how that is done >within WinSQL? > >Thanks again for a great product!

I'm trying to use this same feature to view the DDL definition for a VIEW created in an iSeries DB2 system. However, when I click on the "DDL" option, nothing happens. I thought this may be due to limitations on the version of WinSQL since I'm currentyl running on the 30day trial version. Can you shed some light into this? -tx >I love this program to death. Waiting on accounting to approve the $$$ to get a few >copies of it. In the meantime I do have 1 question regarding the VIEW DDL within >a "View" (or object) for SQL Server 2005. > >How is this being done? Within SSMS (SQL Server Management Studio) you cannot view >system created objects. Yet WinSQL has no issues with them. Click on "View DDL" >and BOOM...there's the code. I can do it, somewhat, withing a query but I don't get >as much information as WinSQL does. Is there any way to tell me how that is done >within WinSQL? > >Thanks again for a great product!

Sorry for the double post... I failed to click on the "Notify me" option before... I'm trying to use this same feature to view the DDL definition for a VIEW created in an iSeries DB2 system. However, when I click on the "DDL" option, nothing happens. I thought this may be due to limitations on the version of WinSQL since I'm currentyl running on the 30day trial version. Can you shed some light into this? -tx >I love this program to death. Waiting on accounting to approve the $$$ to get a few >copies of it. In the meantime I do have 1 question regarding the VIEW DDL within >a "View" (or object) for SQL Server 2005. > >How is this being done? Within SSMS (SQL Server Management Studio) you cannot view >system created objects. Yet WinSQL has no issues with them. Click on "View DDL" >and BOOM...there's the code. I can do it, somewhat, withing a query but I don't get >as much information as WinSQL does. Is there any way to tell me how that is done >within WinSQL? > >Thanks again for a great product!

Hi, I think the plugin that comes with WinSQL is for DB2/UDB, not for iSeries. Try running WinSQL in debug mode to see what sort of errors you are getting. Refer to http://web.synametrics.com/DebugMode.htm for details on debug mode. Peter. >Sorry for the double post... I failed to click on the "Notify me" option before... > >I'm >trying to use this same feature to view the DDL definition for a VIEW created in an >iSeries DB2 system. However, when I click on the "DDL" option, nothing happens. >I thought this may be due to limitations on the version of WinSQL since I'm currentyl >running on the 30day trial version. Can you shed some light into this? > >-tx > > >>I love this program to death. Waiting on accounting to approve the $$$ to get a >few >>copies of it. In the meantime I do have 1 question regarding the VIEW DDL within >>a >"View" (or object) for SQL Server 2005. >> >>How is this being done? Within SSMS (SQL Server Management Studio) you cannot view >>system >created objects. Yet WinSQL has no issues with them. Click on "View DDL" >>and BOOM...there's the code. I can do it, somewhat, withing a query but I don't >get >>as much information as WinSQL does. Is there any way to tell me how that is done >>within >WinSQL? >> >>Thanks again for a great product!

Peter, Here's what I got from the debug log: 12/21/2009 10:21:55 AM; SQL Error State:S0002, Native Error Code: FFFFFF34, ODBC Error: [IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0204 - VIEWS in SYSCAT type *FILE not found. 12/21/2009 10:21:55 AM; Error: Unable to run SQL query. SQL0204 - VIEWS in SYSCAT type *FILE not found. Sure enough, it looks like this does not work with the iSeries. Any suggestions? How else could I get the definition for a VIEW once created? -tx >Hi, > >I think the plugin that comes with WinSQL is for DB2/UDB, not for iSeries. Try running >WinSQL in debug mode to see what sort of errors you are getting. Refer to http://web.synametrics.com/DebugMode.htm >for details on debug mode. > > >Peter. > > > > > >>Sorry for the double post... I failed to click on the "Notify me" option before... >> >>I'm >>trying >to use this same feature to view the DDL definition for a VIEW created in an >>iSeries DB2 system. However, when I click on the "DDL" option, nothing happens. > >>I thought this may be due to limitations on the version of WinSQL since I'm currentyl >>running >on the 30day trial version. Can you shed some light into this? >> >>-tx >> >> >>>I love this program to death. Waiting on accounting to approve the $$$ to get a >>few >>>copies >of it. In the meantime I do have 1 question regarding the VIEW DDL within >>>a >>"View" (or object) for SQL Server 2005. >>> >>>How is this being done? Within SSMS (SQL Server Management Studio) you cannot view >>>system >>created >objects. Yet WinSQL has no issues with them. Click on "View DDL" >>>and BOOM...there's the code. I can do it, somewhat, withing a query but I don't >>get >>>as >much information as WinSQL does. Is there any way to tell me how that is done >>>within >>WinSQL? >>> >>>Thanks again for a great product!