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 SUSE

apache::session::store::informix

Session::Store::Informix(3)				User Contributed Perl Documentation			       Session::Store::Informix(3)

NAME

       Apache::Session::Store::Informix - Store persistent data in a Informix database

SYNOPSIS

	use Apache::Session::Store::Informix;

	my $store = new Apache::Session::Store::Informix;

	$store->insert($ref);
	$store->update($ref);
	$store->materialize($ref);
	$store->remove($ref);

DESCRIPTION

       Apache::Session::Store::Informix fulfills the storage interface of Apache::Session. Session data is stored in a Informix database.

SCHEMA

       To use this module, you will need at least these columns in a table called 'sessions':

	id char(32)	# or however long your session IDs are.
	a_session lvarchar

       To create this schema, you can execute this command using the sqlplus program:

	CREATE TABLE sessions (
	   id char(32) not null primary key,
	   a_session lvarchar
	);

       If you use some other command, ensure that there is a unique index on the table's id column.

CONFIGURATION

       The module must know what datasource, username, and password to use when connecting to the database.  These values can be set using the
       options hash (see Apache::Session documentation).  The options are DataSource, UserName, and Password.

       Example:

	tie %hash, 'Apache::Session::Informix', $id, {
	    DataSource => 'dbi:Informix:database',
	    UserName   => 'database_user',
	    Password   => 'K00l'
	};

       Instead, you may pass in an already-opened DBI handle to your database.

	tie %hash, 'Apache::Session::Informix', $id, {
	    Handle => $dbh
	};

       The last option is LongReadLen, which specifies the maximum size of the session object.	If not supplied, the default maximum size is 8 KB.

AUTHOR

       This module was written by Mike Langen <mike.langen@tamedia.ch>, based on the original for Oracle.

SEE ALSO

       Apache::Session, Apache::Session::Store::DBI

perl v5.12.1							    2007-09-28					       Session::Store::Informix(3)

Shell Programming and Scripting