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] Create Function using TABLE File

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Create Function using TABLE File
 Login/Join
 
Virul Patel
Silver Member
posted
Hi,

I have procedure that I created like below, I tested it and it is working fine
-------------------------------------------
TABLE FILE pol_proc_tx_f_data
PRINT
PK
TX_CD_ID
POL_N
POL_INCP_DT
POL_TERM_EFF_DT
POL_TERM_EXP_DT
MERIT_IND
CLMS_FREE_IND
XMOD_IND
PKG_DISC_IND
XMOD
DISC_DIFF_MOD
TTL_INSD_VAL_AMT
TX_TYPE_ID
WHERE POL_TERM_ID='1000511-2013-03-24'
BY POL_TERM_ID
BY HIGHEST 1 TX_DT NOPRINT
BY HIGHEST 1 TX_TM NOPRINT
BY HIGHEST 1 CURRENTVERSION NOPRINT
-------------------------------------------
I want to create function using same where I want to use parameter with where clause.

Is it possible ?

Thanks, Virul

This message has been edited. Last edited by: <Kathryn Henning>,


Virul Patel
Product :
iWay Data Migrator (8.1)
WebFocus 8.1
SQL SERVER 2012
 
Posts: 32 | Location: Cambridge, Ontario, Canada | Registered: June 02, 2014Report This Post
Msondra
Silver Member
posted Hide Post
quote:
WHERE POL_TERM_ID='1000511-2013-03-24'

Hi Virul,

Does this work just fine?
The WHERE clause has some syntax issues.
WHERE POL_TERM_ID='1000511-2013-03-24'
Should be
WHERE POL_TERM_ID EQ '1000511-2013-03-24';

Are you trying to create a FUNCTION or create parameter functionality?

Check documentation under parameters on the IBI website or perhaps under a Help button.

A WebFOCUS parameter in this situation will start with an ampersand. You will need to know whether you are sending a single value or multiple values.

You can set a default to test it.

Let's say you name the variable &POL_TERM_ID.
Put the default statement at the top of your fex.

-DEFAULT &POL_TERM_ID = '1000511-2013-03-24';

Your WHERE statement is now:

WHERE POL_TERM_ID EQ '&POL_TERM_ID';


WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 35 | Location: Minnesota | Registered: May 17, 2013Report This Post
Virul Patel
Silver Member
posted Hide Post
MSonda,

Thanks your for your help.

Yes, below works fine
The WHERE clause has some syntax issues.
WHERE POL_TERM_ID='1000511-2013-03-24'

I don't need to put EQ instead =, but that is OK.

I am looking to convert this procedure in function, so that I can call that function in iWay data migrator.
My parameter is not static. It will have more than one parameter.
Yes I can set parameter, but in this case design we are looking is different.

Do you have any idea, how to use this TABEL FILE statement in Function ?

Thanks again for your advise.


Virul Patel
Product :
iWay Data Migrator (8.1)
WebFocus 8.1
SQL SERVER 2012
 
Posts: 32 | Location: Cambridge, Ontario, Canada | Registered: June 02, 2014Report This Post
Msondra
Silver Member
posted Hide Post
I'm sorry I am unfamiliar with calling a function in iWay data migrator.

I don't really understand what you are trying to do.


WebFOCUS 8.1.05
Windows, All Outputs
 
Posts: 35 | Location: Minnesota | Registered: May 17, 2013Report This Post
Virul Patel
Silver Member
posted Hide Post
MSondra,

No Problem. Thank you for your help.


Virul Patel
Product :
iWay Data Migrator (8.1)
WebFocus 8.1
SQL SERVER 2012
 
Posts: 32 | Location: Cambridge, Ontario, Canada | Registered: June 02, 2014Report 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] Create Function using TABLE File

Copyright © 1996-2020 Information Builders