Trifox, Inc. -- Database Access Experts

TRIMtools FAQ

Can I put the driver and the connect_string in an .ini file like the network_string? Currently I call TRIMqmr like this -- c:\trimqmr net:orausr/orapwd.

No.

How can I overcome TRIMqmr batch print limitations? I set the output file dynamically with the SET PRINTER option, but the the printer string is limited to 30 characters. Also, can't I use "-" in the file name?

We are looking into the printer issues that you note and will make an update when we develop a solution to cover these issues.

Is there a runtime version for Unix we can use for batch processing?

Yes.

We have TRIMqmr ver 1.0.28.8, will it work with all versions of HPUX?

Yes, there is no inherent reason why it would not work.

I installed TRIMqmr but I'm not able to restore the correct user/group. Which user should be the owner ot the installation, (root?).

root is fine but you should probably use user bin, group bin.

If I try to call TRIMqmr with the option -k, it doesn't accept my command.

The key record files are created by trimqmr -ofile and are in binary format.

We use SET GLOBAL for setting variables in procedures, these variables are used in the header lines. TRIMqmr doesn't support this feature, is there a workaround?

At the moment, only four types of variables are allowed in the header/footer lines:

&n -- where n represents the first value in column n selected by the query (not neccesarily the nth column shown in the report).
&&DATE - causes QMR to display the current date (year/month/day).
&&TIME - causes QMR to display the current time (hour:minute).
&&PAGE - causes QMR to display the current page number of the report.

Is there a switch to enable automatic key repeat?

Holding down the key should work fine.

What do the options -v$ltn>/<m> and -b<s> mean?

-v<n>/<m> controls the size of the Data and Report buffers. When this product was created, memory was expensive and so we gave the user the ability to control the amount of memory used. When the amount of main memory, <m>*4kb, is used, the Data and Report buffers are "spilled" into virtual disk memory controlled by TRIMqmr. The only time the defaults should be modified is if you ever get an error "VM error: Tagged item $1 out of range ($2 overflow)". The $2 value will tell you Report or Data. You must then increase the <n> parameter.

-b<s> controls the fetch buffer. Increasing it can improve performance by allowing more data rows to be fetched at one time.

Is there an option to format the &DATE variable in the German format DD.MM.YYYY ?

Not at the moment.

SET PRINTER "\\REQ00565\HP LaserJet IIIP" doesn't work, so it's impossible to use a network printer under NT.

You are correct. SET PRINTER LPT1: works only for local printers.

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.

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.