multiple updates Post: 79906

Sponsored Content

Top Forums UNIX for Advanced & Expert Users multiple updates Post 79906 by matrixmadhan on Tuesday 2nd of August 2005 03:51:27 AM

08-02-2005

Registered User

multiple updates

Hi all,

I would like to perform multiple updates within a single database open and close.

Box: solaris
dB: informix

This is how i do perform for single update

dbaccess <dbname> -<<EOF
update table1 set col1=1 where col2=1
EOF

i have the col1 values in a file (some 1000 values)
now how do i proceed with an update of 100 values at a time and give a commit. The above sample is time consuming as it has to open and close the database for each and every update done.

And between the dbaccess and EOF i cannot read from the file as within them only database operations are allowed and no file manipulation, storing in variables are allowed.

Any help would be greatly appreciated.

Thanks.

matrixmadhan

View Public Profile for matrixmadhan

Find all posts by matrixmadhan

LEARN ABOUT OSX

kproplog

KPROPLOG(1)						      General Commands Manual						       KPROPLOG(1)

NAME

       kproplog - display the contents of the Kerberos principal update log

SYNOPSIS

       kproplog [-h] [-e num]

DESCRIPTION

       The  kproplog  command  displays the contents of the Kerberos principal update log to standard output.  It can be used to keep track of the
       incremental updates to the principal database, when enabled.  The update log file contains the update log maintained by the kadmind process
       on  the master KDC server and the kpropd process on the slave KDC servers.  When updates occur, they are logged to this file.  Subsequently
       any KDC slave configured for incremental updates will request the current data from the master KDC and  update  their  principal.ulog  file
       with any updates returned.

       The  kproplog  command  can  only  be  run  on a KDC server by someone with privileges comparable to the superuser.  It will display update
       entries for that server only.

       If no options are specified, the summary of the update log is displayed.  If invoked on the master, all of the update entries are also dis-
       played.	 When  invoked	on  a  slave KDC server, only a summary of the updates are displayed, which includes the serial number of the last
       update received and the associated time stamp of the last update.

OPTIONS

       -h     Display a summary of the update log.  This information includes the database version number, state of the database,  the	number	of
	      updates in the log, the time stamp of the first and last update, and the version number of the first and last update entry.

       -e num Display the last num update entries in the log.  This is useful when debugging synchronization between KDC servers.

       -v     Display individual attributes per update.  An example of the output generated for one entry:
	       Update Entry
		  Update serial # : 4
		  Update operation : Add
		  Update principal : test@EXAMPLE.COM
		  Update size : 424
		  Update committed : True
		  Update time stamp : Fri Feb 20 23:37:42 2004
		  Attributes changed : 6
			Principal
			Key data
			Password last changed
			Modifying principal
			Modification time
			TL data

SEE ALSO

       kpropd(8)

																       KPROPLOG(1)