topic Re: SAP to SQL data transfer : Variable declaration issue.., in Application Development and Automation Discussions

SAP to SQL data transfer : Variable declaration issue..,

Former Member — Mon, 24 Sep 2012 08:58:32 GMT

Hi to all,

One of my object is to move data from SAP to native SQL in direct method.

I have created a database connection with username and password, while executing the program the connection obtained successfully.

Now what my problem is i am having data in my internal table ( local table called LT_FINAL ) , i looped the table and try to assign the values to SQL variables.

But its not taking the variable assignments.

Here the code what i write for your reff..

data kunnr type kna1-kunnr.

TRY.

     LOOP AT lt_final INTO lw_final.

       kunnr = lw_final-kunnr .

       EXEC SQL.

DECLARE @v1 varchar(10);

SET @v1 = :KUNNR ; " this variable assignment not yet accepted

            BEGIN TRANSACTION;

         insert into [SAPIT].[DBO].[customer_details] ( KUNNR , name1 )
         values ( @V1 , 'IUY') ;

           COMMIT TRANSACTION;

       ENDEXEC.

     ENDLOOP.

   CATCH cx_sy_native_sql_error INTO exc_ref.
     error_text = exc_ref->get_text( ).
     MESSAGE error_text TYPE 'E'.

ENDTRY.

help me to solve the issue.

Advance thanks,

M.S.Amirtharajvijay.

Re: SAP to SQL data transfer : Variable declaration issue..,

Former Member — Mon, 24 Sep 2012 10:59:35 GMT

Hi,

Why don't you try this? ( KUNNR is CHAR10 so should be same as VARCHAR(10).

insert into [SAPIT].[DBO].[customer_details] ( KUNNR , name1 )
values ( :KUNNR , 'IUY') ;

Hope it helps.

Regards,

Re: SAP to SQL data transfer : Variable declaration issue..,

Former Member — Mon, 24 Sep 2012 11:22:12 GMT

Hi Rudra Roy,

thanks for the reply..,

Its also not working Rudra..,

In SQL TRACE its returning "

BEGIN TRANSACTION; insert into [SAPIT].[DBO].[customer_details] ( KUNNR, name1 ) values ( ? , 'IUY' ) ; COMMIT TRANSACTION;

In this Values ( ? , 'IUY' ) in the place :kunnr its making ?

thanks ,

M.S.AmirtharajVIjay

Re: SAP to SQL data transfer : Variable declaration issue..,

Former Member — Mon, 24 Sep 2012 12:29:35 GMT

Ok. Are you getting any error message out of the exception handling?

Re: SAP to SQL data transfer : Variable declaration issue..,

Former Member — Mon, 24 Sep 2012 12:41:12 GMT

No Rudhra..,

after performing the insert process its moved to disconnect 'dbcon'.