IBM Informix Load and Insert with multiple files

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

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

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

3. Shell Programming and Scripting

Multiple files to load into different tables,

4. Shell Programming and Scripting

Insert a header record (tab delimited) in multiple files

Hi Forum. I'm struggling to find a solution for the following issue. I have multiple files a1.txt, a2.txt, a3.txt, etc. and I would like to insert a tab-delimited header record at the beginning of each of the files. This is my code so far but it's not working as expected. for i in...

5. UNIX for Dummies Questions & Answers

Insert a line into multiple files

HI All, I want to know if it is possible to print the same message but into 2 different files in the same command? Something like . .. ... echo "Text" >> file1 && file2 this is because i creating a script which i use a log but i don't want to duplicate lines of command just to...

6. Shell Programming and Scripting

Insert Filename into Multiple Files

Hi, We have a folder that has files in the following structure abc.sql def.sql efg.sql . . . xyz.sql I have to find a certain string (say "test") in each file and replace it with the name of the file. For eg. if "test" is present in abc.sql, I want to replace it with "test abc". If...

7. Shell Programming and Scripting

insert filename into each line of multiple files

I need to insert <filename + comma> into each line of multiple files. Any idea how to script that? Regards, Manu

8. UNIX and Linux Applications

how to create a logfile in unix after insert/update/delete from informix

I am running a Informix-4GL program to insert/update/delete on a particular table (say xxx). Now I want to create a logfile in unix which will store the affected data(say xxx.*) along with user information (say uname,IP address etc.) what command I should use from Informix-4GL ? I have tried the...

9. Shell Programming and Scripting

Need help in wrting Load Script for a Load-Resume type of load.

hi all need your help. I am wrting a script that will load data into the table. then on another load will append the data into the existing table. Regards Ankit

10. Programming

How can i load or insert a table in oracle from c language thru unix environment

I'm having a oracle server and i'm having a table in that. I'm having a linux server which is in network with the oracle server. I need to write a c program in linux env when on execution loads the table with the text file given as input. Please explain me the flow of process in that and also...

LEARN ABOUT OPENSOLARIS

split

split(1)							   User Commands							  split(1)

NAME

       split - split a file into pieces

SYNOPSIS

       split [-linecount | -l linecount] [-a suffixlength]
	    [file [name]]

       split [-b n | nk | nm] [-a suffixlength] [file [name]]

DESCRIPTION

       The  split  utility reads file and writes it in linecount-line pieces into a set of output-files. The name of the first output-file is name
       with aa appended, and so on lexicographically, up to zz (a maximum of 676 files). The maximum length of name is 2 characters less than  the
       maximum	filename length allowed by the filesystem. See statvfs(2). If no output name is given, x is used as the default (output-files will
       be called xaa, xab, and so forth).

OPTIONS

       The following options are supported:

       -linecount | -l linecount

	   Number of lines in each piece. Defaults to 1000 lines.

       -a suffixlength

	   Uses suffixlength letters to form the suffix portion of the filenames of the split file. If -a is not  specified,  the  default  suffix
	   length  is  2. If the sum of the name operand and the suffixlength option-argument would create a filename exceeding NAME_MAX bytes, an
	   error will result; split will exit with a diagnostic message and no files will be created.

       -b n

	   Splits a file into pieces n bytes in size.

       -b nk

	   Splits a file into pieces n*1024 bytes in size.

       -b nm

	   Splits a file into pieces n*1048576 bytes in size.

OPERANDS

       The following operands are supported:

       file    The path name of the ordinary file to be split. If no input file is given or file is -, the standard input will be used.

       name    The prefix to be used for each of the files resulting from the split operation. If no name argument is given, x will be used as the
	       prefix  of  the	output	files.	The  combined  length of the basename of prefix and suffixlength cannot exceed NAME_MAX bytes. See
	       OPTIONS.

USAGE

       See largefile(5) for the description of the behavior of split when encountering files greater than or equal to 2 Gbyte ( 2^31 bytes).

ENVIRONMENT VARIABLES

       See environ(5) for descriptions of the following environment variables that affect the execution of split: LANG, LC_ALL, LC_CTYPE,  LC_MES-
       SAGES, and NLSPATH.

EXIT STATUS

       The following exit values are returned:

       0     Successful completion.

       >0    An error occurred.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWesu			   |
       +-----------------------------+-----------------------------+
       |CSI			     |Enabled			   |
       +-----------------------------+-----------------------------+
       |Interface Stability	     |Committed 		   |
       +-----------------------------+-----------------------------+
       |Standard		     |See  standards(5).	   |
       +-----------------------------+-----------------------------+

SEE ALSO

       csplit(1), statvfs(2), attributes(5), environ(5), largefile(5), standards(5)

SunOS 5.11							    16 Apr 1999 							  split(1)

Shell Programming and Scripting