Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Script for creating Control file in UNIX
Top Forums UNIX for Beginners Questions & Answers Script for creating Control file in UNIX Post 303042060 by abhilashnair on Thursday 12th of December 2019 01:04:24 PM
Old 12-12-2019
Script for creating Control file in UNIX
Delete

---- Original post, restored by mod after being deleted by abhilashnair ----
I have a requirement where, I need to create a control file which will have 3 columns in the header row as below:

Filename
Count
Checksum

This above control file has to contain metadata as above pertaining to 100+ csv files.

So basically I need a script which will parse through the directory take count of each of the csv file , create sha 256 checksum for each and then write this data to the control file.
Last edited by vbe; 12-13-2019 at 11:59 AM.. Reason: Restored original content
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

create control file in UNIX

UNIX gurus: Following is what I am trying to do: I need to create a control file for another file that I am creating. The information needed in the control file is the date in YYYYMMDD format and then the number of records in the other file right justified and lpadded with spaces of 20. So... (5 Replies)
Discussion started by: alfredo123
5 Replies

2. Shell Programming and Scripting

Need help in creating a Unix Script to parse xml file

Hi All, My requirement is create an unix script to parse the xml file and display the values of the Elements/value between the tags on console. Like say, I would like to fetch the value of errorCode from the below xml which is 'U007' and display it. Can we use SED command for this? I have tried... (10 Replies)
Discussion started by: Anil.Wmg
10 Replies

3. Shell Programming and Scripting

(Urgent):Creating flat file using sql script and sqlplus from UNIX Shell Script

Hi, I need help urgently for following issue. Pls help me to resolve this issue. I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql) I given... (6 Replies)
Discussion started by: praka
6 Replies

4. UNIX for Dummies Questions & Answers

UNIX script for reading a file and creating another file

Hi, I am a beginner in scripting...I have to do a script where I have to read a file which has list of job names, line by line and for every line execute a dsjob command to find the log details of the job and extract only the start time of the job, if it is greater than jan 01 2008 and create... (1 Reply)
Discussion started by: Vijay81
1 Replies

5. Shell Programming and Scripting

Creating a control file for a group of files

Hi, We have almost 45,000 data files created by a script daily. The file names are of format-ODS.POS.<pharmacyid>.<table name>.<timestamp>.dat. There will be one data file like this for each pharmacy and each table.(Totally around 45,000) The requirement is to create a control file for each... (2 Replies)
Discussion started by: Maya_Pillai
2 Replies

6. Shell Programming and Scripting

control M character in unix file

in a file we are getting control character in a file , is there any way that they can be removed once we have the file for eg. BEGIN-PROCEDURE INITIALIZE ^M LET #row_count = 0^M ^M ^M (2 Replies)
Discussion started by: lalitpct
2 Replies

7. Shell Programming and Scripting

Control from UNIX script is not returning to the Parent program

Hi All, My program flow is as below Windows batch -- > Cygwin batch --> zsh script There are multiple Cygwin batch scripts that are called from Windows batch file . But when i am executing the first cygwin batch script the control goes to the zsh file and executes and stoping from... (1 Reply)
Discussion started by: Hypesslearner
1 Replies

8. Shell Programming and Scripting

Control not returning from Sqlplus to calling UNIX shell script.

Hello All, I have a UNIX script which will prepare anonymous oracle pl/sql block in a temporary file in run time and passes this file to sqlplus as given below. cat > $v_Input_File 2>>$v_Log << EOF BEGIN EXECUTE IMMEDIATE 'ALTER SESSION FORCE PARALLEL DML PARALLEL 16'; EXECUTE... (1 Reply)
Discussion started by: vikas_trl
1 Replies

9. Shell Programming and Scripting

Control not returning from Sqlplus to calling UNIX shell script.

Hello All, I have exactly same issue @vikas_trl had in following link: https://www.unix.com/shell-programming-and-scripting/259854-control-not-returning-sqlplus-calling-unix-shell-script.html I wonder if he or somebody else could find the issue's cause or the solution. Any help would... (4 Replies)
Discussion started by: RicardoQ
4 Replies

10. UNIX for Beginners Questions & Answers

Creating script to read many files and load into database via single control file

Hi, I have many files but with only 2 names , I want to load the data of that file into database through sqlldr with single control file. how can i do that ????? Example: switch_file switch_file billing_file billing_file now these files should be loaded into same database but different... (1 Reply)
Discussion started by: niti_sharma
1 Replies

LEARN ABOUT DEBIAN

rt-shredder-4

rt-shredder(8)						     Request Tracker Reference						    rt-shredder(8)

NAME

       rt-shredder - Script which wipes out tickets from RT DB

SYNOPSIS

	 rt-shredder --plugin list
	 rt-shredder --plugin help-Tickets
	 rt-shredder --plugin 'Tickets=query,Queue="general" and Status="deleted"'

	 rt-shredder --sqldump unshred.sql --plugin ...
	 rt-shredder --force --plugin ...

DESCRIPTION

       rt-shredder - is script that allow you to wipe out objects from RT DB. This script uses API that RT::Shredder module adds to RT.  Script
       can be used as example of usage of the shredder API.

USAGE

       You can use several options to control which objects script should wipeout.

OPTIONS

   --sqldump <filename>
       Outputs INSERT queries into file. This dump can be used to restore data after wiping out.

       By default creates files <RT_home>/var/data/RT-Shredder/<ISO_date>-XXXX.sql

   --object (DEPRECATED)
       Option has been deprecated, use plugin "Objects" instead.

   --plugin '<plugin name>[=<arg>,<val>[;<arg>,<val>]...]'
       You can use plugins to select RT objects with various conditions.  See also --plugin list and --plugin help options.

   --plugin list
       Output list of the available plugins.

   --plugin help-<plugin name>
       Outputs help for specified plugin.

   --force
       Script doesn't ask any questions.

SEE ALSO

       RT::Shredder

perl v5.14.2							    2013-05-22							    rt-shredder(8)
All times are GMT -4. The time now is 08:23 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy