Archives of the TeradataForum

Message Posted: Fri, 07 Jan 2011 @ 10:37:25 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Jinesh P V wrote:

Hi Jinesh,

Thanks for the response..

1. can you please let me know the path "bteq_restart_step.txt" file to be created.

2. If the process fails in the label sql1 then how it will be handled, since the statement ".if errorcode = 0 then .os echo '.goto sql2' > bteq_restart_step.txt;" starts only after the sql1.

3. Which statement should come first

Generally when any condition fails in the script, when it come across the below statement i think it may exit from the program immediately.

          .if errorcode <> 0 then .goto EXIT_ERROR;

how come the below statment will be executed?

          .if errorcode = 0 then .os echo'.goto sql2' > bteq_restart_step.txt;

Thanks

Naveed

	<Prev	Next>		<<First	<Prev	Next>	Last>>