11-07-2007
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 following :
RUN "cat xxx.*>>xxx.log"
RUN "echo xxx.* >> xxx.log"
But neither of them worked.
Can anyone please help me?
Thanks & Regards in anticipation.
subhamukh
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Can anyone please help me?
I need to find out if a Unix server running Solaris 2.4 and an Informix V5 Database is capable of CTI via a CSTA Link to a telephone system for screen popping, and what APIs for CTI are supported?
Any help or pointers in the right direction would be much appreciated.... (2 Replies)
Discussion started by: Dave34
2 Replies
2. Shell Programming and Scripting
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
3. UNIX for Advanced & Expert Users
Hi,
I have delimited file(|).
Sample data:
1|name|50009|DS24|0|12
2|name|30009|DS24|0|13
3|name|20409|DS24|0|14
4|name|20009|DS24|0|15
5|name|10009|DS24|0|16
I want to load this data into a oracle table (update and insert)
Please help me the commands and also... (1 Reply)
Discussion started by: unihp1
1 Replies
4. Shell Programming and Scripting
Hi Dudes,
Can you please suggest me how to create a logfile to track the below script output ? Thanks
#!/bin/ksh
# backup the "std" I/P file descriptor
exec 5<&0
#echo "Proceed ?"
while read config_line; do
# backup the I/P file descriptor of "while" block
exec 6<&0
# restore the... (2 Replies)
Discussion started by: shirdi
2 Replies
5. Shell Programming and Scripting
Hello All,
Morning,
I am facing problem with my code while creating a log with name as current time stamp using perl. Here is the code.
#!/usr/bin/perl
my $time=localtime;
my ($day,$month,$date,$tm,$year)=split(/ /,$time);
my $stamp=$year."_".$month."_".$date;
my... (4 Replies)
Discussion started by: krsnadasa
4 Replies
6. Programming
Hi,
I am using INFORMIX 8 and trying to update column value by apending '09' to existing record .
update sample_data_table set Name = Name||22 where id = 90 and state = NY
This worked fine in oracle Database,But throwing error in informix .
I need output as Ravi22 for Ravi record in... (0 Replies)
Discussion started by: Perlbaby
0 Replies
7. Programming
How to get the user name of the Operating system from an Informix 4gl program.
eg:-
-rw-r----- 1 gkuser srth1 292 Jul 27 19:28 u1.txt
i need to get gkuser as the result? (0 Replies)
Discussion started by: enriquegm82
0 Replies
8. Programming
Right I have a MYSQL database with table1 with 3 columns, colA, colB and colC. I want to combine the data in the 3 columns into a 4th column names col_comb. Here's the SQL command that works:
UPDATE table1 SET `col_comb` = CONCAT( `colA` , ' - ', `colB` , ', ', `colC` );
So now I want this... (5 Replies)
Discussion started by: barrydocks
5 Replies
9. Shell Programming and Scripting
Hi folks,
I have a scenario to convert the update statements into insert statements using shell script (awk, sed...) or in database using regex.
I have a bunch of update statements with all columns in a file which I need to convert into insert statements.
UPDATE TABLE_A SET COL1=1 WHERE... (0 Replies)
Discussion started by: dev123
0 Replies
10. Programming
Dear Team
I am using DB2 v10 z/os database . Need expert guidance to figure out best way to track table activities ( Ex Delete, Insert,Update )
Scenario
We have a table which is critical and many developer/testing team access on daily basis . We had instance where some deleted... (1 Reply)
Discussion started by: Perlbaby
1 Replies
LEARN ABOUT DEBIAN
smpppd-ifcfg
SMPPPD-IFCFG(8) SMPPPD SMPPPD-IFCFG(8)
NAME
smpppd-ifcfg - SuSE Meta PPP Daemon
DESCRIPTION
smpppd-ifcfg is a daemon that controls a single dialup connection to the internet. It does so by starting and controlling the pppd. The
configuration of the dialup connections is done by YaST2.
smpppd-ifcfg is not intended for direct use. Use ifup and ifdown or a frontend like cinternet , qinternet or kinternet instead.
OPTIONS
These options are recognized by smpppd-ifcfg. If a long option shows an argument as mandatory, then it is mandatory for the equivalent
short option also.
--up Bring the connection up. This is the default action.
--down Bring the connection down.
--status
Report status of the connection.
-i, --ifcfg=NAME
Specify the ifcfg file to use. This option is mandatory.
-p, --provider=NAME
Specify the provider file to use.
--detach
Detach from the controlling terminal. This is the default.
--nodeatch
Don't detach from the controlling terminal.
-d, --debug
Turn on debugging.
--version
Show program version and exit.
--help Show help information and exit.
FILES
/etc/sysconfig/network/ifcfg-*
Configuration files for the interfaces.
/etc/sysconfig/network/providers/*
Configuration files for the providers.
/var/log/smpppd/ifcfg-xxx.log
Log file.
/var/log/smpppd/accounting.log
File containing accounting information.
/var/run/smpppd.ifcfg-xxx.pid
Pid file.
/var/lib/smpppd/ifcfg-xxx.info
Info file with various status information.
/var/run/smpppd/ifcfg-xxx
Socket to communicate with smpppd.
SEE ALSO
kinternet, qinternet, cinternet(1), accounting(1), wvdial(1), smpppd.conf(5), pppd(8), smpppd(8).
AUTHOR
Arvin Schnell <arvin@suse.de>
SuSE December 2002 SMPPPD-IFCFG(8)