#DateForumTypeThreadPost
32313 Jun 2011 @ 02:51 PDTDatabaseReplySupporting Multiple Environments on One ServerHi, Well, talk about ideal scenario .... yes every environment should be seperate .... starting from IP address, network cables, server etc etc etc!! But what if pocket doesn't allow that? :) ...
32213 Jun 2011 @ 02:39 PDTDatabaseReplySQL help?@Vamsi .... is the table historized? Just as D said .... more information can be helpful :)
32109 Dec 2010 @ 01:47 PSTDatabaseReplyImplicit conversion CHAR to INT failingThanks Dieter! Needed exactly that kind of detail over why its happening. :) Regards, MAC
32008 Dec 2010 @ 05:04 PSTDatabaseTopicImplicit conversion CHAR to INT failingHi, Have a following scenario: Source table named TEST2: CREATE SET TABLE Test2 ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT ( Col1...
31903 Sep 2010 @ 03:00 PDTExtensibilityReplyData Migration from Oracle (Data Import)Hi, ETL tool can be a good option if possible in your case .... otherwise .... search for Data-Direct Connector and/or GoldenGate Data Connector .... they might also be used in your case. Reg...
31803 Sep 2010 @ 02:54 PDTExtensibilityReplyQuerying XML Data stored in the databaseHi, You need to search for TeraXML or TeradataXML ... forgot the exact name my apologies for that! Regards, MAC
31703 Sep 2010 @ 02:51 PDTUDAReplyDrop Table "if exists"The solution mentioned above can be easily implemented in Teradata and obviously can be called from SQL Assistant. Regards, MAC
31603 Sep 2010 @ 02:48 PDTDatabaseReplySoft RIHi, As of restriction, it depends how you plan to implement it. For drawbacks, it include more effort and more CPU time for processing the same data-set. Nothing much I believe. Regards, MAC
31503 Sep 2010 @ 02:41 PDTDatabaseReplyTIMESTAMP(0) showing .0 at the endHi, This has to do with the FORMAT setting not at the database end, but at the application end. So try to tweak that. For assurance if the issue is same .... try to put data in file by casting i...
31403 Sep 2010 @ 02:38 PDTGeneralReplyFailure 2646 No more spool space inHi, The user can have higher MaxPerm the DB/User it was created earlier .... there is no issue in that. Ideally what you should have done was to set values for the user and not for the DB. Re...
31303 Sep 2010 @ 02:34 PDTGeneralReplyTeradata equivalent Query of SQL ServerHi, You can use the same query .... and replace ISNULL with COALESCE. Regards, MAC
31205 Jul 2010 @ 01:58 PDTCloud ComputingReplyTeradata Express for VMware Player - Growing Pains and Version RefreshHi, Out of curiosity, do we have any download of 1TB version so far? :) Regards, MAC
31105 Jul 2010 @ 01:56 PDTDatabaseReplyDay-to-Day DBA TaskHi, Though unlike other RDBMSs you won't find many of them .... but some can be space management across databases/users, DBQL tables periodic truncation (if enabled offcourse), refreshing statis...
31005 Jul 2010 @ 01:51 PDTDatabaseReplyExternal Table to loadHi, You can look into Table-UDFs for the similar functionality of external tables. Example can include Table-UDF over a text file, and then you can query it just as a normal table. Please note, ...
30929 Jun 2010 @ 11:21 PDTMarketing & CRMReplyI need a MACRO that will allow the User to define the tableElastic Marts Builder can be an option, thanks for sharing robpaller, but again .... k_suji86 .... if you could express the need more, it would be more useful.
30829 Jun 2010 @ 11:09 PDTDatabaseReplyAbout call Stored procedure in ASPHi, Its been an age i worked on ASP .... but from what i can remember .... try looking into ADODB.Connection object and using that try to execute the command over that connection and use MOVENEX...
30729 Jun 2010 @ 11:02 PDTDatabaseReplyIdentifying Status of CALL to Stored Proc?Hi, You can make use of stored-procedure labels to do this conditional exit with user-defined return-code. Regards, MAC
30629 Jun 2010 @ 10:59 PDTDatabaseReplyCollect StatsHi, The time can be estimated over data-volume, data-type of column and count of columns. But off-course they can't be very accurate. I believe, there isn't any way to do 'collect stale stats...
30529 Jun 2010 @ 10:47 PDTGeneralReplyBTEQHi, This can also be done using stored-procedure (SP) .... i.e. doing all the pre-processing of a variable in a SP, and returning that in the BTEQ. Another option can be to do pre-processing ...
30423 Jun 2010 @ 11:30 PDTUDAReplyOracle Reports connectiing to TERADATA@datawarehousing: Am sure you have been working with DWH for good 3 years, please don't flood the forum with similar messages no where near to a solution of a raised problem! @CarlosAL: Nice lin...
30323 Jun 2010 @ 11:12 PDTDatabaseReplyThe same user already logged on to DBS...Hi, Are you using same version of ARCMAIN for both activities? Regards, MAC
30223 Jun 2010 @ 11:10 PDTDatabaseReplyHow to select values based on variable name and primary key using SQLHi, What sort of data-volume is expected in this table? Regards, MAC
30122 Jun 2010 @ 09:30 PDTDatabaseReplyRegarding upsertHi, Logically putting UPSERT in one line: If the row exists (same PK), it'll update, if not it'll insert. Example is as follows: MERGE INTO Table1 AS tt USING Table1_tmp AS st ON ...
30022 Jun 2010 @ 09:26 PDTThird Party SoftwareReplySecurity Code vulnerabilities in Informatica seciprts, BTEQ ScriptsHi, Your statement is bit confusing .... Informatica mappings are being developed over BTEQ scripts? Or BTEQ scripts are being used in Informatica mappings? Regards, MAC
29922 Jun 2010 @ 09:16 PDTAnalyticsReplyMAX() and MAX() OVER (PARTITION BY ....) in the same query produces error 3504Hi, What you are trying to do is to get two MAX() values, one partitioned other over whole data-set. As semantically it is wrong, so you need to re-valid what exactly you are trying to do here. ...

Pages