Hello

SQL results was persistent on SQL Result view with RBD v.7.5.1.5. We run more than one queries once and watch results when it's needed but with RBD v.8.0.1 SQL results disappear after you clicked another execution or run a new one. Is this a bug or a planned change? (Note: I am sure SQL Results View Options are same on both versions.)

I am not sure if this is correct forum to ask this but can't find a better one, hope someone move if it is incorrect.

Thanks

Mehmet,

The SQL Results View (and the whole database development perspective) is functionality that we inherit from either Rational Application Developer or from Eclipse itself. I have noticed the same change when I was using the SQL tools.

I am checking to see if anyone knows if there is a way to control the behavior you are seeing. So far, I have not found any preference to control this behavior or found any information regarding this outside of the preferences that might help this.

Mehmet,

I found out this was a bug in RAD that we will pick up at some future point since we are built on RAD. It should work as you expect after that.

In Data Studio, I am trying to save the SQL history - not just the results tab but the SQL itself.  If I export or copy from the SQL history tab all I get is the results.  Does anyone know if its possible to copy the SQL from the history as well?  Data Studio has to be saving it somewhere, I haven';t been able to locate it.

What is your Data Studio version ?
I did It and It saved ok !

 

(SELECT A.CD, VRS, DT_VRS
   FROM PROD.TEST A
  WHERE A.DT_VRS =
       (SELECT MAX(DT_VRS)
          FROM PROD.TEST B
         WHERE B.CD       = A.CD
           AND ((B.VRS >= 92) OR
                (B.VRS  = 01)))
    AND A.CD >= 0 )
ORDER BY 1
Action type:     NLS missing message: OperationCommand_action_execute in: org.eclipse.datatools.sqltools.result.PluginResources
Profile name:    DB2P
Database:        DB2P
Execute time:    20/03/16 02:08

 
Query execution time => 188 ms
---------------------------------------------------------------------------------------

 CD    VRS        DT_VRS
 ----- ---------- ---------------
   105         95 18.11.15
   107         95 17.11.15
   149         95 22.10.15

I have 4.1.1

When I save the history it just saves the results.

Version OK !

I did some test and all same result.

You can tried to watch the SQL RESULT VIEW proferences.

I figured it out.  If you select a history item and right-click and select copy, it only copies the results but if you select save history it saves the SQL with it.

Thanks for your response Hsieh!