Skip to Content
0
Former Member
Jul 25, 2016 at 06:38 AM

extract / file not created

67 Views

Hi, Experts

Env

---------

IQ 15.4

OS : Linux

env|grep SQLCONNECT

SQLCONNECT=uid=DBA;pwd=password;eng=RBADB

/tmp> dbisql -nogui ext.sql

---> NO ERROR BUT no file was created (a.dat)

/***************** ext.sql (bof) *************************/

set temporary option temp_extract_name1= '/tmp/a.dat';

select * from tab_a;

set temporary option temp_extract_name1='';

/****************** (eof) *********************************/

But not using script file( ext.sql)

Extracted file is created successfully without error ....

What is the problem ???

Thanks in advance