I found this useful. I have been using different method to find if we have decimals in an amount field.

This method seems to be easy and quick. Below query pulls account details for accounts that have values in 4 decimal places (there are 4 _ in the LIKE expression below)

SELECT ACCOUNT_NO, ACCOUNT_BALANCE
FROM ACCOUNT (NOLOCK)
WHERE ACCOUNT_BALANCE LIKE ‘%.__%’
;

——————————————————————————————————–

If you would like to Earn Free Stocks, Credit card Points and Bank account Bonuses, Please visit My Finance Blog

——————————————————————————————————–

You may also like to look at:

Working on Mainframes – Is Change to a different technology necessary

Important SQL CODES and ABEND CODES

SORT JOIN – TO JOIN TWO FILES BASED ON A KEY

KNOW YOUR MAINFRAME

REXX – INITIAL SETUP

HOW TO SUBMIT A BATCH JOB FROM THE CICS PROGRAM

CICS – EXEC interface block – EIBRESP Values

CICS – EXEC interface block Fields

Flow of control between COBOL programs, run units, and CICS

CICS INTERVIEW QUESTIONS

CICS TIPS

COBOL – COPY and INCLUDE statements

COBOL – PERFORMANCE IMPROVEMENT

COBOL – SIGN STORED IN COMP, COMP-3 AND DISPLAY FORMATS

SHORTEST COBOL PROGRAM

RESTART LOGIC IN COBOL DB2 Program

GOBACK – EXIT PROGRAM – STOP RUN

Continuation lines in COBOL

Computational items – COMP, COMP 1 , COMP 2, COMP 3

COBOL program format

cobol indicator area column-7 and area a and area b

COBOL INTERVIEW QUESTIONS

COBOL TIPS

COBOL COMPILER OPTIONS

The IDENTIFICATION DIVISION