Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Resource Analyzer: Drop and Creating table queries not captured
Go
New
Search
Notify
Tools
Reply
  
Resource Analyzer: Drop and Creating table queries not captured
 Login/Join
 
Member
posted
We are executing code similar to what is listed below. However, we are not able to identify those queries that Drop or create a DB2 table. Is there something we need to add to our set up of RA? Or any other ideas on how we can identify those queries that Drop or create a DB2 table?


SQL DB2 SET SERVER WRK1
END
-*
SQL
DROP TABLE EDASVR.USER_CAR;
END
-*
TABLE FILE PRODDETL
PRINT ACCT_TYPE AS ACCT_TYPE
OPEN_ID AS OPEN_ID
OPEN_TIME AS OPEN TIME
BY ACCT_NUM AS ACCT_NUM
BY OPEN_DATE AS OPEN_DATE
ON TABLE HOLD AS USERACCT FORMAT DB2
END
-RUN
-*


WF 8.2.01M, MF MVS 7.6.5
 
Posts: 26 | Location: Milwaukee, WI | Registered: September 10, 2008Reply With QuoteReport This Post
Expert
posted Hide Post
Hi wdusbank,

This one seems to be an issue to be fixed by programming, so it should be addressed by a case with Information Builders' Customer Support Services. You may either call at 1-800-736-6130, or access online at InfoResponse.

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1950 | Location: New York | Registered: November 16, 2004Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Resource Analyzer: Drop and Creating table queries not captured

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.