#DateForumTypeThreadPost
2314 Jun 2011 @ 10:22 PDTDatabaseTopicCan somebody help to exec following SQL?Select * FRom T1; Select PK , InCol , Substring(InCol From 1 For Position('|' in InCol)-1) , Substring(InCol From Position('|' in InCol)+1) From T1 ; . When I execute the above query...
2217 May 2011 @ 11:25 PDTDatabaseReplyInserting a value in tableThanks Jimm..This helped....Gr8
2104 May 2011 @ 11:36 PDTDatabaseTopicInserting a value in tableI have column value like CUST.ONGOING |REVENUES Voice Monthly Fees-Contract. I want to extract data which is before pipe delimiter as one column and data after pipe delimiter as another column. ...
2023 Jun 2010 @ 04:44 PDTDatabaseTopicReg Database viewHi,am new to DBA....Can anybody help to create view database?
1923 Jun 2010 @ 04:42 PDTDatabaseReplyReg CLOB variablethanks jim
1821 Jun 2010 @ 06:01 PDTDatabaseTopicHelp in bteqHow to delete based on values in datafile using bteq?
1720 Jun 2010 @ 11:54 PDTDatabaseTopicReg CLOB variableWill teradata stored procedure supports clob variables?
1605 May 2010 @ 06:39 PDTDatabaseTopicHow to Execute the jobs dynamically?I have to schedule jobs and it should execute dynamically(i think we can use crontab in unix for scheduling but how should i make it as dynamic run?...could anybody help me...
1505 May 2010 @ 06:34 PDTDatabaseReplyjob in teradata..its an audit table..so not much rows..can i use bteq utility?
1430 Apr 2010 @ 02:32 PDTDatabaseReplyImport data from Excelyes this would help me ..thanks ashwini
1330 Apr 2010 @ 02:31 PDTDatabaseReplyImport data from ExcelSomething to say? Add your comment here.
1230 Apr 2010 @ 02:26 PDTDatabaseTopicBteq import..Maximum how many rows can we load using bteq?
1130 Apr 2010 @ 02:07 PDTDatabaseTopicjob in teradata..How to create job to load the data from text file to teradata tables(say i have 6 to 7 tables)?
1026 Apr 2010 @ 05:44 PDTDatabaseTopicImport data from ExcelIam having data in Excel file..can we load it using sql assistant...if we can do we have to change delimiters in excel also..
926 Apr 2010 @ 04:15 PDTDatabaseTopicError while Importing data from flat file to table thru sql assistantWhen i load data from file to table thru sql assistant its throwing error like "Query contains 2 parameters but import file contains 1 data values"...i checked the values in file as wel as colu...
820 Apr 2010 @ 06:16 PDTDatabaseReplyMultiLoad - errorthanks jim
719 Apr 2010 @ 03:22 PDTDatabaseTopicMultiLoad - errorA simple MULTILOAD script is applied as follows: *D:\tdata>mload d:\ log.txt * * It constantly generates a kind of 'unsupported configuration' (??) as listed below. ***** ...
619 Apr 2010 @ 12:42 PDTDatabaseReply calling bteq in unix shell scriptThanks srinivasa ...
516 Apr 2010 @ 02:11 PDTDatabaseTopicRelated with automated processi want to drop index,constraints for a table...manually we can do using drop index indexname & alter function to drop constraints...but i want to do it as automated process using bteq & unix...whe...
416 Apr 2010 @ 02:04 PDTDatabaseTopic calling bteq in unix shell scriptHow to call bteq in unix shell script?
306 Apr 2010 @ 04:46 PDTGeneralTopicBTEQhow to assign the statement in bteq ? subj= 'science ' || v_process_cycle || ' Run - Failed; :Group Code ' || in_group_cd || '; database ' || in_db_instance || '; ';
229 Sep 2009 @ 12:01 PDTDatabaseTopicAnalytical functionsI need more technical information about OLAP functions and its usage in real time.Please provide me with documents.
102 Sep 2009 @ 11:47 PDTDatabaseTopicDesign IssueI have surrogate key column and non unique key column.I have to assign primary index. Which column i have to choose (either surrogate key column or non-unique column) in order to make effcient des...