Here is sample code from some of my reports:

SET HOLDDEFAULT=ALPHA
SET DEFAULT=WORK
JOIN CLEAR *
END
TABLE FILE POS00
PRINT POS00_CLAIM_ID
POS00_SUBS_SSN
POS00_MBR_TYPE
POS00_TAX_ID
POS00_TAX_ID_SUFFIX
ON TABLE HOLD AS POS06P1
END

Report is deposited in the work directory of the server where we have alot of space. Althought the file should be about 1 gig but comes out to 1 MB. Records are truncated in there. I am not sure why this happens. Is there a way to set the temp location to work directory? (would limit on temp directory do this? or is it memory limitation?)

Here is the log:

This batch job is running on node FELIX under PID 204B5528
The job is entry 39 in queue FELIX_TOOLS_BATCH
%DCL-W-NOCOMD, no command on line - reenter with alphabetic first character
%DCL-W-MAXPARM, too many parameters - reenter command with fewer parameters
%SET-W-NOTSET, error modifying DSA7358:
-SET-E-INVDEV, device is invalid for requested operation
%SET-W-NOTSET, error modifying DSA7358:
-SET-E-INVDEV, device is invalid for requested operation
%DCL-W-SKPDAT, image data (records not beginning with "$") ignored
$! Created by SUBFEX.COM (FEXSUBMIT)
$! ---
$ set default SORT_DSK:[HNWRK]
$ focus
orauser.com: adding SERVER_2901523009 to LNM$FILE_DEV list.
FOCUS 6.9.8 CREATED 10/17/2000
(C)Copyright 2000 Information Builders Inc.

EX SORT_DSK:[HNWRK]PALL5 ECHO=ALL
>>>>>>>>>>>>>>>>



>>>>> JOININT CALLED TO READ DATA

MERGE: RECORDS= 827 LINES= 827

MERGE: RECORDS= 1654 LINES= 1654
.....

MERGE: RECORDS= 3056600 LINES= 3011991

NUMBER OF RECORDS IN TABLE= 3056600 LINES= 3011203

HOLDING...

FINISH
>
Exiting FOCUS
Cleaning up temporary FOCUS files
Cleaning up temporary FOCUS directory
$! --- Send completion mail
$ mail
send
P53
PALL5 FOCUS batch job complete
%MAIL-E-FILNOTDEL, error deleting DAY$SCRATCH:[YOUR_USERNAME]MAIL_204B5528_SEND.TMP;*
-RMS-F-DEV, error in device name or inappropriate device type for operation
%MAIL-E-FILNOTDEL, error deleting DAY$SCRATCH:[YOUR_USERNAME]MAIL_204B5528_SEND.TMP;*
-RMS-F-DEV, error in device name or inappropriate device type for operation
%MAIL-E-SENDABORT, no message sent
See log file: C4034_ROOT:[P53]PALL5.LOG
%CLI-W-IVVERB, unrecognized command verb - check validity and spelling
\SEE\

%MAIL-E-OPENIN, error opening C4034_ROOT:[P53.MAIL]MAIL.MAI as input
-RMS-E-FNF, file not found
%MAIL-E-NOMSGS, no messages
Created by FOCUS FEXSUBMIT
%CLI-W-IVVERB, unrecognized command verb - check validity and spelling
\CREATED\
%MAIL-E-FILNOTDEL, error deleting DAY$SCRATCH:[YOUR_USERNAME]MAIL_204B5528_SEND.TMP;*
-RMS-F-DEV, error in device name or inappropriate device type for operation
%MAIL-E-FILNOTDEL, error deleting DAY$SCRATCH:[YOUR_USERNAME]MAIL_204B5528_EDIT.TMP;*
-RMS-F-DEV, error in device name or inappropriate device type for operation
$
$! ---
$ exit
P53 job terminated at 5-MAY-2007 06:49:56.27

Accounting information:
Buffered I/O count: 13285 Peak working set size: 100000
Direct I/O count: 26993701 Peak virtual size: 444544
Page faults: 120928 Mounted volumes: 0
Charged CPU time: 0 01:31:11.00 Elapsed time: 0 04:49:56.26

Hi Edgar,

This is specific to a vax and we would need to look at what you are doing to start the process. It would require many more questions based on how the settings are done, and our internal expert said that he would like to try a repro here. Therefore, the best channel for assistance in this situation would be to open a case with Information Builders' Customer Support Services.

To open a case, you may either call at 1-800-736-6130, or access the online system InfoResponse. Here is a list of information to be ready when you call: http://techsupport.ibi.com/before_you_call.jsp.

Hope this helps.

Cheers,

Kerry

Edgar

VAX FOCUS runs a report in a subdirectory created with a random name. Hold files will be created there unless a FOC$HOLD or something like that logical is set or you could explicitly FILEDEF it or copy from the temporary directory.

I think when the batch job is complete the new output is being erased and you are looking at an old test output which thus seems truncated.

Regards

John



John

Thanks I will have IT submit ticket to find out if its VMS issue.

John:

Can you please give me the syntax on how to use FILEDEF or FOC$HOLD to copy from temp folder or use it to specify where temp folder should be located.

Thanks!