Recent content by frangac

Hi Annihilannic Thanks. That should give me a start. Thanks Again Chris

Annihilannic, Thanks for your response. I would like my script to be fully awk (Chris) for e.g. Chris NE DT 20061105 20061106 and must read BEGIN{for (i=1;i<ARGC;i++){ if(ARGV[i] != 4){ exit 1 } else { if($1!=NE){ print something exit 2 } if($2!=DT){ print something exit 3...

Hi All, Can I use a for loop to read the ARGC input parameters instead of me using ksh to do this for e.g. Chris.sh NE DT 20061105 20061106 and must read BEGIN{for (i=1;i<ARGC;i++){ if(ARGV[i] != 4){ exit 1 } else { $1=NE ,$2=DT etc.. } Many Thanks Chris

Hi All, PHV How can I print the getline statement from the following: awk -v opt=Restore_Chris -v PH='/raw_data/SB/repdir/Archive_Restore/' 'BEGIN{print "connect tcenh198 dsadmin \"\""} /MTA0000001/{print "compRead...

Hi All, I think I have solved my problem , the close(VOL) was missing Thanks Chris

Hi All, PHV Below is my script that reads the .ini file and if the start time is 12:00 is should them activate the instance which it does but due to the data base allready marked as active , it returns a "MESG" But when the next instance (conductor_DCAPS_E10_12) is read it does the system...

Hi PHV, As always spot on. One question , may I borrow your brain for one year, I promise to return it in the same order.(just a joke) Many Thanks Chris

Hi PHV,Feherke, Any ideas for me. Many Thanks Chris

Hi Thanks once again. The result i am getting is incorrect A_NUM DATE/TIME B_NUM DURATION (0 rows affected) awk 'BEGIN {printf "%10s %25s %20s %15s\n","A_NUM","DATE/TIME", "B_NUM","DURATION"...

Hi Feherke, Thanks a lot. With you code I get the following error syntax error The source line is 14. The error context is >>> END <<< { awk: The statement cannot be correctly parsed. CODE ==== awk 'BEGIN{printf "%10s %25s %20s %15s\n","A_NUM","DATE/TIME"...

Hi Feherke, Thanks, but I have tried it awk 'BEGIN{printf "%10s %25s %20s %15s\n","A_NUM","DATE/TIME", "B_NUM","DURATION"} FNR==NR { t[$1]=$1; next } {if(t[$1]==$1){Flag=1}{ if($4=="0" && ($4!="[A-Z,a-z] || $4!=\"---")){ DUR=$4...

Hi All, The problem that I am experiencing is when the pattern is not found in file2, print a mesg "0133333333 No Info Available". I have tried different ways but cannot seem to find a solution. My Code awk 'BEGIN{printf "%10s %25s %20s %15s\n","A_NUM","DATE/TIME", "B_NUM","DURATION"}...

Hi All, I have a solution but seems to be like PHV would call it 'BRUTE' Da=`awk '{print $2" 00:00:00"}'` and then awk -v opt="/sybase_oc/OCS-12_0/bin/isql" -v opt2="'$Da'" ' { ....... ....... }' If any or better solution , please post Many Thanks Chris

Hi PHV, Thanks once again. I did try you solution but this is what I get echo select A_NUM=nullif\(A_NUM,\" \"\) from CE.CDR_DRMS where R_DT=date\(2006/06/06\) and A_1=0 and A_2=1 and A_3=2 and A_4=3 and A_5=1 and A_6=1 and A_7=8 and A_8=8 and A_9=6 and A_10=isnull\(5,\"\"\) \\ngo |...

Hi All, How can I call a sprintf command to read the following selcmd1=sprintf("%s","echo select A_NUM=nullif\(A_NUM,\\\" \\\"\) R_DT=date\('2006/06/06'\) "\\\\ngo | " opt) in other words the result must return like : echo select A_NUM=nullif\(A_NUM,\" \"\) where R_DT=date\('2006/06/06'\)...