Hi,
I am migrating data from sybase database.
the datatypes in the table structure are having char datatype and the value is not inserted exactly. so blank spaces are also getting inserted.
please let me know to overcome the problem
Thanks in advance.
srinivas.
COLUMN_NAME char(SPECIFY THE SIZE) "rtrim(:notes)"
THIS SHOULD WORK, FOR EXAMPLE, IF "NOTES" IS THE NAME OF THE COLUMN AND IT IS 2000 CHARACTERS LONG IN THE DATAFILE THEN,
NOTES CHAR(2000) "RTRIM(:NOTES)"
WILL WORK
my problem is i have a column CHAR(6) datatype
but the value which is getting inserted is 'DANY' but it is getting inserted 'DANYbb'(where bb is blanks) i dont want to insert blanks.
As there are around 1300 tables which i am loading the data i am getting a problem how to migrate the tables data exactly which is not having white spaces in the CHAR datatype fields.