Interested to Buy Any Domain ? << Click Here >> for more details...
If there is no row in Emp table with Ename as Raghava and
you run the below queries in SPUFI.
1.select Ename from EMP wher Ename = 'raghava'
2.Select count(*) from EMP where Ename = 'raghava'
What is SQLCODE shown up in SPUFI
- 4 Answers
- 9971 Views
- ADP, I also Faced
- E-Mail Answers
Answer Posted / guest
For 1st query the sql code will +100
for second query the count is zero and sql code is 0
| Is This Answer Correct ? | 30 Yes | 3 No |
Post New Answer View All Answers
What is the cobol picture clause of the db2 data types date, time, timestamp?
How to find primary key of a table in db2?
If I have a view which is a join of two or more tables, can this view be updateable?
How can deadlocks be resolved?
What is buffer pool and list some of them?
What is commit in db2?
What is blu acceleration in db2?
What is dbrm? What it contains?
Explain db2.
What is the latest version of ibm db2?
What is lock escalation in db2?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is the difference between cursor and select statement?
What do you mean by between and in? Is between inclusive of specified range values?
