|
View previous topic :: View next topic
|
| Author |
Message |
ravi30
Currently Banned
New User
Joined: 04 Oct 2007
Posts: 10
Location: chennai
|
|
|
|
i have adb2 table and need to move data entered on a map to the table.
i was able to move everything except the first 2 letters or characters from every field! simlply couldnt understand why? i have checked my code and there are no overlapping fields!
like when i enter
id- a1234
name - rahul
place -london
father- prakash
i see my table as
id name place father
234 hul ndon akash
i.e the first 2 characters of all the fields are not in my table
can anyone guess what the probs would be? |
|
| Back to top |
|
 |
Craq Giegerich
Senior Member
Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA
|
|
|
|
| ravi30 wrote: |
i have adb2 table and need to move data entered on a map to the table.
i was able to move everything except the first 2 letters or characters from every field! simlply couldnt understand why? i have checked my code and there are no overlapping fields!
like when i enter
id- a1234
name - rahul
place -london
father- prakash
i see my table as
id name place father
234 hul ndon akash
i.e the first 2 characters of all the fields are not in my table
can anyone guess what the probs would be? |
Are the fields defined as VarChar? |
|
| Back to top |
|
|
ravi30
Currently Banned
New User
Joined: 04 Oct 2007
Posts: 10
Location: chennai
|
|
|
|
| yes it has fields with varchar! so is there any problem with it! |
|
| Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA
|
|
|
|
| ravi30 wrote: |
| yes it has fields with varchar! so is there any problem with it! |
varying char field has the length in the first 2 bytes followed by the data. Look in the DB2 Manuals. |
|
| Back to top |
|
|
ravi30
Currently Banned
New User
Joined: 04 Oct 2007
Posts: 10
Location: chennai
|
|
|
|
oh thanks for the very answer craq.
actually i have only varchar and integer fields in my table and as u said if varchar has the length in the first 2 bytes then what about integers craq
im missing them even for the phone numbers and pincode fields i enter! |
|
| Back to top |
|
|
fayazbashask
New User
Joined: 28 Jun 2007
Posts: 9
Location: Hyderabad
|
|
|
|
Hi,
the first thing you can check with length and your picture clauses.
The next but important thing is you might have not given the TIOAPFX=YES in your map, this also causes this type of problems
Regards,
Fayaz |
|
| Back to top |
|
|
|
|
