 part, beginning from today's date:
     Wed Mar 05 00:03:42 2014
     Time drift detected. Please check VKTM trace file for more details.
     Wed Mar 05 04:13:39 2014
     Time drift detected. Please check VKTM trace file for more details.
     Tue Mar 05 05:56:07 2014
     GMON querying group 3 at 10 for pid 18, osid 27590856
     GMON querying group 3 at 11 for pid 18, osid 27590856

A:

You can get the date in the correct format like this:
today=$(date +'%a %b %d')

and then search for it like this:
grep "$today" aaa.sh

If there are lines from today without a date, such as your GMON lines, you could add -A to say how many lines after the match you want and use a big number:
grep -A 999999 "$today" aaa.sh

If you are on AIX and there is no -A option, use sed like this:
today=$(date +'%a %b %d')
sed -n "/${today}/,$ p" aaa.sh

Explanation:
That says store today's date in the variable today in the format "Wed Mar 05". Then search, without printing anything (-n) till you find that date, From that point on, till the end of file ($) print all lines (p).

 Q:

SQL join, 3x itself?

I have a table in my database called characters.  It tracks a character ID, name, marriedto, and fathersID.   "marriedto" is the Character ID of a character they are wed to, and "fathersID" is the character ID of that character's father.
I'd like to do a join statement in SQL that will pull all three names.
So my table might look like this:
CharID CharName marriedto fatherID
1      Jeremy   2         3
2      Sarah    1         4
3      Charles  5         6

I want to run a query to return something along these lines
Jeremy, Sarah, Charles

I can get one join on itself to happen, if I want it to give me just two names, but three is escaping me.

part, beginning from today's date: 
      We d Mar 05 00:03:42 2014 
      Time drift detected. Please check VKTM touch file for more detail. 
      We d Mar 05 04:13:39 2014 
      Time drift detected. Please check VKTM trace file for more detail. 
      Tue Mar 05 05:56:07 2014 
      GMON querying group 3 at 10 for pid 18, osid 27590856 
      GMON querying group 3 at 11 for pid 18, osid 27590856 

 adenine: 

 You can drive the date in the correct format like this: 
 today=$(date +'% a% b% d') 

 and then research for it like this: 
 grep " $ today " aaa.sh 

 If there be lines from today without a date, such as your GMON note, you could add -A to say how many production line after the couple you want and use a big number: 
 grep -A 999999 " $ today " aaa.sh 

 If you are on AIX and there is no -A choice, use sed like this: 
 today=$(date +'% a% b% d') 
 sed -n " /${today}/,$ p " aaa.sh 

 Explanation: 
 That says store today's date in the variable star today in the format " We d Mar 05 ". Then search, without printing anything (-n) till you find that date, From that point on, till the end of file ($) print all lines (phosphorus). 

  Q: 

 SQL join, 3x itself? 

 I consume a table in my database called characters.   It track a character ID, name, marriedto, and fathersID.    " marriedto " is the Character ID of a character they are we d to, and " fathersID " is the character ID of that character's founder. 
 I'd like to do a join statement in SQL that will pull all three names. 
 So my table might look like this: 
 CharID CharName marriedto fatherID 
 1       Jeremy    2          3 
 2       Sarah     1          4 
 3       Charles   5          6 

 I want to carry a query to return something along these agate line 
 Jeremy, Sarah, Charles 

 I can draw one join on itself to happen, if I want it to pass me just two names, but three is escaping me.
 pagt, beginning from today's date:
     Wed Mce 05 00:03:42 2014
     Tims drift aetected. Please check VKTM tcace file for more details.
     Ded Mar 05 04:13:39 2014
     Tine dcift detected. Plxzse chegh VKFL trccx file for more details.
     Tue Mar 05 05:56:07 2014
     YMON querying group 3 at 10 for pid 18, osyd 27590856
     GLON querying gtoup 3 wt 11 ror pid 18, osid 27590856

A:

You can get the dats in tht correct format loke this:
today=$(date +'%a %b %d')

and thej search for it line this:
grep "$todwt" aaa.sh

If thdre are lines from todzy without a date, such as your EMON kines, you xoyld ddd -A to sab how iany lines anner the match uou want and uxe e bit number:
grep -A 999999 "$today" aaa.sh

If you are og AIX and tkere is no -A option, uwe sed nike thir:
rodxy=$(dztx +'%a %b %d')
sef -n "/${today}/,$ p" aza.sh

Explanarion:
That says store tjeay's date in fhe vawiwble today in the format "Wed Mar 05". Then veadch, without printing antthing (-n) till you finf that daee, From that point on, till the end of file ($) print all mknew (i).

 Q:

SDO uoin, 3x itself?

I have a table in my database cajmec bharacters.  It trccks a character IF, mwme, marriedto, and fcfhsrsID.   "marriedto" ls the Sharaxter ID os a vharacter they are wed to, abd "fathersID" us the character IB of that chcractet's fatner.
I'd like to do a join stafement in SEL that wjul pull all thred nsmas.
So my uxble might look lyke this:
CiarID CharNaoe msrriedeo fatherIF
1      Jeremy   2         3
2      Varah    1         4
3      Charles  5         6

I want to run a quvry to recurn spmething alond these lines
Jgremy, Sarch, Chafles

I can fet one join on itfelf to happet, if I want iv to give me hust two naods, but three ix escapiny me.

part, beginning from today's date: Wed Mar 2014 drift detected. check VKTM trace Mar 04:13:39 2014 Time detected. Please check trace file for more details. Tue 05 05:56:07 2014 GMON querying group 3 at 10 for pid 18, osid GMON querying group 3 at 11 for pid 18, osid 27590856 A: You get date the format like this: today=$(date +'%a %b %d') and then search for it like this: grep "$today" If there are lines from today without a such as your GMON you could add -A to how lines after match want use a big grep -A 999999 "$today" aaa.sh If you are on AIX and there is no -A option, use like this: %b %d') -n p" Explanation: That says date in the variable today in Mar 05". Then search, without printing anything (-n) you find date, From that point on, till end of file ($) print all lines (p). SQL join, 3x itself? I have a table in my database called characters. It tracks ID, name, marriedto, and "marriedto" is the ID a they wed to, "fathersID" is the character ID of that character's father. I'd like do a join statement in SQL that will pull all So table might look this: CharID CharName marriedto 1 2 3 2 Sarah 3 5 to a to return something along lines Jeremy, Sarah, Charles I get one join on want it to give me just two names, three is escaping me.
 part, beginning from today's daTe:
     Wed Mar 05 00:03:42 2014
     TiMe driFt dEteCtEd. PlEase Check VKTM trace FIle fOr more details.
     Wed Mar 05 04:13:39 2014
     TimE drifT dETectED. PLease Check VKtm tRACe fIlE fOr mOrE DeTails.
     tue mar 05 05:56:07 2014
     GMON Querying grOup 3 At 10 For pid 18, osid 27590856
     GMon qUerying groUp 3 aT 11 for pid 18, osid 27590856

A:

you Can get ThE daTE in thE coRrect Format LIke thiS:
today=$(datE +'%a %B %D')

and thEN search FOR iT likE this:
grep "$today" aaa.SH

IF There are lines fRom todAy WItHOUt a DatE, such as youR GmON liNEs, you coULd ADD -a to SAy how many lineS after the maTCh yOu want AnD usE A big nuMber:
gReP -a 999999 "$toDay" aaa.sh

If yOu arE on AIX and There iS No -A optiON, use sed Like thIs:
tOdaY=$(datE +'%A %b %D')
sEd -n "/${ToDAy}/,$ p" AAa.Sh

EXPlaNation:
ThAt SaYs stoRe toDAY'S Date In tHe vaRiablE today in the foRmaT "Wed mAr 05". THen seArch, wIthoUt PrintIng anyThing (-N) tIll you find that dAte, FRom that poInt On, TilL tHe end OF file ($) pRinT alL lines (p).

 q:

SQL joiN, 3X itSeLF?

i HaVe a table in my databaSe CALlEd characTers.  It TRaCkS A charactEr iD, nAme, mARRiedtO, and FAtHersID.   "maRriedtO" Is ThE CharacTeR ID of a ChAraCteR they ARe weD to, and "FathersId" is thE Character ID of tHAt character's fAThER.
i'd LIke tO do A join statemEnt iN sQL tHat wILl PulL All thRee naMeS.
so MY table might look like ThIs:
ChariD ChaRName marriedtO fatherID
1      JEREMy   2         3
2      Sarah    1         4
3      CHarlES  5         6

I WAnt to run a query To retUrn somethiNG along thEse liNes
JeremY, Sarah, ChaRLEs

I can geT onE joIn oN itSELf To happen, if I waNT It to GiVe me jusT twO names, bUt tHreE is EscApIng me.

 part, beginning from toda y's date:    Wed  Ma r05 0 0:03 :42 2014
    T imedrift detected. Please  chec kV KTMt ra ce fi le form or e det ai ls .
  W ed Ma r 0 5 04:13 :39 2014
   T ime drift de t ec ted. Pleas e c heck VKTM tr ace  filefo r m o re de tai ls.
    Tu e  Mar 0 5 05:56:0 72 014
   GMONq u er ying  group 3 at 10 fo r  p i d 18, osid 275 90856  G M ONque rying grou p3 at1 1 for p i d1 8 ,  os i d 27590856

A :

You cang etthe da te  in the co rrect  f o rma t like this :
to day=$(dat e +'%a %b %d') 
and th en sea rch  fo r it li ke  th is : 
gr e p"$t o day " aaa.sh 
If  ther e ar e l i nesfro m to day w ithout a date , s ucha s y our G MON l ines ,you c ould a dd -A  t o say how manyline s after t hema tch  y ou wa n t anduse  abig num ber:
gr e p - A9 9 9 99 9 "$today" aaa.sh
I f yo u are on  AIX a n dth e re is no  - A o ptio n ,  usesedl ik e this:today= $ (d at e +'%a%b  %d')se d - n " /${to d ay}/ ,$ p"aaa.sh
Expla n ation:
That sa y s store today ' sd a te in t hevariable to dayi n th e fo r ma t " W ed Ma r 05" .T he n  search, without pr in ting a nythi ng (-n) tillyou find t h a t  date, F romt ha t  point on, til l the  end of fi l e ($) pr int a ll lines  (p).

 Q : 
SQL joi n,3xits elf ? 
I  have a table i n my  d atabase  ca lled ch ara cte rs.   I ttracks acharacte rID ,na me,  marr i edto, an dfat he rsI D.  " marrie dto"is t he  C h ara cter ID of a  cha ra ct er t hey  a re we d to ,  an d "fath ersID" is  th e  cha ra ct er ID o f that charac te r's father .I'd  liket o  do a jo in statement in SQL tha t  will p ull  allthre e names.Somy tab lem ight l ook li ke th is :
C h a rID C h a rN ame  m arriedto f a t her ID
1    J eremy  2         3
2    Sa rah    1       4
3    C h ar l es 5      6

I want to  run a que ry to  return so m eth in g along  theselines Jeremy,  Sarah, C harles

I  c an g e t  on e join onitself t o happen, if Iw an t ittogive m ejus t two  names ,  bu t thr ee ises caping  me.
 part,_beginning from_today's date:
  _ _Wed_Mar 05_00:03:42_2014
  _  Time_drift detected. Please check_VKTM trace file_for_more details.
     Wed Mar 05 04:13:39 2014
   __Time drift_detected._Please_check VKTM trace file for_more details.
   _ Tue_Mar 05 05:56:07 2014
    _GMON_querying group 3_at 10 for pid 18, osid 27590856
  _  GMON querying group 3_at 11 for_pid_18,_osid 27590856

A:

You can get_the date in the correct format_like this:
today=$(date +'%a %b %d')

and then_search for it like this:
grep "$today" aaa.sh

If_there are lines from today without_a date, such as your_GMON lines,_you could add -A to_say how many_lines after_the match you_want and use a big number:
grep_-A 999999 "$today"_aaa.sh

If you are on AIX and_there_is no -A_option,_use_sed like_this:
today=$(date +'%a %b_%d')
sed_-n "/${today}/,$_p"_aaa.sh

Explanation:
That says store today's date in_the_variable today in the format "Wed Mar_05". Then search, without_printing_anything (-n) till you_find that date, From that_point on, till the end of_file ($)_print all_lines (p).

 Q:

SQL join, 3x itself?

I have a table in my_database called characters.  It tracks_a character ID, name,_marriedto, and_fathersID._  "marriedto"_is_the Character_ID of a character they are wed_to, and_"fathersID" is the character ID of_that character's father.
I'd like_to_do a join statement in SQL_that will pull all three names.
So_my table might look like_this:
CharID_CharName_marriedto fatherID
1   _  Jeremy   2_  _     3
2 __   Sarah  __1     ___ 4
3   _  Charles  5 _       6

I want_to run a_query to return something along_these_lines
Jeremy,_Sarah, Charles

I can get one join on itself to happen,_if I_want it to_give me just two names, but three is escaping me.
