Dear All
I am stuck in one problem. Kindly help me.
I am taking below mention file as input file and want some op file as mention below.
Kindly send me all possible suggestion and query.
Thnaks
Jaydeep
bELOW IS THE INPUT FILE:
*** Connected to BSCANGR ***... (1 Reply)
Hi All,
Can anybody tell me why is there a "0" in my output of $date_today ?
#!/usr/local/bin/perl
$date_today = system "date '+%y%m%d'";
print "$date_today\n";
Output:
$ perl test4
080908
0 (3 Replies)
Dear all
I had input file as mention below and want op as mention.
Kindly let me knw possible ways.
Regards
Jaydeep
INPUT:
RXOTX-48-1
2A 34
2B 35
RXOTX-499-2
2C 32
RXOTX-4-1
2D 23
OUTPUT: (3 Replies)
Hello Team i have a file with following data (as columns).
I need implement a syntax like below for altering table
ALTER TABLE1 TABLENAME
ADD COLUMN COL1 CHAR(5) NOT NULL WITH DEFAULT
ADD COLUMN COL2 CHAR(5)
..
..
ADD COLUMN COLn CHAR(5) NOT NULL... (1 Reply)
Hi I am a newbie here. I tried searching for the solution but I guess I either didn't find it or there hasn't been one posted.
my problem is I spooled the results of a query into a .txt file. When I cat the file the formating looks great. All the columns are aligned. However once I mailx the... (2 Replies)
can anyone one help me....to make date and time format...to following format for my file
DATE TIME
DD- MON- YEAR 24 Hours
I have a need of format like this
12-Jan-2012 in one column, then time in 24 Hours in another column....please help...me...
... (4 Replies)
Hi,
I have a data as follows in some files, i want to change CHAR(2-20) to VARCHAR(2-20). I should not touch any line with CHAR(1)
Example:
Input:
cur_rev_stage_cd CHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
prev_rev_stage_cd CHAR(5) CHARACTER SET LATIN NOT... (7 Replies)
I need to create a fixed width file based on the column lengths.
lets assume I have six(this may be dynamic) fields each are of different length
column1=6 #size of the column
column2=3
column3=2
column4=3
column5=4
column6=5
I tried below code snippet but it is not working
echo... (4 Replies)
Discussion started by: gvkumar25
4 Replies
LEARN ABOUT DEBIAN
oarstat
oarstat(1) OAR commands oarstat(1)NAME
oarstat - show information about jobs
SYNOPSIS
oarstat [-X|-Y|-J|-D|-f] [-j jobid|--array arrayid] [--sql SQL_properties] [-u user] [--array]
oarstat [-e|-p] [-j jobid | --array arrayid]
oarstat -s [-X|-Y|-J|-D] -j jobid
oarstat [-X|-Y|-J|-D] --gantt "YYYY-MM-DD hh:mm:ss, YYYY-MM-DD hh:mm:ss"
oarstat --accounting "YYYY-MM-DD, YYYY-MM-DD"
DESCRIPTION
This command is used to show information of jobs in OAR batch scheduler.
OPTIONS -f, --full
Very detailed display.
-j, --job job_id
Print information from a specific job.
-e, --events
Print job events only.
-p, --properties
Print job properties in the same format as in the $OAR_RESOURCE_PROPERTIES_FILE file on the nodes.
-s, --state
Print only the state of a specified job. It makes a minimal query to the database. It is optimized to allow scripting for example. Must
be used with -j.
-u, --user [login]
Print information for the current user or the one given. If used with --accounting, print a more detailed accounting report for the
user.
--array [array_id]
Toggle the visualization of array information on. If an array_id is provided, print information relative to the subjobs of the given
array job.
--sql
Restricts display with the SQL where clause on the table jobs (ex: "project = 'p1'")
-D, --DUMPER
Print result in DUMPER format.
-X, --XML
Print result in XML format.
-Y, --YAML
Print result in YAML format.
-J, --JSON
Print result in JSON format.
-g, --gantt "date_start,date_stop"
Print history of jobs and state of resources between two dates like "2006-03-30 13:49:27, 2006-04-30 13:49:27"
--accounting "date_start,date_stop"
Shows accounting information between two dates like "2006-03-30, 2006-04-30".
If --user is also used, more details are shown for this particular user.
Warning: the accounting table must be up to date. The update must be done at superuser level with the oaraccounting command.
-V, --version
Print OAR version number.
-h, --help
Print help message.
SEE ALSO oarprint(1), oarsub(1), oardel(1), oarnodes(1), oarhold(1), oarresume(1)COPYRIGHTS
Copyright 2008 Laboratoire d'Informatique de Grenoble (http://www.liglab.fr). This software is licensed under the GNU Library General Public License. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
oarstat 2012-05-23 oarstat(1)