Syntax to declare a variable in native sql

[VivekG]

Hi Experts,

Please let me know the syntax to declare a variable in Native SQL.

Vivek Gupta

[Former Member]

Well, you don't declare variables in native SQL, you declare it in the ABAB, but the usage depends on the database you are using.

Press F1 on EXEC SQL.

Rob

[VivekG]

Hi Rob,

Thanks for the answer but my requirement is to insert a NULL value in corp database and it can't be done by declaring variable in ABAP side as when we pass '' to corp, its getting defaulted as 01-01-1900 but we need NULL to be inserted in other table.

Please help

Vivek

[SuhaSaha]

Hello Vivek,

I guess this is so because you cannot insert NULL to a date field.

BR,

Suhas

[Former Member]

Hello

Check this link: http://help.sap.com/saphelp_47x200/helpdata/en/7b/0bdea252d746429420007a69bd06c7/frameset.htm

There is example of native SQL.

Also read this:

http://help.sap.com/saphelp_nw04/helpdata/EN/fc/eb3b8b358411d1829f0000e829fbfe/content.htm

http://help.sap.com/saphelp_nw04/helpdata/EN/a3/74caa1d9c411d1950e0000e8353423/content.htm