HCI DS Global Variable and Script

dataservices job design
1

Hi,

If anyone who worked on HCI DS, can you please help with the below.

  1. Can we create User defined Global Variable in HCI DS?
  2. And can we assign a dynamic value to this global variable.
    for example select statement to fetch a record from table X.
    If these are possible then please share syntax for select statement on HCI DS.
    In On-Premise we usually give
    $GV = sql(‘Datastore’, 'select colname from table X);
    This statement isn’t working on HCI DS.
    Please help.

Jasmine4321 (BOB member since 2014-04-09)