u2-users@listserver.u2ug.org
This is a great reply from David T Meeks and Leroy Drefuss to a question that I had some time ago. HTH http://www.indexinfocus.com/dl/u2list/200201/25954.html -- Original message -- > We've just upgraded one of our HPUX machines and have started receiving > an intermittent unix error, I assume this is caused by an incorrectly > set tunable somewhere. > > We have a number of programs the use !SET.PTR to define print unit 1 (or > even 0) with mode 3 (print to &HOLD&) with a banner. > > The programs then make an active select list and EXECUTEs a LIST > statement with the LPTR 1 keyword specified. > > We then see (what I assume is a unix error) "&HOLD&/: Too many open > files" (where is the banner name) - this message does NOT appear in > any active COMO. > > Then another message: "Cannot open file &HOLD&." is displayed (this one > does end up in the COMO). > > Other programs that use !SET.PTR (to the &HOLD& file) but then perform > their own "PRINT ON 1" statements all worked correctly. > > We've had no problems with any of our other files (all of which are > dynamic), although we did get a few problems starting phantoms, when we > received the message "Cannot open file &PH&". > > Any ideas as too which tunable may be responsible for this problem? > > AdrianW > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
u2-users@listserver.u2ug.org
Search the archives for MFILES -- Original message -- > We've just upgraded one of our HPUX machines and have started receiving > an intermittent unix error, I assume this is caused by an incorrectly > set tunable somewhere. > > We have a number of programs the use !SET.PTR to define print unit 1 (or > even 0) with mode 3 (print to &HOLD&) with a banner. > > The programs then make an active select list and EXECUTEs a LIST > statement with the LPTR 1 keyword specified. > > We then see (what I assume is a unix error) "&HOLD&/: Too many open > files" (where is the banner name) - this message does NOT appear in > any active COMO. > > Then another message: "Cannot open file &HOLD&." is displayed (this one > does end up in the COMO). > > Other programs that use !SET.PTR (to the &HOLD& file) but then perform > their own "PRINT ON 1" statements all worked correctly. > > We've had no problems with any of our other files (all of which are > dynamic), although we did get a few problems starting phantoms, when we > received the message "Cannot open file &PH&". > > Any ideas as too which tunable may be responsible for this problem? > > AdrianW > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
u2-users@listserver.u2ug.org
We've just upgraded one of our HPUX machines and have started receiving an intermittent unix error, I assume this is caused by an incorrectly set tunable somewhere. We have a number of programs the use !SET.PTR to define print unit 1 (or even 0) with mode 3 (print to &HOLD&) with a banner. The programs then make an active select list and EXECUTEs a LIST statement with the LPTR 1 keyword specified. We then see (what I assume is a unix error) "&HOLD&/: Too many open files" (where is the banner name) - this message does NOT appear in any active COMO. Then another message: "Cannot open file &HOLD&." is displayed (this one does end up in the COMO). Other programs that use !SET.PTR (to the &HOLD& file) but then perform their own "PRINT ON 1" statements all worked correctly. We've had no problems with any of our other files (all of which are dynamic), although we did get a few problems starting phantoms, when we received the message "Cannot open file &PH&". Any ideas as too which tunable may be responsible for this problem? AdrianW --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Exit BASIC program with SELECT list?
At 04:43 PM 25/10/2004 -0700, you wrote: Is it possible to create a SELECT list inside a BASIC program, then make that list be the active SELECT list 0 after the program terminates? In other words, I want to build lists in a program, and when I return to TCL I want to see the >> prompt and have an active select list. Any ideas? Greetings, Yes it is possible (I am thinking of SHOW here). You will need to set the "Keep select list" processor mode to keep the select list after the program has terminated. See Administering Universe Section 18 Adding capabilities to UV Heading "Adding commands to the VOC" Regards, .Darren. = Congratulations! You have been so successful at the task of scapegoat that we have decided to upgrade your status to martyr! = --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Exit BASIC program with SELECT list?
Hi Barry,
You mean, like this?
*BBBecause it's easy to remember and type
PERFORM "SELECT CM SAMPLE 5"
STOP
:BBB
5 records selected to list 0.
>
Or did you want to actually write to the file that lists are saved in, and
then get the list before ending the program?
In Unidata that file is called SAVEDLISTS. If you wanted to create a list
named AEE you would:
WRITE LIST.REC ON SAVEDLISTS, "AEE000"
appending three zeros to the end of what you wanted the name to be.
To create the list, you would:
LIST.REC = ''
LOOP
READNEXT ID ELSE EXIT
{{do something to create AN.ID}}
LIST.REC<-1> = AN.ID
REPEAT
WRITE LIST.REC ON SAVEDLISTS, "AEE000"
STOP
hth, Allen
btw, you should always mention whether you're using Unidata, or Universe as
there are several differences.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Barry Brevik
Sent: Monday, October 25, 2004 16:44
To: U2-users (E-mail)
Subject: [U2] [UV] Exit BASIC program with SELECT list?
Is it possible to create a SELECT list inside a BASIC program, then make
that list be the active SELECT list 0 after the program terminates?
In other words, I want to build lists in a program, and when I return to TCL
I want to see the >> prompt and have an active select list.
Any ideas?
Barry
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Exit BASIC program with SELECT list?
We do this very thing in a number of our utility programs. We catalog the program and then append a "K" to the characters that appear in field 4 of the generated VOC entry. So field 4 is "BNK" (in our case) - the "K" means "Keep any select list active". Eg. One of ours looks like this: 0001: V 0002: *dedp*PROGS 0003: B 0004: BNK Adrian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Brevik Sent: Tuesday, 26 October 2004 7:44 AM To: U2-users (E-mail) Subject: [U2] [UV] Exit BASIC program with SELECT list? Is it possible to create a SELECT list inside a BASIC program, then make that list be the active SELECT list 0 after the program terminates? In other words, I want to build lists in a program, and when I return to TCL I want to see the >> prompt and have an active select list. Any ideas? Barry --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV] Exit BASIC program with SELECT list?
Is it possible to create a SELECT list inside a BASIC program, then make that list be the active SELECT list 0 after the program terminates? In other words, I want to build lists in a program, and when I return to TCL I want to see the >> prompt and have an active select list. Any ideas? Barry --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] 10.1 SELECT FILE BY DICT (I-type - SUBR) causing Read operation failure
Try doing the SELECT BY on dictionary items PMG.ADD.INSURED.REFER.NO
PGM.PCF.ACCT.ID PMG.INSURED.REFER.NUMBER
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Monday, October 25, 2004 12:02 PM
To: [EMAIL PROTECTED]
Subject: RE: [U2] [UV] 10.1 SELECT FILE BY DICT (I-type - SUBR) causing Read
operation failure
Here's what I inherited (unfortunately not simple in structure):
DICT Record: PMG.NAMED.DEFENDANT.REFER.NUMBER
0001: I
0002: IF @RECORD<3> # "Y" THEN "" ELSE IF PMG.ADD.INSURED.FLAG = "Y"
THEN PMG.ADD.INSURED.REFER.NO ELSE IF PMG.PCF.ACCT.ID # "" THEN
PMG.PCF.ACCT.ID ELSE PMG.INSURED.REFER.NUMBER
The fields that are referenced above are working fine - it's the last
field (PMG.INSURED.REFER.NUMBER) that does the subroutine calls that are
causing issues:
Record name = PMG.INSURED.REFER.NUMBER(this is an indexed field,
and is having no trouble by itself)
0001: I
0002: SUBR("PMG.INSURED.REFER.NUMBER
",PMG.CG.NOTICE.DATE,PMG.COVERAGE.CONTEXT,22)
There are 4 data files this subroutine opens using EQU BMS$.FILENAME TO
COM.FILE(nnn), then OPEN "FILENAME" TO BMS$.FILENAME. It then sets a few
variables, and then calls another subroutine:
CALL CL.GET.COVERAGE.RISK(ERR.PACKET,IARGS,OARGS)
This subroutine sets the EQU BMS$.FILENAME TO COM.FILE(nnn), then READs
records from the 4 data files to formulate values to be returned.
> SELECT CLAIMS SAVING PMG.NAMED.DEFENDANT.REFER.NUMBER - works fine.
> SELECT CLAIMS BY PMG.NAMED.DEFENDANT.REFER.NUMBER - processes for a
while, then starts kicking 'Read operation failure' errors.
These Read operation failures are also kicking when we attempt to
BUILD.INDEX on this field (the original source of finding the problem).
|-+-->
| | Kathleeni M Bodine |
| | <[EMAIL PROTECTED]|
| | t> |
| | Sent by: |
| | [EMAIL PROTECTED]|
| | er.u2ug.org|
| | |
| | |
| | 10/25/2004 01:31 PM|
| | Please respond to |
| | u2-users |
| | |
|-+-->
>---
|
|
|
| To: <[EMAIL PROTECTED]>
|
| cc:
|
| Subject: RE: [U2] [UV] 10.1 SELECT FILE BY DICT (I-type - SUBR)
causing Read operation failure |
>---
|
Is the dictionary use the attribute that is index and what is the
dictionary
doing that you would access the index files.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett
Sent: Monday, October 25, 2004 9:04 AM
To: [EMAIL PROTECTED]
Subject: RE: [U2] [UV] 10.1 SELECT FILE BY DICT (I-type - SUBR) causing
Read
operation failure
AIX 5.2, Universe 10.1.2
We're getting exactly the same thing ... so far we've kinda eliminated all
things 'cept the index, so that was our focus today. A rebuild of the
offending index fixed the problem.
maybe that'll help?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, 25 October, 2004 3:58 PM
To: [EMAIL PROTECTED]
Subject: [U2] [UV] 10.1 SELECT FILE BY DICT (I-type - SUBR) causing Read
operation failure
Just upgraded to AIX 5.2 and UV 10.1 and we're thinking we may be filling
some
workspace somewhere.
Here's what we have:
A DICT I-Type that calls a subroutine. This subroutine sets some
variables,
then calls another
subroutine that does READs of 3 different files to produce a value.
When we LIST FILENAME DICTITEM it processes fine, and will list out all
records with values
for this field.
When we SELECT FILENAME SAVING DICTITEM it also processes fine, and
returns
an active select
of values which we can save.
However, sorting, with SELECT FILENAME BY DICTITEM (even with SAMPLE
n)
processes to a
point, then starts kicking out 'Read operation failure' errors. Once
this
happens, we have to
log out/in of UniVerse to reset or the errors will kick right away if we
issue the command
again.
This statement worked fine at release 9.5 prior to upgrading. We
verified
the settings in
uvconfig, and tested the data files being used for any corruption - none
found.
We're needing to build an index on this field, and can't get past the
selection.
Anyone run into anything similar? Thanks!
---
This email and any files transmitted with it are intended
RE: Unclassified RE: [U2] Universe on windows
We run 11 windows servers on a mixture of 2000 and 2003. By and large we've been quite happy with them but we're now moving to Sun as Windows is very expensive and difficult to maintain/setup when you get past 8 processors. From: [EMAIL PROTECTED] on behalf of HENDERSON MICHAEL MR Sent: Mon 25/10/2004 20:35 To: [EMAIL PROTECTED] Subject: Unclassified RE: [U2] Universe on windows Susan, I believe you said 'Windows XP' in your original post. No we don't run any production server applications on XP: it's a client O/S. But we certainly do run our main production UV application (220 users) on Windows Server 2003, we were probably one of the earlier sites to go to that particular platform. We changed from HP-UX to W2K3 for cost and compatibility reasons. We have been developing on Win NT / 2K / 2K3 for about five years now, but only swapped Production when our HP box needed upgrading about eighteen months ago. Regards Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Saturday, 23 October 2004 02:33 To: [EMAIL PROTECTED] Subject: Re: [U2] Universe on windows Thanks so much to everyone who responded that they are using UniVerse successfully on Windows. I thought it was interesting that no one seems to run production in that combination ... but that's okay, like all of you that responded, we'll just be developing on that platform. Thanks! SJ -- The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] New spam filter
Hi all, I'm in the process of setting up a new "sender address verified" spam filter. If you receive an email from me requesting that you verify your address, please ignore it. It's taking a little fine tuning to get this working with the mailing lists to which I'm subscribed, but I think I'm pretty close. My apologies for any inconvenience. Larry Hiscock Western Computer Services http://www.wcs-corp.com/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Unclassified RE: [U2] Universe on windows
Susan, I believe you said 'Windows XP' in your original post. No we don't run any production server applications on XP: it's a client O/S. But we certainly do run our main production UV application (220 users) on Windows Server 2003, we were probably one of the earlier sites to go to that particular platform. We changed from HP-UX to W2K3 for cost and compatibility reasons. We have been developing on Win NT / 2K / 2K3 for about five years now, but only swapped Production when our HP box needed upgrading about eighteen months ago. Regards Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Saturday, 23 October 2004 02:33 To: [EMAIL PROTECTED] Subject: Re: [U2] Universe on windows Thanks so much to everyone who responded that they are using UniVerse successfully on Windows. I thought it was interesting that no one seems to run production in that combination ... but that's okay, like all of you that responded, we'll just be developing on that platform. Thanks! SJ -- The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] 10.1 SELECT FILE BY DICT (I-type - SUBR) causing Read operation failure
Here's what I inherited (unfortunately not simple in structure):
DICT Record: PMG.NAMED.DEFENDANT.REFER.NUMBER
0001: I
0002: IF @RECORD<3> # "Y" THEN "" ELSE IF PMG.ADD.INSURED.FLAG = "Y"
THEN PMG.ADD.INSURED.REFER.NO ELSE IF PMG.PCF.ACCT.ID # "" THEN
PMG.PCF.ACCT.ID ELSE PMG.INSURED.REFER.NUMBER
The fields that are referenced above are working fine - it's the last
field (PMG.INSURED.REFER.NUMBER) that does the subroutine calls that are
causing issues:
Record name = PMG.INSURED.REFER.NUMBER(this is an indexed field,
and is having no trouble by itself)
0001: I
0002: SUBR("PMG.INSURED.REFER.NUMBER
",PMG.CG.NOTICE.DATE,PMG.COVERAGE.CONTEXT,22)
There are 4 data files this subroutine opens using EQU BMS$.FILENAME TO
COM.FILE(nnn), then OPEN "FILENAME" TO BMS$.FILENAME. It then sets a few
variables, and then calls another subroutine:
CALL CL.GET.COVERAGE.RISK(ERR.PACKET,IARGS,OARGS)
This subroutine sets the EQU BMS$.FILENAME TO COM.FILE(nnn), then READs
records from the 4 data files to formulate values to be returned.
> SELECT CLAIMS SAVING PMG.NAMED.DEFENDANT.REFER.NUMBER - works fine.
> SELECT CLAIMS BY PMG.NAMED.DEFENDANT.REFER.NUMBER - processes for a
while, then starts kicking 'Read operation failure' errors.
These Read operation failures are also kicking when we attempt to
BUILD.INDEX on this field (the original source of finding the problem).
|-+-->
| | Kathleeni M Bodine |
| | <[EMAIL PROTECTED]|
| | t> |
| | Sent by: |
| | [EMAIL PROTECTED]|
| | er.u2ug.org|
| | |
| | |
| | 10/25/2004 01:31 PM|
| | Please respond to |
| | u2-users |
| | |
|-+-->
>---|
|
|
| To: <[EMAIL PROTECTED]>
|
| cc:
|
| Subject: RE: [U2] [UV] 10.1 SELECT FILE BY DICT (I-type - SUBR) causing
Read operation failure |
>---|
Is the dictionary use the attribute that is index and what is the
dictionary
doing that you would access the index files.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett
Sent: Monday, October 25, 2004 9:04 AM
To: [EMAIL PROTECTED]
Subject: RE: [U2] [UV] 10.1 SELECT FILE BY DICT (I-type - SUBR) causing
Read
operation failure
AIX 5.2, Universe 10.1.2
We're getting exactly the same thing ... so far we've kinda eliminated all
things 'cept the index, so that was our focus today. A rebuild of the
offending index fixed the problem.
maybe that'll help?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, 25 October, 2004 3:58 PM
To: [EMAIL PROTECTED]
Subject: [U2] [UV] 10.1 SELECT FILE BY DICT (I-type - SUBR) causing Read
operation failure
Just upgraded to AIX 5.2 and UV 10.1 and we're thinking we may be filling
some
workspace somewhere.
Here's what we have:
A DICT I-Type that calls a subroutine. This subroutine sets some
variables,
then calls another
subroutine that does READs of 3 different files to produce a value.
When we LIST FILENAME DICTITEM it processes fine, and will list out all
records with values
for this field.
When we SELECT FILENAME SAVING DICTITEM it also processes fine, and
returns
an active select
of values which we can save.
However, sorting, with SELECT FILENAME BY DICTITEM (even with SAMPLE
n)
processes to a
point, then starts kicking out 'Read operation failure' errors. Once
this
happens, we have to
log out/in of UniVerse to reset or the errors will kick right away if we
issue the command
again.
This statement worked fine at release 9.5 prior to upgrading. We
verified
the settings in
uvconfig, and tested the data files being used for any corruption - none
found.
We're needing to build an index on this field, and can't get past the
selection.
Anyone run into anything similar? Thanks!
---
This email and any files transmitted with it are intended only for the
person
or entity to which it is addressed and may contain confidential
and/or privilege
Re: [U2] connect to an access database
Sorry all about the 2 posts. I did not see the first one in the digest so I assumed it never got out there. Thanks for your patience with me though. Vance - Original Message - From: "Chauhan, Savita" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 25, 2004 9:49 AM Subject: RE: [U2] connect to an access database > Hi Vance, > I see that this is your second post and noone replied to the earlier > one. So I guess there is no way to directly access a database outside of > UV. You may have to write a connection application (I am not even sure, > how!!) > > I guess you know that the reverse is possible though. You can connect to > UV/UD database from MS-Access via ODBC. > > Hope there is an easier way to achieve what you are trying to do and > someone replies the same. > > Good luck. > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Monday, October 25, 2004 8:33 AM > To: [EMAIL PROTECTED] > Subject: [U2] connect to an access database > > Hello all, > > Is anyone familiar with a way to connect an MVBasic app to an access > database > or datasource ? > I need to be able to read/ write to/from a specifiac datasource. Is > there a > way I can connect from within a UV app to another datasource via ODBC ? > Any > transport will do really. > I was thinking of writing an outside app to do the data connection to > pass > and retr for the uvapp but if theres a more direct approach from the > MVApp > itself, I'm wide open to suggestions. > > Thanks in advance, > Vance > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] connect to an access database
This is great at first glance and seems like the perfect solution. I'm gonna get reading... Thanks much Vance - Original Message - From: "Jeff Schasny" <[EMAIL PROTECTED]> To: "U2 Group" <[EMAIL PROTECTED]> Sent: Monday, October 25, 2004 10:02 AM Subject: [U2] connect to an access database > Here's one way: > > http://www-306.ibm.com/software/data/u2/pubs/library/96univ/bci/BCI.pdf > > Describes how to use the BASIC SQL Client Interface (BCI), an interface to UniVerse and non-UniVerse databases from UniVerse BASIC. The BASIC SQL Client Interface uses ODBC-like function calls to execute SQL statements on local or remote database servers such as UniVerse, INFORMIX, ORACLE, Microsoft SQL Server, or SYBASE. > > Jeff Schasny | Denver, Colorado, USA | [EMAIL PROTECTED] > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] connect to an access database
Many people have emailed to ask for the attachment since it got filtered.
I am inserting it as text below my signature.
Rich Taylor | Senior Programmer/Analyst| VERTIS
250 W. Pratt Street | Baltimore, MD 21201
P 410.361.8688 | F 410.528.0319
[EMAIL PROTECTED] | http://www.vertisinc.com
Vertis is the premier provider of targeted advertising, media, and
marketing services that drive consumers to marketers more effectively.
"The more they complicate the plumbing
the easier it is to stop up the drain"
- Montgomery Scott NCC-1701
**\/\/\/\/\/\//\/\/\/\/\/\/\/
$INCLUDE UNIVERSE.INCLUDE ODBC.H
*
PROGRAM = 'SOSHIP.UPDATE'
ERROR.NO = 0
*---
*Preparing the SQL processes
*---
SQL.OK = TRUE ; * error flag for sql processes
SQL.STATUS = ClearDiagnostics()
* setup the ODBC connection to the SOSHIP.mdb file
SQL.STATUS = SQLAllocConnect(@HENV,SOSHIP.MDB.CONNECT)
IF SQL.STATUS <> SQL.SUCCESS THEN
MESSAGE = "Could not establish a connection to the Access
workspace: "
MESSAGE := "Failed to allocate a CONNECTION environment"
GOSUB ERROR.PROCESS
SQL.OK = FALSE
END
IF SQL.OK THEN
GOSUB MDB.CONNECT
END; * endif sql.ok
(SOSHIP.MDB.CONNECT)
* Setup the ODBC connection to the LOCAL UV account
SQL.STATUS = SQLAllocConnect(@HENV,SOSHIP.UV.CONNECT)
IF SQL.STATUS <> SQL.SUCCESS THEN
MESSAGE = "Could not establish a connection to the Universe
Database environment: "
MESSAGE := "Failed to allocate a CONNECTION environment"
GOSUB ERROR.PROCESS
SQL.OK = FALSE
END
IF SQL.OK THEN
SQL.STATUS = SQLConnect(SOSHIP.UV.CONNECT,"localuv",'','')
IF SQL.STATUS <> SQL.SUCCESS THEN
MESSAGE = "Could not establish a connection to the Universe
Database environment: "
MESSAGE := "Failed to connect to data source"
GOSUB ERROR.PROCESS
SQL.OK = FALSE
END
END; * endif sql.ok
(SOSHIP.UV.CONNECT)
* setup customer table transfer sql statement environments
SQL.STATUS = SQLAllocStmt(SOSHIP.UV.CONNECT,CUSTOMER.SEL.STMT)
IF SQL.STATUS <> SQL.SUCCESS THEN
MESSAGE = "Could not access the CUSTOMER file in Universe: "
MESSAGE := "Failed to allocate a STATEMENT environment (select)"
GOSUB ERROR.PROCESS
SQL.OK = FALSE
END
SQL.STATUS = SQLAllocStmt(SOSHIP.MDB.CONNECT,CUSTOMER.INS.STMT)
IF SQL.STATUS <> SQL.SUCCESS THEN
MESSAGE = "Could not access the CUSTOMER file in Universe: "
MESSAGE := "Failed to allocate a STATEMENT environment (insert)"
GOSUB ERROR.PROCESS
SQL.OK = FALSE
END
* SQL statement objects to access SOSHIP.MDB parts Allocations table
SQL.STATUS = SQLAllocStmt(SOSHIP.MDB.CONNECT,SOSHIP.PARTS)
IF SQL.STATUS <> SQL.SUCCESS THEN
MESSAGE = "Could not access the SOSHIP parts allocations table in
SOSHIP.mdb: "
MESSAGE := "Failed to allocate a STATEMENT environment"
GOSUB ERROR.PROCESS
END
* SQL statement objects to access SOSHIP.MDB Order Allocations table
SQL.STATUS = SQLAllocStmt(SOSHIP.MDB.CONNECT,SOSHIP.ORDERS)
IF SQL.STATUS <> SQL.SUCCESS THEN
MESSAGE = "Could not access the SOSHIP Orders Allocations table
in SOSHIP.mdb: "
MESSAGE := "Failed to allocate a STATEMENT environment"
GOSUB ERROR.PROCESS
END
IF NOT(SQL.OK) THEN
CLOSE SOSHIPF
STOP
END; * endif not(sql.ok) ...
*---
* End of SQL Preparation
*---
LOOP
SQL.STATUS = ClearDiagnostics()
SQL.OK = TRUE
GOSUB RESET.SQL.STATEMENTS
GOSUB PREPARE.SQL.INSERT.COMMANDS
IF NOT(SQL.OK) THEN EXIT
SQL.STATUS = ClearDiagnostics()
' code removed
UNTIL RET.VALUE<1> = "CANCEL" DO
SOSHIP.ID = PART.NO:"*":LOCATION
* get the inventory balance and part description
INV = RAISE(TRANS('INV',PART.NO,-1,'X'))
LOCATE(LOCATION,INV,2;LOC.VMC) THEN
INV.BAL = OCONV(INV<3,LOC.VMC>,'MR4')
END ELSE
INV.BAL = 0
END ; * endlocat(location,inv
PART.DESC = TRANS('PARTS',PART.NO,1,'X')
* calculate header totals
ALLOC = OCONV(SUM(SOSHIP<14>),'MR4')
ON.ORDER = OCONV(SUM(SOSHIP<4>), 'MR4')
BACKORDER = ON.ORDER - ALLOC
NUM.ORDER = 0
NUM.CUST = 0
RE: [U2] Spooler question
Here is the number you need when you call Microsoft to get the fix. The fix will be in SP1 on server 2003 Q820550 Thanks, Tony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: Tuesday, October 19, 2004 8:15 AM To: [EMAIL PROTECTED] Subject: [U2] Spooler question We have two system printers, and would like to set up the following scenario... One form queue that prints the next incoming job on any of the two printers, BUT allows us to specify certain reports that need to come out one after the other (ie on one printer) Thanks dennis - 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, M van Zyl, 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] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] 10.1 SELECT FILE BY DICT (I-type - SUBR) causing Read operation failure
Is the dictionary use the attribute that is index and what is the dictionary doing that you would access the index files. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: Monday, October 25, 2004 9:04 AM To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] 10.1 SELECT FILE BY DICT (I-type - SUBR) causing Read operation failure AIX 5.2, Universe 10.1.2 We're getting exactly the same thing ... so far we've kinda eliminated all things 'cept the index, so that was our focus today. A rebuild of the offending index fixed the problem. maybe that'll help? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, 25 October, 2004 3:58 PM To: [EMAIL PROTECTED] Subject: [U2] [UV] 10.1 SELECT FILE BY DICT (I-type - SUBR) causing Read operation failure Just upgraded to AIX 5.2 and UV 10.1 and we're thinking we may be filling some workspace somewhere. Here's what we have: A DICT I-Type that calls a subroutine. This subroutine sets some variables, then calls another subroutine that does READs of 3 different files to produce a value. When we LIST FILENAME DICTITEM it processes fine, and will list out all records with values for this field. When we SELECT FILENAME SAVING DICTITEM it also processes fine, and returns an active select of values which we can save. However, sorting, with SELECT FILENAME BY DICTITEM (even with SAMPLE n) processes to a point, then starts kicking out 'Read operation failure' errors. Once this happens, we have to log out/in of UniVerse to reset or the errors will kick right away if we issue the command again. This statement worked fine at release 9.5 prior to upgrading. We verified the settings in uvconfig, and tested the data files being used for any corruption - none found. We're needing to build an index on this field, and can't get past the selection. Anyone run into anything similar? Thanks! --- This email and any files transmitted with it are intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you received this email in error, please contact the sender immediately and delete this email from your system. If you are not the named addressee, you should not disseminate, distribute, print, or copy the email, or take any action in reliance on its contents. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ - 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, M van Zyl, 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] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] connect to an access database
I was very interested to see your code but the attachment didn't make it. Could you paste your code into another email? Much appreciated. Stu Glancy Richard Taylor wrote: Yes, you can do this, I have an operation program that reads and writes an Access Database from a UV Basic program. I am attaching a sample program that shows the techniques written under Universe. I had to change the code to remove any proprietary information, but you should still be able to follow the logic of reading and writing to an access database. One caveat, this was written to work with UV on Windows. I believe that this should work on Unix too as long as ODBC has been configured. You will also need to setup an odbc data source on the client that points to your Access database. In this program that is call "SOSHIP" and is referenced in the MDB.CONNECT subroutine. Sorry I don't have an example of that, but if you have trouble post back an I will dig in some more. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. "The more they complicate the plumbing the easier it is to stop up the drain" - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, October 25, 2004 9:33 AM To: [EMAIL PROTECTED] Subject: [U2] connect to an access database Hello all, Is anyone familiar with a way to connect an MVBasic app to an access database or datasource ? I need to be able to read/ write to/from a specifiac datasource. Is there a way I can connect from within a UV app to another datasource via ODBC ? Any transport will do really. I was thinking of writing an outside app to do the data connection to pass and retr for the uvapp but if theres a more direct approach from the MVApp itself, I'm wide open to suggestions. Thanks in advance, Vance --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type application/octet-stream which had a name of ACCESS DATABASE CODE] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] 10.1 SELECT FILE BY DICT (I-type - SUBR) causing Read operation failure
AIX 5.2, Universe 10.1.2 We're getting exactly the same thing ... so far we've kinda eliminated all things 'cept the index, so that was our focus today. A rebuild of the offending index fixed the problem. maybe that'll help? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, 25 October, 2004 3:58 PM To: [EMAIL PROTECTED] Subject: [U2] [UV] 10.1 SELECT FILE BY DICT (I-type - SUBR) causing Read operation failure Just upgraded to AIX 5.2 and UV 10.1 and we're thinking we may be filling some workspace somewhere. Here's what we have: A DICT I-Type that calls a subroutine. This subroutine sets some variables, then calls another subroutine that does READs of 3 different files to produce a value. When we LIST FILENAME DICTITEM it processes fine, and will list out all records with values for this field. When we SELECT FILENAME SAVING DICTITEM it also processes fine, and returns an active select of values which we can save. However, sorting, with SELECT FILENAME BY DICTITEM (even with SAMPLE n) processes to a point, then starts kicking out 'Read operation failure' errors. Once this happens, we have to log out/in of UniVerse to reset or the errors will kick right away if we issue the command again. This statement worked fine at release 9.5 prior to upgrading. We verified the settings in uvconfig, and tested the data files being used for any corruption - none found. We're needing to build an index on this field, and can't get past the selection. Anyone run into anything similar? Thanks! --- This email and any files transmitted with it are intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you received this email in error, please contact the sender immediately and delete this email from your system. If you are not the named addressee, you should not disseminate, distribute, print, or copy the email, or take any action in reliance on its contents. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ - 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, M van Zyl, 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] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] 10.1 SELECT FILE BY DICT (I-type - SUBR) causing Read operation failure
Another method would be to TRANS to the files first and pass those through the subroutine parameter list. If that is not possible, a quick way to see if it was the open files filling stuff up, would be to use the XLATE function within your subroutine which does not need an OPEN before using. It's not as fast as opening once and passing through common, but would be a quick way of testing if that was the problem, hth - aee Help Information For: "UNIBASIC XLATE" Syntax XLATE(filename, rec.id.expr, attrib.expr, "code") Description The UniBasic XLATE function returns the contents of an attribute and takes additional action if the record does not exist or the attribute is empty. This function performs the same action as the TRANS virtual attribute function. Parameters The following table describes each parameter of the syntax: Parameter Description filename Specifies the name of a file from which to return the contents of an attribute. file.expr must be the name of a valid UniData file, not the value of a file variable, even if the same file was opened within the program. rec.id.expr Specifies a record ID in file.expr. attrib.expr Specifies a valid attribute in file.expr. "code"Enter a code specifying action to be taken if the record does not exist or the attribute is empty: C -- Substitutes the id.exp for the value of the function. V -- Returns an empty string and print an error message. X -- Returns an empty string. Related Command UniData TRANS -- For information, see the Using UniData manual. Page 'U'p, 'D'own, 'T'op, 'B'ottom or 'Q'uit? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Fred Finken Sent: Monday, October 25, 2004 07:36 To: [EMAIL PROTECTED] Subject: Re: [U2] [UV] 10.1 SELECT FILE BY DICT (I-type - SUBR) causing Read operation failure Not sure if this is the problem, but make sure that you are not repeatedly opening the files in the subroutines. Open them once to named common. -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] connect to an access database
Yes, you can do this, I have an operation program that reads and writes an Access Database from a UV Basic program. I am attaching a sample program that shows the techniques written under Universe. I had to change the code to remove any proprietary information, but you should still be able to follow the logic of reading and writing to an access database. One caveat, this was written to work with UV on Windows. I believe that this should work on Unix too as long as ODBC has been configured. You will also need to setup an odbc data source on the client that points to your Access database. In this program that is call "SOSHIP" and is referenced in the MDB.CONNECT subroutine. Sorry I don't have an example of that, but if you have trouble post back an I will dig in some more. Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. "The more they complicate the plumbing the easier it is to stop up the drain" - Montgomery Scott NCC-1701 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, October 25, 2004 9:33 AM To: [EMAIL PROTECTED] Subject: [U2] connect to an access database Hello all, Is anyone familiar with a way to connect an MVBasic app to an access database or datasource ? I need to be able to read/ write to/from a specifiac datasource. Is there a way I can connect from within a UV app to another datasource via ODBC ? Any transport will do really. I was thinking of writing an outside app to do the data connection to pass and retr for the uvapp but if theres a more direct approach from the MVApp itself, I'm wide open to suggestions. Thanks in advance, Vance --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type application/octet-stream which had a name of ACCESS DATABASE CODE] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] 10.1 SELECT FILE BY DICT (I-type - SUBR) causing Read operation failure
It would help if you provide the dictionary. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, October 25, 2004 6:58 AM To: [EMAIL PROTECTED] Subject: [U2] [UV] 10.1 SELECT FILE BY DICT (I-type - SUBR) causing Read operation failure Just upgraded to AIX 5.2 and UV 10.1 and we're thinking we may be filling some workspace somewhere. Here's what we have: A DICT I-Type that calls a subroutine. This subroutine sets some variables, then calls another subroutine that does READs of 3 different files to produce a value. When we LIST FILENAME DICTITEM it processes fine, and will list out all records with values for this field. When we SELECT FILENAME SAVING DICTITEM it also processes fine, and returns an active select of values which we can save. However, sorting, with SELECT FILENAME BY DICTITEM (even with SAMPLE n) processes to a point, then starts kicking out 'Read operation failure' errors. Once this happens, we have to log out/in of UniVerse to reset or the errors will kick right away if we issue the command again. This statement worked fine at release 9.5 prior to upgrading. We verified the settings in uvconfig, and tested the data files being used for any corruption - none found. We're needing to build an index on this field, and can't get past the selection. Anyone run into anything similar? Thanks! --- This email and any files transmitted with it are intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you received this email in error, please contact the sender immediately and delete this email from your system. If you are not the named addressee, you should not disseminate, distribute, print, or copy the email, or take any action in reliance on its contents. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: Spam:[U2] connect to an access database
I use UniVerse's BCI (Basic Calling Interface) to READ data from Access/MySQL/DB2. Never tried to WRITE. Mark. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 9:33 AM To: [EMAIL PROTECTED] Subject: Spam:[U2] connect to an access database Hello all, Is anyone familiar with a way to connect an MVBasic app to an access database or datasource ? I need to be able to read/ write to/from a specifiac datasource. Is there a way I can connect from within a UV app to another datasource via ODBC ? Any transport will do really. I was thinking of writing an outside app to do the data connection to pass and retr for the uvapp but if theres a more direct approach from the MVApp itself, I'm wide open to suggestions. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] connect to an access database
In a message dated 10/25/2004 6:44:30 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: > Is anyone familiar with a way to connect an MVBasic app to an access > database > or datasource ? > I need to be able to read/ write to/from a specifiac datasource. Is there a > way I can connect from within a UV app to another datasource via ODBC ? Your message starts clear, then gets fuzzy. At the end you ask for ANY datasource. So what exactly are you trying to accomplish? YES you can, from within MvBasic, read and write to an outside datasource. The devil is in the details of this. For example, I have an MvBasic program, that connects to WorldShip. It sends data into WorldShip on a box to be shipped, WorldShip then processes the data (with possible user additional input), and the data is sent back into the MvBasic program. All of this is interactive, not batch. I have another MvBasic program, that writes data, launches Access and tells it to suck in the data, and write out a response, and then reads the response. It really all depends on exactly what you're trying to accomplish. There are many ways to skin a cat, but none in which the cat is very happy. Will --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] 10.1 SELECT FILE BY DICT (I-type - SUBR) causing Read operation failure
We will check this out to be sure. The odd thing is that a straight SELECT works fine i.e. SELECT FILENAME SAVING DICTITEM where a Sort in memory i.e. SELECT FILENAME BY DICTITEM fails after a certain point. |-+--> | | "Fred Finken" | | | <[EMAIL PROTECTED]> | | | Sent by: | | | [EMAIL PROTECTED]| | | er.u2ug.org| | | | | | | | | 10/25/2004 10:36 AM| | | Please respond to | | | u2-users | | | | |-+--> >---| | | | To: [EMAIL PROTECTED] | | cc: | | Subject: Re: [U2] [UV] 10.1 SELECT FILE BY DICT (I-type - SUBR) causing Read operation failure | >---| Not sure if this is the problem, but make sure that you are not repeatedly opening the files in the subroutines. Open them once to named common. -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- This email and any files transmitted with it are intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you received this email in error, please contact the sender immediately and delete this email from your system. If you are not the named addressee, you should not disseminate, distribute, print, or copy the email, or take any action in reliance on its contents. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] connect to an access database
Vance, Unfortunately, Access is not robust enough to be a true SQL data source. What that means to your question is; no it can't be accessed (no pun intended) from with an U2/MV basic application. You can however access MS SQL Server and other mainstream SQL compliant DB products from within an U2/MV basic application utilizing the BCI (BASIC SQL Client Interface Functions). HTH, Gordon Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 > -Original Message- > Hello all, > > Is anyone familiar with a way to connect an MVBasic app to an > access database or datasource ? I need to be able to read/ > write to/from a specifiac datasource. Is there a way I can > connect from within a UV app to another datasource via ODBC ? > Any transport will do really. I was thinking of writing an > outside app to do the data connection to pass and retr for > the uvapp but if theres a more direct approach from the MVApp > itself, I'm wide open to suggestions. > > Thanks in advance, > Vance 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] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] 10.1 SELECT FILE BY DICT (I-type - SUBR) causing Read operation failure
Not sure if this is the problem, but make sure that you are not repeatedly opening the files in the subroutines. Open them once to named common. -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Suspend.files
We have been using the suspend option as part of our back up plan, since we moved to UV 10.0.19 earlier this year, we are on AIX 5.2 ML3 at this time. Our back up process is scripted at the AIX level. We suspend UniVerse, then run sync several times, then break a 3rd set of mirrors, and unsuspend UniVerse. This process takes about 10 minutes to complete. We were using the AIX snap on and snap off commands, to take a snap shot of our system. However, IBM AIX has an issue with the snap logic, which can cause the system to hang - and the only way to get it back, is a hard reboot - which is not pretty. IBM AIX is working on this problem and with luck will have a fix in the next few weeks. Once they do, using the snap at AIX, only takes a minute or two and then UnVerse can be unsuspended. The back up then takes place on the snap area, once the back up is completed, you "snap off" and the snap area is removed. Once IBM has the snap correction in place, we will be moving to AIX 5.2 ML4, which is the version IBM is working on for the snap correction. It is my understanding that ML4 has other changes for UniVerse and for JFS2 file systems, which we are using. We are 24X7 and this has worked great for us (other than the snap issue). The users are able to continue to access the database for inquiry during the suspend, if they try to write, they will "hang" until the database is unsuspended. Our users know what time each night this will take place and know to not break out or reboot etc during this time. Hope this helps, feel free to drop me a note if you would like more information. Thanks and have a great day! Donald H. Cutting A. N. Deringer, Inc. D. B. A. / Systems Analyst Tel. (802) 524-8172 [EMAIL PROTECTED] www.anderinger.com U.S. Customs Brokers, International Freight Forwarders, Warehousing -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tom Dodds Sent: Monday, October 25, 2004 9:47 AM To: [EMAIL PROTECTED] Subject: [U2] Suspend.files Has anyone had any experience with using the SUSPEND.FILES command as a method of acquiring a clean backup of a UniVerse system. We are running UV 10.2.2 under AIX 5.2.2. Any insights would be appreciated. Tom Dodds [EMAIL PROTECTED] 630-235-2975 Cell 708-482-4510 Office --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Suspend.files
Wrong, 10.1.2 not 10.2.2 (Just washed my hands and can't do anything with them) Tom Dodds [EMAIL PROTECTED] 630-235-2975 Cell 708-482-4510 Office -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds Sent: Monday, October 25, 2004 8:47 AM To: [EMAIL PROTECTED] Subject: [U2] Suspend.files Has anyone had any experience with using the SUSPEND.FILES command as a method of acquiring a clean backup of a UniVerse system. We are running UV 10.2.2 under AIX 5.2.2. Any insights would be appreciated. Tom Dodds [EMAIL PROTECTED] 630-235-2975 Cell 708-482-4510 Office --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] connect to an access database
Here's one way: http://www-306.ibm.com/software/data/u2/pubs/library/96univ/bci/BCI.pdf Describes how to use the BASIC SQL Client Interface (BCI), an interface to UniVerse and non-UniVerse databases from UniVerse BASIC. The BASIC SQL Client Interface uses ODBC-like function calls to execute SQL statements on local or remote database servers such as UniVerse, INFORMIX, ORACLE, Microsoft SQL Server, or SYBASE. Jeff Schasny | Denver, Colorado, USA | [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] connect to an access database
Hi Vance, I see that this is your second post and noone replied to the earlier one. So I guess there is no way to directly access a database outside of UV. You may have to write a connection application (I am not even sure, how!!) I guess you know that the reverse is possible though. You can connect to UV/UD database from MS-Access via ODBC. Hope there is an easier way to achieve what you are trying to do and someone replies the same. Good luck. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, October 25, 2004 8:33 AM To: [EMAIL PROTECTED] Subject: [U2] connect to an access database Hello all, Is anyone familiar with a way to connect an MVBasic app to an access database or datasource ? I need to be able to read/ write to/from a specifiac datasource. Is there a way I can connect from within a UV app to another datasource via ODBC ? Any transport will do really. I was thinking of writing an outside app to do the data connection to pass and retr for the uvapp but if theres a more direct approach from the MVApp itself, I'm wide open to suggestions. Thanks in advance, Vance --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV] 10.1 SELECT FILE BY DICT (I-type - SUBR) causing Read operation failure
Just upgraded to AIX 5.2 and UV 10.1 and we're thinking we may be filling some workspace somewhere. Here's what we have: A DICT I-Type that calls a subroutine. This subroutine sets some variables, then calls another subroutine that does READs of 3 different files to produce a value. When we LIST FILENAME DICTITEM it processes fine, and will list out all records with values for this field. When we SELECT FILENAME SAVING DICTITEM it also processes fine, and returns an active select of values which we can save. However, sorting, with SELECT FILENAME BY DICTITEM (even with SAMPLE n) processes to a point, then starts kicking out 'Read operation failure' errors. Once this happens, we have to log out/in of UniVerse to reset or the errors will kick right away if we issue the command again. This statement worked fine at release 9.5 prior to upgrading. We verified the settings in uvconfig, and tested the data files being used for any corruption - none found. We're needing to build an index on this field, and can't get past the selection. Anyone run into anything similar? Thanks! --- This email and any files transmitted with it are intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you received this email in error, please contact the sender immediately and delete this email from your system. If you are not the named addressee, you should not disseminate, distribute, print, or copy the email, or take any action in reliance on its contents. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] Suspend.files
Has anyone had any experience with using the SUSPEND.FILES command as a method of acquiring a clean backup of a UniVerse system. We are running UV 10.2.2 under AIX 5.2.2. Any insights would be appreciated. Tom Dodds [EMAIL PROTECTED] 630-235-2975 Cell 708-482-4510 Office --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] connect to an access database
Hello all, Is anyone familiar with a way to connect an MVBasic app to an access database or datasource ? I need to be able to read/ write to/from a specifiac datasource. Is there a way I can connect from within a UV app to another datasource via ODBC ? Any transport will do really. I was thinking of writing an outside app to do the data connection to pass and retr for the uvapp but if theres a more direct approach from the MVApp itself, I'm wide open to suggestions. Thanks in advance, Vance --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] TERM TYPE
IBM-PC - Original Message - From: "Mark Johnson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 25, 2004 8:32 AM Subject: [U2] TERM TYPE > Anyone have an idea what TERM I (capital letter EFGH-I) converts to on an > MV-BASE system if I want to use Wintegrate. The normal emulator is MV-Term. > I'm not on the host and it's a W2K OS. > > THanks in advance > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] TERM TYPE
Anyone have an idea what TERM I (capital letter EFGH-I) converts to on an MV-BASE system if I want to use Wintegrate. The normal emulator is MV-Term. I'm not on the host and it's a W2K OS. THanks in advance --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UD] running a subroutine
That seems to be a nice compromise.
- Original Message -
From: "Kieran Clulow" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, October 24, 2004 7:14 PM
Subject: RE: [U2] [UD] running a subroutine
>
> Goto's are fine in user interface validation code if they remain within
the
> scope of a gosub block. Nowhere else though.
>
>
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
> Sent: Sunday, 24 October 2004 1:00 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [U2] [UD] running a subroutine
>
> GOTO's are for the mentally challenged!!!
> Have a nice day.
> Will
>
> In a message dated 10/22/2004 8:17:50 PM Pacific Daylight Time,
> [EMAIL PROTECTED] writes:
>
> > Ditto: This could be replaced with my single PRINT statement.
> >
> >
> > P.S. I'm surprised that this doesn't get flamed for the GOTO's. This
list
> is
> > usually GOTO-phobic.
>
>
>
> > - Original Message -
> > From: "Burwell, Edward" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Friday, October 22, 2004 2:03 PM
> > Subject: RE: [U2] [UD] running a subroutine
> >
> >
> > >001: PROMPT ""
> > >002: 10 PRINT STR("-",79)
> > >003: PRINT "'O'conv or 'I'conv ":;INPUT OI
> > >004: IF OI="" THEN STOP
> > >005: IF OI#"O" AND OI#"I" THEN GO 10
> > >006: IF OI="O" THEN ELB="OCONV"
> > >007: IF OI="I" THEN ELB="ICONV"
> > >008: 20 PRINT STR("-",79)
> > >009: PRINT "enter conversion ":;INPUT CONV
> > >010: IF CONV="" THEN GO 10
> > >011: 30 PRINT STR("-",79)
> > >012: PRINT "enter data to test ":;INPUT X
> > >013: IF X="" THEN GO 20
> > >014: PRINT ELB:'(':X:',"':CONV:'") --> ':
> > >015: IF OI="O" THEN
> > >016: PRINT OCONV(X,CONV)
> > >017: END ELSE
> > >018: PRINT ICONV(X,CONV)
> > >019: END
> > >020: GO 30
> > >021: END
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> To unsubscribe please visit http://listserver.u2ug.org/
>
> Disclaimer
> ~~~
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom
> they are addressed. If you have received this email in error please notify
the
> originator of the message. This footer also confirms that this
> email message has been scanned for the presence of computer viruses.
>
>
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects and Delphi
Chuck, I've used UniObjects with Delphi since it came out. I still rate Delphi by far the best tool for developing Windows applications - far superior to .Net. Regards, Brian > Anyone using UniObjects with Delphi? > > -- > - Charles Barouch --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Internal Subroutine
On Mon, 25 Oct 2004 10:48:14 +0100, you wrote: >If your system has Primos/Prime INFORMATION ancestry, I believe there >existed an internal Primos routine named cp$. Typically, such routines >were accessible from BASIC using the GCI. If that were the case, you may >end up calling something like "$CP$". > >Just a thought. Primos had a CP$ subroutine which you could use to invoke internal commands, such as "AS MT0". It appeared to be PL1 based, with three arguments. The first argument was character_varying with the command itself, the second and third were error return codes. -- Allen Egerton [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Internal Subroutine
If your system has Primos/Prime INFORMATION ancestry, I believe there existed an internal Primos routine named cp$. Typically, such routines were accessible from BASIC using the GCI. If that were the case, you may end up calling something like "$CP$". Just a thought. John Appleyard "Ron Hutchings" <[EMAIL PROTECTED] To: [EMAIL PROTECTED] com>cc: (bcc: John Appleyard/BSDUK/AJG) Sent by:Subject: [U2] Internal Subroutine [EMAIL PROTECTED] er.u2ug.org 22/10/2004 18:36 Please respond to u2-users We ran across a call to a routine named $CP$ and can find no references to it. Can anyone shed some light on this? We are running Universe 9.6. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Internal Subroutine
One possibility could be that it is a user exit to the conversion routines - look for a xCONV( ...,"UCP$") -- mats Ron Hutchings wrote: We ran across a call to a routine named $CP$ and can find no references to it. Can anyone shed some light on this? We are running Universe 9.6. _ Dont just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects and Delphi
Yes we are using delphi with uniobjects more and more, we are well away on making a template for hardcore use now, last week we introduced our first non-green screen application ever for our users :-) It looks very promising, however it would be nice if IBM would provide all the neccessary delphi stuff with uniobjects instead of solely supporting visual basic... best regards from Denmark Claus Derlien edb-afdelingen direkte : 63 13 86 69 email : [EMAIL PROTECTED] > Anyone using UniObjects with Delphi? > > -- > - Charles Barouch Frie Funktionfrer - faglig organisation og tvfrfaglig a-kasse - www.f-f.dk *** Denne email og alle filer vedlagt som bilag kan indeholde fortroligt materiale, der kun er beregnet for adressaten, og maa ikke udleveres eller kopieres til uvedkommende. Har De ved en fejltagelse modtaget denne email, bedes De venligst omgaaende meddele os dette pr. telefon : 6313 8550. Paa forhaand tak. *** This email and any files transmitted with it may contain confidential information intended for the addressee(s) only. The information is not to be surrendered or copied to unauthorised persons. If you have received this communication in error, please notify us immediately by telephone: +45 6313 8550. Thank you. *** --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
