[U2] [UV] WHILE READNEXT id DO
LOOP code WHILE READNEXT id DO more code REPEAT This format of the READNEXT statement is used in a couple of places in the UniVerse BASIC manual. It looks like READNEXT is returning a Boolean. If I look up READNEXT in the manual (or in HELP from TCL) - there is no mention of this format of the statement. And in the manual the THEN and ELSE are enclosed in braces: {THEN statements [ELSE statements] | ELSE statements} which according to convention means that I have to choose one non-optional item. Has this format of the statement just been left out of the manual by mistake or is it a new format, that was never documented. And, what are people's thoughts on using this format. Personally I dislike it, as it isn't easily readable, it's not documented and it's not a standard use of the statement syntax. AdrianW Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] inserting European format dates using SQL
I'm trying to insert a record using SQL from a VB app. The problem is that it assumes the date field is in American format. I'd prefer to specify the date in European format. We always use a single D as the conversion code for all date fields in dictionaries and our LOGIN paragraphs always run DATE.FORMAT, so dates in our UV applications are always formatted correctly ;-) Does anyone know how I make the external SQL accept the date in European format? AdrianW Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Convert Statement Not Working
Check out the CHANGE function instead. CONVERT is a character by character conversion function, it's changing to in your example. Try: LINE = CHANGE(LINE, , amp;) AdrianW -Original Message- From: Morawa, Hans [mailto:[EMAIL PROTECTED] Sent: Wednesday, 9 June 2004 16:42 To: [EMAIL PROTECTED] Subject: [U2] Convert Statement Not Working I'm writing a basic routine to generate XML files and running into a problem. The following CONVERT statement does work, CONVERT TO amp; IN LINE Does anyone know what's happening here. We are on UniVerse Release 10.1.0 on a HPUX. Thanks, Hans --- This email and any files transmitted with it are confidential to the intended recipient and may be privileged. If you have received this email inadvertently or you are not the intended recipient, you may not disseminate, distribute, copy or in any way rely on it. Further, you should notify the sender immediately and delete the email from your computer. Whilst we have taken precautions to alert us to the presence of computer viruses, we cannot guarantee that this email and any files transmitted with it are free from such viruses. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV] SELECTINDEX inside a user conversion subroutine is corruptin g the record count
We have a user conversion code (named UOPNN) which we use in the conversion field of dictionaries to convert an operator number into an operator name. Our operators (ie. users) control file is keyed on name with an AK on number. The UOPNN routine uses SELECTINDEX on the operator file using the number to obtain the name. The SELECTINDEX statement is selecting to list 8, therefore not affecting the default list (0). If I list a file with the SAMPLE keyword, displaying a field which uses the conversion code - then 10 records will be listed, BUT the final line displayed is Sample of 1 records listed. instead of Sample of 10 records listed. The number displayed (ie. 1) is dependant on the number of records that the final SELECTINDEX returns, which, to me, indicates that SELECTINDEX is overwriting some internal counter variable. I added a CRT of @SELECTED and @SYSTEM.RETURN.CODE to the conversion routine and neither of these are altered by the SELECTINDEX. This looks like it may be a bug in Universe as I'm pretty sure we didn't have this problem under PI/Open. Does anyone have any suggestions of a way around this problem? (We're on UV 10.0.19) -- Adrian Womack RAC Group of WA Perth WA Australia Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV] CONVERT.SQL (UV files SQL tables)
* Note: I'm resending this posting as after almost 3 hours my first attempt still hasn't appeared back in my inbox. -- Our UniVerse files on our production unix box all have permissions set so owner and group both have read write access. Our users are all locked into menus and can only access the files via the application programs. I would like to make one of these files accessible (SELECT only) to the outside world via SQL. If I use CONVERT.SQL to convert the file into a table and then use GRANT to set connect select access to a specific user, that user can then connect perform SQL selects on the file. BUT - the rest of our users can no longer access the file via regular UniVerse commands (LIST statements, BASIC reads and writes, etc). It looks like I would have to GRANT connect, select, update, delete insert on the table to EVERY regular UniVerse user just so they can continue to access this file normally. Is there a better (ie. easier) way to achieve this? Am I doing something wrong? I suppose I could make a copy of the file in question which would only be used via SQL, but that would present further complications. AdrianW Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV] CONVERT.SQL (UV files -v- SQL tables)
Our UniVerse files on our production unix box all have permissions set so owner and group both have read write access. Our users are all locked into menus and can only access the files via the application programs. I would like to make one of these files accessible (SELECT only) to the outside world via SQL. If I use CONVERT.SQL to convert the file into a table and then use GRANT to set connect select access to a specific user, that user can then connect perform SQL selects on the file. BUT - the rest of our users can no longer access the file via regular UniVerse commands (LIST statements, BASIC reads and writes, etc). It looks like I would have to GRANT connect, select, update, delete insert on the table to EVERY regular UniVerse user just so they can continue to access this file normally. Is there a better (ie. easier) way to achieve this? Am I doing something wrong? I suppose I could make a copy of the file in question which would only be used via SQL, but that would present further complications. AdrianW Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Companies going belly up converting from PICK/MV
At 01:04 19/05/04, you wrote: The Alert Centre, Englewood CO USA, 1993 - 1996 The Alert Centre (yes they really spelled it that way) What? Something wrong with correct spelling, now? ~8^)) Maybe he was talking about Centre being spelt the English way instead of the American way Center considering that the company was in the US. Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] [UV] File handles in arrays
Not a chance. A dynamic array is really just a string (with delimiters). A file variable has to be stored in a real variable. Why do you have a problem with using a matrix, it's more efficient than a dynamic array anyway. -Original Message- From: Barry Brevik [mailto:[EMAIL PROTECTED] Sent: Thursday, 13 May 2004 08:01 To: [EMAIL PROTECTED] Subject: [U2] [UV] File handles in arrays Is it not possible to store a file handle in a dynamic array? This seems to work: DIM FILE.HANDLES(10) OPEN '','PARTS' TO FILE.HANDLES(1) ELSE PRINT 'noopen' READ THIS.REC FROM FILE.HANDLES(1), '1900-90' ELSE PRINT 'noread' ...but I'd rather use dynamic arrays. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] PHANTOM forever
We have many phantoms doing various stuff in the background. We're running Universe (and previously PI/Open) and we have to do nothing special to get these phantom processes to keep running when the parent process is logged out. All we do is the standard PHANTOM program.id. Maybe under UniData there's a problem with the parent logging out - but not under UniVerse. AdrianW -Original Message- From: Sara Burns [mailto:[EMAIL PROTECTED] Sent: Tuesday, 4 May 2004 09:19 To: U2 List ([EMAIL PROTECTED]) Subject: RE: [U2] PHANTOM forever We discovered this problem with our phantom which sends data to Oracle. We have developed a double stage method to disconnect it from the user. Initially we write the command to launch the phantom to a file - we call ours SCRIPTS, which contains the command of the structure echo program name | /uv/bin/uv ./\PH\/name of log file in PH) 21 Then we have an item in the VOC which contains SH -c 'full path to the item in SCRIPTS' Our initialisation program writes the entry in SCRIPTS then executes the item in the VOC. In the past we extended this to be able to run multiple phantoms doing the same job. Improved hardware means we don't need multiples now. This was originally developed using UniData and we have since ported it to UniVerse. It works well. Sara Burns (SEB) Development Team Leader Public Trust Phone: +64 (04) 474-3841 (DDI) Mobile: 027 457 5974 mailto:[EMAIL PROTECTED] Information contained in this communication is confidential. If you are not the intended recipient the information should not be used, disclosed, copied or commercialised. The information is not necessarily the views nor the official communication of Public Trust. No guarantee or representation is made that the communication is free of errors, virus or interference. Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users