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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CLOSED] Error in Fex Code

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Error in Fex Code
 Login/Join
 
Member
posted
Hi,
I am new to Iway/Webfocus toolset.

I am trying to convert a SQL Stored procedure to data flows.

I read on this forum that creating FEX/FOCUS procedures is much better to handle the scenarios.

I created a sample FEX to convert a stored procedure. but its giving me errors, i know i make an error when converting to fex, but not sure how to proceed further.

DEFINE FILE LOB_SEG
YEAR_MONTH_TXT/A11 = EDIT(LOB_SEG.YEAR_MONTH,'99999999999'); -- YEAR_MONTH = 202003
YEAR_TXT/A4 = SUBSTR(11,YEAR_MONTH_TXT,6,9,4,'A4'); --YEAR_TXT = 2020
MONTH_TXT/A2 = SUBSTR(11,YEAR_TXT,10,11,2,'A2' ); --MONTH_TXT =03
DATE_TXT/A10V=YEAR_TXT|'/'|MONTH_TXT|'/'|'01'; --DATE_TXT = 2020/03/01
CURRENT_DATE/YYMD =HDATE(DATE_TXT,'YYMD'); -- CURRENT_DATE = 2020/03/01 (DATE fORMAT)
END

TABLE FILE LOB_SEG
PRINT
YEAR_TXT
MONTH_TXT
PREVIOUS_DATE
CURRENTDATE
LOB_SEG.SEG_ID
SUM
COMPUTE SEG_ID/I6= COUNT(LOB_SEG.SEG_ID)
WHERE CURRENT_DATE = MAX(CURRENT_DATE)
END

Purpose of this code is to get the max year_month or max_date and total number of records for that month.


It will be great if some one can help me to fix the above code.

Thanks,
Anisha.

This message has been edited. Last edited by: FP Mod Chuck,


Data Migrator 8206
 
Posts: 3 | Registered: March 26, 2020Report This Post
Virtuoso
posted Hide Post
Ajillu

First of all welcome to Focal Point! It is a great place to get answers to your development questions.

I am assuming you created the LOB_SEG master file description against the stored procedure... What error or what is the issue you are having with the code provided?


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 2128 | Location: Customer Support | Registered: April 12, 2005Report This Post
Member
posted Hide Post
there are a couple issues in your code - you have 2 verbs (PRINT, SUM) but the rules for multi-verb requests require that PRINT be the last verb in the request if present. Also, the WHERE statement in WebFOCUS does not use actual operators; try substituting 'EQ' for the '='


WF 8201M/8206, Linux & Windows
 
Posts: 3 | Location: Home-based Kansas City area | Registered: April 16, 2020Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [CLOSED] Error in Fex Code

Copyright © 1996-2020 Information Builders