Technology Questions

Use SELECT DISTINCT ..... in DB2 query

The DISTINCT keyword can be used to return only distinct (different) values.

Syntax:

     SELECT DISTINCT column1,column2

      FROM table_name;

MainMenu component is a component that allows the display of Menus at runtime on a form.

Process of creating Menu using MainMenu Component:

a. Add MainMenu component on Windows Form.

b. Menu designer allows deciding the structure of the main menu by selecting the Type Here area and adding the Menu Items to be displayed on the menu.

c. Add functionality to Menu Items as required

In Visual Basic, the basic syntax of a LINQ query starts with the From clause and ends with the Select or Group By clause. In addition, you can use the Where, Order By, and Order By Descending clauses to perform additional functions, such as filtering data and generating the data in a specific order.

In C#, the basic syntax of a LINQ query starts with the From clause and ends with the Select or group by clause. In addition, you can use the where, orderby, and Orderby descending clauses to perform additional functions, such as filtering data and generating the data in a specific order.

The object need to be serialized when it’s sent over a network and when it’s state is saved. Exceptions which occur during serialization are:

a. transient fields

b. when the base class is serialized then only base class fields are handled.

c. static fields are ignored because they are not part of any state.

Hub is device to connect two devices, switch is a network bridge which processes and routes data approirately over network layer of OSI Reference model

bcoz the static method does not contains the 'this' reference.

CURSOR STABILITY:

- CS is a row level locking

- Acquires an exclusive lock on the row that is to be updated

- When the control is moved to the next updatable row, the lock is released

REPEATABLE READ:

- RR is a page level locking

- Acquires an exclusive lock on the entire page which is the source of row availability

- When the control is moved to the next updatable page the lock is released

LSMW is widely used by EDI programmers. EDI Programmers connect the SAP system to Non SAP system. During this Data migration is a necessity. When data migrates from source to destination the destination code is differrent from the source code. So what LSMW does is 

* Converts the data in to batch files

* Then converts the batch files in to source code batch files 

* And then mirgates data. Standard Interfaces like BAPI or Idoc are used in this process.