2014年
-
编辑 删除
Essbase Data Load Troubleshooting
When Hyperion Essbase cannot load a record, it writes the record to the file calledDATALOAD.ERR on the client.There is a limit to the number of records that an error log can contain. The default limit is 1000 records, but you can set the limit to be higher or lower than 1000 by setting DA...
-
编辑 删除
用批处理文件调用sql脚本导出Oracle数据库查询结果到csv文件
1. sql脚本文件ctl.sql使用这种SET命令的组合能生成标准CSV文件，文件最后两行为导出记录数和所用时间。--------------------------------------------------------SET PAGESIZE 0;SET LINESIZE 1000;SET TRIMSPOOL ON;SET TERMOUT OFF;SET TIMING ON;spool output.csv;SELECT '"'||col1||'","'|...
