Re: [U2] FW: [UV] Change in behaviour of EXECUTE ... CAPTURING at 10.1.18 {Unclassified}
You have my sincere sympathy!
Something has gone awfully wrong with updating UniVerse lately, and they
don't seem to think it is important that behaviour that has been there for
decades should suddenly change (eg user number for each session, A1,-1 = B
adding @VM to A if it is not blank, but B is).
Good luck!
- Original Message -
From: HENDERSON MIKE, MR [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Thursday, June 08, 2006 10:45 AM
Subject: [U2] FW: [UV] Change in behaviour of EXECUTE ... CAPTURING at
10.1.18 {Unclassified}
Folks,
We have been using EXECUTE RetrieVe statement that generates an XML
output CAPTURING STUFF to generate XML statements in STUFF. We then
pass the XML to a BizTalk server to update a number of other systems
from our UniVerse system. This is done from a Trigger program when
certain files change.
This has worked fine on 10.0.15, but since I upgraded the Development
server to 10.1.18, the STUFF variable gets a 'page feed'
ESC[HESC[J inserted every 24 lines. Not unreasonably, this upsets
the MS XML parser in BizTalk!
Note that this is a new feature, it never happened on 10.0.15.
Does anyone know why this happens?
- maybe I missed a uv.config file change in the upgrade?
- maybe this is an exciting 10.1.x 'new feature' [AKA 'bug']?
I know that changing the terminal page depth works, but the TERM verb is
not allowed in Transaction State, and a Trigger is always in Transaction
State.
Unless there's a config change I can make, I can see three ways of
fixing this quickly:
1) fiddling the TERM verb options in the VOC to allow it in
Transaction State
Nasty, will probably work, may have unexpected side-effects
2) Filter the STUFF variable to catch and discard these lines
Crude, may increase the trigger running time significantly, but
will work
3) Upgrade the program to use the brand-new-in-10.1 XMLEXECUTE
verb.
Documentation is sparse to non-existent, except for what the
list has already found for me.
Not sure I want to be that 'bleeding edge' for this important
production application.
And then of course, there's always
4) Upgrade again to 10.1.pick a number, the bug has been found
and fixed
Help!
Thanks
Mike
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
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] IBM U2 UniData ODBC sample working program
Hi Angelo - as mentioned i will send you an example program later (sorry been a bit busy) What i have done for unidata on linux is the following ... 1. Install the databases odbc library (i.e. MyODBC for MySQL) 2. Environment variables (these are the locations i normally set) ODBCSYSINI=/usr/local/etc - directory where odbc.ini is kept ODBCINI=/usr/local/etc/odbc.ini - my shorthand locator for the odbcini file LD_LIBRARY_PATH=/usr/local/lib - odbc shared library directory. NB the name of this env var is different by unix type !! 3. relink the shared libraries - this is the relink.udlibs script. This is set to /usr/local/lib and I ensure the odbc drivers I require are in this directory. All this script does is create /.udlibs as a sym link. 4. Setup odbc.ini - this file (as defined in env var ODBCINI) contains the datasource names and connection info - mysql installs an example one which you can amend. The snippet below shows a datasource called adprecision [adprecision] Driver = /usr/lib/libmyodbc.so Description = MySQL ODBC on localserver SERVER = localhost PORT = 3306 USER = admin Password = Database = adprecision OPTION = 3 SOCKET = TraceFile= /tmp/odbc.trace Trace= 1 5. Test - use CONNECT datasource at TCL and doa simple sql query. All of the above was for a MySQL database using the MyODBC library. I don't think all steps are needed as above but this always works for me. If connecting to Oracle there are more steps as there is a driver and a client that need installing and setting up, and other odbc libraries have their own funny quirks :( rgds Symeon. On 07/06/06, Angelo Collazo [EMAIL PROTECTED] wrote: Hello fellow groupies, After downloading the document called Accessing SQL Data through BCI, the example is from U2 under Windows. It talks about U2 under UNIX but it requires additional steps on how setup up ODBC because it is not native to UNIX. I have found a .pdf file on the IBM website called Basic SQL client Interface Guide for UniVerse. This one shows how from UNIX and UniVerse but I need UNIX and Unidata. My Enviroment on UniData versus UniVerse. 1- I 'm trying to follow the UNIX/UniVerse part of it and I will translate all uv(uvhome vs udhome, uvlibs vs udlibs, ext...) I wanted to now the following: a- Needs UniRpc and I have UniRpc running in AIX/UniData. root:/:# psgrep rpc Search for rpc... UID PIDPPID CSTIMETTY TIME CMD daemon 98438 86376 0 Apr 22 - 0:00 /usr/sbin/rpc.statd root 1622126 1 0 Jun 04 - 0:01 /ud/unishared/unirpc/unirpcd root 102792 86376 0 Apr 22 - 0:00 /usr/sbin/rpc.lockd b- Needs to run relink.uvlibs and I I have relink.udlibs? It shows that it requires for UniVerse to be re-started? Question: 1- Not sure if I should execute the relink.udlibs If UniRpc is already running?, See My Enviroment #1. c- Needs a file called UVodbc.config configured but I do NOT have a file called UDodbc.config? Question: 2- 2- I found ALL of this files under $UDTHOME: root:/:# find ./ -name '*odbc*' -print|more ./ud/bin/lib.d/uddlls/libodbc.a ./ud/bin/lib.d/uddlls/odbc.so ./ud/bin/lib/uddlls/libodbc.a ./ud/bin/lib/uddlls/odbc.so ./ud/lib/uddlls/libodbc.a ./ud/lib/uddlls/odbc.so ./.odbc.ini ?? INVALID IP Address, could have been by predecessor trying to setup UniData ODBC at one point? root:/:# cat ./.odbc.ini [MySQL-test] Description = MySQL test database Trace = Off TraceFile = stderr Driver = MySQL SERVER = 192.168.1.26 USER= pharvey PASSWORD= PORT= 3306 DATABASE= test [PostgreSQL] Description = PostgreSQL driver for Linux Win32 Driver = /usr/local/lib/libodbcpsql.so Setup = /usr/local/lib/libodbcpsqlS.s 3- Talks about using UniAdmin or the UV account for data source creation but the UniAdmin for the ud/sys for UniData does not have this feature? Question: 4- What is the equivalent setup of the data source for UniData? TIA and Cheers fellow groupies. Angelo, [EMAIL PROTECTED] Angelo Do you mean ODBC from UniData (BCI) or into UniData (UniODBC?) For BCI, check the (new) knowledge base at: www.mvopen.org/kb/ There is an article on there Accessing SQL Data through BCI. This takes you through the steps and there is demo data/programs available. For ODBC, I have a similar article - but I can't post it yet! (I'm still waiting for the official publication before I'm allowed to do that). But if you email me offlist I can send you a copy. Brian After searching the archive and to no avail, I would like to know if anyone has a sample working program or (BCI.DEMO) working that could share a copy of it. Cheers, Angelo --- u2-users mailing list
RE: [U2] FW: [UV] Change in behaviour of EXECUTE ... CAPTURING at 10.1.18 {Unclassified}
Mike,
I assume you've already tried it, but does a simple NOPAGE on the RetrieVe
command work?
Otherwise I guess XMLEXECUTE is probably the best bet, as that is likely to
be the quickest to get fixed if there IS anything wrong! It is also a key
part of the UO.net stuff, so there is a lot of pressure there to get that
right.
This sounds like someone complained that an XML listing DIDN'T page break
when they expected it to...
The XML stuff is new enough that I would expect some changes, but to pick up
on Kate's point, it does worry me when older, standard functionality
changes. Why are IBM even looking at that code? There are plenty
'undocumented' features (often inherited features) that people have used,
and it just takes some helpful programmer to think they are cleaning it up
to break vital systems...
Brian
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
HENDERSON MIKE, MR
Sent: 07 June 2006 23:46
To: u2-users@listserver.u2ug.org
Subject: [U2] FW: [UV] Change in behaviour of EXECUTE ...
CAPTURING at 10.1.18 {Unclassified}
Folks,
We have been using EXECUTE RetrieVe statement that generates an XML
output CAPTURING STUFF to generate XML statements in STUFF. We then
pass the XML to a BizTalk server to update a number of other
systems from our UniVerse system. This is done from a
Trigger program when certain files change.
This has worked fine on 10.0.15, but since I upgraded the
Development server to 10.1.18, the STUFF variable gets a 'page feed'
ESC[HESC[J inserted every 24 lines. Not unreasonably,
this upsets the MS XML parser in BizTalk!
Note that this is a new feature, it never happened on 10.0.15.
Does anyone know why this happens?
- maybe I missed a uv.config file change in the upgrade?
- maybe this is an exciting 10.1.x 'new feature' [AKA 'bug']?
I know that changing the terminal page depth works, but the
TERM verb is not allowed in Transaction State, and a Trigger
is always in Transaction State.
Unless there's a config change I can make, I can see three
ways of fixing this quickly:
1)fiddling the TERM verb options in the VOC to allow it in
Transaction State
Nasty, will probably work, may have unexpected side-effects
2)Filter the STUFF variable to catch and discard these lines
Crude, may increase the trigger running time
significantly, but will work
3)Upgrade the program to use the brand-new-in-10.1 XMLEXECUTE
verb.
Documentation is sparse to non-existent, except for
what the list has already found for me.
Not sure I want to be that 'bleeding edge' for this
important production application.
And then of course, there's always
4)Upgrade again to 10.1.pick a number, the bug has been found
and fixed
Help!
Thanks
Mike
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
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
[U2] UDT Sequential File Length
All, Is there a simple way of getting the size of a file opened sequentially under UniData short of actually reading though it in BASIC ? Something equivalent to using the Status statement on UniVerse? Must be OS neutral - no shelling out to ls or DIR I'm afraid. Thanks Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] IBM U2 UniData ODBC sample working program
Angelo One of my friends at VMARK UK has unearthed a couple of IBM articles on setting up ODBC with UniData on UNIX: one for Merant and one for EasySoft. I'll forward these to you off-list. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Angelo Collazo Sent: 07 June 2006 16:37 To: u2-users@listserver.u2ug.org Cc: Matt Varghese; Angelo Collazo; [EMAIL PROTECTED]; Ron Schile Subject: RE: [U2] IBM U2 UniData ODBC sample working program Hello fellow groupies, After downloading the document called Accessing SQL Data through BCI, the example is from U2 under Windows. It talks about U2 under UNIX but it requires additional steps on how setup up ODBC because it is not native to UNIX. I have found a .pdf file on the IBM website called Basic SQL client Interface Guide for UniVerse. This one shows how from UNIX and UniVerse but I need UNIX and Unidata. My Enviroment on UniData versus UniVerse. 1- I 'm trying to follow the UNIX/UniVerse part of it and I will translate all uv(uvhome vs udhome, uvlibs vs udlibs, ext...) I wanted to now the following: a- Needs UniRpc and I have UniRpc running in AIX/UniData. root:/:# psgrep rpc Search for rpc... UID PIDPPID CSTIMETTY TIME CMD daemon 98438 86376 0 Apr 22 - 0:00 /usr/sbin/rpc.statd root 1622126 1 0 Jun 04 - 0:01 /ud/unishared/unirpc/unirpcd root 102792 86376 0 Apr 22 - 0:00 /usr/sbin/rpc.lockd b- Needs to run relink.uvlibs and I I have relink.udlibs? It shows that it requires for UniVerse to be re-started? Question: 1- Not sure if I should execute the relink.udlibs If UniRpc is already running?, See My Enviroment #1. c- Needs a file called UVodbc.config configured but I do NOT have a file called UDodbc.config? Question: 2- 2- I found ALL of this files under $UDTHOME: root:/:# find ./ -name '*odbc*' -print|more ./ud/bin/lib.d/uddlls/libodbc.a ./ud/bin/lib.d/uddlls/odbc.so ./ud/bin/lib/uddlls/libodbc.a ./ud/bin/lib/uddlls/odbc.so ./ud/lib/uddlls/libodbc.a ./ud/lib/uddlls/odbc.so ./.odbc.ini ?? INVALID IP Address, could have been by predecessor trying to setup UniData ODBC at one point? root:/:# cat ./.odbc.ini [MySQL-test] Description = MySQL test database Trace = Off TraceFile = stderr Driver = MySQL SERVER = 192.168.1.26 USER= pharvey PASSWORD= PORT= 3306 DATABASE= test [PostgreSQL] Description = PostgreSQL driver for Linux Win32 Driver = /usr/local/lib/libodbcpsql.so Setup = /usr/local/lib/libodbcpsqlS.s 3- Talks about using UniAdmin or the UV account for data source creation but the UniAdmin for the ud/sys for UniData does not have this feature? Question: 4- What is the equivalent setup of the data source for UniData? TIA and Cheers fellow groupies. Angelo, [EMAIL PROTECTED] Angelo Do you mean ODBC from UniData (BCI) or into UniData (UniODBC?) For BCI, check the (new) knowledge base at: www.mvopen.org/kb/ There is an article on there Accessing SQL Data through BCI. This takes you through the steps and there is demo data/programs available. For ODBC, I have a similar article - but I can't post it yet! (I'm still waiting for the official publication before I'm allowed to do that). But if you email me offlist I can send you a copy. Brian After searching the archive and to no avail, I would like to know if anyone has a sample working program or (BCI.DEMO) working that could share a copy of it. Cheers, Angelo --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] ODBC question
Hi, While we're talking Unidata ODBC... I'm having trouble getting UNIDATA ODBC working here. Server is Tru64 Unix. Client is windows. UCI seems to be set up correctly. I can access the data and create views, etc with VSG. But, when I try to import or link to the data from Access or Excel, I get the following error: The ODBC screen pops up with most of the parameters filled in, except my password. I put in the password (and yes, I've tried it a million times and the password is correct!) and an error pop-up says: [Ardent][Unidata ODBC Driver][IBM][SQL Client][UNIDATA]Server is not authorized Anyone have any suggestions? Dana Baron System Manager Smugglers' Notch Resort --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] Simulation/performance testing tools
Greetings, Actually the mainstream desktop testing tools work remarkably well with U2 products. Especially Redback if you mean load testing your web page. There are products out there from the sublime to the ridiculous -- from shareware to very high end. How elaborate you want to be has to do with how much verification you want to be able to do. If you want to be able to script reads to the database to see if files are being updated correctly and calculations performed and so forth then get one with a powerful scripting language. If you just want to load test simulate a lot of users hitting a web-site there are loads of tools out there that will do it and it doesn't matter that it's Redback/U2 at the backend. A place to find loads of advise about software quality and testing, including reviews and links to various tools is at stickyminds.com. Cheers, Susan Joslyn Date: Tue, 6 Jun 2006 08:23:25 -0400 From: Andy Pflueger [EMAIL PROTECTED] Subject: [U2] [UD] Simulation/performance testing tools Hi, Anyone know of any good simulation/performance testing tools out there for the U2 and application server products (e.g. RedBack)? We are looking for some possible tools to try and simulate running 150-200 user processes to test the performance load of our Sun box(es). Thanks, Andy Pflueger Ivy Hill - Louisville --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UDT Sequential File Length
Brian, I use OPENSEQ, READSEQ and WRITESEQ if needed. Hope this helps Cheers, Angelo All, Is there a simple way of getting the size of a file opened sequentially under UniData short of actually reading though it in BASIC ? Something equivalent to using the Status statement on UniVerse? Must be OS neutral - no shelling out to ls or DIR I'm afraid. Thanks Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ODBC question
Do you have a license to use ODBC? Or Is your UniData licensed? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dana Baron Sent: Thursday, June 08, 2006 8:11 AM To: U2-Users Subject: [U2] ODBC question Hi, While we're talking Unidata ODBC... I'm having trouble getting UNIDATA ODBC working here. Server is Tru64 Unix. Client is windows. UCI seems to be set up correctly. I can access the data and create views, etc with VSG. But, when I try to import or link to the data from Access or Excel, I get the following error: The ODBC screen pops up with most of the parameters filled in, except my password. I put in the password (and yes, I've tried it a million times and the password is correct!) and an error pop-up says: [Ardent][Unidata ODBC Driver][IBM][SQL Client][UNIDATA]Server is not authorized Anyone have any suggestions? Dana Baron System Manager Smugglers' Notch Resort --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UDT Sequential File Length
I don't have access right now, but will FILEINFO do any good for you? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Angelo Collazo Sent: Thursday, June 08, 2006 7:02 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UDT Sequential File Length Brian, I use OPENSEQ, READSEQ and WRITESEQ if needed. Hope this helps Cheers, Angelo All, Is there a simple way of getting the size of a file opened sequentially under UniData short of actually reading though it in BASIC ? Something equivalent to using the Status statement on UniVerse? Must be OS neutral - no shelling out to ls or DIR I'm afraid. Thanks Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ODBC question
Hi Marc, Good question. Yes we have licenses for both Unidata and ODBC, however, our server crashed hard a few months ago and I had to re-install Unidata (and just about everything else). I haven't tried using ODBC since then. It could be that the ODBC license wasn't re-installed correctly. Dana Baron System Manager Smugglers' Notch Resort -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson Sent: Thursday, June 08, 2006 8:08 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] ODBC question Do you have a license to use ODBC? Or Is your UniData licensed? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dana Baron Sent: Thursday, June 08, 2006 8:11 AM To: U2-Users Subject: [U2] ODBC question Hi, While we're talking Unidata ODBC... I'm having trouble getting UNIDATA ODBC working here. Server is Tru64 Unix. Client is windows. UCI seems to be set up correctly. I can access the data and create views, etc with VSG. But, when I try to import or link to the data from Access or Excel, I get the following error: The ODBC screen pops up with most of the parameters filled in, except my password. I put in the password (and yes, I've tried it a million times and the password is correct!) and an error pop-up says: [Ardent][Unidata ODBC Driver][IBM][SQL Client][UNIDATA]Server is not authorized Anyone have any suggestions? Dana Baron System Manager Smugglers' Notch Resort --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] ODBC question
Hi, While we're talking Unidata ODBC... I'm having trouble getting UNIDATA ODBC working here. Server is Tru64 Unix. Client is windows. UCI seems to be set up correctly. I can access the data and create views, etc with VSG. But, when I try to import or link to the data from Access or Excel, I get the following error: The ODBC screen pops up with most of the parameters filled in, except my password. I put in the password (and yes, I've tried it a million times and the password is correct!) and an error pop-up says: [Ardent][Unidata ODBC Driver][IBM][SQL Client][UNIDATA]Server is not authorized Anyone have any suggestions? Dana Baron System Manager Smugglers' Notch Resort --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ODBC question
What version of UD are you running? Does version show it as licensed? Try a new password, I've had trouble with passwords that unusual characters, including basic punctuation marks. A long time ago, I also needed to get an updated .dll from IBM. That was early in the 5? Days. Hopefully, your system isn't that outdated. Hth Colin Alfke Calgary, Canada -Original Message- From: Dana Baron Hi, While we're talking Unidata ODBC... I'm having trouble getting UNIDATA ODBC working here. Server is Tru64 Unix. Client is windows. UCI seems to be set up correctly. I can access the data and create views, etc with VSG. But, when I try to import or link to the data from Access or Excel, I get the following error: The ODBC screen pops up with most of the parameters filled in, except my password. I put in the password (and yes, I've tried it a million times and the password is correct!) and an error pop-up says: [Ardent][Unidata ODBC Driver][IBM][SQL Client][UNIDATA]Server is not authorized Anyone have any suggestions? Dana Baron --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] Inhibiting Access to Debugger
Perry: What about the ON.ABORT phrase in the (VOC)? Combined with user management, which I'm sure you've already built, this should do the trick. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Perry Taylor Sent: Wednesday, June 07, 2006 7:52 AM To: u2-users@listserver.u2ug.org Cc: Chris Schremser; Robin Harrison Subject: [U2][UV] Inhibiting Access to Debugger Does anyone know of a way to prohibit selected users in an account from gaining access to the debugger while still allowing all users to break out of the application? Thanks. Perry Taylor Zirmed, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UDT Sequential File Length
What about using DIR()? I thought there was something in FILE.INFO - but it does not appear to be in there. You could try parsing FILE.STAT. Hth Colin Alfke Calgary, Canada -Original Message- From: Brian Leach All, Is there a simple way of getting the size of a file opened sequentially under UniData short of actually reading though it in BASIC ? Something equivalent to using the Status statement on UniVerse? Must be OS neutral - no shelling out to ls or DIR I'm afraid. Thanks Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniDebugger
Two months ago I was trying to update a program, using UniDebugger, on a remote server using the Disk Read/Write method and couldn't because the Unidata server directory has a minimal amount of security. I was able, however, to update the program using the UniObjects Read/Write method by entering the server name and credentials. Today, this no longer works. When I try to edit a program on the remote UniData server, using UniObjects, I get an Unable to connnect to the host (39207) error. I know UniObjects is installed and set up properly because I have mv.NET installed and can connect to the remote UniData server via UniObjects using the exact same credentials (server name, username, and password) I'm attempting to use in UniDebugger. I've uninstalled and reinstalled UniDebugger. This didn't help. Does anyone know what could be causing this problem? Bill Haskett Advantos Systems, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniData performance problems
We have had ongoing intermittent performance issues with InfoLease for many months now. Recently the problems have become worse, especially at monthend. Users and customers are complaining and we're out of ideas. I'm hoping someone can point us in a direction that will get us to the root cause. I won't go into all the details, but here is some information on what we're seeing and what we've done. Application: InfoLease O/S: AIX 5.2.0.0 DB version: UniData 6.0.8 Disk: EMC HW: IBM P670 with two LPARs. One for production, the second cloned nightly for reporting. * Both online and batch processing/reporting have taken a dive at various times. Isssues used to be primarily a day or two before and after monthend, but we're creeping farther into the month as time goes on. * Slowness only affects InfoLease activity. Shell activity seems unaffected. * EMC (disk) tells us we are nowhere near taxing their system and read/write response times are in the 5-8 ms range * At the same time EMC says we're fine, AIX (filemon) indicate significant read/write waits * Nmon regularly indicates a high number of CPU waits, but I've never been able to map that back to user experience * When we experience slowdowns we may/may not be able to pinpoint a process or group of processes causing the problem. * Resizing seems to have pretty much resolved our batch processing but hasn't helped online activity. Udtmon still shows a surprising amount over Overflow 2 activity. We're investigating, so maybe we have more work to do there. Does anyone know what a system in overflow 2 looks like to the O/S? Maybe a higher number of reads? It seems as if there is a bottleneck that noone can identify. Aside from periodic AIX read/write waits nothing shows any problems. TIA Brad Schrag InfoLease Development -- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. == --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UDT Sequential File Length
UniBasic DIR() function - SIZE=DIR(FILEPATH)1 -- Brian Leach [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] All, Is there a simple way of getting the size of a file opened sequentially under UniData short of actually reading though it in BASIC ? Something equivalent to using the Status statement on UniVerse? Must be OS neutral - no shelling out to ls or DIR I'm afraid. Thanks Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData performance problems
Brad, Others will undoubtedly talk about file sizing issues. We had a problem where we had some jobs locking up to 30,000 records where the system was geared to handle, maybe, scores or hundreds of locks. Jobs that should have taken a minute, or less, were taking hours. I wrote a program to count the lines in a captured LIST.READU so that I would know how bad the problem was. In this case we had upgraded to a newer version of vendor supplied software which had a new locking strategy in inventory that affected job costing. This ran into a non-standard trick where we used inventory to track certain costs. We did make some helpful system changes to accommodate the larger number of locks but we solved the greatest part of the problem by making procedural changes. Karjala -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, June 07, 2006 4:07 PM To: u2-users@listserver.u2ug.org Subject: [U2] UniData performance problems We have had ongoing intermittent performance issues with InfoLease for many months now. Recently the problems have become worse, especially at monthend. Users and customers are complaining and we're out of ideas. I'm hoping someone can point us in a direction that will get us to the root cause. I won't go into all the details, but here is some information on what we're seeing and what we've done. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniData performance problems
[EMAIL PROTECTED] wrote on 06/07/2006 04:07:09 PM: * Resizing seems to have pretty much resolved our batch processing but hasn't helped online activity. Udtmon still shows a surprising amount over Overflow 2 activity. We're investigating, so maybe we have more work to do there. Does anyone know what a system in overflow 2 looks like to the O/S? Maybe a higher number of reads? It seems as if there is a bottleneck that noone can identify. Aside from periodic AIX read/write waits nothing shows any problems. Level 2 overflow will most likely manifest itself in terms of additional I/O requests at the O/S level. Look at the heavy hitters list in filemon. If there's a file at the top of the list, and the number of reads seems high, check sizing on that file. You say that batch processing is OK but interactive users are experiencing performance problems. Is this constant or intermittent? I wouldn't be surprised to hear that some users experience long delays while others fly through. Does the wait queue (see sar -q or topas) show high values? I would look at random write-behind and maybe high- and low-water marks for possible relief. There could be a complex combination of events - at the database and/or AIX levels - converging to create these problems. Shameless plug alert! You may want to have somebody perform a detailed health check of your system. I may just know of somebody who could help you out with this. ;-) Tim Snyder Consulting I/T Specialist , U2 Professional Services North American Lab Services DB2 Information Management, IBM Software Group 717-545-6403 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData performance problems
What does sar say about your wait i/o? On Solaris, I use sar -u. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Wednesday, June 07, 2006 3:07 PM To: u2-users@listserver.u2ug.org Subject: [U2] UniData performance problems We have had ongoing intermittent performance issues with InfoLease for many months now. Recently the problems have become worse, especially at monthend. Users and customers are complaining and we're out of ideas. I'm hoping someone can point us in a direction that will get us to the root cause. I won't go into all the details, but here is some information on what we're seeing and what we've done. Application: InfoLease O/S: AIX 5.2.0.0 DB version: UniData 6.0.8 Disk: EMC HW: IBM P670 with two LPARs. One for production, the second cloned nightly for reporting. * Both online and batch processing/reporting have taken a dive at various times. Isssues used to be primarily a day or two before and after monthend, but we're creeping farther into the month as time goes on. * Slowness only affects InfoLease activity. Shell activity seems unaffected. * EMC (disk) tells us we are nowhere near taxing their system and read/write response times are in the 5-8 ms range * At the same time EMC says we're fine, AIX (filemon) indicate significant read/write waits * Nmon regularly indicates a high number of CPU waits, but I've never been able to map that back to user experience * When we experience slowdowns we may/may not be able to pinpoint a process or group of processes causing the problem. * Resizing seems to have pretty much resolved our batch processing but hasn't helped online activity. Udtmon still shows a surprising amount over Overflow 2 activity. We're investigating, so maybe we have more work to do there. Does anyone know what a system in overflow 2 looks like to the O/S? Maybe a higher number of reads? It seems as if there is a bottleneck that noone can identify. Aside from periodic AIX read/write waits nothing shows any problems. TIA Brad Schrag InfoLease Development -- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. == --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] U2 on Rails?
I'm writing all my business logic using Ruby on Rails. I've investigated writing a Rails database adapter for UniVerse but it doesn't look like it will be easy. I don't know UniVerse well (only been using it for a couple of weeks) but from what I see so far, UniVerse is not fully SQL compliant and AFAIK, portions of the SQL that is generated comes from user code (e.g. conditions specified using the LIKE clause) expect the underlying SQL dialect to be somewhat standard. If UniVerse is SQL92 compatible, then I think it's doable given some time, effort and motivation. FWIW, I'm using a Java API to create a web service that I can then call from my Rails application. If it is possible to connect via SOAP directly to Rails, that would be a help. My target environment is a production database that I would not be allowed to create new 'stored procedures' in. I think that the UniVerse SOAP functionality requires writing a new stored procedure in BASIC. So I can't take that route. Please correct me if I'm wrong here. -- G. On Jun 5, 2006, at 10:02 PM, Wendy Smoak wrote: Is anyone else interested in Rails? http://www.rubyonrails.org/ For me, it's fun to play with, but I figured the chances of it ever talking to UniData were slim to none. Then again... http://alphaworks.ibm.com/tech/db2onrails Maybe we will see U2 on Rails one day. :) -- Wendy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniObjects for Java + GLOBUS (UniVerse) = UniVerse license expired!?
Dear List: I am trying to extract data from a GLOBUS application (which runs atop U2). I'm using the UniObjects for Java API to connect to the database. When I use the right username/password, instead of connecting, it tells me that the UniVerse license has expired. asjava.uniobjects.UniSessionException: The user name provided is incorrect at asjava.uniobjects.UniSession.connectInternal (UniSession.java:336) at asjava.uniobjects.UniSession.connect(UniSession.java:364) at asjava.uniobjects.UniSession.connect(UniSession.java:448) If the account is wrong, it tells me ... asjava.uniobjects.UniSessionException: The directory does not exist, or is not a UniVerse account at asjava.uniobjects.UniSession.connectInternal (UniSession.java:278) at asjava.uniobjects.UniSession.connect(UniSession.java:364) at asjava.uniobjects.UniSession.connect(UniSession.java:448) Here's the backtrace for when the username/password/account are all correct ... asjava.uniobjects.UniSessionException: The UniVerse license has expired at asjava.uniobjects.UniSession.connectInternal (UniSession.java:336) at asjava.uniobjects.UniSession.connect(UniSession.java:364) at asjava.uniobjects.UniSession.connect(UniSession.java:448) If I try to connect using a secure connection, it says ... asjava.uniobjects.UniSessionException: No RPC Connection active. at asjava.uniobjects.UniSession.connectInternal (UniSession.java:339) at asjava.uniobjects.UniSession.connect(UniSession.java:364) at asjava.uniobjects.UniSession.connect(UniSession.java:448) Using uvregen -c, it tells me that the license is valid for xyz number of users and that it will expire on 1/1/2500 (or something similar). Also, connecting via telnet from the same machine, using the same values for account/username/password works! Any ideas? Do I have to resort to screen scraping a telnet session? Any help or response at all would be greatly appreciated! -- G. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData performance problems
A few things come to mind: 1. Is the slowdown for the interactive users a general slowdown thought the business day, or only at specific points in time? 2. Do you experience any udt sessions that are run aways (that is, zombie sessions?) 3. How many users? What kind of locking activity? 4. What is the I/O activity that you are seeing across the adapters (through nmon)? These are items that indicate a need for an overall system assessment ... the issue could well be related to the environment ... and it could be related to the work load and timing of events throughout the day (most likely, a combination of both). You may want to consider an outside assessment of your overall system performance, both from the AIX and from the UniData on AIX perspectives. --- Regards, Robert -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, June 07, 2006 15:07 To: u2-users@listserver.u2ug.org Subject: [U2] UniData performance problems We have had ongoing intermittent performance issues with InfoLease for many months now. Recently the problems have become worse, especially at monthend. Users and customers are complaining and we're out of ideas. I'm hoping someone can point us in a direction that will get us to the root cause. I won't go into all the details, but here is some information on what we're seeing and what we've done. Application: InfoLease O/S: AIX 5.2.0.0 DB version: UniData 6.0.8 Disk: EMC HW: IBM P670 with two LPARs. One for production, the second cloned nightly for reporting. * Both online and batch processing/reporting have taken a dive at various times. Isssues used to be primarily a day or two before and after monthend, but we're creeping farther into the month as time goes on. * Slowness only affects InfoLease activity. Shell activity seems unaffected. * EMC (disk) tells us we are nowhere near taxing their system and read/write response times are in the 5-8 ms range * At the same time EMC says we're fine, AIX (filemon) indicate significant read/write waits * Nmon regularly indicates a high number of CPU waits, but I've never been able to map that back to user experience * When we experience slowdowns we may/may not be able to pinpoint a process or group of processes causing the problem. * Resizing seems to have pretty much resolved our batch processing but hasn't helped online activity. Udtmon still shows a surprising amount over Overflow 2 activity. We're investigating, so maybe we have more work to do there. Does anyone know what a system in overflow 2 looks like to the O/S? Maybe a higher number of reads? It seems as if there is a bottleneck that noone can identify. Aside from periodic AIX read/write waits nothing shows any problems. TIA Brad Schrag InfoLease Development -- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. == --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe Jav
u2logic is ok, but it doesn't color syntax:( and you have to have uv.account for user, so it's useless if you have one uv.account, for example in Globus implementation. Maybe something else is avaiable? 2006/5/30, D Averch [EMAIL PROTECTED]: If you are using Eclipse you can get a free plug-in Editor for Universe and Unidata from our web site at www.u2logic.com. In the following weeks we will have announcements on our new products that are using Eclipse that run in the U2 environment. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Dzikiewicz Sent: Tuesday, May 30, 2006 8:24 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe Java Thanks for the suggestions on the IDE's. I am downloading all that were mentioned to see which one will suite me best. Anthony --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe Java
Unfortunately, when you do a free product not every need can be accommodated within the first 6 months of it's release. Hopefully around the end of July, the U2Editor with support color syntax (maybe snippets, as well) and Outline format. The Outline format allows you to see all the internal GOSUB'S in a separate screen (Java editor's do this) and can click on those names and the U2Editor will take you to that section of the code. Any other features you would like to add please contact us at [EMAIL PROTECTED] and will try to get those suggestion implemented. Regards, Doug BTW: U2Editor does require a Universe/Unidata account because we are using UniObjects to get the data. However, you can use other Eclipse plug-ins to edit JavaScript, HTML, Java, or PHP. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lukasz s Sent: Thursday, June 08, 2006 11:13 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe Jav u2logic is ok, but it doesn't color syntax:( and you have to have uv.account for user, so it's useless if you have one uv.account, for example in Globus implementation. Maybe something else is avaiable? 2006/5/30, D Averch [EMAIL PROTECTED]: If you are using Eclipse you can get a free plug-in Editor for Universe and Unidata from our web site at www.u2logic.com. In the following weeks we will have announcements on our new products that are using Eclipse that run in the U2 environment. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Dzikiewicz Sent: Tuesday, May 30, 2006 8:24 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe Java Thanks for the suggestions on the IDE's. I am downloading all that were mentioned to see which one will suite me best. Anthony --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniObjects for Java + GLOBUS (UniVerse) = UniVerse license expired!?
Guido Sohne wrote: I am trying to extract data from a GLOBUS application (which runs atop U2). I'm using the UniObjects for Java API to connect to the database. When I use the right username/password, instead of connecting, it tells me that the UniVerse license has expired. What version of UV are you on? IIRC, when we were on 9.5.1 we had to buy an additional license to make use of the unirpc service. It became included with the primary UV license at some point. I think you might still need to activate the included unirpc license separately, though, but I could be wrong. It's been a while since I installed UV. Whatever the issue turns out to be, however, UOJ is a fairly common way of connecting to U2, and you shouldn't need to resort to screen scraping a telnet session. -John -- John Hester System Network Administrator Momentum Group Inc. (949) 833-8886 x623 http://memosamples.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData performance problems
Yes; you would see an increased number of disk accesses at the os level, both I and O, with significant level 2 overflow. This would also affect locks; if I set a lock, the longer it takes me to find it, process it, and write it back, the longer the lock is held. If it takes me a few dozen reads to get the whole group, that can be a very significant delay. But if a high percentage of the file is even just barely into level 2, that doubles the i/o latency. So you may be on to something there, but if that (resizing) doesn't do it, the variables are legion. I can tell you that I've worked with Tim Snyder in the past, and would not hesitate to call on him again in the future if the need arises. Our greatest duty in this life is to help others. And please, if you can't help them, could you at least not hurt them? - H.H. the Dalai Lama When buying selling are controlled by legislation, the first thing to be bought sold are the legislators - P.J. O'Rourke Dan Fitzgerald -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, June 07, 2006 15:07 To: u2-users@listserver.u2ug.org Subject: [U2] UniData performance problems We have had ongoing intermittent performance issues with InfoLease for many months now. Recently the problems have become worse, especially at monthend. Users and customers are complaining and we're out of ideas. I'm hoping someone can point us in a direction that will get us to the root cause. I won't go into all the details, but here is some information on what we're seeing and what we've done. Application: InfoLease O/S: AIX 5.2.0.0 DB version: UniData 6.0.8 Disk: EMC HW: IBM P670 with two LPARs. One for production, the second cloned nightly for reporting. * Both online and batch processing/reporting have taken a dive at various times. Isssues used to be primarily a day or two before and after monthend, but we're creeping farther into the month as time goes on. * Slowness only affects InfoLease activity. Shell activity seems unaffected. * EMC (disk) tells us we are nowhere near taxing their system and read/write response times are in the 5-8 ms range * At the same time EMC says we're fine, AIX (filemon) indicate significant read/write waits * Nmon regularly indicates a high number of CPU waits, but I've never been able to map that back to user experience * When we experience slowdowns we may/may not be able to pinpoint a process or group of processes causing the problem. * Resizing seems to have pretty much resolved our batch processing but hasn't helped online activity. Udtmon still shows a surprising amount over Overflow 2 activity. We're investigating, so maybe we have more work to do there. Does anyone know what a system in overflow 2 looks like to the O/S? Maybe a higher number of reads? It seems as if there is a bottleneck that noone can identify. Aside from periodic AIX read/write waits nothing shows any problems. TIA Brad Schrag InfoLease Development -- Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. == --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 on Rails?
Hi Guido I don't know UniVerse well (only been using it for a couple of weeks) but from what I see so far, UniVerse is not fully SQL compliant and AFAIK, portions of the SQL that is generated comes from user code (e.g. conditions specified using the LIKE clause) expect the underlying SQL dialect to be somewhat standard. UniVerse SOAP functionality requires writing a new stored procedure in BASIC. So I can't take that route. Universe is SQL92 Compliant and you can have 2 Query options, SQL or Retrieve. The upcoming SOAP functionality enables you to call an SQL Statement, a Retrieve Statement or a Basic program. Do not be reluctant to use the stored procedures. It is fairly easy to learn and very powerful compared to facilities in other products Regards David Jordan Managing Consultant --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV] Printer page breaks
There was a thread just yesterday (or the day before) about this, and it got me thinking... I've inherited code that has THREE different methods of suppressing the 'press a key to continue' after each 24 lines are printed. All three methods seem to work, but I wonder if anyone can tell me if these methods really do the exact same thing: junk = @(0) assign 0 to system(1016) assign 0 to system(2005) TIA, Barry Brevik --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] SETPTR MODE 1
I have been looking at Universe in PICK flavour on Windows. Does anyone know where the output goes with setptr mode 1 and HOLD. (I have always used mode 3) Is it accessible in basic with a file read. where is the SPOOL - LIST job description data kept and can i access this in basic It seems like there is a gui front end for spooler management under unix but not in windows I would like to be able to come up with something that works with either if thats possible. jak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] SETPTR MODE 1
Goo'day, John, At 09:52 09/06/06 +1000, you wrote: I have been looking at Universe in PICK flavour on Windows. Does anyone know where the output goes with setptr mode 1 and HOLD. (I have always used mode 3) file name = HOLD Every report creates a new item Is it accessible in basic with a file read. It's a file - go for it where is the SPOOL - LIST job description data kept and can i access this in basic It seems like there is a gui front end for spooler management under unix but not in windows I would like to be able to come up with something that works with either if thats possible. jak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.1.394 / Virus Database: 268.8.3/359 - Release Date: 08/06/06 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.394 / Virus Database: 268.8.3/359 - Release Date: 08/06/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] SETPTR MODE 1
OOPS! Sorry! Misread the question At 09:52 09/06/06 +1000, you wrote: I have been looking at Universe in PICK flavour on Windows. Does anyone know where the output goes with setptr mode 1 and HOLD. (I have always used mode 3) It's available/spoolable from the Windows printers environment. AFAIK, it's only a temporary file... I'd be tempted to look in the Temp directory Is it accessible in basic with a file read. where is the SPOOL - LIST job description data kept and can i access this in basic It seems like there is a gui front end for spooler management under unix but not in windows I would like to be able to come up with something that works with either if thats possible. jak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.1.394 / Virus Database: 268.8.3/359 - Release Date: 08/06/06 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.394 / Virus Database: 268.8.3/359 - Release Date: 08/06/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] SETPTR MODE 1
Chris, aha found it. But how does one read the shd file ? This look like where the job description etc SPOOL -LIST uses on windows So i am guessing there is a way to read this and define the data delimiters jak - Original Message - From: Chris Day [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, June 09, 2006 11:38 AM Subject: RE: [U2] SETPTR MODE 1 Hi John, On windows if you use the HOLD keyword on the SETPTR statement, the resulting print job will end up in the spooler directory of the system. On my XP based system this directory is WINDOWS\system32\spool\PRINTERS There will be two files, one being a control file and the other being the actual print job. Hope that this helps Chris Day Technical Pre-Sales Specialist Meier Business Systems Melbourne * Sydney * Kuala Lumpur * Singapore -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Kent Sent: Friday, 9 June 2006 9:52 AM To: U2Users Subject: [U2] SETPTR MODE 1 I have been looking at Universe in PICK flavour on Windows. Does anyone know where the output goes with setptr mode 1 and HOLD. (I have always used mode 3) Is it accessible in basic with a file read. where is the SPOOL - LIST job description data kept and can i access this in basic It seems like there is a gui front end for spooler management under unix but not in windows I would like to be able to come up with something that works with either if thats possible. jak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ CAUTION: This email and any attachments are confidential, may be privileged, and are intended for use solely by the addressee. The confidentiality and/or privilege in this email is not waived, lost or destroyed if it has been transmitted to you in error. If you receive this email in error, please notify MBS by reply email immediately, delete the email and destroy any printed copies. You must not disclose, disseminate, distribute, reproduce or use the information contained in this email if you are not the intended recipient. The content and opinions contained in this email are those of the individual sender and may not necessarily reflect the views and opinions of MBS. MBS does not guarantee that this email is free from viruses, errors, interception or interference. Use of this email and any attachments is at the sole risk of the user. MBS does not accept any liability for any loss or damage to your computer system or network (including any consequential damage) which may occ! ur directly or indirectly from the use of this email. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.8.3/359 - Release Date: 8/06/2006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SETPTR MODE 1
Hi John, Good that you have found where the print files are located on the system. Unfortunately, I have not tried to read the details contained in the .shd file at all, but someone else on the list may be able to assist with this. Chris Day Technical Pre-Sales Specialist Meier Business Systems Melbourne * Sydney * Kuala Lumpur * Singapore -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Kent Sent: Friday, 9 June 2006 12:31 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] SETPTR MODE 1 Chris, aha found it. But how does one read the shd file ? This look like where the job description etc SPOOL -LIST uses on windows So i am guessing there is a way to read this and define the data delimiters jak - Original Message - From: Chris Day [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, June 09, 2006 11:38 AM Subject: RE: [U2] SETPTR MODE 1 Hi John, On windows if you use the HOLD keyword on the SETPTR statement, the resulting print job will end up in the spooler directory of the system. On my XP based system this directory is WINDOWS\system32\spool\PRINTERS There will be two files, one being a control file and the other being the actual print job. Hope that this helps Chris Day Technical Pre-Sales Specialist Meier Business Systems Melbourne * Sydney * Kuala Lumpur * Singapore -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Kent Sent: Friday, 9 June 2006 9:52 AM To: U2Users Subject: [U2] SETPTR MODE 1 I have been looking at Universe in PICK flavour on Windows. Does anyone know where the output goes with setptr mode 1 and HOLD. (I have always used mode 3) Is it accessible in basic with a file read. where is the SPOOL - LIST job description data kept and can i access this in basic It seems like there is a gui front end for spooler management under unix but not in windows I would like to be able to come up with something that works with either if thats possible. jak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ CAUTION: This email and any attachments are confidential, may be privileged, and are intended for use solely by the addressee. The confidentiality and/or privilege in this email is not waived, lost or destroyed if it has been transmitted to you in error. If you receive this email in error, please notify MBS by reply email immediately, delete the email and destroy any printed copies. You must not disclose, disseminate, distribute, reproduce or use the information contained in this email if you are not the intended recipient. The content and opinions contained in this email are those of the individual sender and may not necessarily reflect the views and opinions of MBS. MBS does not guarantee that this email is free from viruses, errors, interception or interference. Use of this email and any attachments is at the sole risk of the user. MBS does not accept any liability for any loss or damage to your computer system or network (including any consequential damage) which may occ! ur directly or indirectly from the use of this email. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] Inhibiting Access to Debugger
Compile with the -I option. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] FW: [UV] Change in behaviour of EXECUTE ... CAPTURING at 10.1.18 {Unclassified}
Is is possible that your default print channel on the old version had NFMT as one of its options, and the one on the new version does not (so that UniVerse is inserting a new page every @CRTHIGH lines)? Just a thought. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
