topic Re: Passing null to CORP by Native SQL in Application Development and Automation Discussions

Passing null to CORP by Native SQL

Former Member — Wed, 27 Jan 2010 14:17:02 GMT

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

Re: Passing null to CORP by Native SQL

Former Member — Mon, 01 Feb 2010 08:30:21 GMT

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.

Re: Passing null to CORP by Native SQL

Former Member — Wed, 10 Mar 2010 06:11:10 GMT

Thanks a lot.