Archives of the TeradataForum
Message Posted: Thu, 17 Oct 2013 @ 22:17:22 GMT
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..!!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|