#DateForumTypeThreadPost
1116 Jun 2008 @ 10:54 PDTDatabaseReplyIs there any query which will tell me.....they are in the view session.
1016 Jun 2008 @ 10:28 PDTDatabaseReplyIs there any query which will tell me.....how come we dont have qrylog and qrylogsql tables? We are using Teradata V2R5. We have table call DBQLogTbl, but the data is not as current time. It may have one day delay. Teradata manager can see...
916 Jun 2008 @ 10:06 PDTDatabaseReplyFastExport to TextHere is the FE log file ======================================================================== = = = Fast...
816 Jun 2008 @ 10:03 PDTDatabaseReplyFastExport to TextIt is a tab delimited file. the output file name called agr_farm.out. And I used ultraedit to open it. But the result is wired. Following is one record of the output. L  0063? Ð   99...
712 Jun 2008 @ 04:05 PDTDatabaseReplywhat is the easiest way to change column nameThank you. That works fine.
611 Jun 2008 @ 03:22 PDTDatabaseReplyAVG(date_column) overflowThanks for the reply. We worked around this problem. Since all the dates are in one year, I convert it to Julian Date (YYYYDDD) first, then do a average on the last three digit. then convert it bac...
511 Jun 2008 @ 02:34 PDTDatabaseTopicFastExport to TextThe FastExport script I am using are:.BEGIN EXPORT TENACITY 4SESSIONS 10SLEEP 6;.EXPORT OUTFILE 'e:\datafile\agr_farm.out' mode record FORMAT text;Select COVERAGE_CD,STATE_CD,COUNTY_CD,CROP_CD,INS_...
409 Jun 2008 @ 05:56 PDTDatabaseTopicwhat is the easiest way to change column nameIf i want to change column name from 'ABC' to 'ABCD', what is the easiest way to do it. and if the column is one of the primary index, how could i do it?
309 Jun 2008 @ 05:52 PDTDatabaseReplyModify a column defination with NOT NULL of a TableNeed to correct myslef. 'Alter table' can dropped a non index field. And 'ALTER TABLE ABC ADD ID NOT NULL;' works fine....
209 Jun 2008 @ 04:02 PDTDatabaseReplyModify a column defination with NOT NULL of a TableI don't think you can modify the property of the columns unless you rebuild the table with the new column type. Correct me if I am wrong. So far as I know 'Alter table' can only add a new column bu...
109 Jun 2008 @ 03:08 PDTDatabaseTopicAVG(date_column) overflowwhen I am trying to use the average funtion on a date field, please see the following sql. select avg(planting_dt) from tablename;I encountered following error message:2616: Numeric overflow occurr...

Pages