Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Variable Size Problem

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Variable Size Problem
# 1  
Old 09-17-2007
Variable Size Problem
Hello Everyone,

I am currently working with a DB2 (ver 8.1) table (Newly Created) and I am running a basic DB2 Select query into a variable. The field and it's size are VARCHAR(20). Since I need to pass the variable through some java I have noticed that when the results come back from the query there are extra spaces. Even if I use the RTRIM or LTRIM I still receive the spaces.

Is there a way to set a variable lenght before the results of a query are passed to it?

I would like to do the following,

Code:
variable1=`db2 -xn "length(rtrim(field1)) from Database"`
if (( variable1 == 16 ))
then
set $variable2 lenght to 16
fi
variable2=`db2 -xn "select LTRIM(RTRIM(field1)) from Database"`

Then I can pass $variable2 through the java.

I know it doesn't make much sense but it's what I need, hopefully.

thanks in advance...........Smilie
Last edited by Bob_Loblaw; 09-17-2007 at 04:36 PM..
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Large Variable content size caveats?

Hi, I wrote a shell script, which let me manage dns records through an api. The raw core-command looks like about this: output="$(curl -X GET https://mgt.myserver.de:8081/api/v1/servers/localhost/zones)"The output contains a list of all zones with all records and is about 800 Kilobytes... (9 Replies)
Discussion started by: stomp
9 Replies

2. Shell Programming and Scripting

Getting size of a variable

if i do the following: echo "hello, mr. sunshine" > /tmp/text.txt du -s /tmp/text.txt The text.txt file now contains "hello, mr. sunshine". So i did a du -s on the file to see how much space the text i inserted took. now, instead of writing "hello, mr. sunshine" to a text file on the... (5 Replies)
Discussion started by: SkySmart
5 Replies

3. UNIX for Advanced & Expert Users

size for sum variable limitation on awk

Hello first, truth been told, I'm not even close to be advanced user. I'm posting here because maybe my question is complicated enough to need your expert help I need to use awk (or nawk - I don't have gawk) to validate some files by computing the total sum for a large numeric variable. It... (1 Reply)
Discussion started by: cwitarsa
1 Replies

4. Shell Programming and Scripting

file size problem

Hi everyone can you people please help me in the problem below -bash-3.00$ ls -ltr abc abc.tar -rw-r--r-- 1 1hinaa2 17 Jan 17 14:09 abc -rw-r--r-- 1 1hinaa2 2048 Feb 17 07:03 abc.tar -rw-r--r-- 1 1hinaa2 135 Feb 17 07:03 abc.tar.gz why this strange... (2 Replies)
Discussion started by: aishsimplesweet
2 Replies

5. UNIX for Dummies Questions & Answers

File size problem

I'm working on a IBM PC Serveur 325. I have a sequential file with more than 800000 records. The size of that file is 136755200. I wrote a cobol program (RM cobol) to delete records. Now the file has 180000 records and the size still the same 136755200. What I need to do to decrease the size.... (3 Replies)
Discussion started by: royinfo
3 Replies

6. SCO

File size problem

I'm working on a IBM PC Serveur 325. I have a sequential file with more than 800000 records. The size of that file is 136755200. I wrote a cobol program (RM cobol) to delete records. Now the file has 180000 records and the size still the same 136755200. What I need to do to decrease the size.... (1 Reply)
Discussion started by: royinfo
1 Replies

7. UNIX for Dummies Questions & Answers

size of number variable in unix (awk)

Hi All, M writing a shell scripting n making use of awk. I am using a integer variable named size. When printing it's value, it is giving result as 4.34534e+10. Is there any way to declare variable of type LONG in awk or in shell scripting in general ? Regards, Abhishek Gera (3 Replies)
Discussion started by: AbhishekG
3 Replies

8. AIX

dev/rmt 0.1 block size is 0; variable; must be 1024 fixed.

Hi. After the shutdown for SWIFT Alliance Server, tape backup process will be done. Unfortunately, I encountered this error message when I performed the database tape backup. The error was "/dev/rmt 0.1 block size is 0; variable; must be 1024 fixed. Consider reconfiguration through 'chdev'... (2 Replies)
Discussion started by: MariaLuisa
2 Replies

9. AIX

Variable Testing for size

How do you test a variable size to know if it is empty or not? Thanks (4 Replies)
Discussion started by: jango
4 Replies

10. Shell Programming and Scripting

Max size of variable

What is the maximum amount of characters that you can have in a varible name in the ksh shell? (1 Reply)
Discussion started by: lesstjm
1 Replies
Login or Register to Ask a Question

LEARN ABOUT PHP

db2_client_info

DB2_CLIENT_INFO(3)							 1							DB2_CLIENT_INFO(3)

db2_client_info - Returns an object with properties that describe the DB2 database client

SYNOPSIS

       object db2_client_info (resource  $connection)

DESCRIPTION

	This function returns an object with read-only properties that return information about the DB2 database client. The following table lists
       the DB2 client properties:

       DB2 client properties

       +---------------------+--------------------------------------+---+
       |   Property name     |					    |	|
       |		     |					    |	|
       |		     |		   Return type		    |	|
       |		     |					    |	|
       |		     |		   Description		    |	|
       |		     |					    |	|
       +---------------------+--------------------------------------+---+
       |   APPL_CODEPAGE     |					    |	|
       |		     |					    |	|
       |		     |		       int		    |	|
       |		     |					    |	|
       |		     |	    The application code page.	    |	|
       |		     |					    |	|
       |   CONN_CODEPAGE     |					    |	|
       |		     |					    |	|
       |		     |		       int		    |	|
       |		     |					    |	|
       |		     | The code page for the  current  con- |	|
       |		     | nection. 			    |	|
       |		     |					    |	|
       |  DATA_SOURCE_NAME   |					    |	|
       |		     |					    |	|
       |		     |		      string		    |	|
       |		     |					    |	|
       |		     | The  data  source name (DSN) used to |	|
       |		     | create the current connection to the |	|
       |		     | database.			    |	|
       |		     |					    |	|
       |    DRIVER_NAME      |					    |	|
       |		     |					    |	|
       |		     |		      string		    |	|
       |		     |					    |	|
       |		     | The  name of the library that imple- |	|
       |		     | ments the DB2 Call  Level  Interface |	|
       |		     | (CLI) specification.		    |	|
       |		     |					    |	|
       |  DRIVER_ODBC_VER    |					    |	|
       |		     |					    |	|
       |		     |		      string		    |	|
       |		     |					    |	|
       |		     | The  version  of  ODBC  that the DB2 |	|
       |		     | client  supports.  This	returns   a |	|
       |		     | string  "MM.mm"	where  $MM  is	the |	|
       |		     | major version and $mm is  the  minor |	|
       |		     | version.   The	DB2  client  always |	|
       |		     | returns "03.51". 		    |	|
       |		     |					    |	|
       |     DRIVER_VER      |					    |	|
       |		     |					    |	|
       |		     |		      string		    |	|
       |		     |					    |	|
       |		     | The version of the  client,  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  version  8, minor |	|
       |		     | version 2, update 1.		    |	|
       |		     |					    |	|
       |ODBC_SQL_CONFORMANCE |					    |	|
       |		     |					    |	|
       |		     |		      string		    |	|
       |		     |					    |	|
       |		     | The level of ODBC SQL  grammar  sup- |	|
       |		     | ported by the client:		    |	|
       |		     |					    |	|
       |		     |		     o MINIMUM		    |	|
       |		     |		       - Supports the mini- |	|
       |		     |		       mum ODBC  SQL  gram- |	|
       |		     |		       mar.		    |	|
       |		     |					    |	|
       |		     |		     o CORE		    |	|
       |		     |		       -  Supports the core |	|
       |		     |		       ODBC SQL grammar.    |	|
       |		     |					    |	|
       |		     |		     o EXTENDED 	    |	|
       |		     |		       - Supports  extended |	|
       |		     |		       ODBC SQL grammar.    |	|
       |		     |					    |	|
       |      ODBC_VER	     |					    |	|
       |		     |					    |	|
       |		     |		      string		    |	|
       |		     |					    |	|
       |		     | The  version  of  ODBC that the ODBC |	|
       |		     | driver	manager   supports.    This |	|
       |		     | returns	a string "MM.mm.rrrr" where |	|
       |		     | $MM is the major version, $mm is the |	|
       |		     | minor  version,	and  $rrrr  is	the |	|
       |		     | release.  The  DB2   client   always |	|
       |		     | returns "03.01.0000".		    |	|
       |		     |					    |	|
       +---------------------+--------------------------------------+---+
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_client_info(3) example

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

	      <?php
	      $conn = db2_connect( 'SAMPLE', 'db2inst1', 'ibmdb2' );
	      $client = db2_client_info( $conn );

	      if ($client) {
		  echo "DRIVER_NAME: "; 	  var_dump( $client->DRIVER_NAME );
		  echo "DRIVER_VER: ";		  var_dump( $client->DRIVER_VER );
		  echo "DATA_SOURCE_NAME: ";	  var_dump( $client->DATA_SOURCE_NAME );
		  echo "DRIVER_ODBC_VER: ";	  var_dump( $client->DRIVER_ODBC_VER );
		  echo "ODBC_VER: ";		  var_dump( $client->ODBC_VER );
		  echo "ODBC_SQL_CONFORMANCE: ";  var_dump( $client->ODBC_SQL_CONFORMANCE );
		  echo "APPL_CODEPAGE: ";	  var_dump( $client->APPL_CODEPAGE );
		  echo "CONN_CODEPAGE: ";	  var_dump( $client->CONN_CODEPAGE );
	      }
	      else {
		  echo "Error retrieving client information.
		   Perhaps your database connection was invalid.";
	      }
	      db2_close($conn);

	      ?>

	      The above example will output:

	      DRIVER_NAME: string(8) "libdb2.a"
	      DRIVER_VER: string(10) "08.02.0001"
	      DATA_SOURCE_NAME: string(6) "SAMPLE"
	      DRIVER_ODBC_VER: string(5) "03.51"
	      ODBC_VER: string(10) "03.01.0000"
	      ODBC_SQL_CONFORMANCE: string(8) "EXTENDED"
	      APPL_CODEPAGE: int(819)
	      CONN_CODEPAGE: int(819)

SEE ALSO

       db2_server_info(3).

PHP Documentation Group 													DB2_CLIENT_INFO(3)