Answer / naga chiranjeevi kota

Session="mysession";


connstring="DSN=DQMCHIRU;UID=dqm5map;pwd=dqm5map;server=Orcl";
rc=db_connect(Session,connstring);

x="select PART_NUM,PART_ORG ,RDX_ID,DESCRIPTION from
reference_data_part where part_num like '%31' order by
PART_NUM";
printf(x);

# Opening the excel sheet
dqmdata = "C:\ExecuteSampleData.xls";
rc = ddt_open(dqmdata, DDT_MODE_READWRITE);
if (rc!= E_OK && rc != E_FILE_OPEN)
pause("Cannot open table.");

dc=db_execute_query(Session,x,rows);

#ddt_get_row_count(dqmdata,rows);
for(i=0;i<rows;i++)
{
db_get_row(Session,i,rowcon);
#ddt_set_row(dqmdata,i);
split(rowcon,rdp,"\t");
for(j=0;j<4;j++)
{
printf("R"&i+1&", C"&j+1&": "&rdp[j+1]);
ddt_set_val_by_row(dqmdata,i+1,"C"&(j+1),rdp[j+1]);

}
}

db_disconnect(Session);
ddt_save(dqmdata);
ddt_close(dqmdata);


answer by: Naga Chiranjeevi Kota(iGATE)

Answer / softwaretester4u

hi this is good answer.But i have one question is it
possible to call differect sheets in same excel
like sheet1 have one data,sheet2 have some data in same
excel .is it possible to call ? pls tell me

1,You have scripts in Qtp8.2 and some scripts 9.0 ..how to handle ?

2 Answers   Ness Technologies,

---

when obligatory & optional properties cannot uniquely identifying an object then in that case which method u r follow for identifying object in Win Runner ?

1 Answers   MBT,

---

Do we need start up file in win runner??if yes then why?and no then why?

1 Answers  

---

What is the purpose of temp. GUI map file?

3 Answers   Logica CMG,

---

what is automation frmaeworks..which type ofs automation is using yr company..what is contains in automation frmeworks.who will prepare automation frmeworks

0 Answers   L&T,

---

How to break infinite loop?

0 Answers  

---

what is the winrunner framework?

1 Answers   Agile Software, GE,

---

what is batch mode, how can u run ur tests in batch mode?

3 Answers   MBT,

---

Can we use the user defined functions (which inclues script with GUI functions) in Compile module? Example: public function MyGuiFun() { set_window(?Browser main window?); button_press(?OK?); } If yes. pls give some example, how to handle...!

1 Answers  

---

I Loaded a compile module "mycomp()" using Load statement.later I tried to load this same compile module using one more load statement.Then I tried to unload this usning unload statement one time.will it unload the compile module?

2 Answers   Accenture,

---

how u can connect database without using any wizard in winrunner?

1 Answers   Accenture, MBT,

---

What is database check points? how many types are there?Explain?

5 Answers   Second Foundation,

---