extracting info from Unix database to construct a visual diagram


 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users extracting info from Unix database to construct a visual diagram
# 1  
Old 11-30-2004
extracting info from Unix database to construct a visual diagram

Ok heres the situation,
We use Solaris 8 at work with Sybase for the db. I need to be able to easily create visual diagrams of some of our more complex systems. I've been using Visio which is such a manual process and takes a while.

I was thinking maybe using Visio somehow in conjunction with sql queries or something else like Apache. I'm not really sure, I was wondering if anyone else has done this before

Any info you can spare would be much appreciated

Thanks in advance
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Special IF construct syntax in UNIX

Hi, I don't understand && and || in this context. I thought && is for logical 'AND' and || is for logical 'OR'. && echo "Not empty" || echo "Empty" Please help Thank You (5 Replies)
Discussion started by: TomG
5 Replies

2. Shell Programming and Scripting

Have a situation while extracting info

i have a text file which i am generating from few sqls. format is like : col1 col2 col3 col4 col5 1001 DONE ABC 17-sep-14 12:02:05 1001 DONE ABC 17-sep-14 12:02:05 1001 DONE ABC 17-sep-14 12:02:55 1001 REDONE ABC ... (6 Replies)
Discussion started by: deepakiniimt
6 Replies

3. Shell Programming and Scripting

Request to checkVenn diagram issue solve by Unix programm

Hello Any Unix programm can help me to solve thsi issue: I have 2 venn digrams please checke the attached file for pictures of venn diagram for eg red is A yellow is B and green is C..Please see attached file for Venn diagrams In one ..... I have 3 data set A , B and C Venn diagram... (0 Replies)
Discussion started by: manigrover
0 Replies

4. Hardware

hardware diagram / database

Hi - we are looking for a (hopefully free/opensource) solution for diagramming our rack/hardware configuration. the rack solution seems easier to find than the hardware piece. i.e. on our IBM 770 with two CEC's, a method of noting what hardware points to what... for example, on the primary CEC,... (0 Replies)
Discussion started by: TinWalrus
0 Replies

5. Solaris

Extracting HBA Card Hardware info

Hello, I am very new to solaris so please bear with me. I have 2 machines in question. For both I am trying to get the HBA Card Hardware information such as: HBA Model Name HBA Firmware version HBA Port details HBA Driver details First machine is a Solaris 10. When I execute fcinfo... (6 Replies)
Discussion started by: flagman5
6 Replies

6. Shell Programming and Scripting

Downloading info from website to database

Hi guys! I created a database using mysql in bash now i would like to download weather info from the data.(temp, date and time)...and just store this in the database to display after every 3 hours or so... i have tried to get the website using wget and now dont exactly now how to go from here... (0 Replies)
Discussion started by: vadharah
0 Replies

7. UNIX for Dummies Questions & Answers

Extracting spec info from finger.

Hi everyone, I'm trying to extract the user name and full name from the finger command without using sed or awk. Any pointers? Thanks in advance. (6 Replies)
Discussion started by: franny
6 Replies

8. UNIX for Dummies Questions & Answers

Extracting Info

i have a file that contain lines like this 9.4.7.8.5.7.9.0.5.7.1.2.msisdn.sub.cs. 1 IN CNAME SDP01.cs. there are about 50,000 lines like this in the files i want to the extract the digits from the above line like:- 947857905712 OS Solaris9 (3 Replies)
Discussion started by: muneebr
3 Replies

9. UNIX for Advanced & Expert Users

Process diagram for 50+ unix scripts

Can someone point me to a good book for drawing a process diagram for 50+ unix scripts? The scripts run at different frequencies, and do everything from putting and getting data via FTP, to database I/O, to checking disk space ... etc. (0 Replies)
Discussion started by: tomstone_98
0 Replies
Login or Register to Ask a Question
Session::Store::Sybase(3)				User Contributed Perl Documentation				 Session::Store::Sybase(3)

NAME
Apache::Session::Store::Sybase - Store persistent data in a Sybase database SYNOPSIS
use Apache::Session::Store::Sybase; my $store = new Apache::Session::Store::MySQL; $store->insert( $ref ); $store->update( $ref ); $store->materialize( $ref ); $store->remove( $ref ); DESCRIPTION
Apache::Session::Store::Sybase fulfills the storage interface of Apache::Session. Session data is stored in a Sybase database. SCHEMA
To use this module, you will need at least these columns in a table called 'sessions': id CHAR(32) # or however long your session IDs are. a_session IMAGE To create this schema, you can execute this command using the isql or sqsh programs: CREATE TABLE sessions ( id CHAR(32) not null primary key, a_session TEXT ) go If you use some other command, ensure that there is a unique index on the id column of the table CONFIGURATION
The module must know what datasource, username, and password to use when connecting to the database. These values can be set using the options hash (see Apache::Session documentation). The options are: DataSource UserName Password Example: tie %hash, 'Apache::Session::Sybase', $id, { DataSource => 'dbi:Sybase:database=db;server=server', UserName => 'database_user', Password => 'K00l', Commit => 1, }; Instead, you may pass in an already-opened DBI handle to your database. tie %hash, 'Apache::Session::Sybase', $id, { Handle => $dbh }; Additional arguments you can pass to the backing store are: Commit - whether we should commit any changes; if you pass in an already-open database handle that has AutoCommit set to a true value, you do not need to set this. If you let Apache::Session::Store::Sybase create your database, handle, you must set this to a true value, otherwise, your changes will not be saved textsize - the value we should pass to the 'set textsize ' command that sets the max size of the IMAGE field. Default is 32K (at least in Sybase ASE 11.9.2). AUTHOR
This module was based on Apache::Session::Store::Oracle which was written by Jeffrey William Baker <jwbaker@acm.org>; it was modified by Chris Winters <chris@cwinters.com> to work with Apache::Session 1.5+ with changes from earlier version of Apache::Session::DBI::Sybase from Mark Landry <mdlandry@lincoln.midcoast.com>. SEE ALSO
Apache::Session perl v5.12.1 2007-09-28 Session::Store::Sybase(3)