|23164||07 Feb 2012 @ 09:42 PST||Private Forum |
|23163||07 Feb 2012 @ 09:34 PST||feinholz||Tools||Reply||Text Qualifiers in Teradata Utilities||
We added the capability to our load/unload tools in 14.0.
We are trying to get the feature back-shipped into TPT 13.10, but that has not yet completed.
We would like customers to use TPT... |
|23162||07 Feb 2012 @ 08:58 PST||robpaller||General||Reply||next levels in a DW career||
Are you looking to continue your career as a developer or transition into something like an architect/data modeler or a database administrator?
|23161||07 Feb 2012 @ 08:54 PST||robpaller||Tools||Reply||Text Qualifiers in Teradata Utilities||
I'm afraid up to TTU 13.10 it's not possible. You could try to write an INMOD to address the text qualifiers. However, if this is being loaded via a UNIX environment modifying... |
|23160||07 Feb 2012 @ 08:20 PST||Greyghost||Viewpoint||Topic||No Data in Query Monitor||
I have an issue that I cannot figure out. In Viewpoint, my Query Monitor session shows no data. DBQL is turned on. What other features in ViewPoint or Teradata need to be turne... |
|23159||07 Feb 2012 @ 07:39 PST||ProudCat||Tools||Reply||How to specify TAB as a delimiter for TDLOAD||
Thanks so much. It worked!
|23158||07 Feb 2012 @ 07:25 PST||agianz1998||Tools||Topic||Text Qualifiers in Teradata Utilities||
I am pretty new to Teradata. I was wondering whether FastLoad, MLoad or TPT has the ability to handle text qualifiers? Following is an example
I have a csv file where some o... |
|23157||07 Feb 2012 @ 07:12 PST||ywjcjj||Database||Reply||is this a range_n partition or case_n partition?||
yes. That is a good recommendation.
|23156||07 Feb 2012 @ 06:26 PST||kjcohen||Database||Reply||Stored Procedure - Continue Handler||
Worked great, thanks Dieter.
|23155||07 Feb 2012 @ 06:23 PST||barani_sachin||Database||Reply||Insufficient memory for this plastic step||
Wat i meant in the previous post was how to edit the DBS Control Record fields from the query man if at all its possible.
|23154||07 Feb 2012 @ 06:22 PST||barani_sachin||Database||Reply||What does this statement does diagnostic oldrewrites on for session??||
Thanks for the info...
|23153||07 Feb 2012 @ 06:21 PST||barani_sachin||Database||Reply||Insufficient memory for this plastic step||
Thanks for your information. Can you please tell me what is mean by DBS Control Record field and also how can we edit from the query man.
|23152||07 Feb 2012 @ 05:12 PST||robpaller||UDA||Reply||Parsing/Response||
Fairly certain that once the query has reached a RESPONDING state TASM workload settings do not effect it. The duration which a query remains in RESPONDING state depends on environmental factors... |
|23151||07 Feb 2012 @ 05:06 PST||robpaller||Tools||Reply||Best Memory specification for SQL Assistant V13||
Memory for PCs and Notebooks is relatively cheap. I would suggest for the overall performance of your computer to upgrade to at least 2GB of RAM if it supports it. Personally, I am running 8GB o... |
|23150||07 Feb 2012 @ 01:09 PST||dnoeth||Database||Reply||Stored Procedure - Continue Handler||
Currently your handler sets the SqlTxt1 and so your proc starts with CALL DBC.sysexecsql(NULL);
What are you trying to achieve? Ignoring the "table doesn't exist" error for the... |
|23149||07 Feb 2012 @ 12:50 PST||dnoeth||Database||Reply||Use of 'Qualify' and online dictionary||
It's similar to HAVING, filtering after an OLAP function.
Check the SQL DML manual for details.
|23148||07 Feb 2012 @ 12:48 PST||dnoeth||Tools||Reply||BTEQ logon||
Ask your friendly DBA for your username and to reset the password.
|23147||07 Feb 2012 @ 12:48 PST||deepeshpm||Tools||Topic||Best Memory specification for SQL Assistant V13||
Can any one can tell what could be the best Memory specification for SQL Assistant V13 ? currently my PC is having 512 MB of RAM and I am planning to upgrade ... Will it helps t... |
|23146||07 Feb 2012 @ 12:47 PST||dnoeth||Database||Reply||What does this statement does diagnostic oldrewrites on for session??||
It's one of the undocmented diagnostic statements which are used by the Teradata developers to enable/disable specific features.
This one seems to switch off some newer optimizations, it... |
|23145||07 Feb 2012 @ 12:44 PST||dnoeth||Database||Reply||Insufficient memory for this plastic step||
Check the Messages manual
3712 Insufficient memory for Plastic Steps for
Explanation: The request was more complex than the
Teradata SQL Parser could process. The parser ... |
|23144||06 Feb 2012 @ 11:05 PST||barani_sachin||Database||Topic||Insufficient memory for this plastic step||
I am getting an error Insufficient memory for this plastic step. I just want to know what does this error tries to tell us.
|23143||06 Feb 2012 @ 11:03 PST||barani_sachin||Database||Topic||What does this statement does diagnostic oldrewrites on for session??||
What does this statement does
diagnostic oldrewrites on for session
|23142||06 Feb 2012 @ 10:45 PST||JohnBasha.N||Tools||Reply||BTEQ logon||
i forget my Teradata BTEQ logon username and password how i recover it.
|23141||06 Feb 2012 @ 05:48 PST||thcaleb||Database||Topic||Use of 'Qualify' and online dictionary||
Can someone explain to me how to use the 'Qualify' statement in SQL (teradata)? Also, if anyone knows of an online dictionary/glossary where I might find this term and others could you s... |
|23140||06 Feb 2012 @ 04:52 PST||smarty||Database||Topic||3NF and Dimensional data model in Teradata||
What is the best method of modelling in Terdata? A 3NF or a dimensional database? When do we use a 2 layer model i.e a 3NF tables and dimensional tables together? What would be the busin... |