| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 1039.1 | | BROKE::WHITE | | Thu Mar 28 1996 09:41 | 31 |
| 1039.2 | Only from precompiled program!!!! | IB002::BERNABE | | Thu Mar 28 1996 15:22 | 16 |
| 1039.3 | | BROKE::WHITE | | Thu Mar 28 1996 16:45 | 4 |
| 1039.4 | Available tomorrow. | IB002::BERNABE | | Thu Mar 28 1996 17:45 | 5 |
| 1039.5 | Traces and codes. | IB002::BERNABE | | Fri Mar 29 1996 05:12 | 491 |
| 1039.6 | | BROKE::WHITE | | Fri Mar 29 1996 11:39 | 16 |
| 1039.7 | Dynamic SQL is the answer. | ORAREP::IB002::BERNABE | | Tue Apr 09 1996 10:24 | 7 |
| Well, unfortunately COBOL does not have a DATE data type. It uses the
equivalent to char(23).
But the good news is that it is very easy to run dynamic SQL from
COBOL, and it works perfectly; DBI pushes the whole condition.
Thanks a lot.
Miguel Bernab�.
|
| 1039.8 | ReadCommited from MS-Access? | ORAREP::IB002::BERNABE | | Tue Apr 09 1996 10:30 | 7 |
| Regarding .1 -> READ COMMITED to avoid -914.
It works fine from SQL$ or a program. But how can I force it from
MS-Access? I have tried several ways, including passthru, but always
failed.
Thanks in advance.
Miguel Bernab�.
|
| 1039.9 | | BROKE::WHITE | | Tue Apr 09 1996 17:22 | 10 |
| At one time the answer was that you could not change the default isolation
level settings from a desktop client like ms-access. I don't know if there
have been ease-of-use changes made to the common components to allow this.
One site I dealt with fixed this by rebinding the DB2 server packageset/plans
so that they never ran with repeatable read. That way all requests against
that instance of the server would run under the cursor stability setting
and locking would not be an issue.
This suited their needs, but your milage may vary....
|
| 1039.10 | | BROKE::WHITE | | Tue Apr 09 1996 17:38 | 6 |
| Check out the published features for RDB 7 and you'll find a SQL Services
feature that allows a SQL Services Server to have an "init" procedure. Sounds
like that would allow you to set the default transaction semantics to something
less restrictive.
Of course, you'll have to wait til RDB 7 ships before you can use it.
|