How can the firstname and the lastname from the emp table be concatenated to generate complete names?
No Answer is Posted For this Question
Be the First to Post Answer
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
What is explain plan in db2?
What is runstats db2?
What is the maximum number of columns in a db2 table?
How to view db2 table structure?
Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......
What is REORG? When is it used?
What is the difference between primary key & unique index ?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is sqlcode -811?
7 Answers Accenture, CTS, TCS,
What is with ur in db2?
What is COPY PENDING status?