Tags

, , , , , , , , , , , ,

Some DB2 columns defined as CHAR or VARCHAR can eventually store both character data and numeric data. Some of these might be just numeric data all together. Now because of loading data into this table from a csv file, there are chances that “all numeric” fields loaded into these columns are loaded as right justified. When these should have been loaded as left justified. To rectify this, we need to first identify the rows that have “all numeric” data in this fields and then update them to be left justified.

To identify if the CHAR or VARCHAR field (col1) has “all numeric” data, below check can be done.

1) TRANSLATE(col1, ‘X ‘,’ 0123456789′) = ‘ ‘

2) UCASE(col1) = LCASE(col1) —-> both will be same only for numeric

3) col1 LIKE ‘ %’ —-> As numeric data is right justified, this can be checked.

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

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