Search results for query: *

Hi, I have multiple files, say, test1.dat, test2.dat, etc. Each file has only one record. I tried: cat test*.dat > final.dat The records from each file were combined into one line instead of separate lines in the final.dat file. How do I combined the record from each file while appending...

Thanks! Ken. Does this mean %Used is more crucial than the number being reported by %Iused when it comes to knowing whether a file system is about to get filled up? Michael

Hi, The output from the df command, Filesystem 1024-blocks Free %Used Iused %Iused Mounted on /dev/hd2 2097152 271868 88% 35871 36% /usr What exactly is the difference between the number reported by %Used and %Iused? Thanks! Michael

Thank you! I kept thinking the Min function needs to be placed somewhere outside of the "SELECT.." statement. Mike

Hi, I have a table similar to the following example: ColumnA ColumnB ================== A 01/02/2006 B 10/10/2005 A 01/01/2006 C 10/10/2005 D E 11/10/2005 I would appreciate help in writing a query that will capture data like this: ColumnA...

Hi, I set up a Perl script to run once a day by Windows 2003 Task Scheduler for a long time and it has been working until several days ago. Server administor claimed nothing had changed and finally offered a workaround by running the script from a .bat file and create a new task schedule to...

Hi, Need some help in the proper VB statements to initialize the DTPicker upon Form_Load. Since the end of month may be different from month to month depending on the month and the current year. What would be the proper VB statements to use to initialize the DTPicker value as the end of the...

Hi, I have a bunch files under a directory and each contain multiple email addresses. What would be the quick way, from the command line, to search for specific address and replace it to another if found? For example, look for user1@mycompany.org in each of the file under the dirctory and, if...

When I ran this command I did not get anything returned: ps -augx | grep sendmail Should I use some other ps argument? Also tried mailq and the output said the queue is empty. Thanks, Mike

Thanks, I looked at the header but not sure how to interpert it. It would seem the delay was between mypc.mycompany.org and mysmspc1.mycompany.ROOT.mycompany.ORG? Received: from mypc.mycompany.org ([102.178.36.103]) by mysmspc1.mycompany.ROOT.mycompany.ORG with Microsoft...

Hi, Not sure the best forum to post my question in addition to the general Unix one so I am starting with the Exchange 2003. We have an AIX server and a script to generate a text log file. At the end of the script we use the following command to send the file out via internet email address...

Hi, Not sure the best forum to post my question so I am starting with the general section first. We have an AIX server and a script to generate a text log file. At the end of the script we use the following command to send the file out via internet email address (for sake of example): mailx...

Hi, I have two SQL 7 tables called, "Model," and "ModelMembers." Model table has data as follow: ID ModelName 1 Model1 2 Model2 3 Model3 4 Model4 5 Model5 6 Model6 ModelMembers table has data representing association between all models: ID ModelID ModelMemberModelID 1 1 1 2...

Thanks! The click event is working as suggested. Mike

Hi, I am unable to trigger a SAVE button to be enabled upon a change in the combo box selection. The combo box is populated by the following database query: Private Sub LoadModelUnit() Dim mrsModelUnit As Recordset Dim sSQL As String Set mrsModelUnit = New Recordset...

Hi, How would I retrieve the newest primary key (an autonumber field in a SQL7 db) immediately after a conn.execute insert command is executed? Thanks, Mike

Hi, After reinstalling the VS6.0, an error msg popped up stating unable to open a few CrystalReport.dsr forms. When checking the Projects/Reference, the highlighted line indicated a missing Crystal Report 7 ActiveX Designer Run Time Library and the location is c:\Program Files\Seagate...

Hi, As a newbie, I have always thought that once the rm is issued on the files, those files would be permanately gone from the file system thus freeing up disk space. Then a colleague of mine just told be the following, which now I am getting a bit confused. This was what I was told: "For...

Thanks, Tony. Based on your example, I found the following portion worked for me: SELECT TOP 1 COLUMN1, COLUMN2 FROM YourTable; Mike

Hi, Need help in creating a query showing numbers appearing most frequently under each column, for example: DATE COLUMN1 COLUMN2 1/1/2004 2 5 1/2/2004 3 2 1/3/2004 4 3 1/4/2004 2 1 1/5/2004 2 5...