It's all about the answers!

Ask a question

getting data from DB tables to BF variables


Dmitry Lapygin (2122) | asked Apr 29 '10, 5:58 a.m.
Hi, we need to get data from Oracle tables and use it during BF project.
I can't find any examples how to do it.
I guess we can work with DB from command line but how to set BF variables with values from Oracle tables?

Thank you!

One answer



permanent link
Brent Ulbricht (2.5k11) | answered Apr 29 '10, 8:52 a.m.
JAZZ DEVELOPER
Hi, we need to get data from Oracle tables and use it during BF project.
I can't find any examples how to do it.
I guess we can work with DB from command line but how to set BF variables with values from Oracle tables?

Thank you!


Hi,

One way you could do this is to use the .set or .bset dot commands with a command to get the value between backticks. For example, the syntax would look like the statements below.

.set env <Env_Group_Name> "<Variable_Name>=`Command To Get Value`"

.bset env "<Variable_Name>=`Command To Get Value`"

For the command to get the value, if your program to get the value from Oracle DB only printed that value you could add that in the backticks or perhaps just cat/type a text file that has the value.

bju

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.