Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] How to create an end of file marker when exporting cvs files from webfocus?
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] How to create an end of file marker when exporting cvs files from webfocus?
 Login/Join
 
Member
posted
Would greatly appreciate any help or suggestions on how to create an output extract a comma delimited file with an end of file marker?
I used both save and hold to output along with format comma, dfix, and set up a variable to delimit the fields after they were written, but still I do not get an end of file marker.
The end-of-file (EOF) marker [chr$(26), or CTRL+Z, or also known as ASCII byte value 26] at the end of output is missing.

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


WebFocus 7.6
 
Posts: 3 | Registered: December 28, 2007Reply With QuoteReport This Post
Expert
posted Hide Post
You should not have to worry about EOF markers.

What is the OS ?

Why do you need to add an EOF marker ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6131 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
<JG>
posted
Waz is correct APPLICATIONS do not require an EOF in the file.

That suggests that you are passing the output to a raw programming language such as C.
That may require an EOF.

Adding an EOF to a WebFOCUS file is possible but requires using a system
copy.

Normally you would append something to a file by allocating it with (APPEND
and using a -WRITE.

Problem is that when you use -WRITE it always adds CR/LF (windows) or LF (unix)

this means that if you -WRITE file EOF you get HEX 1A0D0A (EOF/CR/LF)

To do what you want you need to write EOF to a file with an LRECL of 1,
that prevents the CR/LF being added, then copy the files together

windows example

  
FILEDEF HOLDA DISK c:\TEMP\HOLDA.CSV 
FILEDEF EOF DISK c:\TEMP\EOF.FTM (LRECL 1 RECFM F
-RUN
TABLE FILE CAR
PRINT COUNTRY CAR MODEL DCOST
ON TABLE HOLD AS HOLDA FORMAT COM
END
-RUN
-SET &EOF = HEXBYT(26, 'A1');
-WRITE EOF &EOF
!COPY c:\TEMP\HOLDA.CSV + c:\TEMP\EOF.FTM c:\TEMP\HOLDA_with_EOF.CSV
 
Reply With QuoteReport This Post
Expert
posted Hide Post
Excelent suggestion with the FILEDEF LRECL

With a minor change, the COPY command can be removed.

FILEDEF HOLDA DISK c:\TEMP\HOLDA.CSV 
FILEDEF HOLDEOF DISK c:\TEMP\HOLDA.CSV (APPEND LRECL 1 RECFM F

-RUN

TABLE FILE CAR
PRINT COUNTRY CAR MODEL DCOST
ON TABLE HOLD AS HOLDA FORMAT COM
END

-RUN

-SET &EOF = HEXBYT(26, 'A1');
-WRITE HOLDEOF &EOF


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.06OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

 
Posts: 6131 | Location: 33.8688° S, 151.2093° E | Registered: October 31, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] How to create an end of file marker when exporting cvs files from webfocus?

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.