1
  • Update duplicate record in rpgle

    I have a file where in filed1, field2 and field3 are key fields. Now these key fields are not unique, I need to update field 4, 5 and 6 based on the selection by user via subfile. To say f1 f2 f3 f4 f5 f6 A0123 A0123A *FILE CLM/D07 D07 1 A0123 A0123A *FILE CLM/D08 D08 2 A0123 A0123A *FILE CLM/D05...

    nasrunisar55 pointsBadges:
  • Subfile in As400

    Hi below pasted is my code which i am running but i am getting an error 'Attemp to write duplicate records" DDS A*                                                        ...

    Sangay635 pointsBadges:
  • Updating common files in different document libraries in Sharepoint 2007

    Is it possible to have two separate instances of one file in two different document libraries, but when one of them gets updated, have those updates pushed to the other copy in a different document library? If it is, could someone tell me how to accomplish this? Thank you.

    Marcpritchard5 pointsBadges:
  • Why are duplicate files being created in Lotus Approach 2000?

    We work with several employees we just recently noticed that we have been creating files with the same information why would this happen? we search the system by Date of Birth and social Security to avoid it but it still happens I've thought we maybe have more than one database or window open at...

    Yamizite5 pointsBadges:
  • Duplicate e-mails in my sent folder – Outlook 2010

    I just started using Outlook 2010.  For some reason, I am getting duplicate entries in my sent folder for each e-mail that I send.  How do I correct this?

    Gini10 pointsBadges:
  • RPG 3 duplicate record error handler

    The physical file has a field keyed and unique. If i want to update these to RPG 3 program it is showing a duplicate record error. Does anybody have solution? tell me the command to handle this error only for RPG 3.

    Shankey5 pointsBadges:
  • Duplicate Records

    Help - My query is returning duplicate records.  How do I eliminate that?  In addition, how can I total the adjustment amount and report one record?  Here's the query: SELECT Distinct "T16.GNAM".N_NAME, "T16.GNAM".N_CITY, "T16.CADJ".AD_TOTAL_ADJUSTMENT, "T16.CRDC".RD_COMMENT    FROM...

    lorit365 pointsBadges:
  • Delete duplicate values in Microsoft Access

    there was a ms access database in which there 3 to 4 values same so i want to delete the values keeping only one value. so i need a query.

    Kimidiramana30 pointsBadges:
  • Single Page subfile for duplicate records

    Can you please tell me the how to handle the pageup & pagedown in single page subfile ....(In Physical file keyfield have douplicate records e.g. Douplicate Policy Number )

    S2235 pointsBadges:
  • Microsoft Excel – I need to find rows that match a user entered entries and sum results of column b

    I have a spread sheet that looks like this Project Well Hours Lewis 1 12 Lewis 2 3 Lewis 1 9 I want to find all the rows that match a user inputed name (in this case 'Lewis'), then add the numbers in column c labeled 'hours', if the sum equals 24 then no problem, but if the sum does not equal 24...

    Ksaep0420 pointsBadges:
  • AS/400 QADBIFLD error Duplicate Record Key?

    The AS400 job QDBSRVXR2 has system error message Duplicate Record in QADBIFLD. I am aware this is a system cross reference file. (System is doing an automatic reply of C and then tries again) Is this file now corrupt ? Would an IPL help ? Reclaim Storage ? What is causing this error. (System is...

    Rockgirl20 pointsBadges:
  • How to get the duplicate records using RPG/400

    Please advice how to get the duplicate records using rpg/400.

    Askt1140 pointsBadges:
  • Duplicating records in a table with a SQL query

    How can I duplicate every record in a table with a query in SQL?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Crystal Reports – Duplicating labels

    I need to print x number of labels from a table labels. The field numlabel specifies the number of labels I should print for each record. I tried with an alias and the != join.. but not working properly. Is there a way to duplicate records on crystal reports with functions or.. ?

    Kcastillo15 pointsBadges:
  • Fastest “get duplicates” SQL

    What is an example of a fast SQL to get duplicates in datasets with hundreds of thousands of records. I typically use something like: select afield1, afield2 from afile a where 1 < (select count(afield1) from afile b where a.afield1 = b.afield1);

    Mm201010 pointsBadges:
  • Help finding duplicate info in Excel in different columns

    Hi, I have an excel spreadsheet that looks like below: Origin Store1 Store2 Percent Source Warren 12345 45678 2.45 b Warren 45678 12345 2.45 r I want to be able to recognize and delete one of these rows as a duplicate. The info is the same just in a different column whether it be Store1 or Store2,...

    Hmstacco20 pointsBadges:
  • SQL

    I have some duplicate rows in my SQL database table, Please Tell me how'll delete duplicate

    Badrugts5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following