Archives of the TeradataForum

Message Posted: Wed, 13 May 2015 @ 22:25:40 GMT

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

Thanks for the response. But then my export is failing and I don't see any other errors. Here is the log.

     0001 .LOGTABLE utillog ;

     0002 .LOGON DATACORE/$tdwallet(user),;
     **** 14:37:45 UTY8400 Teradata Database Release: 14.00.07.14
     **** 14:37:45 UTY8400 Teradata Database Version: 14.00.07.14
     **** 14:37:45 UTY8400 Default character set: ASCII
     **** 14:37:45 UTY8400 Current RDBMS has UDT support
     **** 14:37:45 UTY8400 Current RDBMS has Large Decimal support
     **** 14:37:45 UTY8400 Current RDBMS has Statement Info Parcel support
     **** 14:37:45 UTY8400 Current RDBMS has FEXP w/o Spooling support
     **** 14:37:45 UTY8400 Current RDBMS has TASM support
     **** 14:37:45 UTY8400 Maximum supported buffer size: 1M
     **** 14:37:45 UTY8400 Data Encryption supported by RDBMS server
     **** 14:37:45 UTY1008 RDBMS failure: 3807, Object 'SYSLIB.DBSRETRYABLEERRORS'
          does not exist.
     **** 14:37:45 UTY6687 Warning: The job will use its internal retryable error
          codes.
     **** 14:37:46 UTY6211 A successful connect was made to the RDBMS.

     ------------------------------------------------------------------------
     =                                                                      =
     =          Processing Control Statements                               =
     =                                                                      =
     ------------------------------------------------------------------------

     0003 .BEGIN EXPORT
          SESSIONS 1;

     0004 .LAYOUT UsingData ;
     0005          .FIELD  Infokey * varchar(30) ;
     0006          .FIELD  Infodata  * varchar(500)  ;

     0007 .IMPORT INFILE ddname1
          LAYOUT UsingData ;

     0008 .EXPORT OUTFILE C:\Users\infodata.out ;


     0009
          select * from dbc.dbcinfotbl;
     **** 14:37:46 UTY3403 Only one statement per line is allowed.  Extra characters
          were detected beginning in column '31'.

     ------------------------------------------------------------------------
     =                                                                      =
     =          Logoff/Disconnect                                           =
     =                                                                      =
     ------------------------------------------------------------------------
     **** 14:37:46 UTY6215 The restart log table was not dropped by this task.
     **** 14:37:46 UTY6212 A successful disconnect was made from the RDBMS.
     **** 14:37:46 UTY2410 Total processor time used = '0.312002 Seconds'
          .       Start : 14:37:42 - WED MAY 13, 2015
          .       End   : 14:37:46 - WED MAY 13, 2015
          .       Highest return code encountered = '8'.

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