1171 | 14 Nov 2014 @ 08:35 PST | Database | Reply | Use of CTE within stored procedures | How is your macro structure?
You could have made a new topic :) for ease of reference.
The topic above is "use-of-cte-within-stored-procedures".
|
1170 | 14 Nov 2014 @ 08:13 PST | General | Reply | BTEQ .IF ERRORCODE <> 0 THEN <QUERY> | I m not able to understand it properly. It looks like you just want to copy and paste the code. Try to put in a viewable way and press enter or in some unix env , you need to put front slash \, say... |
1169 | 13 Nov 2014 @ 08:29 PST | Database | Reply | SQLServer - Teradata Timestamp Issue | Have you checked the timstamp settings on both the servers too? say like selecting the timestamp.....?
|
1168 | 13 Nov 2014 @ 07:15 PST | Database | Reply | Teradata basics |
Teradata Active Enterprise Data Warehouse --- 8TB to 61PB
Teradata Data Warehouse Appliance------------ up to 21PB
Teradata Integrated Big Data Platform------- 76TB up to 2,048 nodes wit... |
1167 | 13 Nov 2014 @ 05:39 PST | Database | Reply | Lock on DBC.Accessright table and other Create/drop/Alter statement in Block state | Just my thought again, throwing more directions:
Is it a one-off situation or it is recurring?
Background tasks such as defrag,..cylpack, fsg cache purging,TJ purging,cache flushing ..., ... |
1166 | 13 Nov 2014 @ 12:13 PST | Database | Reply | How to avoid using QUALIFY OVER PARTITION BY | You can use regexp_substr like example below:
regexp_substr(address,'bangalore',1,1,'i')
Next time, please issue a new topic, for ease of handling :)
|
1165 | 12 Nov 2014 @ 08:16 PST | General | Reply | Running arcmain backup jobs on each partition | I am not pretty sure.I am thinking that the first job will place hut lock on the table, because we use RELEASE LOCK, even when we specify the partition.
|
1164 | 12 Nov 2014 @ 07:44 PST | Database | Reply | Increase the size limit of teradata objects name from 30 characters to more. | It is 128.
|
1163 | 12 Nov 2014 @ 02:47 PST | Database | Reply | Lock on DBC.Accessright table and other Create/drop/Alter statement in Block state | Hi Sandeep,
I remember a discussion. Can it be because of:
http://forums.teradata.com/forum/database/deadlock-on-dbc-accessrights?
|
1162 | 11 Nov 2014 @ 08:29 PST | Connectivity | Reply | TPT Help with SSIS | Maybe you can post your issues in attunity forum too. ODBC operator for tpt is certified to work only with the DataDirect/Progress ODBC drivers. Others may work but may produce unwanted ... |
1161 | 11 Nov 2014 @ 07:54 PST | Database | Reply | Is it possible to modify my Partition? | You have not told much about the altering criteria :).
Here is an example:
http://forums.teradata.com/forum/database/modify-the-partition
Just for your information: You cannot use the ADD a... |
1160 | 11 Nov 2014 @ 06:51 PST | General | Reply | Convert multiple rows into single row | Yes Dieter,indeed, the sorting based on PromoType, back to the old style.
|
1159 | 11 Nov 2014 @ 05:07 PST | General | Reply | Convert multiple rows into single row | which version of TD?
You can use : select Itinerary , tdstats.udfconcat(trim(PromoCode )) from yourtable group by 1
or do you want specifically : delimiter too?
|
1158 | 10 Nov 2014 @ 07:21 PST | Database | Reply | All access details for a database | Try Join : dbc.allrights,dbc.allrolerights and dbc.rolemembers.
|
1157 | 10 Nov 2014 @ 10:00 PST | Database | Reply | Transaction aborted by Administrator or operation staff | On Sandeep's question:
It is my curiosity if we can see in viewpoint or if there is a session id, connected with Linux/unix process id.....
|
1156 | 10 Nov 2014 @ 07:37 PST | Teradata Applications | Reply | After devolping a script as a teradata devolper then unit test and after how it goes to production . | It depends.
Which methodologies? Continuous Integration, Extreme progamming, Agile and so one and so forth....
organizations adopt different methodologies in different ways that benefit the... |
1155 | 10 Nov 2014 @ 07:23 PST | Database | Reply | Time Zone String Instead of Offset | Which version of TD?
Try this:
select current_timestamp at 'gmt' (title 'GMT TIME'),
current_timestamp at 'america pacific' (title 'America Pacific TIME... |
1154 | 10 Nov 2014 @ 06:46 PST | Database | Reply | BTEQ Export file with a date variable included in the name | Before logon , you can do thus in Linux/unix:
process_date=$(date "+%Y%m%d%H%M%S")
then ..... = teradata_output_${process_date}.csv.....
|
1153 | 08 Nov 2014 @ 05:42 PST | Extensibility | Reply | Calling Web Services | Did you check with MyBatis? An instant web service calls from stored proc. You can see much benefits with xml dealings and wsdl.......
|
1152 | 08 Nov 2014 @ 05:35 PST | Extensibility | Reply | Queue to Queue | Maybe this can help you:
Kudos to Dieter's stored proc for stats, using queue table. Good reference for push..pop:
http://developer.teradata.com/blog/dnoeth/2012/10/how-to-simplify-your-stati... |
1151 | 06 Nov 2014 @ 09:12 PST | Database | Reply | Data skew /qry running long | Just my opinion:
I am not Dieter. The underlying view may have transformation, formats...wher it may need to be fine-tuned
What happens if we run DIAGNOSTIC HELPSTATS ON FOR SESSION;
for th... |
1150 | 06 Nov 2014 @ 08:37 PST | Database | Reply | Encryption in the index | I am not sure. Will it hash?????. But I don't think it is advisable , since when use in where clause, it is nightmare.
|
1149 | 06 Nov 2014 @ 07:03 PST | Database | Reply | Cumulative Average where the partition are overlapping (Moving Avg.) | You can think of in this direction like partition and restricting with qualify set by set maybe
Paramterizing for rows between never worked for me too a while back till now (like rows&n... |
1148 | 06 Nov 2014 @ 06:37 PST | Database | Reply | Backup and restore report | Unity ecosystem manager is a multi-teradata system monitoring or alerting tool for UDA, including hadoop, aster.... Jobs , servers,tables, applications can be monitored.....like many other mo... |
1147 | 06 Nov 2014 @ 06:05 PST | Database | Reply | Disadvantages of Compressionn | It can increase CPU usage. A trade-off is to be made with IO.
|