Load multiple files into a table

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...

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...

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...

4. Shell Programming and Scripting

Multiple files to load into different tables,

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...

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!

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...

8. Shell Programming and Scripting

How do I load records from table to a flat file!

Hi All, I need to load records from oracle table XYZ to a flat file say ABC.dat. could any one tell me how do i do this in UNXI, Regards Ann

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...

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...

LEARN ABOUT PLAN9

ar

AR(1)							      General Commands Manual							     AR(1)

NAME

       ar - archive and library maintainer

SYNOPSIS

       ar key [ posname ] afile [ file ...  ]

DESCRIPTION

       Ar  maintains groups of files combined into a single archive file, afile.  The main use of ar is to create and update library files for the
       loaders 2l(1), etc.  It can be used, though, for any similar purpose.

       Key is one character from the set drqtpmx, optionally concatenated with one or more of vuaibclo.  The files are constituents of the archive
       afile.  The meanings of the key characters are:

       d      Delete files from the archive file.

       r      Replace files in the archive file, or add them if missing.  Optional modifiers are

	      u      Replace only files with modified dates later than that of the archive.

	      a      Place new files after posname in the archive rather than at the end.

	      b or i Place new files before posname in the archive.

       q      Quick.  Append files to the end of the archive without checking for duplicates.  Avoids quadratic behavior in

       t      List a table of contents of the archive.	If names are given, only those files are listed.

       p      Print the named files in the archive.

       m      Move the named files to the end or elsewhere, specified as with

       o      Preserve the access and modification times of files extracted with the x command.

       x      Extract  the  named files.  If no names are given, all files in the archive are extracted.  In neither case does x alter the archive
	      file.

       v      Verbose.	Give a file-by-file description of the making of a new archive file from the old archive and the constituent files.   With
	      p, precede each file with a name.  With t, give a long listing of all information about the files, somewhat like a listing by ls(1),
	      showing
		   mode uid/gid size date name

       c      Create.  Normally ar will create a new archive when afile does not exist, and give a warning.  Option c discards	any  old  contents
	      and suppresses the warning.

       l      Local.  Normally ar places its temporary files in the directory /tmp.  This option causes them to be placed in the local directory.

       When  a	d, r, or m key is specified and all members of the archive are valid object files for the same architecture, ar inserts a table of
       contents, required by the loaders, at the front of the library.	The table of contents is rebuilt whenever the archive is modified,  except
       when the q key is specified or when the table of contents is explicitly moved or deleted.

EXAMPLE

       ar cr lib.a *.o
	      Replace the contents of library with the object files in the current directory.

FILES

       /tmp/v*
	      temporaries

SOURCE

       /sys/src/cmd/ar.c

SEE ALSO

       2l(1), ar(6)

BUGS

       If the same file is mentioned twice in an argument list, it may be put in the archive twice.
       This command predates Plan 9 and makes some invalid assumptions, for instance that user id's are numeric.

																	     AR(1)

UNIX for Dummies Questions & Answers