Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED]-WRITE an END to the file

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED]-WRITE an END to the file
 Login/Join
 
Landerman
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, 2010Report This Post
Waz
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: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Dan Satchell
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, 2007Report This Post
Landerman
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, 2010Report This Post
Waz
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: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Landerman
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, 2010Report This Post
Waz
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: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Landerman
Silver Member
posted Hide Post
yes

thanks Waz.


Landerman

WebFOCUS 7.7.01
Windows 2003 server
all output
 
Posts: 30 | Registered: January 29, 2010Report This Post
Waz
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: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED]-WRITE an END to the file

Copyright © 1996-2020 Information Builders