{"id":3456,"date":"2021-05-27T21:57:16","date_gmt":"2021-05-27T19:57:16","guid":{"rendered":"http:\/\/van-maanen.com\/?p=3456"},"modified":"2021-05-27T21:57:16","modified_gmt":"2021-05-27T19:57:16","slug":"exporting-data-from-teradata","status":"publish","type":"post","link":"http:\/\/archief.van-maanen.com\/?p=3456","title":{"rendered":"Exporting data from Teradata"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Recently, I came across the so-called fast export facility in Teradata. This facility allows you to export data from Teradata in a relative fast way. Let us look at the script:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">.LOGTABLE tom.invoer_log;  \n .logon 192.168.178.13\/tom,******;\n database tom;\n .BEGIN EXPORT SESSIONS 2;  \n       .EXPORT OUTFILE C:\\Users\\tomva\\Documents\\invoer.txt  \n       MODE RECORD FORMAT TEXT;\n       SELECT CAST(leeftijd AS CHAR(10)), \n          CAST(nummer AS CHAR(10))   \n       FROM\n       invoer;\n    .END EXPORT;\n .logoff;\n<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The script can be evoked by &#8220;fexp &lt; t.txt&#8221;, t.txt being the name of the script. The output then looks like:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"http:\/\/van-maanen.com\/wp-content\/uploads\/2021\/05\/Capture-3-2-1-1.png\" alt=\"\" class=\"wp-image-3457\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Recently, I came across the so-called fast export facility in Teradata. This facility allows you to export data from Teradata in a relative fast way. Let us look at the script: .LOGTABLE tom.invoer_log; .logon 192.168.178.13\/tom,******; database tom; .BEGIN EXPORT SESSIONS 2; .EXPORT OUTFILE C:\\Users\\tomva\\Documents\\invoer.txt MODE RECORD FORMAT TEXT; SELECT CAST(leeftijd AS CHAR(10)), CAST(nummer AS CHAR(10)) [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3456","post","type-post","status-publish","format-standard","hentry","category-allgemein"],"_links":{"self":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts\/3456","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3456"}],"version-history":[{"count":0,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts\/3456\/revisions"}],"wp:attachment":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3456"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3456"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3456"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}