HDTenEightyP/NetNews huggingface dataset:
From: paul@eunet.co.at (Paul Gillingwater)
Newsgroups: comp.databases,comp.databases.sybase,alt.cad
Subject: WANTED: Software to draw ER diagrams for Sybase
Date: 21 Jan 1993 21:42:23 +0100
Organization: EUnet EDV Dienstleistungs GmbH A-1010 Wien Austria
NNTP-Posting-Host: hp4at.eunet.co.at

Hi,
We have a large existing database in PACE that we have to migrate to
Sybase.  I've undertaken to redraw all the entity-relation diagrams, but
would like a software tool to do this (and maybe generate some of the
code necessary to build the tables?)

Primarily it should be a documentation tool, but if it can output
schemas then that would be great.  I've heard of DEFT, but believe this
only runs on the Mac.  What experiences have folks had with other tools,
and what about generic "drawing" packages like Corel?  Can they handle
this type of drawing easily?

Since our database has several *hundred* tables in 3nf, we would need
something that can handle the linkages and the rat's nest of lines
connecting boxes.

Thanks in advance!
-- 
Paul Gillingwater
Home system: paul@actrix.co.at (Waffle)
Newsgroups: comp.databases
From: mek@hydrox.enet.dec.com (Mark Klamerus)
Subject: IEEE Mass Storage Ref Model
Date: Fri, 22 Jan 93 05:47:58 PST
X-Received: by usenet.pa.dec.com; id AA19455; Fri, 22 Jan 93 05:48:00 -0800
X-Received: by enet-gw.pa.dec.com; id AA11457; Fri, 22 Jan 93 05:47:58 -0800
X-Received: from hydrox.enet; by decwrl.enet; Fri, 22 Jan 93 05:47:58 PST
X-To: comp.databases.usenet
X-Apparently-To: comp.databases.usenet


	Can someone tell me what this is?  I recently had a question
	regarding this in a pros/cons relation to SQL/Database.

	What is this model/methodology?  Does it have a number?
	Is there documentation regarding this on the net?

	thanks,
	Mark Klamerus

Newsgroups: comp.databases
From: umnoor@ccu.umanitoba.ca (Nasir Ahmed Noor)
Subject: Re: Paradox questions
Organization: University of Manitoba, Winnipeg, Canada
Date: Fri, 22 Jan 1993 23:51:18 GMT

field@.cs.pitt.edu.cs.pitt.edu (Brian Field) writes:

>2) 	How does one access the contents of a field name that have been passed
>	as an arguement to a procedure?  Do I need to use EXECUTE to do this,
>	or is there an alternative?

Following is a way. May not be the best way but gives you an alternative to
EXECUTE command.

Suppose variable name containing field name is FieldName

       MoveTo TableName
       MoveTo Field FieldName
       MyVar = FieldStr()

to move around you can use MoveTo command with combination of RecNo() and 
NRecords(). Also Up, Down, Home, End and Skip prove to be usefull. But you
will notice that not using EXECUTE forces you to read the value of field 
first into a var before you can manipulate it.
Hope it helps!

--nasir
umnoor@ccu.umanitoba.ca
Newsgroups: comp.databases
From: jjfink@skcla.monsanto.com
Subject: Re: ? Microsoft Access
Organization: Searle, Skokie, IL
Distribution: usa
Date: Wed, 27 Jan 1993 13:33:28 GMT

In article <C1H7tt.G4z@world.std.com>, iano@world.std.com (Ian J Ornstein) writes:
> 1.- How can I have a date automatically changed in the TABLE
>     when any field in a form is changed? I know I can use =Date()
>     in a form field. Can I do this without having a date field on
>     the form?

Have the "Before Update" property of the Form call a Macro which has
one line
	SetValue
with parameters
	Item:		[Last Mod Date]
	Expression:	NOW()

If the date field *is* visible, you may want to use the RepaintObject macro
action to display the new date.

> 2.- I'm using counter data type as keys for my tables.
>     I'd like to be able to do some sort of look up with the form
>     so that the text name from the reference table is displayed in the
>     form but only the value of the foreign key is stored in the table.
>     How can I do this?

Your form will have to be based on a Query that relates the two tables.  What
I'd suggest is to make the name field a Combo Box that has the Limit To List
property set to Yes, the Default is set to [Company Name], and has an After
Update property set to modify the ID Number in the primary file.

Joel
-- 
jjfink@skcla.monsanto.com
------------------------------------------------------------------------------
"I want peace on earth, and goodwill towards man."
"We don't do that kind of thing, we're the United States Government!"
  -- from _Sneakers_
Newsgroups: comp.databases
From: jbg@qualcom.qualcomm.com (Jeff Gehlhaar)
Subject: Q+E Product
Summary: Using Q+E
Keywords: Q+E, database access
Organization: Qualcomm, Inc., San Diego, CA
Date: Tue, 26 Jan 1993 20:57:43 GMT

Has anyone used the Q+E Products from Pioneer software? Specifically, their
DLL library with C++ or C?  Also, the tech support guy I spoke with did
not seem clear about how their DLLs gain access to the database. He said
that as long as my PC had access to the network I was okay.

Later, when pressed, he said, "Well of course you need SQL*Net if you
have Oracle....". For people with such experience, how do you gain access
to the database using Q+E. Is it as seemless as it sounds? Any experience
with Sybase in this area?

Thanks in advance for any help.

Jeff Gehlhaar
PC Eudora Development Team
QUALCOMM Incorporated
jbg@qualcomm.com

Newsgroups: comp.databases
From: John_Carson@mindlink.bc.ca (John Carson)
Subject: Re: Dbase III question
Organization: MIND LINK! - British Columbia, Canada
Date: Sun, 24 Jan 1993 19:20:07 GMT

> U56779@uicvm.uic.edu writes:
>
> Msg-ID: <93020.210833U56779@uicvm.uic.edu>
> Posted: Wed, 20 Jan 1993 21:08:3
>
> Org.  : University of Illinois at Chicago
>
> I working on a programm where I want to be as easy as possible.
> I created a name field in the .dbf file.  I call it by using
> x=space(20)
>  @12,12 "Enter name " get x picture "!XXXXXXXXXXXXXXXXXXXX"
> read
>
> This way it will allow user to type name with first letter being
> capitalized.  My question is that is there a way so that last name
> typed after a space within the same field could also have the
> first letter capitalized?
> I would appreciate all the help.
>
>                                                    -AP.


@ 12,12 "Enter Firstname:"  get x                  PICTURE "!XXXXXXXXXXX"
@ 13,12 "Enter Lastname: "  get y                  PICTURE "!XXXXXXXXXXX"

mname = trim(x)+" "+y
REPLACE FIRSTNAME WITH x
REPLACE LASTNAME WITH y
REPLACE FULLNAME WITH mname

etc etc

You can either store "mname or x and y" into the DBF file or use both.
I was not going to add all the other stuff just what you may need to get this
acheived.

John

--
>>>>>>>>>>>>>>>>>>> John_Carson@MINDLINK.BC.CA <<<<<<<<<<<<<<<<<<<<<
>>        D.John Carson    J & H Concepts   (604)589-5118         <<
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>><<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
Newsgroups: comp.databases
From: les@chinet.chi.il.us (Leslie Mikesell)
Subject: Re: picking between FoxPro and Paradox
Organization: Chinet - Public Access UNIX
Date: Tue, 26 Jan 1993 15:49:11 GMT
Keywords: help

In article <troj.728016494@cwis> troj@cwis.unomaha.edu (Kevin Trojanowski) writes:
>If you go with Paradox, you gain an easy advantage, in that you can purchase
>the Paradox Engine, and have your C code directly access the Paradox tables.
>What this allows you to do is write part of your application in PAL
>(Paradox Application Language), and have it run external C programs when
>necessary, but still allow the C code full access to the data without
>having to go through the overhead of exporting/importing the data.

A library development kit is available for foxpro too, and it includes
the Watcom compiler and dos extender for running in 32-bit mode.

>I'll freely admit that, like anything similar, there's a bit of a learning
>curver for the Pdox Engine.  However, I've not found it to be an overly
>difficult one -- just a matter of learning how to setup for the various
>calls, and understanding how Paradox field types map to C types.  It'll
>take you a couple of days of playing around, but it's none too painful.

Perhaps I don't understand Paradox well enough, but I have never been
able to build a set of screens, reports, etc. with the interactive
tools and then easily tie them together into a menu driven application
with a little program code.  In Foxpro it is pretty easy to do that.
You still have to understand the programming language but it's easy
to do the bulk of the work with the tools and still attach explicit
program code where you need it.

Les Mikesell
  les@chinet.chi.il.us 
Newsgroups: comp.dcom.isdn
From: nisimura@sran233.sra.co.jp (Tohru Nishimura)
Subject: Re: Subaddressing (was: ISDN/analog interfacing)
Organization: Software Research Associates, Inc., Japan
Date: Wed, 27 Jan 1993 01:56:42 GMT

ketil@edb.tih.no (Ketil Albertsen,TIH) writes;

>>there is no voice equipemnt at called side, no
>>ringing occurs;  Synthesising (woman) voice would answer; "There is no
>>equipment you can talk with.....", even if "dataline" ISDN TA or ISDN/IP
>>card is attached at called side.  This is a Japanese implemetation. I
>>don't know other countries' implementation.
>
>It sounds as if you are running some timeout-counter in the NT1 to detect
>that none of the connected units responds. Of course that is OK, but the
>conclusion you draw by letting some automatic answering machine say that
>"there is no equipment you can talk with" is a little too general, isn't it?

Timeout-counter is not in the NT1 equip.  ISDN exchange can detect which
type equipments are attached to customer ISDN busline, and ISDN exchange
subsystem will answer as "There is no equipment you can talk with....."
IN THE CASE OF caller is ordinal analog telephone system.

If caller uses ISDN, caller will get various ISDN indication information
from remote side;  "Callee refuses you", "There is no equip for you", or
"Something wrong in net" answered by ISDN exchange....

- nisimura
Newsgroups: comp.dcom.isdn
From: bob1@cos.com (Bob Blackshaw)
Subject: Re: Subaddressing (was: ISDN/analog interfacing)
Organization: Corporation for Open Systems
Distribution: world 
Date: Wed, 27 Jan 1993 14:28:08 GMT

In <scott.728100851@labtam> scott@labtam.labtam.oz.au (Scott Colwell) writes:

>ketil@edb.tih.no (Ketil Albertsen,TIH) writes:

>>In article <C1GM74.Czq@sranhd.sra.co.jp>, nisimura@sran233.sra.co.jp (Tohru 
>>Nishimura) writes:

>>>For example, when you call an ISDN number with ordinal analog telephone
>>>(with/without ISDN), and there is no voice equipemnt at called side, no
>>>ringing occurs;  Synthesising (woman) voice would answer; "There is no
>>>equipment you can talk with.....", even if "dataline" ISDN TA or ISDN/IP
>>>card is attached at called side.  This is a Japanese implemetation. I
>>>don't know other countries' implementation.

>>It sounds as if you are running some timeout-counter in the NT1 to detect
>>that none of the connected units responds.

>The timeout happens at the exchange.  It sends a setup message to any
>devices on the S i/f, they can either decide to ignore it or they can
>respond with an alerting message (meaning that they are 'ringing the phone').

>When the call is accepted locally ('picking up the phone'), a connect message
>is sent to the exchange.
>-- 
I would imagine that in the case Nishimura San was commenting upon, i.e.,
an ordinary analog voice call into the ISDN world, the I.500 series of
CCITT Recs would have something to say. At the POTS to ISDN interface
point, the ISDN part would need to construct a SETUP message and fill
in as much detail as possible. If it 'knows' that the POTS call is
voice, the SETUP should identify it as such. At the called line, the
compatibility check procedures could take place as normal.

I believe that this last study period has seen much work done on the
I.500 series, someone who attends the meetings might comment.

>Scott Colwell				Labtam Australia Pty. Ltd.
>net:	scott@labtam.labtam.oz.au	41 Malcolm Rd., Braeside
>phone:	+61-3-587-1444			Melbourne, Australia  3195

Bob.

Newsgroups: comp.dcom.isdn
From: nisimura@sran233.sra.co.jp (Tohru Nishimura)
Subject: Re: Subaddressing
Organization: Software Research Associates, Inc., Japan
Date: Tue, 26 Jan 1993 12:19:30 GMT

In my last article;

> Unique subaddress
> can be assigned to each equipment ("port") and you can explicitly
> call one of them, for example;
>
>                03-5276-7358#any_string_you_wish
                             ^
	Subaddress seperator is *, in stead of #.  # is delimitor which
	happens to expedite dialing, sorry.

Tohru Nishimura
Software Reseach Associates, Inc.
From: bob1@cos.com (Bob Blackshaw)
Subject: Re: INS-64 TA and TA+MODEM in a box?
Organization: Corporation for Open Systems
Distribution: world 
Date: Thu, 28 Jan 1993 14:43:10 GMT

In <36400@twics.co.jp> burress@twics.co.jp (Tim Burress) writes:

>Does anyone have recommendations for terminal adapters to be used with NTT
>INS-64? 

>Also, does anyone make some kind of "TA+MODEM in a box" device?  We run a
>public-access dialup service in Tokyo, and the current plan is to connect each
>B-ISDN line to a terminal adapter that outputs analog, then run the two analog
>lines into modems where they'll be converted into serial data for our host
>ports.  But it seems kind'a silly to convert from digital to analog to digital
>again, so I wondered if anybody has combined the two functions in one box. 

Well, I have three TAs right here that offer serial digital output as
in V.24, or V.35. Unfortunately, due to certain agreements I cannot
mention names. However, I don't believe these units are unique and
I would imagine most TAs work this way.

>Or is there a better way???

>						Thanks!

>-- 
>Tim Burress                                     Internet:  burress@twics.co.jp
>TWICS Co., Ltd.
>1-21 Yotsuya, Shinjuku-ku, Tokyo 160 Japan

Bob
Newsgroups: comp.dcom.isdn
From: jeff@is.s.u-tokyo.ac.jp (Jeff McAffer)
Subject: Thanks!
Reply-To: jeff@is.s.u-tokyo.ac.jp
Organization: University of Tokyo / Object Technology International
Date: Fri, 22 Jan 1993 10:59:44 GMT
Distribution: comp
X-Bytes: 1295

Recently I posted a bit of a rant fest about my frustrations with
ISDN.  I would just like to thank everyone who responded.  Nothing was
actually resolved but I understand better the cause of my
frustrations.

It would seem that I have fallen prey to the marketting gods who claim
that ISDN is here and has solved our problems.  It is indeed here (in
Japan its everywhere) but there are still problems.  I guess I was
expecting a flexible plug-and-play solution (ala analog modems).  I'm
sure that will come but it appears to be early days.  Also, perhaps I
was/am naive wrt the goals/role of ISDN.  I know what *I* want to use
it for but that does not necessarily map to other people's needs.

From the recent postings it seems that many people are in roughly the
same situation as I am and are just looking for *a* solution that
actually works and does not require a mortgage.

Anyway, thanks.  I have not lost hope but for now its not a reasonable
cost/performance deal.  I await anxiously the day when I can run a 4:1
(or better) compression scheme over dual 64kbit lines for a 512kbit/s
connection to my favorite local and not so local hosts.
--
ato de, |m        -- "Throughout my life I have sought peace and quiet"
                                                          - Ted Nuggent
Newsgroups: comp.dcom.isdn
From: nisimura@sran233.sra.co.jp (Tohru Nishimura)
Subject: Re: Subaddressing
Organization: Software Research Associates, Inc., Japan
Date: Wed, 27 Jan 1993 14:04:51 GMT

ketil@edb.tih.no (Ketil Albertsen,TIH) writes;

>>[...] ISDN exchange can detect which
>>type equipments are attached to customer ISDN busline, and ISDN exchange
>>subsystem will answer as "There is no equipment you can talk with....."
>>IN THE CASE OF caller is ordinal analog telephone system.
>
>How can the exchange know?

Oh well, the only thing I would like to point out is, "There is no equipment
you can talk with....." voice messages would be returned by an ISDN exchange,
instead of remote NT1, nor my local telephony equip.  That's all.

Any other questions?  I would like to talk about ISDN in real life with
customers' words, rather than communication engineers' techy jargons.

- nisimura
Newsgroups: comp.dcom.isdn
From: scott@labtam.labtam.oz.au (Scott Colwell)
Subject: Re: Subaddressing (was: ISDN/analog interfacing)
Organization: Labtam Australia Pty. Ltd., Melbourne, Australia
Date: Wed, 27 Jan 1993 02:14:11 GMT

ketil@edb.tih.no (Ketil Albertsen,TIH) writes:

>In article <C1GM74.Czq@sranhd.sra.co.jp>, nisimura@sran233.sra.co.jp (Tohru 
>Nishimura) writes:

>>For example, when you call an ISDN number with ordinal analog telephone
>>(with/without ISDN), and there is no voice equipemnt at called side, no
>>ringing occurs;  Synthesising (woman) voice would answer; "There is no
>>equipment you can talk with.....", even if "dataline" ISDN TA or ISDN/IP
>>card is attached at called side.  This is a Japanese implemetation. I
>>don't know other countries' implementation.

>It sounds as if you are running some timeout-counter in the NT1 to detect
>that none of the connected units responds.

The timeout happens at the exchange.  It sends a setup message to any
devices on the S i/f, they can either decide to ignore it or they can
respond with an alerting message (meaning that they are 'ringing the phone').

When the call is accepted locally ('picking up the phone'), a connect message
is sent to the exchange.
-- 
Scott Colwell				Labtam Australia Pty. Ltd.
net:	scott@labtam.labtam.oz.au	41 Malcolm Rd., Braeside
phone:	+61-3-587-1444			Melbourne, Australia  3195
Organization: Stanford Linear Accelerator Center
Date: Monday, 25 Jan 1993 10:21:22 PST
From: <DEP@SLACVM.SLAC.STANFORD.EDU>
Newsgroups: comp.dcom.isdn
Subject: Combinet Interchange ISDN Bridge

I'm seeking comment, obervations, advice, etc., from users of the
Combinet INTERCHANGE ISDN Bridge.

Don Pelton
dep@slacvm.slac.stanford.edu
From: jbatson@cayman.com (Jay Batson)
Newsgroups: comp.dcom.isdn
Subject: Re: Low cost ether/isdn brouters (was PC-NFS PPP Serial/ISDN driver wanted)
Date: 22 Jan 93 14:34:55 GMT
Reply-To: jbatson@cayman.com
Distribution: usa

In article <1993Jan21.151029.13640@gandalf.ca> dcarr@gandalf.ca (Dave Carr)  
writes:
> In <1993Jan21.012021.8668@informix.com> johng@informix.com (John Galloway)  
writes:
> >Just 2x64k (uncompressed would be ok), with real router sw (SNMP, RIP, ARP,
> >OSI?) rather than a filtering bridge is what I want. However it can be
> >oriented to a very small net doing quite simple routing (i.e. its not due
> >to a vast LAN at my house, but the fact that I, may, want a different  
network
> >then the other end of the bridge, that makes me want a router rather than a
> >bridge).
> 
> Interesting.  Could you tell me more.  With ISDN, we are basically talking
> about a point-to-point link.  Our view is with the right software mods, you
> can get the desired performance out of a bridge.  The trickiest part is the
> handling of multicast and broadcast.  If we can eliminate these packets
> without doing the entire routing function, do we have what you need?

Besides the very crucial point made above (that you want two different network  
numbers on either side of the link), most routers do tons of other things, such  
as "encapsulation" of one protocol in another, e.g. AppleTalk in IP for people  
who mandate IP-only networks.  This is typically called "tunneling", and  
requires routers at each end that are each configured to know about the tunnel.   
The devices at each end mostly have to be routers because the various  
psuedo-standard tunnelling implementations use routing protocol info to  
accomplish their goal.  (The routing tables themselves are not particularly  
complex - a packet is either local or remote for most single-WAN-port  
routers....)  Tunnelling is only one example - other features might include  
filtering based on service type or device name (vs. network #), which requires  
a fairly tall stack for the protocol in question.  Such features are growing in  
number and are supported by more and more router vendors.

I'll concede that at some point, the line between complex bridges and simple  
routers blurs, but usually bridges slip in features without adding complete  
stacks.  Routers maintain complete stack and protocol info, and router vendors  
are aggressively using the resulting flexibility they get, of course at a  
cost....
 
> Over digital links, do you need CRC32?

The phone companies must think so.  Many T1 lines now use something called an  
"Enhanced super frame", which adds a CRC to the traditional T1 frame.   
Remember, over long distances even digital pulses start to look like analog  
pulses, and errors can creep in.  Another question to ask might be "Who needs  
to do the error detection/correction, and why?"  It depends on who is supplying  
the service, and what problem they are trying to address. 
--
Jay Batson
Product Marketing Manager
Cayman Systems, Inc.
jbatson@cayman.com
(617) 494-1999
Newsgroups: comp.dcom.isdn
From: bob1@cos.com (Bob Blackshaw)
Subject: Re: 23B+D (PBX) & 2B+D (Home)
Organization: Corporation for Open Systems
Distribution: world 
Date: Thu, 28 Jan 1993 14:37:14 GMT

In <1993Jan15.234844.14874@atlastele.com> bcapps@atlastele.com (Brent Capps) writes:

>In a previous article I wrote:
>>You wouldn't want to make the T1 23B+D to do this -- too many muxing
>>problems.  Instead, you'd want to order the T1 to run ESF/B8ZS, DACS 
>>out the DS0s to _24_ residences as leased lines and drive each DS0 
>>as a BRI OPX on the PBX.  

>On second thought this won't work either, a full 2B+D BRI won't fit onto 
>a DS0.  If you want your PBX to run the phone like an OPX as you suggest, 
>this becomes a much trickier problem than it appears.  First, in your
>original plan you were using 23B+D to drive 23 * 2B+D, which is a mismatch in
>both the number of B channels supported and the bandwidth of the D
>channels (23 * 16K = 368K BRI vs. 64K PRI).  That would imply that the
>CO was performing a switching function between the BRI and PRI channels,
>so what you've got is not really an OPX.

>Somebody please tell me if I've overlooked something, but the more I think 
>about this, the more it sounds like you would experience a lot of problems 
>letting the PBX provide your "dial tone", as it were.  You really need the 
>CO to handle the switching, multiplexing, and concentration issues for you, 
>which is to say that you *can't* run these like OPXs off your PBX.  

As I understand the original poster, he wanted 'dialtone' from his
PBX for regular access purposes, i.e., the homes would be extensions
of his PBX, could do 4-digit dial to other extensions. etc. I would
imagine that regular BRI from the CO and some form of numbering plan
games at the switch would be simpler. Or did I misunderstand?

>-- 
>Brent Capps                          | 
>bcapps@agora.rain.com (gay stuff)    | Quis corriget correctores ipsos?
>bcapps@atlastele.com (telecom stuff) |

Bob.

Newsgroups: comp.dcom.isdn
From: jeff@is.s.u-tokyo.ac.jp (Jeff McAffer)
Subject: ISDN/analog interfacing
Reply-To: jeff@is.s.u-tokyo.ac.jp
Organization: University of Tokyo / Object Technology International
Date: Tue, 26 Jan 1993 06:23:11 GMT
Distribution: comp
X-Bytes: 490

I have seen some stuff on ISDN serial TAs which have analog ports on
them.  If I want to dial *into* that analog port, how is that
accomplished?  I assume that the analog port has some sort of
subaddress but how do I specify that at the calling end?  Is the
analog nature of the incoming call detected automatically by the TA?

Thanks again


--
ato de, |m        -- "Throughout my life I have sought peace and quiet"
                                                          - Ted Nuggent
Newsgroups: comp.dcom.isdn
From: jeff@is.s.u-tokyo.ac.jp (Jeff McAffer)
Subject: Sparc 10 ISDN software
Reply-To: jeff@is.s.u-tokyo.ac.jp
Organization: University of Tokyo / Object Technology International
Date: Tue, 26 Jan 1993 06:26:33 GMT
Distribution: comp
X-Bytes: 371

I hear that ISDN is not supported in Solaris 1.0 but only Solaris 2.1
on the Sparc 10.  True?  

In either case, what software is (will soon be) available?  Does
anyone know what software Sun will provide?  Public Domain?


--
ato de, |m        -- "Throughout my life I have sought peace and quiet"
                                                          - Ted Nuggent