Capstone Fundamental Ex 1.5

https://learninghub.kx.com/forums/topic/capstone-fundamental-ex-1-5

refServiceHandle: hopen ::5010 **1.5 Using the handle refServiceHandleand theuniqueOptsvariable we created before, call thegetOptionRefAPI and retrieve the associated Options Reference data. Store the returned table in a variableoptRef`.**

optRef: refServiceHandle(`getOptionRef;uniqueOpts)

Using this line of code is not working. IPC says blocked. How do I fix it?

 

I notice for your uniqueOpts variable you’ve declared it as:

uniqueOpts: enlist (select distinct option_id from trade)

Tables are created out of lists, so by enlisting the option_id column you are creating a list of a list.

Since we already have our list, we just want to convert this into a list format. To do this you can use the exec keyword.

Once you’ve edited this, it should work fine.

Thanks,

Megan

Thanks Megan! It’s working for me now!