03-07-2006
Quote:
Originally Posted by GCTEII
It seems that I can't change the value straightly ......
Is there any method to change the value straightly? ( not use sed )
Why cant you change the value manually ? What is it that you are trying and what is the error that you are facing ? Check the permissions et al..
I think it should be as simple as opening the file in your favourite editor and changing the value.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi there,
I hope someone can help me with this problem :
I have a directory (/var/www/file/imgprofil) which contains about 10000 JPG files. They have a naming convention thus :
prefix-date-key-suffix.jpg
they all have the prefix p-20050608-
then AAAA is a 4 letter code
the suffix is... (7 Replies)
Discussion started by: steve7
7 Replies
2. UNIX for Dummies Questions & Answers
Hi
I am accessing a file on nfs mounted device, after completing using of the file, i am tring to restore the access time and modification times of the file.
So i got the previous modified time of the file using stat() function and trying to set the date and time for the file, To set these... (6 Replies)
Discussion started by: deepthi.s
6 Replies
3. Shell Programming and Scripting
Hello,
say suppose i am processing an file emp.dat the field of which are
deptno empno empname etc
now say suppose i want to change the file to emp.lst then how can i do it? Here i what i attempted but in vain
BEGIN{
system("sort emp.dat > emp.lst")
FILENAME="emp.lst"
}
{
print... (2 Replies)
Discussion started by: salman4u
2 Replies
4. Shell Programming and Scripting
Hi, I am creating a ksh script to search for a string of text inside files within a directory tree. Some of these file are going to be read/execute only. I know to use chmod to change the permissions of the file, but I want to preserve the original permissions after writing to the file. How can I... (3 Replies)
Discussion started by: right_coaster
3 Replies
5. Shell Programming and Scripting
Hi All,
Please help i have written an ksh script, where i am actually take count of lines in one file and want to update this count to 2nd field of a new file and apend the this into an existing file.
Note the below script is in for loop
-------- I am apending few records in a file... (7 Replies)
Discussion started by: iamnoone
7 Replies
6. Shell Programming and Scripting
HI
I have 100 files in below folder:-
/home/lkj/TEST
File name like below
undo_ARL01003_120907-155022.mos
undo_ARL01006_120908-155042.mos
i want replace one first line of each file to pt all
i want change file name as below.
ARL01003.mos
ARL01006.mos
Thanks (2 Replies)
Discussion started by: asavaliya
2 Replies
7. Shell Programming and Scripting
Hi,
I have a files in a directory as below :-
ls -1
mqdepth-S1STC02
proc-mq-S1STC01
proc-mq-S1STC02
proc-mq-S1STC03
Whereever i have S1STC i need to copy them into new file with file name S2STC.
expected output :-
ls -1
mqdepth-S2STC02
proc-mq-S2STC01
proc-mq-S2STC02... (3 Replies)
Discussion started by: satishmallidi
3 Replies
8. Shell Programming and Scripting
I have a bunch of file numbers in the file 'test':
I'm trying the above command to change all the instances of "H" to "Na+" in the file testsds.pdb at the line numbers indicated in the file 'test'. I've tried the following and various similar alternatives but nothing is working:
cat test |... (3 Replies)
Discussion started by: crunchgargoyle
3 Replies
9. Shell Programming and Scripting
Hi,
I have a file which has wrong time format and we want to correct it before we load it.
WRONG FORMAT : 93:0:00
CORRECT FORMAT :09:30:00
If you notice the 0 at the front is missing. Its the case always. (6 Replies)
Discussion started by: varun22486
6 Replies
10. UNIX for Beginners Questions & Answers
I have a log file, which i have divided into 14 files using csplit, the file looks like below
test-000000
test-000001 #and so on until 14
now I want all the 14 files generated to be renamed as the some part of test in first line of the file how can i eliminate the unwanted text?
sample... (5 Replies)
Discussion started by: Sekhar419
5 Replies
osql(1) FreeTDS Utilities osql(1)
NAME
osql - utility to test FreeTDS connections and queries
SYNOPSIS
osql -S dsn -U username -P password [-I ini_dir]
DESCRIPTION
osql is a diagnostic tool provided as part of FreeTDS. It is a Bourne shell script that checks and reports on your configuration files. If
everything checks out OK, it invokes isql.
osql works only with the isql that comes with unixODBC.
OPTIONS
-S dsn the Data Source Name to which to connect, as known to odbc.ini.
-U username
database login name.
-P password
database password.
-I ini_dir
override odbc.ini file location.
EXAMPLE
If you have an odbc.ini with a section like this:
[myDSN]
servername = myserver
TDS_Version = 5.0
You would invoke osql as:
osql -S myDSN [...]
NOTES
If you can connect with "osql -S servername -U user -P passwd", your FreeTDS ODBC installation is working.
osql guesses where unixODBC might look for its odbc.ini by examining the binary. This is not always an effective approach. If it doesn't
work, you'll receive a report of candidate strings. Kindly pass along the output to help improve the guessing.
If osql cannot intuit your odbc.ini directory, you can force the issue with the -I option. However, you're instructing osql what to test,
not where unixODBC will eventually look. Your override is therefore only as good as you are. Look carefully at the error output before
overriding.
If you have suggestions for ways to make osql more useful as a diagnostic tool, please post them to the FreeTDS mailing list.
HISTORY
osql first appeared in FreeTDS 0.65.
AUTHORS
The osql utility was written by James K. Lowden
doc 13 November 2011 osql(1)