#DateForumTypeThreadPost
44102 Aug 2012 @ 11:32 PDTDatabaseReplyMerge syntax (simple version) is this what you are looking for? create table merge_tmp (a integer, b char(10), c char(10)) unique primary index (a); insert into merge_tmp values (1,'abc','def'); SELECT...
44002 Aug 2012 @ 10:34 PDTDatabaseReplyTable pivoting first generate  two big case statements select calendar_date - current_date as id, 'when c.id = ' !! trim(cast(id as varchar(20))) !! ' then ''col' !! trim...
43902 Aug 2012 @ 04:43 PDTDatabaseReplyHelp needed in teradata recursive sql Did you google  teradata recusive sql? this should give you some ideas. This one might also gives an example http://forums.teradata.com/forum/database/string-concat-returning-mu...
43802 Aug 2012 @ 04:40 PDTDatabaseReplyInput date format. There exists some UDFs from ebay available in the forum which would make life a bit easier. The hard way - ugly code select '9/1/2012' as c,        &n...
43702 Aug 2012 @ 12:23 PDTDatabaseReplyQuery to generate collect stats statement automatically Check also dieters blog post http://developer.teradata.com/blog/dnoeth/2011/12/how-to-decode-the-binary-statistics-stored-in-dbc-tables the code can be downloaded in the attachement sect...
43631 Jul 2012 @ 11:56 PDTToolsReplyTPT -> export ASCII data to UTF-8 UTF-8 is unicode, isn't it? To my understanding it is possible what you want to achive. You need to define the CHARACTER SET right on the different level (job and script). Check the manu...
43531 Jul 2012 @ 11:51 PDTToolsReplyTPT ODBC Operator - select data into a TPT "variable" check  http://www.teradata-partners.com/About/ProductAdvisoryCouncil there is also a link to submit a request
43427 Jul 2012 @ 04:42 PDTToolsReplyFastload: fixed field multibyte Didn't got it working right now. But some comments: You need to define the table columns as character set unicode - otherwise you can not load utf-8 data into it. create multiset...
43327 Jul 2012 @ 02:47 PDTToolsReplyFastload: fixed field multibyte and sorry - but on mac rar files are not known. Can you tar, zip, gzip?  
43227 Jul 2012 @ 02:40 PDTToolsReplyFastload: fixed field multibyte strange - as you can see attached I get it a file attachemnt link. lets see...
43126 Jul 2012 @ 09:26 PDTToolsReplyFastload: fixed field multibyte below the editor is a FILE ATTACHMENTS link which you can follow and which should be straigt forward to upload files.  
43026 Jul 2012 @ 06:14 PDTToolsReplyFastload: fixed field multibyte unicode data can become tricky. In case you want help you should attach 1. a testfile incl. unicode chars   2. the ddl of the target table 3. any fastload script you tried s...
42925 Jul 2012 @ 07:58 PDTToolsReplyMLOAD is assuming one extra line and failing Option 1: remove the \n from all rows and use UNFORMAT Option 2: add the \n to ALL rows - in your last LOG you can see the impact of Once missing \n - and use TEXT Option 3: ...
42825 Jul 2012 @ 07:25 PDTToolsReplyMLOAD is assuming one extra line and failing unformat is likely to create the issue. check http://forums.teradata.com/forum/tools/mload-vartext-format Freds last statement "UNFORMAT expects no record delimiter; if ther...
42725 Jul 2012 @ 06:27 PDTToolsReplyMLOAD is assuming one extra line and failing   "Attempted to access out of range input data in field 'IN_TACTIC_ID'"   Is IN_TACTIC_ID the first column in the file?   Do you ha...
42625 Jul 2012 @ 05:02 PDTToolsReplyMLOAD is assuming one extra line and failing And pease just try once to add a \n at the last line as well...
42525 Jul 2012 @ 04:46 PDTToolsReplyMLOAD is assuming one extra line and failing can you share the perl code as well?
42425 Jul 2012 @ 03:46 PDTToolsReplyMLOAD is assuming one extra line and failing can you share the mload log?
42325 Jul 2012 @ 12:52 PDTToolsReplyMLOAD is assuming one extra line and failing I am not sure about this. Could you share a test perl script, ddl and mload script? My first guess would be that all lines need to end with a \n. But your last line doesn't. So m...
42224 Jul 2012 @ 12:42 PDTDatabaseReplyUpload error - import completes but doesnt import any of the columns data which session mode are you using? which tool do you use? In case of ANSI did you send a commit?  
42124 Jul 2012 @ 06:20 PDTDatabaseReplyCreating a fixed width text file "and I can use the export feature" which tool? please share the code? google export fixed width text file teradata  and you will find many postings
42024 Jul 2012 @ 05:07 PDTDatabaseReplyis it possible to use two qualify in a query based on some condition? can you share the SQL? in general you can have a combined qualify condition like  qualify ( row_number() over (partition by key order by age desc, rank desc) = 1 ...
41924 Jul 2012 @ 01:30 PDTAnalyticsReplyINSERT SELECT and other values "not the value which we get after executing it" What do you mean with this? You are mixing two different systax types of the insert stement. you can use insert into tab val...
41824 Jul 2012 @ 01:25 PDTPrivate Forum
41723 Jul 2012 @ 11:56 PDTToolsReplyUsing FILLER in TPT 13.10 Can you share your script?  An example from the documentation: DEFINE SCHEMA PRODUCT_SOURCE_SCHEMA ( Associate_Id integer, Associate_Name char(25), Salary float, DOJ ansidate, ...

Pages