Archive for December, 2013

How to register in Do Not Disturb

Many people suffer from the unwanted marketing messages and calls made by the mobile network operators. These messages and calls are extremely annoying, and there is no way proper information on how to activate this service. This service was formerly called DND (Do Not Disturb), which now transformed to NCPR (National Consumer Preference Register) by the TRAI (The Telecom Regulatory Authority of India). Previously, people who subscribed to DND had chances to receive the unsolicited promotions calls from their mobile network operators. With NCPR, the chances of receiving these unwanted messages is almost zero.

According to NCPR, a mobile customer in India can stop all the unwanted marketing calls and messages whenever he/she wants. This service can give you the option of selecting various options according to your requirement.

All the service providers will have the same set of instructions to register for the do not disturb service. You can activate DND from your mobile by just calling 1909 and selecting the options, or by sending a simple SMS to 1909. This message is similar to all the mobile network operators in India, and check out the various companies and their registration process to start your DND service.

And if you are already registered, and then check your Do not disturb registry here:

Stop All Calls

To enroll in the National Do Not Call registry in India, do one of the following.

Send an SMS with the message START 0 to 1909 OR Call 1909 and follow instructions

Note: If the above SMS is not recognized, try sending the old format message START DND to 1909

You may call 1909 or use below form to enquire current status and know your NDNC registration date.

Stop Calls by Category

Send an SMS with the message STOP 3 to 1909 to stop promotional offers related to Education.

Below is a list of category numbers.

1.Banking/Insurance/Financial products/credit cards
2.Real Estate
5.Consumer goods and automobiles
7.Tourism and Leisure


To audit the number of effected rows, during conversion/interface run %SQLROWS can be used.

%SQLROWS returns the number of rows affected by the most recent UPDATE, DELETE, or INSERT executed through the SQLExec function.
%SQLROWS can also be used after SELECT. It returns 0 if no rows are returned, a non-zero value if one or more rows are returned. In this case, the non-zero value does not indicate the total number of rows returned.

If your application engine step is a SQL step, you could insert a Log Message step below it. Use message set# 18030 and message number 3. This is just a generic message that has 4 variable place holders. In the
Parameters box of your Log Message step, put in %AESECTION,%AESTEP,%SQLROWS,PS_JOB. You can obviously substitute PS_JOB for your record name if you want to see the record name. %SQLROWS is the
important piece and will display the number of row affected by your SQL  step.