Issues found in "Informatics Metric i2b2-ACT MSSQL.sql"
Closed this issue · 1 comments
edneu commented
There are two issues with the script that I had to modify in order to make it run:
*Line 127 - incorrect syntax for commenting (i.e., should replace '//' with '--')
*Line 144 - incorrect table name (i.e., it should be NCATS_DEMOGRAPHICS from the metadata table rather than PCORNET_DEMO. The PCORNET_DEMO would be a correct table name for PCORNET script, but not for i2b2-ACT script.)
There is one more issue, which didn't stop me from executing the script, but it doesn't do anything useful:
*Line 88 - the sql command requres 'lower(c_operator) in (''in'', ''='')'
KenGersing commented
Thank you for your help I changed both line 127 and 144. I left 88 as is