Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

data upload inconsistency from notepad to database table

Former Member

‎05-27-2008 3:38 PM

0 Kudos

Hi I am uploading data from notepad to a database table which has two columns. The data is being read but the data in second column is not reading correctly.

Eg: Col1 Col2

A 1

B 2

C 3

Data in Col1 is being uploaded correctly, but data in Col2 is always taking value 9 into the database table. Please help me with this. Thanks in Advance.

2 REPLIES 2

Former Member

‎05-27-2008 3:40 PM

0 Kudos

check in your debudding mode, whats the value in the internal table.

Check the domain of the data element in the DB TAB whether it contains any fixed values?

Reward points if useful.

Rgds,

Anita

Former Member

‎05-27-2008 3:55 PM

0 Kudos

Hi Srinivas,

Check the below points.

1. The text file have any separator or not. if there is no separator, check the length of the fields in the table and file.

Ex: 1st field length is 10

1st field length is 10

then your text file data per record should be 20 char length.

2. The fields in the table should be char.

Reward if found helpful.

Regards,

Boobalan Suburaj