Load multiple files into a table


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Load multiple files into a table
# 1  
Load multiple files into a table

Hi,

I need to load data from two files to a single table.
My requirement is that I get two files in which a few column data are manadatory.
These files are identified based on the file name.
For example, I have two files ABCFile and BCDFile. ABCFile has mandatory data in column 3 and 4 whereas, BCDFile has mandatory data in 5th column.
So I have to validate whether these columns are null before inserting.
I know I can do it by creating 2 control files but is there any way to do it using one control file?
 

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #177
Difficulty: Easy
The Apple Computer Company was founded on April 1, 1976.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need to prepare a CSV table with inputs from multiple files

Hi, We have thousands of Video files and we need to prepare a table with few of it's parameters/values from their Mediainfo output. Here I have 3 sample mediainfo output text files named Vid1, Vid2 & Vid3 so on... (such we have thousands) and each file has exactly 3 lines. $ ls... (6 Replies)
Discussion started by: prvnrk
6 Replies

2. Shell Programming and Scripting

Load mutliple files into Netezza table

Hi All, I get ~1000 files everyday and the current unix script process one file at a time... like it unzips the file, loads into table . This process will repeat how many ever files were present in the directory. I was wondering can we process multiple files (like unzipping and loading X amount... (1 Reply)
Discussion started by: rajasony
1 Replies

3. Shell Programming and Scripting

Multiple files to load into different tables

multiple files to load into different tables, I have a script show below, but this script loads data from txt file into a table, but i have multiple input files(xyzload.txt,xyz1load.txt,xyz2load.txt......) in the unix folder , can we load these files in diff tables (table 1, table2... (1 Reply)
Discussion started by: nani1984
1 Replies

4. Shell Programming and Scripting

Multiple files to load into different tables,

multiple files to load into different tables, I have a script show below, but this script loads data from txt file into a table, but i have multiple input files(xyzload.txt,xyz1load.txt,xyz2load.txt......) in the unix folder , can we load these files in diff tables (table 1, table2... (0 Replies)
Discussion started by: nani1984
0 Replies

5. Shell Programming and Scripting

reading information from a table and apply a command on multiple files

Hey gyuz, I wanna calculate the number of mapped reads of a bam file in a region of interest. I used this code to do so : samtools view input.bam chrname:region1 > region1.txt This will store all the reads from given bam file within the region of interest in region1.txt Now I have... (5 Replies)
Discussion started by: @man
5 Replies

6. UNIX for Dummies Questions & Answers

How To Load Files in (.log) into a table

Hi, I was just wondering how can i load a files from a log file in unix into a table. e.i. a.log contains the ff: text.dmp text2.dmp Table contains the ff: col 1 filename col 2 date created Thank You! (1 Reply)
Discussion started by: lienyca
1 Replies

7. Shell Programming and Scripting

How to Pull out multiple files from DB table and redirect all those files to a differetn directory?

Hi everyone!! I have a database table, which has file_name as one of its fields. Example: File_ID File_Name Directory Size 0001 UNO_1232 /apps/opt 234 0002 UNO_1234 /apps/opt 788 0003 UNO_1235 /apps/opt 897 0004 UNO_1236 /apps/opt 568 I have to... (3 Replies)
Discussion started by: ss3944
3 Replies

8. Shell Programming and Scripting

To load data from variable to oracle table ....???

Hi all, How to load variable value into Oracle table? I have created a file validation shell script. After the validation completes, i need to update a Oracle table with the variable value... Can someone help me how to do it? I have searched, but not able to get answer. i have 4 variables... (2 Replies)
Discussion started by: Amit.Sagpariya
2 Replies

9. Shell Programming and Scripting

To load data from variable to oracle table

Hi all, How to load variable value into Oracle table? I have created a file validation shell script. After the validation completes, i need to update a Oracle table with the variable value... Can someone help me how to do it? I have searched, but not able to get answer. i have 4... (1 Reply)
Discussion started by: Amit.Sagpariya
1 Replies

10. Shell Programming and Scripting

IBM Informix Load and Insert with multiple files

Hi , Can you guys please help as I have list of files xaa, xab, xac.........xza for eg in which to perform load the 1st (xaa) and insert into table, then only proceed for the 2nd , 3rd and so forth. In other words, before 1st one finished, 2nd one shall not load and insert to table, and so... (0 Replies)
Discussion started by: rauphelhunter
0 Replies
FTE(1)							      General Commands Manual							    FTE(1)

NAME
fte - Text editor SYNOPSIS
fte [[options] files ...] xfte [[options] files ...] vfte [[options] files ...] nfte [[options] files ...] sfte [[options] files ...] DESCRIPTION
This manual page documents briefly the fte. Some detailed documentation is available html format, see below. fte is a powerful text editor which closely resembles Borlands programming editors for M$-DOS, but is far more flexible and configurable. OPTIONS
fte uses a command line syntax, which is a little bit different from most of Debian GNU/Linux apps. -h -? --help Help on command line options. -! Ignore any external configuration file and use internal configuration. -l<line>[,<column>] Go to line (and column) in next file on command line. -#<line>[<,column>] Same as -l. Do not use this option. -m[<mode>] Set mode for next files to <mode>. If just plain -m, then use default mode. -C[<.cnf>] Use specified configuration file (compiled). Plain -C does the same as -!. -D[<.dsk>] Load/save desktop from file <.dsk>. If no argument, disable desktop load/save. -H[<.his>] Load/save history from file <.his>. If no argument, disable history load/save. -T<tagfile> Load 'tagfile' at startup. -t<tag> Lookup tag 'tag' and display file containing it. -- The rest of the arguments are not options, but filenames. -+ The next argument is not an option even if starting with a '-'. Useful when loading files that begin with a -. -noi18n Do not use locales in xfte - useful if you have incorrect locales. -noxmb Do not use XMB functions in xfte - useful if you have incorrect locales and you want to use just english fonts. -font Select XWindow font to use with xfte. See VIOFONT also. ENVIRONMENTAL VARIABLES
This is list of variable which might change behavior of some internals of fte. VIOFONT - select font used by xfte ISOCONSOLE - when set, vfte is usign ascii symbols to draw tables. This is useful when iso latin charset is used on console. EXAMPLES
fte -mBIN /usr/bin/vfte load /usr/bin/vfte in BIN mode fte -mBIN -+ -bla- load file -bla- in BIN mode fte -l100,30 win.c go to (100,30) in win.c fte window.cpp load file window.cpp fte -- -1 -2 -3 -4 -5 -6 load files -1, -2, -3, -4, -5, -6 fte -D -H fte.dsk fte.his disable desktop and history loading and saving and load files fte.dsk and fte.his FILES
~/.fterc /usr/local/etc/fte/system.fterc /etc/fte/system.fterc Default configuration files. Includes all keybindings and menus compiled with cfte(1) from config files in /usr/share/doc/fte/config-exam- ple.tar.gz. SEE ALSO
cfte(1), /usr/share/doc/fte/contents.html AUTHORS
This manual page was written by Riku Voipio and Zdenek Kabelac <riku.voipio@iki.fi> <kabi@debian.org> for the Debian GNU/Linux system. DATE
18 Nov 1999 FTE(1)

Featured Tech Videos