When Inserting, Column variables are taking spaces

lokeshpg · New User Joined: 16 Sep 2005 Posts: 10

HI

I'm trying to insert values into an existing table through my db2 application program,but instead of taking the values that i have specified,
the column variables are taking spaces and some other values.

can anyone helpme in solving this problem?

logaas · New User Joined: 19 Feb 2005 Posts: 25 Location: chennai

Varchar fields in the db2 table have 2 parts in the host variable structure
generated by dclgen-

eg:

name varchar(20)

will have

name-text x(20)
name-len s9(4)

Have u moved spaces to the host variable corresponding to the varchar fields and then move the value to the text portion of the hostvariable

regards

logaas

krishnaiahc · New User Joined: 31 Aug 2005 Posts: 21

I'm trying to insert values into an existing table through my db2 application program,but instead of taking the values that i have specified,
the column variables are taking spaces and some other values.

As per my understanding u'r trying to insert the values into table. but isn't take what u have specified. The table has some other value that is not specified by yourself (i.e space or some value).

If yes, it is due to table creation constraints(i.e default values for the columns).

can anyone helpme in solving this problem?

Hai All ,
If it's not suitable answar please let me correct answer...

Thanks,
Krishna.

khamarutheen · Active Member Joined: 23 Aug 2005 Posts: 677 Location: NJ

hi,
plz check the datatypes specified and make sure that you are moving the right value to the right variable. may be the wrong and also if its varchar as per above solution move the length first and then the text.

correct me if i m wrong