Difference: COOL220ExecutionPlanProblem (1 vs. 2)

Revision 22007-09-13 - RomainBasset

Line: 1 to 1
 
META TOPICPARENT name="ToDoList"
SELECT O."OBJECT_ID", 

Revision 12007-09-13 - RomainBasset

Line: 1 to 1
Added:
>
>
META TOPICPARENT name="ToDoList"
SELECT O."OBJECT_ID", 
   O."CHANNEL_ID", 
   O."IOV_SINCE", 
   O."IOV_UNTIL", 
   O."USER_TAG_ID",
   O."SYS_INSTIME",
   O."LASTMOD_DATE",
   O."ORIGINAL_ID",
   O."NEW_HEAD_ID",
   O."S"
FROM ST_CLIENT."PDBST002_F0001_IOVS" O,
   ST_CLIENT."PDBST002_F0001_CHANNELS" C 
WHERE C."HAS_NEW_DATA" = :"hasNewData" 
AND C."LAST_OBJECT_ID" = O."OBJECT_ID" 
ORDER BY C."CHANNEL_ID" ASC

-- RomainBasset - 13 Sep 2007

 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback