All forum activity

#DateUserForumTypeThreadPost
54217 Mar 2006 @ 11:02 PSTrlaskarDatabaseTopicHow to validate date field in dd/mm/yyyy or yyyy/mm/dd format ?I was trying to write a SQL which would validate a date column field. The validation would be whether the rows have data in 'dd/mm/yyyy' or 'mm/dd/yyyy' format.
54117 Mar 2006 @ 10:11 PSTWitarsaAnalyticsReplyidentity columnsWhat's the main difference between "GENERATED BY DEFAULT" and "GENERATED ALWAYS" commands?Tks,Marc
54017 Mar 2006 @ 10:05 PSTdnoethDatabaseReplyscript of teradata tablesHi dixon,there's a script in C:\Program Files\NCR\Tdat\LTDBMS\etc\perddl.bteq, but the sample db is quite small.It's described in the manuals:Basic Teradata Query Reference APPENDIX B Loading and U...
53917 Mar 2006 @ 09:53 PSTdnoethDatabaseReplyHow can I spot strings that are in UPPER case?select *from tabwhere col (casespecific) = upper(col)orwhere col (cs) = upper(col)Dieter
53817 Mar 2006 @ 08:01 PSTvikasToolsTopicdata archival and restoration in TeradataHi,we are trying to write data from a table into a tape & from the tape into a table.I need some scripts/code , approach for data archival and restoration in Teradata.Can anybody please provide the...
53717 Mar 2006 @ 08:00 PSTvikasToolsTopicdata archival and restoration in TeradataHi,we are trying to write data from a table into a tape & from the tape into a table.I need some scripts/code , approach for data archival and restoration in Teradata.Can anybody please provide the...
53617 Mar 2006 @ 05:25 PSTdixonDatabaseReplyscript of teradata tablesHi like demobld.sql file of ORACLE is there any script available in Teradata. demobld.sql file contains all the tables like EMP,DEPT,JOBS,SALGRADE Tables structure and the rows for these tables. so...
53517 Mar 2006 @ 04:21 PSTBaldTonyDatabaseTopicHow can I spot strings that are in UPPER case?Is there a way to tell whether or not a string value is in upper case?Intuitively you tend to think along the lines of testing UPPER() = but that doesn’t work because Teradata (at least, our ins...
53417 Mar 2006 @ 01:15 PSTFredToolsReplyBTEQ logon problemBTEQ only accepts the "batch mode" form of .LOGON while it is reading commands from a file, e.g. when input is redirected on the command line that invokes BTEQ.You can use the .RUN FILE= command to...
53317 Mar 2006 @ 12:42 PSTFredToolsReplyimport data from text fileThe result of the concatenation operator || is of type VARCHAR, so the exported record contains a two-byte length field at the beginning.If you want to use "unformatted" data without the delimiters...
53217 Mar 2006 @ 12:34 PSTFredConnectivityReplyODBC- Enable MS-ACCESS Interoperability Mode"Advanced Options" selections vary depending on the exact level of the Teradata ODBC driver; they can even change from one patch level to another within the same version.
53117 Mar 2006 @ 12:28 PSTFredToolsReplyCode = 2644 No more room in databaseSpace is managed on a "per-AMP" basis. If one AMP is out of space, the database is full. select VProc, CurrentPerm, MaxPerm from dbc.DiskSpace where DatabaseName='SMB_ETLBASE';Data skew such as thi...
53017 Mar 2006 @ 12:12 PSTFredConnectivityReplyHow to use Decimal(15,2)Note that though the logic inside the function body may be "simple", you can't code the prototype as a "simple C function". In other words,DECIMAL8 *udf_m_2(DECIMAL8 *in_val){...}will not work.If y...
52916 Mar 2006 @ 06:59 PSTshaik.feroz@aaa-calif.comConnectivityReplyHow to use Decimal(15,2)you have to increase the output lenght. leave the input as is decimal (15,2)so the largest number you can provide is 9999999999999.99 set the output: Decimal(18,2) {I guess 18 is the max that is ...
52816 Mar 2006 @ 06:01 PSTpgomToolsTopicInformatica 7.1.3Is anyone using informatica 7.1.3 with td utilities from TTU8.1?
52716 Mar 2006 @ 04:26 PSTbarni07DatabaseTopicCan't connect to TeradataHi. I have installed the Teradata 7 Demo Database.I just can't do anything!!What can I do? How can I create a Database and tables and run a query?I've tried using the BTEQ program. I type .logon lo...
52616 Mar 2006 @ 01:59 PSTshaik.feroz@aaa-calif.comUDAReplyDefault spacesit depends on how you define the field.if it is defined as field1 char(25) then the field lenght is 25 no matter what data you put in it.if you define the field as varchar(25) then the field lenght...
52516 Mar 2006 @ 01:18 PSTVincent GabrielliToolsTopicCode = 2644 No more room in databaseHi folks, I need you expert advice once again...the client is trying to execute a procedure and is getting this error message Code = 2644.2644: No more room in database SMB_ETLBASE. Output directe...
52416 Mar 2006 @ 12:33 PSTcandymanConnectivityTopicODBC- Enable MS-ACCESS Interoperability ModeWe are using Access to gather Teradata from one source and SQL Server data from another source for comparisonand reporting. My laptop has an ODBC connection that under Options/Advanced it lists tw...
52316 Mar 2006 @ 12:26 PSTdivyasrheeUDATopicDefault spacesI am new to tera data. I have a doubt, that.. If a field size is 25 and the value in that is only of lenght 10 the remaining 15 places will be blank spaces?Pls help me?
52216 Mar 2006 @ 06:51 PSTpoonamDatabaseTopicenvironment file in bteq scripthi, i am trying to get the names of input/ export files into my bteq script from an environment file.using .i have used.os /pimecris/temp/pims.envbut .import data file= $export does not work.Any su...
52116 Mar 2006 @ 05:29 PSTdixonDatabaseTopicscript of teradata tablesHi may i know on which pdf i can find the table descriptions, there data about the tables used in the pdf. i.e CUSTOMER,OFFERINGS,ENROLLMENT, COURSES...etc. so that i can work on the examples provi...
52016 Mar 2006 @ 04:22 PSTpoonamToolsReplyimport data from text fileHi,This is the little code that i want to test.cast did not solve my problem.i have tried report, data and indicdata type of export/import.first i am exporting, then importing the result to evaluat...
51915 Mar 2006 @ 06:25 PSTKksJobsTopicTeradata Professionals needed in South AfricaHello all,Teradata Professional needed for a leading financial company in South Africa ,you should have more than 1 yr experience on Teradata as Teradata Developer/ ETL / DBA etc. in a large projec...
51815 Mar 2006 @ 04:52 PSTsantoshkumar.bhugathaToolsTopicIndexI have value like "89237498 876345876 737 U " in attribute named NUMBER......... it is a concatenation of '89237498 876345876' ; '737' and 'U' .Now from Number i have fetch '89237498 876...

Pages