Search code examples
datastage

Is there any way in datastage to fetch the isuser(username of the project) to the target table (in user column)

I have a suitable job which loads data from source to target, but in addition I want to display the isuser (isuser : which is the username of that respective project) of the Datastage Designer on my target table. It should show the isuser in the user column. Can you help me what steps should I follow.

Note Table headers are as follows

+----+------+--------+--------+--------------+
| id | name | f_name | l_name | user(isuser) |
+----+------+--------+--------+--------------+
Solution

  • You can interrogate the DSODB tables JobRun and JobExec to collect this information. The table structures are documented at https://docs-ugi.mybluemix.net/docs/content/SSZJPZ_11.7.0/com.ibm.swg.im.iis.ds.monitor.ref.doc/topics/jobruntable.html