I have a scenario where I need to writed a query if the ERRORCODE condition satisfies in BTEQ .the Query is quite large and have many Joins , so is there any way I can put it to next line, since when I put the next line it doesn't work.
Workaround for the same would be helpful but need to have it after then.
Thanks in advance.
I m not able to understand it properly. It looks like you just want to copy and paste the code. Try to put in a viewable way and press enter or in some unix env , you need to put front slash \, say like in unix script:
you might either omit the period in front of IF or utilize GOTO/LABEL:
.IF ERRORCODE = 0 THEN .GOTO skipit
IF ERRORCODE <> 0 THEN
BTEQ commands must be preceded by a period '.'
so use .IF in your BTEQ.So query must be
.IF ACTIVITYCOUNT=2 THEN