0 pts.
POSTED: Apr 1, 2005 8:18 AM (GMT)
or more efficiently
Update FileA A
set (FldX, FldY)=
(select BFldX, BFldY from FileB where BKeyB = A.KeyB)
AS/400 SQL V5R2 -- updating new fields in a file with values from a different file
I added 2 fields to FileA (FldX and FldY)
FileA has the key to FileB (KeyB) where these values exist.
FileA: FldA, FldB, KeyB, new... FldX, FldY
FileB: BKeyB, BFldX, BFldY
This is probably simple for someone that composes SQL all the time but I'm having trouble coming up with acceptable syntax...
Thanks for any help you can provide...
Dave
FileA has the key to FileB (KeyB) where these values exist.
FileA: FldA, FldB, KeyB, new... FldX, FldY
FileB: BKeyB, BFldX, BFldY
This is probably simple for someone that composes SQL all the time but I'm having trouble coming up with acceptable syntax...
Thanks for any help you can provide...
Dave
ASKED:
Mar 31, 2005 10:15 AM GMT
UPDATED:
April 1, 2005 8:18:08 AM GMT
RELATED QUESTIONS
- Move to One Update Program in Cobol
- OVRDBF SHARE(*YES)
- AS/400 - iSeries SQL Update of on table with values from another joined table
- update a field from a file with a field from a selection from two files
- SQL multiple files
- How to handle deletion in RPG
- SETGT and SETLL
- Physical / Logical file definitions
- Conversion of Char to (Negative) Numeric
- SQL Join on multiple columns?
Answer Wiki:
Hi Dave,
You need something like this:
Update FileA set FldX=(select BFldX from FileB where KeyB=BKeyB) , FldY=(select BFldY from FileB where KeyB=BKeyB).
You need something like this:
Update FileA set FldX=(select BFldX from FileB where KeyB=BKeyB) , FldY=(select BFldY from FileB where KeyB=BKeyB).
To see other answers submitted to the Answer Wiki View Answer History.
