In answer to a few of the questions on SQL and MAPICS
some tips:

1) Authority through Access (Jet engine) does play a role!

2) CL cannont run SQL but RUNSQLSTM can in CL, just remember
        to set commitment control off.

3) Beware of unkeyed files. Access will prompt you to identify
        a "unique" key. With larger data sets this becomes rather
        erratic since Jet must synthesize the keys.

4) Prototype your update statements with a equivalent SELECT
        to avoid unintended selections or updates.

5) Remember that the AS/400 does not support an update join but
        Access does. Be careful again because the Jet database must
        simulate the join.

6) Strange results thru ODBC can usually be traced to the tranlation
        panel on the ODBC connection. MAPICS files are 65535 which is no
        code page at all. ODBC demands one, so translation should be turned
        on (otherwise your character strings appear as hex).

7) Stay up to date on Client Access and ODBC. Get used to managing the
        SQLPKG objects if you use ODBC extensively.

8) On the STRSQL command:
Data refresh . . . . . . . . . . REFRESH        *ALWAYS
        is one of the defaults. This peforms better if you scroll backward
        alot by setting it to *FORWARD. Otherwise going backwards in the
        file will re-access the records instead of just displaying them.

SQL is very useful with MAPICS!

Konrad Underkofler
Hoshizaki America, Inc.


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.