What is the difference between SYNONYM and ALIAS?6 18931
What information can you find in SYSIBM.SYSLINKS table?1 6127
What is the difference between IN subselects and EXISTS subselect?1 7653
What technique is used to retrieve data from more than one table in a single SQL statement?9 8388
what is the maximum number of tables that can be joined ?8 12545
What are simple, segmented and partitioned table spaces ?1 9555
What is the difference between group by and order by?2 11173
What is sqlcode -811?7 56676
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.7 51042
why should we bind the DB2 program . What if we did not BIND a BD2 program ??9 26383
db2 query I have one table with the following details. SNO SNAME DOJ ------ -------------------- ---------- 10 KRISH 2007-03-19 20 REDDY 2007-05-19 30 RRRRR 2007-05-19 40 BBBBB 2008-05-19 50 CCCCC 2009-05-19 60 JJJJJ 2009-05-19 70 JJJJJ 2004-05-19 i want the output in the following format:( no of students joined in each year(no nedd to consider about month and date) year count --------- ---------- 2004 1 2007 3 2008 1 2009 29 7008
Bind concepts in DB2 cobol10 21977
what is the difference between normal select query and currosor2 12939
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic2 6522
what is dynamic cursor?gives syntax for this?1 2765
1. for eg, capacitor is used for many purposes(it act as filter, oscillator, bypass capacitor, memory storage etc...) 2. Please tell me some example circuits for different uses of capacitor( whenever and whereever and however we used capacitor as a filter, oscillator tuning etc..) 3. similarly for inductor and resistors(it act as what?) and when and how we want to act as like that?, and how we can used these components depends upon our requirments with example circuits and explanation? design to act as these components depends
What is Morphological smoothing?
How to make control on vendor master data (bank account ) . We can validate the changes with transactions FK08 & FK09 in functional menu , but I need the path on Spro guide to customize the changes (bank accounts )
what is mppt (maximum power point tracking ) and how they used in solar power generation ??? what are the main components used in mppt?????
What are register in India localisation?
Have you worked on any Functional Specification doc recently? Have you done any development work/ assignment recently? The Interviewer asked me this question in an recent interview. Please give examples from your real time/ live data project along with detailed procedure/ work mechanism and explanation along with path and t-codes if any? Please answer this question asap.... Its Urgent.... Looking forward for your express reply...I have interview within 1-2 days. So, give reply to this query asap.. I would be very grateful to you for your timely help.Thanks in advance. Regards
what is the basic use of power plant in equipment
How to generate QA Report for all contracts?
Pls tell me whether we can use EN3A material for shafts of Permanent magnet alternator.What will be the effect of magnetic and nonmagnetic material for shafts on magnetic properties of PM rotor .
Hi guys, If anyone have gone through the CAPITAL IQ-Junior Research Associate interview then plz let me know about its pattern..and if anyone hav its placement papers or any other information then plz post to me at firstname.lastname@example.org
In the calculation of calorific value of any fuel why the latent heat of vap. of water is taken as 587 kj/mol whereas actually it is 540kj/mol?
What is the effect on 3phase induction motor if current setting knob of DOL kept at minimum current?
how to idetfy which test cases are automated?who will deside that plz tell me
Hi 1)What is the maximum permissible exchange deviation in your project? 2)What is the most typical problem that you have been faced in supporting as well as implementation? 3)How you see dunning notice output?
Instrumentation symbols interpration, P& ID, Logic diagram analysis, Electrical drawing analysis.