Can I put the driver and the connect_string in an .ini file
like the network_string? Currently I call TRIMqmr like this --
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?
We have TRIMqmr ver 22.214.171.124, 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
The key record files are created by
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
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.
- &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.
-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
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.