|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
How to read a dynamically changing file and load into Oracle?
Post 302074490 by Ambikesh on Tuesday 23rd of May 2006 02:19:38 PM
05-23-2006
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi all
I need to input values in a .csv file into my Oracle table running in Unix, I wonder what would be the command to do so...
The values are recorded in an excel file and I tried using a formatted text file to do so but failed because one of the field is simply too large to fit in the... (4 Replies)
Discussion started by: handynas
4 Replies
2. Shell Programming and Scripting
Hi all,
I have a data like,
0,R001,2,D
this wants to be loaded into a oracle database table.
Pl let me know how this has to be done.
Thanks in advance (2 Replies)
Discussion started by: raji35
2 Replies
3. Shell Programming and Scripting
I have a flat file with records like
Header
123 James Williams Finance2000
124 Pete Pete HR 1500
125 PatrickHeather Engg 3000
Footer
The structure is:
Eno:4 characters
Name:8 characters
Surname : 9 characters
Dept:7 characters
Sal:4characters
These are sample... (1 Reply)
Discussion started by: Shivdatta
1 Replies
4. Shell Programming and Scripting
Hi all,
I'm traying to run a script on Unix with in it sql +.
In this script I want to load a externall file that stand on my unix system into a tmp table of a oracle db, but for some reason it won't work.
Find below the script.
#!/bin/ksh
ORACLE_SID=db1... (7 Replies)
Discussion started by: Tuut-Tuut
7 Replies
5. Shell Programming and Scripting
Hi All,
I want to check load balance(or CPU utilzation) on server dynamically based on that value i want to perform some operation .
Means if load balance is <10 then start server .
Am using prstat -a 1
commadn it is listing CPU utilzation/load balancing dynamically ..
How to take this... (7 Replies)
Discussion started by: vivek1489
7 Replies
6. UNIX for Dummies Questions & Answers
Hi
my requriment is read the file name dynamically my code is
#!/bin/sh
file="/c/work/loan/"
Header_Trailer_move()
{
sed '1d;$d' $file| cat >sam.txt
}
Header_Trailer_move
in above given path my list of files or there i have to read file dyanamically when i entered particular file name... (2 Replies)
Discussion started by: sgoud
2 Replies
7. Shell Programming and Scripting
I want to read a constantly changing file and do some operation on text found in that file.
Actually that is log file of linux system and whenever i find a matching string in that file i want to create a text file with timestamp. is it possible to read that file?
here is sample output of log... (7 Replies)
Discussion started by: kashif.live
7 Replies
8. Shell Programming and Scripting
Hi can anyone help me with a script to load output of the .ksh file into an Oracle database. I have attached sample output of the information that i need to load to the database (2 Replies)
Discussion started by: LucyYani
2 Replies
9. Shell Programming and Scripting
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
10. Shell Programming and Scripting
Experts.
I have created a oracle table as below.
create table xml_tab
(
File_No number ,
File_content Varchar2(2000),
file_type xmltype
);
Daily we are receiving many XML files as below.
here is our sample xml file.
File1 : (7 Replies)
Discussion started by: vasuvv
7 Replies
LEARN ABOUT DEBIAN
dbix::class::schema::loader::dbobject::informix
DBIx::Class::Schema::Loader::DBObject::Informix(3pm) User Contributed Perl Documentation DBIx::Class::Schema::Loader::DBObject::Informix(3pm) NAME
DBIx::Class::Schema::Loader::DBObject::Informix - Class for Database Objects for Informix Such as Tables and Views in DBIx::Class::Schema::Loader DESCRIPTION
This is a subclass of DBIx::Class::Schema::Loader::DBObject that adds support for fully qualified objects in Informix including both "database" and schema of the form: database:owner.object_name METHODS
database The database name this object belongs to. Returns undef if ignore_schema is set. sql_name Returns the properly quoted full identifier with "database", schema and name. SEE ALSO
DBIx::Class::Schema::Loader::Table::Informix, DBIx::Class::Schema::Loader::DBObject, DBIx::Class::Schema::Loader::Table, DBIx::Class::Schema::Loader, DBIx::Class::Schema::Loader::Base 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 2012-05-05 DBIx::Class::Schema::Loader::DBObject::Informix(3pm)