Access, Access 2000, Access 2003, Access 2003 forms, Access 2007, Access 2007 forms, Access 2007 functions, Access control, Access Database, Access forms, Access Points, Access query, Access Tables, BLOB, Clustering, CSV, Database administration, Database connectivity, Database design, Database issues, Database management, Database Management Systems, Database migration, DB2, DB2 administration, DB2 Universal Database, DB2/400, DBA, DBMS, Embedded SQL, Flat files, FoxPro 2.6, IIF function, IIF statement, INSERT statement, JDBC, JOIN statement, Microsoft Access, Microsoft Access 2003, Microsoft Access 2007, Microsoft Access 2010, Microsoft Access forms, Microsoft Access subforms, MySQL, MySQL Database, ODBC, Query optimization, SQL queries, Sybase, Triggers VIEW ALL TAGS
We have a web service running on a SQL server sending data to our I-Series using a DB2 connection. The first time the service is run to submit an order, there is a long delay before it is submitted. On repeated orders it much quicker. Is there something we can do to speed up the initial connection?...
I want to limit the number of application connections to 1 in DB2 server. And try connecting with 2 applications to check the behavior?
We are having trouble trying to use a 255 byte key in DB2/400 DDS specs. We use Oracle VARCHAR keys 255 bytes long all the time. How do we specify a DB2/400 key to be like an Oracle VARCHAR? Note: in an Oracle VARCHAR the trailing spaces are compressed out. In a pure 255 DDS field, apparently any...