How to Get data from database(table) to an excel sheet
Answer Posted / 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)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you find out which is the start up file in winrunner?
Without the gui map, use the phy desc directly?
what is risk?
What is the purpose of gui map configuration?
What is the purpose of set_window command?
What happens when the gui map file get loaded?
Explain the purpose of different record methods?
write a compilemodule function for loginscreen.
How do you handle dynamically changing area of the window in the bitmap checkpoints?
What actually happens when you load GUI map?
How do you load GUI map?
soft key for virtual object wizard ?
When do you feel you need to modify the logical name?
Explain the purpose of loading winrunner add-ins?
Name the two modes of recording?