My CL program has RUNSQLSTM. The SQL source has some SQL statements(source is of type SQL) which inserts value to a file. I need to change the SQL to have a column(FLD1) value like this
(A*B*C)/10**D. A,B,C, and D are file fields. The attributes are like this
C - (13,5)
D - 1
I have put the expresstion as (A*B*C) *DEC(1/POWER(10,D)) FLD1
I am getting error SQL0406 Position 1 Conversion error on assignment to column
Please let me know how to put the expression.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!