local variable

local string ls_itemname

select "ItemName" into ls_itemname from oitm where itemcode=<itemcode,dbstring>

Format: You can only use the Format after ":", if the source is type "string"

Example:

select sum("OnHand") into lc_stock:#0.00 from "OITW" where ...

is not working.

instance variable

instance string ls_itemname

select "ItemName" into ls_itemname from oitm where itemcode=<itemcode,dbstring>

Format: You can only use the Format, if the source is type "string". Siee local Variable

str_parm

select "ItemName" into str_parm.s_parm1 from oitm where itemcode=<itemcode,dbstring>

window variable

// without declare

select "ItemName" into ls_itemname from oitm where itemcode=<itemcode,dbstring>

column in dw_1

set in dw_1 the field "itemname"

select "ItemName" into itemname from oitm where itemcode=<itemcode,dbstring>

dw_1-Column

example: select stock and set this in dw_2 column "currentstock"

select sum("OnHand") into dw_2.item.correntstock from "OITW" where "OITW"."ItemCode"='ls_itemcode,dbstring>

with format: ..into itemcode:lower from ...

Only in the current row in dw_1. if you want a other row, use ..into dw_1.itemcode:[ll_row] from ...

dw_x in row y

you can define the row in :row:format

if you've no format, set :row:

example: select stock and set this in dw_2 column "currentstock" in row

for ll_loop=1 to <dw_2.rowcount>

 select sum("OnHand") into dw_2.item.correntstock:[ll_loop]: from "OITW" where &    

    "ItemCode"=<dw_2.item.itemcode:[ll_loop].value,dbstring>

next

Short form:

You can write: .. into dw_2.item.onhand.value:[row]:format from..

without row and format: .. into dw_2.item.onhand.value from ..

without item and value-keyword: .. into dw_2.onhand from ..

without item and value-keyword, with row: .. into dw_2.onhand:[row]:format from ..

or only format: .. into dw_2.itemname:left 20 from ..

Use HANA-Syntax in MS - SQL

is converting in (MS SQL)

select 'A'||'B' ,3+5 from "BEAS_DUMMY"

select 'A'+'B',3+5 from "BEAS_DUMMY"

select IfNull("ItemCode") from "OITM"

Akternative: use coalesce

select isnull(itemcode) from OITM

select now() from "BEAS_DUMMY"

select getdate() from BEAS_DUMMY

select max(5) "ItemCode" from "OITM"

select top 5 ItemCode from OITM

select rpad(' ',10) as emptystring from "BEAS_DUMMY"

select replicate(' ',10) as emptystring from BEAS_DUMMY

select add_date(now(),5) from "BEAS_DUMMY"

select dbo.add_date(getdate(),5) from BEAS_DUMMY

(the function dbo.add_date use dateadd(xx,yy) )

select to_varchar(now(),'yyyy-mm-dd')

select dbo.to_varchar(getdate(),'yyyy-mm-dd')

(the function dbo.to_varchar use convert)

MSSQL

hana

Alternativ

select isnull(a,b)

select ifnull(a,b)

select coalesce(a,b)

select 'hello'+'world'

select 'hello'||'world

no solution, because concat is not available in old mssql version

select space(50)

select rpad(50)

select cast('' as nvarchar(50))

Info

Correct

Wrong

use Cast and not convert

select cast("OnHand" as varchar) as onHandAsVarchar from "OITW"

select convert(varchar(20),"OnHand") as onHandAsVarchar from "OITW"

use from "BEAS_DUMMY" if you've no reference to a table

select 1+2 from "BEAS_DUMMY"

select 1+2

use "||" if you add a string

but use "+" for adding numbers

select 'A'||'B',3+4 from "BEAS_DUMMY"

select 'A'+'B',3+4

don't use dateadd(x,y)

use add_date(), add_month(), add_year(),

select add_year(now(),5)

select dateadd(yy,getdate())

convert datetime use dbo.to_varchar(x,y)

select to_varchar(now(),'yyyy-mm-dd')

select cast (now() as varchar(10))