Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 11 Oct 2006 @ 17:04:54 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Dynamic SQL on Mainframe
From:   Fachtna O Donovan


We are doing an upgrade in the next few weeks and would like to automate some of our validation scripts. What we want to do is create a table that has DatabaseName, TableName and row counts in it.

We have created SQL to generate the insert select statement with the count(*) etc. see below. When we generate a file from this SQL using a fast export the file is about Char(200) in length. What we want to do is generate the SQL, Fast Export it to a file and run the exported file to populate a results table. Unfortunately the Mainframe only lets us use DML scripts of 80.

I know that Carriage Return in both ASCII and EBCDIC in hex is 0D, is there any way that we put this carriage return into our fast export so our file will be less that 80 chars in length.

If you can help us this will save us a load of work!

     ||'SELECT '
     || ''''
     || DB_NAME
     || ''''
     || ','
     || ''''
     || trim(TAB_NAME)
     || ''''
     ||',COUNT(*) FROM '||DB_NAME||'.'||trim(TAB_NAME)||' GROUP BY 1,2;'


Fachtna O'Donovan
Software Engineer
AIB Bank

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