I have these 2 datasets:
Name: SCREEN-TABLE , Manual (10,20/20);
Entry:
SCREEN-NAME (0), << X16 >>
FUNCTION-LINE1 , << 8X8 >>
FUNCTION-LINE2 , << 8X8 >>
FUNCTION-KEY , << 8X4 >>
SCREEN-ID ; << X4 >>
Name: REPORT-MASTER , Manual (10,20/20);
Entry:
REPORT-NAME (0), << X16 >>
REPORT-NUMBER , << X4 >>
FORMS-MSG , << X30 >>
REPORT-TITLE , << X40 >>
JOB-PRIORITY , << X2 >>
PRINT-PRIORITY , << X2 >>
PRINT-COPIES , << X2 >>
OUTPUT-DEVICE , << X8 >>
RPT-SELECT1 , << X18 >>
RPT-SELECT2 , << X18 >>
RPT-SELECT3 , << X18 >>
COMMAND-FILE , << X8 >>
PROGRAM-NAME , << X8 >>
REMOTE-ID , << X8 >>
OUTPUT-TYPE ; << X8 >>
(Schema produced with ADAGER inorder to check for any "funny" field
security)
As MGR.AIMS, well, here is the script....
Xenon 32:IMAGESQL
HP36385B B.G4.02 IMAGE/SQL Utility TUE, AUG 8, 2000, 3:28
PM
(C) COPYRIGHT HEWLETT-PACKARD COMPANY 1993
>>SET DBE PURDBE
>>SET BASE ENGLSH
>>DI USER
ATTACHED BASES : ENGLSH.PUB.AIMS
DBEnvironment : PURDBE.PUB.AIMS
Owner Name : ENGLSH
USER LOGON DBOPEN MODE USER PASSWORD USER CLASS
---------- ----------- ------------- ----------
MGR.AIMS 5 ; 64
PURCH.AIMS 5 ; 64
>>UPDATE USER PURCH TO CLASS = 10
ALLBASE/SQL group ENGLSH_10 created.
View ENGLSH.MESSAGE_V10 created.
View ENGLSH.SCREEN_TABLE_V10 created.
ALLBASE/SQL CREATE VIEW command failed (ATCERR 32357).
Syntax error. (DBERR 1001)
>>
This error (ATCERR 32357) says
32357 MESSAGE ALLBASE/SQL CREATE VIEW command failed (ATCERR
32357).
CAUSE A preprocessed CREATE VIEW failed.
ACTION This message is followed by an ALLBASE/SQL error
message. Refer to the ALLBASE/SQL Message Manual
for more information.
And I find no reference in ALLBASE/SQL Message Manual (I only searched for
32357.
Any ideas why this error and how to fix?
Doing this for other bases (same user) works ok.
> _____________________________________________________________
> Keven Miller mailto:[log in to unmask] http://www.exegesys.com
>
|