Passing null to CORP by Native SQL

[Former Member]

Hi All,

I want to send null value to a date field of CORP table by using Native sql. But while checking data in CORP, i am getting value of date field as '1900-01-01'. But i want to store null.

Also plz let me know the syntax to declare a variable in native sql so that i can assign null value to it and insert accordingly.

Can any body please help me regarding this.

Thanks

Nitesh

[Former Member]

Try the following:

TRY.

EXEC SQL.

INSERT INTO z_table

( ..., z_date )

VALUES

( ..., NULL )

ENDEXEC.

CATCH cx_sy_native_sql_error INTO lv_exc_ref.

lv_error_text = lv_exc_ref->get_text( ).

ENDTRY.

[Former Member]

Thanks a lot.