Linux Script to copy and rename files through SQL statement
Hi,
I require help to complete below requirement through Linux Script.
I have a SQL query which shows two columns as output. One is Report Name and other is report path. Query return multiple rows. below is the output.
Now requirement is to copy the file from output path to /opt/reports
further rename the report name which is in output path after out/ with .out extension
with the name in Report name column.
So script will copy the files and rename them in a loop, so that all the records available in the select statement will be copy and renamed.
below is the SQL Query.
Last edited by vbe; 11-13-2017 at 04:53 AM..
Reason: code tags...
Hi all,
I am a newbie in writng unix..I am using ksh shell..Does anyone know how to copy a list o files from directory A to directory B with differnt names? i.e
in Dir A, I have
RPT101.555.TXT
RPT102.666.TXT
and I want to copy those files to dir B with new naming convention..
in Dir B,... (7 Replies)
I have few webservers logs like access.log. which would be growing everyday.
what i do everyday is, take the backup of access.log as access.log_(currentdate) and nullify the access.log.
So thought of writing a script... but stuck up in middle.
My requirement: to take the backup and nullify... (6 Replies)
hello, I need to build a shell script that receives the folder to copy by parameter and copy all files except thumb.db to another folder and rename them like, file.jpg renamed to file_bb1.jpg.
can someone help me
Thanks (4 Replies)
hello,
I am write a Script and i would listing all Files from Path1 out with DSR*.txt and give a new name an copy to the Path2.
I have problems with that to rename. Someone can help me?
Sorry, for my english. My english is not gut.
I hope you understand my.
That is my Script.
... (2 Replies)
Hi All,
I am new to scripting and am looking for some assistance setting up a script. Basically I need the script to scan a folder for the newest files and make a copy of those files, adding a month to the date stamp. I also need this script to delete the previously copied files to save space.... (4 Replies)
Hi,
I need help in shell scripting. If someone can help me, that would be great!
Problem. I want Linux Script to compare two folders and copy missing files.
Description.
I have two directories
/dir1
/dir2
I need to copy all distinct/new/unique/missing files from /dir1 and that... (1 Reply)
I need to pull down a good bit of files for another support team for an upgrade project. I have a server.list with all of the server names.
I need to do two parts:
FIRST:
I have this example, but it does not list the server name in front of each line.
#! /bin/bash
for server in $(<... (10 Replies)
Is better way to write the script loop through one by one "Old_File_1: & New_File_1:" to copy 100 files to /staging/test folder then re-name & gzip all those files? I wrote this code below and don't like that much. Thanks
I have a control_file under /tmp/test folder like below 100 files and... (10 Replies)
#!/bin/sh
sqlplus -s "/ as sysdba" << EOF
SET HEADING OFF
SET FEEDBACK OFF
Select
pt.user_concurrent_program_name , OUTFILE_NAME
FROm
apps.fnd_concurrent_programs_tl pt,
apps.fnd_concurrent_requests f
where
pt.concurrent_program_id = f.concurrent_program_id
and pt.application_id =... (1 Reply)
Discussion started by: usman_oracle
1 Replies
LEARN ABOUT MOJAVE
mac::apps::launch
Launch(3) User Contributed Perl Documentation Launch(3)NAME
Mac::Apps::Launch - Mac module to launch /quit applications
SYNOPSIS
use Mac::Apps::Launch;
my @apps = qw(R*ch Arch MPGP);
my $path = "HD:System Folder:Finder";
LaunchApps([@apps], 1) or warn $^E; # launch and switch to front
LaunchApps([@apps]) or warn $^E; # launch and don't switch
LaunchApps($app, 1) or warn $^E; # launch and switch to front
LaunchSpecs($path, 1) or warn $^E; # use path instead of app ID
QuitApps(@apps) or warn $^E; # quit all @apps
QuitAllApps(@apps) or warn $^E; # quit all except @apps
IsRunning('MACS'); # returns boolean for whether
# given app ID is running
SetFront('MACS') or warn $^E; # set Finder to front
Hide('MACS') or warn $^E; # hide Finder
Show('Finder', 1) or warn $^E; # show Finder (1 == use name)
DESCRIPTION
Simply launch or quit applications by their creator ID. The Finder can be quit in this way, though it cannot be launched in this way.
This module is used by many other modules.
This module as written does not work with MacPerls prior to 5.1.4r4.
"Hide" and "Show" do not currently work on Mac OS X.
Apps that don't have signatures under Mac OS X currently aren't handled, except with LaunchSpecs().
"SetFront" and "IsRunning" can take a four-char creator ID ('MACS'), a bundle ID ('com.apple.Finder'), or a path
(/System/Library/CoreServices/Finder.app). They both optionally take a second parameter which affirms that the data is indeed a path (for
those rare cases where a path might possibly look like a creator ID or bundle ID ... you never know).
"IsRunning" will return the PSN of the application if it is running, which you can then use for targetting the app, or converting to a PID
(with "Mac::Processes::GetProcessPID()"), to send signals to it.
EXPORT
Exports functions "QuitApps", "QuitAllApps", and "LaunchApps", "IsRunning", "LaunchSpecs", "SetFront", "Hide", "Show".
AUTHOR
Chris Nandor <pudge@pobox.com>, http://pudge.net/
Copyright (c) 1999-2005 Chris Nandor. All rights reserved. This program is free software; you can redistribute it and/or modify it under
the same terms as Perl itself.
perl v5.18.2 2007-01-03 Launch(3)