and field name of that table in its condition. Appreciate greatly if you could let me know about the variable or function in DS to get table name and Field name
Thanking in advance !!
Function or variable to get table name and field name
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 60
- Joined: Tue Jul 12, 2005 3:34 am
Re: Function or variable to get table name and field name
I did not get your question...tsktsk123 wrote:and field name of that table in its condition. Appreciate greatly if you could let me know about the variable or function in DS to get table name and Field name
Thanking in advance !!
Do you want to extract data from any database using any DSPX stage??
If so then you need to know which table you want to extract data from.
Please elaborate the question!
My requirement is to extract the table name and field name from the database (Oracle) of the source record. We have not stored the table names and fields in the database.
i.e.say my table name is EMP which has the following fields EMP_NO, EMP_NAME and EMP_DEPT.
I just wanted to know is there any function or variable which can get the table name & field name i.e function should return the table name as EMP and the field names EMP_NO, EMP_NAME and EMP_DEPT.
i.e.say my table name is EMP which has the following fields EMP_NO, EMP_NAME and EMP_DEPT.
I just wanted to know is there any function or variable which can get the table name & field name i.e function should return the table name as EMP and the field names EMP_NO, EMP_NAME and EMP_DEPT.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There is nothing directly available within a DataStage stage. You can code using the ODBC API - in which case the function is SQLTables() to retrieve a list of tables (optionally filtering with a wildcard name).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.