topic Re: download/upload Unicode data into database table in Application Development and Automation Discussions

download/upload Unicode data into database table

Former Member — Tue, 02 Nov 2010 21:11:34 GMT

Hi folks,

I have reqirement to download data from a series of tables that has unicode data (tables have fields in decimal format, number) and then upload the same in a different client. I have this code tha works fine for non uncoide compatibility. I have just pasted the download option. Unable to download data from a table that has decimal fields. I have to take this apporach because I have a huge list of tables that I need to download in one shot and upload the data in one shot instead of taking each table at once.

Any thoughts of doing this a different way? Please advise. Thanks in advance.

data:v_tabname like dd02l-tabname,

Data: begin of i_list occurs 0,

i_tabledata(2550) type c,

end of i_list.

Data: begin of i_final1 occurs 0,

record_num(4) type n,

table_name(20) type c,

i_tabledata(2550) type c,

Re: download/upload Unicode data into database table

Former Member — Tue, 02 Nov 2010 21:19:56 GMT

If you're simply updating data in a different client there's no need to upload or download. You can insert directly with CLIENT SPECIFIED.

Rob

Re: download/upload Unicode data into database table

Former Member — Tue, 02 Nov 2010 21:28:50 GMT

I did not understand your point of view. It isa different client box altogether. Can you elaborate?

Thanks,

Re: download/upload Unicode data into database table

_IvanFemia_ — Tue, 02 Nov 2010 23:04:59 GMT

Hi,

see INSERT keyword documentation and in particular CLIENT SPECIFIED suffix.

Regards,

Ivan

Re: download/upload Unicode data into database table

Former Member — Fri, 03 Dec 2010 15:03:10 GMT

This message was moderated.