Hi John,

The problem is caused by the fact that the "AOPTIONS"
used by ATCUTIL "SET TURBODB" command conflict
with the AOPTIONS used to open the database in modes
1 or 5. There is an SR filed on this, 5003-225409.

I do not find that it has been fixed in any newer release of
Image/SQL. It could very well be due to the fact that it
cannot safely be fixed.

The listed workaround is, unfortunately, to ensure that the
database in not being accessed or being accessed in
any mode other than 1 or 5.

Sorry this isn't much help!

Bill
HP/CSY

>Hi All
>I am tring to create an IMAGE SQL environment that
>includes several image databases. I have a job with a
>WHILE loop to attach each of the databases. The user
>and account (OWNDBMGR.ACCT) on the job card is the
>owner/creator of all the image databases and the ISQL
>DBE. The relevant code follows:
>
>
>!   ECHO SET SQLDBE MYDBE.MYDRA.ACCT > MYTMPD
>!   ECHO SET TURBODB MYDTY.MYDRA!_DB >> MYTMPD
>!   ECHO ATTACH WITH OWNER = MYDTY!_DB >> MYTMPD
>!   ECHO ADD USER MYUSER@ACCT WITH CLASS = 5, MODE = 6
>>> MYTMPD
>!   ECHO ADD USER MGR@ACCT WITH CLASS = 5, MODE = 6 >>
>MYTMPD
>!   ECHO UPDATE USER OWNDBMGR@ACCT TO CLASS = 5, MODE
>= 6 >> MYTMPD
>!   ECHO DISPLAY OPTIONS  >> MYTMPD
>!   ECHO DISPLAY USERS    >> MYTMPD
>!   ECHO EXIT >> MYTMPD
>!
>!   RUN IMAGESQL.PUB.SYS < MYTMPD
>
>Everything works OK until it tries to attach a DB that
>is open. The following error is generated:
>
>  1025
>   1026   HP36385B
>   1027    B.G2.11
>   1028                  IMAGE/SQL Utility   THU, JUN
>22, 2000,  2:00 AM
>   1029   (C) COPYRIGHT HEWLETT-PACKARD COMPANY 1993
>   1030
>   1031   SET SQLDBE MYDBE.MYDRA.ACCT
>   1032   SET TURBODB MYDTY.MYDRAAW
>   1033   File System Error on MYDTY.MYDRAAW.ACCT
>(ATCERR 32207,FSERR 48).
>   1036
>   1037
>   1038   RUN IMAGESQL.PUB.SYS
>   1039   Program terminated in an error state. (CIERR
>976)
>
>^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>
>The IMAGE databases are always opened in either mode 4
>or 6. I suspect that when IMAGESQL is trying to ATTACH
>the db it is attempts to open with mode 5. There are
>over 30 of these databases and they are accessed
>frequently, so it will be difficult to find a time
>when they are all free.
>
>Any suggestions gratefully received.
>
>Thanks
>John Edwards
>
>__________________________________________________
>Do You Yahoo!?
>Send instant messages with Yahoo! Messenger.
>http://im.yahoo.com/
>