Skip to Content
0

VERY URGENT - OPEN SQL With HANA - Problems with Charset UTF-8

Jun 27, 2017 at 07:57 PM

64

avatar image
Former Member

Hi guys,

I'm facing the following problem: I have a SAP EHP7 with HANA and using a DBCO to transport data to a external DB. I changed the Charset of my string to UTF-8 and it works fine when a execute the program on line by SE38. The problem is when a execute by JOB.

Looks like the program do not get the UTF information and my EXEC SQL gets a DUMP, saying that some fields is null, because did not get all information. I created the JOBs using the FMs, JOB_OPEN, JOB_SUBMIT and JOB_CLOSE.

CALL FUNCTION 'JOB_OPEN'
EXPORTING
jobname = <jobname>
jobclass = 'A'
IMPORTING
jobcount = <jobcount>
EXCEPTIONS
cant_create_job = 1
invalid_job_data = 2
jobname_missing = 3
OTHERS = 4.

CALL FUNCTION 'JOB_SUBMIT'
EXPORTING
authcknam = sy-uname
jobcount = <jobcount>

jobname = <jobname>

language = sy-langu
report = <programname>
variant = v_var .

It always worked fine without hana database, but with the migration i'm facing this problems.

Did I forgot something? Could you please help me?

Thanks a lot.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers