Forum Discussion

raji's avatar
raji
Regular Visitor
9 years ago

user parameter in dynamic query

Hello!   I'm trying to pass the value of a parameter to my dynamic query statement so that I can limit the dataset on the source db (dealing with extremely large data).   I tried the following......
Need Help
ankitpatira's avatar
ankitpatira
Community Champion
9 years ago

raji I think you're just missing double quotes. Pass in parameter as shown in image below with double quotes.

 

 

  • raji's avatar
    raji
    Regular Visitor
    9 years ago

     Thanks ankitpatira !  I tried that but got an error:

     

    New script:

    let
    Source = SapHana.Database("server",
    [Query="select ""VBAK"".""VBELN"", ""VBAK"".""AUART""
    from ""schema"".""VBAK""
    where ""VBAK"".""ERDAT"" > """& Start & """
    "])
    in
    Source

     

    It shows the following query:

    select "VBAK"."VBELN", "VBAK"."AUART"
    from "schema"."VBAK"
    where "VBAK"."ERDAT" > "20160101"

     

    but the hana system needs the date without the quotes as it's throwing the following error message:

    DataSource.Error: ODBC: ERROR [S1000] [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;260 invalid column name: 20160101: line 3 col 24 (at pos 200)
    Details:
    DataSourceKind=SapHana
    DataSourcePath=server
    OdbcErrors=Table

     

    Any ideas? Thanks!