#DateForumTypeThreadPost
64610 Apr 2014 @ 11:44 PDTDatabaseReplyEmail from BteqOne way using bteq  is  export the data to file in a specified directory. In the same script, use mailx -s "......." your file. If  you want to convert a file to xml, then ...
64510 Apr 2014 @ 04:08 PDTGeneralReplyTreating NULL from bteq exportI feel that bteq export is fine. I think you use load data infile ....in mysql. where you may need to check the script...... If I am not wrong \N is represented for NULL in mysql. Do you need to ...
64408 Apr 2014 @ 06:56 PDTAnalyticsReplyREGEXP_SPLIT_TO_TABLE doesn't work Is this what you are looking for? An example from a document   CREATE TABLE split_table_latin(id integer, src varchar(100) character set latin, pattern varchar(100) character set la...
64308 Apr 2014 @ 02:54 PDTDatabaseReplyMaximum Data Block SizeThis link will answer many questions. http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/Database_Management/B035_1093_111A/ch04.023.05.html I think only the DBA can see valu...
64207 Apr 2014 @ 07:57 PDTDatabaseReplyHelp needed in Bteq ExportWhy did you comment it? It is a concatenation of all and it is titled as ''. Also, when you get extra characters at the beginning of the line , you can easily remove them using unix.
64107 Apr 2014 @ 06:14 PDTDatabaseReplyusage of ^ in logical conditions^ is an issue. Maybe you can double check with the customers if ^ is a typo mistake. In unix it is the match of beginning of a string or line. Business folks can talk in theri own lingo who knows ....
64007 Apr 2014 @ 06:07 PDTDatabaseReplyIS NOT IN SyntaxIS NOT IN is wrong syntactically.
63907 Apr 2014 @ 05:55 PDTDatabaseReplyHow to call Fastexport script in UnixI suggest you better ask your  Unix admin for the $PATH settings. Of course you can do it, using the global find where the fastexport is there. Also you can get clue from your bteq path&n...
63806 Apr 2014 @ 10:58 PDTDatabaseReplyHow to call Fastexport script in Unixecho $HOME. See this the content : ls -ltra $HOME/.tdlogon if it shows up. Also see the .profile  content. See the PATH settings for fastexport (fexp). Cheers,  
63704 Apr 2014 @ 09:54 PDTAnalyticsReplyCast data entered is character: 062177 for test.   select cast(cast(dt as date format 'MMDDYY') as date format 'YYYY-MM-DD') from raja.test1   result: 1977-0...
63604 Apr 2014 @ 09:01 PDTDatabaseReplyMERGE INTO and CONCATENATIONHi Cloud36, Maybe you can share the descriptions of yout table1 ,table2 and  sample data maybe too.  Cheers,
63504 Apr 2014 @ 05:32 PDTGeneralReplyHow we can replicate Tables structures between 2 teradata servers ?If it is simple one and one-off situation , I think you can use script(unix/excel) to compare. Note: You can also think that if  many more functionalities than what you require then...
63404 Apr 2014 @ 04:54 PDTDatabaseReplyTeradta Error 6908I don't know what is there beginning and end of the entire process. I have not seen your code code. I m suggesting that maybe you can try  stuffing your INSERTS/UPDATES if ...
63304 Apr 2014 @ 01:43 PDTDatabaseReplyTeradta Error 6908Is it for the same one table? Maybe you can stuff your inserts/updates if for the same table in BT/ET BT---Begin transaction  ET---End transaction
63204 Apr 2014 @ 12:05 PDTCloud ComputingReplyTrustworthy cloud computing service?Whaw!!! hope you will call me for a party once :) kidding It is better to do more rounds of reviews before you give your stuffs to someone's else hands.It depends on you. It has its own advan...
63103 Apr 2014 @ 11:37 PDTDatabaseReplyMERGE INTO and CONCATENATIONAgree with Dieter. I cannot see in the link provided, that it does not support concatenation. Also , if it does not support such concatenation , then it is a limitation of DB. Maybe you can look ag...
63003 Apr 2014 @ 11:20 PDTDatabaseReplyNumber Datatype issue with TeradataYes, if infa works it that way and you can't change then need  a work around. If you can't change the target data type, then maybe you need an extra step. I remember one occassion wit...
62903 Apr 2014 @ 10:20 PDTDatabaseReplyNumber Datatype issue with Teradata  Is it just one value? How about this setting: "Enable high precision property in Session level" Teradata data column type : Is it just number or number(m,n) in target? Did you t...
62803 Apr 2014 @ 09:42 PDTDatabaseReplyError handling when inserting recordsHi, I am not able to understand clearly. Are you able to get the error table? Below sample ksh script can help you(test it before running). You can think of redirecting the output to a file. Then...
62702 Apr 2014 @ 11:58 PDTDatabaseReplyMERGE INTO and CONCATENATIONHave you done the part: select CAST(a.col2 as VARCHAR(3)) ||','|| CAST(b.col2 as VARCHAR(3)) from ...... Can it be because of width anomoly of col2=.....??? In other databases, say SEL...
62602 Apr 2014 @ 06:04 PDTDatabaseReplyHelp me to get the backup of ONLY DBC tables DDL (Not data).You can get from BAR. Also: select 'show table ' || trim(databasename) ||'.'|| trim(tablename) ||';'      from dbc.tables      ...
62502 Apr 2014 @ 02:17 PDTDatabaseReplyKey (Important) tables in DBC databaseI think you can collect stats on these tables. DBC.AccessRights DBC.DBase DBC.Indexes DBC.Owners DBC.Profiles DBC.Roles DBC.RoleGrants DBC.TVFields DBC.TVM DBC.UDFInfo We may ne...
62401 Apr 2014 @ 06:32 PDTDatabaseReplyUpgrade TD14.10 and Reserved WordsYou mean SYSLIB.SQLRestrictedWords  where you have  keywords??? If it is me, even though if I am almost 100% sure, I take a backup somewhere. It may become handy somewhere down the ...
62301 Apr 2014 @ 12:18 PDTDatabaseReplyError handling when inserting recordsFor emailing, I usually put my TD script in unix scripting and use  mailx -s ".....".... I am not aware of, if there is any feature that can  handle within TD itself. Cheers,
62231 Mar 2014 @ 02:00 PDTDatabaseReplyunable to download vmware teradata expressAre you logged in? You can try once again.  Also, you can see many solutions in  http://forums.teradata.com/forum/cloud-computing  :). You can check your 64 bit OS compatibility too...

Pages