Saturday, October 13, 2007

Peoplesoft Peoplecode

Difference Between DoSave and DoSaveNow

DoSave can be used only in FieldEdit, FieldChange, or MenuItemSelected PeopleCode.
DoSave defers processing to the end of the current PeopleCode program event, as distinct from DoSaveNow, which causes save processing (including SaveEdit, SavePreChange, SavePostChange, and Workflow PeopleCode) to be executed immediately.


SetNextPage()
SetNextPage("PAGE_2");DoSave( );TransferPage( );

AddKeyListItem
AddKeyListItem(field, value)
Description
Use the AddKeyListItem to add a new key field and its value to the current list of keys. It enables PeopleCode to help users navigate through related pages without being prompted for key values. A common use of AddKeyListItem is to add a field to a key list and then transfer to a page which uses that field as a key.
The following example creates a key list using AddKeyListItem and transfers the user to a page named VOUCHER_INQUIRY_FS.AddKeyListItem(VNDR_INQ_VW_FS.BUSINESS_UNIT, ASSET_ACQ_DET.BUSINESS_UNIT_AP);
AddKeyListItem(VNDR_INQ_VW_FS.VOUCHER_ID, ASSET_ACQ_DET.VOUCHER_ID);
TransferPage("VOUCHER_INQUIRY_FS");

TransferPage

Syntax
TransferPage([PAGE.page_name_name])

Description
Use the TransferPage function to transfer control to the page indicated by PAGE. page__namename within, or to the page set with the SetNextPage function. The page that you transfer to must be in the current component or menu. To transfer to a page outside the current component or menu, or to start a separate instance of PeopleTools prior to transfer into, use the Transfer function.

SQLExec
SyntaxSQLExec({sqlcmd SQL.sqlname}, bindexprs, outputvars)
where bindexprs is a list of expressions, one for each :n reference within sqlcmd or the text found in the SQL defintion sqlname, in the form: inexpr_1 [, inexpr_2]. . .
and where outputvars is a list of variables, record fields, or record object references, one for each column selected by the SQL command, in the form: out_1 [, out_2]. . .
Description
Use the SQLExec function to execute a SQL command from within a PeopleCode program by passing a SQL command string. The SQL command bypasses the Component Processor and interacts with the database server directly. If you want to delete, insert, or update a single record, use the corresponding PeopleCode record object method.
If you want to delete, insert, or update a series of records, all of the same type, use the CreateSQL or GetSQL functions, then the Execute SQL class method.
Limitation of SQLExec SELECT Statement
SQLExec can only Select a single row of data. If your SQL statement (or your SQL.sqlname statement) retrieves more than one row of data, SQLExec sends only the first row to its output variables. Any subsequent rows are discarded. This means if you want to fetch only a single row, SQLExec can perform better than the other SQL functions, because only a single row is fetched. If you need to SELECT multiple rows of data, use the CreateSQL or GetSQL functions and the Fetch SQL class method. You can also use ScrollSelect or one of the Select methods on a rowset object to read rows into a (usually hidden) work scroll.
Note. The PeopleSoft record name specified in the SQL SELECT statement must be in uppercase.
Limitations of SQLExec UPDATE, DELETE, and INSERT Statements
SQLExec statements that result in a database update (specifically, UPDATE, INSERT, and DELETE) can only be issued in the following events:
SavePreChange
WorkFlow
SavePostChange
FieldChange
Remember that SQLExec UPDATEs, INSERTs, and DELETEs go directly to the database server, not to the Component Processor (although SQLExec can look at data in the buffer using bind variables included in the SQL string). If a SQLExec assumes that the database has been updated based on changes made in the component, that SQLExec can be issued only in the SavePostChange event, because before SavePostChange none of the changes made to page data has actually been written back to the database.
Setting Data Fields to Null
SQLExec does not set Component Processor data buffer fields to NULL after a row not found fetching error. However, it does set fields that aren’t part of the Component Processor data buffers to NULL. Work record fields are also reset to NULL.
Using Meta-SQL in SQLExec
Different DBMS platforms have slightly different formats for dates, times, and datetimes; and PeopleSoft has its own format for these data types as well. Normally the Component Processor performs any necessary conversions when platform-specific data types are read from the database into the buffer or written from the buffer back to the database.
When an SQLExec statement is executed, these automatic conversions don't take place. Instead, you need to use meta-SQL functions inside the SQL command string to perform the conversions. The basic types of meta-SQL functions are:
General functions that expand at runtime to give you lists of fields, key fields, record fields, and so on. %InsertSelect or %KeyEqual are typical examples.
In functions that expand at runtime into platform-specific SQL within the WHERE clause of a SELECT or UPDATE statement or in an INSERT statement. %DateIn is a typical example.
Out functions that expand at runtime into platform-specific SQL in the main clause of SELECT statement. %DateOut is a typical example.
Following is an example of an SQL SELECT using both and "in" and "out" metastring:select emplid, %dateout(effdt) from PS_CAR_ALLOC a where car_id = '" &REGISTRATION_NO "' and plan_type = '" &PLAN_TYPE
"' and a.effdt = (select max (b.effdt) from PS_CAR_ALLOC b where a.emplid=b.emplid and b.effdt <= %currentdatein) and start_dt
<= %currentdatein and (end_dt is null or end_dt >= %currentdatein)";
See Meta-SQL.
Bind Variables in SQLExec
Bind variables are references within the sqlcmd string to record fields listed in bindvars. Within the string, the bind variables are integers preceded by colons: :1, :2,. . .
The integers need not in numerical order. Each of these :n integers represents a field specifier in the bindvars list, so that :1 refers to the first field reference in bindvars, :2 refers to the second field reference, and so on.
For example, in the following statement:SQLExec("Select sum(posted_total_amt)
from PS_LEDGER
where deptid between :1 and :2", DEPTID_FROM, DEPTID_TO, &SUM);
:1 is replaced by the value contained in the record field DEPTID_FROM; :2 is replaced by the value contained in the record field DEPTID_TO.
Note the following points:
Bind variables can be used to refer to long character (longchar) fields. Long character fields are represented in PeopleCode as strings. You should use %TextIn() Meta-SQL to ensure these fields are represented correctly on all database platforms.
Bind variables can be passed as parameters to meta-SQL functions, for example:SQLExec(". . .%datein(:1). . .", START_DT, &RESULT)
If a bind variable :n is a Date field that contains a null value, SQLExec replaces all occurrences of ":n" located before the first WHERE clause with "NULL" and all occurrences of "= :n" located after the first WHERE to "IS NULL".
Inline Bind Variables in SQLExec
Inline bind variables are included directly in the SQL string in the form::recordname.fieldname
The following example shows the same SQLExec statement with standard bind variables, then with inline bind variables:Rem without Inline Bind Variables;
SQLExec("Select sum(posted_total_amt)
from PS_LEDGER
where deptid between :1 and :2", deptid_from, deptid_to, &sum);
Rem with Inline Bind Variables;
SQLExec("Select sum(posted_total_amt)
from PS_LEDGER
where deptid between :LEDGER.DEPTID_FROM
and :LEDGER.DEPTID_TO", &sum);
Inline bind variables, like all field and record references enclosed in strings, are considered by PeopleTools as a "black box". If you rename records and fields, PeopleTools does not update record and field names that are enclosed in strings as inline bind variables. For this reason, you should use standard bind variable in preference to inline bind variables wherever standard bind variables are available (as they are in SQLExec).
Prior to PeopleTools 8.0, PeopleCode replaced runtime parameter markers in SQL strings with the associated literal values. For databases that offer SQL statement caching, a match was never found in the cache so the SQL had to be re-parsed and re-assigned a query path. However, with PeopleTools 8.0, PeopleCode passes in bind variable parameter markers. For databases with SQL caching, this can offer significant performance improvements.
If you use inline bind variables, they will still be passed as literals to the database. However, if you convert them to bind variables, you may see significant performance improvements.
Output Variables in SQLExec
If you use SQLExec to Select a row of data, you must place the data into variables or record fields so that it can be processed. You list these variables or fields, separated by commas in the output part of the statement following the bindvars list. Supply one variable or field for each column in the row of data retrieved by SQLExec. They must be listed in the same order in which the columns will be selected.
The number of output variables cannot exceed 64.
Using Arrays for Bind Variables
You can now use a parameter of type Array of Any in place of a list of bind values or in place of a list of fetch result variables. This is generally used when you don't know how many values are needed until the code runs.
For example, suppose that you had some PeopleCode that dynamically (that is, at runtime) generated the following SQL statement:&Stmt = "INSERT INTO PS_TESTREC (TESTF1, TESTF2, TESTF3, TESTF4, . . . N) VALUES (:1, :2, %DateTimeIn(:3), %TextIn(:4), . . .N)";
Suppose you have placed the values to be inserted into an Array of Any, say &AAny:&AAny = CreateArrayAny("a", 1, %DateTime, "abcdefg", . . .N);
You can execute the insert by:SQLExec(&Stmt, &AAny);
Because the Array of Any promotes to absorb any remaining select columns, it must be the last parameter for the SQL object Fetch method or (for results) SQLExec. For binding, it must be the only bind parameter, as it is expected to supply all the bind values needed.
SQLExec Maintenance Issues
SQLExec statements are powerful, but they can be difficult to upgrade and maintain. If you use a SQL string passed in the command, it’s considered a "black box" by PeopleCode. If field names or table names change during an upgrade, table and field references within the SQL string are not updated automatically. For these reasons, you should use a SQL definition and the meta-SQL statements provided in PeopleTools 8.0, instead of typing in a SQL string.
Generally, you should use SQLExec only when you must interact directly with the database server and none of the ScrollSelect functions, or record class methods (which are somewhat easier to maintain) will serve your purpose effectively.
Be Careful How You Use It
SQLExec performs any SQL statement the current Access ID has database privileges to perform. This normally includes SELECT, INSERT, UPDATE, and DELETE statements against application data tables. However, you can set up users to use Access IDs with more privileges (typically, AccessIDs have full database administrator authority). In such cases, the user could alter the structure of tables using SQLExec, or even drop the database.
Warning! The PeopleSoft application will not stop the end-user from doing anything that the Access ID has privileges to do on the database server, so be very careful what you write in an SQLExec statement.
Parameters
sqlcmd SQL.sqlname
Specify either a String containing the SQL command to be executed or a reference to an existing SQL definition. This string can include bind variables, inline bind variables, and meta-SQL.
bindexprs
A list of expressions, each of which corresponds to a numeric (:n) bind variable reference in the SQL command string. It can also be a reference to a record object or an array of Any containing all the bind values. See Bind Variables in SQLEXEC for more details.
outputvars
A list of PeopleCode variables or record fields to hold the results of a SQL SELECT. There must be one variable for each column specified in the SELECT statement. It can also be a reference to a record object or an Array of Any that contains all the selected values.
Returns
Optionally returns a Boolean value indicating whether the function executed successfully.
Note. Not returning a row is not considered an error. If this is a concern, consider using the %SqlRows system variable after your call to SQLExec.
Example
The following example, illustrates a SELECT statement in a SQLExec:SQLExec("SELECT COUNT(*) FROM PS_AE_STMT_TBL WHERE AE_PRODUCT = :1 AND AE_APPL_ID = :2 AND AE_ADJUST_STATUS = 'A' ", AE_APPL_TBL.AE_PRODUCT,
AE_APPL_TBL.AE_APPL_ID, AE_ADJ_AUTO_CNT);
Note the use of bind variables, where :1 and :2 correspond to AE_APPL_TBL.AE_PRODUCT and AE_APPL_TBL.AE_APPL_ID. AE_ADJ_AUTO_CNT is an output field to hold the result returned by the SELECT.
The next example is also a straightforward SELECT statement, but one which uses the %datein meta-SQL function, which expands to appropriate platform-specific SQL for the :5 bind variable: SQLExec("SELECT 'X', AE_STMT_SEG FROM PS_AE_STMT_B_TBL where AE_PRODUCT = :1 AND AE_APPL_ID = :2 AND AE_SECTION = :3 AND
DB_PLATFORM = :4 AND EFFDT = %datein(:5) AND AE_STEP = :6 AND AE_STMT_TYPE = :7 AND AE_SEQ_NUM = :8", AE_STMT_TBL.AE_PRODUCT,
AE_STMT_TBL.AE_APPL_ID, AE_STMT_TBL.AE_SECTION, AE_STMT_TBL.DB_PLATFORM, AE_STMT_TBL.EFFDT, AE_STMT_TBL.AE_STEP, AE_STMT_TBL.AE_STMT_TYPE,
&SEG, &EXIST, &STMT_SEG);
This last example (in SavePreChange PeopleCode) passes an INSERT INTO statement in the SQL command string. Note the use of a date string this time in the %datein meta-SQL, instead of a bind variable: SQLExec("INSERT INTO PS_AE_SECTION_TBL ( AE_PRODUCT, AE_APPL_ID, AE_SECTION, DB_PLATFORM, EFFDT, EFF_STATUS, DESCR, AE_STMT_CHUNK_SIZE,
AE_AUTO_COMMIT, AE_SECTION_TYPE ) VALUES ( :1, :2, :3, :4, %DATEIN('1900-01-01'), 'A', ' ', 200, 'N', 'P' )", AE_APPL_TBL.AE_PRODUCT,
AE_APPL_TBL.AE_APPL_ID, AE_SECTION, DB_PLATFORM);
In the following example, a SQLExec statement is used to select into a record object. Local Record &DST;

&DST = CreateRecord(RECORD.DST_CODE_TBL);
&DST.SETID.Value = GetSetId(FIELD.BUSINESS_UNIT, DRAFT_BU, RECORD.DST_CODE_TYPE, "");
&DST.DST_ID.Value = DST_ID_AR;
SQLExec("%SelectByKeyEffDt(:1,:2)", &DST, %Date, &DST);
/* do further processing using record methods and properties */
See Also
CreateSQL, FetchSQL, GetSQL, StoreSQL, ScrollSelect.
SQL Class

Saturday, October 6, 2007


dole:Charitable dispensation of goods, especially money, food, or clothing.
hoof: The foot of such an animal, especially a horse.

indefatigable:Incapable or seemingly incapable of being fatigued; tireless

seclusion : the quality of being secluded from the presence or view of others

Scorn:Contempt or disdain felt toward a person or object considered despicable or unworthy

savage:Not domesticated or cultivated; wild

Devoured:To eat up greedily.
littered:A disorderly accumulation of objects; a pile.

Pail:A watertight cylindrical vessel, open at the top and fitted with a handle; a bucket.

<=*FlogTo beat severely with a whip or rod.

skirmishing:A minor battle in war, as one between small forces or between large forces avoiding direct conflict.

manoeuvre:a plan for attaining a particular goal

Geese:Any of various wild or domesticated water birds of the family Anatidae, and especially of the genera Anser and Branta, characteristically having a shorter neck than that of a swan and a shorter, more pointed bill than that of a duck.

ignominious :Marked by shame or disgrace
Hiss: A sharp sibilant sound similar to a sustained.
An expression of disapproval, contempt, or dissatisfaction conveyed by use of this sound.

impromptu:Prompted by the occasion rather than being planned in advance

Stroll: To go for a leisurely walk

Blithe:Carefree and lighthearted.

Prance:To spring forward on the hind legs. Used of a horse.

breech:The lower rear portion of the human trunk; the buttocks

Silage:Fodder prepared by storing and fermenting green forage plants in a silo.

Knoll:A small rounded hill or mound; a hillock.

Incubator:An apparatus in which environmental conditions, such as temperature and humidity, can be controlled, often used for growing bacterial cultures, hatching eggs artificially, or providing suitable conditions for a chemical or biological reaction.

Closeted:Being In a state of secrecy or cautious privacy.

Whimper:To cry or sob with soft intermittent sounds;

Aloof:Distant physically or emotionally; reserved and remote:
sordid: A trough or an open box in which feed for livestock is placed.
Veneration:feeling or showing profound respect or veneration
expulsion:the act of expelling or the state of being expelled.
Pellets:A small, solid or densely packed ball or mass, as of food, wax, or medicine.
cunning:Marked by or given to artful subtlety and deceptiveness.
subversive: cease to exists together
Linger:To remain feebly alive for some time before dying.
sly:Playfully mischievous; roguish.
quarry:An open excavation or pit from which stone is obtained by digging, cutting, or blasting.
Topple:to push or throw over; overturn or overthrow.
superintendence:To oversee and direct; supervise.
repose:the act of resting or the state of being at rest.
emboldened:To foster boldness or courage in; encourage.
snout: projecting nose, jaws, or anterior facial part of an animal's head.
vanity:The quality or condition of being vain.
Stern:Hard, harsh, or severe in manner or character:
Countenance:Appearance, especially the expression of the face:
Spinney: A small grove.
Surmount:To overcome (an obstacle, for example); conquer.
treacherous:Marked by betrayal of fidelity, confidence, or trust; perfidious.
scoundrels:A villian.
gander: A male goose.
Privy:Made a participant in knowledge of something private or secret:
Hitherto:Untill this time.
Detour:A roundabout way or course, especially a road used temporarily instead of a main route.
Smarted:to cause a sharp, usually superficial, stinging pain:
Brace:To get ready; make preparations.
Turnip:A widely cultivated Eurasian plant (Brassica rapa) of the mustard family, having a large fleshy edible yellow or white root.
Piebald:Spotted or patched, especially in black and white
Forbid:To command (someone) not to do something
wafted:To cause to go gently and smoothly through the air or over water.
Stratagem:A military maneuver designed to deceive or surprise an enemy.2. A clever, often underhanded scheme for achieving an objective.
Falter:A military maneuver designed to deceive or surprise an enemy.2. A clever, often underhanded scheme for achieving an objective.
Interment:The act or ritual of interring or burying.
Inebriates:To make drunk; intoxicate.
Rheum:A watery or thin mucous discharge from the eyes or nose.
Morose:Sullenly Melancholy;Sadness or Depression of Spirits
greyer:to become intermediate between two.
muzzle:The forward, projecting part of the head of certain animals, such as dogs, including the mouth, nose, and jaws; the snout.
Taciturn:Habitually Untalkative;
Filial:Of, relating to, or befitting a son or daughter:
Fluttering:to wave or flap rapidly in an irregular manner
Masthead:The listing in a newspaper or periodical of information about its staff, operation, and
circulation.
untrodden:lacking pathways;
birch:Any of various deciduous trees or shrubs of the genus Betula
Trifle:Something of little importance or value.
Consent:To give assent, as to the proposal of another; agree.
Creep:To move with the body close to the ground, as on hands and knees.
incumbent:Imposed as an obligation or duty; obligatory: felt it was incumbent on us all to help.
subsist:to exist.
Flit:To move about rapidly and nimbly

10/05/2007:Animal Farm

Scullery:A room, generally annexed to a kitchen, used to prepare food for cooking, and/or as a pantry.
Lurched:To roll or pitch suddenly or erratically: The ship lurched in the storm. The car gave a start and then lurched forward.
Stirring:Exciting strong feelings, as of inspiration; rousing. Active; lively
A slight motion or moving about: restless stirrings.
Fluttering:To wave or flap rapidly in an irregular manner: curtains that fluttered in the breeze.
ensconced:To settle (oneself) securely or comfortably: She ensconced herself in an armchair.
stout:Having or marked by boldness, bravery, or determination; firm and resolute.
tush:A canine tooth, especially of a horse.
rafter:One of the sloping beams that supports a pitched roof.
lest:For fear that: tiptoed lest the guard should hear her; anxious lest he become ill
mare:A female horse or the female of other equine species.
foal: The young offspring of a horse or other equine animal, especially one under a year old.
paddock:A fenced area, usually near a stable, used chiefly for grazing horses.
orchard:An area of land devoted to the cultivation of fruit or nut trees.
Trotter:A foot, especially the foot of a pig or sheep prepared as food.
Tyrannize:rule or exercise power over (somebody) in a cruel and autocratic manner; "her husband and mother-in-law tyrannize her"
Hoarse:Having or characterized by a husky, grating voice:
lain:lie down
brood:The young of certain animals, especially a group of young birds or fowl hatched at one time and cared for by the same mother.
trodden:crushed or broken by being stepped upon heavily.
mincing:Affectedly refined or dainty.
Daintily:Delicately beautiful or charming; exquisite:
plait:A braid, especially of hair.
purr:The soft vibrant sound made by a cat.
hideous:Repulsive, especially to the sight; revoltingly ugly.
stall:A compartment for one domestic animal in a barn or shed.
Knacker:A person who buys worn-out or old livestock and slaughters them to sell the meat or hides.
Foxhounds:Any of various medium-sized short-haired hounds developed for fox hunting, especially either of two breeds, the English foxhound and the American foxhound.
Falter: To be unsteady in purpose or action, as from loss of courage or confidence;
Astray: Away from correct path.
Hearken:listen; used mostly in the imperative
Spur: A short spike or spiked wheel that attaches to the heel of a rider's boot and is used to urge a horse forward.

Friday, October 5, 2007

10/06/2007:FISH FABLE

FISH

------------------------------------------------


aneurysm:A localized, pathological, blood-filled dilatation of a blood vessel caused by a disease or weakening of the vessel's wall.

fiasco: Complete failure.

hassled:harassed

tranquil:Free from anxiety, tension, or restlessness; composed

Puget sound: sound of a water body.

single out: Select from a group, treat differently on the basis of sex or race

yogurt:A custard like food with a tart flavor, prepared from milk curdled by bacteria, especially Lactobacillus bulgaricus and Streptococcus thermophilus, and often sweetened or flavored with fruit.
Predicament:A situation, especially an unpleasant, troublesome, or trying one, from which extrication is difficult.

Salmon:Any of various large food and game fishes of the genera Salmo and Oncorhynchus, of northern waters, having delicate pinkish flesh and characteristically swimming from salt to fresh water to spawn

"There is no safe harbour, but to take no action is to fail for sure."

"You couldn't have asked a better question, Steve. We can't control the way other people drive, but we can choose how we respond."

Unison:The act or an instance of speaking the same words simultaneously by two or more speakers.

flinch:To start or wince involuntarily, as from surprise or pain. To recoil, as from something unpleasant or difficult; shrink.

grouchy:Tending to complain or grumble; peevish or grumpy.

Indelible:Impossible to remove, erase, or wash away; permanent:

upholster:To supply (furniture) with stuffing, springs, cushions, and covering fabric

intimidated:To make timid; fill with fear.

commotion:A condition of turbulent motion

impasse:A road or passage having no exit

stampede: sudden frenzied rush of panic-stricken animals impediment:

Something that impedes; a hindrance or obstruction.

plaque: A flat plate, slab, or disk that is ornamented or engraved for mounting, as on a wall for decoration or on a monument for information

There is always a choice about the way you do your work,
even if there is not a choice about the work itself
.


"We can choose our attitude
we bring to our work. "

"If we can accomplish this one thing, our work area will become an oasis of energy, flexibility, and creativity in a tough industry."


"Let it be a life that has dignity and meaning for you. If it does, then the particular balance of successorfailure is of lessaccount."

Benefits of Play
• Happy people treat others well.
• Fun leads to creativity.
• The time passes quickly.
• Having a good time is healthy.
• Work becomes a reward and not just a way to rewards.

Tuesday, October 2, 2007

10/02/2007:Regular Post

<=* Stymied=Obstructed =>Spank=To Slap on the buttocks with a flat object or with the open hand, as for punishment.
<=*nuance=A subtle or slight degree of difference, as in meaning, feeling, or tone; a gradation. =>homespun=Woven at home
=>quivers=To shake with a slight, rapid, tremulous movement
=>stew·ard =One who manages another's property, finances, or other affairs.
=>Fear mongering = is the use of fear to leverage the opinions and actions of others towards some end. The object of fear is exaggerated; those the fear is directed toward are kept aware of it on a constant basis.
=>prion=A microscopic protein particle similar to a virus but lacking nucleic acid, thought to be the infectious agent responsible for scrapie and certain other degenerative diseases of the nervous system.
=>myriad=Constituting a very large, indefinite number; innumerable: the myriad fish in the ocean.
=>outrage=An act of extreme violence or viciousness
=>hazard=A chance of being injured or harmed; danger: Space travel is full of hazards.
=>toddler=One who toddles, especially a young child learning to walk.
=>cribs=A bed with high sides for a young child or baby.
=>snicker=A snide, slightly stifled laugh.
=>cres·cen·do =A gradual increase, especially in the volume or intensity of sound in a passage.
=>scavange=To search through for salvageable material: scavenged the garbage cans for food scraps.
o·gre n. =>A giant or monster in legends and fairy tales that eats humans.

=>rabidly=Raging; uncontrollable: rabid thirst.
<=* Spank=To hit on buttock as a punishment. =>e·lu·sive adj. =Tending to elude capture, perception, comprehension, or memory: “an invisible cabal of conspirators, each more elusive than the archterrorist [himself]”
=>loitering =is an intransitive verb meaning to stand idly, to stop numerous times, or to delay and procrastinate.
=>conun·drum = A riddle in which a fanciful question is answered by a pun. A paradoxical, insoluble, or difficult problem;

=>tantalizing =Enticingly in sight, yet often out of reach: mouthwatering.

<=*mayhem=A state of violent disorder or riotous confusion; havoc

=>ascension =The act or process of ascending; ascent.

=>marquee =A large tent, often with open sides, used chiefly for outdoor entertainment.

=>candid =Free from prejudice; impartial.

=>rattle=To make or emit a quick succession of short percussive sounds.

=>in·trigue =A secret or underhand scheme; a plot.

=>remnants=

<=*gleaned=to collect bit by bit.

=>namesake=One that is named after another.

=>Zeitgeist = The spirit of the time; the taste and outlook characteristic of a period or generation: “It's easy to see how a student . . . in the 1940's could imbibe such notions. The Zeitgeist encouraged Philosopher-Kings”

=> surmised = To infer (something) without sufficiently conclusive evidence.

=>bohemian=A person with artistic or literary interests who disregards conventional standards of behavior.
Straight from Freakonomics:
"Risk = hazard + outrage. For the CEO with the bad hamburger meat, Sandman engages in “outrage reduction”; for the environmentalists, it’s “outrage increase.”"

"So why is a swimming pool less frightening than a gun? The thought of a child
being shot through the chest with a neighbor’s gun is gruesome, dramatic,
horrifying—in a word, outrageous. Swimming pools do not inspire outrage. This
is due in part to the familiarity factor. Just as most people spend more time in
cars than in airplanes, most of us have a lot more experience swimming in pools
than shooting guns."


"A woman who doesn’t have her first child until she is at least thirty is likely to
see that child do well in school. This mother tends to be a woman who wanted to
get some advanced education or develop traction in her career. She is also likely
to want a child more than a teenage mother wants a child. This doesn’t mean that
an older first-time mother is necessarily a better mother, but she has put
herself—and her children—in a more advantageous position."


Lesson for Freako: Its the indiviual capability which matters a lot in deciding whether he will make progress or not, in most of the cases. People afraid less from the things which they know well.

So Finally today I have finished "Freakonomics", Indeed a great book. To know how things work really we should divert ourselves from conventional way and should go to the Freko way.

The Economist: Daily news and views