Here in this article we shall learn to create ODBC data sources that will be used as drivers in connecting to databases like oracle or sql servers.

Click here to see how to create data source for oracle database in control panel.

After this is done, you will be able to use this data source in your front end program(Java, VB.net etc). Click here to see the JDBC connectivity if you have already created data source.

To create a data source, Go ... Read more »

Here in this article we shall learn to create ODBC data sources that will be used as drivers in connecting to databases like MS access or oracle.

Click here to see how to create data source for oracle database in control panel.

After this is done, you will be able to use this data source in your front end program(Java, VB.net etc). Click here to see JDBC connectivity if you have already created data source.

To create a data source, Go to Control Panlel--> Administrative Tools and then click on Data sources.

Hello Engineers,

I have seen candidates struggling a lot while making a first time connection to a database(Oracle, MS access etc) using Java or any other front end technology. That is why I have added this article to make it simple and fast.

In this article we will learm how to connect to MS access database(*.accdb, *.mdb) using java program.

Before conneting to MS access database, you need to create data source in Control panel. Follow this llink to create data source in Control Panel >>Administrative Tools for MS access database.

Once the data source is created, we will move to the coding p ... Read more »

shift - shift command is used to shift positional parameters

FORMAT
       shift [n]

DESCRIPTION
       The positional parameters can be shifted using this command. Positional parameter 1 shall be assigned the value of parameter (1+n), parameter 2 shall be assigned  the     value of parameter (2+n), and so on.

The parameters represented by the numbers "$#" down to "$#-n+1" shall be unset, and the parameter '#' is updated to reflect the new number of positional parameters.

       The value n shall be an unsigned decimal integer less ... Read more »

Many times we want to send a mail to someone at a specific time but not now. Due to some reasons, we want to the mail to be sent after some mins or hours.

In this article we will learn how can we schedule a mail in MS Outlook to be delivered at certain time in future!

Its very simple. First of all create the mail/message that you want to send later. Now follow below steps:

1. Go to Options tab at the top.
2. Then, go to More Options section and click on Delay Delivery.
3. You will get below dialog:

... Read more »

XARGS - build and execute command lines from standard input or on the output of previous command

FORMAT
       xargs  [-0prtx]  [-E  eof-str]  [-e[eof-str]]  [--eof[=eof-str]]  [--null]  [-d delimiter] [--delimiter delimiter] [-I replace-str] [-i[replace-str]] [--replace[=replace-str]] [-n max-args] [--max-args=max-args]   [--arg-file=file] [command [initial-arguments]]

DESCRIPTION
       xargs reads items from the standard input line by line, delimited by blanks (which can  be protected  with  double  or  single quotes or a backslash) or newlines, and executes the command (default is /bin/ech ... Read more »

Its very strange and delightful to see that when you press F9 in side vi editor, a backup copy of the file is created or when you press F8, the xml file is formatted in readable form.

It is always useful when we map certain keys usually function keys inside VI editor to make our work easy.
 

In this very article, we shall learn how to map keyboard keys inside vi editor to execute certain commands.

The basic syntax to create mapping is:

cmd attribute lhs rhs

• cmd           :map, :map!, :unmap, :unmap!,
• a ... Read more »

CUT- Remove sections from each line of files vertically. This command basically cuts the file vertically and returns a certain field from each line from a file.

FORMAT
       cut [OPTION]... [FILE]...

DESCRIPTION
       Print selected parts of lines from each FILE to standard output.

       Mandatory arguments to long options are mandatory for short options too.

       -b, --bytes=LIST
              select only these bytes

We are using below file for demo:

pidstat - Report statistics for Linux tasks/processes.

FORMAT
       pidstat [ -C comm ] [ -d ] [ -I ] [ -p { pid | SELF | ALL } ] [ -r ] [ -t ] [ -T { TASK | CHILD | ALL } ] [ -u ] [ -V ] [ -w ] [ interval [ count ] ]

DESCRIPTION
       The pidstat command is used for monitoring individual tasks currently being managed by the Linux kernel.  

It writes to standard output activities for every  task  selected with option -p or for every task managed by the Linux kernel if option -p ALL has been used.

Not selecting any tasks is equivalent to specifying -p ALL but only active tasks (tasks with non-zero statistics values) ... Read more »

grep, egrep, fgrep - print lines matching a pattern given

FORMAT
       grep [options] PATTERN [FILE...]
       grep [options] [-e PATTERN | -f FILE] [FILE...]

DESCRIPTION
       Grep  searches the named input FILEs (or standard input if no files are named, or the file name - is given) for lines containing a match to the given PATTERN.
       By default, grep prints the matching lines.

In addition, two variant programs egrep and fgrep are available.  

• Egrep is the same as grep -E.  
• Fgrep is the same as grep -F.