SELECT a.tps_res_nb,
b.tkt_prod_cd,
b.tkt_prod_typ_nm,
b.prod_intrnl_ds,
b.tkt_prod_typ_nm AS tkt_entl_nm,
NVL (b.tkt_prod_nm, b.prod_intrnl_ds) AS tkt_prod_nm,
c.*,
ROW_NUMBER () OVER (PARTITION BY a.tps_res_nb
ORDER BY c.daycount DESC NULLS LAST,
c.adult,
c.dayclass,
b.tkt_prod_typ_nm,
NVL (b.tkt_prod_nm, b.prod_intrnl_ds),
b.prod_intrnl_ds
) AS row_rn
FROM wdw_prarvl_gsta
INNER JOIN crmmprod.wtrip_acm_tkt b
ON (a.tps_res_nb = b.ord_nb)
LEFT OUTER JOIN tkt_attx c
ON (b.tkt_prod_cd = c.code)
Guys need some advice on how to check some of the questions below?
i'm running on an open VMS platform... which i am an idiot to...
appreciate if anyone can give some hints or source on how to check on..
a script that is running on cron job... but doesn't run as the login user name..
1. why... (6 Replies)
Query 1 : How to check if a directory already exists? If doesn't exist then
create a new one.
Query 2 : I want to put following text using a single echo statement into a
log file and also want to retain the formatting of the text. How it
can be... (3 Replies)
hi guys
Well, i need to have a report generation script or any script which will show me all the content/information of a file when i run that script.
Please help me on this isssue at the earliest.As i am little bit aware of scripting.Thanks in advance!
regards
ash (4 Replies)
Any help on like where to get started on this? I'm just confused.
1. The problem statement, all variables and given/known data:
Enter text here.Queries to satisfy these two report requests (use your CCI database):
Retrieve all rows of active inventory where current on hands is less than... (0 Replies)
Dear All,
Please clarify my queries
My 1st doubt is as you know solaris have default 8 slices out of 8 slices in which slice the OS is stored. Like in windows if you select C drive the Program files are stored in C drive like that in solaris in which slice the OS is stored.
My 2nd doubt is... (2 Replies)
We have 3PVs, now we want to migrate it to new 2PVs.
OLD PVS
hdisk1 ---- /u01
hdisk2 ------ /u01
hdisk 3 ----- /u02, /u01
new PVs
hdisk4 ---- Free
hdisk5 ---- Free
I check man, it doesn't say anything about offline/online thing, do i need downtime to migrate pv ? also, what i... (6 Replies)
Hello,
I am posting the following questions here because I need them answered by people who have actually done a lot of work in GRUB. DO NOT GIVE ME GUESS ANSWERS PLEASE. Feel free to redirect me if this is not the right place to ask these questions.
Can I download GRUB separately from... (6 Replies)
If I have /etc/motd, he is file or directory?
I saw that some call them folders and files others... Which option is better?
I knew that being a director, but many told me not.
Thank you! (1 Reply)
Discussion started by: mescu
1 Replies
LEARN ABOUT CENTOS
truncate
TRUNCATE(1) User Commands TRUNCATE(1)NAME
truncate - shrink or extend the size of a file to the specified size
SYNOPSIS
truncate OPTION... FILE...
DESCRIPTION
Shrink or extend the size of each FILE to the specified size
A FILE argument that does not exist is created.
If a FILE is larger than the specified size, the extra data is lost. If a FILE is shorter, it is extended and the extended part (hole)
reads as zero bytes.
Mandatory arguments to long options are mandatory for short options too.
-c, --no-create
do not create any files
-o, --io-blocks
treat SIZE as number of IO blocks instead of bytes
-r, --reference=RFILE
base size on RFILE
-s, --size=SIZE
set or adjust the file size by SIZE bytes
--help display this help and exit
--version
output version information and exit
SIZE is an integer and optional unit (example: 10M is 10*1024*1024). Units are K, M, G, T, P, E, Z, Y (powers of 1024) or KB, MB, ...
(powers of 1000).
SIZE may also be prefixed by one of the following modifying characters: '+' extend by, '-' reduce by, '<' at most, '>' at least, '/' round
down to multiple of, '%' round up to multiple of.
GNU coreutils online help: <http://www.gnu.org/software/coreutils/> Report truncate translation bugs to <http://translationpro-
ject.org/team/>
AUTHOR
Written by Padraig Brady.
COPYRIGHT
Copyright (C) 2013 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>.
This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law.
SEE ALSO dd(1), truncate(2), ftruncate(2)
The full documentation for truncate is maintained as a Texinfo manual. If the info and truncate programs are properly installed at your
site, the command
info coreutils 'truncate invocation'
should give you access to the complete manual.
GNU coreutils 8.22 June 2014 TRUNCATE(1)