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]-WRITE an END to the file
Go
New
Search
Notify
Tools
Reply
  
[CLOSED]-WRITE an END to the file
 Login/Join
 
Silver Member
posted
Hi,ALL
I want to write a dbafile.

the fex is bellow
FILEDEF MYCAR DISK mycar/mytest.mas
-RUN
-WRITE MYCAR
-WRITE MYCAR FILENAME=MYTEST,$
-WRITE MYCAR SEGNAME=mmmmm,$
-WRITE MYCAR FIELDNAME=fffff,$
-WRITE MYCAR END

FILEDEF MYCAR DISK mycar/mytest.mas (APPEND
-RUN
TABLE FILE CAR
ON TABLE HOLD AS MYCAR
PRINT
COMPUTE AA/A200 = 'USER ='||CAR||',ACCESS=R, RESTRICT=VALUE_WHERE, NAME=SYSTEM, VALUE=CAR EQ '''||CAR||''',$'; AS ''
ON TABLE SAVE AS MYCAR FORMAT TAB

END
-RUN


BUT when the fex run to END the procedure ended.
the result :

FILENAME=MYTEST,$
SEGNAME=mmmmm,$
FIELDNAME=fffff,$
END


so the table file procedure does not run.

question:
can anybody modify the -WRITE MYCAR END to write "END" to the file and not end the procedure

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


Landerman

WebFOCUS 7.7.01
Windows 2003 server
all output
 
Posts: 30 | Registered: January 29, 2010Reply With QuoteReport This Post
Expert
posted Hide Post
Works for me on 7.6.9, Win XP.

Could be an issue with 7.7.01

Do you have an earlier verion to try it on ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6309 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Did you try removing this unnecessary line of code?
ON TABLE HOLD AS MYCAR


WebFOCUS 7.7.05
 
Posts: 1213 | Location: Seattle, Washington - USA | Registered: October 22, 2007Reply With QuoteReport This Post
Silver Member
posted Hide Post
Thanks Waz and Dan
I have resolved this problem


Landerman

WebFOCUS 7.7.01
Windows 2003 server
all output
 
Posts: 30 | Registered: January 29, 2010Reply With QuoteReport This Post
Expert
posted Hide Post
How did you solve the problem ?

It may help others in the future.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6309 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport This Post
Silver Member
posted Hide Post
here is my fex:

FILEDEF MYCAR DISK C:\ibi\apps\mycar\mytest.mas
-RUN
-WRITE MYCAR
-WRITE MYCAR FILENAME=MYTEST,$
-WRITE MYCAR SEGNAME=mmmmm,$
-WRITE MYCAR FIELDNAME=fffff,$
-WRITE MYCAR END

FILEDEF MYCAR DISK C:\ibi\apps\mycar\mytest.mas (APPEND
-RUN
TABLE FILE CAR
PRINT
COMPUTE AA/A200 = 'USER ='||CAR||',ACCESS=R, RESTRICT=VALUE_WHERE, NAME=SYSTEM, VALUE=CAR EQ '''||CAR||''',$'; AS ''
ON TABLE SAVE AS MYCAR FORMAT TAB

END
-RUN


Landerman

WebFOCUS 7.7.01
Windows 2003 server
all output
 
Posts: 30 | Registered: January 29, 2010Reply With QuoteReport This Post
Expert
posted Hide Post
So you changed your FILEDEF to an absolute location.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6309 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Reply With QuoteReport This Post
Silver Member
posted Hide Post
yes

thanks Waz.


Landerman

WebFOCUS 7.7.01
Windows 2003 server
all output
 
Posts: 30 | Registered: January 29, 2010Reply With QuoteReport This Post
Expert
posted Hide Post
Do you mind updating the title to [SOLVED] -WRITE an END to the file.

This can be done by clicking on the Edit from the first post.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6309 | Location: 33°49'23.0"S, 151°11'41.0"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]-WRITE an END to the file

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