02-14-2012
Quote:
Originally Posted by
ctsgnb
@Sara,
The right way to do it would be to pass an SQL statement directly at database level to extract the information you need and spool it to a file.
I'm not using SQL
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
ALL,
My shell script takes a employee file as input.
I have to identify the list of employees not in the input file and update their status in the database.
Approach I followed:
by traversing through the input file add all the emplid's to a variable.
update the status of employees not in... (2 Replies)
Discussion started by: sailussr
2 Replies
2. Shell Programming and Scripting
I am using /usr/bin/ksh in AIX
I am reading the values of $dbname, $dbatmpdir/dbdir.$$, and $scope from a different file
All I have to do is check if $dbname exists in file $dbatmpdir/dbdir.$$ and
$scope should have a value either 'TABLE' or 'SCHEMA'.
When I execute the following code. I am... (3 Replies)
Discussion started by: tenderfoot
3 Replies
3. Shell Programming and Scripting
Can someone tell me when the script is called, what does it do? I can't see it is going to run anything. (1 Reply)
Discussion started by: dp100022
1 Replies
4. Shell Programming and Scripting
Dear experts,
I have an epoch time input file such as : -
1302451209564
1302483698948
1302485231072
1302490805383
1302519244700
1302492787481
1302505299145
1302506557022
1302532112140
1302501033105
1302511536485
1302512669550
I need the epoch time above to be converted into real... (4 Replies)
Discussion started by: aismann
4 Replies
5. Shell Programming and Scripting
I"m trying to calculate the duration of of backup within a ksh shell script but I get an error.
#!/bin/ksh
STTIM=`date '+%T'`
EDTIM=`date '+%T'`
....
....
echo "DURATION OF BACKUP: $((EDTIM - STTIM))" (5 Replies)
Discussion started by: Bperl1967
5 Replies
6. Shell Programming and Scripting
My goal is to create a script that will check if in a test or production environment. I wrote this script to check $host variable to check which server I'm on but this script does not work.
if
then
BASE=/home/fmtest; export BASE
else
BASE=/home/fmprod; export BASE
fi
... (5 Replies)
Discussion started by: Bperl1967
5 Replies
7. Shell Programming and Scripting
i have a ksh script which internally calls another ksh script.
this inner script has simple commands like shown in the code window.
In the script im trying to do a mv - it fails with arg list too long.
then i try to perform cp and cat - and both are failing with similar error.
:wall:
How is... (4 Replies)
Discussion started by: nyc68
4 Replies
8. UNIX for Advanced & Expert Users
Hi,
I'm quite new to ksh scripting, can someone help me with this.
Requirements:
I need to create a script that list the files from a user input date range.
e. g. format of file:
*c1*log.2012-12-22-14-00*
*c1*log.2012-12-22-14-00*
*c1*log.2012-12-22-14-00*... (1 Reply)
Discussion started by: chococrunch6
1 Replies
9. UNIX for Dummies Questions & Answers
Hi,
I'm quite new to ksh scripting, can someone help me with this.
Requirements:
I need to create a script that list the files from a user input date range.
e. g. format of file:
*c1*log.2012-12-22-14-00*
*c1*log.2012-12-22-14-00*
*c1*log.2012-12-22-14-00*... (7 Replies)
Discussion started by: chococrunch6
7 Replies
10. Shell Programming and Scripting
Requirement is to list the files older than 365 days from multiple directories and delete them and log the list of files which are deleted to a log file.
so 1 script should only list files older than 365 days for each directory separately to a folder
The other script should read these files... (7 Replies)
Discussion started by: prasadn
7 Replies
LEARN ABOUT REDHAT
nwfstime
NWFSTIME(1) nwfstime NWFSTIME(1)
NAME
nwfstime - Display / Set a NetWare server's date and time
SYNOPSIS
nwfstime [ -h ] [ -S server ] [ -U user name ] [ -P password | -n ] [ -C ] [ -s ]
DESCRIPTION
nwfstime displays a NetWare server's date and time. You can also set a NetWare server's date and time from the local time.
OPTIONS
-h
With -h nwfstime prints a little help text.
-S server
is the name of the server you want to use.
-U user
user is the user name to use for login. To set the server's time, you need supervisor privileges.
-P password
password is the password to use for login. If neither -n nor -P are given, and the user has no open connection to the server, nwfstime
prompts for a password.
-n
-n should be given if no password is required for the login. As you need supervisor privileges for setting the date and time, this
option is probably not used very often.
-C
By default, passwords are converted to uppercase before they are sent to the server, because most servers require this. You can turn off
this conversion by -C.
-s
With -s, nwfstime sets the file server's date and time according to the local date and time.
nwfstime 12/10/1996 NWFSTIME(1)