Or if you want it in a format that ARS uses, you could create a AL guide,
that loops over that table, and generate a GUID for all the null entries
until it finds no nulls....
Joe
-----Original Message-----
From: Pruitt, Christopher (Bank of America Account)
Sent: Monday, May 02, 2011 3:38 PM Newsgroups:
public.remedy.arsystem.general
To: arslist@ARSLIST.ORG
Subject: Re: Setting Application-Generate-GUID via SQL
Thanks Andrew,
That is just want I needed.
Christopher Pruitt
Business Consulting III
HP Enterprises Services
christopher.pru...@hp.com
www.hp.com
Confidentiality Notice: This message and any files transmitted with it are
intended for the sole use of the entity or individual to whom it is
addressed, and may contain information that is confidential, privileged, and
exempt from disclosure under applicable law. If you are not the intended
addressee for this e-mail, you are hereby notified that any copying,
distribution, or dissemination of this e-mail is strictly prohibited. If you
have received this e-mail in error, please immediately destroy, erase, or
discard this message. Please notify the sender immediately by return e-mail
if you have received this e-mail by mistake.
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew C Goodall
Sent: Monday, May 02, 2011 2:36 PM
To: arslist@ARSLIST.ORG
Subject: Re: Setting Application-Generate-GUID via SQL
Perhaps - http://www.dbasupport.com/forums/showthread.php?t=23871
Regards,
Andrew Goodall
Software Engineer 2 | Development Services | jcpenney . www.jcp.com
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG] On Behalf Of Pruitt, Christopher (Bank of
America Account)
Sent: Monday, May 02, 2011 2:31 PM
To: arslist@ARSLIST.ORG
Subject: Setting Application-Generate-GUID via SQL
Does anyone on the list know how to perform this process via SQL Update
statement.
$PROCESS$ Application-Generate-GUID
We have been trying to do it via a filter for thousands of records to
generate a GUID value into a field where it is missing.
We can do it in very small batches, 10-20 records at a time but like I seen
we have over 1000 to update and wanted to know if anyone had a way of doing
it via a SQL Update statement.
Our environment.
ARS v 7.1 patch 9
Oracle 10g
SunOS 5.9
Christopher Pruitt
Business Consulting III
HP Enterprises Services
christopher.pru...@hp.com
www.hp.com<http://www.hp.com/>
Confidentiality Notice: This message and any files transmitted with it are
intended for the sole use of the entity or individual to whom it is
addressed, and may contain information that is confidential, privileged, and
exempt from disclosure under applicable law. If you are not the intended
addressee for this e-mail, you are hereby notified that any copying,
distribution, or dissemination of this e-mail is strictly prohibited. If you
have received this e-mail in error, please immediately destroy, erase, or
discard this message. Please notify the sender immediately by return e-mail
if you have received this e-mail by mistake.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
