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
- 10184 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 the error code -803 ?
What are PACKAGES ?
What is performance tuning db2?
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
Where do you specify them?
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
When the like statement is used?
What is cursor stability?
how to u check the query is executing or not ?where will u check for sqlcode ?
What is a db2 schema?
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
How do I delete a column in db2?
COBOL 
