All Forums Third Party Software
mybudy 5 posts Joined 01/11
04 May 2011
Teradata SQL Parser

Topics related to the Teradata SQL Parser: Metadata Query, Parsing, formatting, analysis of SQL script, customizable SQL formatter, SQL syntax check

suhailmemon84 47 posts Joined 09/10
29 Jan 2013

Hi,
We have a requirement where I need to find what percentage of queries are querying recent data vs the percentage of queries that are querying historical data.
I went on google to find any sqlparser or some UDF that I can use with terdaata to extract out the where clause of every query in a format of "name=value" pairs that I can further use to get data for my requirement.
Do you know of any UDF/SQL parser that works with teradata?
I found one parser at sqlparser.com but it doesn't seem to be working.
Is anyone else doing this kind of anlaytics on sqltextinfo column of dbc.dbqlsqltbl?
Regards,
Suhail
 
 
 
 
 
 

You must sign in to leave a comment.