{"id":635,"date":"2007-03-28T07:42:00","date_gmt":"2007-03-28T13:42:00","guid":{"rendered":"http:\/\/www.cls-solutions.com\/blog\/?p=635"},"modified":"2007-03-28T07:42:00","modified_gmt":"2007-03-28T13:42:00","slug":"sqlldrspooling","status":"publish","type":"post","link":"http:\/\/www.cls-solutions.com\/blog\/sqlldrspooling\/","title":{"rendered":"SQLLDR\/Spooling"},"content":{"rendered":"<p>Miscellaneous issues when upload\/downloading from Oracle.<\/p>\n<p>SPOOLING:<br \/>When downloading\/Spooling, large fields (Clobs\/Memo) were being truncated. Had to SQL>Show all. Linesize,long,longchunksize were defaulting to 80-increased these.<\/p>\n<p>SQLLDR:<br \/>sqlldr scott\/tiger@LAWSON2 log=log.txt control=loader.ctl<\/p>\n<p>[loader.ctl]<br \/>load data<br \/>infile &#8216;c:\\merged.dat&#8217;<br \/>into table seebeyond.RAD_MESSAGES_LDR<br \/>fields terminated by &#8220;abcZ123&#8221; optionally enclosed by &#8220;&#8221;<br \/>(MESSAGES CHAR(100000))<\/p>\n<p>*To create One table from another: CREATE TABLE ZZZ AS SELECT * FROM AAA <\/p>\n<p>*Set commands (UNION,etc) cannot be used in Clob\/Memo fields <\/p>\n","protected":false},"excerpt":{"rendered":"<p>Miscellaneous issues when upload\/downloading from Oracle. SPOOLING:When downloading\/Spooling, large fields (Clobs\/Memo) were being truncated. Had to SQL>Show all. Linesize,long,longchunksize were defaulting to 80-increased these. SQLLDR:sqlldr scott\/tiger@LAWSON2 log=log.txt control=loader.ctl [loader.ctl]load datainfile &#8216;c:\\merged.dat&#8217;into table seebeyond.RAD_MESSAGES_LDRfields terminated by &#8220;abcZ123&#8221; optionally enclosed by &#8220;&#8221;(MESSAGES CHAR(100000)) *To create One table from another: CREATE TABLE ZZZ AS SELECT * FROM AAA [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-635","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/www.cls-solutions.com\/blog\/wp-json\/wp\/v2\/posts\/635","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.cls-solutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.cls-solutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.cls-solutions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.cls-solutions.com\/blog\/wp-json\/wp\/v2\/comments?post=635"}],"version-history":[{"count":0,"href":"http:\/\/www.cls-solutions.com\/blog\/wp-json\/wp\/v2\/posts\/635\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.cls-solutions.com\/blog\/wp-json\/wp\/v2\/media?parent=635"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.cls-solutions.com\/blog\/wp-json\/wp\/v2\/categories?post=635"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.cls-solutions.com\/blog\/wp-json\/wp\/v2\/tags?post=635"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}