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
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's The Error Code For Unique Index Voilation?
What is concurrency?
What is the difference between cursor and select statement?
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?
What is db2 bind process?
What are types of indexes?
What is db2 command?
What are db2 tables?
What is commit in db2?
Outputs of explain are with matchcols = 0. What does this signify?
Explain the function of data manager.
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is innodb buffer pool?
What is deadlock in db2?
What is package in db2 mainframe?