Focal Point
DECODE Limits

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/9841068331

May 31, 2005, 07:34 PM
reFOCUSing
DECODE Limits
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.
June 01, 2005, 09:05 AM
<JG>
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