topic Re: Syntax to declare a variable in native sql in Application Development and Automation Discussions

Syntax to declare a variable in native sql

VivekG — Wed, 27 Jan 2010 14:25:33 GMT

Hi Experts,

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

Vivek Gupta

Re: Syntax to declare a variable in native sql

Former Member — Wed, 27 Jan 2010 14:38:47 GMT

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

Re: Syntax to declare a variable in native sql

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

Hello

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

There is example of native SQL.

Re: Syntax to declare a variable in native sql

VivekG — Thu, 28 Jan 2010 05:02:22 GMT

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

Re: Syntax to declare a variable in native sql

SuhaSaha — Thu, 28 Jan 2010 05:18:13 GMT

Hello Vivek,

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

BR,

Suhas