Retrieve data from nullable column

SMRAJAESWARI · New User Joined: 07 Jul 2005 Posts: 10

Hello Friends,

Pls let me know the answer for these questions.

1) How to retrieve data from a nullable column?. Give me the syntax?.

2) How can you manually commit or rollback data in DB2?.

Regards,
S.M.Rajaeswari.

simimathew · New User Joined: 26 Jan 2006 Posts: 23 Location: London

Data retrieval from nullable column has already been discussed. Please see www.ibmmainframes.com/viewtopic.php?t=10469&highlight=null+column

hanu_010 · New User Joined: 25 Jan 2007 Posts: 9 Location: hyd

SELECT CNO FROM TABLE1 WHERE CNO IS NULL

hanu_010 · New User Joined: 25 Jan 2007 Posts: 9 Location: hyd

IF SQL CODE = '00'

EXEC SQL
COMMIT
END-EXEC

EXEC SQL
ROLLBACK

END-EXEC