|
|
|
Forum Member
 
Group: Forum Members
Last Login: 1/25/2007 11:21:00 AM
Posts: 25,
Visits: 1
|
|
Hello Everyone,
I have written the following code to extract data to a file
LOGON -------;
DATABASE ---- ;
SET ERROROUT STDOUT;
SET WIDTH 500;
SET ECHOREQ OFF;
SET TITLEDASHES OFF;
EXPORT REPORT FILE="/werr1/we1s/ws/ABX_log";
select * from DBC.Tables;
EXPORT RESET
LOGOFF;
QUIT ;
I am getting an error
*** Error: Open failed because: No such file or directory
Can someone help me out?
Thanks
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 8/1/2006 12:37:00 PM
Posts: 22,
Visits: 1
|
|
Hi,
the only think to suggest is that some subdirectory from
/werr1/we1s/ws/ABX_log
does not exist.
The Code is Ok except, you must have received some Warnings such:
"*** Warning: Expected a '.' before the command"
from command bteq.
The folowing code doesn't make arnings:
.LOGON ----;
DATABASE ----;
.SET ERROROUT STDOUT;
.SET WIDTH 500;
.SET ECHOREQ OFF;
.SET TITLEDASHES OFF;
.EXPORT REPORT FILE="/werr1/we1s/ws/ABX_log";
select * from DBC.Tables where DatabaseName='mydb' AND TableKind='T';
.EXPORT RESET
.LOGOFF;
.QUIT ;
greeting
stami
|
|
|
|