#DateForumTypeThreadPost
4827 Jul 2011 @ 09:12 PDTDatabaseReplyTeradata to teradata replication using Golden GateThanks :-)
4727 Jul 2011 @ 09:11 PDTDatabaseReplyTimeStamp value for every record inserted using ins/selectHi Dieter, Thanks very much!! Worked perfect
4625 Jul 2011 @ 11:06 PDTDatabaseReplyTimeStamp value for every record inserted using ins/selectHi Dieter, What i am trying is to get a unique timestamp for every record inserted using insert/select... However when i execute the above query for all the rows the timestamp is the same ..
4524 Jul 2011 @ 08:48 PDTDatabaseReplyTimeStamp value for every record inserted using ins/select2nd Try
4420 Jul 2011 @ 08:57 PDTDatabaseReplyTeradata to teradata replication using Golden GateThanks!!! .. Yes they can handle huge volume of data.. no doubt ... But they cant handle deletes. The data at the target would only get loaded after the complete data load is done at the source ......
4318 Jul 2011 @ 08:10 PDTDatabaseReplyTeradata to teradata replication using Golden GateHi Jim, The extract process is executing fine But the sort is failing... as i am executing in max protection mode ...
4216 Jul 2011 @ 11:51 PDTDatabaseTopicTimeStamp value for every record inserted using ins/selectHi, i need to add a default timestamp for every row inserted into a table. Sql Statement: create table tbl_A ( a integer, b timestamp(0) default current_timestamp(0) ); ins tbl_A(1...
4116 Jul 2011 @ 11:44 PDTDatabaseTopicTeradata to teradata replication using Golden GateHi, At my source - around 3 million records are inserted into a table in one transaction. Is it possible to replicate 3 million records using Golden Gate. Source and target database being Te...
4010 Feb 2010 @ 01:55 PSTDatabaseTopicGlobal Temp tableHi,I understand that the GTT have their definition in data dictionary and the data is localised for the user for that session.But could any one let me know where GTT is used in the real world. With...
3902 Feb 2010 @ 06:08 PSTDatabaseReplyBirthdaysThis should work...sel emp_name,emp_dob from empwhere emp_dob between current_date and current_date + 7;
3823 Oct 2009 @ 12:38 PDTDatabaseReplyserach for "?"Hi,I am getting the following error:Un-Named Parameter marker found.Use Import Mode
3721 Oct 2009 @ 06:48 PDTDatabaseTopicserach for "?"Hi,I need to serach for strings with "?" (with out quotes)example:quest?onmar?sli??lecan any body throw some light on this.-GRR
3627 Aug 2008 @ 05:30 PDTDatabaseReplyTimestamp difference in secondsHi ,I tried this with timestamp(6):sel extract(second from timestamp '2008-08-27 05:24:44.470000+00:00') -extract(second from timestamp '2008-08-27 05:24:31.240000+00:00')
3521 Aug 2008 @ 11:04 PDTDatabaseReplyhow to write a function to retrieve random character from A TO ZThere are efficient ways than writing like this(i guess)... But this is one of the way to achive what you wantsel case when a1=1 then 'A'when a1=2 then 'B'when a1=3 then 'C'end,random(1,3) as a1fro...
3420 Aug 2008 @ 11:58 PDTDatabaseReplyHow to fetch only the first character from a word using FORMAT optionsel cast(col_name as char(1)) from tbl_nm;
3325 Jun 2008 @ 06:01 PDTDatabaseTopicBteq:INDICDATAHi,Has anybody used INDICDATA option in Bteq while exporting/importing.I know that the field will show the nullvalue fields in that record.But how to read it as the exported data will not be in the...
3226 May 2008 @ 02:12 PDTDatabaseReplySQL Assistant behaving weirdHi,Tried the folowing :sel cast(date '0001-01-01' as char(10)) o/p -- 0001-01-01For all years < 0100 the output seems to be blank.Strange .. something with the calculation of the date ?
3122 May 2008 @ 12:54 PDTDatabaseReplyTo capture the return code in BTEQHi,The logon was just an example that i gave. a.txt is present in the middle of the Bteq script.There were some Sql that had to be run in a.txtBut any idea how to handle File not found in Bteq.
3021 May 2008 @ 02:36 PDTDatabaseReplyTo capture the return code in BTEQHi,I had tried doing that before but it wont work: Here is a part of the logfile .run file a.txt *** Error: Open failed because: No such file or directory+---------+---------+---------+---------+-...
2919 May 2008 @ 02:11 PDTDatabaseReplyConcatenation in MacroHi,Hope this helps:create macro macro_nm(wherecond varchar(10)) as( sel * from tbl_nmwhere col_nm= :wherecond ;);
2815 May 2008 @ 08:08 PDTDatabaseTopicTo capture the return code in BTEQHi,if i want to capture the returncode of the following stmt how do i do that in BTEQ .Env:UNIX. Parent.btq is running the logon.txt.Run File logon.txt-- say suppose the file logon.txt itself doesn...
2712 May 2008 @ 07:03 PDTUDAReplyRegarding Inserting Date valuesHi,Sql assistant always shows date column in the format 'mm/dd/yyyy'
2622 Apr 2008 @ 04:41 PDTDatabaseReplyHow to get a list of internal functionsHi,You can try the following command to get the list of DBS SQL commands and functions:help 'SQL'and if u want to know more about the function say (ABS) you can give:help 'SQL ABS'
2521 Apr 2008 @ 06:27 PDTDatabaseReplyTeradata equivalent with recursiveHi,for recursion - a very good articlehttp://www.teradata.com/tdmo/v06n03/Tech2Tech/InsidersWarehouse/OddballSQLTricks.aspx
2424 Mar 2008 @ 08:09 PDTDatabaseReplyHow to insert a string with quotes into a char datatype?Thank you

Pages