Define host variables for VARCHAR cols in DB2 as fallows:
01 varchar.
49 len pic 9(4) comp.
49 data pic x(200).
My Question's are:
1) Can I define the length variable other than 'COMP' picture clause mentioned above in Sql DB2?
2) What happened If I have not given the length parameter in the Varchar definition?? What abend code it will send?? Should it will take the default length??
I have seen few working codes handling varchar without the length variable. This would work only for selects. I had to modify one such program and I followed the variable definitions. The update and inserts were not appropriate without the length variable.