Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bunwong

    ReportNet Tabular SQL - accept variable/function?

    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...
  2. bunwong

    how to create group and share directory in batch mode

    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
  3. bunwong

    Apache exception

    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...
  4. bunwong

    How to use named pipe for fastload in windows 2003?

    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...
  5. bunwong

    Can Teradata Handle LEFT OUTER JOIN + UNION ALL + PPI Access At The Sa

    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...
  6. bunwong

    how to use partition on the following sql?

    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...
  7. bunwong

    how to use partition on the following sql?

    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...
  8. bunwong

    longest match in Teradata

    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
  9. bunwong

    longest match in Teradata

    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...
  10. bunwong

    Teradata Longest Match

    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...
  11. bunwong

    How to compare if two sets are equal.

    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)
  12. bunwong

    Performance problem in permanent journel

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

    Performance problem in permanent journel

    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...

Part and Inventory Search

Back
Top