04-07-2011 05:05 AM
Hi All,
We have serveral key reports in VBR that use temporary tables. They execute as expected (give results) in VBR and when run against OpsCenter using a direct ODBC link to the Database, but they give no output in the OpsCenter SQL report GUI.
Not true, they actually give a table with "Operation Status" as the heading and one row containing "Operation Is Success".
An example query would be:
CREATE TABLE #LJB_BASE_TABLE(
"first" varchar(20),
"second" varchar(20)
)
INSERT INTO #LJB_BASE_TABLE ("first","second")
VALUES ('FIRST RESULT','SECOND RESULT')
select "first" from #LJB_BASE_TABLE
drop table #LJB_BASE_TABLE
Has anyone experienced this problem? If so, what was your solution?
Thanks
L.J.B
08-11-2011 04:58 AM
Hi,
Does no one else use temporary tables in this way?
L.J.B
08-12-2011 05:00 AM
http://www.symantec.com/business/support/index?page=content&id=HOWTO43067