• RELEVANCY SCORE 4.00

    DB:4.00:Re: How To Check For Uniqueness Of Columns cp




    Hi,

    If I have 2 columns one age and other date of birth, I need to find whether the combination of these two columns are unique or not?

    DB:4.00:Re: How To Check For Uniqueness Of Columns cp

    Sorry this is the query

    select age,birth from table group by age,birth having count(age||birth)1.

  • RELEVANCY SCORE 3.64

    DB:3.64:Msp 2010 Wbs Definition Problem - Boxes Re-Check xc




    When I uncheck 'Verifiy uniqueness of WBS Code', then close and reopen the WBS definition, the 'Verifiy uniqueness of WBS Code' box is re-checked. Anyone know how to make it stay UN-checked? This worked in previous versions of MSP. I'm using MSP 2010
    SP1.

    DB:3.64:Msp 2010 Wbs Definition Problem - Boxes Re-Check xc

    Hi Jill,
    Just jump in to say, you cancontact Microsoft Product Support Service department directly or call the specific number for Bug Report.
    http://support.microsoft.com/gp/contactbug
    Microsoft Customer Service is available Monday through Friday, from 6:30 A.M. to 5:30 P.M. Pacific time. To contact Microsoft Customer Service, please call (800) 426-9400.

    For bug report, there is no charge to contact Microsoft Customer Service. After we identify the bug report, your charge will be refunded.

  • RELEVANCY SCORE 3.62

    DB:3.62:Checking For Uniqueness For A Splist Column Value ss




    I haved a splist with a column EmpID, where i want to apply uniqueness.While making entry into the list from a webpart, i want to apply the uniqueness. How do i do that? any out of the box feature..?
    Thanks...

    DB:3.62:Checking For Uniqueness For A Splist Column Value ss

    Hi NabX,
    Yes this is possible under MOSS 2007. You can either write custom code, or use the free solution on Codeplex:
    http://features.codeplex.com
    This includes a unique column policy that you can apply to a field in a list. To install this you need to be a farm administrator.
    Hope this helps!
    joeljoel
    Joel's SharePoint Architect Blog
    joelblogs.co.uk
    Want SharePoint Training?

  • RELEVANCY SCORE 3.60

    DB:3.60:Frm-40506: Oracle Error: Unable To Check For Record Uniqueness z1


    Hi, friends,
    When I commit the form for save the record, there is rise an error----FRM-40506: Oracle error: unable to check for record uniqueness.
    And I tried to insert exactly the same row data into that table as same db user via TOAD - which worked perfectly.
    so what could be forms' problem here ?? and how to solve it ??

    Thanks,
    Paul

    DB:3.60:Frm-40506: Oracle Error: Unable To Check For Record Uniqueness z1

    when the table has no primary key.... how do you want to update a specific row ?

  • RELEVANCY SCORE 3.57

    DB:3.57:Add Parameter Untagged: Uid m9


    DS 5.2

    The error logs show this
    [02/Feb/2004:17:42:18 -0500] - ERROR33040 - Attribute Uniqueness Plugin - conn
    =97475 op=3 msgId=4 - ADD parameter untagged: uid

    The documentation says, "configuration error" as the possible cause and the remedy being "Check the plug-in configuration parameters in the dse.ldif file. Make sure that the syntax and values are correct."

    The only attribute uniqueness enabled is for the "uid" and I don't see anything wrong with the configuration within the dse.ldif.

    Any one else in the same boat? How did you rectify the issue?

    TIA

    DB:3.57:Add Parameter Untagged: Uid m9

    What hot fix you are mentioning, can you be a bit specifc please.
    I too see this error and i am running the following on linux :

    Sun-ONE-Directory/5.2_Hotfix_1 B2003.323.1316 (32-bit)

  • RELEVANCY SCORE 3.47

    DB:3.47:Re: Generating Random Object Name km


    The uniqueness is more important for our project.
    BTW, is there other functions like this one : SYS_GUID ?

    DB:3.47:Re: Generating Random Object Name km

    But the maintenance developers will. And will curse you and your descendants to the tenth generation. Trust me. I've been there.We have all been there. I already curse the former developer of our projects... to the first generation only :p
    I have left some nice comments in the for the tricky parts of the code anyway.

  • RELEVANCY SCORE 3.29

    DB:3.29:Uniqueness Of Inquiry From Quotation. 9c



    Hi Gurus,

    I like to share the information about the difference between Inquiry and Quotation ;

    The difference is that a Inquiry is shown a " Complete Status" if a single line item or partial quantity is refered for a Quotation.

    And a Quotation shows " Partial Reference Status " when it is referred to subsequent orders unless the total quantity in the Quotation document is referenced.

    Try to check that out.

    Regards,

    Sarosh

    DB:3.29:Uniqueness Of Inquiry From Quotation. 9c


    Yes this is done through Item category customizing. We need to define the completion rule field for this.

  • RELEVANCY SCORE 3.25

    DB:3.25:Add Extra Uniqueness Plug In xk


    hello all,
    I want to have uniqueness for uidnumber and gidnumber in my DS so I created 2 more plug in instances. The plug in for uid is already enabled. When I added them i got this
    [07/Jan/2004:17:04:38 +0200] - ERROR33040 - Attribute Uniqueness Plugin - conn=8292832 op=1 msgId=2 - ADD parameter untagged: uid

    According to the manual this error code it is Configuration error and I have to check the dse.ldif file for the syntax and values.
    I read the dse.ldif but I did n't see and I could understand if there is any problem
    I made a few tests and the plugins are working, I tried to add group and users with same uidnumber or gidnumber and I couldn't and in the errors log I saw that the plugin did n't allow the
    creattion of the entry.

    Any ideas about this?

    Regards,
    Pavlos

    dn: cn=slbgidnumber uniqueness,cn=plugins,cn=config
    changetype: add
    objectClass: top
    objectClass: nsSlapdPlugin
    objectClass: ds-signedPlugin
    objectClass: extensibleObject
    cn: slbgidnumber uniqueness
    nsslapd-pluginPath: /usr/opt/sunone/ds5.2/lib/uid-plugin.so
    nsslapd-pluginInitfunc: NSUniqueAttr_Init
    nsslapd-pluginType: preoperation
    nsslapd-pluginarg0: gidnumber
    nsslapd-pluginarg1: ou=group, o=myzone.gr
    nsslapd-plugin-depends-on-type: database
    nsslapd-pluginEnabled: on
    nsslapd-pluginId: NSUniqueAttr
    nsslapd-pluginVersion: 5.2
    nsslapd-pluginVendor: Sun Microsystems, Inc.
    nsslapd-pluginDescription: Enforce gidnumber unique attribute values
    ds-pluginDigest:: 02Q7yVLYsC8FInPrvbAKYq7Rj0o=
    ds-pluginSignature:: MIIBjwYJKoZIhvcNAQcCoIIBgDCCAXwCAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHATGCAVswggFXAgEBMFYwTTELMAkGA1UEBhMCVVMxGTAXBgNVBAoTEFN1biBNaWNyb3N5c3RlbXMxIzAhBgNVBAMTGlBsdWdpbiBTaWduaW5nIENlcnRpZmljYXRlAgUA5X1ATjAJBgUrDgMCGgUAoF0wGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDMwNTIzMDIxMDE5WjAjBgkqhkiG9w0BCQQxFgQUK++U3uA/HWIl0Qp4mp+nKPuV/B0wDQYJKoZIhvcNAQEBBQAEgYB+BTTCfaaDp0mBVlaqenvMjY9Q9F5H2lt6zonM9tqwaoUT8aI8wLFWWjyaFZ49PmGoU5fVNZPpuCf/9IT/FI9rzC+egCH4NQ33hqFHLIRfmaLWwT4cc6UrSQKGgQCF7bNg2cP6S718PbiG4rPGq8G9K+dxeeWkLkDy2g9sSACg6Q==

    dn: cn=slbuidnumber uniqueness,cn=plugins,cn=config
    changetype: add
    objectClass: top
    objectClass: nsSlapdPlugin
    objectClass: ds-signedPlugin
    objectClass: extensibleObject
    cn: slbuidnumber uniqueness
    nsslapd-pluginPath: /usr/opt/sunone/ds5.2/lib/uid-plugin.so
    nsslapd-pluginInitfunc: NSUniqueAttr_Init
    nsslapd-pluginType: preoperation
    nsslapd-pluginarg0: uidnumber
    nsslapd-pluginarg1: ou=users, o=myzone.gr
    nsslapd-plugin-depends-on-type: database
    nsslapd-pluginEnabled: on
    nsslapd-pluginId: NSUniqueAttr
    nsslapd-pluginVersion: 5.2
    nsslapd-pluginVendor: Sun Microsystems, Inc.
    nsslapd-pluginDescription: Enforce uidnumber unique attribute values
    ds-pluginDigest:: 02Q7yVLYsC8FInPrvbAKYq7Rj0o=
    ds-pluginSignature:: MIIBjwYJKoZIhvcNAQcCoIIBgDCCAXwCAQExCzAJBgUrDgMCGgUAMAsGCSqGSIb3DQEHATGCAVswggFXAgEBMFYwTTELMAkGA1UEBhMCVVMxGTAXBgNVBAoTEFN1biBNaWNyb3N5c3RlbXMxIzAhBgNVBAMTGlBsdWdpbiBTaWduaW5nIENlcnRpZmljYXRlAgUA5X1ATjAJBgUrDgMCGgUAoF0wGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDMwNTIzMDIxMDE5WjAjBgkqhkiG9w0BCQQxFgQUK++U3uA/HWIl0Qp4mp+nKPuV/B0wDQYJKoZIhvcNAQEBBQAEgYB+BTTCfaaDp0mBVlaqenvMjY9Q9F5H2lt6zonM9tqwaoUT8aI8wLFWWjyaFZ49PmGoU5fVNZPpuCf/9IT/FI9rzC+egCH4NQ33hqFHLIRfmaLWwT4cc6UrSQKGgQCF7bNg2cP6S718PbiG4rPGq8G9K+dxeeWkLkDy2g9sSACg6Q=

    DB:3.25:Add Extra Uniqueness Plug In xk

    Hi,
    could it be that the server cares about lower/uppercase values in this case (I don't know), I would try to add the plugins using the exact cases (uidNumber instead of uidnumber, gidNumber instead of gidNumber) - I hadn't any problems doing so on DS5.2 and DS6.
    Regards
    Jochem Ippers

  • RELEVANCY SCORE 3.23

    DB:3.23:How To Disable The Page While Processing A Value Change Event xc


    I'm trying to find a solution for a requirement and currently working on use case using the HR schema.I have an input text box in the page which accepts a new Department Name.The value change listener method on this calls a backing bean to check the uniqueness of the Department Name. (I'm iterating through the rows of the Departments table to check if the value is unique)Now, I need to disable the page and show an hourglass while this check happens and display a message at the end of processing.I've already got this working except that I'm not sure how I can disable the entire page and show an hourglass. Would I need to use Javascript for this?

    DB:3.23:How To Disable The Page While Processing A Value Change Event xc

    HiI got this working now after using clientListener as below.af:inputText label="Dept Name" binding="#{backingBeanScope.backingBean.it1}" id="it1" valueChangeListener="#{backingBeanScope.backingBean.checkUnique}" autoSubmit="true" validator="#{backingBeanScope.backingBean.validateDeptName}" af:clientListener method="enforcePreventUserInput" type="valueChange"/ /af:inputTextThanks for your help.References : http://www.oracle.com/technetwork/developer-tools/jdev/1-2011-javascript-302460.pdf

  • RELEVANCY SCORE 3.21

    DB:3.21:Uniqueness In Ap_Holds_All z1


    I am performing import of flat files to a data repository database.
    In order to determine whether to update or insert, I need to have uniqueness of the table AP_HOLDS_ALL.
    Oracle suggested the concatenation of the columns INVOICE_ID, LINE_LOCATION_ID and HOLD_LOOKUP_CODE for practical purposes.
    Does anyone know whether there are any other combinations of columns to obtain uniqueness of the table, please?

    DB:3.21:Uniqueness In Ap_Holds_All z1

    I am performing import of flat files to a data repository database.
    In order to determine whether to update or insert, I need to have uniqueness of the table AP_HOLDS_ALL.
    Oracle suggested the concatenation of the columns INVOICE_ID, LINE_LOCATION_ID and HOLD_LOOKUP_CODE for practical purposes.
    Does anyone know whether there are any other combinations of columns to obtain uniqueness of the table, please?

  • RELEVANCY SCORE 3.18

    DB:3.18:How To Check Uniqueness Of The Document 9c


    Hi

    Is there any functionality within B2B that ensures that a document has been transmitted only once?
    What are the chances of B2B sending the same document more than once(even after the destination server receives for the first time) due to network issue etc., If so, How can I avoid this situation.

    We can assume the destination being BPEL server.

    Thanks
    Prasad

    DB:3.18:How To Check Uniqueness Of The Document 9c

    Hello Prasad,

    Shamik approached me for a similar issue. Please set up a telecon to discuss your use case further.

    Rgds,
    Ramesh

  • RELEVANCY SCORE 3.18

    DB:3.18:Change Naming Attribute From Cn To Uid m9


    I'm trying to change the naming attribute from cn to uid to maintain uniqueness in the dn.

    For example, I want the dn to appear as:
    dn:uid=xxxxxxxx,o=my-company,c=us

    instead of:
    dn:cn=xxxxxxxx,o=my-company,c=us

    How do I do this? Any help appreciated.

    DB:3.18:Change Naming Attribute From Cn To Uid m9

    After playing around a bit, I figured out how to do this...

    * Login to http://host:port/identity/oblix/
    * Go to Identity System Console -- User Manager Configuration -- Tabs -- Employees -- Modify Attributes
    * Select the cn attribute and de-select DN prefix under Semantic type, click Save
    * Select the uid attribute and select DN prefix under Semantic type, click Save
    * Click done

    Be sure to specify a new ou (or cn or whatever...) as the target or modify the dn of existing entries in the current ou (or cn...)

  • RELEVANCY SCORE 3.18

    DB:3.18:How To Enforce Uniqueness To My Database Table fx


    Hello

    One of my database will be updated based on two columns c1 and c2.
    Previous i created an index on these two columns. But forgot to enforce uniqueness. Now my table has some duplicate data.Means columns c1 and c2 contained same value for more than one record. Now i deleted all the duplicate data. And i also want to allow any duplicate data into my table in future. While i was creating an unique index on these two columns it is not allowing and prompting errors. Can someone guide me how to enforce uniqueness for my table

    DB:3.18:How To Enforce Uniqueness To My Database Table fx

    What does "not allowing and prompting errors" mean? I assume that means that you're getting an error that the combination of c1 and c2 is not unique, which would imply that you did not delete all the duplicate data. In that case, OraMol's suggestion would seem to be appropriate.

    Justin

  • RELEVANCY SCORE 3.18

    DB:3.18:Generating Unique Attributes On Import To Mv j8


    Hi,
    I have read a couple of forum threads on the topic but I still don't know how to solve this in elegant way.

    I remember one post referring to calculation checking for uniqueness during IAF (Extension DLL) and I liked the idea.
    It was suggested to check for uniqueness in MV. But wasn't actually describing the way to accomplish that, I was able to do this using a SQL query, but I'm not sure if this is correct. It seems to work correctly, but I'm not sure of consequences it may have.

    So the import flow from SQL table to MV would look: if the attribute value (to be generated) in MV is empty, and then generate the value using a pretty simple algorithm (concatenating 2 existing attributes) and checking in MV for uniqueness (SQL Query).

    I was also considering using a portal workflow to generate the attribute values but it seems to me even more problematic as a lot of workflows run at the same time so it may not guarantee the uniqueness at all.

    I would be thankful for any suggestions and comments.
    Bart

    DB:3.18:Generating Unique Attributes On Import To Mv j8

    Indeed this would substitute my SQL query to MV mms_metaverse table. Thanks, this was really quick and helpful !

    Actually looked in the SQL profiler what query is being executed by the FindMVEntries and it seems that it's exactly the same query I was running myself, however, in a probably more supported way.

  • RELEVANCY SCORE 3.16

    DB:3.16:Creating Shared Logins In Oracle Istore df


    Hi All,

    We have a requirement to create Shared Logins for all the users of an organization. The users will have a single username/password and will be able to create their own carts and submit it. It related to multi session uniqueness.

    Has anyone came across this scenario. Any pointers to how it is done will be very helpful.

    Thanks,

    Aji

    DB:3.16:Creating Shared Logins In Oracle Istore df

    Another option here would be to do this on login, when they login can you attach them to a different Contact on the Organization so they only get what they own (make sure you set the roles so they only see their information). On login update the fnd_user to switch the party they are related to. A couple of potential issues depending on the process:
    What if two people login at the same time with the account? Either approach could encounter some pitfalls.

    Email notifications if you are using them the email address is on the fnd_user, hz_party, hz_contact_points and in the wf tables. So you may want execute a synchronize against the user anytime you switch accounts. Also, if you update before submitting then you might want to remove that notification and build your own.

  • RELEVANCY SCORE 3.16

    DB:3.16:Re: How To Get Primary Foreign Key Info From Dba_Tables? 3a


    select*
    fromdba_cons_columns
    whereowner = 'ANDY'
    and table_name = 'TEST_TABLE'
    /
    selectowner
    ,index_name
    ,table_name
    uniqueness
    fromdba_indexes
    whereowner = 'ANDY'
    andtable_name = 'TEST_TABLE'
    /reference;http://www.shutdownabort.com/dbaviews/dba_cons_columns.php

    DB:3.16:Re: How To Get Primary Foreign Key Info From Dba_Tables? 3a

    Hi Kiran,
    I have used the query you gave, yes I see the Primary key on each table, there are no referential integrity's on this database. for example i have 4 tables say table A, table B, table C, Table D and each table have PKs on more than 2 columns such as on Table A i have code1, code2, where as ob table B code1, code2, refcode1 ect...how do i know which is parent and which is child table? any other way to find out other than querying each and every table?

    Thnaks for your help.

  • RELEVANCY SCORE 3.16

    DB:3.16:Re: Uniqueness Of Hashcode Of String sj


    This whole thread has become surreal.

    DB:3.16:Re: Uniqueness Of Hashcode Of String sj

    That sounds like it would be unique within the
    process space, but will not necessarily produce a
    globally unique (GUID) or universally
    unique (UUID) identifier. You probably already
    know that, and I don't know if that kind of
    uniqueness is what is needed in this context.Depending on how you used the optional prefix it could be but it's not really intended for that. I was under the impression it only needed to be unique for a given environment and that they would only be running one process at a time. In that kind of scenario the only potential issue would be someone turning back the machine's time. That could be protected against, but since the chances of getting the exact time again even if they did that are slim I wouldn't bother.

  • RELEVANCY SCORE 3.13

    DB:3.13:Reference And Hashcode() Method 8s



    Hi all,

    since JCR handles the MULTIPLE node propries as an array of Value an application has to hande the uniqueness of the values by itself. E.g. throgh Set. But org.modeshape.graph.property.Reference does not implement hashCode() method.

    Does anybody have any other ideas how to handle the value's uniqueness in a MULTIPLE node property?

  • RELEVANCY SCORE 3.11

    DB:3.11:How To Validate For Uniqueness Constraint Consisting Of Multiple Columns? 9d


    In my software, I have Foo that has multiple children of type Bar. Each bar should be unique in the sense that for each Foo, there is only one Bar with a given name. This is easily accomplished through Table-annotation:

    @Table(
    name = "bars",
    uniqueConstraints = @UniqueConstraint(columnNames = { "name", "foo_id" })
    )

    DB:3.11:How To Validate For Uniqueness Constraint Consisting Of Multiple Columns? 9d

    Thanks for the suggestions! The biggest problem here was that I was a bit confused about what I wanted. The constraints I have exist at DB level and I first wanted to get the validation to upper level by using JSF validation without repeatin myself. Doing that would have required me to handle cases where input is valid at first but not when it is persisted.
    I now persist the new Bars in validator (ugh) and in case the persisting fails, I rollback the changes and fail the validation.Thanks for the links on validation, they will come handy in other cases!
    Btw, am I the only one who is totally fed up with Wordpress themes that have whole 460 px available for text and thus cause a lot of wrapping on code samples?

  • RELEVANCY SCORE 3.10

    DB:3.10:Re: Creating Shared Members Via Eas Load Rule With Duplicates Allowed af


    Hi John. Thanks for responding. I guess this is why I have been avoiding using the 'allow duplicates' function until now. I'm not a fan of it either. In this customer's case, we have need of allowing duplicate aliases. I am forcing uniqueness on member names by using prefixes in all dimensions.

    They have a few dimensions that have country names for aliases. They want (need) them to be straight country names.

    For now, I have turned off 'allow duplicates' on the one dimension that has three hierarchies because there isn't a need for it there. So, I may have found my work around for the time being. I would prefer to learn how to do this function for future reference.

    Thanks

    DB:3.10:Re: Creating Shared Members Via Eas Load Rule With Duplicates Allowed af

    I spent some time going through this and it seems there is no functionality to do this via a load rule. It looks like you can only do it via EAS. It seems that when the duplicate member functionality was added, load rules were not updated to deal with this. There is a similar issue with ASO where you can't set a couple of properties via load rules. Annoying! I think it stems from the fact that when they built load rules, shared members were not something you could explicitly tag during a load; shared members were implicit based on the fact the member name already existed. I imagine when they first developed it they did not envision duplicate member names and this must be very deep in the code and why they don't fix it (just speculating of course).

    Fortunately we have work arounds. For your situation, I would allow the third member that you want to be the shared member, load as a unique member. Set it to dynamic calc with a member formula that references the member you want it to be "Shared" as.

    i.e.

    KS
    --Kansas City (Stored)
    MO
    --Kansas City (Stored)
    Alt Rollup
    --Kansas City (Dynamic Calc) [Formula: "[KS].[Kansas City]"; /*pseudo shared member*/

  • RELEVANCY SCORE 3.09

    DB:3.09:I Don't Know What This Concept Is Called... Something About Uniqueness fx


    Let's say I have a single table of maintenance tasks. The table will have the following columns:
    auto incrementing index
    task_name
    step_number
    step_name

    So, each task will have a series of steps to complete it. I want to make sure that the step_numbers are not duplicated within a given task. Of course, one way to solve this would be to have a separate table for each maintenance task, which would only hold records for each step. But I don't know the number of different tasks, and will likely be adding more and more, so adding a new table each time doesn't make sense. So, is this "uniqueness" something that I would have to check on the client side before updating, or is there a way to create a database constraint such as this. Oh, and if this concept has a specific name, I would appreciate hearing it.

    DB:3.09:I Don't Know What This Concept Is Called... Something About Uniqueness fx

    Oh my gosh! If you aren't writing SQL textbooks, you should be. Thank you for the incredibly comprehensive answer. Thanks, rp0428!

  • RELEVANCY SCORE 3.09

    DB:3.09:How To Maintain Uniqueness In Batch Management s3



    Hi,

    Now I am having a scenario in my project.

    Suppose I have placed a Purchase Order for 'X' Material for 500 qty. At the time of GRN system generates one batch number for this 500 qty. let us say batch B1 is generated by the system. But my requirement is I have to maintain uniqueness in this batch for every quantity. this uniqueness like B1-1, B1-2, B1-3, B1-4 ..........................B1-500. So that they can trace which material is in which placce and to whom we have sold out. How to maintain this scenario in batch management.

    Please don't suggest "use serial number for this scenario". This is not acceptable for my scenario.

    Regards,

    Venkat

    Ph: 9990417848

    DB:3.09:How To Maintain Uniqueness In Batch Management s3

    Suppose I have placed a Purchase Order for 'X' Material for 500 qty. At the time of GRN system generates one batch number for this 500 qty. let us say batch B1 is generated by the system. But my requirement is I have to maintain uniqueness in this batch for every quantity. this uniqueness like B1-1, B1-2, B1-3, B1-4 ..........................B1-500. So that they can trace which material is in which placce and to whom we have sold out. How to maintain this scenario in batch management.

    Please don't suggest "use serial number for this scenario". This is not acceptable for my scenario.

    You should use serial number management. There's no point in speaking about batch if you give batch number for each pc of your material.

    If you want to give a unique ID for each piece of your material, your "batch" is called serial number...

    batch - Longman dictionary:

    quantity of food, medicine etc that is produced or prepared at the same time

    batch - SAP glossary:

    Subset of the total quantity of a material held in stock, which is managed separately from other subsets of the same material.

    Examples: different production lots (such as paints, dyes, wallpapers, and pharmaceutical products), delivery lots, quality grades of a material.

    serial number - Longman dictionary

    a number put on things that are produced in large quantities, so that each one has its own different number:

    serial number - SAP glossary

    Number that you give to an individual item of material in addition to the material number, in order to differentiate that individual item from all the other items of the material.

    The combination of material and serial number is unique.

    So, I think you should give the reason why you don't want to use SAP standard solution...and you should justify your requirement because you seem to be against the meaning of batch serial number....

    Regards,

    Csaba

    Edited by: Csaba Szommer on Apr 5, 2009 6:52 PM

    Edited by: Csaba Szommer on Apr 5, 2009 6:54 PM

  • RELEVANCY SCORE 3.07

    DB:3.07:Uniqueness Plug-In z8


    Hi,

    1. Does someone know how to configure the uniqueness plug-ins to force uniqueness BETWEEN multiple attributes. It is documented in the last release notes that it is now possible.

    2. Has someone experienced some problem when checking for attribute uniqueness with the requiredObjectClass and the MarkerObjectClass option. In my environnement, my DS5.2 is Disorderly Shutting down.

    Thank you,

    DB:3.07:Uniqueness Plug-In z8

    Hi,

    1. Does someone know how to configure the uniqueness plug-ins to force uniqueness BETWEEN multiple attributes. It is documented in the last release notes that it is now possible.

    2. Has someone experienced some problem when checking for attribute uniqueness with the requiredObjectClass and the MarkerObjectClass option. In my environnement, my DS5.2 is Disorderly Shutting down.

    Thank you,

  • RELEVANCY SCORE 3.07

    DB:3.07:Storing Undirected Graph ds


    Hi,

    I need to store an undirected graph.
    Supposed I have 2 tables for storing node and edges.

    How to enforce uniqueness of each node pair in edges table, as in:

    If below pair already exists in database
    node1: a
    node2: b

    Then user should not be able to insert/update pair of
    node1: b
    node2: a

    Please help.

    TIA.

    DB:3.07:Storing Undirected Graph ds

    Thank you all for the answer.
    For my case, the nodes should not be null

  • RELEVANCY SCORE 3.06

    DB:3.06:How To Force Checking Uniqueness In Datablock? cp


    Hi all,

    How do you force Form 6i to check uniqueness of the records in datablock. I want Form to be able to check uniqueness in datablock AS users type in the data NOT when users commit the data.

    For example: I want form to be able to fires warning when users type an identical data in 2 records just when (before) the users begin to key in the third records.

    Thanks in advance for your help.

    DB:3.06:How To Force Checking Uniqueness In Datablock? cp

    Try this in a When-Validate-Record trigger:

    Declare
    counter Number;
    Begin
    If :System.Record_Status = 'Insert' Then
    select count (*) into counter from yourTable
    where primaryKey = :Block.primaryKey;
    If counter != 0 Then
    Message ('Notify User of Duplicate Primary Key');
    Raise Form_Trigger_Failure;
    End if;
    End if;
    End;

    Hope this helps.

  • RELEVANCY SCORE 3.06

    DB:3.06:Uid Uniqueness Plug-In Getting Tripped cj


    I have the UID Uniqueness enabled in a multi-master environment. Yes I've read the plugin is not designed for multi-master replication environments and that if the UID is modified on more than one server at the same time the plug-in cannot detect it because it does not perform the uniqueness check when receiving replication updates, but only on the master in which the update is being made.

    That being said, the risk I run is that I unknowingly have duplicate UIDs in my system that were not detected. However, what I have recently been experiencing is the UID uniqueness plugin being tripped with false positives. Periodically, maybe once per week, or 0.5% of update transactions, an update to the directory will return err=19, tag=105 with the error log stating Attribute Uniqueness as the problem. In each case, simply re-running the LDAP modify yeilds success. Basically the UID uniqueness plugin is reporting a false positive.

    The UID is not the naming attribute in our system but is configured identically (applicable subtrees) on each of the servers.

    Is there a known scenerio where this can occur? Am I wasting my time having the plugin enabled on each master?

    DS 5.2_4 pkg install
    Solaris 9

    Thanks

    DB:3.06:Uid Uniqueness Plug-In Getting Tripped cj

    does your system reuse ids? could the system be seeing an entry marked for deletion, and still holds the unique uid value, only when the object is really finally deleted do you see it work, appearing like a false positive?
    I forget how to find a deleted entry, but it assigns it a new objectclass and does a modrdn to a guid value, then deletes the entry later. Just a thought.

  • RELEVANCY SCORE 3.04

    DB:3.04:Datagrid Column Validation s8


    Currently I am doing row validation. DataGrid sometime ago used to support bindinggroup.Items to have all the items of grid in it which can then be used to iterate over allthe items and check for uniqueness. But latest DataGrid control doesn't support
    that anymore. Now bindinggroup.Items contains only one item which is the one just edited.
    I want some sugesstions on how to attach ValidationRule to validate column or for that matter just give me Itessource as one of the parameter that I can traverse for validation.
    Can I create an attached property and attach a validationRule to that. The validationRule should get ItemsSource of grid as one of its parameters which can then be used to iterate over it and check for uniqueness. Any thoughts?

    Thanks,
    Dami.

    DB:3.04:Datagrid Column Validation s8

    Hi Dami,
    How about your issue?
    Sheldon _Xiao[MSFT]
    MSDN Community Support | Feedback to us
    Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

  • RELEVANCY SCORE 3.04

    DB:3.04:Uniqueness Database File dp


    I'm using WDS to deploy an automated build of WinXP Pro.  I've gotten everything to work with one exception.  I want to use Uniqueness Database files to hand out different product keys to different machines.  Has anyone used UDF's for product keys?  If so, can you provide a functional example?  (I don't expect a functioning key :))Thanks!---Devin

    DB:3.04:Uniqueness Database File dp

    Hi Devin,
     
    Hope these can help:
     
    http://technet.microsoft.com/es-mx/library/cc722944(en-us).aspx
    http://technet.microsoft.com/es-mx/library/cc749979(en-us).aspx
     
    Tim Quan - MSFT
     

  • RELEVANCY SCORE 3.03

    DB:3.03:Feed Back On Developer Window Os 8.1 For Mobile 9f


    Hi, I seriously appreciate the development team for creating user friendly operating system.

    however as a user I would like to put forward my suggestion on 8.1 update.
    I some how feel that windows phone uniqueness' is getting compromised on few new changes.
    1. Time and battery display on hone screen- as uniqueness of windows phone, it should be invisible as earlier version .
    2. Games should be organised as earlier version, here is thrown out as android concepts. Which deprives windows phone view.
    3.

    DB:3.03:Feed Back On Developer Window Os 8.1 For Mobile 9f

    Hi, I seriously appreciate the development team for creating user friendly operating system.

    however as a user I would like to put forward my suggestion on 8.1 update.
    I some how feel that windows phone uniqueness' is getting compromised on few new changes.
    1. Time and battery display on hone screen- as uniqueness of windows phone, it should be invisible as earlier version .
    2. Games should be organised as earlier version, here is thrown out as android concepts. Which deprives windows phone view.
    3.

  • RELEVANCY SCORE 3.03

    DB:3.03:Check Mailnickname For Uniqueness For All Mail Enabled Objects On Creation mp


    I would like to check for uniqueness of the mailnickname attribute on group creation, but i would also like to check against the person object as well.
    I tried adding both:

    my:Property
    my:Name=UniquenessValidationXPath
    my:Value=/Person[MailNickname='%VALUE%']
    /

    my:Property
    my:Name=UniquenessValidationXPath
    my:Value=/Group[MailNickname='%VALUE%']
    /

    but it only validates the first one, and ignores the second.
    Is there a way to do this all on one line, like

    my:Property
    my:Name=UniquenessValidationXPath
    my:Value=/Person[MailNickname='%VALUE%']
    or /Group[MailNickname='%VALUE%']
    /
    Thanks

  • RELEVANCY SCORE 3.03

    DB:3.03:Frm-30050: Block With Uniqueness Check Must Have At Least One Key Item. km


    I create a block called "request_info". I create a view "request_master_info_v" for its base table. When click on the button to open request_info form and try to edit data and save it. First it pops up the ""ORA-01779: cannot modify a column which maps to a non key-preserved table"

    After I changed the Key Mode to Updateable, the above error message gone.

    But, come up unable to create a form with following two errors when I compile it

    FRM-30050: Block with uniqueness check must have at least one key item.
    Block: REQUEST_INFO
    Form: XXLICC
    FRM-30085: Unable to adjust form for output.
    Form not created

    I've set the primary key to true already. it's still the same problem.

    I am using Oracle 8i database and form version is 11.0.35

    How to fix?

    DB:3.03:Frm-30050: Block With Uniqueness Check Must Have At Least One Key Item. km

    I create a block called "request_info". I create a view "request_master_info_v" for its base table. When click on the button to open request_info form and try to edit data and save it. First it pops up the ""ORA-01779: cannot modify a column which maps to a non key-preserved table"

    After I changed the Key Mode to Updateable, the above error message gone.

    But, come up unable to create a form with following two errors when I compile it

    FRM-30050: Block with uniqueness check must have at least one key item.
    Block: REQUEST_INFO
    Form: XXLICC
    FRM-30085: Unable to adjust form for output.
    Form not created

    I've set the primary key to true already. it's still the same problem.

    I am using Oracle 8i database and form version is 11.0.35

    How to fix?

  • RELEVANCY SCORE 3.01

    DB:3.01:Combine Primary Keys For Uniqueness Profiling In Information Steward 7a



    Hi, I would like to run Uniqueness profiling on my db but not on single column. My primary keys consist of 3-4 columns. Can I combine those primary keys and then run uniqueness i.e. can I combine multiple columns from a table and then run Uniqueness profiling.

    Thanks

    DB:3.01:Combine Primary Keys For Uniqueness Profiling In Information Steward 7a


    Uniqueness is tied to a single column.

    The Views inside of IS doesn't appear to allow you to concatenate fields. One thing that you might do is create a View in the database itself where you combine these fields and then profile that view inside of Data Insight.

    Hope this is helpful,

    Paula

  • RELEVANCY SCORE 3.00

    DB:3.00:Create User Account With A Powershell Workflow From Fim 77


    Useing the FIM Portal, to populate attributes in the Portal I would like to use a PowerShell Workflow to build the user account and check for uniqueness. I no longer want User Accounts to be created via the Sync engine. What is the best way of doing this?Anthony Marsiglia

    DB:3.00:Create User Account With A Powershell Workflow From Fim 77

    I don't know you reasons for wanting to create the user through Powershell. If you want to do extra configuration, such as Lync or Exchange stuff, you could maybe use this PowerShell MA as a supplement -

    http://blog.goverco.com/2012/01/powershell-management-agent-updated.htmlRegards, Soren Granfeldt
    http://granfeldt.blogspot.com

  • RELEVANCY SCORE 2.98

    DB:2.98:Re: Using Attribute Uniqueness With Multi-Master Replication? j1


    Attribute uniqueness plugin only ensure uniqueness on a single master before the entry is added. It doesn't check replicated operation since they have already been accepted and a positive result was returned to the client. So in a multiMastered environment, it is still possible to add 2 identical attributes, if like you're saying you're adding the entries at the same time on both master servers.

    We're working on a solution to have Attribute Uniqueness working in a multiMastered environment. But we're worried about its impact on performances we may get with it.

    Regards,

    Ludovic.

    DB:2.98:Re: Using Attribute Uniqueness With Multi-Master Replication? j1

    Hi,

    I'm trying to use attribute uniqueness in a iDS 5.1 multi-master replication env. I have created a plug-in instance for the attribute (memberID) on each directory instance (same installation on NT) and tested (if I try to create a duplicate value under the same instance I get a constraint error as expected). However if I create a entry under one instance and then create a second entry (different DN) with the same attribute value on the second instance, the entry is written with no complaints? If I create the entries with an identical DN, then the directory automatically adds nsuniqueID to the RDN of the second entry to maintain DN uniqueness but it doesn't seem to mind about duplicate values within the entry despite the plug-in?

    BTW I've tested MMR and it is working and I'm using a subtree to enforce uniqueness.

    Regards

    Simon

  • RELEVANCY SCORE 2.96

    DB:2.96:How To Do Update Instead Of Insert / Cancel The Insert dm


    Hello,

    we are porting an application, written originally for PostgreSQL, to Oracle. Most of the porting is pretty straightforward - change column types, simple trigger syntax changes etc.

    But we have a table (more precisely several tables) with a set of triggers, holding a tree-like structure. The point is in PostgreSQL we're using a RETURN NULL; behavior in BEFORE triggers, which means 'do nothing' to simplify thing.

    For example imagine tables A and B - and in a trigger on B we could have something like

    ...
    INSERT INTO A VALUES (id, ...)
    ...

    without a check on a uniqueness of the id value. And in a BEFORE INSERT trigger on A we have something like

    ...
    SELECT INTO c id FROM A where id = NEW.id;
    IF FOUND THEN
    UPDATE A SET .... WHERE id = NEW.id;
    -- cancel the insert without an exception
    RETURN NULL;
    END IF;
    ...

    which checks for existence of the row, and if it already exists it effectively replaces with UPDATE and cancels the INSERT without an exception.

    Is there something like this in Oracle or do I have to completely rewrite / refactor the whole thing?

    PS: We do have UNIQUE (more precisely PRIMARY KEY) on the columns - I am aware that this is not sufficient to enforce uniqueness in Oracle.

    DB:2.96:How To Do Update Instead Of Insert / Cancel The Insert dm

    Thanks John, the solution using a view seems very nifty to me. I guess it will require relatively small (if any) changes in application code when compared to MERGE.

  • RELEVANCY SCORE 2.95

    DB:2.95:Check Uniqueness da


    Hi All,

    I have an Item of a block, that hast to be unique.
    My intention is do check uniqeness when user tries to leave the Item and if not to prevent him from leaving.

    How can I realize it
    thanks for help
    Silke

    DB:2.95:Check Uniqueness da

    It is again time to bring up Kevin D Clarke's magic method of testing for uniqueness.

    The method he describes works perfectly:

    Re: Trigger

  • RELEVANCY SCORE 2.94

    DB:2.94:How To Disable Requirement Title Uniqueness ? 18



    hallo ,

    i tried to find a point where in Requirement Model ( Model Options ..." etc.) i could disable the uniqueness check for Title.

    (Code is unique) but if i add with vbs a new Requirement with same Title i get an error.

    The Base Problem is that the Business Analysts will switch the Requirements to a new Requirement ( with same "Title" ) but a new Code

    and set a Extended Prop. "State" to Active or Inactive.

    The impl. of new Ext. Prop is easy but i raise the "Feature" of uniqness Titles

    I think in other Models the Code / Name could be different ?

    thanks

    /br

    DB:2.94:How To Disable Requirement Title Uniqueness ? 18


    Yes, the PK includes the stereotype. You can use them just about everywhere to give another level of abstraction. They have a lot of features like adding custom attributes or collections at the stereotype level. One of the most helpful and simple is custom symbols in your diagrams. For me a custom symbol is not usually a symbol change (except in EAM), but just a format change. So in your example you could add a custom symbol for Active Objects that changes only the background color to green, and Inactive Objects background to yellow. Then your diagrams are easier to understand (and prettier ) I always create a custom symbol for all of my "Lookup" tables. In some analysis I have ended up with 5X the number of lookups over base tables. Having different background colors automatically assigned by stereotype really clarified the overall diagrams. I usually keep one diagram I call Top that has every object in the model so I get a global view. Having different colors for different types of objects makes this a usable model.

    If you go the color route spend some time up front creating a palette ("add to custom colors") you can use across your models or enterprise. That way things are consistent and you avoid color clashes (hello Sybase). Am I the only one that things the art director for Sybase and PD was colorblind? Every time I see the default background color for a PDM table I think of my kids - actually their dirty diapers.

    If you haven't, check out the PD MetaModel, under Help. It will help you understand PD better and also give you some real appreciation for the original design.

  • RELEVANCY SCORE 2.93

    DB:2.93:Join Columns Of Outer Join With Table Have No Uniqueness Cons xk


    Hi! I'm getting noizy error in alert log from time to time:

    -----
    Join columns of outer join with table table_name have no uniqueness constraints
    -----

    I've collected all the queries (v$sql, all_source) with montioned table, but non of them produces that error if executed.
    Any hints how to reproduce this error or where else to search that buggy sql join?

    Edited by: user545083 on 25.10.2010 6:21

    DB:2.93:Join Columns Of Outer Join With Table Have No Uniqueness Cons xk

    Hi

    I think this error is output via an materialized view refresh - check for mviews against the given table which fulfil the issue given in the error text.

    Thanks
    Paul

  • RELEVANCY SCORE 2.92

    DB:2.92:Uniqueness Conflict fj


    hi every body,

    When I read the related book about uniqueness conflict all of the says one of the way to resolve it is to append site name.
    So for primary key I thought before any insert in a table in the application I append site name to the sequence then I insert into the table so with this manere i can avoid primary key conflict and I do not need to add uniqueness conflict resolution for my primary key.
    Is it correct?
    The reason why I ask you this question is that in all books they have written that you can use uniqueness conflict resolution in this case ,but i don't want to use that so before any insert i conncat the site name to the sequence to avoid uniqueness conflict then i insert the row.

    Do you think that my approach is correct ?

    DB:2.92:Uniqueness Conflict fj

    Thank you so much for your quick response ya my site name is unique and thank you for that

  • RELEVANCY SCORE 2.89

    DB:2.89:Re: How To Generate Unique Ascii Value For A String Of Characters dj


    Your change in code is doing correct. I just wanted to know the logic change which you did.I am just concerned for uniqueness of ASCII values in the long run when data grows.

    DB:2.89:Re: How To Generate Unique Ascii Value For A String Of Characters dj

    I have to generate incremental data records in PL SQL.

    My logic is, store for each row the ASCII value of concatenated columns in that row.

    So if in the future, for generating incremental data (generate data only in case if there is any modification), if any change in the record, the ASCII value will be different and on comparing the ASCII values of new and old records, I can generate only the incremental data.
    Well it doesn't make much sense to add a new column and do all that work when you have to compare every column anyway.Just compare the new data column by column with the old data. There must be SOMETHING you can use for a primary key. If the new key doesn't exist it is a new row so just insert it.If the new key exists then do the column by column comparison to determine which columns changed.

  • RELEVANCY SCORE 2.89

    DB:2.89:Write Optimized Dso jf



    Hello,

    I have write optimized DSO and itsoverwriting.

    In this DSO there is check mark for 'Do Not Check Uniqueness of Data', i know by doing this it checks for the uniqueness of the records based on the fields avaialble in techinical keys and the active table has multiple records with same key fields available in semaintic keys.

    If i remove this check mark it will check the uniqueness of the record and if the data in fields which are avalable in the semaintic keys are same it will says duplicate entires.

    My question is ,is there any way in the write optimized DSO that if we get same data for the fields availabe in the semantic keys then the DSO will overwite.

    Cheers,

    Vikram.

    DB:2.89:Write Optimized Dso jf


    you've just found the biggest design considerationwhen using write opimised (no overwrite). I have all my write optimised DSOs feed a standard DSO so I can create delta records to subsequent targets.

    I only use the write optimised DSO's for the Inbound Data Layer to store a record of the data from the source system.

    cheers,

    Rich

  • RELEVANCY SCORE 2.89

    DB:2.89:Duplicate Data Records In Write Optimized Dso af



    Hi all,

    I am loading 2LIS_02_ITM (Purchasing Document - Item Level) data to a write optimized DSO. I am still checking uniqueness of data. I am getting duplicate data record errors; however, the records don't appear to be duplicates because the difference is that the Reversal Indicator is checked (X) on some of the records that are failing. Why isn't this recognized?

    Any suggestions for eliminating these errors with a write optimized DSO? What are the implications of checking the "do not check for uniqueness" option? I am afraid I will lose records - I need all invoice goods receipt relevant records to be maintained.

    Thanks

    C

    DB:2.89:Duplicate Data Records In Write Optimized Dso af


    Please see

    http://wiki.sdn.sap.com/wiki/display/BI/WriteOptimizedDSO

    it might help you

  • RELEVANCY SCORE 2.89

    DB:2.89:How To Validate Uniqueness In Seam p8


    Hi All
    I want to validate uniqueness for string value.it should validate in both add and edit page with respect to database.
    please help me.
    Thanks and Regards
    Maruthy

    DB:2.89:How To Validate Uniqueness In Seam p8

    Hi All
    I want to validate uniqueness for string value.it should validate in both add and edit page with respect to database.
    please help me.
    Thanks and Regards
    Maruthy

  • RELEVANCY SCORE 2.89

    DB:2.89:Check For Uniqueness Of Executable File... dc


    hi all,
    I want to develope one application which shall check the uniqueness of the application. I mean to say if I am building a project in VS and creating a exe/dll and some other person is building the same project in VS. Then how we can verify that both executables
    or dlls which got created by two person are same.
    Is there any way to do this...?
    Thanks in advance,
    IamHuM

    DB:2.89:Check For Uniqueness Of Executable File... dc

    Hi,
    Explain how to validate two applications using an automated test suite!? when the applications might not be testable!!?
    I'd need to write a book! Eh... two books!!. Have a look at a tool called NUnit. This is a testing framework that can be used to test applications. Problem you've got is the application you have is legacy (using the term from the point of viem that legacy
    is code that has no tests) ... and not designed to be testable.
    Well ok it's not ideal .... look at NUnit and read up on integration testing, your going to have to test large sections of your code base at a time. That means your going to have a difficult time setting up context for the test.

    Actually you know what might help forget NUnit, look into Pex. This is an experimental tool that will generate test code for you, it uses MsTest, Microsofts NUnit clone. That might do a lot for you. Used it once as an experiment.
    Best I can do for now, need to be somewhere.

    …we each have more potential than we might ever presume to guess. (Blog: http://dsmyth.blogspot.com/)

  • RELEVANCY SCORE 2.88

    DB:2.88:Finding Same Data Columns 9m


    There was missing one html file that was forwarded as a thanks after posting the data. So operator has inserted duplicate data many times to the DB. There is no check of uniqueness on any column as the nature of data is like this.

    Please let me know how can I compare and find the similar two columns value i.e. term and definition

    Thanks best regards

    DB:2.88:Finding Same Data Columns 9m

    not sure if this will help.

    select term, definition
    from [table]
    group by term, definition
    having count(*) 1

  • RELEVANCY SCORE 2.88

    DB:2.88:Re: How To Increment A String??? fc


    No, it doesn't always need to be a number.If
    the rows naturally have some uniqueness in them,
    there is no need to create yet another numericcolumn
    to serve as the primary key.It's safer to have a meaningless key, whether numeric
    or not. It's more resistent to future change than
    relying on the natural uniqueness of your data.So you'd suggest always having doing that? I certainly wouldn't, and would argue that there are TONS of existing corporate tables out there and new ones created every day that don't. Simple case - a table of US states, where the key is the state abbreviation. No need to create some additional meaningless column to serve as the key.

    DB:2.88:Re: How To Increment A String??? fc

    I'm just saying I'm sure there are lots of cases
    where tables have natural keys so they don't
    need an additional made-up surrogate key added. It
    would be a mistake to say you should always
    create a surrogate key.Eh. There is never a time that I know of when an artificial key can be harmful, and I don't know of any benefits to natural keys. OTOH, there are times when one thinks a natural key will be fine but later that turns out to be wrong. So I would say it really is a good idea to always use a meaningless key. My 2 cents.

  • RELEVANCY SCORE 2.88

    DB:2.88:How Unique Is Messageid In Jbossmq ? kk



    Heya,I'd like to ask how unique is MessageID generated for sent JMS messages.JMS spec states that scope of uniqueness it is up to the provider. It also states that scope should at least cover "connected set of message routers", which definition isn't too clear to me.How unique is MessageID in JBossMQ and what is it created from (IP, time....) ?CheersMichal

    DB:2.88:How Unique Is Messageid In Jbossmq ? kk


    The same ClientID cannot be connected twice concurrently.So client id and time should be enough.If you have some use case where two differentmachines use the same ClientID close togetherand the times are not in synch then it might be possibleto get a collision.But even in this case, the JBoss server won't be confusedbecause the first connection has to be disconnected beforethe second can reconnect.Regards,Adrian

  • RELEVANCY SCORE 2.87

    DB:2.87:Check Uniqueness Waveset.Email x7


    Hi,

    I can use testUser to check if an new accountId is unique:

    isnull
    invoke name='testUser' class='com.waveset.ui.FormUtil'
    refcontext/ref
    refmyId/ref
    /invoke
    /isnull

    Is there something simular to check the uniqueness of a new mailaddress?

    I need to check the waveset.email attribute for this because we don't allow re-using a mailaddress for some time after the user's resource accounts are deleted.

    Greetings,
    Marijke

    DB:2.87:Check Uniqueness Waveset.Email x7

    This should help you:

    http://forums.sun.com/thread.jspa?threadID=5342476

  • RELEVANCY SCORE 2.87

    DB:2.87:How To Combine 2 Columns For A Data Validation Need cc


    Hi i have an app that will allow a user to get documents from the document server. I have allowed the user to ask for multi docs by date or doc num. i therefore need to check on the server that the customerid matches. the uniqueness is not just customer
    id but a combo of customerid and company.
    document server: company: varchar 20
    customerid: varchar 80
    the app server: customerid: FK int not null 4
    company: PK FK char(50) not null
    we take the document id where? how do I make the correct sql here for company and customerid's?

    DB:2.87:How To Combine 2 Columns For A Data Validation Need cc

    IF EXISTS (SELECT * FROM docserverdatabase..tbl S JOIN appserverdatabase..tbl D ON S.company=D.company AND S.customerid=D.customerid) BEGIN Print 'rows are matched' END
    Hello!
    One suggestion regarding performance is that use
    IF EXISTS (SELECT1 FROM docserverdatabase..tbl S JOIN appserverdatabase..tbl D ON

    S.company=D.company AND S.customerid=D.customerid)
    BEGIN
    Print 'rows are matched'
    END

    Thanks,Raheel Khan

  • RELEVANCY SCORE 2.86

    DB:2.86:Re: Re: (Forte-Users) Max Size Of A Hash Table. sz


    Hashtables, just like arrays ( are expected to ) grow once you exceed the
    initial (setup) size. The size that is specified at the creation time is
    only the initial size. When you add more elements than what it can
    accomodate, the effective size of the hashtable is increased by making one
    (or more ) of the bucket pointers to point to sub-tables/arrays.

    Eventhough the rearrangement is transparent to the programmer, you should
    note that the performance of the look-up algorithm might reduce slightly
    with each "growth".

    Forte technote 10971 ( LargeArrays, and Hash Tables )nicely explains how
    these data structures are managed.

    Hope this helps,
    Ajith Kallambella M.

    From: "Braja Chattaraj" forte_brajachotmail.com
    To: forte-userslists.xpedior.com
    Subject: (forte-users) Max size of a hash table.
    Date: Tue, 20 Mar 2001 12:05:45 -0500

    We are trying a performance test and have discovered that the hash table
    data structure has a max limit of 32767. The setup() method would not take
    anything more than 32767 for the size parameter. The documentation does not
    say anything about a max limit for a hash table. Evidently it is using a
    signed integer of 2 bytes for the size.

    We have been using the hash table to check for the uniqueness of a large
    data set of 100,000 ids (rather than looping through the set for each id).
    Any duplicates raise an exception which is trapped to validate the
    duplicates. We could probably set the size of the hash table to 32767 if we
    are sampling more than that many ids but I am not sure about the
    performance
    if we do so. Will try though

    Any comments, suggestions or insight will be appreciated.

    Thanks,
    Braja.

    --
    For the archives, go to: http://lists.xpedior.com/forte-users and use
    the login: forte and the password: archive. To unsubscribe, send in a new
    email the word: 'Unsubscribe' to: forte-users-requestlists.xpedior.com

    DB:2.86:Re: Re: (Forte-Users) Max Size Of A Hash Table. sz

    We had to build a new hash table that linked multiple hash tables together.
    I think it was really short sighted of Forte to set that kind of upper
    limit. Good luck.

  • RELEVANCY SCORE 2.86

    DB:2.86:Mds Modeling Techniques zc


    hi all,
    I have a couple modeling concerns, as they relate to MDS 2012:
    1. Is it possible/advisable to have just one entity created out of a table that has P/C relationships for *multiple* hierarchies?
    Say I have a table with the following columns:

    HierarchyName varchar(10)
    ParentCode varchar(10)
    ChildCode varchar(10)

    where the same ChildCode may belong in multiple hierarchies, having the *same* or *different* parents?

    Currently, not seeing how this is possible, because the ChildCode (as far as MDS is concerned, needs to be unique across the entity) our solution is to have one entity per hierarchy. Is this the day to do it (creating one entity per hierarchy)?

    2. Compound columns determining uniqueness:
    Say we have a table, such as below, where all 4 columns hold the uniqueness of the row:

    Code varchar(10)
    StartDate date
    StartTime date
    isActive bit
    Is this possible in MDS, without creating a large concatenated field (of the 4)?

    It seems that MDS requires the CODE attribute to be unique so the only feasible way to implement multi-column uniqueness is to concatenate these fields, and then parse them out, after the fact, with a business rule or such. Or, just create an identity
    key for the Code attribute and manage the 4 column uniqueness in a business rule.
    thx a bunch for any feedback onto these modeling quandaries. :-)
    Cos

    DB:2.86:Mds Modeling Techniques zc

    thank you so much, Val! -- I appreciate your feedback.
    Cos

  • RELEVANCY SCORE 2.86

    DB:2.86:D2 Uniqueness Check sa



    Hi We have a requirement where , On creation page of for "dm_document" object we are checking the value for Customer Id attribute should be unique which is entered by user , So how to incorporate D2 Uniqueness Configuration with the above mentioned condition . Regards Mayur Mitkari

    DB:2.86:D2 Uniqueness Check sa


    Hi

    My DQL Qualification is : "dm_cabinet where object_name='$value(object_name)'"

    I am getting following messages in Application logs

    ""[INFO ] - c.e.d.d.a.s.p.D2SavePropertiesService : Object ID = 0c00afc8800c05b4

    "" [DEBUG] - c.e.d.a.c.documentset.D2DocumentSet : "Custom Cabinet" document set for 0c00afc8800c05b4 object and 67Admin user and null interface is true (0.000s)

    "" [DEBUG] - c.e.d.a.c.d.D2DocumentSetSwitch : Used "[Custom Cabinet Check]" (d2_uniqueness_config) for 0c00afc8800c05b4 object and 67Admin user (0.031s)

    "" [DEBUG] - c.e.d.a.c.m.u.D2UniquenessConfig : retrieving qualification at position 0

    "" [DEBUG] - c.e.d.a.c.m.u.D2UniquenessConfig : Qualification to check : dm_cabinet where object_name ='$value(object_name)'

    "" [DEBUG] - c.e.d.a.c.m.u.D2UniquenessConfig : Qualification with customized predicate : dm_cabinet where i_chronicle_id '$value(i_chronicle_id)' and (object_name ='$value(object_name)')

    ""- c.e.d.a.c.m.u.D2UniquenessConfig : Resolved qualification : dm_cabinet where i_chronicle_id '0c00afc8800c05b4' and (object_name ='pol')

    emc.d2fs.dctm.api.services.D2Service : D2SavePropertiesService - null
    2014-09-29 09:09:37 [ERROR] - c.emc.d2fs.dctm.api.services.D2Service : {}

    After this it is taking long time and throwing time out exception.

    Regards

  • RELEVANCY SCORE 2.86

    DB:2.86:Query A Web Site Javadb 13


    Hi

    Apologies for the basic nature of this question but I'm looking for a bit of inspiration.

    I am trying to work out the best way to check the uniqueness (of a user input to a web page) against records held in a javadb table located in the same web site directory. Put simply, if a user enters say the the word 'pass' then I would like to query the table to see if it already exists. If it did then I will display a message to the user.

    I would like to create a java class that will do this but the only web site resource at my disposal is the cgi_bin directory. I am sure that I can invoke the java class from a cgi script but how to return the query results from the class has me stumped.

    Any advice on this would be greatly appreciated.

    Many Thanks
    GB

    DB:2.86:Query A Web Site Javadb 13

    They are few and far between unfortunately

    A cheap USA host is DailyRazor - who are good...but IF anything goes wrong, their technical support is absolutely aweful - the worst I've ever come across, practically non-existant (I could rant all day about how aloof they are about customer satisfaction).

    If you find a good, cheap host, then please post the site here, I'm sure I'm not the only person looking for somewhere cheaper to host my sites.

    Bamkin

  • RELEVANCY SCORE 2.84

    DB:2.84:Checking Uniqueness Of An Attribute During Creation cp


    Hi,In the release notes I'm reading the following:
    Portal User Interface
    ·    You can now copy and paste a vertical list from Excel to the Resource Picker input box. This is especially useful for doing bulk Adds.
    ·    The UOC text box now lets you check uniqueness using a custom XPATH statement that you provide.

    Note

    DB:2.84:Checking Uniqueness Of An Attribute During Creation cp

    Hi, It appears to work but it does not work correctly. You cannot use the same XPATH validation filter from the CREATE mode in the EDIT mode. The XPATH validation filter has to be slightly different!
    See:
    http://blogs.dirteam.com/blogs/jorge/archive/2011/01/23/checking-uniqueness-of-an-attribute-in-fim-2010-during-the-edit-process.aspx
    Cheers,
    (HOPEFULLY THIS INFORMATION HELPS YOU!)
    Ing. Jorge de Almeida Pinto
    Senior Technical Consultant
    MVP Identity Access - Directory Services
    http://blogs.dirteam.com/blogs/jorge/default.aspx
    * This posting is provided AS IS with no warranties and confers no rights!
    * Always test before implementing!

    Jorge de Almeida Pinto [MVP-DS] (http://blogs.dirteam.com/blogs/jorge/default.aspx)

  • RELEVANCY SCORE 2.83

    DB:2.83:Staging Table Records Uniqueness ap


    Hi,

    I am loading the records into the staging table using SQL LOADER. The staging table has the following columns:

    TRANS_DATE

    TRANS_AMT

    TRANS_STATUS

    DATE_CREATED.

    I need to check before sql loader loads data into staging table, if records in the staging table has TRANS_STATUS is "PROCESSED" for a TRANS_DATE, then the same TRANS_DATE should not be allowed to load into oracle staging table thru sql loader again. How can I achieve this?

    Thanks in advance.

    DB:2.83:Staging Table Records Uniqueness ap

    Hello user1175432.
    As damorgan has suggested, there are going to be better ways to approach row-by-row decision making. The suggestions of loading to a temporary load table or using an external table are both useful here.

    However, you can accomplish the task by simply passing the TRANS_DATE value to a function that performs the lookup desired and in the instance that it finds a corresponding PROCESSED status, throw an exception (this way you could control the error message) or output an invalid value (if you are simply doing a proof of concept, but I wouldn't consider this supportable or advisable beyond that development stage). Of course, the function would simply return the TRANS_DATE value if the record should be loaded.

    You will increase the complexity of your error checking routine for contents in the SQL*Loader log file and bad data file by using this approach.

    Hope this helps,
    Luke

    Please mark the answer as helpful or answered if it is so. If not, provide additional details.
    Always try to provide create table and insert table statements to help the forum members help you better.

  • RELEVANCY SCORE 2.83

    DB:2.83:Jpa Uniqueness Constraint On Columns zm


    Hi all,

    I have a very simple data structure which has

    - the key (String) of another data class
    - a Date (using TemporalType.DATE)
    - an integer value

    but the combination of the timestamp and the key makes for a unique identifier. I could quite easily add an additional 4th @Column into my @Entity that is my @Id, but I'd rather investigate how JPA can help me setup a custom @Id that is the combination of the key and the timestamp value. It would be good to be able to let the database manage the uniqueness, instead of me having to programmatically handle (and check) it in JPA-QL queries.

    Is this a classic case of @EmbeddedId or @IdClass? If so, it seems like an awful lot of boilerplate code to achieve what I want. Is what I am proposing even recommended? Is there perhaps another way to achieve uniqueness for the combination of these two columns?

    DB:2.83:Jpa Uniqueness Constraint On Columns zm

    In general I would recommend using a generated Id, but yes, your example is a case for using an @EmbeddedId or @IdClass.

    See,
    http://en.wikibooks.org/wiki/Java_Persistence/Identity_and_Sequencing#Composite_Primary_Keys

    -- James : http://www.eclipselink.org

  • RELEVANCY SCORE 2.83

    DB:2.83:Data Profiling Newbie Question Regarding Concatenation k9


    I am loading data off a spreadsheet to be profiled and I have three fields that I need to concatenate together to create one field to check for uniqueness. One field is a String, the other two are numeric. The concat function within expression builder fails because the data types all need to be String. I can't find a function that would cast the numeric values into a String within the transformation since I am not using a database. Any suggestions on how to do the conversion of the data type so I can concatenate would be appreciated. Thanks!

    DB:2.83:Data Profiling Newbie Question Regarding Concatenation k9

    I am loading data off a spreadsheet to be profiled and I have three fields that I need to concatenate together to create one field to check for uniqueness. One field is a String, the other two are numeric. The concat function within expression builder fails because the data types all need to be String. I can't find a function that would cast the numeric values into a String within the transformation since I am not using a database. Any suggestions on how to do the conversion of the data type so I can concatenate would be appreciated. Thanks!

  • RELEVANCY SCORE 2.83

    DB:2.83:Session Id Uniqueness mm


    I would like to know how the session id is constructed and how
    uniqueness within the id is maintained.

    Thanks in advance.

    Jacob Waddles

    DB:2.83:Session Id Uniqueness mm

    I would like to know how the session id is constructed and how
    uniqueness within the id is maintained.

    Thanks in advance.

    Jacob Waddles

  • RELEVANCY SCORE 2.83

    DB:2.83:Unique Numbering - Duplicates x7



    In Service Now we have noticed duplicate numbering of tickets. We have unique watermark prefixes set up as well as the javascript: getNextObjNumberPadded(): in the default value for the Number field. In the wiki it mentions that out-of-box, numbering does not enforce uniqueness. Although it would be rare that a duplicate number would be assigned, uniqueness is not enforced. To enforce uniqueness, see Requiring Unique Values for a Field. I read through this and it has you check the box 'Unique' on the form. Whenever I do this I get a Key Violation. I have deleted all of the duplicate numbers (I am in DEV) and I still keep getting the violation even though I do not have dups. Is there other conditions that the unique value looks for?Thoughts?Please and Thank you,Shirley

    DB:2.83:Unique Numbering - Duplicates x7


    Wow - now that made a difference. I was going against the individual tables. Thank you!

  • RELEVANCY SCORE 2.81

    DB:2.81:Unique And Nonunique Indexes 3k


    Hello people,

    can somebody explain to me, what the hell am I missing?

    What enforces the unique value when you create primary or a unique key? I thought it's a unique index, but that turned out to be wrong....

    create table test1 (no number primary key);

    select index_name,uniqueness
    from user_indexes
    where table_name ='TEST1';

    INDEX_NAME UNIQUENESS
    ------------------------------ ----------
    SYS_C0017897 UNIQUE
    /

    OK, this works. Exactly as one would expect. But, If I create a table without primary key, create a nonunique index on it and then add the primary key, the index doesn't change.

    create table test2 (no number);

    create index test2_idx on test2(no);

    alter table test2
    add constraint test2_pk primary key (no);

    select index_name,uniqueness
    from user_indexes
    where table_name ='TEST2';

    INDEX_NAME UNIQUENESS
    ------------------------------ ----------
    TEST2_IDX NONUNIQUE
    /

    insert into test2 values(1); this goes ok
    insert into test2 values(1); and here I get an error

    So, it doesn't allow duplicate values...well, that's good

    When I queried the index above it shows that it's nonunique.
    So, I came to conclusion that I don't need it anymore and decided to drop it.

    drop index TEST2_IDX ;

    and I got

    ORA-02429: cannot drop index used for enforcement of unique/primary key

    So, I' have a nonunique index that is enforcing uniqueness on primary key. And I have a headache, because I don't understand what's going on.

    Same thing would happen if I created a column, then created a nonunique index on it and finally added a nonunique constraint.

    The index would still be NONUNIQUE.

    I was coming to conclusion that it's not the index that is preforming the uniqueness check, so I tested the following - create a column with unique index without unique key.

    create table test3(no number);
    create unique index test3_idx on test3(no);
    insert into test3 values(1);
    insert into test3 values(1); - error

    ORA-00001: unique constraint (TEST.TEST3_IDX) violated
    00001. 00000 - "unique constraint (%s.%s) violated"

    So index is enforcing it.

    Can somebody please tell me, what am I missing? I came to conclusion that Oracle sometimes doesn't care if index is unique or not.

    DB:2.81:Unique And Nonunique Indexes 3k

    sybrand_b wrote:
    The mechanism is version dependent. Obviously you assume everyone is using the same version and/or Oracle never changes, so that is why typing 4 digits and three dots is too cumbersome for you.
    The other part of the issue is this is a documented feature: an primary key can be enforced by a non-unique index.
    Apparently you don't -like 99.999 percent of all people asking questions here - read documentation.
    As you don't provide a version I sadly can't provide a link.
    I recommend before you start wasting your time by setting up testcases and posting them here you read documentation.

    --------------
    Sybrand Bakker
    Senior Oracle DBAWhat a snotty answer to what was a very reasonable, thought out and politely put question. I hope you didn't get any Helpful points for this.

    Seriously, learn some manners.

  • RELEVANCY SCORE 2.81

    DB:2.81:How Do Ensure That A Series Of Int's Are Never The Same? d3



    Two ways to do this.


    For the simple case like yours you can simply check against each value to see it is unique. If it is not unique then randomize it until a unique value is returned.


    The complex case is used with more numbers, or where checking the uniqueness is difficult or time consuming, or if you need to randomise the entire range. Typically you create the entire range of possibilities in a list. Then remove that item from the list once it is created, meaning it can never be selected again.

    DB:2.81:How Do Ensure That A Series Of Int's Are Never The Same? d3


    Two ways to do this.


    For the simple case like yours you can simply check against each value to see it is unique. If it is not unique then randomize it until a unique value is returned.


    The complex case is used with more numbers, or where checking the uniqueness is difficult or time consuming, or if you need to randomise the entire range. Typically you create the entire range of possibilities in a list. Then remove that item from the list once it is created, meaning it can never be selected again.

  • RELEVANCY SCORE 2.80

    DB:2.80:Can Not Attach An Element To A Document (Cda-01305) s7


    My application was migrated from Designer 2.1 to Desinger 9i. In Designer 2.1 a table element was attached to a document. After migration the element was missing. When attempting to re-attach the element in Desginer 9i I know receive the below listed error(s). I do not understand the reference to what "documentation" should be refered to. Both the table element and dcoument have been 'checked out'.

    Thank you.

    ------------------------------------------------------------------------------------------

    Message
    -------
    RME-00209: Current activity has outstanding violations

    Cause
    -----
    Could not 'commit' the data because of outstanding
    data integrity violations.

    Action
    ------
    Examine violations, fix the invalid data, and try again.

    ------------------------------------------------------------------------------------------

    Message
    -------
    RME-00224: Failed to close activity

    Cause
    -----
    Could not close ('commit') an activity.

    Action
    ------
    Examine other reported errors for specific details.

    ------------------------------------------------------------------------------------------

    Message
    -------
    CDA-01305: Document Attachment: UID 1 uniqueness violation

    Cause
    -----
    A uniqueness constraint violation was detected for this element.

    Action
    ------
    Refer to the documentation for the uniqueness constraint rules for
    this element. The number after 'UID' refers to which uniqueness
    constraint is violated if there are more than one.

    ------------------------------------------------------------------------------------------

    DB:2.80:Can Not Attach An Element To A Document (Cda-01305) s7

    My application was migrated from Designer 2.1 to Desinger 9i. In Designer 2.1 a table element was attached to a document. After migration the element was missing. When attempting to re-attach the element in Desginer 9i I know receive the below listed error(s). I do not understand the reference to what "documentation" should be refered to. Both the table element and dcoument have been 'checked out'.

    Thank you.

    ------------------------------------------------------------------------------------------

    Message
    -------
    RME-00209: Current activity has outstanding violations

    Cause
    -----
    Could not 'commit' the data because of outstanding
    data integrity violations.

    Action
    ------
    Examine violations, fix the invalid data, and try again.

    ------------------------------------------------------------------------------------------

    Message
    -------
    RME-00224: Failed to close activity

    Cause
    -----
    Could not close ('commit') an activity.

    Action
    ------
    Examine other reported errors for specific details.

    ------------------------------------------------------------------------------------------

    Message
    -------
    CDA-01305: Document Attachment: UID 1 uniqueness violation

    Cause
    -----
    A uniqueness constraint violation was detected for this element.

    Action
    ------
    Refer to the documentation for the uniqueness constraint rules for
    this element. The number after 'UID' refers to which uniqueness
    constraint is violated if there are more than one.

    ------------------------------------------------------------------------------------------

  • RELEVANCY SCORE 2.80

    DB:2.80:Re: Uniqueness Plug-In Not Working 99


    All the plugins are NOT enabled (Enabled: Off).
    Is that on purpose ?
    I suggest that you check in the error log to see if you have an indication of a problem.
    If not, you should change the Error log level to log messages for plugins and restart the server. The logs will be pretty verbose but you may get some usefull information.
    Otherwise, your changes look good.

    Regards,

    Ludovic.

    DB:2.80:Re: Uniqueness Plug-In Not Working 99

    Hi,

    I am having a problem getting the uniqueness plug-in to work for additional
    attributes.

    Following instructions in the manual, the following entries are placed in
    the dse.ldif file, and the server restarted.
    However, once I restart the server the entries either disappear from the
    dse.ldif file, or are retained but do not appear in the plug-in list inside
    the iDS console.

    What is going wrong?

    Chris

    dn: cn=uid uniqueness,cn=plugins,cn=config
    objectClass: top
    objectClass: nsSlapdPlugin
    objectClass: extensibleObject
    cn: uid uniqueness
    nsslapd-pluginPath: C:/iPlanet/Servers/lib/uid-plugin.dll
    nsslapd-pluginInitfunc: NSUniqueAttr_Init
    nsslapd-pluginType: preoperation
    nsslapd-pluginEnabled: off
    nsslapd-pluginarg0: uid
    nsslapd-pluginarg1: dc=root
    nsslapd-plugin-depends-on-type: database
    nsslapd-pluginId: NSUniqueAttr
    nsslapd-pluginVersion: 5.0
    nsslapd-pluginVendor: Sun | Netscape Alliance
    nsslapd-pluginDescription: Enforce unique attribute values

    dn: cn=businessid uniqueness,cn=plugins,cn=config
    objectClass: top
    objectClass: nsSlapdPlugin
    objectClass: extensibleObject
    cn: businessid uniqueness
    nsslapd-pluginPath: C:/iPlanet/Servers/lib/uid-plugin.dll
    nsslapd-pluginInitfunc: NSUniqueAttr_Init
    nsslapd-pluginType: preoperation
    nsslapd-pluginEnabled: off
    nsslapd-pluginarg0: businessid
    nsslapd-pluginarg1: dc=root
    nsslapd-plugin-depends-on-type: database
    nsslapd-pluginId: NSUniqueAttrBusinessid
    nsslapd-pluginVersion: 5.0
    nsslapd-pluginVendor: Sun | Netscape Alliance
    nsslapd-pluginDescription: Enforce unique attribute values

    dn: cn=group cn uniqueness,cn=plugins,cn=config
    objectClass: top
    objectClass: nsSlapdPlugin
    objectClass: extensibleObject
    cn: group cn uniqueness
    nsslapd-pluginPath: C:/iPlanet/Servers/lib/uid-plugin.dll
    nsslapd-pluginInitfunc: NSUniqueAttr_Init
    nsslapd-pluginType: preoperation
    nsslapd-pluginEnabled: off
    nsslapd-pluginarg0: attribute=cn
    nsslapd-pluginarg1: markerObjectClass=dc
    nsslapd-pluginarg2: requiredObjectClass=comBssGroup
    nsslapd-plugin-depends-on-type: database
    nsslapd-pluginId: NSUniqueAttrGroup
    nsslapd-pluginVersion: 5.0
    nsslapd-pluginVendor: Sun | Netscape Alliance
    nsslapd-pluginDescription: Enforce unique attribute values

  • RELEVANCY SCORE 2.80

    DB:2.80:How To Deal With Duplicates In Dso/Cube? pc



    Hi all,

    I know to eliminate duplicates we can go WDSO or check uniqueness of data---settings --- standard DSO I want to identify /trace duplicates while looking into DSO / Infocube and can i trace out exactly which request has data that duplicated data in the cube/DSO?

    can u suggest me?

    DB:2.80:How To Deal With Duplicates In Dso/Cube? pc


    To identify the duplicate records while loading to a cube,

    In the UPDATE tab of the DTP, under Error Handling choose Update Valid Records, No Reporting(Request Red).

    If there are any duplicates those will be captured in the error stack. Display Error Stack to see the duplicate records.

    Does this help??

    Regards,

    Meghana

  • RELEVANCY SCORE 2.80

    DB:2.80:Frm-40506: Oracle Error: Unable To Check For Record Uniqueness ac


    Hello everyone

    I have an emergency problom. the context is:

    I have a master -detail structure in a form. first, my detail is a tabulation view, so it has severals records. Then, when i try to commit the form ii received the message FRM-40506: Oracle error: unable to check for record uniqueness.
    i made a test by changing the detail block presentation to Form. and i could save because my detail has one record.

    Could someone has any idea how can I save my master-detail form with severals records in my detail.

    Master
    --------------------------------------------------------------------------------
    [code_p] [non_P]
    --------------------------------------------------------------------------------

    Detail
    --------------------------------------------------------------------------------
    [code_p] [product1]
    [code_p] [product2]
    [code_p] product3]
    -
    --
    --
    [code_p] [productn]
    --------------------------------------------------------------------------------
    thanks!

    DB:2.80:Frm-40506: Oracle Error: Unable To Check For Record Uniqueness ac

    when i do ''display error' in the menu, there is no error at all.

  • RELEVANCY SCORE 2.80

    DB:2.80:Check Record Uniqueness xj


    --
    Hi everyone,

    I'm woring in Form 4.5.
    How do I check the record uniqueness within a multiple-record
    block in order to display an
    error message to the user who have entered the key value twice
    in the keyin process
    (post_text_item_trigger) rather than firing the on_check_unique
    trigger during the commit
    operation ?

    Any help is appreciated.

    Andy
    null

    DB:2.80:Check Record Uniqueness xj

    --
    Andy Yeh (guest) wrote:
    : Hi everyone,
    : I'm woring in Form 4.5.
    : How do I check the record uniqueness within a multiple-record
    : block in order to display an
    : error message to the user who have entered the key value twice
    : in the keyin process
    : (post_text_item_trigger) rather than firing the on_check_unique
    : trigger during the commit
    : operation ?
    : Any help is appreciated.
    : Andy

    Dear Andy
    Oracle will raise an error when it commit the record which
    contains the duplicate key value.

    But we can write a simple select statement in the post-text-
    item trigger to avoid the duplicate values.

    declare
    var_empno emp.empno%type;

    begin

    select empno into var_empno from emp
    where empno = :emp_block.empno;

    message ('Already Exists ');

    exception
    when no_data_found then
    null;
    end;

    In this code let us assume, the emp is the base table, emp_blcok
    is the block for emp table, empno is a primary key in that table
    and the var_empno is a temporary variable.

    When a user type a value in the field and jumps to next filed
    this code will fetch the empno from the emp table by matching
    the entered empno with table's data.

    If the value is not there it will fire exception. In that
    exception null is available. So no problem. That means the key
    value is not there.

    If the key value is already there, it won't fire exception, it
    will come to the next statement. That is the message statement.

    Using this code you can avoid duplicate key values.

    Thanks and Regards

    Jeya Raman R

    null

  • RELEVANCY SCORE 2.80

    DB:2.80:Enforce Uniqueness In Fim Portal - Generating A Uniquename c8


    Forgive me if I have missed this but I have a generate uniqueness problem
    I have written a few powershell scripts that run using a Portal Powershell WF Activity.. one creates a file and URL safe SHA token bla bla all good

    I have written a script that tries to generate a unique attribute in the Portal using first middle third preferred and lastname and i=1 do until loop at the end bla bla

    BUT my testingthat imports, sync's and exports to FIMMA 10 identical first middle third preferred and lastname identities (good test huh !) fails uniqueness generation.

    Well the PS script fires and checks the derived name from the script login is not in AD ORnot in Portal BUT at the time the first 'n' WF fire in parallel a match was not found in AD or Portal. Consequently all 'n' WF try and
    DO populate the same value to the destination attr.
    The unique but duplicate attribute occurs because the 10 identites cause an un-anticiapted duplicate becasue they all fire their WF in sequence but run in parallel at the same time. If these 10 were spilt over time or over sequence (meaning if they occured
    somewhere in a stream of 1500 identites that fire the same WF then I might never generate a duplicate)

    I have enforced unique validation for create and edit user objects for this attribute in RCDC and then worked out this XPATH check only applies FROM the portal not a WF that hits the FIM :5725
    I have some ideas to minmise the possible duplication but wondered how I can enforce uniqueness when the attribute neither exists in AD nor the Portal but another WF is queued to used the same value.

    Hope thi smakes sense

    Any ideas please ?

    TIA

    Nigel

    DB:2.80:Enforce Uniqueness In Fim Portal - Generating A Uniquename c8

    I third it!

    - RossFIMSpecialist.com | MCTS: FIM 2010 | Now Offering

    ECMA1-ECMA2 Upgrade Services

  • RELEVANCY SCORE 2.79

    DB:2.79:Tuple Update Option 1z



    Hi,

    I have this requirement.In Customer repository I have a tuple for Phone numbers with fields like Phone number, Is Standard No, Notes etc.Everytime I import data in this tuple it would be based on uniqueness of the phone number along with Cust No .

    Now I have to change the format of Phone number , how do I import this?

    Say for eg Phone number was +1-676-434-9898 Now I want it as 6464349898.

    If I re import this , it is treated as new number but I just want to update this?

    Regards

    Nisha

    DB:2.79:Tuple Update Option 1z


    Hi Nisha,

    yes, "Creating a new field and importing values in that and then deleting the original" is one option.

    But please also give a try first by reimporting data. Try below steps to solve your issue:

    Open import manager and your data map. Change the "Set tuple update" from "Update mapped records" with "Replace". (* I am not sure what matching fields you have defined in Tuple upate option. if needed then please change them as per need)

    After changing the tuple update option to replace, import data using updated map and let us know if this solves your problem.

    - Shiv

  • RELEVANCY SCORE 2.79

    DB:2.79:Createaccount.Aspx - Event To Check Other Activities Before Account Created 13



    I would like as part of the createaccount.aspx, check another external membership database to make sure that the username is not already taken up.

    What event of method can I override to do that short or rewriting it completely?

    I am quite familiar with the account and user API, but I don't want to code all the validators that already exist in the createaccount.aspx.

    The other thing I wanted to check as part of validation was UNIQUENESS of the email. The unique flag in the configuration for the user does not work.

    Thanks

    Mike

    DB:2.79:Createaccount.Aspx - Event To Check Other Activities Before Account Created 13


    I decided to use validation controls on the controls to accomplish this

  • RELEVANCY SCORE 2.79

    DB:2.79:Vm Name Uniqueness - At Datacenter Level? 79



    Is it possible to have "same names" Virtual Machines within a datacenter?

    So, for example - a vm named "sql1" running on host1 in cluster1 and then a DIFFERENT VM named "sql1" running on, say, host 2 in cluster 2?

    Where and how is VM name uniqueness enforced?

    DB:2.79:Vm Name Uniqueness - At Datacenter Level? 79


    the uniqueness is enforced at the vCenter level. All objects have to have a unique name.

  • RELEVANCY SCORE 2.79

    DB:2.79:How To Check For Unique Field Constarint While Updating The Form 13


    I have to check uniqueness on 2 database fields(x,y)
    combination of x, y is unique which should be controlled in front end.

    In preupdate and preinsert

    iam using sql statement
    select count(*) into v_count
    from table
    where x = 'value'
    and y = 'value'

    If v_count 0 then
    message('already exists');
    raise form trigger failure;
    end if

    I am trying to update one of the fields in the block .

    While committing the form it is giving the message(already exists)from the select query in preupdate.

    Is there any way to stop the form other than

    on error where error code= 40508 or 40509
    then use the above sql stmt.
    If count 0 then
    alerting the user(' already exists');
    End if;

    DB:2.79:How To Check For Unique Field Constarint While Updating The Form 13

    http://sheikyerbouti.developpez.com/duplicates/duplicates.htm

    that was the link.

  • RELEVANCY SCORE 2.78

    DB:2.78:Uniqueness Of The Array Elements 37



    Hi,

    I've got the 1D array of the DBL values.

    How to quickly check all of they are unique?

    DB:2.78:Uniqueness Of The Array Elements 37


    What happens if you're comparing two NaN entries in a numeric array?

    Edit - by which I mean to say that, as usual, altenbach has a pretty good example of this - have a read through the comments here




    ---CLD

  • RELEVANCY SCORE 2.78

    DB:2.78:Unique Visitors ap


    I want the number of unique visitors for my site daily.

    Now, I can use the IP address as an identifier for uniqueness.

    However, for clients accessing my site through a proxy or firewall, I will get the same IP for multiple clients.

    How to get around this problem?

    Is there a better way to check for unique visitors?

    DB:2.78:Unique Visitors ap

    Do u have a sample code?

    Thx for ur time.

  • RELEVANCY SCORE 2.78

    DB:2.78:How To Manage Uniqueness Of A Value That Is Stored In Multiple Databases Tables 7s


    I have separate assets tables for storing different kind of physical and logical assets, such as:-

    Vehicle table( ID, model, EngineSize, Drivername, lastMaintenanceDate)Server table ( ID, IP, OSName, etc…)VM (ID, Size, etc…).VM_IP (VM_ID,IP)
    Now the problems I have is:-

    For the IP column in the server table and in the VM_IP table, I need this column to be unique in these two tables, so for example the database should not allow a server and a VM to have the same IP. In the current design I can only guarantee uniqueness
    for the table separately.
    So can anyone advice on how I can handle this unique requirement on the databases level.

    Regards

    DB:2.78:How To Manage Uniqueness Of A Value That Is Stored In Multiple Databases Tables 7s

    Hi,
    Create a primary key on 2 fields like ID, IP in server and VM_IP table. So that there is no duplicate records.Balaji -Please click mark as answer if my reply solves your problem.

  • RELEVANCY SCORE 2.77

    DB:2.77:Replicate Plugins Ds 5.2 73


    I'm a starter to LDAP and want to know how to create a new plugin from a existing one. I want to replicate uid uniqueness plugin to work as email uniqueness so that I can use two plugins uid and email uniqueness.

    I'm using DS 5.2

    Please help !

    DB:2.77:Replicate Plugins Ds 5.2 73

    Try this:
    http://docs.sun.com/source/817-7613/uiduniq.html

  • RELEVANCY SCORE 2.77

    DB:2.77:How To Check The Uniqueness Of Objects In A Vector 9p


    Hi!

    I want to ensure the uniqueness of objects into a vector.

    Vector BunchOfFlowers = new Vector();

    BunchOfFlowers.add( new Flower("red") );
    BunchOfFlowers.add( new Flower("green") );
    BunchOfFlowers.add( new Flower("pink") );If I want to add a ...new Flower("red").... is there a smart way to find out that the vector contains already an element which was instanciated in the same way??

    Do I have to loop through the vector?

    Kind regards

    DB:2.77:How To Check The Uniqueness Of Objects In A Vector 9p

    And now, that I am involved in projects ofsignificant size, Eclipse is my friend.

    That's cool. But my scorn is directed at the teachers
    who take noobies and
    teach them to drag'n'drop, and never bother to even
    discuss what's really
    happening. Programming as magic.Absolutely.... none scorn the premature use of IDEs as much as I

  • RELEVANCY SCORE 2.77

    DB:2.77:Re: Unique Constraint On Valid_To And Valid_From Dates p3


    Not sure what you are asking since the title conflicts with the description.
    For description i.e.
    How can I enforce uniqueness such that at any one point in time, only one row exists in the table for each name?
    Why can't you just create a unique constraint on name field to solve this ?

    DB:2.77:Re: Unique Constraint On Valid_To And Valid_From Dates p3

    If you are willing to spend some time to try things out the following approach could be interesting. I'm not sure yet if this concept would hold but It looks promising and challenging.

    Maybe it would be possible to create your own domain index by using a new indextype. This indextype would serialize the FROM and TO column range to some leaf blocks on the index.

    Either by creating separate index entries for each day (could give trouble with intra day overlaps).

    Index
    A
    _ Day 1
    _ Day 2
    _ Day 3
    B
    _ Day 1
    _ Day 2
    ...

    Then declare this index as unique (in combination with one other column).

    If somebody tries to enter a new range value for A from Day 2 o Day 4, the index should raise en error, because its uniquness on A - Day 2 and A - Day 3 is violated.

    Or by using some (mutating table select) on the index. A domain index is if I understood correctly just some IOT that is referenced when using this index object. Uniqueness could be enforced on this table. This would be almost the same concept as with a trigger, but could be implemented much faster and with less coding overhead for other tables too.

  • RELEVANCY SCORE 2.77

    DB:2.77:Catch The Uniqueness Of Primary Or Candidate Key Is Violated. (Error 1884) In Browse Window sd


    Hi Everybody,
    Help me, please
    I have problem with unique index.
    How to catch the message The uniqueness of primary or candidate key is violated. (Error 1884) in Browse window (or Grid control). Because I want to display my message instead VFP's meassage.
     
    I use VFP9.
    Sorry because my english is not good!
     
    Thanks everybody
     

    DB:2.77:Catch The Uniqueness Of Primary Or Candidate Key Is Violated. (Error 1884) In Browse Window sd

    Hi all (Markish,CetinBasoz),
    Thanks in advance for your helps.
    I solved my prolem.
    I'm sorry, because my english is not enough to say thank to you.
     
    Best regards,
    Minh Tran

  • RELEVANCY SCORE 2.77

    DB:2.77:How Can I Check Username Uniqueness Using Javascript? ds


    Hallo,

    When I am setting up a user I would like to determine whether a username exists before submiting the form. This I think is done using JS. My problem is I don't know how.

    Does anyone have any ideas?

    Thank you

    Kostas

    DB:2.77:How Can I Check Username Uniqueness Using Javascript? ds

    I would also be interested in the answer to that question because I don't know of a way to access database data from Javascript. But until we get that answer, you could use the following SQL to check that the table doesn't already contain someone with name.

    declare
    empno varchar2(7);
    empname varchar2(20);
    begin
    --- Get the user name
    empname := p_session.get_value_as_VARCHAR2(
    p_block_name = 'DEFAULT',
    p_attribute_name = 'A_USERNAME',
    p_index = 1);
    --- See if that name already exists in the database
    SELECT COUNT(*) into empno
    FROM IRUSER
    WHERE username = empname);
    IF empno 0
    THEN
    --- The user doesn't exist, add the new record
    doInsert;--- This is the default handler
    ELSE
    --- The user exists, put an error message on the status bar
    p_session.set_value(
    p_block_name = 'DEFAULT',
    p_attribute_name = '_STATUS',
    p_value = 'User already exists');
    end if;
    end;

    Put the code into your Insert button.

  • RELEVANCY SCORE 2.77

    DB:2.77:Is Sysjobid Unique? 1a



    Hi!

    We plan to use the sysjobid macro variable as an id for our historical tables to indicate uniqueness of data batches. Is it possible to recur?

    Thanks for the help!

    DB:2.77:Is Sysjobid Unique? 1a


    I see. Thanks for the help guys, as well as for the tips.

  • RELEVANCY SCORE 2.77

    DB:2.77:Indexes 88


    Hi,
    For the following information i queried

    select table_name,index_name,column_name from user_ind_columns;

    For the same indexes and table namei want to see uniqueness

    select table_name,index_name,uniqueness from user_indexes;

    I want a query that returns

    table name, index name, columns in the index and their uniqueness

    can anyone post the query.

    Thanks in advance.

    DB:2.77:Indexes 88

    ora wrote:
    Hi,
    For the following information i queried

    select table_name,index_name,column_name from user_ind_columns;

    For the same indexes and table namei want to see uniqueness

    select table_name,index_name,uniqueness from user_indexes;

    I want a query that returns

    table name, index name, columns in the index and their uniqueness

    can anyone post the query.

    Thanks in advance.SELECT ic.table_name , ic.index_name, ic.column_name,
    ic.column_position col_pos,ix.uniqueness
    FROM user_indexes ix, user_ind_columns ic
    WHERE ic.index_name = ix.index_name
    AND ic.table_name = 'EMPLOYEES';Edited by: elegant on Jul 19, 2010 10:52 AM

  • RELEVANCY SCORE 2.76

    DB:2.76:How Do Ensure That A Series Of Int's Are Never The Same? fj



    Two ways to do this.


    For the simple case like yours you can simply check against each value to see it is unique. If it is not unique then randomize it until a unique value is returned.


    The complex case is used with more numbers, or where checking the uniqueness is difficult or time consuming, or if you need to randomise the entire range. Typically you create the entire range of possibilities in a list. Then remove that item from the list once it is created, meaning it can never be selected again.

    DB:2.76:How Do Ensure That A Series Of Int's Are Never The Same? fj


    Two ways to do this.


    For the simple case like yours you can simply check against each value to see it is unique. If it is not unique then randomize it until a unique value is returned.


    The complex case is used with more numbers, or where checking the uniqueness is difficult or time consuming, or if you need to randomise the entire range. Typically you create the entire range of possibilities in a list. Then remove that item from the list once it is created, meaning it can never be selected again.

  • RELEVANCY SCORE 2.76

    DB:2.76:Re: How To Capture Data Submitted By ≪Select≫ Tag? Part 2 mj


    What went wrong? Did ANYTHING happen? You were getting one string to work last time. Did you still get one string to work? Database failure? Uniqueness constraint violated? Something wrong with reusing a Statement that way? On the basis of what I've told is it difficult to figure out what it is?

    Post more info. Maybe you'll get more help.

    Most importantly, you have to learn to help yourself. You'll never get this assignment done if you wait for the forum to write it for you.

    Is this for school or work? - MOD

    DB:2.76:Re: How To Capture Data Submitted By ≪Select≫ Tag? Part 2 mj

    Thank you. Feel free to come back and ask if you need more.

    Don't forget that you can earn Dukes by answering questions for other folks. It's a great way to learn Java, too. I've been educated by smart folks on this forum. You can build up a stockpile of Dukes for those times when you'll really need some answers, and get smarter along the way. - MOD

  • RELEVANCY SCORE 2.76

    DB:2.76:Record Exists Or Not c1


    Hi Folks
    I want to create a request .I want to check if the record already exists or not .If exists,I want to update else i want to create.How to check the uniqueness of this record through a filter ? Kindly help

    Thnks in Adv
    Priya

    DB:2.76:Record Exists Or Not c1


    Sure...you can key off the request ID. It is not unique to the form, unless you use a prefix and you are certain the prefix isn't used anywhere else. I do enough importing and exporting of records where I choose NOT to use a request ID as my unique key value as it can change. Whereas if you use a GUID (like an instance ID) as your unique field, the value will not change if you happen to import it to another system and generate a new request ID which will then break the link.. Either will work to identify the record. It just depends on how flexible you want to configuration to be.

  • RELEVANCY SCORE 2.76

    DB:2.76:How Do Ensure That A Series Of Int's Are Never The Same? kp



    Two ways to do this.


    For the simple case like yours you can simply check against each value to see it is unique. If it is not unique then randomize it until a unique value is returned.


    The complex case is used with more numbers, or where checking the uniqueness is difficult or time consuming, or if you need to randomise the entire range. Typically you create the entire range of possibilities in a list. Then remove that item from the list once it is created, meaning it can never be selected again.

    DB:2.76:How Do Ensure That A Series Of Int's Are Never The Same? kp


    Two ways to do this.


    For the simple case like yours you can simply check against each value to see it is unique. If it is not unique then randomize it until a unique value is returned.


    The complex case is used with more numbers, or where checking the uniqueness is difficult or time consuming, or if you need to randomise the entire range. Typically you create the entire range of possibilities in a list. Then remove that item from the list once it is created, meaning it can never be selected again.

  • RELEVANCY SCORE 2.75

    DB:2.75:Lot Number Exist x7


    Hello friends i am trying to define an Inventory org

    In the process when i reach Revision,lot,And LPN

    Lot Control

    uniqueness : trying to select Across Items from the List of Values There come the error message as

    APP:INV-05381:Lot numbers exist that have been used for different items

    Lot uniqueness will be violated -update not allowed

    Can any one find a solution and let me know

    Kind Regards
    Pru

    DB:2.75:Lot Number Exist x7

    Hello,

    Please check this metalink note.
    INVSDOIO: APP-INV-05381 Cannot Change The Parameter Lot Control Uniqueness [ID 1124233.1]

    Thanks
    -Arif.

  • RELEVANCY SCORE 2.74

    DB:2.74:Guid Of Solution Objects aa


    hi All..    iw as wondering how we could grab the GUID for solution objects in VS Addin Project. or alternative to identify the uniqueness of the solution objects?thanks for any comment.

    DB:2.74:Guid Of Solution Objects aa

    Solution don't have and don't need Guids. Projects inside a solution have Guids, and each project have:1) One unique project Guid that identifies it inside the solution.2) One project type Guid that identifies the type of project (C#, VB.NET, SmartDevice, etc.) and optionally a project flavor.  See:INFO: List of known project type GuidsHOWTO: Guess the type of a Visual Studio project from an add-in or macroHOWTO: Get the project flavor (subtype) of a Visual Studio project from an add-inhttp://mztools.com/resources_vsnet_addins.aspx MZ-Tools: Productivity add-ins for Visual Studio: http://www.mztools.com.
    My blog about VS extensibility: http://msmvps.com/blogs/carlosq/

  • RELEVANCY SCORE 2.74

    DB:2.74:Re: Alternative For Sequences In Rac Environment cd


    Hi All,

    Thanks for the reply

    For our sequences in Oracle, we not only require the uniqueness but also ordering of sequences.

    To give precise example, we are sending the files to other interfaces, we have sent the file XXXX000001.xx to them, and then the next file they are expecting is XXXX000002.xx.

    If we are going for CACHE (ex. 1000), then for one instance the sequence increment happen like 1 to 1000 and then might be 2000 to 3000.

    We have other scenario in which also we require behavior of number with uniqueness and ordering.

    I am reiterating the problem we are facing with these sequences of NOCACHE and ORDER. This has an ORDER and NOCACHE means for every NEXTVAL, it needs to check against all the instances to sychronize itself. We have large no. of transactions which increment sequences.

    Please get back to me if you require some other information also.

    Regards,
    Manoj

    DB:2.74:Re: Alternative For Sequences In Rac Environment cd

    For our sequences in Oracle, we not only require the uniqueness but also ordering of
    sequences.
    This is a violation of relational design. A surrogate key (which is the purpose of a sequence) only guarantees uniqueness - nothing more.

    Trying to enforce some kind of physical ordering of rows based on a number, is also missing the fundamentals of server programming, server performance, and server scalability.

    "Serialisation kills performance!" (say this phrase repeatedly until enlightenment is achieved)

    Heck, even from a business perspective your so-called requirement reeks. Take a business that writes invoices. Typically there will be more than one invoice book in order for more than one salesperson to make out an invoice (serialisation kills performance!). Some invoices can be made out incorrectly and land in the dustbin. Invoice books can be checked out in the wrong chronological order from stationary). Etc.

    Numerous factors that can and will ensure that the invoices made out by the business is not made out in a nice ascending numerical order. Not that it ever matters as there is an invoice date.

    But your requirement is so special and so unique, that it not only violates relational design and fundamental RDBMS scalability, it is also contrary to every common sense business process flow...? Yeah right.

  • RELEVANCY SCORE 2.73

    DB:2.73:Update Record With Check New User 19


    I have a page where the already registered member can create
    a username and password to access the secure part of my site. I
    need to be able to 1) check for uniqueness of username (no
    duplicates) , 2) validate my fields (password, confirm password,
    email address)
    Is there a way to apply the check new username behavior to
    the update record server behavior I have in place?
    thanks,
    Rob

    DB:2.73:Update Record With Check New User 19

    In the server behaviors panel with the submit button
    selected, from the (+) button choose User Authentication then Check
    New Username. There you can set uniqueness and requirements. From
    there, on the behaviors panel (not server behaviors), again with
    the submit button selected, select the (+) button and choose
    Validate Form. From there you can set requirements and validations.

    That should at least help.

  • RELEVANCY SCORE 2.73

    DB:2.73:Getting Attribute Values From Properties Or Attributes Components cc


    Hi,I'm have Webtop 5.3 working with 5.2.5 eContent server. In the DocApp Builder, I have defined the various attributes for different tabs that appear in my custom object Properties component. In my custom attribute, I have three attributes (attr_a, attr_b, attr_c), and I need to implement a uniqueness check to make sure that the combination of the three attributes is unique.I'm looking at implementing this in either a custom Properties or custom Attributes class, but I'm not sure how to get the info that the user has entered for those three attributes to run my uniqueness check. I would like to run this check before the vaues are actually written to the actual attributes.Any suggestions would be greatly appreciated.Thanks,-Dale

    DB:2.73:Getting Attribute Values From Properties Or Attributes Components cc

    Hi, You need to implement a function for validating the UI before saving. Here is an example*************************************************** protected boolean validateUISelection() { boolean flag = true; String s1, s2; Label label1, label2; label1 = (Label)getControl("nameerrorlabel", com.documentum.web.form.control.Label.class); label1.setVisible(false); label2 = (Label)getControl("patherrorlabel", com.documentum.web.form.control.Label.class); label2.setVisible(false); s1 = getObjectName(); if(s1 == null || s1.length() == 0) { label1.setVisible(true); return false; } // Valid File Name, Check for either Path or Assigned Categories being NOT Assigned s1 = getFolderPath(); s2 = getAssignedCategories(); if(((s1 == null) || (s1 == getString("MSG_NONE_SELECTED"))) ((s2 == null) || (s2 == getString("MSG_NONE_SELECTED")))) { label2.setVisible(true); return false; } return flag; }***************************************************Raj

  • RELEVANCY SCORE 2.73

    DB:2.73:Few Qns c3



    Dear all ,

    I have some doubt related to WRITEOPTIMIZED dsO.

    1)What is the main use of Technical key in case of Writoptimized DSO?

    2) WHAT is the uniqueness of record check box do and how it is related to semantic key?

    Ihave few idea on semanti kye but not able to make out its relation with uniqueness of record check box and technical key in DSO/

    Please can anybody help me in replying this query.

    Regards

    SK

    DB:2.73:Few Qns c3


    Dear all thanks for all of your usefull answer.

    Assigned points

  • RELEVANCY SCORE 2.73

    DB:2.73:Check Row For Uniqueness fd


    Hi all,

    I ve a requirement in iExpenses where on a standard page, i ve a 2 tabs. one for expense lines and other for mileage lines.Both use the same EO.

    I ve to check few columns on the expense lines for uniqueness and also have check few other column for mileage lines for uniqueness and should not allow duplicates while updating to the table.

    I ve successfully implemented the solution by extending the controller and getting the column values and by creating a prepared statement. But I believe there should be other simple ways to achieve this.

    I ruled out EO extension because, i cannot create unique constraint checks for both the scenarios.

    Thanks,
    Sree.

  • RELEVANCY SCORE 2.72

    DB:2.72:Forms:How To Edit Text Field Names For Uniqueness kx


    I have 20 forms with inputted data that unfortunately had the same name fields on two pages of the form. This is causing wrong data showing up in the second instance. How to easily fix without losing data?

    Also the form has a multiple line text field box that needs to be able to extend to an additional page. How to do

    DB:2.72:Forms:How To Edit Text Field Names For Uniqueness kx

    Use either Acrobat or Designer (the one the form was made in), select the field with the appropriate field tool and either double click or right click for the properties. Change the name.

  • RELEVANCY SCORE 2.72

    DB:2.72:Calling Finders From The Bean Class p1



    I've defined an entity bean with CMP. In it, I have a username that I want to check for uniqueness upon creation. To do this, I need to call a finder method from my bean class. Since the container is defining the finder methods using jaws and the Home interface, how do I make this call?-Todd

    DB:2.72:Calling Finders From The Bean Class p1


    I ended up using a much more optimal solution (that should get rid of the chance for race conditions...)in the setLoginName method of my ejb class, I get the home interface of my bean and invoke a finder to find duplicates, if one is found, I throw an exception.quick note on throwing exceptions from your ejb class:you must add a throws clause to your main interface, and any create methods in your home interface that call the throwing code.(your compiler will not remind you about any exceptions you've forgotten to throw in your home class)-Todd

  • RELEVANCY SCORE 2.72

    DB:2.72:Re: Combining Single Transaction Between Session Bean &Amp; Application Client 1s


    r035198x wrote:
    What records were inserted twice?
    Don't you have uniqueness constraints on the primary key columns to guard against duplicates?Employee 1, Project A // Both records persisted fine into both tables.
    Employee 2, Project A // Both records still persisted successfully into both tables despite have declared
    // uniqueness constraint on PROJECT table.
    Project A // Project A gets persisted for the third time even though no new record was read
    // and the uniqueness constraints had no affect.

    Below is the changes made to Project entity to impose the uniqueness constraints on column PROJECT_NAME which is not a primary key:

    @Entity
    @Table(name="PROJECT", catalog="EmployeeDB", schema="",
    uniqueConstraints = {@UniqueConstraint(columnNames={"PROJECT_ID", "PROJECT_NAME"})})
    or
    uniqueConstraints = {@UniqueConstraint(columnNames={"PROJECT_ID"})})

    public class Project implements Serializable {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name="PROJECT_ID")
    private int id;
    public void setId(int id) {
    this.id = id;
    }

    @Column(name="PROJECT_NAME")
    private String projectName;
    .
    }Is this what you are referring to? If so, it did not make any difference. Otherwise, are you referring to placing uniqueness constraint on the primary columns of the jointTable EMPLOYEE_PROJECT which I dont know how this could be done.

    Also want to find out whether it is possible to impose uniqueness constraints on non-primary key column such as PROJECT_NAME since primary key PROJECT_ID is incremental, thus will always remain unique. In other word, is JPA capable of determining whether a record is unique based on the value of its primary key only, or the values of the Project entity. e.g. Project A is a name and may include the system date as part of its record.

    Thanks,

    Jack

    DB:2.72:Re: Combining Single Transaction Between Session Bean &Amp; Application Client 1s

    There's a lot of debate as to the best way to define Entity identity in a way that pleases both the entity manager and the rest of the application.
    e.g read through some posts here: http://stackoverflow.com/questions/5031614/the-jpa-hashcode-equals-dilemma
    The main thing is that you understand both strategies (their pros and cons) so that you know what to expect when you use one of those strategies.

  • RELEVANCY SCORE 2.72

    DB:2.72:Disabling Uniqueness Constraint a7


    Hi!

    I have a table with a PK called "ID" and a "Name" field. This field has defined a uniqueness constraint. I need to disable this constraint in order to allow "Name" attribute repeating, and without get rid of table data. I need help!! How can I do this??

    Thanks very much to all!!!

    DB:2.72:Disabling Uniqueness Constraint a7

    I think Carlos wants to drop the UNIQUE constraint on the name column, not the primary key constraint.

    If that is the case, he will need to know the name of the constraint (by querying user_cons_columns) and issuing:

    ALTER TABLE table_name DROP CONSTRAINT constraint_name;

    And, if incapable of querying the dictionary, then using DBA Studio to drill down graphically to the constraint and clicking the checkbox to disable it.

  • RELEVANCY SCORE 2.72

    DB:2.72:Re: What Is The Best Approach To Trying To Find High Freq Hits In A File? cs


    Is there some sort of unique identifier? Because you could have more than one person with the same name which would mean you would have to check the address to for uniqueness. As Jverd says a map and a count is probably the only way left with what you have. Use some unique key like there first name, last name and house number (which still has some problems) and read them into a buffer reader adding a new object to the map for each new name and increasing a count when the same name/identifier appears more than once.

    DB:2.72:Re: What Is The Best Approach To Trying To Find High Freq Hits In A File? cs

    Continued here:
    http://forum.java.sun.com/thread.jspa?threadID=5181477

  • RELEVANCY SCORE 2.72

    DB:2.72:Uniqueness And If For Computed Column 98


    I have 2 questions and would like to ask1. I have a table TABLE[ID,Buyer, Item]I would like to add a constraint that buyer can have multiple item but with quality of 1 only. For example,1 John Pen2. John Pencil3. John Book4. Kerry Pen5. Kerry CD-======== the one below is not correct:1. John Pen2. John Pen Reason: John cannot buy 2 Pen3. John Book4. Kerry Pen5. Kerry CDThe only uniqueness I know is the unique when creating the field of the table, I cannot do this kind of uniqueness. How could I do this one?2. This question is related to IF when creating calculated column,I have a table Member[ExpirationDate, ExpiredYesNO]If the ExpirationDate datenow then ExpiredYesNO = TrueElseif ExpiredYesNO = False.With the help of a forum member, I could create simple computed column but with IF I could not

    DB:2.72:Uniqueness And If For Computed Column 98

    orcreate table #t(id int identity, Val varchar(50), UniqueFlag bit, [Key] as id*UniqueFlag unique)insert into #t select 'John', 1insert into #t select 'John', 1insert into #t select 'Kerry', 0insert into #t select 'Kerry', 0select * from #tdrop table #thttp://www.t-sql.ru

  • RELEVANCY SCORE 2.72

    DB:2.72:Re: Oim 11g : Modify Self Registration Form Page 3s


    Which version of OIM 11g are you using ?

    In OIM 11.1.1.5.0, we have a system property:

    Whether or not email should be validated for uniqueness

    This property is available in an Oracle Identity Manager 11g Release 1 (11.1.1) deployment that has been upgraded from an earlier release of Oracle Identity Manager.If the value of this property is FALSE, then Email Uniqueness check is not performed by Oracle Identity Manager.
    If the value if TRUE, then Email Uniqueness check is performed by Oracle Identity Manager. Note: If this property is not present, then Email Uniqueness check is performed by Oracle Identity Manager.

    OIM.EmailUniqueCheck

    TRUE

    DB:2.72:Re: Oim 11g : Modify Self Registration Form Page 3s

    Hi Raghav,

    I tried to create plugin by removing the ValidateEmailID() then modify SelfCreateUserRequest.xml.
    But still didn't work..

    Can you tell me the details please?

    Thank you,

    Ivan P.

  • RELEVANCY SCORE 2.71

    DB:2.71:Hashcode Uniqueness For Strings mx


    Hi,
    Is the hash code returned by String.hashcode() method unique for all Strings?? If it is not unique, up to what length of string the uniqueness can be ensured??

    Your help is greatly appreciated,

    Thanks and Regards,
    k.s.sridhar

    DB:2.71:Hashcode Uniqueness For Strings mx

    Characters in Java are 2 bytes, so the limit on
    uniques hashcodes (theoretically) is 2 characters.In the case of the Java primitive type char you're right of course but I clearly stated I was talking about one-byte characters in general and then I'm right. Characters represented with one byte is still a common situation and the fact that the Java char holds two bytes doesn't change that. So when dealing with one-byte chacters why waste half the available space in the hashcode for storing two 0 bytes?

    Conclusion: You can create a unique int hashcode from a string of up to 4 one-byte characters.

  • RELEVANCY SCORE 2.71

    DB:2.71:How Do I Setup An Attribute To Be Unique In A Resource Type? mf


    I have created a new Resource Type in FIM. I want each resource to be unique. How can I do that?I have noticed that a check is performed for uniqueness of a user. Accountname + Domain must be unique.

  • RELEVANCY SCORE 2.71

    DB:2.71:Checking For The Uniqueness Of That Record ... 3m


    Hello,

    I created a User table and created Entity Class for it and prepared a controller class for user bean. there is a "create" method in the controller class which persists the user bean to the database and returns an action string for the nagivation. but I think I should check for the uniqueness of the user before persisting it. what's the proper way for doing this kind of things(I mean db-side validation) in JSF?

    Thanks

    DB:2.71:Checking For The Uniqueness Of That Record ... 3m

    This has nothing to do with JSF. You should post this question in the EJB forums.