All Forums Teradata Studio
mahesh 4 posts Joined 06/04
10 May 2016
How to perform partial string search in Teradata Studio History?

Hi,
Has anyone successfully perform partial string search in TD Studio history? Its easy to perform partial string search in SQL Assistant history, but same doesnt work on Teradata Studio History. In TD Studio history, I found that you can only search an entire entry (eg: a complete query, but not a string in a query). By the way, I am using 15.10.1.1 version.

Thanks, Mahesh Bank of America
fgrimmer 553 posts Joined 04/09
10 May 2016

Mahesh, The Studio SQL History's Find (Ctrl+F) action will search for strings that contain your value. Select a cell in the SQL History and right click to bring up the cell menu. Choose the Find menu option.

mahesh 4 posts Joined 06/04
11 May 2016

Thanks. For some reason It was not searching, after closing and re-opening, it worked. I still like SQL Assistant, search summary window showing all the result hitsĀ in a small window.

Thanks,
Mahesh
Bank of America

You must sign in to leave a comment.