Interested to Buy Any Domain ? << Click Here >> for more details...
What is the syntax of SELECT statement when embedded in a
COBOL program?
- 2 Answers
- 9913 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sivakumar sekharannair
EXEC SQL
SELECT
EMPNAME
INTO : HS-EMPNAME(Host variable)
FROM EMPTABLE
WHERE
EMPID = :HS-EMPID(Host variable)
END-EXEC.
| Is This Answer Correct ? | 17 Yes | 1 No |
Answer / guest
EXEC SQL
SELECT STATEMENT : HOST VARIABLE NAME
END-EXEC.
| Is This Answer Correct ? | 3 Yes | 6 No |
What is a db2 table?
how to resolve -805 . how to see dbrm and package not found
What is data manager?
Name the lockable units in DB2?
What does an outer join do?
Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
How do I delete a table in database?
in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?
COBOL 
