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)
TABLE FILE LOB_SEG
COMPUTE SEG_ID/I6= COUNT(LOB_SEG.SEG_ID)
WHERE CURRENT_DATE = MAX(CURRENT_DATE)
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.
Anisha.This message has been edited. Last edited by: FP Mod Chuck,
Data Migrator 8206
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
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
|Powered by Social Strata|