HP3000-L Archives

June 1997, Week 2

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Herbert Baumgartner <[log in to unmask]>
Reply To:
Herbert Baumgartner <[log in to unmask]>
Date:
Tue, 10 Jun 1997 18:20:56 GMT
Content-Type:
text/plain
Parts/Attachments:
text/plain (40 lines)
Hello ALL!

We are looking for a solution to the following IMAGE/SQL problem:

We want to write a EXCEL Basic script that should update an Image/SQL
database. Unfortunately the UPDATE statement in the EXCEL-Script returns an
error 2042.

When we do the same update with ISQL the following error occurs:

isql=> update dbb.cfg set anschluss = 'N' where ADR='VW';
IMAGE/SQL error 156; TurboIMAGE error -242; TurboIMAGE intrinsic 420, &
Auxiliary error 6554488.  (DBERR 13552)
Number of rows processed is 0
isql=>

The same error occurs also when doing only a SELECT on the dataset. SELECT
with open mode 5 is ok.

The dataset CFG is a manual master with ADR as key.

The user is defined with open mode 1.

The intrinsic 420 is DBXBEGIN, the error -242 could not be found in the manuals.

Our MPE Release is C.50.00, ALLBASE/SQL version installed is A.G1.13,
IMAGE/SQL version is B.G1.05.

My questions are:

1. Do anybody now what is wrong?

2. Is there anybody who did a successful update on an IMAGE/SQL database
within an Excel-Skript?

Thank you in advance for your help.

Regards
Herbert

ATOM RSS1 RSS2