Interested to Buy Any Domain ? << Click Here >> for more details...
how to u check the query is executing or not ?where will u check for sqlcode ?
- 6 Answers
- 12827 Views
- Infosys, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / lu
OH man...everytime, you execute a sql statement, u have to
check you SQLCODE = 0 or not = 0....this a basic using DB2,
Oracle....
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / arun
If you want to check from DBA point of view.
I would suggest if the query is taking longer time you can
use any of the tools like detector and check how long the
query is running and how much cpu has been allocated to
this thread and how many get pages has been done how many
rows has been selected or inserted or updated.
We have tools to know the current status of the query.
If the query is simple and completes quickly SQL RC = 0 is
for the normal completion of the query
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / anjireddy vintha
RUNTIME SUPERVISER WIL MONITER THE SQL QUERY'S AND IT WILL
GENERATE SQLCODE FOR EVERY EXEUTION OF SQL QUERY.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nithinbalaji mariappan
You need to display SQL-ERR-D variable from SQL CA on your program. It will write a sql error code
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ankit.:-)
before embeding check that command in SPUFI and u will get
the sqlcode value , if it is successful means
sqlcode=0 ,then go for embeding into pgm
| Is This Answer Correct ? | 1 Yes | 2 No |
What is the difference between Primary key and unique index?
How to solve S0C7 abend with out using DISPlay in 10 mins?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
How will you delete duplicate records from a table?
what is main use of table space and index object? please its urgent
5 Answers CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,
How to resolve -917 sql code in DB2?
What are the 2 sqlcodes that are returned?
Give the COBOL definition of a VARCHAR field.
How can we read records for specific member in CL? AND rpg?
What is package versioning? Please give an example.
what is difference between random and sequence file access
What is the picture clause of the null indicator variable?
COBOL 
