Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 08 Nov 2004 @ 13:59:09 GMT


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


Subj:   Re: Executing Dynamic SQL using BTEQ scripts
 
From:   Michael Larkins

Parijat:

It looks like you did not read the comments that I put into my reply to you. The problem you are experiencing has nothing to do with BTEQ. Instead, it has everything to do with your JCL. You have probably defined the DATAOUT DD statement with a DISP of NEW (output) in order to build the file. Now you want to read it. I would create another DD statement with a DISP of OLD or SHR to read it instead of writing it. That is why I referenced DATAIN or call it CMDSIN so that the name more closely references an input operation instead of an output and the content is commands and not data. That way if someone becomes responsible for maintaining the job, it is easier to understand as well as being functional.

Also, since I have not seen your final script and therefore do not know if you are using REPORT instead of data. The other thing that I indicated but did not change in your SQL is the TITLE. Since any heading will not execute you need to have no title (heading) for each column. Therefore, you need to follow each column with: (TITLE ' ')


Good luck,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor



     
  <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