Search results for query: *

I'm trying to set up sendmail on AIX 5.2 and this is the error message I'm getting after trying to send a test email: Cannot open hash database /etc/mail/domaintable.db: A system call received a parameter that is not valid. Cannot open hash database /etc/mail/mailertable.db: A system call...

vongrunt: I've tried that and the problem still exists. SVRMGR> select dateadd('second',f_createtime,'1970-01-01') from f_sw.vwqueue1_127; select dateadd('second',f_createtime,'1970-01-01') from f_sw.vwqueue1_127 * ORA-00904: invalid column name AND SVRMGR> select...

I'm having an issue trying to convert the UNIX time value to a readable SQL date. I keep getting a "ORA-00904: invalid column name" message. Here's the statement: SVRMGR> select dateadd(second,f_createtime,'1970-01-01') from f_sw.vwqueue1_127; select dateadd(second,f_createtime,'1970-01-01')...

Thanks PH, this is exactly what I'm looking for.

I have 3 files with data with the same number of records in each file. I would like to merge or join these 3 files into a comma delimited file. For example, file1 has the person's name, file2 with their SSN, and file3 has their phone number. file1 file2 file3 john 123456789...

Thanks. Not exactly what I was looking for, but it will do.

I would like know if there's a parameter for the date function in UNIX that shows the day as 1 digit instead of 2 digits? For example, tomorrow is 02/03 (date +%m/%d). How can I make it show up as 2/3 with this date function. I can write a script to strip off the leading zeros, but I would...

Thanx! This is exactly what I needed. Jason

Thanks CaKiwi. However, I happen to have some fields that are blank and it deletes them. For example: 01 | | am | stuck |on| this. This line would produce results: field1=01 field2=am field3=stuck field4=on field5=this. Field2 is ignored and everything is shifted. Any way I can...

Hello, I have a spooled SQL file that I need to separate the fields delimited by pipes using awk or sed. There can be leading and trailing spaces in between pipes. How can I just extract the field itself and not any spaces. For example, file(line) looks like: 01 | I | am | stuck |on|...