Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Insert Command Creating Table Locking Problem
Top Forums UNIX for Advanced & Expert Users Insert Command Creating Table Locking Problem Post 302806589 by senkerth on Monday 13th of May 2013 09:51:51 AM
Old 05-13-2013
thanks,

so for insert i can do direct insert query no need to put an external lock and then do insert..? even if am inserting 30 rows at time..
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

locking problem

Hi... after unlock my computer from lock, all telnet windows which i opened previously are closing automaticaly... i hope u understand....plz give solution... (1 Reply)
Discussion started by: venkatramana
1 Replies

2. Shell Programming and Scripting

need to insert two columns (or two feilds) at the begining of the table

Hey guys/gals, So here is what i'm starting with...its a Solaris patch diag output. bash-3.0# pca -l Using /var/tmp/patchdiag.xref from Oct/20/08 Host: seiftsx4140 (SunOS 5.10/Generic_127128-11/i386/i86pc) List: missing Patch IR CR RSB Age Synopsis ------ -- - -- --- ---... (3 Replies)
Discussion started by: zeekblack
3 Replies

3. Shell Programming and Scripting

select values from db1 table and insert into table of DB2

Hi I am having three oracle databases running in three different machine. their ip address is different. from one of the DB am able to access both the databases.(means am able to select values and insert values in to tables individually.) I need to fetch some data from DB1 table(say DB1 ip is... (2 Replies)
Discussion started by: aemunathan
2 Replies

4. Shell Programming and Scripting

Insert into Oracle table thru UNIX - linux 2.6.9-89

Hi, I am trying to insert a record into a table (say dips_tbl) which resides in Oracle DB through a ksh script. I want to insert records into few of the table columns-not all. I'll give an e.g. for the date column "CREATE_DATE". For that I first execute SQL1="SELECT SYSDATE FROM DUAL" ... (1 Reply)
Discussion started by: dips_ag
1 Replies

5. Shell Programming and Scripting

Creating a table

I have a file like below Iter 1: Best Model = 10.0 12.0 13.0 17.0 23.3 78.7 Iter 2: Best Model = 10.0 20.0 30.0 40.0 50.0 60.0 Iter 3: Best Model = 27.3 46.3 84.5 23.0 34.5 35.4 etc I want to use a scipts using csh or awk to select the iteration number and show the numbers in a table... (2 Replies)
Discussion started by: kristinu
2 Replies

6. Shell Programming and Scripting

[Solved] Problem insert $1 value into a command

Hi folks I am trying to use a call to a python command within a shell script to help validate a date. If I hard code the date to be checked in the string it works. As follows cmd_result=$(/usr/bin/python -c 'import time; print time.strftime("%d",time.strptime("31/02/2008", "%d/%m/%Y"))'... (2 Replies)
Discussion started by: PatMcDonagh
2 Replies

7. UNIX for Dummies Questions & Answers

Creating a condensed table from a pre-existing table in putty

Hello, I'm working with putty on Windows 7 professional and I'd like to know if there's a way to gather specific lines from a pre-existing table and make a new table with that information. More specifically, I'd like the program to look at a specific column, say column N, and see if any of the... (5 Replies)
Discussion started by: Deedee393
5 Replies

8. Programming

Table Locking in Insert Command.

Hi, i have a java based tool which does insert operation in a TABLE, and in parallel the same table is used by my C++ code which does select Query. the Table will be always busy, but sometimes the table is getting locked when i try to make an insert, am bit confused whether the lock is... (0 Replies)
Discussion started by: senkerth
0 Replies

9. Shell Programming and Scripting

Insert bulk values in DB table using isql

Hello, Objective is to insert bulk values in DB table using isql. Following code tried: isql -SServer_name -Ddb_name -Uuser_name -Ppassword < file.txt cat file.txt for i in `cat data_value_file.txt` do insert into tempdb..temp_table11 values ('$i') go done cat... (3 Replies)
Discussion started by: manishdivs
3 Replies

10. Shell Programming and Scripting

Insert one table and update another with shellscript

I have a problem with my shell script. I want to insert data from file to table1(empty) and then, compare table1 with table2 and update some fields. The first part is correct, but the second part does not work. The only way it works is if after the first part I truncate table1 and run the script... (1 Reply)
Discussion started by: nika_mill
1 Replies

LEARN ABOUT DEBIAN

snmp::info::layer2::cisco

Info::Layer2::Cisco(3pm)				User Contributed Perl Documentation				  Info::Layer2::Cisco(3pm)

NAME

       SNMP::Info::Layer2::Cisco - SNMP Interface to L3 and L2+L3 IOS Cisco Device that are not covered in other classes.

AUTHOR

       Max Baker

SYNOPSIS

	# Let SNMP::Info determine the correct subclass for you.
	my $cisco = new SNMP::Info(
			       AutoSpecify => 1,
			       Debug	   => 1,
			       # These arguments are passed directly to SNMP::Session
			       DestHost    => 'myswitch',
			       Community   => 'public',
			       Version	   => 2
			       )
	   or die "Can't connect to DestHost.
";

	my $class      = $cisco->class();
	print "SNMP::Info determined this device to fall under subclass : $class
";

DESCRIPTION

       Subclass for Generic Cisco Routers running IOS

   Inherited Classes
       SNMP::Info::CiscoVTP
       SNMP::Info::CDP
       SNMP::Info::CiscoStats
       SNMP::Info::CiscoImage
       SNMP::Info::CiscoRTT
       SNMP::Info::CiscoQOS
       SNMP::Info::CiscoConfig
       SNMP::Info::Layer2

   Required MIBs
       Inherited Classes' MIBs
	   See "Required MIBs" in SNMP::Info::CiscoVTP for its own MIB requirements.

	   See "Required MIBs" in SNMP::Info::CiscoStats for its own MIB requirements.

	   See "Required MIBs" in SNMP::Info::CDP for its own MIB requirements.

	   See "Required MIBs" in SNMP::Info::CiscoImage for its own MIB requirements.

	   See "Required MIBs" in SNMP::Info::CiscoRTT for its own MIB requirements.

	   See "Required MIBs" in SNMP::Info::CiscoQOS for its own MIB requirements.

	   See "Required MIBs" in SNMP::Info::CiscoConfig for its own MIB requirements.

	   See "Required MIBs" in SNMP::Info::Layer2 for its own MIB requirements.

GLOBALS

       These are methods that return scalar value from SNMP

       $cisco->vendor()
	       Returns 'cisco'

   Global Methods imported from SNMP::Info::CiscoVTP
       See documentation in "GLOBALS" in SNMP::Info::CiscoVTP for details.

   Globals imported from SNMP::Info::CDP
       See documentation in "GLOBALS" in SNMP::Info::CDP for details.

   Globals imported from SNMP::Info::CiscoStats
       See documentation in "GLOBALS" in SNMP::Info::CiscoStats for details.

   Globals imported from SNMP::Info::CiscoImage
       See documentation in "GLOBALS" in SNMP::Info::CiscoImage for details.

   Globals imported from SNMP::Info::CiscoRTT
       See documentation in "GLOBALS" in SNMP::Info::CiscoRTT for details.

   Globals imported from SNMP::Info::CiscoQOS
       See documentation in "GLOBALS" in SNMP::Info::CiscoQOS for details.

   Globals imported from SNMP::Info::CiscoConfig
       See documentation in "GLOBALS" in SNMP::Info::CiscoConfig for details.

   Globals imported from SNMP::Info::Layer2
       See documentation in "GLOBALS" in SNMP::Info::Layer2 for details.

TABLE METHODS

       These are methods that return tables of information in the form of a reference to a hash.

   Table Methods imported from SNMP::Info::CiscoVTP
       See documentation in "TABLE METHODS" in SNMP::Info::CiscoVTP for details.

   Table Methods imported from SNMP::Info::CDP
       See documentation in "TABLE METHODS" in SNMP::Info::CDP for details.

   Table Methods imported from SNMP::Info::CiscoStats
       See documentation in "TABLE METHODS" in SNMP::Info::CiscoStats for details.

   Table Methods imported from SNMP::Info::CiscoImage
       See documentation in "TABLE METHODS" in SNMP::Info::CiscoImage for details.

   Table Methods imported from SNMP::Info::CiscoRTT
       See documentation in "TABLE METHODS" in SNMP::Info::CiscoRTT for details.

   Table Methods imported from SNMP::Info::CiscoQOS
       See documentation in "TABLE METHODS" in SNMP::Info::CiscoQOS for details.

   Table Methods imported from SNMP::Info::CiscoConfig
       See documentation in "TABLE METHODS" in SNMP::Info::CiscoConfig for details.

   Table Methods imported from SNMP::Info::Layer2
       See documentation in "TABLE METHODS" in SNMP::Info::Layer2 for details.

perl v5.12.4							    2011-09-28						  Info::Layer2::Cisco(3pm)
All times are GMT -4. The time now is 08:28 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy