ranganath

• Jan 17th, 2006

 

in what situatons we use search and search all verbs and where can we use it in emabadded sql.

Nabin Chandra Sahu

• Mar 15th, 2006

 

I think no. Because search and search all is used only for array or table and we can,t use array or table application in embedded sql.

pradeepshan

 Profile Answers by pradeepshan 

• Apr 9th, 2006

 

how do you say it can not be , can you justify ?

Kiran

• Apr 17th, 2006

 

Hi,

No we can't use it.

krishna rao

• Apr 29th, 2006

 

 How it is possible? search and search all are cobol verbs . how it is possible in db2.it is not possible in embedded sql.

kapil vharande

• Jun 5th, 2006

 

We cant use search & searchall in embedded sql.

Senijor Mastrojani

 Profile Answers by Senijor Mastrojani 

• Oct 24th, 2006

 

search and search all are cobol reserved words.

sequal will not recognize them wether it's embeded or not.

moreover it makes no sence for instance to fetch everything onto file and than use search or search-all when from database you can select anything randomly.

TheMadProfessor

 Profile Answers by TheMadProfessor 

• Oct 12th, 2009

 

SEARCH and SEARCH ALL are only used for tables within the program and have nothing to do with SQL. SQL is used for queries and other such functions on external relational tables maintained by a DBMS.