Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Linux Script to copy and rename files through SQL statement
Top Forums Shell Programming and Scripting Linux Script to copy and rename files through SQL statement Post 303007180 by rbatte1 on Monday 13th of November 2017 05:44:16 AM
Old 11-13-2017
Welcome usman_oracle,

I have a few to questions pose in response first:-
  • Is this homework/assignment? There are specific forums for these.
  • What have you tried in your script so far?
  • What output/errors do you get?
  • What OS and version are you using?
  • What are your preferred tools? (C, shell, perl, awk, etc.)
  • What logical process have you considered? (to help steer us to follow what you are trying to achieve)
  • How do you get the report names? I don't see it in your SQL.
  • Can I presume that the headings in bold do not actually appear in your output? If they do, i don't see where your SQL generates them.
Most importantly, What have you tried so far?

There are probably many ways to achieve most tasks, so giving us an idea of your style and thoughts will help us guide you to an answer most suitable to you so you can adjust it to suit your needs in future.



We're all here to learn and getting the relevant information will help us all.
 

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

copy and rename list of files

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)
Discussion started by: kinmak
7 Replies

2. UNIX for Dummies Questions & Answers

script to rename files with current date and copy it.

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)
Discussion started by: logic0
6 Replies

3. Shell Programming and Scripting

Copy files from folder and rename them

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)
Discussion started by: zeker
4 Replies

4. Shell Programming and Scripting

Files rename and copy

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)
Discussion started by: efeijoo
2 Replies

5. Shell Programming and Scripting

Help with script to copy/rename files, then delete by date

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)
Discussion started by: Lucid13
4 Replies

6. Shell Programming and Scripting

Linux Script to compare two folders and copy missing files

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)
Discussion started by: S.Praveen Kumar
1 Replies

7. Shell Programming and Scripting

Copy down remote files and rename them to include the server name with full path

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)
Discussion started by: asnatlas
10 Replies

8. Shell Programming and Scripting

Is better way copy list of multiple files, rename and gzip

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)
Discussion started by: dotran
10 Replies

9. Shell Programming and Scripting

Oop to copy and rename files through SQL Statement in shell Script

#!/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 DEBIAN

data::phrasebook::sql::query

Data::Phrasebook::SQL::Query(3pm)			User Contributed Perl Documentation			 Data::Phrasebook::SQL::Query(3pm)

NAME

       Data::Phrasebook::SQL::Query - Query Extension to the SQL/DBI Phrasebook Model.

SYNOPSIS

	   my $q = $book->query( 'find_author' );
	   my $q = $book->query( 'find_author', 'Dictionary' );

DESCRIPTION

       An extension to the SQL class to specifically handle the DBI interface for each query requested.

CONSTRUCTOR

   new
       Not to be accessed directly, but via the parent Data::Phrasebook, by specifying the class as SQL.

METHODS

   sql
       Get/set the current "sql" statement, in a form suitable for passing straight to DBI.

   sth
       Get/set the current statement handle.

   args
       Return list of arguments that will be used as bind parameters to any placeholders. Any given arguments will replace the whole list.

       Returns list in list context, arrayref in scalar.

   order
       As for "args", but regarding the corresponding list of argument names.

       The assorted "order_XXX" methods are supported as for "args_XXX".

   dbh
       Get/set the database handle.

PREPARATION 
/ EXECUTING METHODS
   execute
       Executes the query. Returns the result of "DBI::execute".

       Any arguments are given to "order_args" with the return of that method being used as arguments to "DBI::execute". If no arguments, uses
       those already specified.

       Calls "prepare" if necessary.

   order_args
       Given a hash or hashref of keyword to value mappings, organises an array of arguments suitable for use as bind parameters in the order
       needed by the query itself.

   prepare
       Prepares the query for execution. This method is called implicitly in most cases so you generally don't need to know about it.

   rebind
       Rebinds any bound values. Lets one pass a scalar reference in the arguments to "order_args" and have the bound value update if the original
       scalar changes.

       This method is not needed externally to this class.

DELEGATED METHODS

       Any method not mentioned above is given to the statement handle.

       All these delegations will implicitly call "prepare".

SEE ALSO

       Data::Phrasebook, Data::Phrasebook::SQL.

SUPPORT

       Please see the README file.

AUTHOR

	 Original author: Iain Campbell Truskett (16.07.1979 - 29.12.2003)
	 Maintainer: Barbie <barbie@cpan.org> since January 2004.
	 for Miss Barbell Productions <http://www.missbarbell.co.uk>.

COPYRIGHT AND LICENSE

	 Copyright (C) 2003 Iain Truskett.
	 Copyright (C) 2004-2010 Barbie for Miss Barbell Productions.

	 This module is free software; you can redistribute it and/or
	 modify it under the Artistic Licence v2.

perl v5.10.1							    2010-08-31					 Data::Phrasebook::SQL::Query(3pm)
All times are GMT -4. The time now is 11:35 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy