Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


where will u check for sqlcode ?

Answers were Sorted based on User's Feedback



where will u check for sqlcode ?..

Answer / shaan

Be sure to include sqlca in working storage section.
Then you can check sqlcode from the copybook variable SQLCODE.

Is This Answer Correct ?    15 Yes 0 No

where will u check for sqlcode ?..

Answer / guru

If you dont include SQLCA, Define SQLCODE and SQLSTATE as
working storage variables and This will suffice

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More DB2 Interview Questions

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

0 Answers  


Is ibm db2 open source?

0 Answers  


If I have a view which is a join of two or more tables, can this view be updatable?

3 Answers  


Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam

1 Answers   Mphasis,


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?

0 Answers   TATA,


How to execute stored procedure in db2 command editor?

0 Answers  


How would one remove old reorg information from the DB2 catalog?

2 Answers  


What is a recovery log?

1 Answers  


What is a buffer pool?

2 Answers  


what is the difference between where clause and having clause

2 Answers   IBM,


Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

1 Answers  


What is the difference between a package and a plan?

6 Answers   Infosys, L&T, Mphasis,


Categories