Datacom ACCT OPTION=EDIT error DB13239E

Products

• Datacom
• Datacom/AD
• Datacom/DB

Issue/Introduction

The  Datacom ACCT OPTION=EDIT function of DBUTLTY to add or modify an Accounting table to an existing Accounting database results in error DB13239E

 CONDITIONAL EXPRESSION:
 JTYPE NE '02' 
 DB13239E - EXCEEDS ELEMENT LENGTH NEAR POSITION 014 

Cause

For Accounting Tables, both conditional and logical expressions require double quotes ("), not single quotes (') to enclose the literal for hexadecimal fields.

Resolution

Correct the syntax to use double quotes (") instead of single quotes ('):

     JTYPE NE "02"

Additional Information

The following literal types can be used for comparison with accounting table elements:

• Unsigned integers (such as 12 or 1456).
• Character literals enclosed in single quotes. (Slashes (/) must not be used in any character literal.)
• Hexadecimal literals enclosed in double quotes.

Use the following syntax when expressing the literals which are being compared with elements of type C (character string), N (numeric string), B (unsigned binary), and D (packed decimal):

Element Type     Syntax for Literal  
C or N           'string' (in single quotes)
C or N           "hexadecimal, same length" (in double quotes)  
B or D           integer value (no punctuation)  
B or D           "hexadecimal, same length" (in double quotes) 

For documentation on accounting , see ACCT (Accounting Facility)