Sponsored Content
Operating Systems Linux Shell Script to generate Dynamic Param file Using SQL Plus Quey Post 302750629 by Sravana Kumar on Wednesday 2nd of January 2013 04:21:21 AM
Old 01-02-2013
RedHat Shell Script to generate Dynamic Param file Using SQL Plus Quey

Hi Jim,

I need to generate param file Dynamically using Linux shell script.

ex: i have query like...

Code:
   SQL> Select * from EMP;

 o/p Emp_No EMP_Name Location
         1         AAA          Tirupati
         2         BBB           Bangalore

...and my expected output is...

Code:
Param_Sample1.prm
------------------
$$EMP_No=1
$$EMP_NAME='AAA'
$$EMP_Location=Tirupati
/* These three values should go to one file  and second record details should go to second param file like....*/

Param_Sample1.prm
------------------
$$EMP_No=2
$$EMP_NAME='BBB'
$$EMP_Location=Bangalore...

like this i am expecting... Please help me on this....Sravan

Last edited by Scott; 01-03-2013 at 02:44 AM.. Reason: Code tags, please...
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Sql dynamic table / dynamic inserts

I have a file that reads File (X.txt) Contents of record 1: rdrDESTINATION_ADDRESS (String) "91 971502573813" rdrDESTINATION_IMSI (String) "000000000000000" rdrORIGINATING_ADDRESS (String) "d0 movies" rdrORIGINATING_IMSI (String) "000000000000000" rdrTRAFFIC_EVENT_TIME... (0 Replies)
Discussion started by: magedfawzy
0 Replies

2. Shell Programming and Scripting

Dynamic SQL query based on shell script parameters

Hi, I need a script that will run a dynamic Oracle SQL. Dynamic meaning the SQL statement depends on the parameter. For instance, something like this: #!/bin/ksh -x # Set environment . /home/mine/set_vars sqlplus $LOGINID <<! >> /home/mine/log.txt select count(1) from $1 where... (2 Replies)
Discussion started by: laiko
2 Replies

3. Shell Programming and Scripting

to read a CSV file and generate SQL output

Friends, This is what I need: I will pass a CSV file as an input, and I want my shell to be reading that CSV file, and based on the parameters it should generate SQLs and write those SQL in a different file in the same location. I'm new to Shell scripting. I'm currently working on a... (1 Reply)
Discussion started by: Ram.Math
1 Replies

4. Shell Programming and Scripting

Read a CSV file and generate SQL output

Friends, This is what I need: I will pass a CSV file as an input, and I want my shell to be reading that CSV file, and based on the parameters it should generate SQLs and write those SQL in a different file in the same location. I'm new to Shell scripting. I'm currently working on a... (25 Replies)
Discussion started by: Ram.Math
25 Replies

5. Shell Programming and Scripting

a shell script to generate an excel sheet from a text file..

hi, i have a text file that looks like this! i want to generate an excel sheet out of it, removing all the junk data except the addresses that look like . Arrow Electrical Services Rotating Machinery, Electrical Contracting & Mining Specialists Onsite maintenance, breakdown... (8 Replies)
Discussion started by: vemkiran
8 Replies

6. Shell Programming and Scripting

Shell script to compare and generate a new file

Requirement is I have two files their format is File1 - input_file ----- tmp_value|3|number|| tmp_value1|3|alpha|| tmp_value2|6|alpha|AA AA| tmp_value3|15|number|000000005| tmp_value4|15|number|000000000000000| tmp_value5|11|alpha|bbbbbbbbbbb| tmp_value6|11|alpha|bb bb| input_file ... (4 Replies)
Discussion started by: greenworld123
4 Replies

7. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies

8. Shell Programming and Scripting

Generate 10000 unique audio file of 2MB each using shell script.

Hi, I want 10000+ unique Audio file of approx 2MB each. How can i generate numerous audio files using shell script. Any tool, command or suggestions are welcome. If i give one audio seed file then can we create numerous unique files with same seed file? Any help is highly appreciable.... (11 Replies)
Discussion started by: sushil.kumar
11 Replies

9. Shell Programming and Scripting

Generate sql statement using shell scripting

Can anyone please assist me? I have attached 2 input files and one output file. I need to generate the sql update statements using the above 2 input files. if inputfile2 has 5 rows, then we should generate 5 update statements because column1 is unique. inputfile1 and inputfile2 may contain more... (10 Replies)
Discussion started by: vinus
10 Replies

10. Shell Programming and Scripting

Parameterizing to dynamically generate the extract file from Oracle table using Shell Script

I have below 2 requirements for parameterize the generate the extract file from Oracle table using Shell Script. Could you please help me by modifying the script and show me how to execute it. First Requirement: I have a requirement where I need to parameterize to generate one... (0 Replies)
Discussion started by: hareshvikram
0 Replies
RoPkg::Exceptions(3pm)					User Contributed Perl Documentation				    RoPkg::Exceptions(3pm)

NAME
RoPkg::Exceptions - exceptions used by RoPkg packages DESCRIPTION
RoPkg::Exceptions is a collection of predefined exceptions used by all modules from RoPkg namespace. SYNOPSIS
#!/usr/bin/perl use strict; use warnings; use RoPkg::Exceptions; sub main { eval { if ( $#ARGV == -1 ) { Param::Missing->throw('No parameter found'); } }; if ( my $e = Exception::Class->caught('Param::Missing') ) { print STDERR $e->message,$/,$e->trace,$/; } } main(); It is very possible that you don't find a good reason for using exceptions from this example. And you are right. This example is kind of silly. But, try to use exceptions in a real project. Then, you will apreciate their real value. DEPENDENCIES
RoPkg::Exceptions require perl 5.008 or later and the Exception::Class module. Exceptions List The following exceptions are defined in this class: *) General - general pourpose exception *) OutsideClass - raised when a method is called outside a class instance *) File - the base for all file related exceptions . This exception has the filename parameter, who can be used to specify the path to the file. filename parameter can be used by all derivated exceptions. The following exceptions are derivated from File: *) File::NotFound - the file was not found *) File::Open - error while opening file *) File::Create - could not create file *) Dir - the base for all directory related exceptions . This exception has the dirname parameter, who can be used to specify the path to the directory. dirname parameter can be used by all derivated exceptions. The following exceptions are derivated from Dir: *) Dir::NotFound - the directory was not found *) Dir::Open - error while opening directory *) Dir::Create - could not create directory *) Param - the base for all parameters related exceptions. This exception has the name parameter, who can be used to specify the parameter name. name can be used by all derivated exceptions. The following exceptions are derivated from Param: *) Param::Missing - the parameter was not found *) Param::Unknown - the parameter is unknown *) Param::Wrong - the parameter has the wrong value or is not defined *) DB - the base for all database related exceptions. This exception has the following parameters: dsn, user and pass . This exception (and the ones derivated from her) are mostly used in RoPkg::DB class. Of course, this doesn't means that you can't use them in your application ;) .The following exceptions are derivated from DB: *) DB::Connect - raised when the connection with the database could not be established *) DB::ConnExists - raised when a connection with the same name already exists. *) DB::ConnNotFound - the requested connection was not found *) DB::NoResults - the sql query returned no results Exceptions Tree ROOT General OutsideClass File File::NotFound File::Open File::Create Dir Dir::NotFound Dir::Open Dir::Create Param Param::Missing Param::Unknown Param::Wrong DB DB::Connect DB::ConnExists DB::ConnNotFound DB::NoResults SEE ALSO
RoPkg::Utils AUTHOR
Subredu Manuel <diablo@iasi.roedu.net> VERSION
The current version is 0.2.1 DIAGNOSTICS
The tests for this module are located in t directory. To run those tests, use the following command: make test SUBROUTINES
/METHODS This module does not have any public methods. INCOMPATIBILITIES
None known to me PERL CRITIC
This module is perl critic level 1 compliant with 1 exception. BUGS AND LIMITATIONS
No known bugs. If you find one (or many) please send me a detailed report. CONFIGURATION AND ENVIRONMENT
No configuration file or environment variables are used by this module. LICENSE AND COPYRIGHT
Copyright (C) 2005 Subredu Manuel. All Rights Reserved. This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. The LICENSE file contains the full text of the license. perl v5.8.8 2006-06-09 RoPkg::Exceptions(3pm)
All times are GMT -4. The time now is 11:34 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy