#DateForumTypeThreadPost
1907 Feb 2008 @ 01:46 PSTUDAReplySlow Coalesceusing function on the join will be an expensive and time consuming. Try to avoid as much as you can.i would suggest,try to create a derive/volatile table instead of using coalesce function on the j...
1806 Feb 2008 @ 01:06 PSTUDAReplyCheck newline character in a text columnit would be great if you can send doc/link to get the equivalent HEX for all the invisible characters ( like \r,back space,tab ...etc).Again thanks a lot for your help.
1706 Feb 2008 @ 09:00 PSTUDAReplyCheck newline character in a text columnThanks a lot! It works for me.Can you tell me what is x'OA' is? Is it a hexadecimal value for new line character?Thanks,
1605 Feb 2008 @ 03:47 PSTUDATopicCheck newline character in a text columnGuys,can any one let me know how to check the newline character in a given varchar/char field in teradata?ex:i have a text column in a teradata table which can hold 10 characters. I need to check i...
1525 Sep 2006 @ 04:21 PDTDatabaseReplyCompress a table???Thanks
1420 Sep 2006 @ 04:15 PDTDatabaseTopicCompress a table???could any one please tell me how to compress a Teradata table?Thanks in adv,Sparan
1315 Sep 2006 @ 01:50 PDTUDATopicformatting datecan anyone please tell me why the folloing query is not working.i result same format is comming.sel '2004-01-01'(format 'yydd');
1231 Aug 2006 @ 05:14 PDTUDATopicImporting delimiter text file!!!!!!!!can any one please give me a sample script to load a table using bteq import?Thanks in adv.
1131 Aug 2006 @ 01:30 PDTAnalyticsReplyProvider Syntaxtry this....con.Open "Driver={Teradata};DBCNAME=" & DSN & ";uid=" & user_id & "; pwd=" & passwdlet me know if this works for you.-- Sparan
1031 Aug 2006 @ 09:51 PDTUDAReplySupressing Titles on .EXPORT commanduse (title '') for each filed.select APP_NAME(title ''),RUN_NAME(title ''), GROUP_NUMBER(title ''), RUN_ORDER (title '')from $DBPREFIX.dm_driver_steps_t where run_status = 'S' and run_order = 40;us...
930 Aug 2006 @ 10:22 PDTAnalyticsReplystoring PasswordsThere are many ways to store userid/password.below are few ideas......1. you can set the variables a global variables and ask userid and password when they open the workbook.2. ask userid and passw...
822 Aug 2006 @ 11:01 PDTToolsReplyDate Format Problemselect cast( (date (format 'YY-MM-DD')) as char(10)) ;
717 Aug 2006 @ 09:47 PDTToolsReplySelect Top 10 recordstry with Rank function
617 Aug 2006 @ 09:43 PDTUDAReplyLimitation ON Bteq Exportyou are correct. it seems we have MP-RAS.i used fastexport to solve this problem.one more, is there any chance to get octal delimiter "\001" in the fastexport script.thanks a lot,Sparan
517 Aug 2006 @ 08:59 PDTUDAReplyLimitation ON Bteq Exporterroring out after 4.5GB size(24 M). what is MP-RAS ?
416 Aug 2006 @ 02:07 PDTUDAReplye-mail Notificationsyou can use .os to generate email from bteq script. Basically it will execute operating system commands in bteq mode.here is an example sql1;sql2;.os mailx -s "subject" email_address < file_name as...
316 Aug 2006 @ 02:03 PDTUDATopichow to get octal delimiter in the export file???Hello,i need to get the octal delimiter ("\001" non - printable character) in a flat file.please suggest me how to get it in fastexport.that need to be automated.Thanks,Sparan
216 Aug 2006 @ 01:18 PDTDatabaseTopicBteq Export LImitation???Hello,i am trying to export 34M records into a flat file of record length 97 using BTEQ export.I am getting error after exporting 24M records and says "output FIle is to large"Please let me know if...
116 Aug 2006 @ 11:22 PDTUDATopicLimitation ON Bteq ExportHello,i am trying to export 34M records into a flat file of record length 97 using BTEQ export.I am getting error after exporting 24M records and says "output FIle is to large"Please let me know if...