UNIX for Dummies Questions & Answers

Variable Size Problem

 
Thread Tools Search this Thread
# 1  
Old
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 05:36 PM..
 

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #457
Difficulty: Easy
NTP was created to synchronize all participating computers to within a few milliseconds of Coordinated Universal Time (UTC).
True or False?

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. Shell Programming and Scripting

file size problem

Hi Everyone I am having very strange problem I want to know if i do ls -ltr then the file size it return will always be in bytes or it could be different in different scenario. or is there any command which will return the size of file in only one unit. Please help... (8 Replies)
Discussion started by: aishsimplesweet
8 Replies

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

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

LEARN ABOUT DEBIAN

deb-substvars

deb-substvars(5)						  dpkg utilities						  deb-substvars(5)

NAME

       deb-substvars - Debian source substitution variables

SYNOPSIS

       substvars

DESCRIPTION

       Before  dpkg-source,  dpkg-gencontrol  and dpkg-genchanges write their control information (to the source control file .dsc for dpkg-source
       and to standard output for dpkg-gencontrol and dpkg-genchanges) they perform some variable substitutions on the output file.

       A variable substitution has the form ${variable-name}.  Variable names consist of alphanumerics, hyphens  and  colons  and  start  with	an
       alphanumeric.  Variable	substitutions  are  performed repeatedly until none are left; the full text of the field after the substitution is
       rescanned to look for more substitutions.

       After all the substitutions have been done each occurrence of the string ${} (which is not a legal substitution) is replaced with a $ sign.

       While variable substitution is done on all control fields, some of those fields are used and needed during the build when the  substitution
       did not yet occur. That's why you can't use variables in the Package, Source and Architecture fields.

       Variable substitution happens on the content of the fields after they have been parsed, thus if you want a variable to expand over multiple
       lines you do not have to include a space after the newline. This is done implicitly when the field is output. For example, if the  variable
       ${Description} is set to "foo is bar.${Newline}foo is great." and if you have the following field:

	Description: foo application
	 ${Description}
	 .
	 More text.

       It will result in:

	Description: foo application
	 foo is bar.
	 foo is great.
	 .
	 More text.

       Variables  can be set using the -V common option. They can be also specified in the file debian/substvars (or whatever other file is speci-
       fied using the -T option). This file consists of lines of the form name=value.  Trailing whitespace on each line, blank	lines,	and  lines
       starting with a # symbol (comments) are ignored.

       Additionally, the following standard variables are available:

       Arch   The current build architecture (from dpkg --print-architecture).

       source:Version
	      The source package version.

       source:Upstream-Version
	      The upstream source package version, including the Debian version epoch if any.

       binary:Version
	      The binary package version (which may differ from source:Version in a binNMU for example).

       Source-Version
	      The source package version (from the changelog file). This variable is now deprecated as its meaning is different from its function,
	      please use the source:Version or binary:Version as appropriate.

       Installed-Size
	      The total size of the package's installed files. This value is copied into the corresponding control file  field;  setting  it  will
	      modify the value of that field. If this variable isn't set dpkg-gencontrol will use du -k debian/tmp to find the default value.

       Extra-Size
	      Additional  disk	space used when the package is installed. If this variable is set its value is added to that of the Installed-Size
	      variable (whether set explicitly or using the default value) before it is copied into the Installed-Size control file field.

       F:fieldname
	      The value of the output field fieldname (which must be given in the canonical capitalisation). Setting these variables has no effect
	      other than on places where they are expanded explicitly.

       Format The .changes file format version generated by this version of the source packaging scripts. If you set this variable the contents of
	      the Format field in the .changes file will change too.

       Newline, Space, Tab
	      These variables each hold the corresponding character.

       shlibs:dependencyfield
	      Variable settings with names of this form are generated by dpkg-shlibdeps.

       dpkg:Upstream-Version
	      The upstream version of dpkg.

       dpkg:Version
	      The full version of dpkg.

       If a variable is referred to but not defined it generates a warning and an empty value is assumed.

FILES

       debian/substvars
	      List of substitution variables and values.

BUGS

       The point at which field overriding occurs compared to certain standard output field settings is rather confused.

SEE ALSO

       dpkg(1), dpkg-genchanges(1), dpkg-gencontrol(1), dpkg-shlibdeps(1), dpkg-source(1).

Debian Project							    2009-07-15							  deb-substvars(5)

Featured Tech Videos