Variable Size Problem


 
Thread Tools Search this Thread
# 1  
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
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