nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Want to shift my select query to the database server

Sunil1 · 2011-06-30T04:44:55+00:00

Hello everyone, I am using select query, in dataset. this query returns me 200 fields from database, Now i want to write this query on database server and want to get back 200 records from it. select * from CAP2_TAXBASE_MONTHLY_REPORT where ROLE_ID = ? and REPORT_MONTH =…

Sunil1

Hello everyone, 
I am using select query, in dataset. 
this query returns me 200 fields from database, 
Now i want to write this query on database server and 
want to get back 200 records from it. 
 
select * from CAP2_TAXBASE_MONTHLY_REPORT 
where ROLE_ID = ? 
and REPORT_MONTH = ? 
and REPORT_YEAR = ? 
 
So, can anybody suggest me how can i do it ? <a class='bbc_url' href='http://www.birt-exchange.org/org/forum/public/style_emoticons/'>http://www.birt-exchange.org/org/forum/public/style_emoticons/</a><#EMO_DIR#>/confused.gif 
 
Thanks, 
Sunil

Find more posts tagged with

Comments

mwilliams

So, above is your query and you want to return only 200 rows? Is this correct? If so, you can go to the settings section in your dataSet editor and set a limit on the rows returned. Let me know if I'm misunderstanding.

Sunil1

I want to write procedure, which gives me multiple records as a result.

In my CAP2_TAXBASE_MONTHLY_REPORT table there is multiple fields and i am changing it as per new requirements,
so,columns are multiple.

Thanks,
Sunil.

mwilliams

I'm not sure what you're asking. select * will return all of the columns in the table. Are you wanting to create a stored procedure? If so, you'll do that in your database and then call the stored procedure from BIRT. Let me know.

Sunil1

yes, i created store procedure at database, 
 
for example procedure call is : 
call getAllAssessement{?,?,?,?,?,?,?,?,?,?} 
 
suppose i have more than 200 fields than i have to write more than 200 question marks in procedure call and also have to create more than 200 output variables in procedure, 
so i dont want to write 200 output variables and question marks, 
Instead of that if procedure will return me collection of all data than it is good solution. 
 
And tried it but my procedure didn't return me bunch(collection) of all data, 
somewhere i heard that cursor will return all data, 
but i don't know how to implement cursor OR will BIRT 2.6.2 support cursor or not ? 
 
so, how to get multiple data without writing to many output variables and question marks ? <a class='bbc_url' href='http://www.birt-exchange.org/org/forum/public/style_emoticons/'>http://www.birt-exchange.org/org/forum/public/style_emoticons/</a><#EMO_DIR#>/confused.gif 
 
Thanks, 
Sunil

Hans_vd

<blockquote class='ipsBlockquote' >Instead of that if procedure will return me collection of all data than it is good solution.</blockquote>
Well, that's the only possible way to work with stored procedures. You will need to create a stored procedure that has a cursor as an output parameter. How you do this, depends on the database you are on.