Focal Point
Decode error special character problem?

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

August 22, 2007, 11:21 AM
kgleason
Decode error special character problem?
Hello,
I am getting the following error in this decode statement and I don't know why.

(FOC272) FORMAT ERROR IN DECODE OR FILE ELEMENT: TWO-WAY RADIO-VOICE SERVICES

I have removed the dashes and it still errors out. Is there a limit on the length of the input field or something? Is it the special characters in the input string? Any help would be appreciated.

NAME/A50 = DECODE TYPE_(
'FLAT RATE BUSINESS LINE' 'LOCAL',
'FLAT RATE RESIDENCE LINE' 'LOCAL',
-->Errors out on this line 'TWO-WAY RADIO-VOICE SERVICES' 'VOICE',
'TWO-WAY RADIO-EQUIPMENT' 'VOICE',
'TWO-WAY RADIO-LEASE/MAINTENANCE' 'VOICE',
'800 SERVICE-UNKNOWN TYPE' 'TOLL FREE',
'800 SERVICE-DEDICATED' 'TOLL FREE',
'800 SERVICE-SWITCHED' 'TOLL FREE',
'900 SERVICE' 'TOLL FREE',
'AT&T FIBER OPTIC NETWORK' 'DATA T-1',
'ALARM CIRCUIT' 'DATA T-1',
'OPERATOR MANNED ANSWERING SERVICE' 'VOICE',
'ASYNCHRONOUS TRANSFER MODE' 'FRAME T-1',
'ASYNCHRONOUS TRANSFER MODE' 'FRAME T-1',
'BLACKBERRY' 'VOICE',
'BLACKBERRY' 'VOICE',
'CABLE' 'DATA T-1',
'CABLE' 'DATA T-1',
'CABLE INTERNET' 'INTERNET SVC',
'CABLE INTERNET' 'INTERNET SVC',
'CABLE' 'DATA T-1',
'CALLING CARD' 'VOICE',
'CELLULAR SERVICE' 'VOICE',
'CELLULAR EQUIPMENT' 'VOICE',
'CELLULAR EQUIPMENT' 'VOICE',
'CENTREX STATION-MEASURED SERVICE' 'ISDN',
'CENTREX STATION-FLAT RATE' 'ISDN',
'CIRCUIT THE DATA RATE OF 36.368 MBPS' 'DATA T-3',
'CIRCUIT-128 KBS' 'DATA T-1',
'CIRCUIT-19.2 KBS' 'DATA T-1',
'CIRCUIT-2.4 KBS' 'DATA T-1',
'CIRCUIT-256 KBS' 'DATA T-1',
'CIRCUIT-384 KBS' 'DATA T-1',
'CIRCUIT-4.8 KBS' 'DATA T-1',
'CIRCUIT-512 KBS' 'DATA T-1',
'CIRCUIT-56 KBS' 'DATA T-1',
'CIRCUIT-64 KBS' 'DATA T-1',
'CIRCUIT-768 KBS' 'DATA T-1',
'CIRCUIT-9.6 KBS' 'DATA T-1',
'CIRCUIT-E1' 'DATA T-3',
'CIRCUIT-T1' 'DATA T-1',
'CIRCUIT-T3' 'DATA T-3',
'CIRCUIT 1GBS' 'DATA T-3',
'CIRCUIT CARD' 'DATA T-1',
'CIRCUIT CARD' 'DATA T-1',
'FIBER OPTIC CIRCUIT-UNKNOWN TYPE' 'DATA T-1',
'CIRCUIT-FIBER OPTIC' 'DATA T-1',
'CIRCUIT-UNKNOWN TYPE' 'DATA T-1',
'CIRCUIT-VOICE GRADE' 'DATA T-1',
'COIN OPERATED PAY TELEPHONE' 'VOICE',
'TELECONFERENCE CARD' 'CONFERENCE',
'CONSOLE TELEPHONE' 'VOICE',
'CONSOLE TELEPHONE' 'VOICE',
'UNKNOWN TYPE' 'VOICE',
'UNKNOWN TYPE' 'VOICE',
'UNKNOWN TYPE' 'VOICE',
'UNKNOWN TYPE' 'VOICE',
'UNKNOWN TYPE' 'VOICE',
'DIRECT INWARD DIAL STATION RANGE' 'LOCAL',
'DIRECTORY ADVERTISING' 'VOICE',
'DIGITAL SUBSCRIBER LINE' 'INTERNET SVC',
'DIGITAL SUBSCRIBER LINE' 'INTERNET SVC',
'ENHANCED 911' 'VOICE',
'ENHANCED 911' 'VOICE',
'ELECTRONIC DATA INTERCHANGE SERVICE' 'DATA T-1',
'ELECTRIC AND GAS SERVICES' 'VOICE',
'ELECTRIC SERVICE' 'VOICE',
'ELECTRONIC MESSAGING' 'INTERNET SVC',
'EQUIPMENT PURCHASE' 'VOICE',
'EQUIPMENT' 'VOICE',
'ETHERNET' 'INTERNET SVC',
'FACSIMILE SERVICE' 'VOICE T-1',
'FACSIMILE MACHINE' 'VOICE T-1',
'FACSIMILE MACHINE' 'VOICE T-1',
'FEATURE GROUP A' 'VOICE',
'FRAUD PROTECTION' 'VOICE',
'FRAME RELAY' 'FRAME T-1',
'FOREIGN EXCHANGE SERVICE' 'LD',
'FOREIGN EXCHANGE SERVICE' 'LD',
'NATURAL GAS SERVICE' 'VOICE',
'HANDHELD DEVICE' 'VOICE',
'HANDHELD DEVICE' 'VOICE',
'VENDOR ID CODES' 'VOICE',
'INTERNET ACCESS SERVICE' 'INTERNET SVC',
'INTERNET SERVICE' 'INTERNET SVC',
'INTERPRETER SERVICES-LANGUAGE TRANSLATION' 'VOICE',
'INVALID CUSTOMER NUMBER' 'VOICE',
'INVALID CUSTOMER NUMBER' 'VOICE',
'INVALID CUSTOMER NUMBER' 'VOICE',
'INVALID CUSTOMER NUMBER' 'VOICE',
'INVALID CUSTOMER NUMBER' 'VOICE',
'INVALID CUSTOMER NUMBER' 'VOICE',
'IP TRANSFER' 'INTERNET SVC',
'ISDN/BRI' 'ISDN',
'ISDN/BRI' 'ISDN',
'ISDN/PRI' 'ISDN',
'ISDN/PRI' 'ISDN',
'ISDN-UNKNOWN TYPE' 'ISDN',
'ISDN-UNKNOWN TYPE' 'ISDN',
'NETWORK MANAGEMENT-IXC PROVIDED' 'VOICE T-1',
'KEY TELEPHONE SYSTEM' 'VOICE',
'LONG DISTANCE SERVICE-UNKNOWN TYPE' 'LD',
'LEASING CONTRACT' 'VOICE',
'LICENSING CONTRACT' 'VOICE',
'DIRECTORY LISTING' 'VOICE',
'LONG DISTANCE SERVICE-DEDICATED' 'LD',
'LONG DISTANCE SERVICE-SWITCHED' 'LD',
'MAINTENANCE CONTRACT' 'VOICE',
'MEASURED RATE BUSINESS LINE' 'VOICE',
'MODEM' 'INTERNET SVC',
'MODEM' 'INTERNET SVC',
'MPLS' 'FRAME T-1',
'MEASURED RATE RESIDENTIAL LINE' 'VOICE',
'TRUNK-MEASURED RATE 2 WAY' 'VOICE',
'TRUNK-MEASURED RATE OUTBOUND' 'VOICE',
'MULTIPLE' 'VOICE T-1',
'NATIONAL DIRECTORY ASSISTANCE' 'VOICE',
'NETWORK MANAGEMENT-LEC PROVIDED' 'VOICE T-1',
'OFF PREMISE EXTENSION' 'VOICE',
'OFF PREMISE EXTENSION' 'VOICE',
'OTHER USE' 'VOICE',
'PAGER SERVICE' 'VOICE',
'PAGER SERVICE' 'VOICE',
'PAGER SERVICE' 'VOICE',
'PRIVATE BRANCH EXCHANGE' 'VOICE T-1',
'PRIVATE BRANCH EXCHANGE' 'VOICE T-1',
'PUBLIC BRANCH EXCHANGE' 'VOICE T-1',
'PRIVATE LINE DATA-SPECIAL USE' 'VOICE T-1',
'PRIVATE LINE VOICE-SPECIAL USE' 'VOICE',
'PORT/ATM' 'FRAME T-1',
'PORT FRAME' 'FRAME T-1',
'PVC ATM' 'FRAME T-1',
'PVC FRAME' 'FRAME T-1',
'PVC SIW' 'FRAME T-1',
'REMOTE CALL FORWARDING SERVICE' 'VOICE',
'REMOTE DIAL ACCESS' 'VOICE T-1',
'SIGNAL REPEATER' 'DATA T-1',
'SIGNAL REPEATER' 'DATA T-1',
'SATELLITE COMMUNICATIONS SERVICE' 'DATA T-1',
'SWITCHED DIGITAL SERVICE-56KBS' 'DATA T-1',
'SWITCHED DIGITAL SERVICE-UNKNOWN TYPE' 'DATA T-1',
'SECOND LANGUAGE OPTION' 'VOICE',
'SYNCHRONOUS OPTICAL NETWORK-OC1' 'DATA T-1',
'SYNCHRONOUS OPTICAL NETWORK-OC1' 'DATA T-1',
'SYNCHRONOUS OPTICAL NETWORK-OC12' 'DATA T-3',
'SYNCHRONOUS OPTICAL NETWORK-OC12' 'DATA T-3',
'SYNCHRONOUS OPTICAL NETWORK-OC24' 'DATA T-3',
'SYNCHRONOUS OPTICAL NETWORK-OC24''DATA T-3',
'SYNCHRONOUS OPTICAL NETWORK-OC3' 'DATA T-3',
'SYNCHRONOUS OPTICAL NETWORK-OC3' 'DATA T-3',
'SYNCHRONOUS OPTICAL NETWORK-OC48' 'DATA T-3',
'SYNCHRONOUS OPTICAL NETWORK-OC48' 'DATA T-3',
'SYNCHRONOUS OPTICAL NETWORK-OC96' 'DATA T-3',
'SYNCHRONOUS OPTICAL NETWORK-OC96' 'DATA T-3',
'SUMMARY LEVEL CHARGES-CIRCUITS' 'DATA T-1',
'SUMMARY LEVEL CHARGES-FRAME/ATM' 'FRAME T-1',
'SUMMARY LEVEL CHARGES' 'VOICE',
'TIME AND MATERIALS' 'VOICE',
'AUDIO TELECONFERENCING SERVICE' 'CONFERENCE',
'TEMPORARY TELECOMMUNICATIONS SERVICE' 'VOICE',
'THRIFTY BILL' 'VOICE',
'TRUNK-2 WAY' 'LOCAL',
'TRUNK-2 WAY DIRECT INWARD DIAL' 'LOCAL',
'TRUNK-DIRECT INWARD DIAL' 'LOCAL',
'TRUNK-FX' 'LOCAL',
'TRUNK-INBOUND' 'LOCAL',
'TRUNK-MEASURED RATE INBOUND' 'LOCAL',
'TRUNK-OUTBOUND' 'LOCAL',
'TRUNK-UNKNOWN TYPE' 'LOCAL',
'TIE LINE' 'VOICE',
'TIE LINE' 'VOICE',
'TIME AND MATERIALS-LEASE/MAINTENANCE' 'VOICE',
'TRACKING ACCOUNT' 'VOICE T-1',
'WASTE REMOVAL SERVICE' 'VOICE',
'UNIDENTIFIED LINE' 'VOICE',
'VIDEO TELECONFERENCING SERVICE' 'CONFERENCE',
'VOICE MAIL' 'VOICE',
'VOICE CALLS OVER THE INTERNET PROTOCOL' 'INTERNET SVC',
'VOICE CALLS OVER THE INTERNET PROTOCOL' 'INTERNET SVC',
'WATER AND SEWER SERVICE' 'VOICE',
'WATER SERVICE' 'VOICE',
'WIDE AREA TELEPHONE SERVICE' 'VOICE',
'WEB SERVICE' 'INTERNET SVC',
'WEB SERVICE' 'INTERNET SVC',
'WIRELESS DATA' 'DATA T-1');

Thanks,
Ken Gleason
August 22, 2007, 11:37 AM
hammo1j
Need to know the format of _type.

Ken can you fill in your profile please?


Server: WF 7.6.2 ( BID/Rcaster) Platform: W2003Server/IIS6/Tomcat/SQL Server repository Adapters: SQL Server 2000/Oracle 9.2
Desktop: Dev Studio 765/XP/Office 2003 Applications: IFS/Jobscope/Maximo
August 22, 2007, 11:41 AM
Prarie
Are Comma's supposed to separate a Decode?


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
August 22, 2007, 11:45 AM
Tony A
Ken,

Two things I would do first -

1. Remove the commas at the end of your decode pairs, they are not correct syntax.
2. Remove the duplicates from your decode pairs. There are about 22 (ish).

There are some limitations on decodes but I don't have the manual to hand to check.
For an external file the limit is (I think) 32000 chars so you might like to consider loading the data into a file and the performing a JOIN.

T

This message has been edited. Last edited by: Tony A,


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
August 22, 2007, 11:49 AM
kgleason
thanks for the quick response.

type is an A100.
August 22, 2007, 11:49 AM
kgleason
I tried it with and without commas and got the same error.
August 22, 2007, 11:50 AM
Francis Mariani
'AT&T FIBER OPTIC NETWORK' 'DATA T-1',

is the culprit - WebFOCUS is trying to translate the &T as a Dialogue Manager variable.

Try coding it as:

'AT&|T FIBER OPTIC NETWORK' 'DATA T-1',


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
August 22, 2007, 11:52 AM
Francis Mariani
I like the commas and always use them to separate the pairs from each other.

From the manual:
quote:
Use either a comma or blank to separate the code from the result, or one pair from another



Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
August 22, 2007, 11:57 AM
Tony A
Well, I'll be ********. Never really looked at that. Just goes to show the things we miss even when we do read the manual(s). Wink

T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
August 22, 2007, 12:06 PM
Francis Mariani
Tony,

In the documentation, that comma should be shown in the syntax as [,] instead of just as a comment.

Cheers,


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
August 22, 2007, 01:03 PM
dhagen
Geeze guys! 1777 and 1555 Post for Francis and Tony! Do you guys have jobs?

I'm actually just posting this to try to top 300. 300, I feel like I've done nothing on this site!


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
August 22, 2007, 01:20 PM
Francis Mariani
Now it's 119 for me! And we won't even talk about my pseudonym!


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
August 22, 2007, 01:32 PM
kgleason
Thanks for all the responses. I am still getting the same error:
(FOC272) FORMAT ERROR IN DECODE OR FILE ELEMENT: TWO-WAY RADIO-VOICE SERVICES

Here is the decose statement after removing commas, duplicates and changing AT&T to AT&|T

NAME/A50 = DECODE TYPE_(
'FLAT RATE BUSINESS LINE' 'LOCAL'
'FLAT RATE RESIDENCE LINE' 'LOCAL'
'TWO-WAY RADIO-VOICE SERVICES' 'VOICE'
'TWO-WAY RADIO-EQUIPMENT' 'VOICE'
'TWO-WAY RADIO-LEASE/MAINTENANCE' 'VOICE'
'800 SERVICE-UNKNOWN TYPE' 'TOLL FREE'
'800 SERVICE-DEDICATED' 'TOLL FREE'
'800 SERVICE-SWITCHED' 'TOLL FREE'
'900 SERVICE' 'TOLL FREE'
'AT&|T FIBER OPTIC NETWORK' 'DATA T-1'
'ALARM CIRCUIT' 'DATA T-1'
'OPERATOR MANNED ANSWERING SERVICE' 'VOICE'
'ASYNCHRONOUS TRANSFER MODE' 'FRAME T-1'
'BLACKBERRY' 'VOICE'
'CABLE' 'DATA T-1'
'CABLE INTERNET' 'INTERNET SVC'
'CABLE' 'DATA T-1'
'CALLING CARD' 'VOICE'
'CELLULAR SERVICE' 'VOICE'
'CELLULAR EQUIPMENT' 'VOICE'
'CENTREX STATION-MEASURED SERVICE' 'ISDN'
'CENTREX STATION-FLAT RATE' 'ISDN'
'CIRCUIT THE DATA RATE OF 36.368 MBPS' 'DATA T-3'
'CIRCUIT-128 KBS' 'DATA T-1'
'CIRCUIT-19.2 KBS' 'DATA T-1'
'CIRCUIT-2.4 KBS' 'DATA T-1'
'CIRCUIT-256 KBS' 'DATA T-1'
'CIRCUIT-384 KBS' 'DATA T-1'
'CIRCUIT-4.8 KBS' 'DATA T-1'
'CIRCUIT-512 KBS' 'DATA T-1'
'CIRCUIT-56 KBS' 'DATA T-1'
'CIRCUIT-64 KBS' 'DATA T-1'
'CIRCUIT-768 KBS' 'DATA T-1'
'CIRCUIT-9.6 KBS' 'DATA T-1'
'CIRCUIT-E1' 'DATA T-3'
'CIRCUIT-T1' 'DATA T-1'
'CIRCUIT-T3' 'DATA T-3'
'CIRCUIT 1GBS' 'DATA T-3'
'CIRCUIT CARD' 'DATA T-1'
'FIBER OPTIC CIRCUIT-UNKNOWN TYPE' 'DATA T-1'
'CIRCUIT-FIBER OPTIC' 'DATA T-1'
'CIRCUIT-UNKNOWN TYPE' 'DATA T-1'
'CIRCUIT-VOICE GRADE' 'DATA T-1'
'COIN OPERATED PAY TELEPHONE' 'VOICE'
'TELECONFERENCE CARD' 'CONFERENCE'
'CONSOLE TELEPHONE' 'VOICE'
'UNKNOWN TYPE' 'VOICE'
'DIRECT INWARD DIAL STATION RANGE' 'LOCAL'
'DIRECTORY ADVERTISING' 'VOICE'
'DIGITAL SUBSCRIBER LINE' 'INTERNET SVC'
'ENHANCED 911' 'VOICE'
'ELECTRONIC DATA INTERCHANGE SERVICE' 'DATA T-1'
'ELECTRIC AND GAS SERVICES' 'VOICE'
'ELECTRIC SERVICE' 'VOICE'
'ELECTRONIC MESSAGING' 'INTERNET SVC'
'EQUIPMENT PURCHASE' 'VOICE'
'EQUIPMENT' 'VOICE'
'ETHERNET' 'INTERNET SVC'
'FACSIMILE SERVICE' 'VOICE T-1'
'FEATURE GROUP A' 'VOICE'
'FRAUD PROTECTION' 'VOICE'
'FRAME RELAY' 'FRAME T-1'
'FOREIGN EXCHANGE SERVICE' 'LD'
'NATURAL GAS SERVICE' 'VOICE'
'HANDHELD DEVICE' 'VOICE'
'VENDOR ID CODES' 'VOICE'
'INTERNET ACCESS SERVICE' 'INTERNET SVC'
'INTERNET SERVICE' 'INTERNET SVC'
'INTERPRETER SERVICES-LANGUAGE TRANSLATION' 'VOICE'
'INVALID CUSTOMER NUMBER' 'VOICE'
'IP TRANSFER' 'INTERNET SVC'
'ISDN/BRI' 'ISDN'
'ISDN-UNKNOWN TYPE' 'ISDN'
'NETWORK MANAGEMENT-IXC PROVIDED' 'VOICE T-1'
'KEY TELEPHONE SYSTEM' 'VOICE'
'LONG DISTANCE SERVICE-UNKNOWN TYPE' 'LD'
'LEASING CONTRACT' 'VOICE'
'LICENSING CONTRACT' 'VOICE'
'DIRECTORY LISTING' 'VOICE'
'LONG DISTANCE SERVICE-DEDICATED' 'LD'
'LONG DISTANCE SERVICE-SWITCHED' 'LD'
'MAINTENANCE CONTRACT' 'VOICE'
'MEASURED RATE BUSINESS LINE' 'VOICE'
'MODEM' 'INTERNET SVC'
'MPLS' 'FRAME T-1'
'MEASURED RATE RESIDENTIAL LINE' 'VOICE'
'TRUNK-MEASURED RATE 2 WAY' 'VOICE'
'TRUNK-MEASURED RATE OUTBOUND' 'VOICE'
'MULTIPLE' 'VOICE T-1'
'NATIONAL DIRECTORY ASSISTANCE' 'VOICE'
'NETWORK MANAGEMENT-LEC PROVIDED' 'VOICE T-1'
'OFF PREMISE EXTENSION' 'VOICE'
'OTHER USE' 'VOICE'
'PAGER SERVICE' 'VOICE'
'PRIVATE BRANCH EXCHANGE' 'VOICE T-1'
'PUBLIC BRANCH EXCHANGE' 'VOICE T-1'
'PRIVATE LINE DATA-SPECIAL USE' 'VOICE T-1'
'PRIVATE LINE VOICE-SPECIAL USE' 'VOICE'
'PORT/ATM' 'FRAME T-1'
'PORT FRAME' 'FRAME T-1'
'PVC ATM' 'FRAME T-1'
'PVC FRAME' 'FRAME T-1'
'PVC SIW' 'FRAME T-1'
'REMOTE CALL FORWARDING SERVICE' 'VOICE'
'REMOTE DIAL ACCESS' 'VOICE T-1'
'SIGNAL REPEATER' 'DATA T-1'
'SATELLITE COMMUNICATIONS SERVICE' 'DATA T-1'
'SWITCHED DIGITAL SERVICE-56KBS' 'DATA T-1'
'SWITCHED DIGITAL SERVICE-UNKNOWN TYPE' 'DATA T-1'
'SECOND LANGUAGE OPTION' 'VOICE'
'SYNCHRONOUS OPTICAL NETWORK-OC1' 'DATA T-1'
'SYNCHRONOUS OPTICAL NETWORK-OC12' 'DATA T-3'
'SYNCHRONOUS OPTICAL NETWORK-OC24' 'DATA T-3'
'SYNCHRONOUS OPTICAL NETWORK-OC3' 'DATA T-3'
'SYNCHRONOUS OPTICAL NETWORK-OC48' 'DATA T-3'
'SYNCHRONOUS OPTICAL NETWORK-OC96' 'DATA T-3'
'SUMMARY LEVEL CHARGES-CIRCUITS' 'DATA T-1'
'SUMMARY LEVEL CHARGES-FRAME/ATM' 'FRAME T-1'
'SUMMARY LEVEL CHARGES' 'VOICE'
'TIME AND MATERIALS' 'VOICE'
'AUDIO TELECONFERENCING SERVICE' 'CONFERENCE'
'TEMPORARY TELECOMMUNICATIONS SERVICE' 'VOICE'
'THRIFTY BILL' 'VOICE'
'TRUNK-2 WAY' 'LOCAL'
'TRUNK-2 WAY DIRECT INWARD DIAL' 'LOCAL'
'TRUNK-DIRECT INWARD DIAL' 'LOCAL'
'TRUNK-FX' 'LOCAL'
'TRUNK-INBOUND' 'LOCAL'
'TRUNK-MEASURED RATE INBOUND' 'LOCAL'
'TRUNK-OUTBOUND' 'LOCAL'
'TRUNK-UNKNOWN TYPE' 'LOCAL'
'TIE LINE' 'VOICE'
'TIME AND MATERIALS-LEASE/MAINTENANCE' 'VOICE'
'TRACKING ACCOUNT' 'VOICE T-1'
'WASTE REMOVAL SERVICE' 'VOICE'
'UNIDENTIFIED LINE' 'VOICE'
'VIDEO TELECONFERENCING SERVICE' 'CONFERENCE'
'VOICE MAIL' 'VOICE'
'VOICE CALLS OVER THE INTERNET PROTOCOL' 'INTERNET SVC'
'WATER AND SEWER SERVICE' 'VOICE'
'WATER SERVICE' 'VOICE'
'WIDE AREA TELEPHONE SERVICE' 'VOICE'
'WEB SERVICE' 'INTERNET SVC'
'WIRELESS DATA' 'DATA T-1');

Any other suggestions?
August 22, 2007, 01:53 PM
Darin Lee
Also from the manual:
"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. "

I would guess there are more than 40 lines in this one. As to why it references that particular line, ???. Just like "Error at or near line X" sometimes gets close, sometimes it doesn't.


Regards,

Darin


In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
August 22, 2007, 01:53 PM
Francis Mariani
When I run this, I do not get any errors:

-SET &ECHO=ALL;

DEFINE FILE CAR
TYPE_/A50 = 'CIRCUIT THE DATA RATE OF 36.368 MBPS';
NAME/A50 = DECODE TYPE_(
'FLAT RATE BUSINESS LINE' 'LOCAL'
'FLAT RATE RESIDENCE LINE' 'LOCAL'
'TWO-WAY RADIO-VOICE SERVICES' 'VOICE'
'TWO-WAY RADIO-EQUIPMENT' 'VOICE'
'TWO-WAY RADIO-LEASE/MAINTENANCE' 'VOICE'
'800 SERVICE-UNKNOWN TYPE' 'TOLL FREE'
'800 SERVICE-DEDICATED' 'TOLL FREE'
'800 SERVICE-SWITCHED' 'TOLL FREE'
'900 SERVICE' 'TOLL FREE'
'AT&|T FIBER OPTIC NETWORK' 'DATA T-1'
'ALARM CIRCUIT' 'DATA T-1'
'OPERATOR MANNED ANSWERING SERVICE' 'VOICE'
'ASYNCHRONOUS TRANSFER MODE' 'FRAME T-1'
'BLACKBERRY' 'VOICE'
'CABLE' 'DATA T-1'
'CABLE INTERNET' 'INTERNET SVC'
'CABLE' 'DATA T-1'
'CALLING CARD' 'VOICE'
'CELLULAR SERVICE' 'VOICE'
'CELLULAR EQUIPMENT' 'VOICE'
'CENTREX STATION-MEASURED SERVICE' 'ISDN'
'CENTREX STATION-FLAT RATE' 'ISDN'
'CIRCUIT THE DATA RATE OF 36.368 MBPS' 'DATA T-3'
'CIRCUIT-128 KBS' 'DATA T-1'
'CIRCUIT-19.2 KBS' 'DATA T-1'
'CIRCUIT-2.4 KBS' 'DATA T-1'
'CIRCUIT-256 KBS' 'DATA T-1'
'CIRCUIT-384 KBS' 'DATA T-1'
'CIRCUIT-4.8 KBS' 'DATA T-1'
'CIRCUIT-512 KBS' 'DATA T-1'
'CIRCUIT-56 KBS' 'DATA T-1'
'CIRCUIT-64 KBS' 'DATA T-1'
'CIRCUIT-768 KBS' 'DATA T-1'
'CIRCUIT-9.6 KBS' 'DATA T-1'
'CIRCUIT-E1' 'DATA T-3'
'CIRCUIT-T1' 'DATA T-1'
'CIRCUIT-T3' 'DATA T-3'
'CIRCUIT 1GBS' 'DATA T-3'
'CIRCUIT CARD' 'DATA T-1'
'FIBER OPTIC CIRCUIT-UNKNOWN TYPE' 'DATA T-1'
'CIRCUIT-FIBER OPTIC' 'DATA T-1'
'CIRCUIT-UNKNOWN TYPE' 'DATA T-1'
'CIRCUIT-VOICE GRADE' 'DATA T-1'
'COIN OPERATED PAY TELEPHONE' 'VOICE'
'TELECONFERENCE CARD' 'CONFERENCE'
'CONSOLE TELEPHONE' 'VOICE'
'UNKNOWN TYPE' 'VOICE'
'DIRECT INWARD DIAL STATION RANGE' 'LOCAL'
'DIRECTORY ADVERTISING' 'VOICE'
'DIGITAL SUBSCRIBER LINE' 'INTERNET SVC'
'ENHANCED 911' 'VOICE'
'ELECTRONIC DATA INTERCHANGE SERVICE' 'DATA T-1'
'ELECTRIC AND GAS SERVICES' 'VOICE'
'ELECTRIC SERVICE' 'VOICE'
'ELECTRONIC MESSAGING' 'INTERNET SVC'
'EQUIPMENT PURCHASE' 'VOICE'
'EQUIPMENT' 'VOICE'
'ETHERNET' 'INTERNET SVC'
'FACSIMILE SERVICE' 'VOICE T-1'
'FEATURE GROUP A' 'VOICE'
'FRAUD PROTECTION' 'VOICE'
'FRAME RELAY' 'FRAME T-1'
'FOREIGN EXCHANGE SERVICE' 'LD'
'NATURAL GAS SERVICE' 'VOICE'
'HANDHELD DEVICE' 'VOICE'
'VENDOR ID CODES' 'VOICE'
'INTERNET ACCESS SERVICE' 'INTERNET SVC'
'INTERNET SERVICE' 'INTERNET SVC'
'INTERPRETER SERVICES-LANGUAGE TRANSLATION' 'VOICE'
'INVALID CUSTOMER NUMBER' 'VOICE'
'IP TRANSFER' 'INTERNET SVC'
'ISDN/BRI' 'ISDN'
'ISDN-UNKNOWN TYPE' 'ISDN'
'NETWORK MANAGEMENT-IXC PROVIDED' 'VOICE T-1'
'KEY TELEPHONE SYSTEM' 'VOICE'
'LONG DISTANCE SERVICE-UNKNOWN TYPE' 'LD'
'LEASING CONTRACT' 'VOICE'
'LICENSING CONTRACT' 'VOICE'
'DIRECTORY LISTING' 'VOICE'
'LONG DISTANCE SERVICE-DEDICATED' 'LD'
'LONG DISTANCE SERVICE-SWITCHED' 'LD'
'MAINTENANCE CONTRACT' 'VOICE'
'MEASURED RATE BUSINESS LINE' 'VOICE'
'MODEM' 'INTERNET SVC'
'MPLS' 'FRAME T-1'
'MEASURED RATE RESIDENTIAL LINE' 'VOICE'
'TRUNK-MEASURED RATE 2 WAY' 'VOICE'
'TRUNK-MEASURED RATE OUTBOUND' 'VOICE'
'MULTIPLE' 'VOICE T-1'
'NATIONAL DIRECTORY ASSISTANCE' 'VOICE'
'NETWORK MANAGEMENT-LEC PROVIDED' 'VOICE T-1'
'OFF PREMISE EXTENSION' 'VOICE'
'OTHER USE' 'VOICE'
'PAGER SERVICE' 'VOICE'
'PRIVATE BRANCH EXCHANGE' 'VOICE T-1'
'PUBLIC BRANCH EXCHANGE' 'VOICE T-1'
'PRIVATE LINE DATA-SPECIAL USE' 'VOICE T-1'
'PRIVATE LINE VOICE-SPECIAL USE' 'VOICE'
'PORT/ATM' 'FRAME T-1'
'PORT FRAME' 'FRAME T-1'
'PVC ATM' 'FRAME T-1'
'PVC FRAME' 'FRAME T-1'
'PVC SIW' 'FRAME T-1'
'REMOTE CALL FORWARDING SERVICE' 'VOICE'
'REMOTE DIAL ACCESS' 'VOICE T-1'
'SIGNAL REPEATER' 'DATA T-1'
'SATELLITE COMMUNICATIONS SERVICE' 'DATA T-1'
'SWITCHED DIGITAL SERVICE-56KBS' 'DATA T-1'
'SWITCHED DIGITAL SERVICE-UNKNOWN TYPE' 'DATA T-1'
'SECOND LANGUAGE OPTION' 'VOICE'
'SYNCHRONOUS OPTICAL NETWORK-OC1' 'DATA T-1'
'SYNCHRONOUS OPTICAL NETWORK-OC12' 'DATA T-3'
'SYNCHRONOUS OPTICAL NETWORK-OC24' 'DATA T-3'
'SYNCHRONOUS OPTICAL NETWORK-OC3' 'DATA T-3'
'SYNCHRONOUS OPTICAL NETWORK-OC48' 'DATA T-3'
'SYNCHRONOUS OPTICAL NETWORK-OC96' 'DATA T-3'
'SUMMARY LEVEL CHARGES-CIRCUITS' 'DATA T-1'
'SUMMARY LEVEL CHARGES-FRAME/ATM' 'FRAME T-1'
'SUMMARY LEVEL CHARGES' 'VOICE'
'TIME AND MATERIALS' 'VOICE'
'AUDIO TELECONFERENCING SERVICE' 'CONFERENCE'
'TEMPORARY TELECOMMUNICATIONS SERVICE' 'VOICE'
'THRIFTY BILL' 'VOICE'
'TRUNK-2 WAY' 'LOCAL'
'TRUNK-2 WAY DIRECT INWARD DIAL' 'LOCAL'
'TRUNK-DIRECT INWARD DIAL' 'LOCAL'
'TRUNK-FX' 'LOCAL'
'TRUNK-INBOUND' 'LOCAL'
'TRUNK-MEASURED RATE INBOUND' 'LOCAL'
'TRUNK-OUTBOUND' 'LOCAL'
'TRUNK-UNKNOWN TYPE' 'LOCAL'
'TIE LINE' 'VOICE'
'TIME AND MATERIALS-LEASE/MAINTENANCE' 'VOICE'
'TRACKING ACCOUNT' 'VOICE T-1'
'WASTE REMOVAL SERVICE' 'VOICE'
'UNIDENTIFIED LINE' 'VOICE'
'VIDEO TELECONFERENCING SERVICE' 'CONFERENCE'
'VOICE MAIL' 'VOICE'
'VOICE CALLS OVER THE INTERNET PROTOCOL' 'INTERNET SVC'
'WATER AND SEWER SERVICE' 'VOICE'
'WATER SERVICE' 'VOICE'
'WIDE AREA TELEPHONE SERVICE' 'VOICE'
'WEB SERVICE' 'INTERNET SVC'
'WIRELESS DATA' 'DATA T-1');
END
-RUN

TABLE FILE CAR
PRINT COUNTRY NAME
END
-RUN

Perhaps there's something else in your program causing the error.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
August 22, 2007, 02:17 PM
Prarie
quote:
Well, I'll be ********.

Me too on that one Tony.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
August 22, 2007, 03:07 PM
kgleason
It works now. Using the example Francis gave.

Thanks for all you suggestions.
August 22, 2007, 03:12 PM
Tony A
Ken,

I also noticed a pairing that didn't have a space between them - 'SYNCHRONOUS OPTICAL NETWORK-OC24''DATA T-3', but that doesn't seem to be there in your last post.

I actually stripped out all the values for TYPE_, knocked up (sorry Mickey, "put together") a dynamic .mas and then ran the decode with the dupicates removed (how do you think I knew it was around 22?) and ran a quick TABLE request. It worked perfectly OK.

DHagen,

Yes, I have a job, I just don't have a life by the looks of things Wink

In my defence I would point out that Francis has been registered a year less than me so his posting rate is higher Music (64 a month as opposed to 39 Wink)

T

This message has been edited. Last edited by: Tony A,


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10