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     [SOLVED] I can't see my data when trying to print

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] I can't see my data when trying to print
 Login/Join
 
webmeister
Guru
posted
I have a very simple fixed-format file with only 3 fields, and also of course a very simple MFD. However, in a small FOCEXEC, where I have one define made up of one field and a 3 character prefix, when I try the following, I see no resulting data, except for the 3-digit prefix I defined.
Here's my code:

Define file AUD002
rmkkey /a12 = '001' | employee_id
end
table file aud002
print rmkkey employee_id job_code location_code
end

If anyone can offer a thought or two, I sure would be happy to hear them. Thanks in advanc.

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


Mainframe FOCUS 7.0
VM/CMS and MVS/TSO
 
Posts: 250 | Registered: January 14, 2008Report This Post
Leah
Virtuoso
posted Hide Post
quote:
Define file AUD002
rmkkey /a12 = '001' | employee_id
end
table file aud002
print rmkkey employee_id job_code location_code
end


First, you are missing a semi-colon after employee_id. Second is employee_id alpha. Third is this in lower case only because you typed it in that way?


Leah
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
webmeister
Guru
posted Hide Post
The missing semi-colon was a typo on my sie... in my FOCEXEC the semi-colon is present. The employee_id is alpha. Yes, that was the way I type it in...lower-case.

Interesting note.... I commented out the filedf portion and then I was able to see my data duing a print. Seems I am doing something incorrectly in my filedef.

Here is my original FOCEXEC
-*
-INCLUDE FOCDEF
-SET     &TITLE       = ' ';
-DEFAULT &PRG         = 'TEST  ';
-*
-* LISTING BY ACCOUNT
-*
DEFINE FILE AUD002
RMKKEY   /A12 = '100'|EMPLOYEE_ID;
END
TABLE FILE AUD002
PRINT EMPLOYEE_ID JOB_CODE LOCATION_CODE
BY RMKKEY
END
-*


Mainframe FOCUS 7.0
VM/CMS and MVS/TSO
 
Posts: 250 | Registered: January 14, 2008Report This Post
Leah
Virtuoso
posted Hide Post
I'm assuming the -include focdef is where the filedef is. You must have the file allocated someway if you are able to see data without it.


Leah
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
webmeister
Guru
posted Hide Post
Leah,

Thanks for replying. I decided, where my PC is my interface to my mainframe, to reboot my PC and my problem disappeared. I can now see my data. I'm not asking why, I'm just happy to see my data!

Again, thanks for replying to my initial plicht...I appreciate that you took the time and effort to do so.


Mainframe FOCUS 7.0
VM/CMS and MVS/TSO
 
Posts: 250 | Registered: January 14, 2008Report This Post
Leah
Virtuoso
posted Hide Post
You're most welcome. As I've said before, sometimes it's the simple things that bite you.


Leah
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report This Post
Baillecl
Platinum Member
posted Hide Post
A DM remark :
I know plenty of people are confused between -SET and -DEFAULT
But, Please, NO ';' in -DEFAULT where you can give default Values for more than a DM Variable
-DEFAULTS &LEVEL1 = 'VIRTUOSO', &LEVEL99 ='LEARNER'
And, Still Please, don't Forget ';' in a -SET that concerns One and Unique DM Variable
Can't you hear Focus laughing when you fall in one of his silly tricks, don't let him this childish pleasure (that costs you plenty of time)
More vicious : Focus will wait for Version X.Y
to make you fall down. He loves delayed bad tricks
So, be as rigid with Focus syntax as an old Monk.
Focusly yours


Focus Mainframe 7.6.11
Dev Studio 7.6.11 and !!!
PC Focus, Focus for OS/2, FFW Six, MSO
 
Posts: 134 | Registered: November 06, 2007Report This Post
Leah
Virtuoso
posted Hide Post
Of course we have the confusion of
SET versus -SET as well. SET is system variable and depending on where it is 'set' you need or don't need an '=' sign, and heaven forbid, no 'semi-colon' on SET. I like Old Monk comment. Good One


Leah
 
Posts: 1317 | Location: Council Bluffs, IA | Registered: May 24, 2004Report 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     [SOLVED] I can't see my data when trying to print

Copyright © 1996-2020 Information Builders