142 | 18 Jan 2006 @ 07:39 PST | Apukad | UDA | Reply | Grouping sets | Dear Feroz,Unfortunately I will deal with this topic not before next week. But thanks for your ansver! |
141 | 18 Jan 2006 @ 02:48 PST | XTUPIE | Database | Reply | Session modes in Teradata | HiHere are the main differences: TERADATA MODE / ANSI MODE=========================================================================================== Comparison are ... |
140 | 18 Jan 2006 @ 02:25 PST | XTUPIE | UDA | Reply | Opportunity | Hi SteveDo these posts include foreigners. I am a South Africa (Teradata Master).Divvy |
139 | 17 Jan 2006 @ 07:25 PST | Dennis Calkins | Tools | Reply | Unlocking tables after fastload failure | Please see this other thread on the same subject....http://www.teradata.com/teradataForum/shwmessage.aspx?forumid=10&messageid=2703 |
138 | 17 Jan 2006 @ 04:03 PST | Krishan.R | Tools | Topic | Unlocking tables after fastload failure | Is there a way other than dropping and recreating the load tables after the Fastload failed.If so can some one give me the syntax? Your help would be highly appreciated. I tried to runBegin Loading... |
137 | 17 Jan 2006 @ 08:06 PST | DaveWellman | Database | Reply | Session modes in Teradata | Hi Liju,There are two main areas of differences between Teradata and ANSI session modes.The first (and arguably the most important) is to do with transaction control. This affects when a transactio... |
136 | 17 Jan 2006 @ 07:48 PST | freynjord | Database | Reply | ARCHIVE Database | Thanks a lot for theses informations, i tried.But he don't find arcmain.arcmain must be installed on the client or on the server ?I don't see arcmain application on my client teradata. |
135 | 17 Jan 2006 @ 06:26 PST | Dennis Calkins | Database | Reply | ARCHIVE Database | ARCHIVE is a separate program from BTEQ on Teradata. it is called ARCMAIN.Here are the directions that come wit the Teradata Demo CD about archiving the database. I updated it to match what you... |
134 | 17 Jan 2006 @ 04:37 PST | freynjord | Database | Topic | ARCHIVE Database | Hi,i try to archive a database with all tables ans constraints but i've a problem. Could you help me please ...On BTEQ, i'm connect with dbc/sysdba.--> Logon successfully completed..archive data ta... |
133 | 17 Jan 2006 @ 03:55 PST | Srividhya80_b | Tools | Reply | Export a variable length record | Hi Just on similar lines, I need the ASCII '1F' (Non-printable control character' to be used as the delimiter. I have tried this using the BTEQ EXPORT but have not been successful. Can any body... |
132 | 13 Jan 2006 @ 09:24 PST | liju | Database | Topic | Session modes in Teradata | Hi,Can someone let me know the difference between Teradata Session mode and ANSI Session mode..What kind of impact does each mode have? Would like to specifically know about any issues with table c... |
131 | 12 Jan 2006 @ 12:40 PST | Valery | Tools | Topic | import MultiLoad problem | Hello,I have some problems to load a char(06) variable wich represent hours.I'm trying to import this variable in a TIME variable with a format like this HH:MI:SS.What is the command (format) that ... |
130 | 12 Jan 2006 @ 11:46 PST | Dennis Calkins | Connectivity | Reply | Why username and password need to be passed with dataSource.getConnection() | You need to set up Some sort of Single Sign on or other Mutual Authentication method on the Teradata system.What OS type are your Teradata Database nodes and what version of software are you ... |
129 | 12 Jan 2006 @ 11:32 PST | prashanth777 | Connectivity | Topic | Why username and password need to be passed with dataSource.getConnection() | I have configured V5 datasources on WSAD for DB2, Oracle and Teradata. While dataSource.getConnection() with no parameters work fine with DB2 and Oracle, but not with Teradata. For Teradata, we eit... |
128 | 12 Jan 2006 @ 10:51 PST | shaik.feroz@aaa-calif.com | UDA | Reply | Grouping sets | Apukad, ( if you already go the results let me know if there is a good way)i am not sure if this will work for you or not. I tried this example and could get results by using derived tables.in my e... |
127 | 11 Jan 2006 @ 06:14 PST | Dennis Calkins | Database | Reply | renaming a column name.....? | Can you give us the Layout of the table currently? And maybe some made up sample data and explain how you want the layout changed?You could try renaming the column on the select.In ANSI sql you ca... |
126 | 11 Jan 2006 @ 02:52 PST | Mike | Database | Topic | renaming a column name.....? | Hi Everyone,This is more of a SQL question, but figured I would post here as this group has always been super-helpful : )I want to, in the course of the SQL code, rename a column depending on what... |
125 | 11 Jan 2006 @ 01:53 PST | dnoeth | UDA | Reply | compress Timestamp(6) | You can't compress a Timestamp value.Only NULLs might be compressed for Time/Timestamp/Interval...Dieter |
124 | 11 Jan 2006 @ 01:44 PST | shaik.feroz@aaa-calif.com | UDA | Topic | compress Timestamp(6) | Is there a way to compress timestamp(6) field.we have a exp_ts field that gets a default value of 9999-12-31 00:00:00.000000 I want to compress this field is this possible?If it is possible how to ... |
123 | 11 Jan 2006 @ 10:47 PST | Sancerre | Connectivity | Reply | Ole DB Connection string | We have found the answer to the last question as well. To help any of you that may need to use parameters with a command object, then this is how we got it to work: Don't use named parameters, inst... |
122 | 11 Jan 2006 @ 08:04 PST | hitenchavan | Tools | Reply | Teradata Select Case Statement Help | BOTH THE QUERIES WILL WORK******************************************************UPDATE APPL.FR_DETAILFROM APPL.ADMIN_TBLSET ADMIN_FEE = CASE WHEN APPL.FR_DETAIL.AD_NO_ADD = 'A' THEN APPL.ADMIN_T... |
121 | 10 Jan 2006 @ 06:01 PST | RGlass | Database | Topic | Multiload (out of Range error) | Hello all,Is there a good way to handle invalid data when using multiloadie :-( ......)coming in on an MVS flat file.some records return 'out of range error' on one particular field,and others have... |
120 | 10 Jan 2006 @ 04:22 PST | fouttyp | Database | Topic | V2R6 | We are planning an upgrade to V2R6 and was wondering if anyone would tell me their experiences with their upgrade to V2R6. Philip Foutty |
119 | 10 Jan 2006 @ 02:54 PST | Ravindra Harve | Database | Reply | SQL Update | Thank You.RegardsRavi |
118 | 10 Jan 2006 @ 11:55 PST | Sancerre | Connectivity | Reply | Ole DB Connection string | It looks like I found the answer - using the Extended properties appears to do the trick. Here is an example of the connection string that seems to work:Provider=TDOLEDB.1;Data Source=xxx.xxx.xxx;P... |