Posts

Showing posts from 2014

How to give a job-winning interview

The way to crack a job interview is not just by giving answers, but the ‘right’ answers. Here are some important tips on how to get it right Create a strong resume. Build a compelling case on why you fit the job role: The process of giving a job winning interview starts by forming a strong resume. A resume works as an entrance test to get an interview. A person’s resume should be concise and convey more in fewer words. For example, instead of saying, “I am an exceptional guitarist”, one can say, “I was the lead guitarist of an award winning rock band back in college”. Do your primary research on your potential employer Every recruiter expects you to have some basic knowledge about the organization and the industry that you are contemplating joining. Hence, it is advisable to do a primary research before going. After all, the employer has a lot of information about the applicant, so it’s only polite if the applicant evens the score. Hig

How to find the Table name if field name is known (Progress4GL)

Below query will be used to find the Table name if field name is known. We have taken the example of field idh_part. /**************************************************/ find first _field no-lock where _Field-name = "idh_part" . if avail _field then do:    find first _file no-lock where RECID(_File) = _Field._File-Recid .       if avail _file then             DISPLAY _File-name _Field-name.     end. /*************************************************/

Progress - 4GL, show the qty of difference for same item from two different excel in to single excel.

/* program take input from two excel sheets and show the same item with same rate and their   corresponding value in same row ,*/ /* if not found same item with same rate , then fetch the first record for the item from second sheet and show this record with not matched record */ /* item found in one sheet but not in another sheet will show with the zero value for the sheet for which it is not found */ DEFINE TEMP-TABLE ttinv_st NO-UNDO     FIELD st_part AS CHARACTER      FIELD st_qty AS DECIMAL  FORMAT  "->>>,999,999.999"     FIELD st_rate AS DECIMAL  FORMAT  "->>>,999,999.999". DEFINE TEMP-TABLE ttinv_st2 NO-UNDO     FIELD st2_part AS CHARACTER      FIELD st2_qty AS DECIMAL  FORMAT  "->>>,999,999.999"     FIELD st2_rate AS DECIMAL  FORMAT  "->>>,999,999.999". DEFINE TEMP-TABLE ttinv_cs NO-UNDO     FIELD cs_part AS CHARACTER      FIELD cs_qty AS DECIMAL  FORMAT  "->>>,999,999.999"     F

Progres 4GL Sample Query, how to fetch the data in excel.

In the below Query we have used the join of two tables i.e ih_hist and idh_his, you can replace them as per need. output to "test-sachin3.xls". put unformatted  "part "      "~011"  "invoice nbr" "~011"  "qty ord"    "~011"  "qty inv "      "~011"  "price"    "~011"  "pod_line "      "~011" "ih inv date"    "~011" "ih ord date"      "~011" "ih req date"    "~011" "ih ship date"   "~011" "ih due date"    "~011"  "idh due date"    "~011" "idh per date "      "~011" "idh req date"    "~011" "idh sob date"    "~011" SKIP.       FOR EACH ih_hist WHERE ih_cust = ih_cust: for each idh_hist where idh_part = '120620'and idh_inv_nbr = ih_inv_nbr: put unformatted   idh_part   &qu
CMM Level 1 (Initial) • Beginning level for most organizations. • Ad hoc development practices. • Highly dependent on current engineers. • Likely cost and schedule problems. • Quality is difficult to predict CMM Level 2 (Repeatable) • Focus is on projects. • Project management system in place. • Projects have a disciplined process. • A predictable pattern is in forming. • Less unscheduled rework. CMM Level 3 (Defined) • Emphasis shifts to organization. • Organization gathers best practices. • Processes are tailored. • Common processes, measurements, and training are established CMM Level 4 (Managed) • Level 3 established metric collection. • Level 4 uses the collected data to make decisions. CMM Level 5 (Optimizing) • Process Improvement is now in-grained. • Participation in process improvement increases dramatically CMM Level 2 KPAs • Software Configuration Management • Software Quality Assurance • Software Subcontract

Sample code to do cim load in QAD/MFGPRO

{mfdeclre.i} OUTPUT TO  "/home/hu/maggonm/rscupcimout.txt" . INPUT FROM "/home/hu/maggonm/rscup.cim" . {gprun.i ""rscup.p""}  INPUT CLOSE . OUTPUT CLOSE. Where   "rscup.cim" is the cim file which you want to load.   "rscup.p" is the program in which you are doing cim load.   "rscupcimout.txt" is the output file which shows the screen shot of the screens while doing cim load.