|
|
Archives of the TeradataForum
Message Posted: Thu, 17 Oct 2013 @ 22:17:22 GMT
Subj: | | PPI Revaildation |
|
From: | | Singh, Ravi Pratap |
Hi Folks,
I was looking for a way to identify tables whose PPI range is ending in 2013.? I know we could use DBC.IndexConstraints to get the PPI text.
But parsing that text manually seems to be a herculean task specially when there are tons of tables sitting in system. I did try to chop PPI text
down using substrings and cases but nothing seems to work perfectly.
Did anyone tried that before? Any insight will be helpful..!!
Regards,
Ravi
| |