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     ALPHA file format in WebFocus 7

Read-Only Read-Only Topic
Go
Search
Notify
Tools
ALPHA file format in WebFocus 7
 Login/Join
 
focusqueen
Silver Member
posted
I have a program that selects student ID numbers and then holds the list as an ALPHA output file. The students are selected using SQL within my .fex file. When I look at the output file, there appears to be the length of the field displayed first and then the id number on each line. How do I get rid of the length that is showing? I didn't have this problem in our previous version of WebFocus.
 
Posts: 46 | Location: Taylor University in Upland Indiana | Registered: May 20, 2003Report This Post
Piipster
Guru
posted Hide Post
I would expect that the numbers are AnV format ... variable length. You'll have to look at the settings available for your relational adapter to control how variable length fields are dealt with.


ttfn, kp


Access to most releases from R52x, on multiple platforms.
 
Posts: 346 | Location: Melbourne Australia | Registered: April 15, 2003Report This Post
Tony A
Expert
posted Hide Post
focusqueen,

Several ways you can do it. I'll use a ficticious column "student_number" as an example -

Method 1
SQL SQLMSS SET VARCHAR OFF

Method 2
SQL
SELECT CAST(student_number AS CHAR(12)) AS student_num
;

Method 3
TABLE FILE SQLOUT
PRINT student_number/A12
ON TABLE SAVE AS whatever
END


Hope this helps

T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Tony A
Expert
posted Hide Post
Whoops, missed at least one Wink -

SQL
SELECT CONVERT(VARCHAR(12), CHAR(12), student_number) AS student_num
;

T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
focusqueen
Silver Member
posted Hide Post
You guys are awesome. The select cast(student_number as char(12)) as student_num worked great. Thank you so much!!!
 
Posts: 46 | Location: Taylor University in Upland Indiana | Registered: May 20, 2003Report This Post
Tony A
Expert
posted Hide Post
You are most welcome.

I suppose the advantage of the chosen resolution is that, should WF revert to forcing non-varchar then the CAST will not fail whereas the COVNERT may have done so. That and the fact that you are only applying the conversion to one actual column.

T
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 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     ALPHA file format in WebFocus 7

Copyright © 1996-2020 Information Builders