Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: copy, clear and keep to new data only
Top Forums UNIX for Dummies Questions & Answers copy, clear and keep to new data only Post 302091688 by sarge on Wednesday 4th of October 2006 03:01:39 PM
Old 10-04-2006
Question copy, clear and keep to new data only
I have an Ingres database logfile that grows constantly, iircp.log. It is always "attached" to the Ingres process that uses it, and I do not want to screw up the data. I have been copying it to another directory and then using vi on the original to reduce the size 34000 lines at a time. What I want is some way to copy the active file to another directory and drop the difference between the two (any new lines) back into the original file without disconnecting it.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

copy prod data to QA

We keep getting production files into an input directory. These files will be processed three times a day. 8:00AM 1:30PM 5:30PM file1.20041005_05303423.dat File2.200041005_14232313.dat Once the files are processed, they are archived immediately to prod/archive directory ... (1 Reply)
Discussion started by: zomboo
1 Replies

2. AIX

db2 - copy data from one db to another

I need to take data from one database to another on the same machine. My first attempt has been using restore, but I am getting an error. Here is the command I am trying: db2 restore database prod into test I get the following error: The container is already in use. What would... (2 Replies)
Discussion started by: jyoung
2 Replies

3. UNIX for Dummies Questions & Answers

Copy data from tape in unix

Dear sir/madam Could you tell me how to copy or get data from tape to any folder in unix? Thanks, (2 Replies)
Discussion started by: seyha_moth
2 Replies

4. Solaris

Copy data from zfs datasets

I 've few data sets in my zfs pool which has been exported to the non global zones and i want to copy data on those datasets/file systems to my datasets in new pool mounted on global zone, how can i do that ? (2 Replies)
Discussion started by: fugitive
2 Replies

5. UNIX for Dummies Questions & Answers

Copy/Paste data in files

Hi, I want to put the following values into Variables R2=0.999863 , V2=118.870318 , D2=-178.887511 and so on. There are six values for each variable R2-R8, V2-V8 and D2-D8, total of 18 values for all the variables. Can any one help me to copy and paste all the values in their respective... (2 Replies)
Discussion started by: sullah
2 Replies

6. UNIX for Dummies Questions & Answers

how to clear data on / (root)

hello, /dev/dsk/c0t0d0s0 mounted on / it shows 95% full what steps i need to follow in order to clear data??? what files i need to clear??? thanks in advance (2 Replies)
Discussion started by: mtunganati
2 Replies

7. Solaris

Copy data over a TB

Hi All, We are not able to grow a UFS filesystem since its size will be going over a TB and it wasn't created using -T with newfs. Hence we have decided to take the backup of all the files on another filesystem and recreate it using -T with newfs. Please recommend the most reliable... (2 Replies)
Discussion started by: vishalaswani
2 Replies

8. UNIX for Dummies Questions & Answers

Need to copy data from one position to another in file

Hi. I need to write a script that will allow me to copy data from one position in a line to another position while changing the first 2 bytes of the data to a constant. Here is an example of a line of data before and what it needs to look like after. there are about 200 lines in the file. ... (1 Reply)
Discussion started by: wlb_shore_user
1 Replies

9. Shell Programming and Scripting

Copy and paste data

I need to copy from specified lines and paste the data into several other lines. XX123450008 xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x XX123451895 xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x xx.x ...... XX123452012 xx.x xx.x xx.x xx.x xx.x xx.x xx.x... (13 Replies)
Discussion started by: ncwxpanther
13 Replies

10. What is on Your Mind?

Instructions to Clear Data Cache in Safari, Chrome, Firefox, Opera Browsers (Pictures)

Here are instructions to clear the data cache for four browsers, Safari, Chrome, Firefox, Opera. In these examples I'm using MacOS Mojave, but it should be similar for any OS. You can use these instructions to to clear and reload the cache if you have any issues with the Vue.js UserCP (current... (1 Reply)
Discussion started by: Neo
1 Replies

LEARN ABOUT PHP

ingres_connect

INGRES_CONNECT(3)							 1							 INGRES_CONNECT(3)

ingres_connect - Open a connection to an Ingres database

SYNOPSIS

       resource ingres_connect ([string  $database], [string  $username], [string  $password], [array  $options])

DESCRIPTION

       ingres_connect(3) opens a connection with the given Ingres $database.

	The connection is closed when the script ends or when ingres_close(3) is called on this link.

PARAMETERS

	If  some  parameters  are  missing,  ingres_connect(3)	uses  the values in php.ini for $ingres.default_database, $ingres.default_user and
       $ingres.default_password.

	      o $database
		- The database name. Must follow the syntax: $[vnode::]dbname[/svr_class]

	      o $username
		- The Ingres user name

	      o $password
		- The password associated with $username

	      o $options
		-ingres_connect(3) options

	      +----------------------+-------------------------------------------+---+---+
	      |     Option name      |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |		      Option type		 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |		      Description		 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			Example 		 |   |	 |
	      | 		     |						 |   |	 |
	      +----------------------+-------------------------------------------+---+---+
	      |date_century_boundary |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			integer 		 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |	     The  threshold  by  which	 a	 |   |	 |
	      | 		     |	     2-digit year is determined to	 |   |	 |
	      | 		     |	     be in the current century	or	 |   |	 |
	      | 		     |	     in  the next century. Equiva-	 |   |	 |
	      | 		     |	     lent     to      II_DATE_CEN-	 |   |	 |
	      | 		     |	     TURY_BOUNDARY.			 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			  50			 |   |	 |
	      | 		     |						 |   |	 |
	      |        group	     |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			string			 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |	     Specifies the group ID of the	 |   |	 |
	      | 		     |	     user, equivalent to the  "-G"	 |   |	 |
	      | 		     |	     flag				 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			payroll 		 |   |	 |
	      | 		     |						 |   |	 |
	      |        role	     |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			string			 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |	     The  role	ID of the applica-	 |   |	 |
	      | 		     |	     tion. If a role  password	is	 |   |	 |
	      | 		     |	     required, the parameter value	 |   |	 |
	      | 		     |	     should   be   specified	as	 |   |	 |
	      | 		     |	     "role/password"			 |   |	 |
	      | 		     |						 |   |	 |
	      |   effective_user     |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			string			 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |	     The ingres user account being	 |   |	 |
	      | 		     |	     impersonated,  equivalent	to	 |   |	 |
	      | 		     |	     the "-u" flag			 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |		     another_user		 |   |	 |
	      | 		     |						 |   |	 |
	      |    dbms_password     |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			string			 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |	     The  internal  database pass-	 |   |	 |
	      | 		     |	     word for the user	connecting	 |   |	 |
	      | 		     |	     to Ingres				 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			s3cr3t			 |   |	 |
	      | 		     |						 |   |	 |
	      |   table_structure    |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			string			 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |	   The	default  structure  for 	 |   |	 |
	      | 		     |	  new tables. Valid values  for 	 |   |	 |
	      | 		     |	  table_structure are:			 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			       oINGRES_STRUC-	 |   |	 |
	      | 		     |			       TURE_BTREE	 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			       oINGRES_STRUC-	 |   |	 |
	      | 		     |			       TURE_HASH	 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			       oINGRES_STRUC-	 |   |	 |
	      | 		     |			       TURE_HEAP	 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			       oINGRES_STRUC-	 |   |	 |
	      | 		     |			       TURE_ISAM	 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			       oINGRES_STRUC-	 |   |	 |
	      | 		     |			       TURE_CBTREE	 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			       oINGRES_STRUC-	 |   |	 |
	      | 		     |			       TURE_CISAM	 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			       oINGRES_STRUC-	 |   |	 |
	      | 		     |			       TURE_CHASH	 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			       oINGRES_STRUC-	 |   |	 |
	      | 		     |			       TURE_CHEAP	 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |		INGRES_STRUCTURE_BTREE		 |   |	 |
	      | 		     |						 |   |	 |
	      |   index_structure    |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			string			 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |	   The default structure for new sec-	 |   |	 |
	      | 		     |	  ondary indexes.  Valid  values  for	 |   |	 |
	      | 		     |	  index_structure are:			 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			       oINGRES_STRUC-	 |   |	 |
	      | 		     |			       TURE_CBTREE	 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			       oINGRES_STRUC-	 |   |	 |
	      | 		     |			       TURE_CISAM	 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			       oINGRES_STRUC-	 |   |	 |
	      | 		     |			       TURE_CHASH	 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			       oINGRES_STRUC-	 |   |	 |
	      | 		     |			       TURE_BTREE	 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			       oINGRES_STRUC-	 |   |	 |
	      | 		     |			       TURE_HASH	 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			       oINGRES_STRUC-	 |   |	 |
	      | 		     |			       TURE_ISAM	 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |		 INGRES_STRUCTURE_HASH		 |   |	 |
	      | 		     |						 |   |	 |
	      |     login_local      |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			boolean 		 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |	  Determines  how the connection user	 |   |	 |
	      | 		     |	  ID and password  are	used  when  a	 |   |	 |
	      | 		     |	  VNODE  is  included  in  the target	 |   |	 |
	      | 		     |	  database string. If  set  to	TRUE,	 |   |	 |
	      | 		     |	  the  user  ID and password are used	 |   |	 |
	      | 		     |	  to locally access  the  VNODE,  and	 |   |	 |
	      | 		     |	  the VNODE login information is used	 |   |	 |
	      | 		     |	  to establish the  DBMS  connection.	 |   |	 |
	      | 		     |	  If  set  to FALSE, the process user	 |   |	 |
	      | 		     |	  ID is used to access the VNODE, and	 |   |	 |
	      | 		     |	  the connection user ID and password	 |   |	 |
	      | 		     |	  are used  in	place  of  the	VNODE	 |   |	 |
	      | 		     |	  login  information to establish the	 |   |	 |
	      | 		     |	  DBMS connection. This parameter  is	 |   |	 |
	      | 		     |	  ignored  if no VNODE is included in	 |   |	 |
	      | 		     |	  the  target  database  string.  The	 |   |	 |
	      | 		     |	  default is FALSE.			 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			 TRUE			 |   |	 |
	      | 		     |						 |   |	 |
	      |      timezone	     |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			string			 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |	  Controls  the  timezone of the ses-	 |   |	 |
	      | 		     |	  sion. If not set it will default to	 |   |	 |
	      | 		     |	  the	value	defined  by  II_TIME-	 |   |	 |
	      | 		     |	  ZONE_NAME. If  II_TIMEZONE_NAME  is	 |   |	 |
	      | 		     |	  not defined, NA-PACIFIC (GMT-8 with	 |   |	 |
	      | 		     |	  Daylight Savings) is used.		 |   |	 |
	      | 		     |						 |   |	 |
	      |     date_format      |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			integer 		 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     | Sets the allowable input and output	 |   |	 |
	      | 		     | format  for  Ingres dates. Defaults	 |   |	 |
	      | 		     | to    the    value    defined	by	 |   |	 |
	      | 		     | II_DATE_FORMAT.	If  II_DATE_FORMAT	 |   |	 |
	      | 		     | is not set the default date  format	 |   |	 |
	      | 		     | is  US, e.g. mm/dd/yy. Valid values	 |   |	 |
	      | 		     | for date_format are:			 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			    oINGRES_DATE_DMY	 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			    oINGRES_DATE_FIN-	 |   |	 |
	      | 		     |			    ISH 		 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			    oINGRES_DATE_GER-	 |   |	 |
	      | 		     |			    MAN 		 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			    oINGRES_DATE_ISO	 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			    oINGRES_DATE_ISO4	 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			    oINGRES_DATE_MDY	 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			    oINGRES_DATE_MULTI-  |   |	 |
	      | 		     |			    NATIONAL		 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			    oINGRES_DATE_MULTI-  |   |	 |
	      | 		     |			    NATIONAL4		 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			    oINGRES_DATE_YMD	 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			    oINGRES_DATE_US	 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |	      INGRES_DATE_MULTINATIONAL4	 |   |	 |
	      | 		     |						 |   |	 |
	      |  decimal_separator   |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			string			 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     | The  character  identifier  for	decimal  |   |	 |
	      | 		     | data					 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			  ","			 |   |	 |
	      | 		     |						 |   |	 |
	      |     money_lort	     |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			integer 		 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     | Leading or trailing currency sign. Valid  |   |	 |
	      | 		     | values for money_lort are:		 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			    oINGRES_MONEY_LEAD-  |   |	 |
	      | 		     |			    ING 		 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			    oINGRES_MONEY_TRAIL- |   |	 |
	      | 		     |			    ING 		 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |		 INGRES_MONEY_TRAILING		 |   |	 |
	      | 		     |						 |   |	 |
	      |     money_sign	     |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			string			 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     | The currency symbol to be used  with  the |   |	 |
	      | 		     | MONEY datatype				 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			  EUR			 |   |	 |
	      | 		     |						 |   |	 |
	      |   money_precision    |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			integer 		 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |	  The precision of the MONEY datatype	 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			   3			 |   |	 |
	      | 		     |						 |   |	 |
	      |  float4_precision    |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			integer 		 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |	   Precision of the FLOAT4 datatype	 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			  10			 |   |	 |
	      | 		     |						 |   |	 |
	      |  float8_precision    |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			integer 		 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |	     Precision of the FLOAT8 data	 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			  10			 |   |	 |
	      | 		     |						 |   |	 |
	      | blob_segment_length  |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			integer 		 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     | The amount of data in bytes to fetch at a |   |	 |
	      | 		     | time when retrieving BLOB or  CLOB  data, |   |	 |
	      | 		     | defaults  to  4096 bytes when not explic- |   |	 |
	      | 		     | itly set 				 |   |	 |
	      | 		     |						 |   |	 |
	      | 		     |			 8192			 |   |	 |
	      | 		     |						 |   |	 |
	      +----------------------+-------------------------------------------+---+---+
RETURN VALUES

	Returns a Ingres link resource on success or FALSE on failure

EXAMPLES

       Example #1

	      Open a connection to an Ingres database

	      <?php
	      $link = ingres_connect("mydb", "user", "pass")
		  or die("Could not connect");
	      echo "Connected successfully";
	      ingres_close($link);
	      ?>

SEE ALSO

       ingres_pconnect(3), ingres_close(3).

PHP Documentation Group 													 INGRES_CONNECT(3)
All times are GMT -4. The time now is 02:27 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy