One Star

Export of hierarchical data from rdbms (SQL Server) to flat files

I want to export the data for one 'program' out of a database that we manage.
People are tied to programs through the programid foreign key, visits are tied to people through the personid foreign key.
Can I create an export that takes in the programid that I want to export, and because I'v edefined the realtionships (or because the system KNOWS the relationships, it only selects rows that are tied to that programid through the foreign key relationship?
I hope by description is clear...
Thank you.
David Buttrick
1 REPLY
One Star

Re: Export of hierarchical data from rdbms (SQL Server) to flat files

Hi David,
this is possible. You could define a context variable (for example program) and use it in a tInput. For example in java use "context.program" in your SQL. To define the relation you could use standard SQL syntax.
Bye
Volker