TPUMP NOT WORKING

Teradata Applications
Enthusiast

TPUMP NOT WORKING

I have the below code For T-PUMP WHICH IS not working .Please help me because t-pump has very less number of 
posts online

bteq<<eof1
SESSIONS 1;
LOGTABLE Etlt5.EMP_TPUMP_LOG;
.logon ttdbia/a0c9sx,blue@126;
BEGIN LOAD
PACK 5
RATE 10
ERROR TABLE EMPDB.TPUMPERROR;
 
.LAYOUT RECLAYOUT;
.FIELD id * varchar(10);
.FIELD name * varchar(20);
.FIELD country * varCHAR(30);
 
.DML LABEL INSERT_INFA_SOURCE12
INSERT INTO etlt5.infa_source12
(id,name,country)
VALUES
(:id, :name, :country);
 
.IMPORT INFINE /home/a0c9sx/SQLAExport.txt;
LAYOUT RECLAYOUT
APPLY INSERT_INFA_SOURCE12
.END LOAD;
.LOGOFF;

Errors:
$ ./tpump.sh
BTEQ 14.10.00.03 Sun Mar 20 01:00:09 2016 PID: 27983954
+---------+---------+---------+---------+---------+---------+---------+----
SESSIONS 1;
 *** Warning: Expected a '.' before the command
+---------+---------+---------+---------+---------+---------+---------+----
LOGTABLE  Etlt5.EMP_TPUMP_LOG;
 *** Warning: You must log on before sending SQL requests.
+---------+---------+---------+---------+---------+---------+---------+----
.logon ttdbia/a0c9sx,
 *** Logon successfully completed.
 *** Teradata Database Release is 15.10.01.03
 *** Teradata Database Version is 15.10.01.03
 *** Transaction Semantics are BTET.
 *** Session Character Set Name is 'ASCII'.
 *** Total elapsed time was 1 second.
+---------+---------+---------+---------+---------+---------+---------+----
 BEGIN LOAD SESSIONS 1;
BEGIN LOAD SESSIONS 1;
      $
 *** Failure 3706 Syntax error: Expecting the word QUERY.
                Statement# 1, Info =7
 *** Total elapsed time was 1 second.

+---------+---------+---------+---------+---------+---------+---------+----
 
 .LAYOUT RECLAYOUT;
 *** Error: Unrecognized command LAYOUT
+---------+---------+---------+---------+---------+---------+---------+----
 .FIELD    id        * varchar(10);
 *** Error: Unrecognized command FIELD
+---------+---------+---------+---------+---------+---------+---------+----
.FIELD    name      * varchar(20);
 *** Error: Unrecognized command FIELD
+---------+---------+---------+---------+---------+---------+---------+----
.FIELD    country   * varCHAR(30);
 *** Error: Unrecognized command FIELD
+---------+---------+---------+---------+---------+---------+---------+----

 .DML LABEL INSERT_INFA_SOURCE12
 *** Error: Unrecognized command DML
+---------+---------+---------+---------+---------+---------+---------+----
INSERT INTO etlt5.infa_source12
(id,name,country)
VALUES
(:id, :name, :country);
 *** Failure 3857 Cannot use value (or macro parameter) to match 'id'.
                Statement# 1, Info =0
 *** Total elapsed time was 1 second.

+---------+---------+---------+---------+---------+---------+---------+----

 .IMPORT INFINE /home/a0c9sx/SQLAExport.txt;
 *** Warning: No IMPORT mode was given, assuming field mode.
 *** Syntax Error: Expected FILE or DDNAME keyword, not "INFINE".
 *** Warning: Extra text found after command.
              The text '/home/a0c9sx/SQLAExport.txt' not processed (ignored).
+---------+---------+---------+---------+---------+---------+---------+----
 LAYOUT RECLAYOUT
APPLY INSERT_INFA_SOURCE12
 .END LOAD;
LAYOUT RECLAYOUT
        $
 *** Failure 3706 Syntax error: expected something between the beginning of
 the request and the word 'LAYOUT'.
                Statement# 2, Info =9
 *** Total elapsed time was 1 second.

+---------+---------+---------+---------+---------+---------+---------+----
 *** Warning: EOF on INPUT stream.
.LOGOFF;
 *** You are now logged off from the DBC.
 *** BTEQ exiting due to EOF on stdin.
 *** Exiting BTEQ...
 *** RC (return code) = 8
$ ./tpump.sh
BTEQ 14.10.00.03 Sun Mar 20 01:06:47 2016 PID: 27984012
+---------+---------+---------+---------+---------+---------+---------+----
SESSIONS 1;
 *** Warning: Expected a '.' before the command
+---------+---------+---------+---------+---------+---------+---------+----
LOGTABLE  Etlt5.EMP_TPUMP_LOG;
 *** Warning: You must log on before sending SQL requests.
+---------+---------+---------+---------+---------+---------+---------+----
.logon ttdbia/a0c9sx,
 *** Logon successfully completed.
 *** Teradata Database Release is 15.10.01.03
 *** Teradata Database Version is 15.10.01.03
 *** Transaction Semantics are BTET.
 *** Session Character Set Name is 'ASCII'.
 *** Total elapsed time was 1 second.
+---------+---------+---------+---------+---------+---------+---------+----
BEGIN LOAD
PACK 5
RATE 10
ERROR TABLE EMPDB.TPUMPERROR;
BEGIN LOAD
      $
 *** Failure 3706 Syntax error: Expecting the word QUERY.
                Statement# 1, Info =7
 *** Total elapsed time was 1 second.

+---------+---------+---------+---------+---------+---------+---------+----

 .LAYOUT RECLAYOUT;
 *** Error: Unrecognized command LAYOUT
+---------+---------+---------+---------+---------+---------+---------+----
 .FIELD    id        * varchar(10);
 *** Error: Unrecognized command FIELD
+---------+---------+---------+---------+---------+---------+---------+----
.FIELD    name      * varchar(20);
 *** Error: Unrecognized command FIELD
+---------+---------+---------+---------+---------+---------+---------+----
.FIELD    country   * varCHAR(30);
 *** Error: Unrecognized command FIELD
+---------+---------+---------+---------+---------+---------+---------+----

 .DML LABEL INSERT_INFA_SOURCE12
 *** Error: Unrecognized command DML
+---------+---------+---------+---------+---------+---------+---------+----
INSERT INTO etlt5.infa_source12
(id,name,country)
VALUES
(:id, :name, :country);
 *** Failure 3857 Cannot use value (or macro parameter) to match 'id'.
                Statement# 1, Info =0
 *** Total elapsed time was 1 second.

+---------+---------+---------+---------+---------+---------+---------+----

 .IMPORT INFINE /home/a0c9sx/SQLAExport.txt;
 *** Warning: No IMPORT mode was given, assuming field mode.
 *** Syntax Error: Expected FILE or DDNAME keyword, not "INFINE".
 *** Warning: Extra text found after command.
              The text '/home/a0c9sx/SQLAExport.txt' not processed (ignored).
+---------+---------+---------+---------+---------+---------+---------+----
 LAYOUT RECLAYOUT
APPLY INSERT_INFA_SOURCE12
 .END LOAD;
LAYOUT RECLAYOUT
        $
 *** Failure 3706 Syntax error: expected something between the beginning of
 the request and the word 'LAYOUT'.
                Statement# 2, Info =9
 *** Total elapsed time was 1 second.

+---------+---------+---------+---------+---------+---------+---------+----
 *** Warning: EOF on INPUT stream.
.LOGOFF;
 *** You are now logged off from the DBC.
 *** BTEQ exiting due to EOF on stdin.
 *** Exiting BTEQ...
 *** RC (return code) = 8
Tags (1)
4 REPLIES
Enthusiast

Re: TPUMP NOT WORKING

CAN any one plz reply??

Junior Contributor

Re: TPUMP NOT WORKING

BTEQ and TPUMP are different utilities...

Enthusiast

Re: TPUMP NOT WORKING

@Deiter ,i have edited the script but the same errors i'm facing

TPUMP<<eof1

SESSIONS 1;

LOGTABLE Etlt5.EMP_TPUMP_LOG;

.logon ttdbia/a0c9sx,blue@126;

BEGIN LOAD

PACK 5

RATE 10

ERROR TABLE EMPDB.TPUMPERROR;

 

.LAYOUT RECLAYOUT;

.FIELD id * varchar(10);

.FIELD name * varchar(20);

.FIELD country * varCHAR(30);

 

.DML LABEL INSERT_INFA_SOURCE12

INSERT INTO etlt5.infa_source12

(id,name,country)

VALUES

(:id, :name, :country);

 

.IMPORT INFINE /home/a0c9sx/SQLAExport.txt;

LAYOUT RECLAYOUT

APPLY INSERT_INFA_SOURCE12

.END LOAD;

.LOGOFF;

 

 

Errors:

$ ./tpump.sh

BTEQ 14.10.00.03 Sun Mar 20 01:00:09 2016 PID: 27983954

+---------+---------+---------+---------+---------+--- ------+---------+----

SESSIONS 1;

 *** Warning: Expected a '.' before the command

+---------+---------+---------+---------+---------+--- ------+---------+----

LOGTABLE  Etlt5.EMP_TPUMP_LOG;

 *** Warning: You must log on before sending SQL requests.

+---------+---------+---------+---------+---------+--- ------+---------+----

.logon ttdbia/a0c9sx,

 *** Logon successfully completed.

 *** Teradata Database Release is 15.10.01.03

 *** Teradata Database Version is 15.10.01.03

 *** Transaction Semantics are BTET.

 *** Session Character Set Name is 'ASCII'.

 *** Total elapsed time was 1 second.

+---------+---------+---------+---------+---------+--- ------+---------+----

 BEGIN LOAD SESSIONS 1;

BEGIN LOAD SESSIONS 1;

      $

 *** Failure 3706 Syntax error: Expecting the word QUERY.

                Statement# 1, Info =7

 *** Total elapsed time was 1 second.

 

+---------+---------+---------+---------+---------+--- ------+---------+----

 

 .LAYOUT RECLAYOUT;

 *** Error: Unrecognized command LAYOUT

+---------+---------+---------+---------+---------+--- ------+---------+----

 .FIELD    id        * varchar(10);

 *** Error: Unrecognized command FIELD

+---------+---------+---------+---------+---------+--- ------+---------+----

.FIELD    name      * varchar(20);

 *** Error: Unrecognized command FIELD

+---------+---------+---------+---------+---------+--- ------+---------+----

.FIELD    country   * varCHAR(30);

 *** Error: Unrecognized command FIELD

+---------+---------+---------+---------+---------+--- ------+---------+----

 

 .DML LABEL INSERT_INFA_SOURCE12

 *** Error: Unrecognized command DML

+---------+---------+---------+---------+---------+--- ------+---------+----

INSERT INTO etlt5.infa_source12

(id,name,country)

VALUES

(:id, :name, :country);

 *** Failure 3857 Cannot use value (or macro parameter) to match 'id'.

                Statement# 1, Info =0

 *** Total elapsed time was 1 second.

 

+---------+---------+---------+---------+---------+--- ------+---------+----

 

 .IMPORT INFINE /home/a0c9sx/SQLAExport.txt;

 *** Warning: No IMPORT mode was given, assuming field mode.

 *** Syntax Error: Expected FILE or DDNAME keyword, not "INFINE".

 *** Warning: Extra text found after command.

              The text '/home/a0c9sx/SQLAExport.txt' not processed (ignored).

+---------+---------+---------+---------+---------+--- ------+---------+----

 LAYOUT RECLAYOUT

APPLY INSERT_INFA_SOURCE12

 .END LOAD;

LAYOUT RECLAYOUT

        $

 *** Failure 3706 Syntax error: expected something between the beginning of

 the request and the word 'LAYOUT'.

                Statement# 2, Info =9

 *** Total elapsed time was 1 second.

 

+---------+---------+---------+---------+---------+--- ------+---------+----

 *** Warning: EOF on INPUT stream.

.LOGOFF;

 *** You are now logged off from the DBC.

 *** BTEQ exiting due to EOF on stdin.

 *** Exiting BTEQ...

 *** RC (return code) = 8

$ ./tpump.sh

BTEQ 14.10.00.03 Sun Mar 20 01:06:47 2016 PID: 27984012

+---------+---------+---------+---------+---------+--- ------+---------+----

SESSIONS 1;

 *** Warning: Expected a '.' before the command

+---------+---------+---------+---------+---------+--- ------+---------+----

LOGTABLE  Etlt5.EMP_TPUMP_LOG;

 *** Warning: You must log on before sending SQL requests.

+---------+---------+---------+---------+---------+--- ------+---------+----

.logon ttdbia/a0c9sx,

 *** Logon successfully completed.

 *** Teradata Database Release is 15.10.01.03

 *** Teradata Database Version is 15.10.01.03

 *** Transaction Semantics are BTET.

 *** Session Character Set Name is 'ASCII'.

 *** Total elapsed time was 1 second.

+---------+---------+---------+---------+---------+--- ------+---------+----

BEGIN LOAD

PACK 5

RATE 10

ERROR TABLE EMPDB.TPUMPERROR;

BEGIN LOAD

      $

 *** Failure 3706 Syntax error: Expecting the word QUERY.

                Statement# 1, Info =7

 *** Total elapsed time was 1 second.

 

+---------+---------+---------+---------+---------+--- ------+---------+----

 

 .LAYOUT RECLAYOUT;

 *** Error: Unrecognized command LAYOUT

+---------+---------+---------+---------+---------+--- ------+---------+----

 .FIELD    id        * varchar(10);

 *** Error: Unrecognized command FIELD

+---------+---------+---------+---------+---------+--- ------+---------+----

.FIELD    name      * varchar(20);

 *** Error: Unrecognized command FIELD

+---------+---------+---------+---------+---------+--- ------+---------+----

.FIELD    country   * varCHAR(30);

 *** Error: Unrecognized command FIELD

+---------+---------+---------+---------+---------+--- ------+---------+----

 

 .DML LABEL INSERT_INFA_SOURCE12

 *** Error: Unrecognized command DML

+---------+---------+---------+---------+---------+--- ------+---------+----

INSERT INTO etlt5.infa_source12

(id,name,country)

VALUES

(:id, :name, :country);

 *** Failure 3857 Cannot use value (or macro parameter) to match 'id'.

                Statement# 1, Info =0

 *** Total elapsed time was 1 second.

 

+---------+---------+---------+---------+---------+--- ------+---------+----

 

 .IMPORT INFINE /home/a0c9sx/SQLAExport.txt;

 *** Warning: No IMPORT mode was given, assuming field mode.

 *** Syntax Error: Expected FILE or DDNAME keyword, not "INFINE".

 *** Warning: Extra text found after command.

              The text '/home/a0c9sx/SQLAExport.txt' not processed (ignored).

+---------+---------+---------+---------+---------+--- ------+---------+----

 LAYOUT RECLAYOUT

APPLY INSERT_INFA_SOURCE12

 .END LOAD;

LAYOUT RECLAYOUT

        $

 *** Failure 3706 Syntax error: expected something between the beginning of

 the request and the word 'LAYOUT'.

                Statement# 2, Info =9

 *** Total elapsed time was 1 second.

 

+---------+---------+---------+---------+---------+--- ------+---------+----

 *** Warning: EOF on INPUT stream.

.LOGOFF;

 *** You are now logged off from the DBC.

 *** BTEQ exiting due to EOF on stdin.

 *** Exiting BTEQ...

 *** RC (return code) = 8

Enthusiast

Re: TPUMP NOT WORKING

hey guys plz reply on this post :)