Focal Point
edastart - setting hold directory

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4701097331

July 19, 2004, 04:19 PM
jbmuir
edastart - setting hold directory
Hello,

How does one set the hold directory using edastart -t ???

I tried several directories in case permissions were the issue, but no luck. Also fiddled alot with various APP commands. What am I missing?

We're on Solaris:

(/focd01/users/muirj)> uname -a
SunOS dh10 5.8 Generic_117350-02 sun4u sparc SUNW,Sun-Fire-880
-James

RELEASE = R720526B
GEN_NUM = 12.02
SOURCE_DATE = 06/18/2004 17:30:55
BUILD_DATE = 06/19/2004 08:35:37
INSTALLATION_DATE = 07/01/2004 12:01:00
ON EDAPRINT Entering edasprof.prf
ON EDAPRINT Entering wfsitepf.fex
ON EDAPRINT Leaving wfsitepf.fex
ON EDAPRINT Leaving edasprof.prf
>>APP SHOWPATH
muirjwf
wdisk
cuwatest
udisk
bchtest
ibisamp
baseapp
>>APP LIST
BEGIN-APP-LIST
17/12/2003 15.28.16 session
23/01/2004 13.56.08 baseapp
23/01/2004 14.01.59 bchtest
11/03/2004 10.34.33 bchtst2
14/07/2004 14.11.41 cuwatest
01/07/2004 12.38.16 ibinccen
01/07/2004 12.17.17 ibisamp
14/07/2004 15.37.08 wdisk
16/07/2004 15.43.22 udisk
14/07/2004 14.53.08 sstest
16/07/2004 16.01.19 muirjwf
END-APP-LIST
>>APP MAP holddir /focd18/hdrextra/test/mah
>>APP HOLD holddir
>>EX USEIBI
>>TABLE FILE CAR
>PRINT COUNTRY
>ON TABLE HOLD AS WALLY FORMAT ALPHA
>END

NUMBER OF RECORDS IN TABLE= 5 LINES= 5

(FOC36219) AN ERROR OCCURED WHEN OPENING FILE: WALLY
>>FIN

James Muir
Dartmouth-Hitchcock Data Warehouse
E-mail: James.Muir@hitchcock.org
July 19, 2004, 04:34 PM
Leah
Do you have a filedef for WALLY pointing to somwhere you have write access to.
July 19, 2004, 05:56 PM
jbmuir
Well, I just tried this again, adding in a FILEDEF for good measure, and once again I get the vexing FOC36219 message. Frowner

But I did notice that the master file was created, so it half works.

Thanks for the idea. Keep 'em coming.
-James

>>!pwd
/focd01/users/muirj/extracts
>>APP LIST
BEGIN-APP-LIST
17/12/2003 15.28.16 session
23/01/2004 13.56.08 baseapp
23/01/2004 14.01.59 bchtest
11/03/2004 10.34.33 bchtst2
14/07/2004 14.11.41 cuwatest
01/07/2004 12.38.16 ibinccen
01/07/2004 12.17.17 ibisamp
14/07/2004 15.37.08 wdisk
16/07/2004 16.58.13 udisk
14/07/2004 14.53.08 sstest
16/07/2004 16.01.19 muirjwf
END-APP-LIST
>>APP SHOWPATH
muirjwf
wdisk
cuwatest
udisk
bchtest
ibisamp
baseapp
>>FILEDEF WALLY DISK /focd01/users/muirj/extracts/wally.ftm
>>APP MAP holddir /focd01/users/muirj/extracts
>>APP HOLD holddir
>>APP PREPENDPATH holddir
>>APP SHOWPATH
holddir
muirjwf
wdisk
cuwatest
udisk
bchtest
ibisamp
baseapp
>>EX USEIBI
>>TABLE FILE CAR
>PRINT COUNTRY
>ON TABLE HOLD AS WALLY FORMAT ALPHA
>END

NUMBER OF RECORDS IN TABLE= 5 LINES= 5

(FOC36219) AN ERROR OCCURED WHEN OPENING FILE: WALLY
>>
>>!ls -lF /focd01/users/muirj/extracts
total 44
drwxr-x--- 2 muirj hdrstaff 1536 Jan 30 10:06 gen/
drwxr-x--- 2 muirj hdrstaff 512 Jun 24 15:35 gmc/
drwxr-x--- 2 muirj hdrstaff 512 Jun 24 15:37 gpa/
drwxr-x--- 2 muirj hdrstaff 512 Jun 24 08:54 hcl/
drwxr-x--- 2 muirj hdrstaff 512 Jun 24 09:25 hclw/
drwxr-x--- 2 muirj hdrstaff 512 Jun 24 09:34 hcs/
drwxr-x--- 2 muirj hdrstaff 512 Jun 25 10:23 hpa/
drwxr-x--- 2 muirj hdrstaff 1024 Jul 19 13:19 mah/
drwxr-x--- 2 muirj hdrstaff 512 Jun 24 15:58 oprn/
drwxr-x--- 2 muirj hdrstaff 1024 Jun 25 10:51 phar/
drwxr-x--- 2 muirj hdrstaff 512 Jun 25 14:22 pnln/
drwxr-x--- 2 muirj hdrstaff 512 Jun 25 11:33 pnls/
drwxr-x--- 2 muirj hdrstaff 512 Jul 15 16:57 prn/
drwxr-x--- 2 muirj hdrstaff 512 Jul 7 16:25 prs/
drwxr-x--- 2 muirj hdrstaff 512 Jun 25 09:31 ptdw/
drwxr-x--- 3 muirj hdrstaff 512 Jun 24 15:31 schn/
drwxr-x--- 2 muirj hdrstaff 512 Jun 24 15:33 schs/
drwxr-x--- 2 muirj hdrstaff 512 Jun 25 14:22 spr/
drwxr-x--- 2 muirj hdrstaff 512 Jun 25 09:34 ucv/
drwxr-x--- 2 muirj hdrstaff 512 Jun 24 09:39 upa/
-rw-r----- 1 muirj hdrstaff 588 Jul 19 13:21 wally.mas
>>!cat wally.mas
$==================================================================$
$ HOLD file created on 2004/07/19 at 13.18.40 by FOCUS R720526B $
$ Database records retrieved= 5 $
$ Records in the HOLD file = 5 $
$==================================================================$
FILE=WALLY ,SUFFIX=FIX
SEGNAME=WALLY ,SEGTYPE=S0
FIELDNAME =COUNTRY ,E01 ,A10 ,A10 ,$
July 19, 2004, 06:02 PM
Leah
What happens if you do a 'SAVE' as. Are you sure you have write permissions?
July 19, 2004, 06:45 PM
jbmuir
The master was created in the target directory so I have write access. I went ahead and did the 'SAVE' as, as requested and got FOC350. Frowner

After running the 'SAVE AS' test I thought I'd remove the wally.mas that was created earlier in this session. I discovered that edastart has a rm command, and that edastart could not find the wally.mas file. However, the unix command worked. (See Below)

I am wondering if the APP HOLD command done previously in this session didn't "take" for some reason. Does anyone know if eda restricts who may revise the hold path? Is this something that is configurable?
-James


>>TABLE FILE CAR
>PRINT COUNTRY
>ON TABLE SAVE AS WALLY FORMAT ALPHA
>END

NUMBER OF RECORDS IN TABLE= 5 LINES= 5


ALPHANUMERIC RECORD NAMED WALLY

FIELDNAME ALIAS FORMAT LENGTH

COUNTRY COUNTRY A10 10

TOTAL 10
(FOC350) ERROR WRITING OUTPUT FILE: WALLY
>>!ls -lF
total 46
drwxr-x--- 2 muirj hdrstaff 1536 Jan 30 10:06 gen/
drwxr-x--- 2 muirj hdrstaff 512 Jun 24 15:35 gmc/
drwxr-x--- 2 muirj hdrstaff 512 Jun 24 15:37 gpa/
drwxr-x--- 2 muirj hdrstaff 512 Jun 24 08:54 hcl/
drwxr-x--- 2 muirj hdrstaff 512 Jun 24 09:25 hclw/
drwxr-x--- 2 muirj hdrstaff 512 Jun 24 09:34 hcs/
drwxr-x--- 2 muirj hdrstaff 512 Jun 25 10:23 hpa/
drwxr-x--- 2 muirj hdrstaff 1024 Jul 19 13:19 mah/
drwxr-x--- 2 muirj hdrstaff 512 Jun 24 15:58 oprn/
drwxr-x--- 2 muirj hdrstaff 1024 Jun 25 10:51 phar/
drwxr-x--- 2 muirj hdrstaff 512 Jun 25 14:22 pnln/
drwxr-x--- 2 muirj hdrstaff 512 Jun 25 11:33 pnls/
drwxr-x--- 2 muirj hdrstaff 512 Jul 15 16:57 prn/
drwxr-x--- 2 muirj hdrstaff 512 Jul 7 16:25 prs/
drwxr-x--- 2 muirj hdrstaff 512 Jun 25 09:31 ptdw/
drwxr-x--- 3 muirj hdrstaff 512 Jun 24 15:31 schn/
drwxr-x--- 2 muirj hdrstaff 512 Jun 24 15:33 schs/
drwxr-x--- 2 muirj hdrstaff 512 Jun 25 14:22 spr/
drwxr-x--- 2 muirj hdrstaff 512 Jun 25 09:34 ucv/
drwxr-x--- 2 muirj hdrstaff 512 Jun 24 09:39 upa/
-rw-r----- 1 muirj hdrstaff 588 Jul 19 13:51 wally.mas
>>rm wally.mas
WALLY.MAS: No such file or directory
>>!rm wally.mas
>>
July 19, 2004, 07:43 PM
jbmuir
A little more info on this mystery. Looks like there is a permissions problem, because this is what FOC350 says:

(FOC350) ERROR WRITING OUTPUT FILE: ?
An I/O type error prevented the file named from being written.

After starting a new edastart session I mapped an APP to a directory, and then did an APP QUERY. The error message would seem to indicate the the APP MAP did not work, yet the APP MAP appears on the APP LIST, but without a date associated with it.

What can be wrong here?

Must I create an APP directory under APPROOT? I'd rather not have to do that in order to use edastart!

Any and all suggestions appreciated.
-James

>>APP MAP holddir /focd01/users/muirj/extracts
>>APP QUERY holddir
(FOC36307) APPLICATION holddir DOES NOT EXIST.
END-APP-QUERY
>>APP LIST
BEGIN-APP-LIST
17/12/2003 15.28.16 session
23/01/2004 13.56.08 baseapp
23/01/2004 14.01.59 bchtest
11/03/2004 10.34.33 bchtst2
14/07/2004 14.11.41 cuwatest
01/07/2004 12.38.16 ibinccen
01/07/2004 12.17.17 ibisamp
14/07/2004 15.37.08 wdisk
16/07/2004 16.58.13 udisk
14/07/2004 14.53.08 sstest
16/07/2004 16.01.19 muirjwf
holddir
END-APP-LIST
>>
July 19, 2004, 07:44 PM
Jen
How about SET TEMPERASE = OFF?

Or (not knowing much about Unix) does Unix not like .FTM files? Have you tried a different format?
July 19, 2004, 08:32 PM
Jen
One more idea...

FILEDEF HOLDMAST DIR /focd01/users/muirj/extracts
FILEDEF WALLY DISK /focd01/users/muirj/extracts/wally.ftm
July 20, 2004, 01:42 PM
jbmuir
I tried the FILEDEF variation but without success:

FILEDEF HOLDMAST DIR /focd01/users/muirj/extracts
FILEDEF WALLY DISK /focd01/users/muirj/extracts/wally.ftm

Thanks jen and leah for your suggestions. At this point I need to address some other problems so I'll summarize what I've found and move on.

This is what I have discovered about edastart: You can deposit hold files in your current working directory. If the APP MAP has been predefined by the administrator, you can deposit files in that folder. You cannot specify another target directory even though you have proper unix permissions. Perhaps only the administrator may define the app map directories. The documentation is unclear as to who can do what. Frowner


RELEASE = R720526B
GEN_NUM = 12.02
SOURCE_DATE = 06/18/2004 17:30:55
BUILD_DATE = 06/19/2004 08:35:37
INSTALLATION_DATE = 07/01/2004 12:01:00
ON EDAPRINT Entering edasprof.prf
ON EDAPRINT Entering wfsitepf.fex
ON EDAPRINT Leaving wfsitepf.fex
ON EDAPRINT Leaving edasprof.prf
>>APP LIST
BEGIN-APP-LIST
17/12/2003 15.28.16 session
23/01/2004 13.56.08 baseapp
23/01/2004 14.01.59 bchtest
11/03/2004 10.34.33 bchtst2
14/07/2004 14.11.41 cuwatest
01/07/2004 12.38.16 ibinccen
01/07/2004 12.17.17 ibisamp
14/07/2004 15.37.08 wdisk
16/07/2004 16.58.13 udisk
14/07/2004 14.53.08 sstest
20/07/2004 08.58.17 muirjwf
END-APP-LIST
>>EX USEIBI
>>TABLE FILE CAR
>PRINT COUNTRY
>ON TABLE HOLD AS WALLY FORMAT ALPHA
>END

NUMBER OF RECORDS IN TABLE= 5 LINES= 5



HOLDING ALPHA FILE...
>>APP HOLD muirjwf
>>TABLE FILE CAR
>PRINT COUNTRY
>ON TABLE HOLD AS WALLY FORMAT ALPHA
>END

NUMBER OF RECORDS IN TABLE= 5 LINES= 5



HOLDING ALPHA FILE...
>>APP MAP holddir /focd01/users/muirj/extracts
>>APP HOLD holddir
>>TABLE FILE CAR
>PRINT COUNTRY
>ON TABLE HOLD AS WALLY FORMAT ALPHA
>END

NUMBER OF RECORDS IN TABLE= 5 LINES= 5

(FOC36219) AN ERROR OCCURED WHEN OPENING FILE: WALLY
>>FIN

James Muir
Dartmouth-Hitchcock Data Warehouse
E-mail: James.Muir@hitchcock.org