#DateForumTypeThreadPost
49127 Aug 2012 @ 11:30 PDTDatabaseReplyParent Child Relationship FlatteningYou need to provide some test data - DDL & Insert statements Beside this it is not an easy task... What is your order rule? Seems not straight forward to me. As you wane the whole tree down to ...
49027 Aug 2012 @ 07:27 PDTAnalyticsReplyConnecting to csv in R with the teradataR packageCan you share some rows of your csv file?
48927 Aug 2012 @ 05:32 PDTToolsReplyTPT script: error while executing TPT scriptcan you run and share tbuild -V UPPERCASE V to get the version info
48824 Aug 2012 @ 04:57 PDTToolsReplyExporting data using a BTEQ and don't forget the (title'')
48724 Aug 2012 @ 04:28 PDTToolsReplyTPT script: error while executing TPT script TPT installation might be incomplete. Can you run  tbuild -V    
48624 Aug 2012 @ 03:02 PDTToolsReplyTPT script: error while executing TPT script So the message states that the file does not exists  did you check the file name in the script? beside this you would need to share the tpt script...
48522 Aug 2012 @ 06:14 PDTAnalyticsReplyEmbedded Selects statements within a select stmt   Depends on your release.  In 13.10 below works - query need to guarantee that only one row is returned!     select calendar_date,    ...
48422 Aug 2012 @ 05:15 PDTDatabaseReplyInsert data into table with data imported already so, why don't you try it? Read the SQL basisc inserts will add rows Update will modify rows and Delete will delete rows. There exists exceptions for Insert for example SE...
48322 Aug 2012 @ 03:01 PDTAnalyticsReplyConnecting to csv in R with the teradataR package tdConnect connects to a Teradata database td.data.frame is querying a Teradata DB NOT FILES.... If you wane read csv files you should open them with native R (like read.table scan) comma...
48221 Aug 2012 @ 01:26 PDTDatabaseReplyGetting the Max values and Grouping. This might give you what you are looking for. Where I have to mention that I don't understand how you deal with this data as there are still many overlaps, at least for the first group o...
48116 Aug 2012 @ 02:33 PDTDatabaseReplyGetting the Max values and Grouping. Can be done with Olap functions. Can you provide us with a DDL and insert statements for the test data. I loose willingness to set these up on my own... check also  http://f...
48015 Aug 2012 @ 11:38 PDTToolsReplyCompression-issue It will depend on your sec index. You can find in the manuals some formulars to calculate the size of a sec index. The feret utiliy can also be used. Google teradata sec index size a...
47915 Aug 2012 @ 11:24 PDTDatabaseReplySHA-256 hashing for Data Did you check if as SHA256 function is available for columns? If not ask AI, they might be able to help you.
47815 Aug 2012 @ 07:00 PDTDatabaseReplySHA-256 hashing for Data To calculate the hash values within the DB you would need to write a UDF. A sha1 UDF is available in the download section but I am not aware of an SHA256 implementation. Alternative is to ex...
47714 Aug 2012 @ 10:28 PDTToolsReplyInsert select in Mload Is table B empty?
47614 Aug 2012 @ 10:27 PDTDatabaseReplyAdd comment when migrating a table Did you consider to use arcmain to migrate DDL's? Beside this dbc.tables and dbc.columns contain the commentstring. So you should be able to generate the comment statements as well.
47514 Aug 2012 @ 10:25 PDTToolsReplyCompression-issue Did you do the compression analysis against development data? The compress lists need to reflect the data demographics of the real table therefore the analysis is usually done against produc...
47414 Aug 2012 @ 03:38 PDTDatabaseReplyTeradata Update Syntax You need to write the derived table M in a way that you can execute it on itself (copy / paste into SQLA) and gives a result set which you can join to the target table.
47313 Aug 2012 @ 08:03 PDTDatabaseReplyTeradata Update Syntax Didn't rec it in the last post. You need to fix your derived table...       on a.tran_area_id = b.tran_area_id ...
47213 Aug 2012 @ 07:44 PDTDatabaseReplyDate Diff function/ column not found error. And what does these error codes imply?
47113 Aug 2012 @ 07:42 PDTDatabaseReplyTeradata 13 Vs 14 Start with the release summary of 13.10 (13.00 -> 13.10) Release Summary and the release Summary of 14.00 (13.10 -> 14.00) 14.0 Release Summary - Documentation - Teradata
47013 Aug 2012 @ 07:12 PDTDatabaseReplyTeradata Update Syntax Check the Update syntax diagram in the manuals What I can see is the the set needs a , instead of an and  something like  update k from cust_zone_sales k, (select m...
46913 Aug 2012 @ 06:42 PDTDatabaseReplyMax value for datatype column. "the SQL would ..."  can you explain in a bit more detail? You might be able to query dbc.columns.   select columnname,          ...
46813 Aug 2012 @ 05:20 PDTGeneralReplyAlter a table seems you don't want to change the data type but to update your compression list, correct? Alter table_x add col_a char(8) COMPRESS ('1       ','2 &nb...
46713 Aug 2012 @ 04:01 PDTDatabaseReplyTeradata Update Syntax Hi,   it would be easier if you would describe what the update should do. So I could only give a guess from the code... UPDATE K FROM Table_A ( select ...

Pages