bteq_restart_step.txt;" starts only after the sql1." />
Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: BTEQ Restart Logic
From:   Naveedahmed

Jinesh P V wrote:

  Not a clean solution, but works.
Create an empty file "bteq_restart_step.txt" before you start bteq.
Change ".os" commands according to the OS.

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;



  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023