L2hvbWUvdml2ZWs6IGVjaG8gJnF1b3Q7JHRlc3QmcXVvdDsKSGV3bGV0dCBQYWNrYXJkIEVudGVycHJpc2UgTm9uU3RvcChUTSkgU1FML01YIENvbnZlcnNhdGlvbmFsIEludGVyZmFjZSAzLjcKKGMpIENvcHlyaWdodCAyMDAzLTIwMTkgSGV3bGV0dCBQYWNrYXJkIEVudGVycHJpc2UgRGV2ZWxvcG1lbnQgTFAuCiZndDsmZ3Q7U0VMRUNUIHN1YnN0cmluZyhzdWJzdHJpbmcodG5hbWUgZnJvbSAoMStsb2NhdGUoJy4nLHRuYW1lKSkpLAorJmd0OygxK2xvY2F0ZSgnLicsc3Vic3RyaW5nKHRuYW1lIGZyb20gKDErbG9jYXRlKCcuJyx0bmFtZSkpKSkpLDE1ICkgYXMgVEFCX05BTUUKKyZndDtGUk9NIHRhYmxlKGV4cGxhaW4oJy9ob21lL3ZpdmVrL01GQ0FCUzEwMzFWQ0FULlZTQ0guQTlCNjkzOTVBRTMyMzhBNDE4NEE5MENEMUYyOEMxNjEnLCAnJScpKQorJmd0O1dIRVJFIE9QRVJBVE9SIExJS0UgJyVGSUxFX1NDQU4lJzsKClRBQl9OQU1FCi0tLS0tLS0tLS0tLS0tLQoKVEVTVDEKCi0tLSAxIHJvdyhzKSBzZWxlY3RlZC4KJmd0OyZndDtleGl0OwoKRW5kIG9mIE1YQ0kgU2Vzc2lvbgovaG9tZS92aXZlazo=
/home/vivek: echo "$test"
Hewlett Packard Enterprise NonStop(TM) SQL/MX Conversational Interface 3.7
(c) Copyright 2003-2019 Hewlett Packard Enterprise Development LP.
>>SELECT substring(substring(tname from (1+locate('.',tname))),
+>(1+locate('.',substring(tname from (1+locate('.',tname))))),15 ) as TAB_NAME
+>FROM table(explain('/home/vivek/MFCABS1031VCAT.VSCH.A9B69395AE3238A4184A90CD1F28C161', '%'))
+>WHERE OPERATOR LIKE '%FILE_SCAN%';
TAB_NAME
---------------
TEST1
--- 1 row(s) selected.
>>exit;
End of MXCI Session
/home/vivek: