Hi,
I want to query a xmeta table to get user info. Can you please let me know how to access xmeta.
I was able to do the same in Unix Server through Shell Script. But not sure how to access from Windows Server.
Thanks
Access Xmeta
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
#!/bin/ksh
db2 << EOF > /home/db2inst1/log
connect to xmeta
select distinct tabschema || ','|| tabname from syscat.tables
EOF
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
So long as /home is defined on the currently logged drive (the same drive on which Information Server is installed) and db2inst1 is defined in there, then you should be OK.
For example, if IIS is installed on E: drive, then E:\tmp is treated as /tmp.
For example, if IIS is installed on E: drive, then E:\tmp is treated as /tmp.
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.