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:
  • sql update command to update a date-of-birth

    I need to change the date-of-birth MONTH to May and DAYS to 15 without changing the YEAR

    Mji50 pointsBadges:
  • sql update command to change text

    I need to modify all characters within a text field. Some of the fields will contain 2-5 characters, others will contain 20-200 or more. The field is defined as Text 4000. I want to replace every letter with "K" We have a Select statement: select...

    Mji50 pointsBadges:
  • 0 Row affected

    Could you please assist with the following? UPDATE dbo.[Elution_Report_Template] SET [Elutriation_Set_SqM] = dbo.[Elution_Report].[Elutriation_Set_SqM], [Elutriation_Pump_SqM] = dbo.[Elution_Report].[Elutriation_Pump_SqM],

    GPNel200675 pointsBadges:
  • OPNQRYF

    I HAVE A CASE LIKE THIS IN CL/400 OPNQRYF FILE((MADE07/GLM0120)) QRYSLT('(GLFINP *NE + 99) *AND (GLPRDC *EQ "AR" *OR GLPRDC *EQ + "SW" *OR GLPRDC *EQ "WP" *OR GLPRDC *EQ + "LR" *OR GLPRDC *EQ "MD") *and (glbrnc + *eq ("' *CAT %substR(&bc 1 1) *CAT '"))') HERE BC IS A FIELD ON DISPLAY FILE I NEED TO...

    Zilan85 pointsBadges:
  • update a field from a file with a field from a selection from two files

    Hi! When I try this: update fileD d set d.value = (select c.value from (select b.key, b.value from fileB b where b.key not in (select a.key from fileA a)) c where d.key = c.key) I get the message "Null values not allowed in column or variable VALUE." on the other hand, when I do this selection:...

    Mr.70 pointsBadges:
  • Updating Dreamweaver Templates

    Can anyone suggest a reason why my templates are not updating pages based on the template? I create a template in the usual way. Create a page based on the template. I go to the Assets Folder, click on edit. when I edit the template it asks me if I want to update pages based on the template. For...

    Ken10k5 pointsBadges:
  • update single row error

    This query returns a single row error while attempting to update the mfr_name_id in the property table with the values in the eqp_mfr_names table where property.mfrcode = eqp_mfr_names.mfr_code why? UPDATE property p SET (mfr_name_id ) = ( SELECT (mfr_name_id) FROM eqp_mfr_names WHERE mfr_code =...

    Mandrews810 pointsBadges:
  • Problem with Microsoft Update

    Working with an XP SP2 machine, I get notices that updates are ready to download. I choose them manually, but they never download. Next time I'm online, I get the same notices. Any suggestions greatly appreciated.

    NoHa115 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