12 | 24 Jul 2014 @ 06:53 PDT | Database | Reply | Total Quantity of Items Sold per Month | Hi Kartheek,
this looks odd. This generally happends when the object name (tablename or column name) contains more than 30 character during DDL operation
|
11 | 24 Jul 2014 @ 06:38 PDT | Database | Reply | Total Quantity of Items Sold per Month | Try with this
insert into k.test (eventdate) values('2014-02-24 19.37.38.000000');
|
10 | 24 Jul 2014 @ 06:07 PDT | Database | Reply | Total Quantity of Items Sold per Month | Hi,
Check if this works out....
Select qwe.Year_, qwe.MonthNum, qwe.mnfctr_cd, sum (qwe. totalSold) as totalQtySold
from ....
....
....
group by 1, 2, 3
... |
9 | 24 Jul 2014 @ 02:12 PDT | Database | Reply | regexp_substr in TD14.10 | Hi,
Check if this would satisfies your needs.
SEL oreplace(
regexp_substr(
'a,b,c," abc,def,dfg",m,n,"hi,how,are you&q... |
8 | 24 Jul 2014 @ 12:09 PDT | Database | Reply | Need help on a case scenario | Hi Sujith,
I have a questioins for you. I am refererring your Result Table now. As per the output availble for QRY*PRICE, how is that value arrived 20*50 ?
As per the above statem... |
7 | 22 Jul 2014 @ 02:12 PDT | Database | Reply | How to check what values are passed to procedure call from qrylog table ? | Thanks for the insight ! This helps.
|
6 | 21 Jul 2014 @ 09:44 PDT | Database | Reply | Is there any debugger option in Teradata Studio. | Thanks Krishaneesh !
Hi Walter, Thanks this will be usefull for my development.
Many thanks,
|
5 | 21 Jul 2014 @ 02:27 PDT | Database | Topic | How to check what values are passed to procedure call from qrylog table ? | Hi,
This is regarding, how do I find values passed in the stored procedure call from qrylog table.
From dbc.qrylog, I could see all the procedure names made through TD. Howev... |
4 | 21 Jul 2014 @ 01:58 PDT | Database | Reply | Is there any debugger option in Teradata Studio. | Hi Experts,
Can anyone please help me on this ?
Thanks in advance
|
3 | 18 Jul 2014 @ 06:38 PDT | Database | Topic | Is there any debugger option in Teradata Studio. | Hi Everyone,
I am interested in debugging SP of my DB instance. Is there any debugger option availble in Teradata Studio 14.2.0 ?
If the debugger option is not availble TD Studio,... |
2 | 17 Jul 2014 @ 10:24 PDT | Database | Reply | Choosing FExp/TPump or regular Insert STMT | Hi Dnoeth,
Thanks for the link. This will help :)
Regards,
Vinod
|
1 | 17 Jul 2014 @ 02:45 PDT | Database | Topic | Choosing FExp/TPump or regular Insert STMT | Hi Everyone,
I need guidelines on what scenario, I would choose FExp, TPump, MLoad or Insert Statement.
Thanks in advance.
-
Vinod
|