list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: Wednesday, February 29, 2012 11:57 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy Table Recreation
**
The information you provide is always helpful. Thanks to your first
response we have what we need to move forward.
Axton
: Wednesday, February 29, 2012 11:57 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy Table Recreation
**
The information you provide is always helpful. Thanks to your first
response we have what we need to move forward.
Axton
On Feb 29, 2012 12:06 PM, Mueller, Doug doug_muel...@bmc.com wrote
8:52 AM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy Table Recreation
I know on Oracle a view can not be altered. It can only be dropped
and created. Not sure if the same applies to MSSQL.
-Original Message-
On Tue, Mar 6, 2012 at 8:17 AM, Narayanan, Radhika wrote:
**
Hi
, Frederick W
Sent: Tuesday, March 06, 2012 10:02 AM Newsgroups:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Remedy Table Recreation
I don't think every supported database has the CREATE OR REPLACE VIEW
syntax, so I believe the system drops and creates a new view.
Fred
Subject: Remedy Table Recreation
First, some background information:
It used to be the case that certain operations would trigger Remedy to
recreate a database table:
- rename existing table
- create new table with the original name
- copy the data from the renamed table to the new table
table.
I hope this correction is helpful,
Doug Mueller
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: Monday, February 27, 2012 1:27 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy Table Recreation
We did
Message-
From: Action Request System discussion list(ARSList) [mailto:
arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: Monday, February 27, 2012 1:27 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy Table Recreation
We did not see a primary key defined for the T, H, or B tables, or the
meta
: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug
Sent: Wednesday, February 29, 2012 12:07 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy Table Recreation
Axton,
OK, the implementation was not carried to the complete degree for Oracle
First, some background information:
It used to be the case that certain operations would trigger Remedy to
recreate a database table:
- rename existing table
- create new table with the original name
- copy the data from the renamed table to the new table
- drop the renamed table
I remember
anyone changing your table structure should know about the
primary key).
Fred
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: Monday, February 27, 2012 9:53 AM
To: arslist@ARSLIST.ORG
Subject: Remedy Table
:)
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: Monday, February 27, 2012 8:53 AM
To: arslist@ARSLIST.ORG
Subject: Remedy Table Recreation
First, some background information:
It used to be the case that certain
Subject: Remedy Table Recreation
First, some background information:
It used to be the case that certain operations would trigger Remedy to
recreate a database table:
- rename existing table
- create new table with the original name
- copy the data from the renamed table to the new table
- drop
Subject: Re: Remedy Table Recreation
I read that thread, but the terminology confused me.
Just to be clear on the terminology; I am looking for things that
issue a DROP TABLE and a CREATE TABLE (in an effort to alter the
characteristics of an existing table) and I am not concerned with
things
Hi,
It depends on the database, where different vendors allow for different
changes with ALTER TABLE.
I think that if you go to/from 255 bytes in character lenght, this
requires a datatype change from VARCHAR to TEXT, which will trigger the
operation.
For all practical purposes, it should be
Thanks Misi. I'm trying to identify a specific case on Oracle. I
don't think this exists any more (as it used to), but I need to try
and confirm. Hoping I get lucky and find someone who has run into
this.
Axton Grams
On Mon, Feb 27, 2012 at 11:32 AM, Misi Mladoniczky m...@rrr.se wrote:
Hi,
Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: Monday, February 27, 2012 12:04 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy Table Recreation
Thanks Misi. I'm trying to identify a specific case on Oracle. I
don't think this exists any more (as it used
27, 2012 12:04 PM
To: arslist@ARSLIST.ORG
Subject: Re: Remedy Table Recreation
Thanks Misi. I'm trying to identify a specific case on Oracle. I
don't think this exists any more (as it used to), but I need to try
and confirm. Hoping I get lucky and find someone who has run
@ARSLIST.ORG
Subject: Re: Remedy Table Recreation
Hi,
It depends on the database, where different vendors allow for different changes
with ALTER TABLE.
I think that if you go to/from 255 bytes in character lenght, this requires a
datatype change from VARCHAR to TEXT, which will trigger the operation
18:20
To: arslist@ARSLIST.ORG
Subject: Re: Remedy Table Recreation
Close. It creates a temp column and not a temp table:
ALTER TABLE T3185 ADD (C536870916Z clob NULL) ALTER TABLE T3185 DROP COLUMN
C536870916 ALTER TABLE T3185 RENAME COLUMN C536870916Z TO C536870916 DROP VIEW
ztestsql1 CREATE
to confirm
what I just claimed for anything below those versions..
Joe
-Original Message-
From: Peter Romain
Sent: Monday, February 27, 2012 1:21 PM Newsgroups:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Remedy Table Recreation
I seem to remember years ago
Subject: Re: Remedy Table Recreation
I thought DROP COLUMN always existed since the beginning of times - its just
that the AR API didn't use it when it could have in many cases in the
earlier days.. But then beginning of times for me was Oracle 7.x and greater
and MS-SQL 6.x (6.5 I think
Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: Monday, February 27, 2012 7:53 AM
To: arslist@ARSLIST.ORG
Subject: Remedy Table Recreation
First, some background information:
It used to be the case that certain operations would trigger Remedy
be aware that this is coming and may have some impact on you in
the future.
Doug Mueller
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: Monday, February 27, 2012 7:53 AM
To: arslist@ARSLIST.ORG
Subject: Remedy
and may have some impact on you in
the future.
Doug Mueller
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: Monday, February 27, 2012 7:53 AM
To: arslist@ARSLIST.ORG
Subject: Remedy Table Recreation
First
that this is coming and may have some impact on you in
the future.
Doug Mueller
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Axton
Sent: Monday, February 27, 2012 7:53 AM
To: arslist@ARSLIST.ORG
Subject: Remedy Table
Hi,
Which Remedy table has the Support Organization, Support Group, and the
Location?
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
, December 08, 2010 9:00 AM
To: arslist@ARSLIST.ORG
Subject: Remedy Table
**
Hi,
Which Remedy table has the Support Organization, Support Group, and the
Location?
_attend WWRUG11 www.wwrug.com ARSlist: Where the Answers Are_
/SQL-Reporing-Services---making-sense-of-Remedy-Table-structure-tp20626113p20682374.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.
___
UNSUBSCRIBE or access ARSlist Archives
) 962-7177
-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]
On Behalf Of npeterson
Sent: Sunday, November 23, 2008 5:32 PM
To: arslist@ARSLIST.ORG
Subject: Re: SQL Reporing Services - making sense of Remedy Table structure
Thanks both of you
-Reporing-Services---making-sense-of-Remedy-Table-structure-tp20626113p20668739.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com.
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Subject: Re: SQL Reporing Services - making sense of Remedy Table structure
Welcome to the joy of reporting from Remedy :-
There is database documentation, IMHO its as good as some m/soft
documentation l have found. If anyone understands it please let me know!
Well done for using the tables
Curious what is it then ?
--
View this message in context:
http://www.nabble.com/SQL-Reporing-Services---making-sense-of-Remedy-Table-structure-tp20626113p20670813.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com
January 1, 4713, BC.
Jennifer Meyer
-Original Message-
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]
On Behalf Of RFrench
Sent: Monday, November 24, 2008 5:03 PM
To: arslist@ARSLIST.ORG
Subject: Re: SQL Reporing Services - making sense of Remedy Table
there are things missing. Not least of all documenation. Guess
now l have managed to start posting l might be asking some more questions =)
--
View this message in context:
http://www.nabble.com/SQL-Reporing-Services---making-sense-of-Remedy-Table-structure-tp20626113p20672036.html
Sent from
)
[mailto:[EMAIL PROTECTED] On Behalf Of RFrench
Sent: Monday, November 24, 2008 4:12 PM
To: arslist@ARSLIST.ORG
Subject: Re: SQL Reporing Services - making sense of Remedy Table structure
Thanks for that, for me personally speaking it raises another issue where
%*% is all this information. I have only
in context:
http://www.nabble.com/SQL-Reporing-Services---making-sense-of-Remedy-Table-structure-tp20626113p20626113.html
Sent from the ARS (Action Request System) mailing list archive at
Nabble.com.
___
UNSUBSCRIBE
not be met with the
integrated reporting tools.
Thanks
--
View this message in context:
http://www.nabble.com/SQL-Reporing-Services---making-sense-of-Remedy-Table-structure-tp20626113p20626113.html
Sent from the ARS (Action Request System) mailing list archive at Nabble.com
not a remedy guy, I just happen to admin the system
and
have been given some reporting requirement that can not be met with the
integrated reporting tools.
Thanks
--
View this message in context:
http://www.nabble.com/SQL-Reporing-Services---making-sense-of-Remedy-Table-structure
:[EMAIL PROTECTED]
On Behalf Of npeterson
Sent: Friday, November 21, 2008 11:35 AM
To: arslist@ARSLIST.ORG
Subject: SQL Reporing Services - making sense of Remedy Table structure
I am hoping to user SQL Reporting services to create some Remedy reports,
however I can not make one bit of sense
Hi,
I hate to compare Remedy to a spreadsheet, but that is probably the best way
to explain this concept. When Remedy creates a form, the database table for
that form has 1 defined index. It is the only clustered index for that
form/table. That index is for the Request ID (field id #1)
. The
Since the other posts didn't answer your Q:
You are correct. If Remedy doesn't know about an index, it was added through
Oracle.
Cheers
Ben
- --- Original Message --- -
From: Marc Simmons [EMAIL PROTECTED]
To: arslist@ARSLIST.ORG
Sent: Wed, 21 May 2008
I was recently asked to check which columns of one of our remedy forms
were indexed. The documentation gave me the impression that only
Request Id would be indexed automatically, which makes sense since it
is the primary key. Remedy administrator indicated that two other
columns had indexes.
RequestID is the only automatically indexed field on any form. Your
impression on the others makes sense. If that's true, or should I say,
until you are sure that it is NOT true, you should not modify your indexes
in Remedy Administrator. If they were created in the DB, they need to be
*Hi Luksha Timothy,*
It's true that Request ID is the only implicitely indexed field in Remedy.
But,in form properties,what is the status of Indexes ?Are there any
fields indexed?Check that also.
There may be work flows related to Direct SQL action or SQL Query in
set fields action in which
44 matches
Mail list logo