Iam Using INSTR and SUBSTRING in UNIX shell script. They are working in Teradata sql assistant but they both are not working in UNIX SHELL SCRIPT.
I changed SUBSTRING to SUBSTR and it worked. But i still have problem with INSTR. Can any one help me out.
SUBSTRING(str FROM startpos FOR length) -- Standard SQL
SUBSTR(str, startpos, length) -- Teradata SQL
For SUBSTRING i used SUBSTR and unix shell script recognized. But i Have Problem with INSTR in Shell script
The variation you wrote will never work in shell (=BTEQ), remove the INSTR and you still get the same error while INSTR standalone will work.