#DateForumTypeThreadPost
1327 Jan 2016 @ 01:59 PSTDatabaseTopicSubstr - End of Line, Count backwards onText and NumbersHello, I habe a varchar(5) column, holding a combination text and numbers, manly 6 char spaces seperated by a colon. The can be cases where there is only one occurance, or several of the 6 sp...
1231 Dec 2015 @ 11:20 PSTGeneralReplyDate Conversion Issue, from String to DATEUPDATE: I went back to the Excel file, did a Custom Date Format, on the column in question, exported, floaded, and then did the ins/sel, with no errors, and with no cast/formats either. That is bec...
1131 Dec 2015 @ 09:08 PSTGeneralTopicDate Conversion Issue, from String to DATEHello, I fastloaded data into a temp table, and have a date columns as varchar(255), and am getting an error with insert/select to a perm table that has the receiving date column as dtcolname date ...
1015 Dec 2015 @ 12:54 PSTToolsReplyFASTLAOD on TTU15 - Empty file on read open Thanks for this feedback and help. What I believe at this time the issue is for my configuration, 64bit hardawre, 64bit os, and 64bit ttu15, that using the older 32 bit utils to run the fastload sc...
915 Dec 2015 @ 12:07 PSTToolsReplyFASTLAOD on TTU15 - Empty file on read open BTW, this is on a PC, Win 7, 64 bit OS and installed the 64 bit of TTU15. I understood the TTU15 x64 software to install all 64 bit tools. When I check the FASTLOAD version is 15.00.00 I also ...
815 Dec 2015 @ 11:44 PSTToolsReplyFASTLAOD on TTU15 - Empty file on read open I'm running the latest FASTLOAD version 15 when the error occurs. I used TTU 13 and TTU 14 when I was running the same BTEQ/FLOAD with no error. To upgrad eto TTU15, I had to remove every trace...
715 Dec 2015 @ 11:18 PSTToolsReplyFASTLAOD on TTU15 - Empty file on read open I checked this, the access and priv, several times, and it still gives that same "enpty file on read open". So I setup and sampled off 100 rows from the FEXP extract and then loaded the 1...
614 Dec 2015 @ 01:41 PSTToolsTopicFASTLAOD on TTU15 - Empty file on read open Hello, I just upgraded to TTU15 on a Windows 64 bit OS, and intalled all the goodies. Now I'm running a large monthly process where there are a lot of FASTEXPORTS And FASTLOADS to be done, all ...
531 Jul 2015 @ 09:48 PDTToolsReplySQL Inserter Help with TPT and CLOB Data LoadI've gone through the Web info and it primarily covers BLOB. Does anyone have any sample BTEQ or TPT run through SQLA that loads CLOB? I namely need to see how the control file deals with the C...
427 Jul 2015 @ 11:56 PDTToolsReplySQL Inserter Help with TPT and CLOB Data LoadThank you for the link Steve, after using the Wizard, it did seem confining, and I prefer a script that I can edit without always having to use a GUI.
323 Jul 2015 @ 02:46 PDTToolsTopicSQL Inserter Help with TPT and CLOB Data LoadHello, I have a table created on Teradata RDBMS 14, I'm using TTU 14 on my PC, and the TPT Wizard. I'm attempting to load a large ASCII comma delimited flat file, that has two columns/comm...
222 Jul 2015 @ 01:55 PDTToolsTopicSample TPT Script; Loading Large Char FlatFile data to CLOB DatatypesHello, I have a series of large flat files that are CSV, that contain very large blocks of character data larger than 8000 characters. I need to load to a Teradata Target table, empty at first, wit...
119 Jul 2013 @ 02:01 PDTDatabaseTopicCreate GTT with Recursive TableHello everyone, I came here to get some help or ideas for recoding a table and population design. Currently I have a single complex statement that creates and populates a table, and creates a recur...

Pages