Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 10 Dec 2004 @ 16:28:46 GMT


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


Subj:   BTEQ Inport and Export in same process(s) on MVS
 
From:   Capp.Luckett

Hi, again.

Thanks to Fred on his previous answer to my earlier question.

I copied this examples from the BTEQ manual, 11-04-2004 p. 298. I have used ===> to highlight my questions.

The following MVS JCL example selects data from the Employee table and saves it in a client data set (SAVEDATA). The example selects rows according to values of EmpNo contained in an input data set (DATA). (EmpNo is the prime key for the Employee table.)

//YNINPUT JOB1,'Your Name',CLASS=B,NOTIFY=YN,
// MSGCLASS=A,MSGLEVEL=(1,1)
//BTEQ EXECPGM=BTQMAIN
//STEPLIB DD DSN=TERADATA.APPLOAD,DISP=SHR
// DD DSN=TERADATA.TRLOAD,DISP=SHR
//INFILE DD DSN=YN.BTEQ.CNTL(DATA),DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSABEND DD SYSOUT=*
//SYSTERM DD SYSOUT=*
//SAVEDATA DD DSN=YN.SAVEDATA.TEXT,DISP=(NEW,CATLG),
// UNIT=SYSDA,SPACE=(TRK,(1,1),RLSE),
// DCB=(LRECL=80,RECFM=FB,BLKSIZE=800)
//SYSIN DD DATA,DLM=##
.IMPORT DATA DDNAME=INFILE
.EXPORT DATA DDNAME=SAVEDATA
.SET SESSIONS 2     ===>  Why is Sessions set to 2? For 2 processes 1 read input 2 extract?
.LOGON userid,password
.REPEAT 10     ===> Does repeat cmd correlate to the numer of input records I have?
USING EMPNO (CHAR(5)),     ===> Are there restrictions for the variable names?
FILLER (CHAR(75))     ===> Assuming that the rec length is 80, is it require to account for all

===> postions in the record?
SELECT * FROM PERSONNEL.EMPLOYEE
WHERE EMPNO = :EMPNO;
.EXPORT RESET
.QUIT
##
where:

Thanks in advance, AGAIN.

Capp Luckett



     
  <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: 27 Dec 2016