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.



Read-Only Read-Only Topic
Go
Search
Notify
Tools
DECODE Limits
 Login/Join
 
Guru
posted
Is there a limit to how many lines you can have in a DM DECODE?

I found this on the tech support site:
'You can use up to 40 lines to define the code and result pairs for any given DECODE function, or 39 lines if you also use an ELSE phrase. Use either a comma or blank to separate the code from the result, or one pair from another.'

Link to doc.

But when I run the following code I don't get any errors:

-SET &RPT_NAME = '99';
-TYPE Report Name: &RPT_NAME

-SET &INC = DECODE &RPT_NAME (
- '00' '00'
- '01' '01'
- '02' '02'
- '03' '03'
- '04' '04'
- '05' '05'
- '06' '06'
- '07' '07'
- '08' '08'
- '09' '09'
- '10' '10'
- '11' '11'
- '12' '12'
- '13' '13'
- '14' '14'
- '15' '15'
- '16' '16'
- '17' '17'
- '18' '18'
- '19' '19'
- '20' '20'
- '21' '21'
- '22' '22'
- '23' '23'
- '24' '24'
- '25' '25'
- '26' '26'
- '27' '27'
- '28' '28'
- '29' '29'
- '30' '30'
- '31' '31'
- '32' '32'
- '33' '33'
- '34' '34'
- '35' '35'
- '36' '36'
- '37' '37'
- '38' '38'
- '39' '39'
- '40' '40'
- '41' '41'
- '42' '42'
- '43' '43'
- '44' '44'
- '45' '45'
- '46' '46'
- '47' '47'
- '48' '48'
- '49' '49'
- '50' '50'
- '51' '51'
- '52' '52'
- '53' '53'
- '54' '54'
- '55' '55'
- '56' '56'
- '57' '57'
- '58' '58'
- '59' '59'
- '60' '60'
- '61' '61'
- '62' '62'
- '63' '63'
- '64' '64'
- '65' '65'
- '66' '66'
- '67' '67'
- '68' '68'
- '69' '69'
- '70' '70'
- '71' '71'
- '72' '72'
- '73' '73'
- '74' '74'
- '75' '75'
- '76' '76'
- '77' '77'
- '78' '78'
- '79' '79'
- '80' '80'
- '81' '81'
- '82' '82'
- '83' '83'
- '84' '84'
- '85' '85'
- '86' '86'
- '87' '87'
- '88' '88'
- '89' '89'
- '90' '90'
- '91' '91'
- '92' '92'
- '93' '93'
- '94' '94'
- '95' '95'
- '96' '96'
- '97' '97'
- '98' '98'
- '99' '99'
- ELSE ' ');

-TYPE INC is: &INC

I'm running WF 5.3.3.
 
Posts: 406 | Location: Canada | Registered: May 31, 2004Report This Post
<JG>
posted
Yes that's what the docs say and still say in 7.1.

However from my testing the limit appears to have been raised to 32k which is the same as when using an input file.
From an inline point of view that equates to 370 80 character lines plus an allowance for pointers.
Technically as there is no 80 character line limit any more you could also say 1 line 32k long
 
Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic


Copyright © 1996-2020 Information Builders