can we use search and search all in embedded sql

bhuvana_veera · New User Joined: 10 Oct 2005 Posts: 5

khamarutheen · Active Member Joined: 23 Aug 2005 Posts: 677 Location: NJ

Hi bhuvana,

I think Search and Search all is COBOL Commands?????

sbalajibe · New User Joined: 15 Aug 2005 Posts: 62

Hi Bhuvana,

I Thing u r confusing with the term table

search and search all is used to find data in cobol table ie cobol array which is defined in the cobol application program using occurs clause

sql is used to retrieve data from DB2 tables
u can use where clause to sql to find the data in DB2

thanks
Balaji

bhuvana_veera · New User Joined: 10 Oct 2005 Posts: 5

Hi

Thank you for ur valuable information

Regards
Bhuvana