Hi,
Actually I do have time because I an waiting for a report in SAP [R/3] to
finish, and that will be several hours. I tried the VTRACE, but I was
successfully able to rename the DEGREE field to DEGREE1 (and bacl) without
any problems.
Thank you,
Noah Silva
IS&T - Programmer Analyst
(215) 419 - 7916
"Stausberg, Markus" <[EMAIL PROTECTED]>
03/18/2003 08:40 AM
To: "'Noah J SILVA'" <[EMAIL PROTECTED]>, "'Elias Martenson'"
<[EMAIL PROTECTED]>, "'[EMAIL PROTECTED]'"
<[EMAIL PROTECTED]>
cc:
Subject: RE: Modify Table Error
Hello,
I tried to reproduce the error, but w/o success yet.
I made sure that there are no problems coming from
'degree' being a keyword in obsolete db2 mode of SAP DB.
If you've got some more time to spend on this issue
(I wouldn't be surprised if not) it would help us
to look at a vtrace of such an error situation.
As Thomas wrote, vtraces can be made like this :
http://sapdb.2scale.net/moin.cgi/VTrace
regards,
Markus Stausberg
SAP Labs Berlin
> -----Original Message-----
> From: Noah J SILVA [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 17, 2003 6:08 PM
> To: Stausberg, Markus
> Subject: RE: Modify Table Error
>
>
> Hi,
>
> This was for me with 7.4.0.14, and SQL studio is 7.4 (most DLLs way
> 7.4.3.6).
> The table definition has changed since then, but I can give
> you an idea.
> (I think still I couldn't rename the column if I tried). I
> have a feeling
> it is a special case - in FACT, I wonder if "degree" is a SQL
> reserved
> word, since it shows up as blue in SQL Studio. I would think
> the create
> table dialog wouldn't let you use reserved words.
>
> the table looks like:
> GUID INTEGER KEY NOTNULL
> SPELLING VARCHAR 128 ASCII NOT NULL
> SYN_CODE INTEGER (foreign key)
> ANT_CODE INTEGER (foreign key)
> POS CHAR 3 ASCII NOT NULL (foreign key)
> TENSE INTEGER (foreign key)
> DEGREE INTEGER (foreign key) - (this was not a foreign key
> before, and has
> DEFAULT 64)
> F_OBSOLETE BOOLEAN DEFAULT FALSE
> F_VULGAR BOOLEAN DEFAULT FALSE
> F_POLITE BOOLEAN DEFAULT FALSE
> ... (more booleans)
> STAT_POP INTEGER
> - the following fields are new since the problem -
> NUMBER INTEGER (foreign key)
> PERSON INTEGER (foreign key)
> CASE INTEGER (foreign key)
> VOICE INTEGER (foreign key)
> F_REFLEXIVE BOOLEAN
> F_IMPERATIVE BOOLEAN
> F_DIMINUTIVE BOOLEAN
> W_CODE INTEGER (Foreign Key)
> STRENGTH INTEGER (replaces DEGREE)
>
> I am sure you can see this database holds some words and grammer
> information. We were using "degree" to mean the strength of
> a word, i.e.
> "HOT" might be 128 and "WARM" is only 64. Then we
> realized, "Degree"
> has a special (and similar) meaning in english, where:
>
> COLD = standard
> COLDER = comparative
> COLDEST = Superlative
>
> (and good, better, best, etc.)
>
> So we decided to rename "degree" to "strength". This didn't
> work, so I
> made a new "strength" column and moved all of the data over to it.
>
> Thank you,
> Noah Silva
> IS&T - Programmer Analyst
> (215) 419 - 7916
>
>
>
>
>
> "Stausberg, Markus" <[EMAIL PROTECTED]>
> 03/17/2003 11:22 AM
>
>
> To: "'Noah J SILVA'" <[EMAIL PROTECTED]>
> cc:
> Subject: RE: Modify Table Error
>
>
> Hi Noah and Elias,
>
> it should be possible to rename columns using the table def dialog.
>
> could you provide the usual version strings
> (DB kernel, SQL Studio) and a table definition for
> reproducing the error ?
> Does this happen generally or only in special cases ?
>
> any hints appreciated,
>
> regards,
>
> Markus Stausberg
> SAP Labs Berlin
>
>
> > -----Original Message-----
> > From: Noah J SILVA [mailto:[EMAIL PROTECTED]
> > Sent: Monday, March 17, 2003 4:40 PM
> > To: Elias Martenson
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: Modify Table Error
> >
> >
> > Hi,
> >
> > I was trying to do the rename from the SQL Studio "Alter
> > Table" dialog.
> > This was the only change I made. Strangely enough, though
> I couldn't
> > change the column's name, I was able to change it's type.
> >
> > I made a new column with the new name and did:
> >
> > update table
> > set new=old
> >
> > update table
> > set old = 0
> >
> > This worked around the problem, but I feel a little
> > uncomfortable with
> > problems like this existing, so I still hope someone can
> > explain why this
> > happened and how to fix it.
> >
> > Thank you,
> > Noah Silva
> > IS&T - Programmer Analyst
> > (215) 419 - 7916
> >
> >
> >
> >
> >
> > Elias Martenson <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> > 03/17/2003 10:30 AM
> >
> >
> > To: [EMAIL PROTECTED]
> > cc:
> > Subject: Re: Modify Table Error
> >
> >
> > Noah J SILVA wrote:
> > > Hi,
> > >
> > > I am running SAPDB 74[.0.14?] on windows 2000, the DB type
> > is OLTP. I
> > am
> > > accessing the DB in internal mode.
> > >
> > > I have a table, which contains a column like:
> > >
> > > NAME TYPE DEFAULT
> > > -------------- ---------------- ----
> > > DEGREE SMALLINT 64
> > >
> > > There are quite a few other columns, mainly Boolean and
> > integer, with a
> > > few short CHAR and VARCHAR.
> > >
> > > I tried to rename DEGREE to STRENGTH in SQL Studio, and
> > when I select
> > > execute, I get an error dialog:
> > >
> > > "Database Error Occurred:
> > > Native Error: -9406
> > > Text: [SAP AG][SQLOD32.DLL][SAP DB]General Error; -9406
> DDL Trigger
> > failed
> > > : 200."
> >
> > It's funny, I had the exact same problem this weekend. You
> > were trying
> > to execute the rname as part of a batch, didn't you?
> >
> >
> > _______________________________________________
> > sapdb.general mailing list
> > [EMAIL PROTECTED]
> > http://listserv.sap.com/mailman/listinfo/sapdb.general
> >
> >
> >
> > _______________________________________________
> > sapdb.general mailing list
> > [EMAIL PROTECTED]
> > http://listserv.sap.com/mailman/listinfo/sapdb.general
> >
>
>
>
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
