Hi Lory, try to run
SELECT * FROM syscat.tables WHERE type = 'T' As I remember, this query returns the list of the tables in DB2 ===================== WBR, Gennady Kim Techdinamics Solutions, Inc From: [email protected] [mailto:[email protected]] On Behalf Of L Sent: Tuesday, January 08, 2013 12:35 PM To: [email protected] Subject: [EDI-L] Re: Generate report on User information(IBM Sterling Integrator 5.2) It might seem "elementary" but when you're a novice with a completely new system, very little training, and documentation that is lacking at best, nothing is elementary. We are using DB2, however I do not have direct access to the database. SI provides a SQL Manager where I can run queries, but I don't know the table names and what fields they contain. I was hoping there was a utility within SI that would provide this information. I guess I have to put in a request with our DBA team to look this up for me and maybe they can give me a spreadsheet or something. I was looking for a way to look up table names and fields myself, without having to bug the DBAs. I'm curious - do most of you have direct access to your EDI database tables? I'm assuming that the majority of us are EDI developers, analysts, engineers, mappers, etc., and not DBAs, Technical Services, or infrastructure-type folks. What I mean is, I did not install the software, set up the database, or create the file system. I analyze trading partner requirements, write maps, set up trading partner relationships and communications, set up reports, monitor errors, etc. Maybe it's the nature of my organization. We are a large enterprise with a full-service IT staff comprised of separate teams for different functions. Thanks, Lori Folta Lead EDI Engineer UniGroup --- In [email protected]<mailto:EDI-L%40yahoogroups.com>, Mike Rawlins wrote: > > Well, this seems kind of elementary unless I'm missing something. SI > uses a database like Oracle or SQL Server, right? Just track down the > username and password you used to for the installation to access the > database, start up SQLPlus or SQL Server enterprise manager (or whatever > your version calls it) and go poke around. > > Mike > > ----------------------------------------- > Michael C. Rawlins, Senior Software Engineer, GXS > Sent from personal account > > > On 1/7/2013 12:26 PM, L wrote: > > > > This begs a general question regarding SI 5.2. How does one find a > > list of table names and the fields contained therein? > > > > Thank you, > > Lori Folta > > Lead EDI Engineer > > UniGroup > > > > --- In [email protected]<mailto:EDI-L%40yahoogroups.com> , riaz > > mohammed wrote: > > > > > > YFS_USER > > > > > > > > > > > > ________________________________ > > > From: Vijay Chandra > > > To: "[email protected]<mailto:EDI-L%40yahoogroups.com> " > > > Sent: Wednesday, January 2, 2013 11:17 PM > > > Subject: [EDI-L] Generate report on User information(IBM Sterling > > Integrator 5.2) > > > > > > Â > > > Hi All, > > > > > > Can anyone please share the Database table names that store all User > > names and their corresponding details like permissions of that User. I > > need to generate a report on user permissions and found out that there > > is no pre-defined report configuration for fetching User information. > > The only way is to extract the values from Database. > > > > > > I am using IBM Sterling Integrator 5.2. > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > [Non-text portions of this message have been removed] ------------------------------------ ... Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Job postings are welcome, but for job postings or requests for work: <JOBS> IS REQUIRED in the subject line as a prefix.Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/EDI-L/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/EDI-L/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
