19 | 07 Feb 2008 @ 01:46 PST | UDA | Reply | Slow Coalesce | using 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... |
18 | 06 Feb 2008 @ 01:06 PST | UDA | Reply | Check newline character in a text column | it 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. |
17 | 06 Feb 2008 @ 09:00 PST | UDA | Reply | Check newline character in a text column | Thanks 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, |
16 | 05 Feb 2008 @ 03:47 PST | UDA | Topic | Check newline character in a text column | Guys,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... |
15 | 25 Sep 2006 @ 04:21 PDT | Database | Reply | Compress a table??? | Thanks |
14 | 20 Sep 2006 @ 04:15 PDT | Database | Topic | Compress a table??? | could any one please tell me how to compress a Teradata table?Thanks in adv,Sparan |
13 | 15 Sep 2006 @ 01:50 PDT | UDA | Topic | formatting date | can anyone please tell me why the folloing query is not working.i result same format is comming.sel '2004-01-01'(format 'yydd'); |
12 | 31 Aug 2006 @ 05:14 PDT | UDA | Topic | Importing delimiter text file!!!!!!!! | can any one please give me a sample script to load a table using bteq import?Thanks in adv. |
11 | 31 Aug 2006 @ 01:30 PDT | Analytics | Reply | Provider Syntax | try this....con.Open "Driver={Teradata};DBCNAME=" & DSN & ";uid=" & user_id & "; pwd=" & passwdlet me know if this works for you.-- Sparan |
10 | 31 Aug 2006 @ 09:51 PDT | UDA | Reply | Supressing Titles on .EXPORT command | use (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... |
9 | 30 Aug 2006 @ 10:22 PDT | Analytics | Reply | storing Passwords | There 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... |
8 | 22 Aug 2006 @ 11:01 PDT | Tools | Reply | Date Format Problem | select cast( (date (format 'YY-MM-DD')) as char(10)) ; |
7 | 17 Aug 2006 @ 09:47 PDT | Tools | Reply | Select Top 10 records | try with Rank function |
6 | 17 Aug 2006 @ 09:43 PDT | UDA | Reply | Limitation ON Bteq Export | you 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 |
5 | 17 Aug 2006 @ 08:59 PDT | UDA | Reply | Limitation ON Bteq Export | erroring out after 4.5GB size(24 M). what is MP-RAS ? |
4 | 16 Aug 2006 @ 02:07 PDT | UDA | Reply | e-mail Notifications | you 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... |
3 | 16 Aug 2006 @ 02:03 PDT | UDA | Topic | how 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 |
2 | 16 Aug 2006 @ 01:18 PDT | Database | Topic | Bteq 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... |
1 | 16 Aug 2006 @ 11:22 PDT | UDA | Topic | Limitation ON Bteq Export | 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... |