Using TRIM Utilities
During my port to DB2 I get the following message
from trimrun: ERROR: Unique buffer length exceeded.
DB2 does not have a unique row identifier such as ROWID in Oracle. To uniquely
identify the row, we build a "primary key" using all the DBMS fields with
the UNIQUE attribute. In this case, the buffer used to build the where clause
is too small. Check the number of fields to which you've assigned the UNIQUE
I can't create a DVapp (.gap) on trim_dict_table with the following steps:
1. Define window.
2. In the table field enter "TRIM_DICT_TABLE"
3. Choose "Default"
You must use lower case trim_dict_table with Informix. We had to keep
case sensitivity for Sybase.
How can I get my old code to compile correctly using the current
trim.h that was sent to me for the new version? Do I have to combine
the two trim.h files?
Copy the contents of your VAX $TRIM_HOME:[lib] directory to your $TRIM_HOME/lib
directory on your DEC UNIX box.
What are .mir files ?
trimgen has two output options: .run (machine specific) or .mir (ascii
portable) If you are in a multi-system enviroment, .mir files give you
control over your .app and .rep files. You can keep them in one place
instead of having to distribute them to all the different machine types
to do trimgen. By doing
trimgen xyz.app -i
copy the .mir file to another system
gives you a .run file for that system.
In the $TRIM_HOME/term directory there are .key, .key7, .key8 files.
What is the difference between each of these?
.key is most likely 8-bit as is .key8; .key7 is 7-bit.
Is it necessary to use a specific terminal and/or key
mapping, that 8-bit national characters are supported. Is there a
command line parameter, an enviroment variable or anything else?
And which are the right settings to use?
What is your TERM environment variable set to? There are some 8-bit character
key mappings in the $TRIM_HOME/term directory. For example, if TERM is set
to vt220 and you want to use the 8-bit definition file, copy vt220.key8 to
vt220.key. There is a getkey64 program in the $TRIM_HOME/bin directory that
will build a new key definition file for you.
When our users try executing trimrun.ora they see a message saying
that "error message : 3 is not available".
It looks like a problem with privileges, since it is not displayed when
I run that executable. Can you tell me what I need to do to allow other
users to run?
The $TRIM_HOME/lib/trim.msg file must be r everyone. You need to
chmod gou+r $TRIM_HOME/lib/trim.msg. In addition, the directories in the
$TRIM_HOME/lib path must all have r everyone.
I want to offload some data in a table because it is getting extremely
large ( > 1000000 rows). I want to be able to load the data back into
the table at any time.
Use list_file() with the binary option. Then when you want to put the data
back in the DBMS,
ll = list_open("myfile",10000000);
exec_sql("insert into mytable values(:1,:2,:3)",ll);
Is there a TRIMpl function that lets me obtain the width of a
particular column in a list?
list columns are not fixed width. In fact, different rows can have different
datatypes in the same column. For example, row 0 col0 could have the value
"moose" whereas row1 col0 has the number 1234.22455.
How do I save the fonts I've chosen?
Use the TRIMpl function winprop() to bring up the font window.
Save the font using Save menu item.
I have a problem with getkey since the key configuration generated
for my vt220 emulator gives an incorrectly drawn map.
With emulators, it is sometimes difficult to get the keys you want to work since
the emulator software may be trapping functions keys locally. Try a backslash
(\) as a prefix to "escape" the keys that are causing you a problem.
Updated 6 Sep 2011.