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

    Problem with a date difference formula

    Hello, I have to calculate the difference between two dates (action date and birthday (dob)) and return the result in years, months, days. I have a formula that works really well except for two things. 1)When the day(action_date) = 31 and the month(dob) in (Feb, Apr, Jun, Sep, Nov). When I...
  2. Padre764

    Changing stored procedures on the fly

    Hello, Here is my problem: I am working on a product where the databases that we send to our customers always the same names, FooDB, TrackDB for example. When we troubleshoot these databases, we restore them to one of servers here in the office and rename the databases to the customer's name...
  3. Padre764

    Experience with VSS and PowerBuilder

    Hello, I have been tasked with finding source code control tool for my development group. We use a lot of PowerBuilder. Does anyone have any experience with using VSS as the source control for PB? I'm looking for both good and bad experiences. thanks!!
  4. Padre764

    Dynamically setting path to source csvfiles

    Hello, I have a DTS package with over a dozen csv source files. All of source files will be in the same directory but, the directory will not be in the same location on every machine that I need to run the package on. I know that I can use the Dynamic Properties task to set the path for each...
  5. Padre764

    Reverse engineering index scripts

    Carp, I got around the duplicates by adding the table_name to the where clause but, now I see that I getting every index on the table regardless of the column_name that I specify. Any ideas on that? Thanks, Padre :)
  6. Padre764

    Reverse engineering index scripts

    carp, Thanks. It seems to work but, I am getting duplicates in what is being returned. Padre
  7. Padre764

    Reverse engineering index scripts

    Hello, I have about 60 tables with about 70 indexes between them. I need to add a new field to all of the tables. Once the new field is on all of the tables, I need to recreate all of the existing indexes using the new field instead of one of the existing fields. I.E. if the existing index...
  8. Padre764

    Printing the last x num of fields in var length record

    Hello, I am trying to create a nawk script to do the following: print the $1, $2, $(NF-1), $NF (basically print the first two fields and then the last two fields where the number of fields for each row varies). When I try to run this I get an error ("Trying to access field -1"). Any...
  9. Padre764

    Left Outer Join not returning unmatched rows

    Hello, I am using Oracle 9.2.0.3. I want to find out what columns exist in one table but don't exist in another table. Here is the SQL: select a.column_name dim_col , b.column_name hist_col from user_tab_columns a left outer join user_tab_columns b on a.column_name = b.column_name where...
  10. Padre764

    Grepping for carriage returns and line feeds

    Hello, I am trying to write a ksh script to search text files for carrige returns (\r) and line feeds (\n). I need to find the lines have \r\n versus the lines that have just \n. I know that I can run dos2unix to clean up the file but I want to know beforehand what lines this is going to...

Part and Inventory Search

Back
Top