 |
 |
Archives of the TeradataForum
Message Posted: Thu, 22 Oct 2009 @ 13:35:28 GMT
| Subj: | | Re: Bteq Import problem, or is it an Export problem? |
| |
| From: | | narayan.murthy |
Try Indicdata:
BTEQ -- Enter your DBC/SQL request or BTEQ command:
.export indicdata file=/tmp/abc
.export indicdata file=/tmp/abc
*** To reset export, type .EXPORT RESET
BTEQ -- Enter your DBC/SQL request or BTEQ command:
sel * from t1;
sel * from t1;
*** Success, Stmt# 1 ActivityCount = 4
*** Query completed. 4 rows found. 2 columns returned.
*** Total elapsed time was 1 second.
BTEQ -- Enter your DBC/SQL request or BTEQ command:
.export reset
.export reset
*** Output returned to console.
BTEQ -- Enter your DBC/SQL request or BTEQ command:
del from t2;
del from t2;
*** Delete completed. 4 rows removed.
*** Total elapsed time was 1 second.
BTEQ -- Enter your DBC/SQL request or BTEQ command:
.repeat *
.repeat *
BTEQ -- Enter your DBC/SQL request or BTEQ command:
.import indicdata file=/tmp/abc
.import indicdata file=/tmp/abc
BTEQ -- Enter your DBC/SQL request or BTEQ command:
using(a int, b varchar(10))
ins t2(:a,:b);
using(a int, b varchar(10))
ins t2(:a,:b);
*** Starting Row 0 at Fri Sep 1 03:48:11 2006
*** Insert completed. One row added.
*** Total elapsed time was 1 second.
*** Insert completed. One row added.
*** Total elapsed time was 1 second.
*** Insert completed. One row added.
*** Total elapsed time was 1 second.
*** Insert completed. One row added.
*** Total elapsed time was 1 second.
*** Warning: Out of data.
*** Finished at input row 4 at Fri Sep 1 03:48:11 2006
*** Total number of statements: 4, Accepted : 4, Rejected : 0
*** Total elapsed time was 1 second.
*** Total requests sent to the DBC = 4
*** Successful requests per second = 4.000
BTEQ -- Enter your DBC/SQL request or BTEQ command:
sel * from t2;
sel * from t2;
*** Query completed. 4 rows found. 2 columns returned.
*** Total elapsed time was 1 second.
a b
----------- ----------
2 abc
3
1 ?
4 xyz
BTEQ -- Enter your DBC/SQL request or BTEQ command:
sel * from t1;
sel * from t1;
*** Query completed. 4 rows found. 2 columns returned.
*** Total elapsed time was 1 second.
a b
----------- ----------
2 abc
3
1 ?
4 xyz
BTEQ -- Enter your DBC/SQL request or BTEQ command:
| |
