Search results for query: *

Hi all, Did you have any experience embedding variable/function in ReportNet Tabular SQL? e.g. can I use something like today() function in my Tabular SQL? I need to have constant string date of today in the SQL. (Due to other limitation, today() function in the RDBMS side won't work) I know...

Dear all, Do you know how to - create user group - share directory in batch mode for windows 2003? I have tried "Net Group" but it is only for Domain Controller. But my server is standalone, and I want to create local group. Thanks, Bun

Dear all, I have received an apache exception as follow. Do you have any idea about the exception, why it happen? Thanks. ========================== org.apache.jasper.JasperException at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254) at...

Hi experts, I have tried to use the named pipe for fastload using the np_AXSMOD.dll as indicated in the document, however, it failed, do you have any idea about the errors? I/O Error on Open: 34, Text: Error: Invalid pmHandle parameter my script and log attached. Thanks! Bun...

We have the following scenarioa and would like to have you advise: - table BILLED_CALL_RECS, PI = Cust_Num, Subr_Num, PPI column = Call_Start_Date - table PREPD_CALL_RECS, PI = Cust_Num, Subr_Num, PPI column = Call_Start_Date - table PREPD_POSTPAID_SUBR, PI = Cust_Num, Subr_Num, no PPI When...

Dear Roger, Thanks, for your input. However I still do not understand... My problem is that the sql won't use partition, how does the PI affact the use of partition? also, if i just want to have a simple select on the table (i.e. i don't have ref_customer) , i.e select field1, field2 from...

We are using the following query to get data from a table which is paritioned by "call_start_date" Select field1, field2 From huge_tbl Where Call_Start_Date >= current_date - 60 We found that we are not able to use the partition because of the "current_date" function and the ">=", this causes...

Hi dnoeth, After applying your suggest, we got a dramatic improvement (> 10 times) on the matching. We have go ahead with your approach. Thanks. Bun

Dear all, We are seeking for a most effective way to perform longest match in Teradata. Following is our situation: The source data is called "call_records" (2.8 million records). The pattern table is called "dialed_digits" (15,000 records). We are using the following SQL to perform longest...

Dear all, It seems the simplest way to do a longest match in Teradata is to use like and qualify rank. However, it causes large spool during its product join. And, we cannot use Update /w join to update with only the longest match record, as what Oracle does in PL/SQL. I find a SQL in this...

intersect" the 2 tables. the are identical if the result row count is the same as the 2 source tables (of course the 2 source tables already has same number of rows, otherwise you can directly jump to the conclusion that they are different)

Dear dnoeth, I am talking Insert/Upadte/Delete. I have no problem on select. Any work around for the incremental backup? Thanks, Bun

Hi, We are planning to perform an incremental backup on a hugh table. Full backup won't work here due to the size. As a result, we have turned on the permanent after journal of the table and try to backup the journal instead. However, after turning on the journal, it causes peroformance...