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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
hi all, input TAB1 COL1
hi all, input TAB1 COL1 --- AAA BBB CCC How can i obtain the follow output with a SELECT maybe CASE? TAB1 COL1 --- CCC AAA BBB thanks in advance, bye -
update subselect
hi all, input TAB1 COL1 COL2 COL3 COL4 AAA 1 A1 1 AAA 2 A2 1 AAA 3 A3 0 BBB 9 A1 1 BBB 99 A2 1 BBB 999 A3 0 How can i obtain the follow output with an update ? output TAB1 COL1 COL2 COL3 COL4 AAA 9 A1 1 AAA 99 A2 1... -
sqlcode -802
hi all, i get sqlcode -802 from this UPDATE: UPDATE taba SET afield1 = 'S' WHERE afield2 = 'I' AND afield3 IN (SELECT bfield3 FROM tabb WHERE bfield1 IN ( SELECT... -
extract rows with characters in char field
hi ALL, is there a way in sql to find a character in a column that is defined char but can contain only numbers? example: columnA '001' '002' 'R03' I need to extract just 'R03' THANKS in advance bye -
group by without max
hi all, can i select all rows from a table where there are more rows with the same column A and i don't want to extract column A with the hight column b when there are more equal rows for columns A. example column a column b a 1 b 2 c 3 c 4 d 5 d... -
as400 job cl time
hi, anyone know how to see duration of a CL job in AS400 ? thanks bye- gdg1976
- Thread
- Replies: 1
- Forum: RPG (Report Program Generator)
-
db2 sql extract double rows (different in case sensitive)
hi all, how can i extrac from a table only equal rows that are diffent just for case sensitive? exsample table1 col1 ------ MARK mark PAUL paul john ALEX I would like to select and extract only these rows: MARK mark PAUL paul thanks for any idea bye
