|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Shell Script to Load data into the database using a .csv file and .ctl file
Post 302072672 by Csmani on Friday 5th of May 2006 02:11:36 AM
05-05-2006
Shell Script to Load data into the database using a .csv file and .ctl file
Since i'm new to scripting i'm findind it difficult to code a script. The script has to be an executable with 2 paramters passed to it.The Parameters are
1. The Control file name(.ctl file)
2. The Data file name(.csv file)
Does anybody have an idea about it?
1. The Control file name(.ctl file)
2. The Data file name(.csv file)
Does anybody have an idea about it?
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello people,
Need favour. The problem I have is that, I need to develop a unix shell script that performs recurring exports of data from a csv file to an oracle database. Basically, the csv file contains just the first name and last name will be dumped to an Unix server. The data from these... (3 Replies)
Discussion started by: vinayagan
3 Replies
2. Shell Programming and Scripting
Hi
Does any one have any idea on uploading the data using Unix Shell script from text file to Oracle database.
Requirement:-
1. Need to connect to Oracle database from Unix Shell script.
2. Need to pick Text file from some location on Unix Box.
3. Need to upload the data from text file to... (6 Replies)
Discussion started by: chandrashekharj
6 Replies
3. Shell Programming and Scripting
I am currently trying to find a way to loop through files in a given directory and for each file modify a ctl file and sql load it. I have been using the sed command to change the infile, badfile parameters of the control file. I have not yet tried to sql load it.
Requirement: files are ftp to... (1 Reply)
Discussion started by: dba_nh
1 Replies
4. Shell Programming and Scripting
Hi....can you guys help me out in this script??
Below is a portion text file and it contains these:
GEF001 000093625 MKL002510 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL003604 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL005675 000001... (1 Reply)
Discussion started by: pallavishetty
1 Replies
5. Web Development
hello
i want a script to load the data line by line from a csv file into a mysql
table (3 Replies)
Discussion started by: srpa01red
3 Replies
6. Shell Programming and Scripting
I need help as to how to write a script in Unix for the following:
We have 3 servers;
The mainframe will FTP them to a folder. In that folder we will need the script to look and see if the specific file name is there and load it to the correct table.
Can anyone pls help me out with... (2 Replies)
Discussion started by: msrahman
2 Replies
7. Shell Programming and Scripting
Hello everyone,
I am new to shell scripting/ loading data into a database.
I want to load data into Oracle database using SQL loader. Can some one please explain why do we need unix shell script to load the data into the database? Also can someone please explain what has to be in that script?... (5 Replies)
Discussion started by: new_prog
5 Replies
8. UNIX for Dummies Questions & Answers
Hi Guys,
I am new to shell script.I need your help to write a shell script.
I need to write a shell script to extract data from a .csv file where columns are ',' separated.
The file has 7 columns having values say column 1,column 2.....column 7 as below along with their values.
Name, Address,... (7 Replies)
Discussion started by: Vivekit82
7 Replies
9. Shell Programming and Scripting
Hi everyone,
I have a csv file which has data with different heading and column names as below.
Static Data Ingested
,,,,,,,,,,,,Known Explained Rejections
Column_1,column_2,Column_3,Column_4,,Column_6,Column_7,,% Column_8,,Column_9 ,Column_10 ,... (14 Replies)
Discussion started by: Vivekit82
14 Replies
10. UNIX for Dummies Questions & Answers
Hi Guys,
Another questions to the genius over here. I have spool the dataf from the database into a .csv file. But can it be possible to have all the rows and column with the boundaries..for example the .csv file which i have is as below:
20140327 BU 9A 3
20140327 SPACE 9A 3
20140327... (8 Replies)
Discussion started by: Pramod_009
8 Replies
LEARN ABOUT DEBIAN
gen-ctl-io
GEN-CTL-IO(1) libctl GEN-CTL-IO(1) NAME
gen-ctl-io - generate C interface code for libctl control files SYNOPSIS
gen-ctl-io [OPTION]... [spec-file] DESCRIPTION
gen-ctl-io generates C code to import/export the input/output variables used in a libctl control file. gen-ctl-io generates files like ctl-io.h and ctl-io.c. These files define global variables, data structures, and functions for the input/output variables, classes, and function interfaces defined in the spec-file argument, automating the interaction between C and Guile. The arguments such as --code and --header are used to control whether ctl-io.c or ctl-io.h, etcetera, are generated. If no argument is specified then both of these files are generated by default, for backwards compatibility. libctl is a free library to aid in interfacing scientific software with the GNU Guile scripting and extension language. Documentation for it may be found online at the libctl home page: http://ab-initio.mit.edu/libctl OPTIONS
--code Generate C (or C++) source code to implement the Guile interface functions. The default output file name is ctl-io.c (in C) or ctl- io.cpp (in C++). --header Generate the header file declaring the interface data types and functions. The default output file name is ctl-io.h (in C) or ctl- io.hpp (in C++). --swig Generate a SWIG interface definition file declaring automatic conversions for the various libctl data types. The default output file name is ctl-io.i. --cxx Generate C++ code instead of C code. -o file Use file as the output file name instead of the defaults (above). BUGS
Send bug reports to S. G. Johnson, stevenj@alum.mit.edu. AUTHORS
Written by Steven G. Johnson. libctl March 27, 2006 GEN-CTL-IO(1)