为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM7.6
【操作系统】:window64位
【CPU】:intel
【问题描述】:
spool输出查询结果到文件时如何避免终端同时显示查询结果:
想要的结果是:
SQL>spool D:\b.sql
SQL>select top 5 from sysobjects;
SQL>spool off
实际的结果是:
SQL> spool D:/b.sql
SQL> select top 5* from sysobjects;
行号 NAME ID SCHID TYPE$ SUBTYPE$ PID VERSION
CRTDATE INFO1 INFO2 INFO3 INFO4 INFO5
--------------------------- ----------- ----------- -------------------- -------------------- ----------
INFO6 INFO7 INFO8
---------------------------------------------------------------------- -------------------- ----------
VALID
-----
1 ##TMP_TBL_FOR_DBMS_LOB_BLOB 268436861 0 DSYNOM NULL NULL 0
2020-11-12 10:13:34.138000 1 NULL NULL NULL NULL
0x03005359531B002323544D505F54424C5F464F525F44424D535F4C4F425F424C4F42 NULL NULL
Y
行号 NAME ID SCHID TYPE$ SUBTYPE$ PID VERSION
CRTDATE INFO1 INFO2 INFO3 INFO4 INFO5
--------------------------- ----------- ----------- -------------------- -------------------- ----------
INFO6 INFO7 INFO8
---------------------------------------------------------------------- -------------------- ----------
VALID
-----
2 ##TMP_TBL_FOR_DBMS_LOB_CLOB 268436860 0 DSYNOM NULL NULL 0
2020-11-12 10:13:34.138000 1 NULL NULL NULL NULL
0x03005359531B002323544D505F54424C5F464F525F44424D535F4C4F425F434C4F42 NULL NULL
Y
行号 NAME ID SCHID TYPE$ SUBTYPE$ PID VERSION
CRTDATE INFO1 INFO2 INFO3 INFO4 INFO5
--------------------------- ----------- ----------- -------------------- -------------------- ----------
INFO6 INFO7 INFO8
---------------------------------------------------------------------- -------------------- ----------
VALID
-----
3 <ADT_1> 268436850 0 DSYNOM NULL NULL 0
2020-11-12 10:13:33.755000 1 NULL NULL NULL NULL
0x068053595344424107003C444D414F543E NULL NULL
Y
行号 NAME ID SCHID TYPE$ SUBTYPE$ PID VERSION
CRTDATE INFO1 INFO2 INFO3 INFO4 INFO5
--------------------------- ----------- ----------- -------------------- -------------------- ----------
INFO6 INFO7 INFO8
---------------------------------------------------------------------- -------------------- ----------
VALID
-----
4 ALL_ALL_TABLES 268436746 0 DSYNOM NULL NULL 0
2020-11-12 10:13:31.881000 1 NULL NULL NULL NULL
0x03005359530E00414C4C5F414C4C5F5441424C4553 NULL NULL
Y
行号 NAME ID SCHID TYPE$ SUBTYPE$ PID VERSION
CRTDATE INFO1 INFO2 INFO3 INFO4 INFO5
--------------------------- ----------- ----------- -------------------- -------------------- ----------
INFO6 INFO7 INFO8
---------------------------------------------------------------------- -------------------- ----------
VALID
-----
5 ALL_COL_COMMENTS 268436776 0 DSYNOM NULL NULL 0
2020-11-12 10:13:31.981000 1 NULL NULL NULL NULL
0x03005359531000414C4C5F434F4C5F434F4D4D454E5453 NULL NULL
Y
5 rows got
已用时间: 123.460(毫秒). 执行号:376.
SQL> spool off;
目前不支持,我们提一个需求上去,有新版本通知您