#DateForumTypeThreadPost
625 Jun 2012 @ 03:07 PDTToolsTopic2616: Numeric overflow occurred during computation error given in Control M Hi All, I have a scheduled job in Control M which runs a bteq to insert the data in staging table. But when it runs through control M , it gives 2616: Numeric overflow occurred during comput...
505 Mar 2012 @ 11:19 PSTToolsTopicCheckpoint in FastLoad Hi all, I running a fastload which loads the data from a flat file. Size of the file is 25Gb and it consists of 14 billions records. Can CHECKPOINT value makes a difference to speed up t...
426 Sep 2011 @ 02:41 PDTGeneralTopicControl characters while exporting the data Hi all, I am exporting the data using fastexport. While exporting data, 3 to 4 fields I am casting as varchar. After exporting, these filed also contains the control characters like ^@ ^M ^A...
315 Feb 2011 @ 11:04 PSTGeneralTopicCast smallint to timeHow can i cast smallint value to time. Please help.
212 Nov 2010 @ 12:16 PSTGeneralReplyProblem regarding the difference between two dates in terms of monthalso .... i want the difference between two dates as fraction value.... like for less than one month.....0.65 or somthing for grater than one month ...1.45 or something... how do I get t...
111 Nov 2010 @ 11:58 PSTGeneralTopicProblem regarding the difference between two dates in terms of monthHi Freinds, I m executing the following query, select (date '2010-07-31' - date '2010-06-30')month and getting the result as (2010-07-31 - 2010-06-30) MONTH -------...