Search results for query: *

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

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

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

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

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 :)

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

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

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

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

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