05-05-2006
Is this SQL Loader you are using to load data into oracle database?
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
dbix::class::schema::loader::manual::upgradingfromv4
DBIx::Class::Schema::Loader::Manual::UpgradingFromV4(3pmUser Contributed Perl DocumentatiDBIx::Class::Schema::Loader::Manual::UpgradingFromV4(3pm)
NAME
DBIx::Class::Schema::Loader::Manual::UpgradingFromV4 - Important Information Related to Upgrading from Version 0.04006
What Changed
o add_column
The new Loader detects much more information about columns and sets flags like "is_auto_increment" that it didn't set before.
o RelBuilder
The new RelBuilder will give you nicer accessor names for relationships, so you will no longer have conflicts between a foreign key
column and the relationship accessor itself (if the FK is named "_id".)
It will also more correctly infer the relationship type, e.g. some relationships that were previously detected as a "has_many" will now
be a "might_have" (when it detects a unique constraint on the foreign key column.)
Also "cascade_delete" and "cascade_copy" are turned off for by default for "has_many" and "might_have" relationships, while
"belongs_to" relationships are created with "on_delete => 'CASCADE'" and "on_update => 'CASCADE'" by default. This is overridable via
relationship_attrs.
o moniker_map
Table names are now singularized when determining the "Result" class names. So the table "user_roles" would have become "UserRoles" in
0.04006 but now becomes "UserRole" instead.
o use_namespaces
Now defaults to on. See "use_namespaces" in DBIx::Class::Schema::Loader::Base and "load_namespaces" in DBIx::Class::Schema.
o Support for more databases
We now support Microsoft SQL Server and Sybase, and there are also many improvements to the other backends.
Backward Compatibility
In backward compatibility mode, the Loader will use the old relationship names and types, will not singularize monikers for tables, and
"use_namespaces" will be off.
To control this behavior see "naming" in DBIx::Class::Schema::Loader::Base and "use_namespaces" in DBIx::Class::Schema::Loader::Base.
Static Schemas
When reading a "Schema.pm" from a static schema generated with an 0.04 version of Loader, backward compatibility mode will default to on,
unless overridden with the "naming" and/or "use_namespaces" attributes.
Dynamic Schemas
Dynamic schemas will always by default use 0.04006 mode and have "use_namespaces" off.
To upgrade a dynamic schema, set the "naming" and "use_namespaces" attributes (which is proxied to the loader) in your "Schema.pm":
__PACKAGE__->naming('current');
__PACKAGE__->use_namespaces(1);
AUTHOR
See "AUTHOR" in DBIx::Class::Schema::Loader and "CONTRIBUTORS" in DBIx::Class::Schema::Loader.
LICENSE
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.14.2 2010-06-10 DBIx::Class::Schema::Loader::Manual::UpgradingFromV4(3pm)