Archives of the TeradataForum

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

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

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>>