Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to Pull out multiple files from DB table and redirect all those files to a differetn directory?
Top Forums Shell Programming and Scripting How to Pull out multiple files from DB table and redirect all those files to a differetn directory? Post 302373545 by ss3944 on Friday 20th of November 2009 04:40:22 PM
Old 11-20-2009
Thanks for ur reply Jim..

I ve got DB2 database
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Redirect output to multiple files.

Hi, I am new to shell scripting and have a question. I would like to redirect the output of a command to multiple files, each file holding the exact same copy. From what I read from the bash manpage and from some searching it seems it cannot be done within the shell except setting up a loop. Is... (3 Replies)
Discussion started by: cbkihong
3 Replies

2. UNIX for Dummies Questions & Answers

can you redirect multiple files for input?

I have a program that is reading strings into a vector from a file. Currently I am using this command: a.out < file1 The program runs and prints the contents of the vector to the screen, like its supposed to. The problem is that it needs to read in 3 files to fill the vector. Is there anyway... (4 Replies)
Discussion started by: Matrix_Prime
4 Replies

3. Shell Programming and Scripting

redirect files to a directory

i have some 2000 files and i want to redirect it to a dir after i give the command find . -mtime -15 -print it gives some 2000 files file1.DAT file2.DAT : : : file2000.DAT ------------------------------------------------------------------------how to redirect all these 2000 files... (2 Replies)
Discussion started by: ali560045
2 Replies

4. Shell Programming and Scripting

How to redirect the output to multiple files without putting on console

How to redirect the output to multiple files without putting on console I tried tee but it writes to STDOUT , which I do not want. Test.sh ------------------ #!/bin/ksh echo "Hello " tee -a file1 file2 ---------------------------- $>./Test.sh $> Expected output: -------------------... (2 Replies)
Discussion started by: prashant43
2 Replies

5. Shell Programming and Scripting

how to redirect multiple input files?

I have a program that runs like "cat f1 - f2 -", I need to write shell script to run the program whose standard input will be redirected from 2 files. I spend a whole day on it, but didn't figure out. Can someone help me out? Thanks! (8 Replies)
Discussion started by: microstarwwx
8 Replies

6. UNIX for Dummies Questions & Answers

Redirect stdin stdout to multiple files

Hi, i know how to a) redirect stdout and stderr to one file, b) and write to two files concurrently with same output using tee command Now, i want to do both the above together. I have a script and it should write both stdout and stderr in one file and also write the same content to... (8 Replies)
Discussion started by: ysrini
8 Replies

7. Shell Programming and Scripting

find string from multiple dir and redirect to new files

Hi, I am new to script and I want find one string from multiple files in diff directories and put that out put to new file. Like I have A,B & C directories and each has multiple files but one file is unic in all the directories like COMM.txt Now I want write script to find the string... (8 Replies)
Discussion started by: Mahessh123
8 Replies

8. UNIX for Dummies Questions & Answers

Reading Table name from a list of files in a Directory

Hi , I have searched through the forum but not able to find out any help :( i have a directory having lot of files which contains sql statemtns eg : file 1 contains select from table_name1 where ..................... select from table_name2 where .......... select from ... (3 Replies)
Discussion started by: Trendz
3 Replies

9. Shell Programming and Scripting

How do I use grep to pull incremental data and send to multiple files?

Hi Everyone, Im currently using the below code to pull data from a large CSV file and put it into smaller files with just the data associated with the number that I "grep". grep 'M053' test.csv > test053.csv Is there a way that I can use grep to run through my file like the example below... (6 Replies)
Discussion started by: TheStruggle
6 Replies

10. 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... (0 Replies)
Discussion started by: reshma15193
0 Replies

LEARN ABOUT PHP

db2_server_info

DB2_SERVER_INFO(3)							 1							DB2_SERVER_INFO(3)

db2_server_info - Returns an object with properties that describe the DB2 database server

SYNOPSIS

       object db2_server_info (resource  $connection)

DESCRIPTION

	This  function returns an object with read-only properties that return information about the IBM DB2, Cloudscape, or Apache Derby database
       server. The following table lists the database server properties:

       Database server properties

       +----------------------+--------------------------------------+---+
       |    Property name     | 				     |	 |
       |		      | 				     |	 |
       |		      | 	    Return type 	     |	 |
       |		      | 				     |	 |
       |		      | 	    Description 	     |	 |
       |		      | 				     |	 |
       +----------------------+--------------------------------------+---+
       |      DBMS_NAME       | 				     |	 |
       |		      | 				     |	 |
       |		      | 	       string		     |	 |
       |		      | 				     |	 |
       |		      | The name of the database  server  to |	 |
       |		      | which  you  are  connected.  For DB2 |	 |
       |		      | servers this is a combination of DB2 |	 |
       |		      | followed  by the operating system on |	 |
       |		      | which the database  server  is	run- |	 |
       |		      | ning.				     |	 |
       |		      | 				     |	 |
       |      DBMS_VER	      | 				     |	 |
       |		      | 				     |	 |
       |		      | 	       string		     |	 |
       |		      | 				     |	 |
       |		      | The  version of the database server, |	 |
       |		      | in the form of a string "MM.mm.uuuu" |	 |
       |		      | where  $MM is the major version, $mm |	 |
       |		      | is the minor version, and  $uuuu  is |	 |
       |		      | the	update.     For     example, |	 |
       |		      | "08.02.0001" represents  major	ver- |	 |
       |		      | sion 8, minor version 2, update 1.   |	 |
       |		      | 				     |	 |
       |     DB_CODEPAGE      | 				     |	 |
       |		      | 				     |	 |
       |		      | 		int		     |	 |
       |		      | 				     |	 |
       |		      | The  code  page  of  the database to |	 |
       |		      | which you are connected.	     |	 |
       |		      | 				     |	 |
       |       DB_NAME	      | 				     |	 |
       |		      | 				     |	 |
       |		      | 	       string		     |	 |
       |		      | 				     |	 |
       |		      | The name of the  database  to  which |	 |
       |		      | you are connected.		     |	 |
       |		      | 				     |	 |
       |    DFT_ISOLATION     | 				     |	 |
       |		      | 				     |	 |
       |		      | 	       string		     |	 |
       |		      | 				     |	 |
       |		      | The  default  transaction  isolation |	 |
       |		      | level supported by the server:	     |	 |
       |		      | 				     |	 |
       |		      | 	      o UR		     |	 |
       |		      | 		- Uncommitted  read: |	 |
       |		      | 		changes  are immedi- |	 |
       |		      | 		ately visible by all |	 |
       |		      | 		concurrent  transac- |	 |
       |		      | 		tions.		     |	 |
       |		      | 				     |	 |
       |		      | 	      o CS		     |	 |
       |		      | 		- Cursor  stability: |	 |
       |		      | 		a  row	read  by one |	 |
       |		      | 		transaction  can  be |	 |
       |		      | 		altered  and commit- |	 |
       |		      | 		ted by a second con- |	 |
       |		      | 		current transaction. |	 |
       |		      | 				     |	 |
       |		      | 	      o RS		     |	 |
       |		      | 		-  Read stability: a |	 |
       |		      | 		transaction can  add |	 |
       |		      | 		or    remove	rows |	 |
       |		      | 		matching  a   search |	 |
       |		      | 		condition or a pend- |	 |
       |		      | 		ing transaction.     |	 |
       |		      | 				     |	 |
       |		      | 	      o RR		     |	 |
       |		      | 		-  Repeatable  read: |	 |
       |		      | 		data   affected   by |	 |
       |		      | 		pending  transaction |	 |
       |		      | 		is  not available to |	 |
       |		      | 		other transactions.  |	 |
       |		      | 				     |	 |
       |		      | 	      o NC		     |	 |
       |		      | 		-  No  commit:	 any |	 |
       |		      | 		changes  are visible |	 |
       |		      | 		at the end of a suc- |	 |
       |		      | 		cessful   operation. |	 |
       |		      | 		Explicit commits and |	 |
       |		      | 		rollbacks   are  not |	 |
       |		      | 		allowed.	     |	 |
       |		      | 				     |	 |
       |IDENTIFIER_QUOTE_CHAR | 				     |	 |
       |		      | 				     |	 |
       |		      | 	       string		     |	 |
       |		      | 				     |	 |
       |		      | The character  used  to  delimit  an |	 |
       |		      | identifier.			     |	 |
       |		      | 				     |	 |
       |      INST_NAME       | 				     |	 |
       |		      | 				     |	 |
       |		      | 	       string		     |	 |
       |		      | 				     |	 |
       |		      | The  instance on the database server |	 |
       |		      | that contains the database.	     |	 |
       |		      | 				     |	 |
       |  ISOLATION_OPTION    | 				     |	 |
       |		      | 				     |	 |
       |		      | 	       array		     |	 |
       |		      | 				     |	 |
       |		      | An array of  the  isolation  options |	 |
       |		      | supported  by  the  database server. |	 |
       |		      | The isolation options are  described |	 |
       |		      | in the DFT_ISOLATION property.	     |	 |
       |		      | 				     |	 |
       |      KEYWORDS	      | 				     |	 |
       |		      | 				     |	 |
       |		      | 	       array		     |	 |
       |		      | 				     |	 |
       |		      | An array of the keywords reserved by |	 |
       |		      | the database server.		     |	 |
       |		      | 				     |	 |
       | LIKE_ESCAPE_CLAUSE   | 				     |	 |
       |		      | 				     |	 |
       |		      | 		bool		     |	 |
       |		      | 				     |	 |
       |		      | 				     |	 |
       |		      | TRUE if the database server supports |	 |
       |		      | the  use of % and _ wildcard charac- |	 |
       |		      | ters.  FALSE if the database  server |	 |
       |		      | does   not  support  these  wildcard |	 |
       |		      | characters.			     |	 |
       |		      | 				     |	 |
       |  MAX_COL_NAME_LEN    | 				     |	 |
       |		      | 				     |	 |
       |		      | 		int		     |	 |
       |		      | 				     |	 |
       |		      | Maximum length of a column name sup- |	 |
       |		      | ported	 by   the  database  server, |	 |
       |		      | expressed in bytes.		     |	 |
       |		      | 				     |	 |
       | MAX_IDENTIFIER_LEN   | 				     |	 |
       |		      | 				     |	 |
       |		      | 		int		     |	 |
       |		      | 				     |	 |
       |		      | Maximum length of an SQL  identifier |	 |
       |		      | supported  by  the  database server, |	 |
       |		      | expressed in characters.	     |	 |
       |		      | 				     |	 |
       |   MAX_INDEX_SIZE     | 				     |	 |
       |		      | 				     |	 |
       |		      | 		int		     |	 |
       |		      | 				     |	 |
       |		      | Maximum size of columns combined  in |	 |
       |		      | an  index  supported by the database |	 |
       |		      | server, expressed in bytes.	     |	 |
       |		      | 				     |	 |
       |  MAX_PROC_NAME_LEN   | 				     |	 |
       |		      | 				     |	 |
       |		      | 		int		     |	 |
       |		      | 				     |	 |
       |		      | Maximum length of a  procedure	name |	 |
       |		      | supported  by  the  database server, |	 |
       |		      | expressed in bytes.		     |	 |
       |		      | 				     |	 |
       |    MAX_ROW_SIZE      | 				     |	 |
       |		      | 				     |	 |
       |		      | 		int		     |	 |
       |		      | 				     |	 |
       |		      | Maximum length of a row  in  a	base |	 |
       |		      | table	supported  by  the  database |	 |
       |		      | server, expressed in bytes.	     |	 |
       |		      | 				     |	 |
       | MAX_SCHEMA_NAME_LEN  | 				     |	 |
       |		      | 				     |	 |
       |		      | 		int		     |	 |
       |		      | 				     |	 |
       |		      | Maximum length of a schema name sup- |	 |
       |		      | ported	 by   the  database  server, |	 |
       |		      | expressed in bytes.		     |	 |
       |		      | 				     |	 |
       |  MAX_STATEMENT_LEN   | 				     |	 |
       |		      | 				     |	 |
       |		      | 		int		     |	 |
       |		      | 				     |	 |
       |		      | Maximum length of an  SQL  statement |	 |
       |		      | supported  by  the  database server, |	 |
       |		      | expressed in bytes.		     |	 |
       |		      | 				     |	 |
       | MAX_TABLE_NAME_LEN   | 				     |	 |
       |		      | 				     |	 |
       |		      | 		int		     |	 |
       |		      | 				     |	 |
       |		      | Maximum length of a table name	sup- |	 |
       |		      | ported	 by   the  database  server, |	 |
       |		      | expressed in bytes.		     |	 |
       |		      | 				     |	 |
       |NON_NULLABLE_COLUMNS  | 				     |	 |
       |		      | 				     |	 |
       |		      | 		bool		     |	 |
       |		      | 				     |	 |
       |		      | 				     |	 |
       |		      | TRUE if the database server supports |	 |
       |		      | columns  that  can be defined as NOT |	 |
       |		      | NULL, FALSE if the  database  server |	 |
       |		      | does  not support columns defined as |	 |
       |		      | NOT NULL.			     |	 |
       |		      | 				     |	 |
       |     PROCEDURES       | 				     |	 |
       |		      | 				     |	 |
       |		      | 		bool		     |	 |
       |		      | 				     |	 |
       |		      | 				     |	 |
       |		      | TRUE if the database server supports |	 |
       |		      | the  use  of  the  CALL statement to |	 |
       |		      | call stored procedures, FALSE if the |	 |
       |		      | database server does not support the |	 |
       |		      | CALL statement. 		     |	 |
       |		      | 				     |	 |
       |    SPECIAL_CHARS     | 				     |	 |
       |		      | 				     |	 |
       |		      | 	       string		     |	 |
       |		      | 				     |	 |
       |		      | A string containing all of the char- |	 |
       |		      | acters	other  than  a-Z,  0-9,  and |	 |
       |		      | underscore that can be	used  in  an |	 |
       |		      | identifier name.		     |	 |
       |		      | 				     |	 |
       |   SQL_CONFORMANCE    | 				     |	 |
       |		      | 				     |	 |
       |		      | 	       string		     |	 |
       |		      | 				     |	 |
       |		      | The  level  of	conformance  to  the |	 |
       |		      | ANSI/ISO    SQL-92     specification |	 |
       |		      | offered by the database server:      |	 |
       |		      | 				     |	 |
       |		      | 	      o ENTRY		     |	 |
       |		      | 		- Entry-level SQL-92 |	 |
       |		      | 		compliance.	     |	 |
       |		      | 				     |	 |
       |		      | 	      o FIPS127 	     |	 |
       |		      | 		- FIPS-127-2 transi- |	 |
       |		      | 		tional compliance.   |	 |
       |		      | 				     |	 |
       |		      | 	      o FULL		     |	 |
       |		      | 		-  Full level SQL-92 |	 |
       |		      | 		compliance.	     |	 |
       |		      | 				     |	 |
       |		      | 	      o INTERMEDIATE	     |	 |
       |		      | 		- Intermediate level |	 |
       |		      | 		SQL-92 compliance.   |	 |
       |		      | 				     |	 |
       +----------------------+--------------------------------------+---+
PARAMETERS

	      o $connection
		- Specifies an active DB2 client connection.

RETURN VALUES

	Returns an object on a successful call. Returns FALSE on failure.

EXAMPLES

       Example #1

	      A db2_server_info(3) example

	       To retrieve information about the server, you must pass a valid database connection resource to db2_server_info(3).

	      <?php

	      $conn = db2_connect('sample', 'db2inst1', 'ibmdb2');

	      $server = db2_server_info( $conn );

	      if ($server) {
		  echo "DBMS_NAME: ";		      var_dump( $server->DBMS_NAME );
		  echo "DBMS_VER: ";		      var_dump( $server->DBMS_VER );
		  echo "DB_CODEPAGE: "; 	      var_dump( $server->DB_CODEPAGE );
		  echo "DB_NAME: ";		      var_dump( $server->DB_NAME );
		  echo "INST_NAME: ";		      var_dump( $server->INST_NAME );
		  echo "SPECIAL_CHARS: ";	      var_dump( $server->SPECIAL_CHARS );
		  echo "KEYWORDS: ";		      var_dump( sizeof($server->KEYWORDS) );
		  echo "DFT_ISOLATION: ";	      var_dump( $server->DFT_ISOLATION );
		  echo "ISOLATION_OPTION: ";
		  $il = '';
		  foreach( $server->ISOLATION_OPTION as $opt )
		  {
		     $il .= $opt." ";
		  }
		  var_dump( $il );
		  echo "SQL_CONFORMANCE: ";	      var_dump( $server->SQL_CONFORMANCE );
		  echo "PROCEDURES: ";		      var_dump( $server->PROCEDURES );
		  echo "IDENTIFIER_QUOTE_CHAR: ";     var_dump( $server->IDENTIFIER_QUOTE_CHAR );
		  echo "LIKE_ESCAPE_CLAUSE: ";	      var_dump( $server->LIKE_ESCAPE_CLAUSE );
		  echo "MAX_COL_NAME_LEN: ";	      var_dump( $server->MAX_COL_NAME_LEN );
		  echo "MAX_ROW_SIZE: ";	      var_dump( $server->MAX_ROW_SIZE );
		  echo "MAX_IDENTIFIER_LEN: ";	      var_dump( $server->MAX_IDENTIFIER_LEN );
		  echo "MAX_INDEX_SIZE: ";	      var_dump( $server->MAX_INDEX_SIZE );
		  echo "MAX_PROC_NAME_LEN: ";	      var_dump( $server->MAX_PROC_NAME_LEN );
		  echo "MAX_SCHEMA_NAME_LEN: ";       var_dump( $server->MAX_SCHEMA_NAME_LEN );
		  echo "MAX_STATEMENT_LEN: ";	      var_dump( $server->MAX_STATEMENT_LEN );
		  echo "MAX_TABLE_NAME_LEN: ";	      var_dump( $server->MAX_TABLE_NAME_LEN );
		  echo "NON_NULLABLE_COLUMNS: ";      var_dump( $server->NON_NULLABLE_COLUMNS );

		  db2_close($conn);
	      }
	      ?>

	      The above example will output:

	      DBMS_NAME: string(9) "DB2/LINUX"
	      DBMS_VER: string(10) "08.02.0000"
	      DB_CODEPAGE: int(1208)
	      DB_NAME: string(6) "SAMPLE"
	      INST_NAME: string(8) "db2inst1"
	      SPECIAL_CHARS: string(2) "@#"
	      KEYWORDS: int(179)
	      DFT_ISOLATION: string(2) "CS"
	      ISOLATION_OPTION: string(12) "UR CS RS RR "
	      SQL_CONFORMANCE: string(7) "FIPS127"
	      PROCEDURES: bool(true)
	      IDENTIFIER_QUOTE_CHAR: string(1) """
	      LIKE_ESCAPE_CLAUSE: bool(true)
	      MAX_COL_NAME_LEN: int(30)
	      MAX_ROW_SIZE: int(32677)
	      MAX_IDENTIFIER_LEN: int(18)
	      MAX_INDEX_SIZE: int(1024)
	      MAX_PROC_NAME_LEN: int(128)
	      MAX_SCHEMA_NAME_LEN: int(30)
	      MAX_STATEMENT_LEN: int(2097152)
	      MAX_TABLE_NAME_LEN: int(128)
	      NON_NULLABLE_COLUMNS: bool(true)

SEE ALSO

       db2_client_info(3).

PHP Documentation Group 													DB2_SERVER_INFO(3)
All times are GMT -4. The time now is 07:55 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy