Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: heatmiserkmp
- Order by date
-
Need help updating a field based on join of 2 tables
Thank You, Thank You, Thank You!- heatmiserkmp
- Post #7
- Forum: ANSI_SQL
-
Need help updating a field based on join of 2 tables
offxcpp: Seq Pg K Field T Len Fd Dd From To Text 5 1 FXAXCD A 3 1 3 Division Code 10 1 FXA7TX A 6 4 9 BOL Number 15 1 FXIHST A 1 10 10 BoL Type OSJ0CPP: Mbr : OSJ0CPP Scan...- heatmiserkmp
- Post #5
- Forum: ANSI_SQL
-
Need help updating a field based on join of 2 tables
I tried that and am getting the following error: You have entered a subquery that contains a correlation without qualification for: Field. . . . . . . . . . . . .: FXAXCD I am trying this on IBM AS400 DB2 Thanks for any help!- heatmiserkmp
- Post #3
- Forum: ANSI_SQL
-
Update database using a query for DB2
Dont I need to put both table names in the outer select statement?- heatmiserkmp
- Post #3
- Forum: IBM: DB2
-
Need help updating a field based on join of 2 tables
update OSFXCPP set fxxest = 'O' WHERE exists (SELECT * FROM OSJ0CPP, osfxcpp WHERE J0D3DT = 1050427 AND J0AXCD = fxaxcd AND j0a7tx = fxa7tx AND J0AXCD= '409') and FXXEST = 'C' I know I am doing something wrong. I have 2 tables FRT...- heatmiserkmp
- Thread
- Replies: 6
- Forum: ANSI_SQL
-
Update database using a query for DB2
I need to "match up" data from 2 files and then change a field in one of hte files. Here is my statement: update OSFXCPP set fxxest = 'O' where (SELECT J0D3DT, FXAXCD, FXA7TX, FXXEST FROM OSJ0CPP, OSFXCPP WHERE J0D3DT = 1050427 AND...- heatmiserkmp
- Thread
- Replies: 4
- Forum: IBM: DB2
