Showing posts with label How to. Show all posts
Showing posts with label How to. Show all posts

Wednesday, March 28, 2012

how to show hibernate option in shutdown menu


how to enable hibernate option in shutdown menu in windows xp / windows 7

The mentioned process disables the hybrid sleep option.
follow the steps below :)
In the Control Panel Window, Click the Power Options icon
In the 'Change Settings For Plan' window, Click the 'Change advanced power settings'
Click the Plus (+) sign next to the Sleep option
click 'Allow hybrid sleep'. set it to 'Off'
Click the OK button
now you should see the hibernate option.

Thursday, October 6, 2011

How to get the current timestamp in Teradata SQL

 

How to select current timestamp in Teradata SQL just like we use "select date" or 
"select current_date" to get the current date

There are two possible ways to get the desired results:
SELECT CAST(CAST(CURRENT_DATE AS FORMAT 'YYYY-MM-DD') || ' ' || CAST(CAST(CURRENT_TIME AS FORMAT 'HH:MI:SS') AS CHAR(8)) AS TIMESTAMP(0));
AND
SELECT CAST(CURRENT_DATE AS TIMESTAMP(0)) + ((CURRENT_TIME - TIME '00:00:00') HOUR TO SECOND(0));
Both the above queries will display the same results in Teradata sql.

Thursday, July 7, 2011

How to Change Country Default Search in Google Chrome - Language customization

I always want to use google in english

Its very simple, You need to edit the “Local State” file and thats all :)
FIRST OPTION:

 In windows XP:
step 1: goto C:\Users\yourusername\AppData\Local\Google\Chrome\User Data\
step2: locate the "Local State" file and delete it. (dont worry when you open chrome again it will be created again with default options when chrome was installed).
step3: open chrome and google it, enjoy :)
In windows7:
step 1: goto C:\Users\yourusername \AppData\Local\Google\Chrome\User Data
step2: locate the "Local State" file and delete it. (dont worry when you open chrome again it will be created again with default options when chrome was installed).
step3: open chrome and google it, enjoy :)
SECOND OPTION:

1. Go to "Options" in chrome 
2. Click "Manage" at the Default Search section
3. Click "Add"
4. Put the name as "Google.COM"
5. Put keyword as "always google.com"
6. Paste this as the URL > http://www.google.com/search?q=%s
7. Click "Ok"
8. Click "Make Default"
9. There you go!, just type the word you want to search in the address bar in Chrome, it'll give results in English page, google.com 

You can now enjoy it ;)

Incoming search terms:

How to change from google.xx to google.com?
How to access Google in your preferred language?  
How to keep Google Chrome always in English 
How do I change my Google search location? 
Can I turn off location-based customization?
How to Switch Chrome’s Default Search to International Google
always diplay Google sites in English
always diplay Google search results in English
How do I reset the default language setting (to English)? Google always starts in

 

Saturday, March 19, 2011

Google Adsense Error - The publisher must be associated with the developer account . . .

 
AdSense - The publisher must be associated with the developer account before the developer can invoke operations on the publisher's account
You may be unfortunate unlucky enough to face this error when you try to switch on AdSense for your Blogger blog:
"The publisher must be associated with the developer account before the developer can invoke operations on the publisher's account."
Follow simple steps to get out of this error and work with adsense account hassle-free :-)
Just goto Home -> Accounts Settings -> Access and Authorization -> view 3rd-party access

Now under where it says "Hosts " you may see a blogger.com entry with a link next to it "enable access".

Click the link "enable access", and you're back in business :)

 

 

 

This is how it works. Simple :)

Friday, February 18, 2011

How to find a file by name in UNIX/Solaris/Linux OS

Find a file by name in UNIX/Solaris/Linux

  • To find a file such as filename.txt anywhere on the system:

find / -name filename.txt -print

  • Recent operating system versions do not require the print option because this is the default. To limit the search to a specific directory such as /usr:

find /usr -name filename.txt -print

I hope this helps you to find a file in unix/linux/solaris system. Leave a comment plz :)

Monday, February 7, 2011

Error Handling in BTEQ Teradata?

Error Handling in BTEQ Teradata?

BTEQ Return Codes:
Bteq return codes are the two digit values that BTEQ returns to the client operating system as a result of any error code occured in BTEQ session. Possible BTEQ return codes are as given below

Return Code Description
00 Job completed with no errors.
02 User alert to log on to the Teradata Database.
04 Warning error.
08 User error.
12 Severe internal error

The return code is decided by the Error messages that BTEQ receives from the Teradata database. Different Teradata database error codes are assigned a specific return code value.
The below table will give what different return codes are returned by BTEQ for different Error codes it receives from Teradata database.

For an Example : If you issue a SQL statement in BTEQ session to create a table which is alrady there, then Teradata database will return an error code of 3803 to the BTEQ session and in turn in BTEQ will send a return code of 04 to the client operating system where you have intiated the BTEQ session.

Return Code = 04 ( BTEQ returns a return code of 04 for the following Teradata error codes )
2580 - Mload not active on table %TVMID.
2667 - Statistics cannot be collected on an empty table. 
3534 - Index already exists.
3666 - This view has too many columns to store or retrieve comments.
3737 - Name is longer than 30 characters.
3747- No start-up string defined for this user.
3803 - Table “%VSTR” already exists.
3804 - View “%VSTR” already exists.
3805 - Macro “%VSTR” already exists.

A Sample Code Part Using BTEQ Conditional Logic:

The Bank offers a number of special services to its Million-Dollar customers.
-------------------------------------------------------------
DELETE FROM Million_Dollar_Customer ALL;
.IF ERRORCODE = 0 THEN .GOTO TableOK
CREATE TABLE Million_Dollar_Customer
(Account_Number INTEGER
,Customer_Last_Name VARCHAR(20)
,Customer_First_Name VARCHAR(15)
,Balance_Current DECIMAL(9,2));
.LABEL TableOK
INSERT INTO Million_Dollar_Customer
SELECT A.Account_Number
,C.Last_Name
,C.First_Name
,A.Balance_Current
FROM Accounts A INNER JOIN
Account_Customer AC INNER JOIN
Customer C
ON C.Customer_Number = AC.Customer_Number
ON A.Account_Number = AC.Account_Number
WHERE A.Balance_Current GT 1000000;
.IF ACTIVITYCOUNT > 0 THEN .GOTO Continue
.QUIT
.LABEL Continue
------------------------------------------------------------

What it does???

- DELETE all rows from the Million_Dollar_Customer table.
- IF this results in an error (non-zero), THEN create the table, ELSE attempt to populate using INSERT/SELECT.
- IF some rows are inserted (ACTIVITYCOUNT>0) THEN arrange services, ELSE terminate the job.

Sunday, February 6, 2011

Create Separate Profiles in Google Chrome for Family Members

 

HOW TO CREATE SEPARATE PROFILES FOR MULTIPLE USERS IN CHROME AND ENJOY BROWSING  

 

Step 1: Open your Google Chrome installation folder that is available at:

For Windows Vista - C:\Users\<username>\AppData\Local\Google\Chrome
For Windows XP - C:\Documents and Settings\<user>\Local
Settings\Application Data\Google\Chrome

Step 2: Open Windows Explorer and switch to the "User Data" folder available inside Chrome installation folder.

Then select the subfolder caleld "default" and make a copy of it in the "User Data" folder itself. Give that copy a name, say, Your_Name. (See screenshot).

chrome-profile

 

Step 3: (Optional): We will now initialize this new "Your_Name" profile to the factory default settings.

Open "Command Prompt", switch to the Chrome Application folder and run the following command:

chrome.exe --user-data-dir="..\User Data\Your_Name" -first-run

Step 4: So our new user profile is ready. To run Google Chrome using this profile instead of the default profile, just create a shortcut on your desktop, Quick launch bar or your Windows Start Menu.

 

Right click anywhere on the desktop, choose New -> Shortcut and type the following for location:

For Windows Vista: C:\Users\username\AppData\Local\Google\Chrome\Application\chrome.exe  --user-data-dir="..\User Data\Your_Name"

For Windows XP: C:\Documents and Settings\User\Local Settings\Application Data\Google\Chrome\Application\chrome.exe --user-data-dir="..\User Data\Your_Name"

chrome-icons

 

Monday, January 17, 2011

How To Fix Google Chrome Crash Problem?

How to Solve the Google Chrome crashes problem

There are two possible solutions, both are mentioned below:
 

Solution#01

  • Click on the Google Chrome shortcut
  • In Target field add “–no-sandbox” or “–in-process-plugins”
  • Click Apply and Try starting Chrome again..

If this wont work in your case, then  try solution#2 below

Solution#02

  • Click on the Google Chrome shortcut
  • In Target field add “–new-http”
  • Click Apply and Try starting Chrome again..

                                                          google chrome crash solution

 

Hope the will help you to get your chrome working again :-) enjoy chrome with awesome extensions/plugins :)

 

Saturday, January 8, 2011

how to reload all tabs in chorme?

how to reload all tabs in chorme?

how to reload all tabs in chromium?

 I did an Google Chrome extension that will allow you to reload all tabs, 

After you install the extension (Download Here), you can reload all the tabs in the current window by pressing "CTRL + SHIFT + R". 

Wednesday, December 8, 2010

SQLPLUS SET COMMAND

SQLPLUS SET COMMAND

Basic

    /* 
        Multiple line comments
        Can go between these delimiters

     */

SET TERM      OFF
-- TERM = ON will display on terminal screen (OFF = show in LOG only)

SET ECHO      ON
-- ECHO = ON will Display the command on screen (+ spool)
-- ECHO = OFF will Display the command on screen but not in spool files.
-- Interactive commands are always echoed to screen/spool.

SET TRIMOUT   ON
-- TRIMOUT = ON will remove trailing spaces from output

SET TRIMSPOOL ON
-- TRIMSPOOL = ON will remove trailing spaces from spooled output

SET HEADING   OFF
-- HEADING = OFF will hide column headings

SET FEEDBACK  OFF
-- FEEDBACK = ON will count rows returned

SET PAUSE     OFF
-- PAUSE = ON .. press return at end of each page

SET PAGESIZE  0  
-- PAGESIZE = height 54 is 11 inches (0 will supress all headings and page brks)

SET LINESIZE  80
-- LINESIZE = width of page (80 is typical)

SET VERIFY    OFF
-- VERIFY = ON will show before and after substitution variables

-- Start spooling to a log file
SPOOL C:\TEMP\MY_LOG_FILE.LOG

--
-- The rest of the SQL commands go here
--
SELECT * FROM GLOBAL_NAME;

SPOOL OFF

Saturday, November 13, 2010

How To Capture a Screen Shot of your Desktop or the Active Window in Windows

How to capture( Snap shot) windows screen without installing new software

Have you ever pressed the PrtScn (print screen) key on your Windows keyboard and wondered why it was there since it never seemed to do anything? Well, it does do something! It copies an image of your screen onto the "clipboard," ready to paste into any graphics program.
How to:
  1. Press the Print Screen key on your keyboard. It may be labeled [Prnt Scrn].
  2. Open Microsoft Paint or any other image editing program of your choice.
  3. Go to the Edit menu and choose Paste.
  4. If prompted to enlarge the image, choose Yes.
  5. Optional: Use your image editor's crop tool to crop out unnecessary portions of the screen shot.
  6. Go to the File Menu and choose Save As.
  7. Navigate to the folder where you want to save the image.
  8. Type a file name for the image.
  9. Select a file type [Generally the GIF format works best].
  10. Click the Save button.
Tips:
Hold the Alt key down while pressing Print Screen to capture only the active window.
This is how you can capture desktop window or any active window. Simple :-)

how to cast date in MMYYYY format in SQL Teradata

how to cast date in YYYYMM format using SQL in Teradata


For odbc connections (e.g if you are using sql assistant/queryman) then use:
sel cast((current_Date (format 'yyyymmdd' )) as char(8));

For native connections (e.g if you are using bteq) then use:
sel current_date (format 'yyyymmdd');

however you may use below query(same as for sql assistant) in bteq also ...
sel cast((current_Date (format 'yyyymmdd' )) as char(8));

This is how you can cast date in different formats in sql teradata. Simple :-)


Wednesday, November 3, 2010

How to enable / disable javascript in Internet Explorer ?



Enable / disable Javascripting in Internet Explorer

1. Click Tools menu in Internet Explorer window.
2. Click Options then
3. Click Security then
4. Click Internet then
5. Click Custom level then
6. Scroll down to Scripting and select the radio button to Enable or Disable it.
7. Click OK, and then click on OK again.
JavaScript should now be enabled or disabled in Internet Explorer.

See/click below for visual aid.

This is how you can disable / enable javascript in Internet Explorer. Simple ;-)

Tuesday, November 2, 2010

How to Create Pages in Blogger ?


Create Pages in Blogger / Blogspot ?

Now it is possible to create pages or navigation bar in your blog.
You create a page similar to creating a blog post. click the Posting | Edit Pages tab, then click New Page. (Note: you can create up to 10 pages.)

This is how you can create pages or navigation bar in your blog. Simple :-)


 

How to insert checkboxes in Microsoft Word ?


Check-boxes in MS Word ?

Place the cursor where you want to insert the check bo
x.
- Click on View menu then
- Click on Toolbars then
- Click Forms.
The Forms toolbar appears on the screen.
- Click on the check box on the Forms toolbar. This inserts an unchecked box in your document.

To check the check-box;Double-click on the inserted box. This opens the Check Box Form Field Options menu. Select "Checked", if you want a checked box - this inserts a check mark in the box.

This is how you can insert check-boxes in MS Word. Simple ;-)

See/click below for visual aid.


Twitter Delicious Facebook Digg Stumbleupon Favorites More

 
Design by Free WordPress Themes | Bloggerized by Lasantha - Premium Blogger Themes | fantastic sams coupons