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


Please Help Members By Posting Answers For Below Questions

How do you handle unexpected events and errors?

607


How to do text matching?

611


How to break infinite loop?

663


Which are default codes winrunner generates when we start the application?

1590


by useing qtp where the maximum people feeling difficult

1388






How do you execute your tests from windows run command?

1446


When it is appropriate to change physical description?

638


Without the gui map, use the phy desc directly?

605


Dear all i am new to testing my company using vb.net and we are developing web based application. How i can test those application with winrunner if any one have some good tutorial or link kindly provide thanks u.

1557


Explain the purpose of loading winrunner add-ins?

635


How do you handle pop-up exceptions?

602


How to force wr to learn the sub-items on a menu?

546


How can withwin runner to make single scripts which supports multiple languages?

610


what are the differences you see in e-commerce and banking domain in testing point of view Thanks in Advance

1035


What different actions are performed by find and show button?

654