VARCHAR definition..if length is not given what will happen?

vverma9 · New User Joined: 20 Jun 2007 Posts: 2 Location: noida

Hi,

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??

vverma9,Mumbai

dbzTHEdinosauer · Posted: Thu Jul 29, 2010 5:40 pm Post subject:

1) no
2) won't work.
don't know,don't care.
no

Bharath Bhat · Posted: Fri Jul 30, 2010 4:18 pm Post subject:

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.

dbzTHEdinosauer · Posted: Fri Jul 30, 2010 6:00 pm Post subject:

you can not reference the 49 levels in sql, you must reference the group item.

and as Bharath Bhat said,
with select, db2 sets the length-variable.

UPDATE, INSERT you have to set the host variable to an appropriate value
before invoking the SQL

Craq Giegerich · Posted: Fri Jul 30, 2010 6:54 pm Post subject:

On an update or insert DB2 will use the first 2 bytes as the length!

dbzTHEdinosauer · Posted: Fri Jul 30, 2010 7:01 pm Post subject: