Wednesday, March 28, 2012
how to show hibernate option in shutdown menu
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
Thursday, July 7, 2011
How to Change Country Default Search in Google Chrome - Language customization
I always want to use google in english
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 ;)
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
"The publisher must be associated with the developer account before the developer can invoke operations on the publisher's account."
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 :)
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???
- 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).
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"
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..

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
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
- Press the Print Screen key on your keyboard. It may be labeled [Prnt Scrn].
- Open Microsoft Paint or any other image editing program of your choice.
- Go to the Edit menu and choose Paste.
- If prompted to enlarge the image, choose Yes.
- Optional: Use your image editor's crop tool to crop out unnecessary portions of the screen shot.
- Go to the File Menu and choose Save As.
- Navigate to the folder where you want to save the image.
- Type a file name for the image.
- Select a file type [Generally the GIF format works best].
- Click the Save button.
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));
Wednesday, November 3, 2010
How to enable / disable javascript in Internet Explorer ?
Enable / disable Javascripting in Internet Explorer
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.How to insert checkboxes in Microsoft Word ?
Check-boxes in MS Word ?
Place the cursor where you want to insert the check box.- 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.


Raheel Farooq
Posted in: