how to execute qcmdexc in rpgle?plz write code also?
I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?
How to resolve -502 sql code in DB2?
What is null indicator in db2?
How can deadlocks be resolved?
how to identify the pseudo conversation by seeing the program
How do you prepare a COBOL + DB2 program from coading till execution ?
Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
List some fields from sqlca?
What is host variable in db2 cobol?
Q3. How will you fetch duplicate values from a DB2 table?
What is the use of commit in db2?