Hi,

I am trying to hold the data in my server to do the report directly against that data. But unfortunately I am not able to store the data and always getting "File doesn't exist" error.

My code will be like


-SET &DIR='\\SERVER\IBI\APPS\BASEAPP';
DOS STATE &DIR.EVAL
-RUN

-IF &RETCODE EQ 0 GOTO DIREXIST;
DOS MD &DIR
-RUN
-DIREXIST

FILEDEF CDSDAT DISK &DIR|CDSDAT.FTM
-RUN

TABLE FILE CAR
PRINT
CAR
BY COUNTRY
ON TABLE HOLD AS CDSDAT
END
-EXIT


Any suggestions/thoughts will be helpful.

Thanks

This message has been edited. Last edited by: Kerry,

Kamesh,

You are missing a backslash between directory and filename.

Change line into :
-SET &DIR='\\SERVER\IBI\APPS\BASEAPP\';

or change this line into :
FILEDEF CDSDAT DISK &DIR|\CDSDAT.FTM


-Fred-

Fred,

I have that on my original code. It was just a typo error here.

Thanks

Is the \\server\path SMB notation allowed in WebFOCUS? Maybe it is, I did not check documentation. When faced with that I try to map a drive letter to it in the reporting server and use X:\path instead.

Anyway, would this alternative perhaps help you?

-SET &DIR='\\SERVER\IBI\APPS\BASEAPP\';

APP MAP MYPATH &DIR
APP HOLDDATA MYPATH
-RUN

TABLE FILE CAR
PRINT
CAR
BY COUNTRY
ON TABLE HOLD AS CDSDAT
END
-RUN

-DOS dir &DIR