嗨,我正在使用bash脚本。 在这里,我执行这段代码。
/usr/bin/mxci <<EOF
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%';
EOF'
这将返回输出为
>>SELECT substring(substring(tname from (1+locate('.',+>(1+locate('.',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;
现在我知道如何将整个输出存储到单个变量中并打印出来,但是我不知道如何将部分信息存储到变量中。 就像如果我只想将TEST1存储到变量中,该怎么办。
预先感谢
可变测试的输出
/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('.','%'))
+>WHERE OPERATOR LIKE '%FILE_SCAN%';
TAB_NAME
---------------
TEST1
--- 1 row(s) selected.
>>exit;
End of MXCI Session
/home/vivek: