Sh: -c: line 0: syntax error near unexpected token `(' how to resolve this

Applications Programming
1

Below query is not working for me. Please help me on this

DATA EXCLUDE STATEMENT: TABLE:\"LIKE \'%\_HISTORY\'\", TABLE:\"LIKE \'%\_HIST\'\", TABLE:\"in \(select tname from tab where REGEXP_LIKE(TNAME,\'\_H$\'\))\", TABLE:\"LIKE \'%\_LOG\'\", TABLE:\"LIKE \'DW\_%\'\", TABLE:\"LIKE \'SIM_BLOB%\'\", TABLE:\"LIKE \'OP\_SERVICES\_%\'\"

sh: -c: line 0: syntax error near unexpected token `('
2

Welcome on board,
We are missing what shell, language, OS and their versions you are using...

in \(select tname from tab where REGEXP_LIKE(TNAME,\'\_H$\'\))\"

From what I see above, not knowing the language I would say after REGEXP_LIKE either \ is missing on all the following brackets but one, or if this part is correct the protected bracket H$\'\)) is the wrong one, should be the next one

1 Like