Variable Size Problem - The UNIX and Linux Forums

		The UNIX and Linux Forums > Top Forums > UNIX for Dummies Questions & Answers
Variable Size Problem

google unix.com

UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
dev/rmt 0.1 block size is 0; variable; must be 1024 fixed.	MariaLuisa	AIX	2	12-08-2006 04:27 AM
ftp UnixWare File Size Problem	Niraj Gopal Sha	Shell Programming and Scripting	1	06-18-2005 08:29 AM
Variable Testing for size	jango	AIX	4	08-19-2004 11:46 AM
Max size of variable	lesstjm	Shell Programming and Scripting	1	09-27-2002 10:16 AM


	Powered by

LinkBack

Thread Tools

Search this Thread

Rate Thread

Display Modes

#1 (permalink)

09-17-2007

Bob_Loblaw Bob_Loblaw is offline

Registered User

Join Date: Sep 2007

Posts: 7

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...........

Last edited by Bob_Loblaw; 09-17-2007 at 04:36 PM..

Bookmarks

« Grep a line with between 3 and 5 digits | Problem in incrementin a variable in UNIX shell script »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

All times are GMT -4. The time now is 09:25 AM.