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

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

     trimmir xyz.mir

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,

{
list ll;
ll = list_open("myfile",10000000);
commit(update);
exec_sql("insert into mytable values(:1,:2,:3)",ll);
commit();
}

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.

© 1985-2020 Updated 6 Sep 2011.