Useful System Stored Procedures:

Useful System Stored Procedures:

Lists the number of table in Database
sp_help
To get code for Stored Procedure
sp_helptext 'usp_Load_mntLoadDate'
Who is accessing which database…
sp_who 'CMC\sbaheti'
Verify dependencies for give object,For example we want to know where 'datedim' table is referenced
sp_depends datedim
Deatils of Databse
sp_helpdb DefaultReportStage
Details of all table
sp_tables
Details of particular table
sp_tables 'DateDim'


To rename the object:
Rename table
sp_rename 'AssetDetails','AssetDet'
Rename column
sp_rename 'AssetDet.AssetName','AssetNm'

Correlated SubQueries in DB2

A sub query in which the inner (nested) query refers back to the table in the outer query is called correlated sub queries in DB2.

Correlated sub queries must be evaluated for each qualified row of the outer query that is referred to.

SUDO Access (Redhat vs SUSE Linux)

SUDO Access (Redhat vs SUSE Linux):
RHCE:
1) Create the user
2) Add the user to Wheel group
3) Uncomment the Wheel group entries line in sudoers file.
4) User can able execute root users previledged command by executing sudo followed by the commands

SLES 9:
But in SLES Apart from above steps We have to comment out the following lines inorder to provide SUDO Access to the users.
# Defaults specificationDefaults targetpw # ask for the password of the target user i.e. root

Note:
Without commenting the above lines will ask only the root pwd to allow normal user to get sudo access.

Email won’t go if the destination is over 500 miles

Imagine yourself as a system administrator for a moment and you get a weird call from a user saying that any email that he sends would fail if the destination point is over 500 miles. You'll choke for a moment and you ll call that guy Insane. E-Mails don't have distance or stamps. It goes to whomever it needs to, wherever he is on the face of the earth.

I read a blog of a system admin who went through a smiliar situation and how he ironed out the issue. It definitely wasn't the users fault. At times all it requires to catch serious bugs is a totally new perspective!!

Read more here: http://www.ibiblio.org/harris/500milemail.html?test

Using HashMap

Map is an object that stores key/volume pairs. Given a key, you can find its value. Keys must be unique, but values may be duplicated. The HashMap class provides the primary implementation of the map interface. The HashMap class uses a hash table to implementation of the map interface. This allows the execution time of basic operations, such as get() and put() to be constant.

This code shows the use of HaspMap. In this program HashMap maps the names to account balances.

import java.util.*;
public class HashMapDemo {
public static void main(String[] args) {
HashMap hm = new HashMap();
hm.put("Rohit", new Double(3434.34));
hm.put("Mohit", new Double(123.22));
hm.put("Ashish", new Double(1200.34));
hm.put("Khariwal", new Double(99.34));
hm.put("Pankaj", new Double(-19.34));
Set set = hm.entrySet();
Iterator i = set.iterator();
while(i.hasNext()){
Map.Entry me = (Map.Entry)i.next();
System.out.println(me.getKey() + " : " + me.getValue() );
}
double balance = ((Double)hm.get("Rohit")).doubleValue();
hm.put("Rohit", new Double(balance + 1000));
System.out.println("Rohit new balance : " + hm.get("Rohit"));
}
}

source: java-tips.org

Mainframe and Commonly used Dataset options in SAS

1) FIRSTOBS - Causes processing to begin at a specified observation.
Example : data new (firstobs = 30);

2)OBS - Causes processing to end with the nth observation.
Example : data new (obs = 30);

3)LABEL - Specifies the label for the data set. Example : data new (Label = ‘label for input dataset is not permanent’);

4)WHERE - Selects the observations that match the specified condition.
Example : data new (where = (age ge 45));

5)YEARCUTOFF option
This System option specifies the first year of a 100 year span used by Informats & functions.
Based on this, the century values of dates are determined by SAS system if the year is specified as a two digit year.

The default value is 1920.

If the yearcutoff option is set to 1950 then the value
09/18/49 with MMDDYY8. format will be read as 18th September 2049.
This does not have any effect on year specified in four digits

Stored Procedures

Stored procedures are specialised programs stored in RDBMS. A stored procedure is a named group of SQL statements (and in some cases operating system calls) that have been coded and stored directly in a database.

Stored procedures provide the following advantages:
1) Reduced network traffic
2) Improved performance of server-intensive work
3) Separation and reuse of business logic
4) Access to server features

MDT in CICS

MDT (Modified Data Tag) is one bit of the attribute character. If it is off(0), it indicates that this field has not been modified by the terminal operator. If it is on(1), it indicates that this field has been modified by the operator. Only when MDT is on, will the data of the field be sent by the terminal hardware to the host computer ( i.e., to the application program, in end).
An effective use of MDT drastically reduces the amount of data traffic in the communication line, thereby improving performance significantly. Therefore, BMS maps and CICS application programs should be developed based on careful considerations for MDT.

Proceedure to execute Stored procedures

1) Create the stored procedure.
2) Write the stored procedure.
3) Compile and Bind the stored procedure.
4) Insert a row in SYSIBM.SYSPROCEDURES.
5) Write the Application Program.
6) Compile and Bind the Application program.
7) Run the Application program

Server requirements for deploying a Flex application

Flex or Flash applications are compiled to SWF format. You can deploy SWF file on a normal web server.

SWF files are downloaded on to the the client and will run on the Flash Player. So there are no specific requirements for hosting or deploying a Flex application. A normal web server which is used to deploy a HTML page is sufficient for deploying the SWF files.

In the URL below there is a detailed description on how to deploy a Flex application. You will find very useful.

http://livedocs.adobe.com/flex/3/html/deployingoverview_02.html

How-To: Copy Excel cells into a Word document!!

Just thought of writing about one of the pain points i often come across while working on Excel and Word. Whenever we try to paste some excel cells into Word, the usual problem faced is the loss of formatting. This can be overcome by following the steps mentioned below:

1.Select your cells in Excel, copy (Ctrl+C) then in your Word document, on the Edit menu,
2.click Paste Special
3.Click Microsoft Office Excel Worksheet Object, and then click OK

Note: If you are using word 2007 then press ALT+CTRL+V. This reduces formatting problems between Word and Excel.

Add Language Translation feature to your Blog.

In order to add language translation feature to your Blog or Website, follow the steps below

1.) Point your Browser to Google Translate Tools section. (http://translate.google.com/translate_tools?hl=en)
2.) Select the language of your website or blog. The option you select should be the same as the language of your website, else the translation won’t work properly.
3.) Copy the code from the page and paste it on your webpage whereever you would like to have the language translation feature.

Source: http://technofriends.in/2008/11/23/how-to-add-language-translation-feature-to-your-website-or-blog/

Why Selenium scripts fail when run outside the web server for Selenium Core?

As we know selenium scripts will fail when we place our scripts outside the AUT (Application Under Test) web server for Selenium Core, this is due to the reason that Selenium core is built with DHTML / JavaScript. When we are using javaScript we should bound to Same Origin Policy of JavaScript.

What is Same Origin Policy?
Same origin Policy states that javaScript is only allowed to read / Modify the HTML content from the same origin as source i.e, javaScript can able to read / Modify the HTML only when the source and destination of the scripts are from same web server.

For Example:
Suppose a person is working on crutial page and some unsecured webpage simultaneously which are from different sources. If JavaScript is not bound to same Origin Policy, then the other user / Owner of unsecured web page can access / Modify the content of crutial web page. In order to avoid this JavaScript should be bound to Same Origin Policy.

But when we install Selenium IDE, this acts as a trusted FireFox extension and therefore we can violate the Same Origin Policy.

Java Tokenizing Techniques Comparision

If Performance is a Matters !!!

In this blog I am going to discuss about my experience in measuring the fastness of different Tokenizing techniques in Java.

Tokenizing! The first that comes to our mind is StringTokenizer.

When you google it, the other popular things are Scanner, String.split() .

Scanner can me more handy if we want to split the string based on Regex. Of the above three based on the fastness of tokenizing StringTokenizer wins the race followed by Scanner and split.

Optimistic Concurrency using Hibernate

I came across an interesting but most common use case last week. It goes like this that we need to manage concurrency for the data which are being worked on by multiple users at the same time…Obviously Pessimistic Locking of Database records is not a possible solution as it will affect the performance and scalability of the application.

When looking for a solution, straight away the answer could be that the Framework / ORM has to provide some mechanism to control.

Luckily the use case we are working on is using Hibernate and we ought to find a way from Hibernate. Being a strong recommender of hibernate I felt confident that it will have something to solve this.

Hibernate provides technique called "Optimistic Concurrency" using Versioning / Timestamp. What is intersting here? Versioning and Timestamp are same old stuff. But above these two it has another concept called "Session-Per-Conversation" or "Long Conversation" using which we can do Optimistic Concurrency control without change in datastructure and without much change in code.

For More details visit:
http://www.hibernate.org/hib_docs/reference/en/html_single/#transactions-optimistic
http://hibernate.bluemars.net/43.html

Software Testing - Test Harness

Test Harness or Automated Test Framework is a collection of software and test data configured to test a program unit by running it under varying conditions and monitoring its behavior and outputs.

It has two main parts:
1. Test execution engine and
2. Test script repository.
Test harnesses allow for the automation of tests. They can call functions with supplied parameters and print out and compare the results to the desired value. The test harness is a hook to the developed code, which can be tested using an automation framework.

A test harness should allow specific tests to run (this helps in optimizing), orchestrate a runtime environment, and provide a capability to analyse results.

The typical objectives of a test harness are to:

• Automate the testing process.
• Execute test suites of test cases.
• Generate associated test reports.

A test harness typically provides the following benefits:

• Increased productivity due to automation of the testing process.
• Increased probability that regression testing will occur.
• Increased quality of software components and application.

Using generic ArrayList

JDK 5.0 provides typed array list. Before JDK 5.0 Array List store the objects of type Object. But now type of the elements of an ArrayList can be specified.

Syntax:
ArrayList list = new ArrayList();

Example:

import java.util.ArrayList;

public class MyArrayList {

public static void main(String[] args) {

Seller sel = new Seller();
Buyer buy = new Buyer();

// declare an array list of type Seller
ArrayList list = new ArrayList();
list.add(sel); // add object of type Seller which is permisible
list.add(buy); // this statement will give an error
}
}


source: java-tips.org

List of Windows xp Dos Commants part 2

Here is list of Remaining Windows xp Dos Commands:

NET Manage network resources
NETDOM Domain Manager
NETSH Configure network protocols
NETSVC Command-line Service Controller
NBTSTAT Display networking statistics (NetBIOS over TCP/IP)
NETSTAT Display networking statistics (TCP/IP)
NOW Display the current Date and Time
NSLOOKUP Name server lookup
NTBACKUP Backup folders to tape
NTRIGHTS Edit user account rights

PATH Display or set a search path for executable files
PATHPING Trace route plus network latency and packet loss
PAUSE Suspend processing of a batch file and display a message
PERMS Show permissions for a user
PERFMON Performance Monitor
PING Test a network connection
POPD Restore the previous value of the current directory saved by PUSHD
PORTQRY Display the status of ports and services
PRINT Print a text file
PRNCNFG Display, configure or rename a printer
PRNMNGR Add, delete, list printers set the default printer
PROMPT Change the command prompt
PsExec Execute process remotely
PsFile Show files opened remotely
PsGetSid Display the SID of a computer or a user
PsInfo List information about a system
PsKill Kill processes by name or process ID
PsList List detailed information about processes
PsLoggedOn Who's logged on (locally or via resource sharing)
PsLogList Event log records
PsPasswd Change account password
PsService View and control services
PsShutdown Shutdown or reboot a computer
PsSuspend Suspend processes
PUSHD Save and then change the current directory

QGREP Search file(s) for lines that match a given pattern.

RASDIAL Manage RAS connections
RASPHONE Manage RAS connections
RECOVER Recover a damaged file from a defective disk.
REG Read, Set or Delete registry keys and values
REGEDIT Import or export registry settings
REGSVR32 Register or unregister a DLL
REGINI Change Registry Permissions
REM Record comments (remarks) in a batch file
REN Rename a file or files.
REPLACE Replace or update one file with another
RD Delete folder(s)
RDISK Create a Recovery Disk
RMTSHARE Share a folder or a printer
ROBOCOPY Robust File and Folder Copy
ROUTE Manipulate network routing tables
RUNAS Execute a program under a different user account
RUNDLL32 Run a DLL command (add/remove print connections)

SC Service Control
SCHTASKS Create or Edit Scheduled Tasks
SCLIST Display NT Services
ScriptIt Control GUI applications
SET Display, set, or remove environment variables
SETLOCAL Control the visibility of environment variables
SETX Set environment variables permanently
SHARE List or edit a file share or print share
SHIFT Shift the position of replaceable parameters in a batch file
SHORTCUT Create a windows shortcut (.LNK file)
SHOWGRPS List the NT Workgroups a user has joined
SHOWMBRS List the Users who are members of a Workgroup
SHUTDOWN Shutdown the computer
SLEEP Wait for x seconds
SOON Schedule a command to run in the near future
SORT Sort input
START Start a separate window to run a specified program or command
SU Switch User
SUBINACL Edit file and folder Permissions, Ownership and Domain
SUBST Associate a path with a drive letter
SYSTEMINFO List system configuration

TASKLIST List running applications and services
TIME Display or set the system time
TIMEOUT Delay processing of a batch file
TITLE Set the window title for a CMD.EXE session
TOUCH Change file timestamps
TRACERT Trace route to a remote host
TREE Graphical display of folder structure
TYPE Display the contents of a text file

USRSTAT List domain usernames and last login

VER Display version information
VERIFY Verify that files have been saved
VOL Display a disk label

WHERE Locate and display files in a directory tree
WHOAMI Output the current UserName and domain
WINDIFF Compare the contents of two files or sets of files
WINMSD Windows system diagnostics
WINMSDP Windows system diagnostics II
WMIC WMI Commands

XCACLS Change file permissions
XCOPY Copy files and folders

Note: To Know the Syntax for Each Commands type help followed by that Command name in DOS Prompt"

e.g., "help color", help del, help copy etc..,

MVS SYSTEM CODES -S322

Description:

The time limit was exceeded for a job or job step.

Possible causes:

1. An endless loop occurred in the executing program.
2. The time parameter on the job card did not allow enough time for the job to complete.
3. The time parameter on the exec card did not allow enough time for the step to complete.
4. If the time parameter was not specified, the default time limit was exceeded.

Resolution:
1. Check for program errors, especially endless loops that cause the job or job step to exceed the time limit.
2. Verify that the time limits for the given job are realistic.
If necessary, specify a longer time in the time parameter, and rerun the job.

Ref: www.ibmmainframes.com

Renaming and Appending in a file using CF

Using ColdFusion's cffile tag, you can rename a file on the server and you can append a file on the server.

Example of Renaming a File


The following code renames the source file with the name specified with the destination attribute.

action="rename"
source="C:\docs\accessLog.txt"
destination="C:\docs\oldAccessLog.txt">

To append a file, you simply use action="append" (instead of action="write").

The contents you specify in this tag are appended to the end of the existing file.If the file doesn't already exist, it is created.

Example of Appending a File

This example declares a variable, assigns the current date and time to it, then appends the result to a file.

dateAccessed = "This page was accessed at this time: " & now()>

action="append"
file="C:\docs\accessLog.txt"
output="#dateAccessed#">

Source : http://www.quackit.com/coldfusion/tutorial/coldfusion_append_file.cfm