Re: [U2] Get External Sql Data Dynamically

[Results]

Ken,

Meanwhile, jBASE remains the only MV product on the market which does allow
transparent integration with external databases.  The jBASE jEDI interface
does the same sort of things as OFS, but extends throughout the product and
works transparently behind every facet of jBASE - BASIC, TCL, PROC, etc.
Actually, Reality has a better support than jBASE and ON Corp is refers 
to their system as a database independent MV environment.

Kris, you could also build an automated update to your SQL database with 
any number of tools, including [AD] the upcoming Zeus SQL Edition 
(scheduled for release June/July of this year) [/AD].
Additionally, you could make the SQL system drive the process and have 
it output to flatfile which you can link to U2 by declaring it a type 19 
file. Not so closed after all, is it? For that matter, you could make 
the U2 database work as a web service and make the SQL do the same and 
cross-update using CGI.

--
- Charles Barouch
[EMAIL PROTECTED] - Zeus Data Integration
[EMAIL PROTECTED]- Consulting services
(718) 762-3884 x 1 - Key Ally Voice mail
Mount Olympus, Home of Zeus Data Integration
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

RE: [U2] Get External Sql Data Dynamically

[Ken Wallis]

Kris Stevens wrote:

> That was our first solution was updating a local file with
> the data from the sql table.
> I was hoping for something "a little more dynamic", but that
> is what you get with a "closed environment" that UniData is.

What you want to do is what the OFS used to do, and still does do, (and is
documented to do) but is now (strongly) deprecated, as far as I can tell.

OFS provides a mechanism through which you can identify an alternate set of
'C' routines which will transparently handle I/O to your data source.  Once
upon a time there was a third party that wrote and distributed a library set
called DAM (Data Access Modules) which provided OFS access to Oracle/Sybase
and Informix.  I still support one site that runs this DAM software to
interface with Oracle (in fact they are just doing testing of the interface
with UniData 6 and Oracle 9i).

There are many uglinesses about OFS.  The worst of which is that it only
works for BASIC programs and not for ECL commands (though the DAM libraries
do fashion a kludge which allows a form of SELECT to work).  Others include
the way in which it has been treated by Ardent/Informix and IBM with extra
bits being added to the API to support the aborted SQLator project, but
never documented properly so others could update their OFS drivers to allow
for things like transaction commit and rollback.  The DAM libraries had
their own uglinesses in that they used STATIC SQL statements (ie no
parameter passing, just hard coded values in the SQL for each update or
select) which tended to make Oracle administrators in particular have a cow
whenever they analysed what was going in and out of the database.

The best thing about OFS though is that once you have the code in place and
you set up an "FX" VOC pointer, an external RDBMS table, or set of tables,
can simply be OPENed by a BASIC program which can then do READs and WRITEs
without knowing that it is connected to anything unusual.

I believe that at least one other contributor to this list has written his
own OFS driver for Oracle.  I doubt he'd share with you, because it isn't a
trivial thing to do, and I'm not recommending you try and write you own -
again because it really isn't a trivial exercise.  I suppose I'm just
pointing out that there used to be a way to do this quite well (OFS was
first introduced in UniData 3.1 about 10 years ago), but it got sat on and
squished until it died and now the best alternative is BCI which still only
works from BASIC and still requires you to purchase and install a third
party component (the ODBC manager).

Last time I saw a U2 presentation there was talk of something new being
developed to sort of replace OFS but work everywhere, but I don't recall the
timeline on that being anywhere 'real soon now'.

Meanwhile, jBASE remains the only MV product on the market which does allow
transparent integration with external databases.  The jBASE jEDI interface
does the same sort of things as OFS, but extends throughout the product and
works transparently behind every facet of jBASE - BASIC, TCL, PROC, etc.  As
someone who has written jEDI drivers and supports live sites that use them,
I know that the jEDI is not perfect, but it does work.  Now if only I could
persuade the guys at Temenos not to do to the jEDI what UniData did to OFS,
I'd be a happy camper.  Sadly though, they already seem to be heading for
the dark side - adding new bits to the API and refusing to document them,
changing things that used to work and improving them until they don't ...

Cheers,

Ken

PS.  In your specific example:

>> List  MYLocalFILE  where MyRemoteKey = "X" MyRemoteData

It looks like you have a UniData file whose KEYs are significant to your
external data source.  That your external data is essentially providing
additional attributes that you want to access and query from within UniData.
That being the case, you may well be able to use BCI inside a SUBR called
from a Virtual Field (I type) to access the data in the remote database and
retrieve it.  With a bit of judicious use of named common you could even
make this reasonably efficient so that accessing 5 separate virtual fields
based on the same UniData key value would only go to your external data
source once.

The tricky bit about transparent access comes when you have NO local data
records from which you can drive your queries, simply the knowledge that an
entity exists "somewhere else" and contains information that you need to
see:

LIST MyRemoteFile WITH ItsRemoteKey = "Y"

There really is no way to do this except to run a specific BCI BASIC program
to access the information and return it in a specific format.

> David Beahm wrote:

> BCI doesn't offer quite as tight an integration as that.
> What it gives
> you is the ability to read and write to SQL data sources from within
> UniBasic.  For instance, we have a table that exists in MySQL, but we
> need to access the data from UniData (and for the moment we
> don't have
> time to change 

Re: [U2] Get External Sql Data Dynamically

[FFT2001]

In a message dated 5/6/2004 3:53:03 PM Pacific Daylight Time, 
[EMAIL PROTECTED] writes:


> I was hoping for something "a little more dynamic", but that is what you 
> get
> with a "closed environment" that UniData is. 

Unidata is not closed.
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

Re: [U2] D3 Master Dictionary

[Mark Johnson]

1. D3 supports PQ and PQN procs interchangably.
2. LIST MD = "CUSTOMER" resulted in No Items Present.
3. I don't plan to change either MD or M/DICT. I will change my habit and
store my MD stuff in M/DICT.
4. Typing LIST-FILES got me the files listed and when I edited the process
LIST-FILES, I saw the M/DICT.

Thanks for all who helped.
Mark Johnson
- Original Message -
From: "Bill H." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 06, 2004 9:27 PM
Subject: RE: [U2] D3 Master Dictionary


> Mark:
>
> > Pardon being a D3 question but someone may have run into this
> > before.
> >
> > My new client has D3 on W2K. I edited MD BOB and made
> > 001=PQN,
> > 002=HTIME and
> > 003=P, saved it and then type BOB at TCL and get [3] VERB?.
>
> There are no PQN procs in D3 (I don't believe).  Change field 001 to PQ.
>
> > I type LIST CUSTOMER and get output but when I type LIST MD =
> > "CUSTOMER" I get nothing.
>
> I'm not sure what's up since "CUSTOMER" is a file (or q pointer) and
should
> reside in the MD.  When you say you "...get nothing" what do you mean
(let's
> see the command and the result).
>
> > I've found out that there's 2 MD's. One called MD which points
> > to that accounts SYSTEM defined space and another called
> > M/DICT which points to another account that contains the
> > cataloged programs, filenames, verbs etc and lets BOB work.
>
> That's unusual.  Usually the MD "MD" item is a q pointer to the current
> account and so is the MD "M/DICT" item.  They're synonyms.  There must be
> specific reasons to change that structure and I'm not going to guess.  I'm
> not sure what you mean by the "...SYSTEM defined space" but I'd guess you
> mean it points to the current account like:
>
> MD  'MD' size = 116
> 01 q
> 02
> 03
> 04
> 05
> 06
> 07
> 08
> 09 l
> 10 17
> 11
> 12
> 13
> 14
> 15
> 16
> 17 the item.id of a dictionary item is the name of the language
>element being defined.
>
> > So my question is what would happen if I made MD point to that
> > other account?  Would I mess anything up. Their system runs
> > 20/7 but I'm not there at 4am to try this.
>
> I'd suggest you NEVER mess with this as someone else has made the change
for
> some reason.  Normally the "M/DICT" item is a synonym to "MD" but is
changed
> for some unknown reason.  In D3, you can reference another accounts MD by
> simply referencing "ACCOUNT,," or "ACCOUNT,MD,".  If the "M/DICT" item has
> changed I'd think there is a reference to "M/DICT" somewhere but won't
guess
> where.
>
> I can't say for sure, but when you execute a verb the MD is searched
first.
> I don't know if the M/DICT is searched next or at all.  So, either the
> "M/DICT" MD item is inconsequential or it acts a little like a PATH.
Maybe
> a posting to CDP would answer this.
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.u2ug.org/listinfo/u2-users
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

Re: [U2] D3 Master Dictionary

[Tony Wood]

They are pointing to different accounts.

MD MD is pointing to the current account but MD M/DICT is pointing to the md
of the ADMIN account.

If you change MD MD to be the same as MD M/DICT you may break the system
especially where file pointers are concerned. Although if you NEED to do
this I am sure it can be done.

Regards,

T.

- Original Message - 
From: "Mark Johnson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 07, 2004 9:26 AM
Subject: Re: [U2] D3 Master Dictionary


> You missed my original point. It appears that there are 2 MD's. One's
called
> MD and the other is called M/DICT and they both appear to be present in
the
> application account but reference 2 different files.
>
> If I type in the following I get the following:
>
> ED MD MD
> 001 Q
>
> ED MD M/DICT
> 001 Q
> 002 ADMIN
>
> There is an account called ADMIN as well as the application account,
called
> MAIN.
>
> Apparently the normal file pointer for the Master Dictionary of an account
> is the Account's SYSTEM file reference. This is both old-school (native)
and
> D3 technology. Microdata used to have 4 references to their SYSTEM item
that
> was the MD for that account: MD, DICT, M/DICT and DL/ID.
>
> I haven't seen 2 MD's in a while. If I COUNT MD I get 2,000 items. If I
> COUNT M/DICT, I get 4,500 items.
>
> If I type LIST M/DICT "CUSTOMER" I get the display indicating it being
> there.
>
> My question is if I make the MD MD item the same as the MD M/DICT item
what
> would happen.
>
> Thanks in advance.
>
>
> - Original Message -
> From: "Eugene Perry" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, May 06, 2004 7:05 PM
> Subject: Re: [U2] D3 Master Dictionary
>
>
> > The highest file on a D3 system is known as MDS.  It contains the
account
> > records.  In your account called BOB, you have a file called MD which is
> the
> > equivalent of VOC.  It contains all the verbs, file definititions,
> cataloged
> > programs etc.
> >
> > When you type LIST CUSTOMER, you are listing the customer file.  If you
> want
> > to list the MD for a record called CUSTOMER, which happens to be  your
> > CUSTOMER file, you could type LIST MD WITH *A0 "CUSTOMER" and it would
> > display it.
> >
> > Eugene
> >
> > - Original Message -
> > From: "Mark Johnson" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Thursday, May 06, 2004 3:45 PM
> > Subject: [U2] D3 Master Dictionary
> >
> >
> > > Pardon being a D3 question but someone may have run into this before.
> > >
> > > My new client has D3 on W2K. I edited MD BOB and made 001=PQN,
002=HTIME
> > and
> > > 003=P, saved it and then type BOB at TCL and get [3] VERB?.
> > >
> > > I type LIST CUSTOMER and get output but when I type LIST MD =
"CUSTOMER"
> I
> > get
> > > nothing.
> > >
> > > I've found out that there's 2 MD's. One called MD which points to that
> > > accounts SYSTEM defined space and another called M/DICT which points
to
> > > another account that contains the cataloged programs, filenames, verbs
> etc
> > and
> > > lets BOB work.
> > >
> > > So my question is what would happen if I made MD point to that other
> > account?
> > > Would I mess anything up. Their system runs 20/7 but I'm not there at
> 4am
> > to
> > > try this.
> > >
> > > Please no VOC flames. Thanks.
> > > ---
> > > u2-users mailing list
> > > [EMAIL PROTECTED]
> > > http://www.u2ug.org/listinfo/u2-users
> > ---
> > u2-users mailing list
> > [EMAIL PROTECTED]
> > http://www.u2ug.org/listinfo/u2-users
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.u2ug.org/listinfo/u2-users
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

RE: [U2] D3 Master Dictionary

[Bill H.]

Mark:

> Pardon being a D3 question but someone may have run into this
> before.
>
> My new client has D3 on W2K. I edited MD BOB and made
> 001=PQN,
> 002=HTIME and
> 003=P, saved it and then type BOB at TCL and get [3] VERB?.

There are no PQN procs in D3 (I don't believe).  Change field 001 to PQ.

> I type LIST CUSTOMER and get output but when I type LIST MD =
> "CUSTOMER" I get nothing.

I'm not sure what's up since "CUSTOMER" is a file (or q pointer) and should
reside in the MD.  When you say you "...get nothing" what do you mean (let's
see the command and the result).

> I've found out that there's 2 MD's. One called MD which points
> to that accounts SYSTEM defined space and another called
> M/DICT which points to another account that contains the
> cataloged programs, filenames, verbs etc and lets BOB work.

That's unusual.  Usually the MD "MD" item is a q pointer to the current
account and so is the MD "M/DICT" item.  They're synonyms.  There must be
specific reasons to change that structure and I'm not going to guess.  I'm
not sure what you mean by the "...SYSTEM defined space" but I'd guess you
mean it points to the current account like:

MD  'MD' size = 116
01 q
02
03
04
05
06
07
08
09 l
10 17
11
12
13
14
15
16
17 the item.id of a dictionary item is the name of the language
   element being defined.

> So my question is what would happen if I made MD point to that
> other account?  Would I mess anything up. Their system runs
> 20/7 but I'm not there at 4am to try this.

I'd suggest you NEVER mess with this as someone else has made the change for
some reason.  Normally the "M/DICT" item is a synonym to "MD" but is changed
for some unknown reason.  In D3, you can reference another accounts MD by
simply referencing "ACCOUNT,," or "ACCOUNT,MD,".  If the "M/DICT" item has
changed I'd think there is a reference to "M/DICT" somewhere but won't guess
where.

I can't say for sure, but when you execute a verb the MD is searched first.
I don't know if the M/DICT is searched next or at all.  So, either the
"M/DICT" MD item is inconsequential or it acts a little like a PATH.  Maybe
a posting to CDP would answer this.
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

Re: [U2] D3 Master Dictionary

[Eugene Perry]

No, they changed that name of the SYSPROG account to DM.  They also changed
the name of the highest level file (where all the accounts are stored) from
SYSTEM to MDS.

Eugene

- Original Message -
From: "Kryka, Richard" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 06, 2004 4:44 PM
Subject: RE: [U2] D3 Master Dictionary


> Its been a while, but I seem to recall that Pick changed the name from
> MD to DM.  Try placing your BOB there.
>
> Dick Kryka
> Director of Applications
> CCCS of Greater Denver, Inc.
> Paragon Financial Services
> 303-632-2226
> [EMAIL PROTECTED]
>
> -Original Message-
> From: Mark Johnson [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 06, 2004 3:46 PM
> To: [EMAIL PROTECTED]
> Subject: [U2] D3 Master Dictionary
>
> Pardon being a D3 question but someone may have run into this before.
>
> My new client has D3 on W2K. I edited MD BOB and made 001=PQN, 002=HTIME
> and
> 003=P, saved it and then type BOB at TCL and get [3] VERB?.
>
> I type LIST CUSTOMER and get output but when I type LIST MD = "CUSTOMER"
> I get
> nothing.
>
> I've found out that there's 2 MD's. One called MD which points to that
> accounts SYSTEM defined space and another called M/DICT which points to
> another account that contains the cataloged programs, filenames, verbs
> etc and
> lets BOB work.
>
> So my question is what would happen if I made MD point to that other
> account?
> Would I mess anything up. Their system runs 20/7 but I'm not there at
> 4am to
> try this.
>
> Please no VOC flames. Thanks.
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.u2ug.org/listinfo/u2-users
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.u2ug.org/listinfo/u2-users
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

RE: [U2] Get External Sql Data Dynamically

[Tom Firl]

Could Kris use an I-descriptor to call a BASIC SUBRoutine that uses BCI to retrieve 
the value in the SQL database?

Tom Firl

> -Original Message-
> From: David Beahm [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 06, 2004 2:52 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [U2] Get External Sql Data Dynamically
> 
> 
> BCI doesn't offer quite as tight an integration as that.  
> What it gives 
> you is the ability to read and write to SQL data sources from within 
> UniBasic.  For instance, we have a table that exists in MySQL, but we 
> need to access the data from UniData (and for the moment we 
> don't have 
> time to change the user interface to support interfacing with 
> UniData -- 
> besides it made a good test case).  Anyway, we were able to 
> execute SQL 
> queries against the external database from within a program.  In your 
> case, you might want to write a program that updates a local 
> file with 
> data from the SQL table.  Then you can use all your familiar Retrieve 
> logic (I-types, etc.)
> 
> HTH,
> David Beahm
> 
> 
> 
> Kris Stevens wrote:
> 
> > Thanks for the response. 
> > 
> > Here is a followup question, to verify I am asking my 
> question clearly.
> > 
> > What I am trying to do is:
> > 
> > List  MYLocalFILE  where MyRemoteKey = "X" MyRemoteData
> > 
> > where the MyLocalfile is a local unidata mv file.  
> > MyRemoteKey is a dict item that references the remote SQL 
> table on the
> > network.
> > MyRemoteData is a dict item that returns the value from the 
> remote SQL
> > table.
> > 
> > The clients would not have any software installed, just the 
> server only.
> > 
> > Would this need to be done in a datatel subroutine?
> > 
> > Thanks!
> > 
> > Kris Stevens
> > 
> > 
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] Behalf Of David Beahm
> > Sent: Thursday, May 06, 2004 1:44 PM
> > To: [EMAIL PROTECTED]
> > Subject: Re: [U2] Get External Sql Data Dynamically
> > 
> > 
> > Yes, BCI is the tool.  If you're on Unix, you also need to 
> have an ODBC 
> > manager.  Being on 64-bit HP-UX (which makes it hard to 
> find compatible 
> > OTS software), we ended up using EasySoft's ODBC-ODBC 
> bridge (they made 
> > a custom port to HP-UX for us), which is working great.
> > 
> > Best,
> > David Beahm
> > 
> > Tom Firl wrote:
> > 
> >>Take a look at BCI... this is the U2 feature that provides 
> ODBC client
> > 
> > functionality.  I personally haven't used it, but several 
> readers of this
> > group have...
> > 
> >>Tom Firl
> >>Columbia Ultimate
> > 
> > ---
> > u2-users mailing list
> > [EMAIL PROTECTED]
> > http://www.u2ug.org/listinfo/u2-users
> > ---
> > u2-users mailing list
> > [EMAIL PROTECTED]
> > http://www.u2ug.org/listinfo/u2-users
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.u2ug.org/listinfo/u2-users
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

Re: [U2] D3 Master Dictionary

[Mark Johnson]

Nope. Not the issue.
Thanks.

- Original Message - 
From: "Burwell, Edward" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 06, 2004 7:19 PM
Subject: RE: [U2] D3 Master Dictionary


> Try PQ instead of PQN
> 
> -Original Message-
> From: Kryka, Richard [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 06, 2004 6:44 PM
> To: [EMAIL PROTECTED]
> Subject: RE: [U2] D3 Master Dictionary
> 
> 
> Its been a while, but I seem to recall that Pick changed the name from
> MD to DM.  Try placing your BOB there.
> 
> Dick Kryka
> Director of Applications
> CCCS of Greater Denver, Inc.
> Paragon Financial Services
> 303-632-2226
> [EMAIL PROTECTED]
> 
> -Original Message-
> From: Mark Johnson [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, May 06, 2004 3:46 PM
> To: [EMAIL PROTECTED]
> Subject: [U2] D3 Master Dictionary
> 
> Pardon being a D3 question but someone may have run into this before.
> 
> My new client has D3 on W2K. I edited MD BOB and made 001=PQN, 002=HTIME
> and
> 003=P, saved it and then type BOB at TCL and get [3] VERB?.
> 
> I type LIST CUSTOMER and get output but when I type LIST MD = "CUSTOMER"
> I get
> nothing.
> 
> I've found out that there's 2 MD's. One called MD which points to that
> accounts SYSTEM defined space and another called M/DICT which points to
> another account that contains the cataloged programs, filenames, verbs
> etc and
> lets BOB work.
> 
> So my question is what would happen if I made MD point to that other
> account?
> Would I mess anything up. Their system runs 20/7 but I'm not there at
> 4am to
> try this.
> 
> Please no VOC flames. Thanks.
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.u2ug.org/listinfo/u2-users
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.u2ug.org/listinfo/u2-users
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.u2ug.org/listinfo/u2-users
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

Re: [U2] D3 Master Dictionary

[Mark Johnson]

BTW, If you LIST MD WITH *A0 "CUSTOMER" it will parse through the entire
file.

If you LIST MD "CUSTOMER" it will go to that record directly.

my 1 cent.

- Original Message -
From: "Eugene Perry" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 06, 2004 7:05 PM
Subject: Re: [U2] D3 Master Dictionary


> The highest file on a D3 system is known as MDS.  It contains the account
> records.  In your account called BOB, you have a file called MD which is
the
> equivalent of VOC.  It contains all the verbs, file definititions,
cataloged
> programs etc.
>
> When you type LIST CUSTOMER, you are listing the customer file.  If you
want
> to list the MD for a record called CUSTOMER, which happens to be  your
> CUSTOMER file, you could type LIST MD WITH *A0 "CUSTOMER" and it would
> display it.
>
> Eugene
>
> - Original Message -
> From: "Mark Johnson" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, May 06, 2004 3:45 PM
> Subject: [U2] D3 Master Dictionary
>
>
> > Pardon being a D3 question but someone may have run into this before.
> >
> > My new client has D3 on W2K. I edited MD BOB and made 001=PQN, 002=HTIME
> and
> > 003=P, saved it and then type BOB at TCL and get [3] VERB?.
> >
> > I type LIST CUSTOMER and get output but when I type LIST MD = "CUSTOMER"
I
> get
> > nothing.
> >
> > I've found out that there's 2 MD's. One called MD which points to that
> > accounts SYSTEM defined space and another called M/DICT which points to
> > another account that contains the cataloged programs, filenames, verbs
etc
> and
> > lets BOB work.
> >
> > So my question is what would happen if I made MD point to that other
> account?
> > Would I mess anything up. Their system runs 20/7 but I'm not there at
4am
> to
> > try this.
> >
> > Please no VOC flames. Thanks.
> > ---
> > u2-users mailing list
> > [EMAIL PROTECTED]
> > http://www.u2ug.org/listinfo/u2-users
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.u2ug.org/listinfo/u2-users
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

Re: [U2] D3 Master Dictionary

[Mark Johnson]

You missed my original point. It appears that there are 2 MD's. One's called
MD and the other is called M/DICT and they both appear to be present in the
application account but reference 2 different files.

If I type in the following I get the following:

ED MD MD
001 Q

ED MD M/DICT
001 Q
002 ADMIN

There is an account called ADMIN as well as the application account, called
MAIN.

Apparently the normal file pointer for the Master Dictionary of an account
is the Account's SYSTEM file reference. This is both old-school (native) and
D3 technology. Microdata used to have 4 references to their SYSTEM item that
was the MD for that account: MD, DICT, M/DICT and DL/ID.

I haven't seen 2 MD's in a while. If I COUNT MD I get 2,000 items. If I
COUNT M/DICT, I get 4,500 items.

If I type LIST M/DICT "CUSTOMER" I get the display indicating it being
there.

My question is if I make the MD MD item the same as the MD M/DICT item what
would happen.

Thanks in advance.


- Original Message -
From: "Eugene Perry" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 06, 2004 7:05 PM
Subject: Re: [U2] D3 Master Dictionary


> The highest file on a D3 system is known as MDS.  It contains the account
> records.  In your account called BOB, you have a file called MD which is
the
> equivalent of VOC.  It contains all the verbs, file definititions,
cataloged
> programs etc.
>
> When you type LIST CUSTOMER, you are listing the customer file.  If you
want
> to list the MD for a record called CUSTOMER, which happens to be  your
> CUSTOMER file, you could type LIST MD WITH *A0 "CUSTOMER" and it would
> display it.
>
> Eugene
>
> - Original Message -
> From: "Mark Johnson" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, May 06, 2004 3:45 PM
> Subject: [U2] D3 Master Dictionary
>
>
> > Pardon being a D3 question but someone may have run into this before.
> >
> > My new client has D3 on W2K. I edited MD BOB and made 001=PQN, 002=HTIME
> and
> > 003=P, saved it and then type BOB at TCL and get [3] VERB?.
> >
> > I type LIST CUSTOMER and get output but when I type LIST MD = "CUSTOMER"
I
> get
> > nothing.
> >
> > I've found out that there's 2 MD's. One called MD which points to that
> > accounts SYSTEM defined space and another called M/DICT which points to
> > another account that contains the cataloged programs, filenames, verbs
etc
> and
> > lets BOB work.
> >
> > So my question is what would happen if I made MD point to that other
> account?
> > Would I mess anything up. Their system runs 20/7 but I'm not there at
4am
> to
> > try this.
> >
> > Please no VOC flames. Thanks.
> > ---
> > u2-users mailing list
> > [EMAIL PROTECTED]
> > http://www.u2ug.org/listinfo/u2-users
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.u2ug.org/listinfo/u2-users
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

RE: [U2] D3 Master Dictionary

[Burwell, Edward]

Try PQ instead of PQN

-Original Message-
From: Kryka, Richard [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 06, 2004 6:44 PM
To: [EMAIL PROTECTED]
Subject: RE: [U2] D3 Master Dictionary


Its been a while, but I seem to recall that Pick changed the name from
MD to DM.  Try placing your BOB there.

Dick Kryka
Director of Applications
CCCS of Greater Denver, Inc.
Paragon Financial Services
303-632-2226
[EMAIL PROTECTED]

-Original Message-
From: Mark Johnson [mailto:[EMAIL PROTECTED] 
Sent: Thursday, May 06, 2004 3:46 PM
To: [EMAIL PROTECTED]
Subject: [U2] D3 Master Dictionary

Pardon being a D3 question but someone may have run into this before.

My new client has D3 on W2K. I edited MD BOB and made 001=PQN, 002=HTIME
and
003=P, saved it and then type BOB at TCL and get [3] VERB?.

I type LIST CUSTOMER and get output but when I type LIST MD = "CUSTOMER"
I get
nothing.

I've found out that there's 2 MD's. One called MD which points to that
accounts SYSTEM defined space and another called M/DICT which points to
another account that contains the cataloged programs, filenames, verbs
etc and
lets BOB work.

So my question is what would happen if I made MD point to that other
account?
Would I mess anything up. Their system runs 20/7 but I'm not there at
4am to
try this.

Please no VOC flames. Thanks.
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

RE: [U2] D3 Master Dictionary

[Ross Ferris]

AFAIK D3 doesn't like PQN in attribute 1  just PQ will work find (or N for a macro 
- loose the "H" prefix & "P" lines) - this will solve your VERB issue.

I would expect both MD and M/DICT to simply be "null" q-pointers  and I assume 
that there was a typo when you said MD pointed to system space (did you mean MDS ?)

Please feel free to email me direct rather than cluttering this list - happy to help 
you resolve any D3 issues (you never did say which account you were logged into in the 
first place, and there are other "issues", like 'Is this account in the VME or the 
FSI' that can have an impact in terms of performance, reliability etc

Ross Ferris
Stamina Software
Visage  an Evolution in Software Development


>-Original Message-
>From: [EMAIL PROTECTED] [mailto:owner-u2-
>[EMAIL PROTECTED] On Behalf Of Mark Johnson
>Sent: Friday, 7 May 2004 7:46 AM
>To: [EMAIL PROTECTED]
>Subject: [U2] D3 Master Dictionary
>
>Pardon being a D3 question but someone may have run into this before.
>
>My new client has D3 on W2K. I edited MD BOB and made 001=PQN, 002=HTIME
>and
>003=P, saved it and then type BOB at TCL and get [3] VERB?.
>
>I type LIST CUSTOMER and get output but when I type LIST MD = "CUSTOMER" I
>get
>nothing.
>
>I've found out that there's 2 MD's. One called MD which points to that
>accounts SYSTEM defined space and another called M/DICT which points to
>another account that contains the cataloged programs, filenames, verbs etc
>and
>lets BOB work.
>
>So my question is what would happen if I made MD point to that other
>account?
>Would I mess anything up. Their system runs 20/7 but I'm not there at 4am
>to
>try this.
>
>Please no VOC flames. Thanks.
>---
>u2-users mailing list
>[EMAIL PROTECTED]
>http://www.u2ug.org/listinfo/u2-users
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.677 / Virus Database: 439 - Release Date: 4/05/2004
>

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.677 / Virus Database: 439 - Release Date: 4/05/2004
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

Re: [U2] D3 Master Dictionary

[Mark Johnson]

DM is the new name of the SYSPROG account. Many installations have SYSPROG
as a Q-pointer account to DM.

Thanks.

- Original Message -
From: "Kryka, Richard" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 06, 2004 6:44 PM
Subject: RE: [U2] D3 Master Dictionary


> Its been a while, but I seem to recall that Pick changed the name from
> MD to DM.  Try placing your BOB there.
>
> Dick Kryka
> Director of Applications
> CCCS of Greater Denver, Inc.
> Paragon Financial Services
> 303-632-2226
> [EMAIL PROTECTED]
>
> -Original Message-
> From: Mark Johnson [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 06, 2004 3:46 PM
> To: [EMAIL PROTECTED]
> Subject: [U2] D3 Master Dictionary
>
> Pardon being a D3 question but someone may have run into this before.
>
> My new client has D3 on W2K. I edited MD BOB and made 001=PQN, 002=HTIME
> and
> 003=P, saved it and then type BOB at TCL and get [3] VERB?.
>
> I type LIST CUSTOMER and get output but when I type LIST MD = "CUSTOMER"
> I get
> nothing.
>
> I've found out that there's 2 MD's. One called MD which points to that
> accounts SYSTEM defined space and another called M/DICT which points to
> another account that contains the cataloged programs, filenames, verbs
> etc and
> lets BOB work.
>
> So my question is what would happen if I made MD point to that other
> account?
> Would I mess anything up. Their system runs 20/7 but I'm not there at
> 4am to
> try this.
>
> Please no VOC flames. Thanks.
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.u2ug.org/listinfo/u2-users
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.u2ug.org/listinfo/u2-users
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

Re: [U2] [UV] getting LISTU to show full user names or in raw for mat

[Clifton Oliver]

It is a function of the host O/S. PORT.STATUS queries the running 
processes. Those processes then have to interrupt what they are doing 
and report back to the calling process. I would have to look up the 
details of the mechanism, but IBM probably considers that information 
proprietary anyway. Suffice it to say, PORT.STATUS has a lot of 
overhead because of what it needs to do.

A bunch of programmers sitting there running repeated PORT.STATUS 
queries by hitting .X over and over will nail system's performance. So 
use with care.

--
Regards,
Clif
~~~
W. Clifton Oliver, CCP
CLIFTON OLIVER & ASSOCIATES
Tel: +1 619 460 5678Web: www.oliver.com
~~~
On May 6, 2004, at 10:52, Troy Buss (Logitek Systems) wrote:
This could work if it was'nt so slow.  Does anyone know why that 
port.status
command runs so slow?
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

Re: [U2] D3 Master Dictionary

[Eugene Perry]

The highest file on a D3 system is known as MDS.  It contains the account
records.  In your account called BOB, you have a file called MD which is the
equivalent of VOC.  It contains all the verbs, file definititions, cataloged
programs etc.

When you type LIST CUSTOMER, you are listing the customer file.  If you want
to list the MD for a record called CUSTOMER, which happens to be  your
CUSTOMER file, you could type LIST MD WITH *A0 "CUSTOMER" and it would
display it.

Eugene

- Original Message -
From: "Mark Johnson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 06, 2004 3:45 PM
Subject: [U2] D3 Master Dictionary


> Pardon being a D3 question but someone may have run into this before.
>
> My new client has D3 on W2K. I edited MD BOB and made 001=PQN, 002=HTIME
and
> 003=P, saved it and then type BOB at TCL and get [3] VERB?.
>
> I type LIST CUSTOMER and get output but when I type LIST MD = "CUSTOMER" I
get
> nothing.
>
> I've found out that there's 2 MD's. One called MD which points to that
> accounts SYSTEM defined space and another called M/DICT which points to
> another account that contains the cataloged programs, filenames, verbs etc
and
> lets BOB work.
>
> So my question is what would happen if I made MD point to that other
account?
> Would I mess anything up. Their system runs 20/7 but I'm not there at 4am
to
> try this.
>
> Please no VOC flames. Thanks.
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.u2ug.org/listinfo/u2-users
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

Re: [U2] Is there a better way?

[Ray Wurlod]

Use FIND rather than LOCATE for a whole-of-element search, or FINDSTR for a 
partial-element search.

- Original Message -
From: [EMAIL PROTECTED]
Date: Thu, 6 May 2004 09:26:10 -0400
To: [EMAIL PROTECTED]
Subject: [U2] Is there a better way?

> I've got an attribute with value marks and sub-value marks.
> 
> Is there a way that I can do a locate for a value that will give me both 
> the value mark and sub-value make values in universe basic code.
> 
> LIST<1> = "A":@SVM:"B":@SVM:"C":@VM:"D":@SVM:"E":@SVM:"F"
> 
> If I want to find "D" I would like something to tell me it's location can 
> be found at LIST<1,2,1> ( VM = 2, SVM = 1) so I can quickly reference it.
> 
> Is this possible?
> 
> Thanks for any pointers. :)
> 
> " I used to be an Optimist until I knocked over the glass. "
> 
> Randy Smith Programmer/Analyst
> [EMAIL PROTECTED]
> http://users.adelphia.net/~lee_crystal/
> http://www.sopranoboy.com
> 
> Zaner Bloser
> http://www.zaner-bloser.com
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.u2ug.org/listinfo/u2-users
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

RE: [U2] D3 Master Dictionary

[Kryka, Richard]

Its been a while, but I seem to recall that Pick changed the name from
MD to DM.  Try placing your BOB there.

Dick Kryka
Director of Applications
CCCS of Greater Denver, Inc.
Paragon Financial Services
303-632-2226
[EMAIL PROTECTED]

-Original Message-
From: Mark Johnson [mailto:[EMAIL PROTECTED] 
Sent: Thursday, May 06, 2004 3:46 PM
To: [EMAIL PROTECTED]
Subject: [U2] D3 Master Dictionary

Pardon being a D3 question but someone may have run into this before.

My new client has D3 on W2K. I edited MD BOB and made 001=PQN, 002=HTIME
and
003=P, saved it and then type BOB at TCL and get [3] VERB?.

I type LIST CUSTOMER and get output but when I type LIST MD = "CUSTOMER"
I get
nothing.

I've found out that there's 2 MD's. One called MD which points to that
accounts SYSTEM defined space and another called M/DICT which points to
another account that contains the cataloged programs, filenames, verbs
etc and
lets BOB work.

So my question is what would happen if I made MD point to that other
account?
Would I mess anything up. Their system runs 20/7 but I'm not there at
4am to
try this.

Please no VOC flames. Thanks.
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

RE: [U2] Get External Sql Data Dynamically

[Kris Stevens]

That was our first solution was updating a local file with the data from the
sql table.
I was hoping for something "a little more dynamic", but that is what you get
with a "closed environment" that UniData is.  

Still , I like the environment warts and all.

Kris Stevens

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of David Beahm
Sent: Thursday, May 06, 2004 4:52 PM
To: [EMAIL PROTECTED]
Subject: Re: [U2] Get External Sql Data Dynamically


BCI doesn't offer quite as tight an integration as that.  What it gives 
you is the ability to read and write to SQL data sources from within 
UniBasic.  For instance, we have a table that exists in MySQL, but we 
need to access the data from UniData (and for the moment we don't have 
time to change the user interface to support interfacing with UniData -- 
besides it made a good test case).  Anyway, we were able to execute SQL 
queries against the external database from within a program.  In your 
case, you might want to write a program that updates a local file with 
data from the SQL table.  Then you can use all your familiar Retrieve 
logic (I-types, etc.)

HTH,
David Beahm



Kris Stevens wrote:

> Thanks for the response. 
> 
> Here is a followup question, to verify I am asking my question clearly.
> 
> What I am trying to do is:
> 
> List  MYLocalFILE  where MyRemoteKey = "X" MyRemoteData
> 
> where the MyLocalfile is a local unidata mv file.  
> MyRemoteKey is a dict item that references the remote SQL table on the
> network.
> MyRemoteData is a dict item that returns the value from the remote SQL
> table.
> 
> The clients would not have any software installed, just the server only.
> 
> Would this need to be done in a datatel subroutine?
> 
> Thanks!
> 
> Kris Stevens
> 
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of David Beahm
> Sent: Thursday, May 06, 2004 1:44 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [U2] Get External Sql Data Dynamically
> 
> 
> Yes, BCI is the tool.  If you're on Unix, you also need to have an ODBC 
> manager.  Being on 64-bit HP-UX (which makes it hard to find compatible 
> OTS software), we ended up using EasySoft's ODBC-ODBC bridge (they made 
> a custom port to HP-UX for us), which is working great.
> 
> Best,
> David Beahm
> 
> Tom Firl wrote:
> 
>>Take a look at BCI... this is the U2 feature that provides ODBC client
> 
> functionality.  I personally haven't used it, but several readers of this
> group have...
> 
>>Tom Firl
>>Columbia Ultimate
> 
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.u2ug.org/listinfo/u2-users
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.u2ug.org/listinfo/u2-users
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

[U2] D3 Master Dictionary

[Mark Johnson]

Pardon being a D3 question but someone may have run into this before.

My new client has D3 on W2K. I edited MD BOB and made 001=PQN, 002=HTIME and
003=P, saved it and then type BOB at TCL and get [3] VERB?.

I type LIST CUSTOMER and get output but when I type LIST MD = "CUSTOMER" I get
nothing.

I've found out that there's 2 MD's. One called MD which points to that
accounts SYSTEM defined space and another called M/DICT which points to
another account that contains the cataloged programs, filenames, verbs etc and
lets BOB work.

So my question is what would happen if I made MD point to that other account?
Would I mess anything up. Their system runs 20/7 but I'm not there at 4am to
try this.

Please no VOC flames. Thanks.
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

Re: [U2] Get External Sql Data Dynamically

[David Beahm]

BCI doesn't offer quite as tight an integration as that.  What it gives 
you is the ability to read and write to SQL data sources from within 
UniBasic.  For instance, we have a table that exists in MySQL, but we 
need to access the data from UniData (and for the moment we don't have 
time to change the user interface to support interfacing with UniData -- 
besides it made a good test case).  Anyway, we were able to execute SQL 
queries against the external database from within a program.  In your 
case, you might want to write a program that updates a local file with 
data from the SQL table.  Then you can use all your familiar Retrieve 
logic (I-types, etc.)

HTH,
David Beahm

Kris Stevens wrote:
Thanks for the response. 

Here is a followup question, to verify I am asking my question clearly.
What I am trying to do is:
List  MYLocalFILE  where MyRemoteKey = "X" MyRemoteData
where the MyLocalfile is a local unidata mv file.  
MyRemoteKey is a dict item that references the remote SQL table on the
network.
MyRemoteData is a dict item that returns the value from the remote SQL
table.

The clients would not have any software installed, just the server only.
Would this need to be done in a datatel subroutine?
Thanks!
Kris Stevens
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of David Beahm
Sent: Thursday, May 06, 2004 1:44 PM
To: [EMAIL PROTECTED]
Subject: Re: [U2] Get External Sql Data Dynamically
Yes, BCI is the tool.  If you're on Unix, you also need to have an ODBC 
manager.  Being on 64-bit HP-UX (which makes it hard to find compatible 
OTS software), we ended up using EasySoft's ODBC-ODBC bridge (they made 
a custom port to HP-UX for us), which is working great.

Best,
David Beahm
Tom Firl wrote:
Take a look at BCI... this is the U2 feature that provides ODBC client
functionality.  I personally haven't used it, but several readers of this
group have...
Tom Firl
Columbia Ultimate
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

Re: [U2] MV Fad

[Mark Johnson]

In the tiniest of defenses of Dick Pick during the infamous Bill Gates
conversation, one should examine the prevailing systems of the time. If this
conversation took place in 1980-81, then let's jump into that time machine.
(Actual dates may vary)

The Apple II or II+ already had 3 years momentum with its BASIC language/OS,
floppy etc. Heathkit had a different but similar BASIC/OS as well as Radio
Shack (TRS-80 anyone?). Throw in the Commodore 64, Atari, Intellivision and
it looked like everyone was attaching a keyboard to a TV set. Add the
hobbyist nature of the S-100 bus plus other single user OS's like CPM and
MPM and this thing called MS-DOS didn't appear to be anything different.

Given the real hardware of the time, Dec's PDP-8,9,10, Perkin
Elmer/Interdata, IBM system 32/34, Burroughs and a whole lot of forgettable
mini-computers (as opposed to mainframes like VAX, system 360/370, etc) Pick
was sitting pretty comfortable having a good OS and database marriage on the
Microdatas and Ultimates circa the late 70's early 80's. I recall trying to
create a Pick-like dictionary-driven app on a Perkin Elmer system.

It wasn't until the late 80's and arguably the early 90's when the PC's
gained momentum with the introduction of Windows 3.1 that they became more
functional and interconnectable. Until then, it was just as green-screen as
we were. But given the PC programs like Lotus, Harvard Graphics and
WordPerfect, it was gaining respect on the desktop.

There was early Revelation using floppy drives and the Pick-PC-XT with its
10MB second partition system. I owned both in 1983-84 but at that time, PC
users were more into tinkering and configuring their systems instead of
running a database. DOS appealed to them as an environment to fiddle with
IRQ's, dip switches, CONFIG.SYS etc. Run a database application? I'm having
more fun tweaking the OS.

Talk about tweaking, I recall owning an EPROM burner to distribute protected
software on an Apple II+. I wore 2 hats. My 9-5 Pick hat and my 5-9
DOS/Apple hat.

My 2 cents on the infamous meeting.


- Original Message -
From: "Lee Bacall" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Harvey Rodstein" <[EMAIL PROTECTED]>; "MIke Shebesta"
<[EMAIL PROTECTED]>; "Becky Piel" <[EMAIL PROTECTED]>; "Porfirio Matt
Sperandio" <[EMAIL PROTECTED]>
Sent: Thursday, May 06, 2004 4:32 PM
Subject: Re: [U2] MV Fad


> Ross and others,
> One would have to go back in time to around 1987 for those exciting
> attendance figures for Spectrum.
> The shows at that time were incredible events.  Ask some of the old-timers
> like Charlie Noah and Henry Eggers - they can tell you some interesting
> stories about "history".
>
> No, Pick isn't a fad, as fad's are fashion news.  Most of us happen to
work
> in an arena that is considered un-fashionable by mainstream IT, which
tends
> to
> favor large staff and huge budgets that justify big salaries and senior IT
> titles.
>
> Pick shops don't generally have titles like chief information officer,
> Director of Information technology or Vice President of Information
Systems.
> We tend to have a single programmer capable of supporting 500 users doing
> double duty as both support person and help desk while enhancing
> applications and running reports for management.  We have allowed it to
> become an environment that is looked upon by management as a bastard child
> rather than as a valuable adjunct to the business. The mainstream world
> shines in their ability to sell management on their importance.
>
> I'll pose this question rhetorically to the group... what have we done to
> become the kicking post for CEO's and CFO's who now favor Oracle or even
> Microsoft SQL
> server as an environment?
>
> Essentially, we have tried to "cheap out" by telling ourselves and
> management that we can do it cheaper, when what we really should have been
> saying is that we can do it better, but we are going to need more money
and
> more help and more education.  We didn't get, because we didn't ask.
Oracle
> sells because management "buys in" at the boardroom level or on the golf
> course where bragging is king and no one can brag about spending 50k on a
> database, but spending 2.5 million on Oracle implies bragging rights.
>
> Dick Pick although a gifted visionary in terms of seeing the elegance in
the
> methodology to flexibly store and retrieve data, truly screwed up when
Billy
> Gates asked hime if he would port Pick to a PC with two floppy disc
drives,
> as he said "no, go #$%(* yourself" in a fit of pride.
>
> Lee Bacall
> http://www.binarystar.com
> Phone: +1 (954) 791-8575
> Cell:  +1 (954) 937-8989
>
> - Original Message -
> From: "Ross Ferris" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, May 05, 2004 8:51 PM
> Subject: RE: [U2] MV Fad
>
>
> > I don't recall there EVER being 5,000 people at a Spectrum conference
(not
> that I have been to many) - and based on the previous 2 years that I have
> attended, 500 sounds l

[U2] U2 UNIQUERY PA...

[Keith Johnson]

All,
Does anyone know if there are any more programming tools directly
available in a UNIDATA PA? (delivered or home grown)  For example:
CASE, WHILE, IF THEN ELSE, ETC?


I am aware of the LOOP REPEAT, GO, and IF THEN.  However this is a bit
light in my book and I do not always want to make a full program to do
this kind of work.  Thank you for your time.


Keith Johnson
UNIX Systems Administrator
Programmer / Analyst
Lewis-Clark State College
208.792.2510
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

RE: [U2] Get External Sql Data Dynamically

[Kris Stevens]

Thanks for the response. 

Here is a followup question, to verify I am asking my question clearly.

What I am trying to do is:

List  MYLocalFILE  where MyRemoteKey = "X" MyRemoteData

where the MyLocalfile is a local unidata mv file.  
MyRemoteKey is a dict item that references the remote SQL table on the
network.
MyRemoteData is a dict item that returns the value from the remote SQL
table.

The clients would not have any software installed, just the server only.

Would this need to be done in a datatel subroutine?

Thanks!

Kris Stevens


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of David Beahm
Sent: Thursday, May 06, 2004 1:44 PM
To: [EMAIL PROTECTED]
Subject: Re: [U2] Get External Sql Data Dynamically


Yes, BCI is the tool.  If you're on Unix, you also need to have an ODBC 
manager.  Being on 64-bit HP-UX (which makes it hard to find compatible 
OTS software), we ended up using EasySoft's ODBC-ODBC bridge (they made 
a custom port to HP-UX for us), which is working great.

Best,
David Beahm

Tom Firl wrote:
> Take a look at BCI... this is the U2 feature that provides ODBC client
functionality.  I personally haven't used it, but several readers of this
group have...
> 
> Tom Firl
> Columbia Ultimate
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

Re: [U2] MV Fad

[Lee Bacall]

Ross and others,
One would have to go back in time to around 1987 for those exciting
attendance figures for Spectrum.
The shows at that time were incredible events.  Ask some of the old-timers
like Charlie Noah and Henry Eggers - they can tell you some interesting
stories about "history".

No, Pick isn't a fad, as fad's are fashion news.  Most of us happen to work
in an arena that is considered un-fashionable by mainstream IT, which tends
to
favor large staff and huge budgets that justify big salaries and senior IT
titles.

Pick shops don't generally have titles like chief information officer,
Director of Information technology or Vice President of Information Systems.
We tend to have a single programmer capable of supporting 500 users doing
double duty as both support person and help desk while enhancing
applications and running reports for management.  We have allowed it to
become an environment that is looked upon by management as a bastard child
rather than as a valuable adjunct to the business. The mainstream world
shines in their ability to sell management on their importance.

I'll pose this question rhetorically to the group... what have we done to
become the kicking post for CEO's and CFO's who now favor Oracle or even
Microsoft SQL
server as an environment?

Essentially, we have tried to "cheap out" by telling ourselves and
management that we can do it cheaper, when what we really should have been
saying is that we can do it better, but we are going to need more money and
more help and more education.  We didn't get, because we didn't ask.  Oracle
sells because management "buys in" at the boardroom level or on the golf
course where bragging is king and no one can brag about spending 50k on a
database, but spending 2.5 million on Oracle implies bragging rights.

Dick Pick although a gifted visionary in terms of seeing the elegance in the
methodology to flexibly store and retrieve data, truly screwed up when Billy
Gates asked hime if he would port Pick to a PC with two floppy disc drives,
as he said "no, go #$%(* yourself" in a fit of pride.

Lee Bacall
http://www.binarystar.com
Phone: +1 (954) 791-8575
Cell:  +1 (954) 937-8989

- Original Message - 
From: "Ross Ferris" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 05, 2004 8:51 PM
Subject: RE: [U2] MV Fad


> I don't recall there EVER being 5,000 people at a Spectrum conference (not
that I have been to many) - and based on the previous 2 years that I have
attended, 500 sounds like an increase.
>
> By definition a fad is also relatively short lived  to even make
reference to 5 years ago indicates that this is not the case - and the first
International Spectrum I went to was 1992 ?, so I think that for a 'fast
paced' arena like technology, multi-valued is not a 'fad' . though the
growth rate could always be better :-)
>
> Ross Ferris
> Stamina Software
> Visage  an Evolution in Software Development
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

Re: [U2] Is there a better way?

[Mark Johnson]

If I read the original post correctly it indicates that it is looking for
both the VM position and the SVM position.

I don't believe a single LOCATE can produce this as how would it represent
the 2 resulting values (VM position and the SVM position)?

Thus, knowing that the user is looking for a unique "D" in this multi-level
field, then the logic may be:

C=DCOUNT(LINE,CHAR(253))
SVM.POS=0
FOR MV.POS = 1 TO C
  LOCATE "D" IN LINE<1,MV.POS> SETTING SVM.POS THEN EXIT
NEXT MV.POS
IF SVM.POS=0 THEN STOP "VALUE NOT FOUND"

my 1 cent

- Original Message -
From: "Piers Angliss" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 06, 2004 10:23 AM
Subject: RE: [U2] Is there a better way?


> > I've got an attribute with value marks and sub-value marks.
>
> > Is there a way that I can do a locate for a value that will give me both
> > the value mark and sub-value make values in universe basic code.
>
> Use FINDSTR (see on-line HELP, both UV and UD)
>
> hth
>
> Piers
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.u2ug.org/listinfo/u2-users
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

Re: [U2] Get External Sql Data Dynamically

[David Beahm]

Yes, BCI is the tool.  If you're on Unix, you also need to have an ODBC 
manager.  Being on 64-bit HP-UX (which makes it hard to find compatible 
OTS software), we ended up using EasySoft's ODBC-ODBC bridge (they made 
a custom port to HP-UX for us), which is working great.

Best,
David Beahm
Tom Firl wrote:
Take a look at BCI... this is the U2 feature that provides ODBC client functionality.  
I personally haven't used it, but several readers of this group have...
Tom Firl
Columbia Ultimate
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

RE: [U2] Get External Sql Data Dynamically

[Tom Firl]

Take a look at BCI... this is the U2 feature that provides ODBC client functionality.  
I personally haven't used it, but several readers of this group have...

Tom Firl
Columbia Ultimate

> -Original Message-
> From: Kris Stevens [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 06, 2004 10:04 AM
> To: '[EMAIL PROTECTED]'
> Subject: [U2] Get External Sql Data Dynamically
> 
> 
> I am looking to setup a link from within unidata to a 
> external SQL Db table.
> Has anybody done this?
> 
> Background:
> 
> This table needs to be maintained outside the unidata environment, 
> but the data available inside the unidata environment. 
> 
> Any pointers would be nice to have.
> 
> Thanks in advance!
> 
> Kris Stevens
> Sr. Programmer/Analyst
> [EMAIL PROTECTED]
> St. Louis, MO 
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.u2ug.org/listinfo/u2-users
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

RE: [U2] [UV] getting LISTU to show full user names or in raw for mat

[Troy Buss (Logitek Systems)]

Wow, another undocumented option.

This could work if it was'nt so slow.  Does anyone know why that port.status
command runs so slow?

Thanks for the help!

-Original Message-
From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 05, 2004 2:33 PM
To: [EMAIL PROTECTED]
Subject: RE: [U2] [UV] getting LISTU to show full user names or in raw
format


Hi Troy,

There is an INTERNAL keyword that works with PORT.STATUS. Same deal as
LIST.READU in that it returns everything separated by a value mark.

It is detailed in the subroutine VMADMSUB.B in APP.PROGS. Look around
line 11800 and you can see how it counts the number of attributes to
tell you whether the user is a phantom, normal or other.

HTH

Regards

David Logan
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

Re: [U2] How to print value of variable used in a paragraph

[Dianne Ackerman]

I don't think there's a way to do that for @ variables in general, but 
for your @USERNO example, I always just put the paragraph line as WHO
-Dianne

ashish ratna wrote:
Hi All,
I want to know that-
How to display value of a variable in a paragraph
e.g. @USER0 tells us who is the user logged in. What is the command to
display the value in   variable through a universe paragraph.
If I use  DISPLAY @USER0 in the paragraph it just displays the text
"@USER0" and not the value of @USER0
Thanks in advance.
Ashish.
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

RE: [U2] How to print value of variable used in a paragraph

[John Reid]

Or... less elegantly,
0001: PA
0002: LIST VOC EVAL"@ACCOUNT" FIRST 1 HDR.SUP COL.SUP ID.SUP COUNT.SUP

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, Charles
Sent: Thursday, May 06, 2004 12:31 PM
To: [EMAIL PROTECTED]
Subject: RE: [U2] How to print value of variable used in a paragraph

> [mailto:[EMAIL PROTECTED] On Behalf Of ashish ratna
>
> How to display value of a variable in a paragraph...
> If I use  DISPLAY @USER0 in the paragraph it just displays 
> the text "@USER0" and not the value of @USER0


Vanilla UV, UDT paragraph: you can't, but...

I wrote my own verb that packs stuff from the command line into an
"inline prompt" variable.
( What is called Inline-promts are really paragraph variables.  the name
of the variable is (sometimes) also a prompt.
I think "inline prompt" is a poor name. )

   PA
   ILPROMPT.DEF "USER0 or anything you want" @USER0
   DISPLAY <>

The guts of my ilprompt.def program does the basic function:

DATA @USER0
BREAK OFF ; HUSH ON
DUM = ILPROMPT( '<>' )
HUSH OFF ; BREAK ON

that makes it available subsequently in the calling paragraph.
Of course, my DATA statement and ILPROMPT() arguments are more
generalized parsing the command line for a variety of things, including
a select or savedlists that does the equivalent of
<> :


> Thanks in advance.
>
> Ashish.


You're welcome in retrospect,

Chuck
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users


This e-mail, including attachments, may include confidential and/or 
proprietary information, and may be used only by the person or entity to 
which it is addressed. If the reader of this e-mail is not the intended 
recipient or his or her authorized agent, the reader is hereby notified 
that any dissemination, distribution or copying of this e-mail is 
prohibited. If you have received this e-mail in error, please notify the 
sender by replying to this message and delete this e-mail immediately. 
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

[U2] Get External Sql Data Dynamically

[Kris Stevens]

I am looking to setup a link from within unidata to a external SQL Db table.
Has anybody done this?

Background:

This table needs to be maintained outside the unidata environment, 
but the data available inside the unidata environment. 

Any pointers would be nice to have.

Thanks in advance!

Kris Stevens
Sr. Programmer/Analyst
[EMAIL PROTECTED]
St. Louis, MO 
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

Re: [U2] Another 4GL

[Dave Taylor]

Mark,

As a software business who has used a 4GL since 1985 to develop our
software, I have never seen a 4GL that will generate an entire application.
The BOM explosion shopfloor scheduling programs in our mfg. software are
written Pick Basic, as are the translation programs in our EDI translator.

Most of our data entry/update/review screens use Pick Basic subroutines
after one or more entry fields and in the filing subroutine.

The benefits of 4GL's are not that they never require the use of Pick Basic,
but that they enable the development of software applications in a fraction
of the time needed for writing applications entirely in Pick Basic, and that
they improve the reliability of those applications by the use of
standardized coding practices built into the 4GL.

Add to any 4GL the capability of generating html-screens simultaneously with
character-based screens, as se have, and you can reduce the time to develop
browser-based software from months and years to hours and days.

We face the same problem that you face when we are asked by a customer to
support someone else's software that is written in a 4GL that we've never
seen and that is totally undocumented, and we hate learning another 4GL just
as much as you do.

4GL's are written by programmers to make their job easier and to enable them
to be more productive.  They are of greatest value to the businesses using
their software supported either by in-house staff or a long-term software
business.

There is no doubt that the language most commonly used in Pick Basic and the
4GL's present a learning curve at first.

Hopefully, by learning your customer's 4GL, you can assist them in
preserving their software investment rather that just rolling in another
application pkg. that may be easier for you to support.

I understand that Fred has offered to assist you and he will do an excellent
job for you.

Best wishes,

Dave


Dave Taylor
Sysmark Information Systems, Inc.
49 Aspen Way
Rolling Hills Estates, CA 90274
800-SYSMARK (800-797-6275)
(O) 310-544-1974
(F) 310-377-3550
www.sysmarkinfo.com

- Original Message - 
From: "Mark Johnson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 06, 2004 4:57 AM
Subject: Re: [U2] Another 4GL


> Thanks. I was afraid of being stepped on.
> Hopefully it's not to hard to get going. My new client has a long list of
> needed changes.
>
> On another note, do programmers ever hit a wall with the functionality of
> program generators/4GL's such that they still spend a good amount of time
> writing straight code. Being a 100% straight code person, ie too many
4GL's
> to get good at, I tend to lean towards this solution as all of my other
> clients who have (had) code generators don't have the tools anymore and
I'm
> enhancing finished code.
>
> thanks.
>
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, May 05, 2004 11:01 PM
> Subject: Re: [U2] Another 4GL
>
>
> > In a message dated 5/5/2004 8:52:10 PM Eastern Daylight Time,
> [EMAIL PROTECTED] writes:
> >
> > > > Thus, any clues on where I could find more about the development
> tools.
> > > > ScanNet is on the internet but only for their newer GUI developer
> stuff.
> > > The
> > > > Programmer's Helper looks like generated code as opposed
> > > to parameter
> > > driven
> > > > stuff.
> > > >
> > > > Thanks in advance.
> > > >
> > > > Mark Johnson
> >
> > Yes Mark, The Programmer's Helper generates code based on parameters.
You
> can add code sections, but only if you use their tool to do it.  Otherwise
> your changes are step on by the next programmer who does use their tool.
> > Will Johnson
> > ---
> > u2-users mailing list
> > [EMAIL PROTECTED]
> > http://www.u2ug.org/listinfo/u2-users
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.u2ug.org/listinfo/u2-users
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

RE: [U2] How to print value of variable used in a paragraph

[Stevenson, Charles]

> [mailto:[EMAIL PROTECTED] On Behalf Of ashish ratna
>
> How to display value of a variable in a paragraph...
> If I use  DISPLAY @USER0 in the paragraph it just displays 
> the text "@USER0" and not the value of @USER0


Vanilla UV, UDT paragraph: you can't, but...

I wrote my own verb that packs stuff from the command line into an
"inline prompt" variable.
( What is called Inline-promts are really paragraph variables.  the name
of the variable is (sometimes) also a prompt.
I think "inline prompt" is a poor name. )

   PA
   ILPROMPT.DEF "USER0 or anything you want" @USER0
   DISPLAY <>

The guts of my ilprompt.def program does the basic function:

DATA @USER0
BREAK OFF ; HUSH ON
DUM = ILPROMPT( '<>' )
HUSH OFF ; BREAK ON

that makes it available subsequently in the calling paragraph.
Of course, my DATA statement and ILPROMPT() arguments are more
generalized parsing the command line for a variety of things, including
a select or savedlists that does the equivalent of
<> :


> Thanks in advance.
>
> Ashish.


You're welcome in retrospect,

Chuck
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

RE: [U2] Another 4GL

[David Wolverton]

Can you still even buy The Programmers Helper or Wizard? Both were awesome
tools at the time...

I came across documentation while cleaning out old file from both products
from work I did in the early 90s --- I stopped to ponder if either still was
around in light of the SB+s and VB/Java clients now -- then proceeded to
chuck the 8" stack of paper...

DW

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Thursday, May 06, 2004 8:07 AM
To: [EMAIL PROTECTED]
Subject: Re: [U2] Another 4GL

In a message dated 5/6/2004 5:25:49 AM Pacific Daylight Time,
[EMAIL PROTECTED] writes:


> On another note, do programmers ever hit a wall with the functionality of
> program generators/4GL's such that they still spend a good amount of time
> writing straight code. Being a 100% straight code person, ie too many
4GL's
> to get good at, I tend to lean towards this solution as all of my other
> clients who have (had) code generators don't have the tools anymore and
I'm
> enhancing finished code.
> 

There is a learning curve with TPH esp if no one at your client knows how to

use it (!)
However, one good thing about it, is it does allow you to insert straight 
code in sections, sort of like includes.  So for example AFTER entry of the
field 
you can insert whatever straight line code you want to validate it, if the 
validation TPH's allows don't suit your needs.
   TPH has a number of places where you can insert your own code.  I didn't 
find an example of where I needed to replace a TPH screen/function with my
own 
entirely.

Will Johnson
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

[U2] How to print value of variable used in a paragraph

[ashish ratna]

Hi All,

I want to know that-

How to display value of a variable in a paragraph
e.g. @USER0 tells us who is the user logged in. What is the command to
display the value in   variable through a universe paragraph.

If I use  DISPLAY @USER0 in the paragraph it just displays the text
"@USER0" and not the value of @USER0

Thanks in advance.

Ashish.
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

RE: [U2] MV Fad

[Hanwell, David]

Better watch out, Jeff. Jeremy, a.k.a. Pope Innocent  of the 8th
century Transylvanian Church of the Immaculate Ellison, will have you
crucified for heresy.

The next thing you know, Jeff, you'll be talking just like Neo and
Morpheus, "Remember that Oracle is just a computer program."   ;-)

<<"I've heard that PICK programmers are too arrogant to recognize a
threat. Maybe that is why their database is losing to Oracle?  :)">>
Well, what are IBM's and Micro$leaze's excuses?

<<"Look at a legacy Oracle system with required database standards built
in">>
And the maintenance and consulting fees for which provide St. Larry with
85% of his profits. Licensing fees are a drop in the bucket because,
like SAS, an Oracle DB ties a company to so much more.

"A stray bullet killed one bystander
slightly." - from the "Maryville (MO) Forum"
David Hanwell

-Original Message-
From: [EMAIL PROTECTED] On Behalf Of Jeff Ritchie
Sent: Wednesday, May 05, 2004 6:50 PM EDT
To: [EMAIL PROTECTED]
Subject: RE: [U2] MV Fad

And this month's Larry Ellison claim is ? Well, it will be coming in
the next version, or the one after that, or at least some one has an
email about it. If they didn't invent the term "vaporware" for Oracle
they really should have.

-Original Message-
From: Jeremy Adell [EMAIL PROTECTED]
Sent: Thursday, 6 May 2004 4:35 AM EDT
To: [EMAIL PROTECTED]
Subject: RE: [U2] MV Fad

Stiletos? {SIC} Pink shoes? I can definitely see what these two have in
common with a database.  :)

I've heard that PICK programmers are too arrogant to recognize a threat.
Maybe that is why their database is losing to Oracle?  :)

Of course, now I will be labelled a heretic by the 12th century Catholic
Church of database programmers, but really, look at those who designed
the pick {SIC} systems.

To last at anything, you have to be realistic about your threats and
weaknesses. Look at a legacy Oracle system with required database
standards built in and compare it to a PICK db with no standards and 20
years of maintenance. At the PICK convention in Vegas this year, maybe
500 people showed up. I heard 5 years ago there more like 5,000. Sound
like a fad anyone? Maybe IBM can fix it.

> Yes, but Dawn, fads change. For example, I'm sure that you know that
> the fad among twentysomething female professionals used to be to
> wear pink or baby blue Nike jogging shoes to work and to carry their
> work shoes. Now when those women get off of a commuter train in
> Center City it looks like there's a morticians convention in town.
> They are all dressed in black business suits, hair tied back in a
> bun, and walking on ugly, clunky black Amish granny shoes.
>
> I can even feel the next fad coming, for suddenly stiletto shoes have
> made an appearance. I was walking up the stairs at Suburban Station,
> just fascinated by the twentysomething woman just in front of me who
> had:
> * a huge purse slung over her right shoulder,
> * a smaller purse in the crook of her right elbow,
> * the obligatory Starbucks travel mug in her right hand, and
> * a cell phone on which she was conversing in her left hand,
> all the while wobbling up the steps on thin 5" stiletto heels.
>
> It was a truly amazing athletic performance!   ;-)
>
> Now, do we really want to be a fad?
>
> "Behold I am become Death,
> the shatterer of worlds." - Vishnu,
> in the Hindu Bhagavad Gita.
> David Hanwell
>
> -Original Message-
> From: [EMAIL PROTECTED] On Behalf Of Dawn M.
> Wolthuis Sent: Wednesday, May 05, 2004 10:44 AM EDT To: u2-
[EMAIL PROTECTED]
> Subject: [U2] MV Fad
>
> I'm just smilin' big and decided to pass this along in case it
> brings a smile to your face too. Others in the "PICK world" or MV
> arena have been chatting on comp.databases.theory for much longer
> than I have (Wol introduced me to it).  But I've been on there for
> some months now, addressing the question of why we teach relational
> theory as if it were "truth" and yet non-1NF databases seem to yield
> greater flexibility and productivity when used in businesses.
>
> I've been asking a lot of questions and have learned quite a bit.  I
> also invited others on comp.databases.pick to pipe up on a particular
> posting, and several folks (most of them likely on this list too -
> thanks!) piped up.
>
> And then today ...
>
> Someone chimed in about the "MV Fad". So, there you have it -- you
> are not working with an outdated database, using an outdated data
> model -- now it's a fad! There are dollars in fads -- perhaps it's
> time to update our resumes.  Smiles.  --dawn
>
> P.S.-I would like to see non-relational data models (tree structures
> & di-graphs in particular) really become more than "a fad" (the next
> thing after strict RELATIONAL) because they work well and should
> have more industry resources angled their way.  So, there is more
> work to do.
>
> Dawn M. Wolthuis
> Tincat Group, Inc.
> www.tincat-group.com
>
> Take and give some delight today.
> ---
> u2-users mailing

RE: [U2] Is there a better way?

[Piers Angliss]

> I've got an attribute with value marks and sub-value marks.

> Is there a way that I can do a locate for a value that will give me both
> the value mark and sub-value make values in universe basic code.

Use FINDSTR (see on-line HELP, both UV and UD)

hth

Piers
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

RE: [U2] Is there a better way?

[Dean.Armbruster]

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of
> [EMAIL PROTECTED]
> Sent: Thursday, May 06, 2004 9:26 AM
> To: [EMAIL PROTECTED]
> Subject: [U2] Is there a better way?
> 
> 
> I've got an attribute with value marks and sub-value marks.
> 
> Is there a way that I can do a locate for a value that will 
> give me both 
> the value mark and sub-value make values in universe basic code.
> 
> LIST<1> = "A":@SVM:"B":@SVM:"C":@VM:"D":@SVM:"E":@SVM:"F"
> 
> If I want to find "D" I would like something to tell me it's 
> location can 
> be found at LIST<1,2,1> ( VM = 2, SVM = 1) so I can quickly 
> reference it.
> 
> Is this possible?
> 
> Thanks for any pointers. :)


FIND, or FINDSTR if you only need a partial match.

You're welcome.
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

RE: [U2] Is there a better way?

[Grant.Boice]

Randy,

If you are using UniBasic, there is a UniBasic command call FIND, that will do this 
job.  If I remember correctly, I believe UniVerse has the same command, also.

FIND is very similar to LOCATE.

Hope this helps!

Grant W. Boice, Jr.
Systems Administrator
Benchmark Electronics, Inc.
Manassas Division
8500 Phoenix Drive
Manassas, VA  20110
 
Phone:  (703) 334-0156
Email:   [EMAIL PROTECTED]  
Web:www.bench.com  
 
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 06, 2004 9:26 AM
To: [EMAIL PROTECTED]
Subject: [U2] Is there a better way?


I've got an attribute with value marks and sub-value marks.

Is there a way that I can do a locate for a value that will give me both 
the value mark and sub-value make values in universe basic code.

LIST<1> = "A":@SVM:"B":@SVM:"C":@VM:"D":@SVM:"E":@SVM:"F"

If I want to find "D" I would like something to tell me it's location can 
be found at LIST<1,2,1> ( VM = 2, SVM = 1) so I can quickly reference it.

Is this possible?

Thanks for any pointers. :)

" I used to be an Optimist until I knocked over the glass. "

Randy Smith Programmer/Analyst
[EMAIL PROTECTED]
http://users.adelphia.net/~lee_crystal/
http://www.sopranoboy.com

Zaner Bloser
http://www.zaner-bloser.com
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

RE: [U2] MV Fad - UniVerse (Pick) vs Oracle

[kmbodine]

Just because someone created a poor website, does not mean that the
database it links to is poor as well. 




-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett
Sent: Thursday, May 06, 2004 12:40 AM
To: [EMAIL PROTECTED]
Subject: RE: [U2] MV Fad - UniVerse (Pick) vs Oracle

>> maybe that is why their database is losing to Oracle?:)

Just had to leap in here... Just for interest's sake have a
look at
these two sites

www.pnet.co.za

www.1time.com

Pnet is run on UniVerse, 1Time is run on Oracle.

Being a total illiterate regarding Oracle I found this quite
interesting. Check out the speed difference!
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

[U2] Is there a better way?

[rlsmith]

I've got an attribute with value marks and sub-value marks.

Is there a way that I can do a locate for a value that will give me both 
the value mark and sub-value make values in universe basic code.

LIST<1> = "A":@SVM:"B":@SVM:"C":@VM:"D":@SVM:"E":@SVM:"F"

If I want to find "D" I would like something to tell me it's location can 
be found at LIST<1,2,1> ( VM = 2, SVM = 1) so I can quickly reference it.

Is this possible?

Thanks for any pointers. :)

" I used to be an Optimist until I knocked over the glass. "

Randy Smith Programmer/Analyst
[EMAIL PROTECTED]
http://users.adelphia.net/~lee_crystal/
http://www.sopranoboy.com

Zaner Bloser
http://www.zaner-bloser.com
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

Re: [U2] Another 4GL

[FFT2001]

In a message dated 5/6/2004 5:25:49 AM Pacific Daylight Time, 
[EMAIL PROTECTED] writes:


> On another note, do programmers ever hit a wall with the functionality of
> program generators/4GL's such that they still spend a good amount of time
> writing straight code. Being a 100% straight code person, ie too many 4GL's
> to get good at, I tend to lean towards this solution as all of my other
> clients who have (had) code generators don't have the tools anymore and I'm
> enhancing finished code.
> 

There is a learning curve with TPH esp if no one at your client knows how to 
use it (!)
However, one good thing about it, is it does allow you to insert straight 
code in sections, sort of like includes.  So for example AFTER entry of the field 
you can insert whatever straight line code you want to validate it, if the 
validation TPH's allows don't suit your needs.
   TPH has a number of places where you can insert your own code.  I didn't 
find an example of where I needed to replace a TPH screen/function with my own 
entirely.

Will Johnson
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

RE: [U2] Unidata login terminating

[alfkec]

Yes, we get the same error. I reported it to IBM but they want a
consistently reproducible case. We've found that sometimes it works fine.
The times that it doesn't work it still seems to save the path because the
user gets it the next time they login and then it works fine. We've seen the
problem for a while - not sure when it started. We do have that patch
loaded. 

Win 2K sp4.
UD 6.0.12

-- 
Colin Alfke
Calgary, Alberta Canada

"Just because something isn't broken doesn't mean that you can't fix it"

Stu Pickles

>-Original Message-
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>Sent: Thursday, May 06, 2004 1:54 AM
>To: [EMAIL PROTECTED]
>Subject: [U2] Unidata login terminating
>
>
>Just seen various emails from Universe users about a problem with non
>administrator users having telnet sessions terminating, and 
>think I may have
>a similar problem on Unidata 6, W2000. Our telnet parameters 
>prompt for the
>path when a user logs in, if I leave the path the same the 
>user can log in
>with no problems. If I change the PATH to a valid Unidata 
>account path, the
>telnet process hangs on the client, and I get a 'Application 
>popup' event on
>the application server.
>
>Event Type:   Information
>Event Source:Application Popup
>Event Category: None
>Event ID:   26
>Date:03/05/2004
>Time:10:39:05
>User:N/A
>Computer: FL-AVANTEDB-01
>Description:
>Application popup: udt.exe - Application Error : The instruction at
>"0x100408ca" referenced memory at "0x". The memory could not be
>"read".
>
>Click on OK to terminate the program
>
>If I leave the path as the default, and then use a 'LOGTO' it 
>works. If I
>change the default path in Unidata admin, it works OK.
>
>The reason I think this may be linked to the Universe problem 
>is this only
>started happening on 1st May, after we loaded the patch's for 
>the MS04-011
>vulnerability.
>
>Has anyone else on W2000 with Unidata 6 seen a similar problem?
>
>Graham Forbes
>BT Syntegra
>
>
>
>
>
>This email may contain information which is privileged or 
>confidential. If you
>are not the intended recipient of this email, please notify the sender
>immediately and delete it without reading, copying, storing, 
>forwarding or
>disclosing its contents to any other person
>Thank you
>
>Check us out at http://www.btsyntegra.com
>
>
>---
>u2-users mailing list
>[EMAIL PROTECTED]
>http://www.u2ug.org/listinfo/u2-users
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

Re: [U2] MV Fad - UniVerse (Pick) vs Oracle

[Schalk van Zyl]

Dennis,
Thanks.
Now I understand the difference: for an Oracle site you need a password, 
and a UV-site you don't!

Schalk



On Thu, 6 May 2004 10:39:59 +0200, Dennis Bartlett <[EMAIL PROTECTED]> wrote:

>>> maybe that is why their database is losing to Oracle?:)
>
> Just had to leap in here... Just for interest's sake have a
> look at
> these two sites
>
> www.pnet.co.za
>
> www.1time.com
>
> Pnet is run on UniVerse, 1Time is run on Oracle.
>
> Being a total illiterate regarding Oracle I found this quite
> interesting. Check out the speed difference!
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.u2ug.org/listinfo/u2-users
>



-- 
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

-
GWK BEPERK/LIMITED (REG: 1997/022252/06)
POSBUS 47 PO BOX 8730
DOUGLAS

Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes,
JH Coetzee, JGD Smit, JF Jacobs, AO M|ller, JW Smit,
JP Snyman, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A M|ller,
Sekr/Secr: E van Niekerk.

Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by:
http://www.gwk.co.za/DisclaimerVrywaring.asp
This e-mail is subjected to the disclaimer that can be viewed at:
http://www.gwk.co.za/DisclaimerVrywaring.asp
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

Re: [U2] Another 4GL

[Mark Johnson]

Thanks. I was afraid of being stepped on.
Hopefully it's not to hard to get going. My new client has a long list of
needed changes.

On another note, do programmers ever hit a wall with the functionality of
program generators/4GL's such that they still spend a good amount of time
writing straight code. Being a 100% straight code person, ie too many 4GL's
to get good at, I tend to lean towards this solution as all of my other
clients who have (had) code generators don't have the tools anymore and I'm
enhancing finished code.

thanks.

- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 05, 2004 11:01 PM
Subject: Re: [U2] Another 4GL


> In a message dated 5/5/2004 8:52:10 PM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
>
> > > Thus, any clues on where I could find more about the development
tools.
> > > ScanNet is on the internet but only for their newer GUI developer
stuff.
> > The
> > > Programmer's Helper looks like generated code as opposed
> > to parameter
> > driven
> > > stuff.
> > >
> > > Thanks in advance.
> > >
> > > Mark Johnson
>
> Yes Mark, The Programmer's Helper generates code based on parameters.  You
can add code sections, but only if you use their tool to do it.  Otherwise
your changes are step on by the next programmer who does use their tool.
> Will Johnson
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> http://www.u2ug.org/listinfo/u2-users
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

RE: [U2] MV Fad - UniVerse (Pick) vs Oracle

[tvankirk]

Dennis,
What are these sites supposed to show? My company blocks "job search" 
websites and the other one comes up with a motorcycle site. I am 
interested in performance bechmarks/comparisons, maybe you can give us the 
details.
Thanks!





"Dennis Bartlett" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/06/2004 04:39 AM
Please respond to u2-users
 
To: <[EMAIL PROTECTED]>
cc: 
Subject:RE: [U2] MV Fad - UniVerse (Pick) vs Oracle


>> maybe that is why their database is losing to Oracle?:)

Just had to leap in here... Just for interest's sake have a
look at
these two sites

www.pnet.co.za

www.1time.com

Pnet is run on UniVerse, 1Time is run on Oracle.

Being a total illiterate regarding Oracle I found this quite
interesting. Check out the speed difference!
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

RE: [U2] MV Fad - UniVerse (Pick) vs Oracle

[Dennis Bartlett]

>> maybe that is why their database is losing to Oracle?:)

Just had to leap in here... Just for interest's sake have a
look at
these two sites

www.pnet.co.za

www.1time.com

Pnet is run on UniVerse, 1Time is run on Oracle.

Being a total illiterate regarding Oracle I found this quite
interesting. Check out the speed difference!
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

[U2] Unidata login terminating

[graham.forbes]

Just seen various emails from Universe users about a problem with non
administrator users having telnet sessions terminating, and think I may have
a similar problem on Unidata 6, W2000. Our telnet parameters prompt for the
path when a user logs in, if I leave the path the same the user can log in
with no problems. If I change the PATH to a valid Unidata account path, the
telnet process hangs on the client, and I get a 'Application popup' event on
the application server.

Event Type:   Information
Event Source:Application Popup
Event Category: None
Event ID:   26
Date:03/05/2004
Time:10:39:05
User:N/A
Computer: FL-AVANTEDB-01
Description:
Application popup: udt.exe - Application Error : The instruction at
"0x100408ca" referenced memory at "0x". The memory could not be
"read".

Click on OK to terminate the program

If I leave the path as the default, and then use a 'LOGTO' it works. If I
change the default path in Unidata admin, it works OK.

The reason I think this may be linked to the Universe problem is this only
started happening on 1st May, after we loaded the patch's for the MS04-011
vulnerability.

Has anyone else on W2000 with Unidata 6 seen a similar problem?

Graham Forbes
BT Syntegra





This email may contain information which is privileged or confidential. If you
are not the intended recipient of this email, please notify the sender
immediately and delete it without reading, copying, storing, forwarding or
disclosing its contents to any other person
Thank you

Check us out at http://www.btsyntegra.com


---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users

RE: [U2] MV Fad

[David Jordan]

The reason large numbers of people don't attend spectrum, is that 90% of
PICK users don't even know they use PICK.  I was at the International CEBIT
show in Sydney Australia today and I identified at least 3 Pick shops doing
thriving business, but they were all sellinng solutions, not PICK.

A number of software houses moved from PICK to other technologies, most of
them have gone, whilst most PICK software houses have remained viable for
years. With the IT depression of the last couple of years, you will find the
proportion of PICK software houses to other will have increased in PICK's
favour, as they are able to provide cost effective solutions.

Regards

David Jordan 
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users