which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
2 8233I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
10 43942In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
2 5105How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?
6 59724. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
3 5724if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
8 5974Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA
8 21770i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?
8 7827Post New Wipro DB2 Interview Questions
Is there Disqualification of Auditor u/s 139 of Companies Act 2013 if the auditor is indebted towards the company to be appointed as an auditor, if amount exceeds more than Rs.1000 as against the provision related to Companies Act, 1956 ?
Program to check whether a word is a sub-string or not of a string typed
Encapsulation of attributes and operations inside objects makes it easy to obtain object state information during testing. is it true.explain
What is replication difference between wi2k and win2k3 replication?
how many maximum session supports to multiload in teradata ??
What is the process to change the files at arbitrary locations in HDFS?
Which sex(es) of flowers in the Cucurbitaceae have nectary disks? Why?
Why rdt and thermocouple both give different output .and one things more, how to generate ohm or mili volt plz mail me merajalam143545@yahoo.com
I am importing dc-dc converters from singapore to india. how much tax will be applicable towards Custom duty.and the rates of the custom duty.
How to detect the computer name?
If gas turbine is operating on part load, how droop will affect the output with respect to frequency.
why we have to use particular buffer only for dissolution instead of using cheap buffer.
The lowest allowable insulation resistance?
What other TCP setting can you modify besides MTU to shorten packets
How to transfer request which is created directly on quality server & has to be moved to in production server?
- C (153)
- STL (10)
- OOPS (37)
- C++ General (30)
- MFC (5)
- COM DCOM (1)
- Win32API (1)
- Delphi (4)
- PHP (13)
- Programming Languages AllOther (18)
- ASP (1)
- CGI Perl (3)
- JavaScript (5)
- VB Script (4)
- JSP (2)
- Shell Script (11)
- Tcl (1)
- AJAX (2)
- Scripts AllOther (2)
- SNMP (6)
- TCP IP (10)
- UDP (2)
- SS7 (1)
- Protocols AllOther (9)
- Networking Administration (27)
- Networking Security (5)
- Networking AllOther (13)
- Visual Basic (14)
- C Sharp (51)
- ASP.NET (61)
- VB.NET (2)
- ADO.NET (9)
- IIS (7)
- Crystal Reports (2)
- Dot Net Framework (4)
- Dot Net WindowsForms (12)
- Dot Net General (21)
- Dot Net AllOther (2)
- Exchange Server (14)
- WCF (1)
- Microsoft Related AllOther (6)
- Oracle General (46)
- OCI (1)
- Database Management (7)
- Forms Reports (3)
- Oracle AllOther (5)
- SQL Server (59)
- MS Access (2)
- MySQL (5)
- Postgre (1)
- DB Architecture (2)
- DB Administration (4)
- DB Development (1)
- SQL PLSQL (22)
- Databases AllOther (5)
- SDK (2)
- Windows Threads (2)
- Windows General (5)
- Windows AllOther (15)
- Linux Commands (15)
- Linux Threads (1)
- Linux System Calls (8)
- Linux General (4)
- Linux AllOther (4)
- Unix Commands (12)
- Unix Socket Programming (1)
- Unix General (2)
- Unix AllOther (3)
- Solaris Commands (24)
- Solaris System Calls (2)
- Solaris General (72)
- Solaris AllOther (13)
- Vxworks (3)
- RTOS AllOther (1)
- Operating Systems General Concepts (14)
- Data Structures (9)
- Operating Systems AllOther (4)
- WinRunner (15)
- Load Runner (19)
- QTP (144)
- Test Director (2)
- Rational TestSuite (2)
- Silk Test (1)
- Automation Testing AllOther (4)
- Manual Testing (195)
- QA Concepts (8)
- Mobile Testing (2)
- Test Cases (19)
- Test Documents Reporting (2)
- Testing AllOther (11)
- Servers AllOther (4)
- COBOL (31)
- JCL (26)
- CICS (4) DB2 (13)
- IMS (2)
- REXX (2)
- Assembler (1)
- MVS (2)
- VSAM (1)
- QSAM (1)
- IBM MainFrame AllOther (3)
- RPG400 (7)
- DB400 (1)
- COOLPLEX (1)
- IBM AS400 AllOther (7)
- Core Java (91)
- Advanced Java (20)
- Swing (4)
- EJB (8)
- Servlets (8)
- Struts (29)
- JDBC (18)
- J2EE (4)
- Weblogic (11)
- Websphere (1)
- Java Networking (3)
- Java J2EE AllOther (2)
- J2ME (4)
- Java Related AllOther (2)
- MQSeries (1)
- Middleware AllOther (4)
- HTML DHTML (1)
- XML XSLT RSS (2)
- Flash Action Scripting (1)
- Web Related AllOther (1)
- Teradata (21)
- Business Objects (40)
- Cognos (32)
- Informatica (92)
- Ab Initio (9)
- Data Stage (43)
- SAS (9)
- ETL (2)
- Data Warehouse General (4)
- HR Questions (34)
- Design Patterns (6)
- OOAD (3)
- Software Design Tools (2)
- Requirements Management (2)
- Project Planning (3)
- Project Management (4)
- Software Design AllOther (2)
- Debugging AllOther (3)
- Clear Case (2)
- Telecom Routers Switches (1)
- Telecom Protocols (2)
- Voice Gateways (1)
- Telecom Security (1)
- WiFi Protocols (1)
- BlueTooth (3)
- Telecom General (1)
- SAP Basis (31)
- SAP ABAP (108)
- SAPScript (4)
- SAP SD (112)
- SAP MM (21)
- SAP QM (1)
- SAP PP (18)
- SAP FI CO (74)
- SAP HR (30)
- SAP CRM (59)
- SAP SRM (1)
- SAP APO (2)
- SAP Business Warehouse (6)
- SAP Business Workflow (3)
- SAP Security (10)
- SAP ALE IDocs (1)
- SAP B1 (5)
- SAP AllOther (2)
- PeopleSoft HRMS (1)
- Oracle Apps Technical (28)
- Oracle Apps Financial (27)
- Oracle Apps Manufacturing (3)
- Oracle Apps HRMS (1)
- Oracle Apps SCM (3)
- ERP CRM AllOther (4)
- 86 Family (14)
- VLSI (8)
- Embedded Systems AllOther (1)
- Client Server General (5)
- Client Server AllOther (1)
- AI General (1)
- Encryption Decryption (1)
- Cryptography General (1)
- WebMethods (2)
- TIBCO (11)
- JCAPS (1)
- 3D Animation (1)
- Visual Effects (1)
- Software Integration & Delivery (1)
- Software Integration & Release (1)
- Image Processing General (1)
- Micro Biology (2)
- Bio Chemistry (1)
- Bio Informatics (49)
- Genetics (1)
- Biological Sciences AllOther (1)
- Inorganic Chemistry (2)
- Physical Chemistry (2)
- Pharmacy (1)
- Dermatology (1)
- Gynaecology (1)
- Mathematics (2)
- Civil Engineering (3)
- Mechanical Engineering (16)
- Electrical Engineering (79)
- Electronics Communications (62)
- Aeronautical Engineering (1)
- Bio Engineering (2)
- Instrumentation (3)
- Engineering AllOther (26)
- Business Administration (11)
- Marketing Sales (11)
- Banking Finance (23)
- Human Resources (19)
- Personnel Management (1)
- Infrastructure Management (1)
- IT Management (3)
- Non Technical (2)
- Audit (7)
- CompanyAffairs CS (3)
- Taxation (27)
- Accounting General (44)
- Accounting AllOther (86)
- Advertising Media AllOther (1)
- Call Centre AllOther (310)
- UPSC Political Science (1)
- UPSC History (1)
- UPSC General Studies (2)
- UPSC AllOther (1)
- SSC Geography (1)
- SSC General Science (1)
- SSC General Studies (3)
- SSC AllOther (9)
- RRB (7)
- CDS (1)
- POs (5)
- BSRB Clerical (4)
- BSRB AllOther (1)
- Group I (12)
- Group II History (6)
- Group II AllOther (4)
- APPSC AllOther (13)
- General Knowledge_Current Affairs (30)
- Government AllOther (10)
- Law AllOther (1)
- Teaching (5)
- Funny Interview Questions (5)
- Everything Else AllOther (19)
- English (20)
- General Aptitude (106)
- Puzzles (21)
- Placement Papers (31)
- CCNA (47)
- Microsoft Certifications (15)
- Sun Certifications (2)
- CISA Certification (1)
- Oracle Certifications (4)
- Certifications AllOther (3)
- H1B Visa (8)
- USA Student Visa F1 Visa (2)
- L1 Visa (1)
- USA Visitor Visa B2 Visa (2)
- USA Business Visa B1 Visa (1)
- USA Dependent Visa H4 Visa (6)
- USA AllOther Visa (1)
- UK Visa (1)
- Australia Visa (2)
- Canada Visa (1)
- C Code (20)
- C++ Code (3)
- J2SE Code (1)
- ASP.NET Code (2)
- C Sharp Code (2)
- Visual Basic Code (1)
- Programming Code AllOther (1)
- PHP Code (2)
- JSP Code (1)
- JavaScript Code (1)
- VB Script Code (1)
- GATE (5)
- CAT (1)
- MAT (1)
- GMAT (3)
- AIIMS (1)
- ICET (4)
- C C++ Errors (2)
- Oracle Errors (9)
- SQLServer Errors (1)
- Scripts Errors (2)
