After struggling for a while I seem to have found that the interactive SQL requires a space after a comma when using SUBSTR.
For example
Is this normal? I'm using V6R1M1.
For example
Code:
> SELECT SUBSTR[B](QQPARM,1,5)[/B] FROM QAQQINI TOKEN ,1 WAS NOT VALID. VALID TOKENS: ) ,. > SELECT SUBSTR[B](QQPARM,1, 5)[/B] FROM QAQQINI TOKEN ,1 WAS NOT VALID. VALID TOKENS: ) ,. > SELECT SUBSTR[B](QQPARM, 1,5)[/B] FROM QAQQINI ARGUMENT 2 OF FUNCTION SUBSTRING NOT VALID. > SELECT SUBSTR[B](QQPARM, 1, 5)[/B] FROM QAQQINI SELECT STATEMENT RUN COMPLETE ===>
Comment