Re: [U2] Self Deadlatch error on device 655372, inode 610205, group 11460608, latch 80000 to WRITE.
Hi Usually, it occurs when a index key is based on a subr or trigger and the subr re-read the current updated record or another one stored on the same group. manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Ken Ford Envoyé : lundi 3 février 2014 03:26 À : 'u2-users@listserver.u2ug.org' Objet : [U2] Self Deadlatch error on device 655372, inode 610205, group 11460608, latch 8 to WRITE. We are getting the error in the subject line in a 3rdParty program (no sourcecode). We have recreated the file, resized the file and rebuilt its secondary indices, and still get the error. There is a group lock when it occurs. A search of the archives has not produced anything useful. Any ideas would be appreciated. Thanks. Ken Ford Firstmac Ltd Brisbane QLD Australia --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] uvbackup and uvrestore
Hi Anna, UVBACKUP will read uvfiles's records one by one and push it into a device or stdout. Your command do not create a backup, it performs a integrity control of uv files. Details of your options : -v = verbose -f = full (not incremental) -notag = do not switch the uvbackup flag of records -l = label of the job is Co %DAY % -cmdfil = do the job for uvfiles listed into %Pdir%\bin\COPY\list _ % SAVE %.txt -s = log the verbosity into %Pdir %\bin\COPY\LOG _ % SAVE %.txt -t = sent the data into the device named nul . (do nothing) 2 nul = echo the errors to 2nul (do nothing) The good command to perform a uvrestore'able uvbackup must be : uvbackup -v -f -notag -cmdfil %Pdir%\bin\COPY\list _ %SAVE%.txt -s %Pdir%\bin\COPY\LOG _ %SAVE%.txt -l Co %DAY% %Pdir%\bin\COPY\list _ %SAVE%.uvb Then you'll receive files %Pdir%\bin\COPY\%SAVE%.uvb recoverable with uvbackup %Pdir%\bin\COPY\LOG _ %SAVE%.txt where you can read the log of uvbackup I hope this help. manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Anna Envoyé : lundi 7 octobre 2013 22:56 À : u2-users@listserver.u2ug.org Objet : [U2] uvbackup and uvrestore Hi, I am new here, abouts between one of my new tasks it is to take charge of a computer with Universe, with Open Suse, that I leave another company of service. Of universe do not know anything, for what I have seen at least safety copies are done in a file copia.bk. I have not even idea if other day I have to restore the safety copy, someone can help me. The command that does the copy is this: %uvdir %\bin\UVBACKUP-v-f-notag-l Co %DAY % -cmdfil %Pdir %\bin\COPY\list _ % SAVE %.txt-s %Pdir %\bin\COPY\LOG _ % SAVE %.txt-t nul 2 nul thank you ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Select from one file with save-list from another file
hi, like the same post from a few month, use direct access to btree indexfile (type 25) you can do it like this : 1) add a index on Y.INFO:PACKET.ID (create.index + build.index) 2) set a VOC entry to the btree file I_Y.INFO/INDEX.000 (000 can be different) ED VOC YINFO.PACKETID 001 F 002 I_Y.INFO/INDEX.000 003 D_VOC 3) do your select on X.INFO + SAVING PACKET.ID . in memory you have PACKETID list 4) retrieve Y.INFO id's via btree direct access ; in memory you get Y.INFO id's using QSELECT on Y.INFO sample: SELECT X.INFO WITH DOB SAVING {UNIQUE} PACKET.ID QSELECT YINFO.PACKETID i hope this help Manu Hilk, Brandon brandon.h...@iqor.com a écrit : Thanks everyone, I've got some usable info to work with. Sorry if my original post was a bit vague, let me illustrate to clarify: X.INFO @PACKET.ID.NAME..DOB...STATUS 52781456.52781456..DOE, JOHN.06-17-1985CCC Y.INFO @BILL.DAY..BILL.AMT..TYPE..PACKET.ID 52781456*MPA*2...08/28/201350MPA...52781456 Hopefully showing a rough table structure helps me better convey what I was trying to do. Using criteria in X.INFO to create a selection list and then using that list to select and export information from Y.INFO like BILL.DAY and BILL.AMT that wasn't available in X.INFO. Since a select list made from X.INFO would have different record ID's, it wouldn't be able to be used to select from Y.INFO. Hence, me looking for some trickery to use Y.INFO's PACKET.ID field as the array for the select list to work against. Brandon -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On 8/27/2013 1:24 PM, Hilk, Brandon wrote: Hello! UniVerse 10.1, HP/UX, Pick. Is there a way I can build a save-list from a selection from one file X.INFO (where the record ID is an 8 digit number) and use that list to select from file Y.INFO (where that 8 digit number is not the record ID but does exist as a foreign key elsewhere in the file). In SQL this would be considered a join and would look something like this: select * from X.INFO, Y.INFO where X.INFO.packet.id=Y.INFO.packet.id and X.INFO.status='ccc'; I can run this in TCL and have it return the results I want but can't build a save-list from it because I don't know the UniVerse/SQL syntax to do so. So to summarize, is there a way to use a save-list built from X.INFO to make another save-list comprised of the record ID's from Y.INFO? Thanks for any advice you can give. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] TU.SQL.CONNECT
HI, TU.SQL.* are part of SB+/SBClient Utilities (Termulator Utilities) to interface SQL server via ODBC connection defined on the client. SBClient are the gateway between ODBC server request. On client, you define ODBC connection; like for excel or other. On server you have TU.SQL.* subrtoutine to call to interface it. TU.SQL.CONNECT : open the odbc relationship ; return a odbcconn handle TU.SQL.DISCONNECT : close it :-) TU.SQL.EXEC : submit a sql statement TU.SQL.READ : do a fetch from the last EXEC result set ; you get one sql result line into on dynamicarray TU.SQL.MAKEDICT : will create DICTionaries defn from a SQL TABLE You can found all details and samples in SBClient Programmer Reference from Rocket Software (https://docs.rocketsoftware.com/nxt/gateway.dll/RKB14/sbxa/622/client_prog.pdf chapter 6 ODBC connectivity) Very helpfull if you can't set SQL conn from U2Server side. manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Israel, John R. Envoyé : jeudi 22 août 2013 14:14 À : U2 Users List Objet : [U2] TU.SQL.CONNECT Does anyone have any experience using the TU.SQL.CONNECT command to connect to a Microsoft Sequel database? I am not finding any on-line docs and the OLD book I am using is not very helpful. JRI ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Type 30 files modified when LISTed? (UV 10.0.2)
hi, When uv open a T30, it's header is loaded into uv's shared memory (until all user session which adress the file terminate), ready for writing. File is open for writing, I suppose some header info are updated at open time. Manu George Gallen ggal...@wyanokegroup.com a écrit : If I LIST a Type 30 file, Then execute a ls -la FILENAME it shows the last time DATA.30 portion was modified was when I did the LIST. Why would a LIST modify the date/time stamp that a file was modified? The OVER.30 wasn't changed at this point. George ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] and the Hebrew character set
hi jacques, I'll add some elements.Here in Luxemburg, we use french german languages then I have some experience with extended characters. To store the extended chars, if you choose codepage OEM862 or Windows-1255 , you work on single byte coding the both don't re-define chars 252,253,254 then no-prob with sv'ed, mv'ed data. Regarding sortorder, yes, use Right justification. For display, your client must works with a compatible codepage font and communication must be set to 8 bits. For printing, your printers must known the codepage font. If you choose unicode, you must turn Universe/NLS on. At basic runtime, UV works as unicode multi-byte (reread your basic code regarding chars manipulations) then be carefull to understand there is only one language declaration per file/device - when possible use unicode. Problems start when you need display hebrew, french or russian chars on the same screen and a non-unicode client ! my two pence Manu Jacques G. jacque...@yahoo.com a écrit : Hello, Has anyone here ever used Universe with a Hebrew character set ? Is it neccessary to to with a full 16-bit Unicode character set or are there older 8-bit character sets that are useable ? Also since text is apparently read from right to left (like in arabic) how are sorts affected ? (Must dictionnary elements be changed from left justified to right justified ?) Jacques G. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] and the Hebrew character set
hum, Regarding sortorder, yes you can use Right justification if the byte value of chars into codepage are ordered like the hebrew alphabet elsewhere you need to build a re-ordered string via subr!! Like in french the chars éèêàâ are converted to eeea in a subr to make a correct sortorder. simple SUBROUTINE FLAT;FRENCH(RESULT,STRING) RESULT = STRING CONVERT CHAR(130):CHAR(136):CHAR(138) TO EEE IN RESULT RETURN Manu Jacques G. jacque...@yahoo.com a écrit : Hello, Has anyone here ever used Universe with a Hebrew character set ? Is it neccessary to to with a full 16-bit Unicode character set or are there older 8-bit character sets that are useable ? Also since text is apparently read from right to left (like in arabic) how are sorts affected ? (Must dictionnary elements be changed from left justified to right justified ?) Jacques G. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] sbclient and multi-language
yes, we use it with french, dutch, german, english, ... translation. please, what's your question ? Manu Fingerle, Julius juliusfinge...@daytonsuperior.com a écrit : Hello group – has anyone implemented the multi-language feature of system builder? I’d like to call and discuss. Thx Julius Fingerle Dayton Superior Corp Julius Fingerle Senior ERP Developer Dayton Superior Corporation 1125 Byers Rd Miamisburg, OH 45342 Office: 937-866-0711 x44304 Fax: 937-847-8473 juliusfinge...@daytonsuperior.com Your feedback builds a better experience. We want to hear from you. Please call Dayton Superior Customer Care at 855-602-3722 (855-602-DSCC) or go to daytonsuperior.com/customercarehttp://daytonsuperior.com/customercare, leave your feedback and you could win a new iPad. This message w/attachments (message) is intended solely for the use of the intended recipient(s) and may contain information that is privileged, confidential or proprietary. If you are not an intended recipient, please notify the sender, and then please delete and destroy all copies and attachments, and be advised that any review or dissemination of, or the taking of any action in reliance on, the information contained in or attached to this message is prohibited. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Writing into metadata
Hi, We use ImageMagick (http://www.imagemagick.org/) ; It provides OS command line to read / write picture properties ; and many other tools for image manipulation. Check identify -verbose picturefilename then parse what you need ; or use escapes (http://www.imagemagick.org/script/escape.php) to pick elements. Free, Available on win / linux Manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Susan Joslyn Envoyé : mardi 11 juin 2013 12:53 À : u2-users@listserver.u2ug.org Objet : [U2] Writing into metadata Hi everyone, Does any one know how to use a unibasic program to write into the metadata of a .jpg file in windows? Or to read, rename and write that file? If someone knows how to do it with a windows tool I'm game, but I've looked into some that require me to learn a lot of new skills that I cannot invest in for this particular little project. Appreciate any thoughts or ideas. Susan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Signature Capture and use
hi, Regarding os which manage the capture : Signature pad (MS-windows- .Net tool ) ; tablet-screen smatphone-screen (androïd- java; iOS - oC) Then signature is received by uv then converted to base64 for storage; then converted to .png for display on screen ; then converted to EPS to include into postscript form; then create job for printer or convert the form to pdf for sharing. We store png into uv via basic encode(base64) function which produce text format. We use ImageMagic package to perform : - image convertion from shell command line ; - add text, logo, ... to the image/signature (name of the owner, reference of the transaction, ...) - add information into exif internal data ; (name of the owner, reference of the transaction, ...) my 2 pence. Manu Oaks, Harold harold.o...@clark.wa.gov a écrit : I'm sure some of you are implementing signature pad capture to a Universe system. What are you using and doing? I'd like to look into adding that feature to our jail system. Thanks- Harold Oaks Clark County, WA This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] UniObjects.Net vs Thrid-party Products
HI, Just for enlarge the question. On the U2 side, we choose to develop and expose web-services ; RESTful format, From now, our .Net, j-script, java, androïd, ...Thrid-party app call htpp to request U2. Then we work as a team of U2 devs and third-party devs or designer ... the best on each sides. My two pence. Manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Perry Taylor Envoyé : mardi 28 mai 2013 01:45 À : U2-Users List Objet : [U2] [UV] UniObjects.Net vs Thrid-party Products I'm investigating the pros and cons to using UniObjects.Net vs third-party products such as MV.Net, etc. Anyone care to chime in with your experiences? Thanks. Perry Taylor Senior MV Architect ZirMed 888 West Market Street, Suite 400 Louisville, KY 40202 www.zirmed.comhttp://www.zirmed.com/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 demos and sample code now on Github
Hi Dan, Without doubt about Github quality, I have just a question. Why dont you extend u2devzone/accelerate ? Regards Manu Daniel McGrath dmcgr...@rocketsoftware.com a écrit : I thought I should share this with you all. It's been in the works for a while and still a 'work in progress'. Let us know what you think. http://blog.rocketsoftware.com/2013/05/u2-samples-now-on-github/ Cheers, Dan McGrath Managing Director, U2 Servers Lab Rocket Software ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] select query..
Hi Do you have wildcard characters like [] into KEYVALUE ? If not, why do you SELECT ; it's the key of file.name ; you can read directly ! Elsewhere, For performance, set a index on the @id Why do you want to use save-list/get-list ? You can work on LIST1 directly ! manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Sathya Envoyé : mercredi 15 mai 2013 11:45 À : u2-users@listserver.u2ug.org Objet : [U2] select query.. Hi Experts.. I have one issue here with fetching data from the file. EXECLINE = SELECT FILE.NAME WITH @ID = \:KEYVALUE:\ DISPLAY EXECLINE EXECUTE EXECLINE RTNLIST LIST1 EXECUTE 'SAVE-LIST SOME.LIST' PASSLIST LIST1 LIST.NAME = GET-LIST SOME.LIST sellist = '' EXECUTE LIST.NAME RTNLIST sellist CAPTURING junk Here Im running a loop for a set of KEYVALUEs and for each run the SSELECT statement is taking around 30 seconds. When I want to run 1000 loops, ideally the run time will be much. Is there any easier way to do this with less time consumption. Thanks Regards, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] select query..
Hi Sathya, Clearly, in basic, if you know the unique-key of a record, you don't need to select it to access its data. Do it like this : OPEN FILE.NAME TO F.FILE.NAME ELSE ... error ... KEYVALUE = READ V.RECORD FROM F.FILE.NAME, KEYVALUE THEN * OK RECORD EXIST ; V.RECORD IS LOADED WITH DATA END ELSE * KO RECORD DOESN'T EXIST ! V.RECORD IS NOT MODIFIED V.RECORD = '' END Do what you need with V.RECORD -- Now if the value you have is not the unique-key ; you need to execute a select. Do like this : OPEN FILE.NAME TO F.FILE.NAME ELSE ... error ... DATAVALUE =. .. EXECUTE 'SELECT FILE.NAME WITH FIELD.NAME = ':DATAVALUE:'' RTNLIST LIST1 LOOP WHILE READNEXT KEYVALUE DO READ V.RECORD FROM F.FILE.NAME,KEYVALUE THEN * OK RECORD EXIST END ELSE * KO RECORD DOEN'T EXIST CONTINUE ;* GOTO NEXT READNEXT END Do what you need with V.RECORD REPEAT By extension, You can create index à secondary-key declaration like this : At TCL,do like this (with users logged out) CREATE.INDEX FILE.NAME FIELD.NAME NO.NULLS BUILD.INDEX FILE.NAME FIELD.NAME If exist, Universe SELECT use automatically the index system - I hope this help. Manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Sathya Envoyé : mercredi 15 mai 2013 13:19 À : u2-users@listserver.u2ug.org Objet : Re: [U2] select query.. Manu Fernandes efv at infodata.lu writes: Hi Do you have wildcard characters like [] into KEYVALUE ? If not, why do you SELECT ; it's the key of file.name ; you can read directly ! Elsewhere, For performance, set a index on the at id Why do you want to use save-list/get-list ? You can work on LIST1 directly ! manu Hi Fernandes, Thanks for your comments. But as Im new to this technology Im not sure how to proceed with your suggestions. Can u please be more specific on this approach? There is no [] symbols in the KEYVALUE. How do I check whether @ID is indexed? I will modify it with using LIST1 directly. Thanks Regards, Sathya V. Hi Experts.. I have one issue here with fetching data from the file. EXECLINE = SELECT FILE.NAME WITH at ID = \:KEYVALUE:\ DISPLAY EXECLINE EXECUTE EXECLINE RTNLIST LIST1 EXECUTE 'SAVE-LIST SOME.LIST' PASSLIST LIST1 LIST.NAME = GET-LIST SOME.LIST sellist = '' EXECUTE LIST.NAME RTNLIST sellist CAPTURING junk Here Im running a loop for a set of KEYVALUEs and for each run the SSELECT statement is taking around 30 seconds. When I want to run 1000 loops, ideally the run time will be much. Is there any easier way to do this with less time consumption. Thanks Regards, Sathya V. ___ ://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users at listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] select query..
Erratum, LOOP WHILE READNEXT KEYVALUE FROM LIST1 DO -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Manu Fernandes Envoyé : mercredi 15 mai 2013 21:10 À : U2 Users List Objet : Re: [U2] select query.. Hi Sathya, Clearly, in basic, if you know the unique-key of a record, you don't need to select it to access its data. Do it like this : OPEN FILE.NAME TO F.FILE.NAME ELSE ... error ... KEYVALUE = READ V.RECORD FROM F.FILE.NAME, KEYVALUE THEN * OK RECORD EXIST ; V.RECORD IS LOADED WITH DATA END ELSE * KO RECORD DOESN'T EXIST ! V.RECORD IS NOT MODIFIED V.RECORD = '' END Do what you need with V.RECORD -- Now if the value you have is not the unique-key ; you need to execute a select. Do like this : OPEN FILE.NAME TO F.FILE.NAME ELSE ... error ... DATAVALUE =. .. EXECUTE 'SELECT FILE.NAME WITH FIELD.NAME = ':DATAVALUE:'' RTNLIST LIST1 LOOP WHILE READNEXT KEYVALUE DO READ V.RECORD FROM F.FILE.NAME,KEYVALUE THEN * OK RECORD EXIST END ELSE * KO RECORD DOEN'T EXIST CONTINUE ;* GOTO NEXT READNEXT END Do what you need with V.RECORD REPEAT By extension, You can create index à secondary-key declaration like this : At TCL,do like this (with users logged out) CREATE.INDEX FILE.NAME FIELD.NAME NO.NULLS BUILD.INDEX FILE.NAME FIELD.NAME If exist, Universe SELECT use automatically the index system - I hope this help. Manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Sathya Envoyé : mercredi 15 mai 2013 13:19 À : u2-users@listserver.u2ug.org Objet : Re: [U2] select query.. Manu Fernandes efv at infodata.lu writes: Hi Do you have wildcard characters like [] into KEYVALUE ? If not, why do you SELECT ; it's the key of file.name ; you can read directly ! Elsewhere, For performance, set a index on the at id Why do you want to use save-list/get-list ? You can work on LIST1 directly ! manu Hi Fernandes, Thanks for your comments. But as Im new to this technology Im not sure how to proceed with your suggestions. Can u please be more specific on this approach? There is no [] symbols in the KEYVALUE. How do I check whether @ID is indexed? I will modify it with using LIST1 directly. Thanks Regards, Sathya V. Hi Experts.. I have one issue here with fetching data from the file. EXECLINE = SELECT FILE.NAME WITH at ID = \:KEYVALUE:\ DISPLAY EXECLINE EXECUTE EXECLINE RTNLIST LIST1 EXECUTE 'SAVE-LIST SOME.LIST' PASSLIST LIST1 LIST.NAME = GET-LIST SOME.LIST sellist = '' EXECUTE LIST.NAME RTNLIST sellist CAPTURING junk Here Im running a loop for a set of KEYVALUEs and for each run the SSELECT statement is taking around 30 seconds. When I want to run 1000 loops, ideally the run time will be much. Is there any easier way to do this with less time consumption. Thanks Regards, Sathya V. ___ ://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users at listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB and Printers
Hi susan, After defining the sbprinter into /ADMIN Printers Term Printer Mng Physical Prn Defn You must start it into /ADMIN Printers Term Printer Mng Maintain Printers Then you add the sb physical printer in the table. Then f2. !! on UV/unix, At f2, SB+ will try to add the printer on sp.config and restart uvspoold via usa commands. You must be root to add a sbprinter. !! on UV/Windows, there is no uvspoold ; but you need to add your sb+printers into the list. (not sure about the sb's actions on Udt/ux~win) SB+ store the table into DMSECURITY PRINTERS.STARTED ; the list of started printers ... SB Print Manager use it to check if the printer is started. I hope this help Manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Susan Joslyn Envoyé : mardi 7 mai 2013 17:19 À : sjos...@sjplus.com; u2-users@listserver.u2ug.org Objet : Re: [U2] SB and Printers Hi everyone, I have not used the printer admin parts of SB very much. I have a customer trying to set up printers in SB but when he runs a report (/ARD type) and uses 'P' to go to the printer he gets this message about the printer not being 'started'. Anyone know what step we missed? Screen shot below if you can see it. Basically it's the SB Print Manager window, then centered on the bottom row 'THIS PRINTER IS NOT STARTED'. Susan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help needed..
Hi, For fun : EXECUTE QSELECT UFD tabdelimitedname LOOP WHILE READNEXT LINE DO K = FIELD(LINE, ,1) ... REPEAT manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Allen Egerton Envoyé : mardi 30 avril 2013 17:57 À : U2 Users List Objet : Re: [U2] Help needed.. On 4/30/2013 11:21 AM, Sathya wrote: Hi all,.. I have a requirement here. Need guidance in doing that. Any help will be useful. TIA. I have a flat file with tab delimited records and the file looks like below: abcd 1234 cdef 3478 ghae 6284 ... I have to fetch the data 'abcd' and 'cdef' from this flat file and fetch some corresponding attributes from a file which has 'abcd' and 'cdef' as the key values. Please let me know if this could be done. If yes any kinda basic suggestions in doing that will be helpful. Lots of ways to solve this problem, here's a very quick and dirty untested piece of code written off the top of my head... PROMPT EQUATE TABCHAR TO CHAR(7) * OPEN , UFD TO F.UFD ELSE STOP CAN'T OPEN UFD READ D.UFD FROM F.UFD, xxx.tabdelimitedname ELSE CRT Can't read tab- delimited file from current directory STOP END OPEN , OTHERFILE TO F.OTHER ELSE CRT Can't open OTHERFILE file to retrieve data from STOP END REM1 = 999 LOOP WHILE REM1 NE 0 REMOVE LINE FROM D.UFD SETTING REM1 K.OTHER = FIELD(LINE, TABCHAR, 1) READ D.OTHER FROM F.OTHER, K.OTHER THEN ONE = D.OTHER1 TWO = D.OTHER2 do something with the fields... END ELSE CRT Cant' read record : K.OTHER: from OTHERFILE. END REPEAT * CRT DONE STOP -- Allen Egerton; aeger...@pobox.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] RESIZE INPLACE
Hi, Given the risk of manipulating a file of this size, I recommend the use of distributed files (DEFINE.DF). Just as effective, if not better, each part file is administered individually (backups, resizing, indexing, !accessing, locking,...) Procedure : 1 - analyse the keys to build a distribution algorythm ; at worst use hashing algorythm ; don't forget a elsewhere partnumber (1 ) 2 - create part files (define how many, size, ..., by analysing number key-records, time growing ,...) 3 - define distributed file ; DICT adress the original DICT 4 - copy all record from orig.file to df.file (do it one time before live to check if all keys can be processed by your algorythm) 5 - edit VOC orig.file to adress df.file as data file 6 - resize all part file individually. 7 - delete the orig.DATA file index from os ; to get back your 144gb My two pence manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Perry Taylor Envoyé : jeudi 25 avril 2013 22:10 À : U2-Users List Objet : [U2] [UV] RESIZE INPLACE Before I go and resize a 144GB file has anyone had any experiences with the INPLACE option of RESIZE in UniVerse? Good, bad, ugly??? Thanks. Perry Perry Taylor Senior MV Architect ZirMed 888 West Market Street, Suite 400 Louisville, KY 40202 www.zirmed.comhttp://www.zirmed.com/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] What tools do you use for data warehouse...
Hi, We use a in-house ETL which is based on DICT independant table/column definition. The user interface to define table/column is a SB+ app ; easy to use. At first, you define you tables and columns to be created/loaded into your dw ; each table are linked to one datafile and in case of mv/sv'ed; linked to a controling field (mv/sv) Next, you define each column by setting their sql properties, the source of the value (attribute number or sb+.expression) ; the human label of the column ; with it you can create transformed data. (by default you can retrieve the dictionnaries) here a screen sample : http://wiki.infodata.lu/lib/exe/fetch.php?media=public/etl/etl_dw_defn1.png With these table/columns definition, the system build sql-stmt to create the table into the dw and load the data into the table via insert / loadinto ,... After what, the ETL send the sql-stmt to the dw. The sql-stmts are build from sql dialect-templates then , we can adress all SQL dbms After what, you can define datamarts ; as a set of tables, and request immediate or, via crontab/taskmanager, sheduled refreshing processus of one/* datamart For more details, send me a mail. manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Tom Whitmore Envoyé : vendredi 26 avril 2013 19:50 À : U2 Users List Objet : [U2] What tools do you use for data warehouse... Hi, I was wondering what tools you use to export data to an SQL data warehouse from UniVerse. This export could occur on multiple flavors of Unix. What we would need to do is extract the UV data and perform some data translations before importing the data into the SQL table. I know at one point DataStage was a powerful but expensive tool that would accomplish this task. All suggestions are greatly appreciated! Tom Whitmore RATEX Business Solutions ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] uvbackup linux command line - multiple specific files
hey, Another method, put the list of files to backup into a textfile, use the -cmdfil param of uvbackup cmd. Manu Perry Taylor perry.tay...@zirmed.com a écrit : cd to the directory where the files live then... find -maxdepth 1 -name 'BUY.[ST]MF*' -print | uvbackup Should get 'em. Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Wednesday, April 17, 2013 1:51 PM To: U2-Users@listserver.u2ug.org Subject: [U2] uvbackup linux command line - multiple specific files Unix 'find' is failing me and I have not found documentation on specifically what I'm trying to do. I need to use uvbackup from the command line to back up 4 specific Universe files to one archive so they can be restored to a different platform without all the fnuxi stuff. I need to pick up the following files only. ./BUY.SMF ./BUY.TMF ./BUY.SMF.LAST ./BUY.TMF.FIND Help me Mr. uvbackupWizard! -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] uvuidlog.txt - who is parent error codes
Hi u2Masters, On a UV/NT, we receive a file uvtemp\uvuidlog.txt filled with errors like : - Wed Mar 20 22:18:08 2013 pid = 10088 lookup_name() failed. Error = 122 - Sat Jul 11 23:05:20 2009 pid = 6088 NetGetDCName() failed. Error = 997 I found nothing about this file ! - who is the producer ? - any idea where I can found doc about error codes ? Thanks for any help. manu ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How do you print a .pdf from inside a Unix Box
hi Bruce, on 'ux, we use ghostscript http://ghostscript.com/doc/current/Use.htm Manu Bruce Conway - Bamac LTD bconw...@cinci.rr.com a écrit : I may have missed this discussion but if someone can help me that would be great. We have been executing a SB command to windows to open Adobe and print the PDF document. We would like to either not have to open Adobe and print the document or print the document from within our Unix box. We have a hp7640 11iv3 running on an Itanium processor. Here is the Unidata information: Module Name Version Licensed UniData RDBMS 7.2 Yes Connection Pooling... 7.2 No Device License... 7.2 No NFA.. 7.2 No RFS.. 7.2 No EDA.. 7.2 No 721 Oh, love this list, I have been using Pick since 1985 and still going strong. Bruce ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV Retrieve] Selecting file based on partial key
hi peter, I suggest this : 1) build a indexfile based on ACC_NBR 2) set a VOC file pointer directly on the index file FILENAME.INDEX0 F I__FILENAME/INDEX.000 (or other physical filename) for selection 3) GET.LIST ACC_LIST 4) QSELECT FILENAME.INDEX0 the active select list is the content of FILENAME.INDEX0 ... the keys you need I hope this help manu Manu Peter Cheney peter.che...@firstmac.com.au a écrit : Dear U2 List, Is the below at all possible in universe retrieve please? I didn't think it was but there're a lot more clever people out there than I plus it's been too long since I was doing this regularly and cannot remember if it is or not. I cannot see anything obvious in the manuals. We have a file in a production environment with 5477108 records whose @ID/Key are all '9-digit-account-number':'4-digit-sequence-number'. Q. Is it possible to obtain a list of @ID's based on a separate saved list of '9-digit-account-number'? The remaining record fields are all out of scope for the selection apart from an internal date in attribute 4 but that can be interrogated later. Is it possible to construct a kind of reverse select based on my existing saved-list and pass this data into a dict item for the account number? I've tried numerous permutations of this but have yet to find the answer. Or can I do something lie an sql SELECT FILENAME WHERE ACC_NBR = 'GET-LIST ACC_LIST'? How is this done on a (live) normal type 18 UV file? Of course I can always whip up some basic code to do this but it is production and getting it there will take a while. (and no I didn't design the file layout ...) Many thanks in advance. Regards, Peter --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UV win 2008 Workgroup - ED / COPY very slow
Hi group, Using Universe 11.1.9 on win2008/workgroup logged as Administrator, I get a perf trouble when using ED, COPY, BUILD.INDEX, the process use 10 seconds to start. After look inside, I detect each one use uv's subroutine -PERMISSIONS which seems check the user's write right on the file to update. The execution of these subr (non documented) use 10 seconds. I suspect a security/rights problem but where ? Any suggestions ? Thanks Manu Fernandes ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Advantage of indirect call in BASIC
hi, These method is very usefull when you build software like a lego, some pieces are polymorphic, the assignment of source depens of environment, params at runtime not only at compile time... the value of soure can be assigned from litteral, but also read from file or be the result of a text expression. sample : if you run a software on mutiple plateform, unix and windows, UV, UD, D3, ...; to adress OS and third part software, the final syntax is different but the main() can call source with no difference, you an createa a new variation of source() with no change on the main(). sample : send a e-mail : depending of OS, smpt, relaying, it can be 20 differents method/tools to send a mail but the elements of it (from,to,subjet,body,attachment) are always the same. With the indirect call, you can define wich is the local method to send a mail and never touch the main(). two pence. Manu Wjhonson wjhon...@aol.com a écrit : I've not encountered this is my career previously, but now I'm seeing a system written almost entirely with the use of indirect calls in Universe BASIC. That is SOURCE = *SOME.PROGRAM ... CALL @SOURCE(INPUTS) Is there some advantage to the use of indirect calls that a system would be written entirely in this fashion? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UPLOAD not DOWNLOAD
hi John, Depending what you are looking for, - a generic ETL tool where you define 1) Extract data from a defineable source (remote sql, csv-xls-dbf-xml-json files, webservice result , ...) with extendable method 2) Transform the received clob to internal UV data representation (iconv, mv'ed representation, build multi-part unique key, ...) 3) Load into U2 files (update one or more uvfiles into a Transaction (db transaction + application transaction)) That's not a routine that's complex tool with a lot of params and subroutines :-p I have it, writen in SB+, require SB+ at runtime, but it's not free. Please let me know if you can be interested. - - Anyway, If you search routines to import, write one record on one uvfile per received record, from some specific data source I'm ready to share my experience (sql, dbf, csv, mdb, xls, xml, ...). Please put some detail of the source. regards Manu Wjhonson wjhon...@aol.com a écrit : Does anyone have a robust ETL routine for loading data *into* Universe (not out from it). Something like Cedarville's DOWNLOAD but in reverse ? Before I roll my own. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] RESIZE error - Replication?
hi, on 10.3, we talk about UVReplication vs. U2Replication available o r11. UVRep is set file by file using UniAdmin, the gui tool delivered on UVClient CD. Before RESIZE; you must unset the replication flag from the file header. Use UniAdin to achieve it. see Replication branch. After resizing, you must re-set the uvrep setting on your file. Manu John Thompson jthompson...@gmail.com a écrit : Its Universe 10.3.1 on Red Hat 5, so I'm guessing its the old style? Is the replication tool a part of the UVClient windows software? On Thu, Sep 27, 2012 at 8:43 PM, John Jenkins u2g...@btinternet.com wrote: The file has been marked for replication. Depending on your UniVerse version this is either old style replication, or the newer U2 replication. If it should not be replicated then use the Replication configuration tool or XAdmin to turn this off for the file. You may also want to check your uvconfig setting for replication. If you are not using it then you may as well turn it off completely. Note: old style uses the file header and UV_UDRPUB/SUB/SYS in the UV account. U2 replication uses a separate repconfig file. Regards, JayJay Sent from my iPad On 28 Sep 2012, at 01:29, John Thompson jthompson...@gmail.com wrote: Has anyone ever seen this error while trying to resize a file. RESIZE CUSTOMER RESIZE attempt on a replicated file. I've never seen it and I was trying to do a bit of maintenance. -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Virtualizing a Universe server of 100+ users
hi, Badly knowed, UV/NET is a embedded client server module which work over unirpc system. Then when a uv system open a remote uv file ; uv/net start (if not already established) a uv session on the remote server. On remote uv uvlictool, port-status, list-readu reports uv/net session like phantoms session. Then when uv system READ/WRITE on the remote file, UVNet send a request to do it by the remote session. Locks (group and record) are maintined on the remote server linked to the uv net phantom session. UVNET module must be licensed on uv remote system only (where files are adressed). a uv subr is provided to launch a uv/basic on the remote uv ; most powerfull vs. select/readnext/read on a remote file. Manu Wjhonson wjhon...@aol.com a écrit : Well for networked UV systems, you would only need group and record locking *if* the UV systems were trying to write to each others hashed files. But how do you even reference a hashed file, living on a different server ? Using an UNC path? Does that work? I would think that Universe wouldn't even try to open a file as hashed using just a Windows PATH type pointer. It could open the directory possibly. But on writing conflicts you should get a block at the Windows level anyway. -Original Message- From: Robert i...@keyway.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Aug 21, 2012 8:22 am Subject: Re: [U2] Virtualizing a Universe server of 100+ users Yes, UV/NET is a good way to network UNIVERSE systems. I saw a UNIVERSE job site recently have networked UV systems WITHOUT using UV/NET. They used the networking built into the OS (Windows or UNIX). Sounds good, right? Not until you realize that there was no record locking because the OS had no concept of a UNIVERSE record. It also didn't allow you to file away the record. If you pulled up a record on one system, and then pulled it up on the other, there would be no message and no lock. You can use UV/NET and a file pointer with the '!' designator to specify the system and it works well (record locking, etc.). Robert Norman . ROBERT NORMAN AND ASSOCIATES 23441 Golden Springs Dr., #289, Diamond Bar, CA 91765 (951) 541-1668 i...@keyway.net mailto:i...@keyway.net http://users.keyway.net/~ice/ http://users.keyway.net/%7Eice/ Affordable UNIVERSE programming services for PICK/BASIC, DATA/BASIC, UniVerse Basic, UniBasic, R/BASIC, jBC. On 8/21/2012 7:31 AM, Wjhonson wrote: Uv/NET ? Wow. I didn't know anyone actually used that. -Original Message- From: Manu Fernandes e...@infodata.lu To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Aug 21, 2012 4:14 am Subject: Re: [U2] Virtualizing a Universe server of 100+ users hi, we have done it with a 150 uv Enterprise edition, we run +- 3 sessions per user + UV/Net access. database specs : - 65GB, we use mostly DEFINE.DF vs 65BIT files applications type - SB+ / SBClient on telnet - UV/Net is running ; we share another uv for wharehouse activity hardware setting - dell 12 proc, 256 GB ram - SAN on SCSI vmware setting - ESX - 4 processor dedicated - 128 GB RAM os setting - Redhat Enterprise - regarding a pure hardware system, same config, we loose 30% of perf. then we push the memory larger the database, Linux push the complete DB on cache an we have a very powerfull system. Manu Eric Armstrong earmstr...@lobelfinancial.com a écrit : Has anyone virtualized a Universe server of 100+ users, and if so, could you share how it went? Eric Armstrong Programmer/Analyst Lobel Financial LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV Unix File Recovery
Hi bill, If uv is on your win-box, try this : - On windows, use uvbackup (eventually -rev10.1 or less) - On hp-ux use uvrestore manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Bill Brutzman Envoyé : mercredi 20 juin 2012 23:29 À : U2 Users List Objet : [U2] UV Unix File Recovery I am having trouble trying to restore a year-end file to a new file name. The file is saved to my Windows7 PC... The UniVerse host is running on hp-ux. I tried to FileZilla FTP the file back using binary enconding. I tried to create a new file and dictionary from the UV command prompt and then copy the file and dictionary over. I tried creating a new file in UniVerse and sizing the file like the known working files. When I try to do a UVFIXFILE... an error indicating file truncation results. I am now trying ASCII encoding. I was able to get something like this to work in the past. Suggestions would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] How to adresse OracleClientInterface from UV/Basic
Hi group, I'll connect my Universe app to a Oracle system. The Oracle expose a list of PL/SQL functions I'll call to and receive some results. I'm running UV 11.1 on Linux/Suse and OracleClientInterface is installed on the system (OCI is correctly running). Do you have any advice, basic sample, ... ? Thanks by advance. manu ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] uv/win - PHANTOM JOBS not sync'ed
Hi, VOC entry look exactly like NEWACC. One more info, PHANTOM process finishs but I'm not NOTIFIED about it ; it comes probably from the same trouble. Thanks for your attention. Manu JOBS 01 Verb - Show which PHANTOM jobs are running 02 JOBS 03 I 04 G PHANTOM 01 Verb - Create a PHANTOM task to perform a specified operation 02 PHANTOM 03 I -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Wjhonson Envoyé : jeudi 14 juin 2012 18:26 À : u2-users@listserver.u2ug.org Objet : Re: [U2] uv/win - PHANTOM JOBS not sync'ed Post the VOC entry for JOBS -Original Message- From: Manu Fernandes e...@infodata.lu To: u2-users u2-users@listserver.u2ug.org Sent: Thu, Jun 14, 2012 7:11 am Subject: [U2] uv/win - PHANTOM JOBS not sync'ed Hi group, A strange behavior on Universe/Windows. When I start a PHANTOM, it starts correctly, do his works and finish properly ; no more PORT.STATUS, no more WindowsTaskManagerProcessus). But JOBS command continue to report it Running. Any idea what wrong in the system ? rights ? Manu __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] uv/win - PHANTOM JOBS not sync'ed
Hi group, A strange behavior on Universe/Windows. When I start a PHANTOM, it starts correctly, do his works and finish properly ; (no more PORT.STATUS, no more WindowsTaskManagerProcessus). But JOBS command continue to report it Running. Any idea what wrong in the system ? rights ? Manu ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] XML and UV
Hi jerry, If you don't want to use xmapping system, you can do like this : 1 - store xml clob directly under universe (one record is one xml clob) 2 - define xpaths expression to adress the data you need from the xml clob 3 - call one subr to extract the xpath's values How to write a xpath stmt : http://www.w3schools.com/xpath/xpath_syntax.asp You can use it as a subr call XMLDATA = ... CALL IN.XDOM.XPATHS(RESULT,XMLDATA,/ONIXmessage/Product/MediaFile[2]/MediaFileLink[text()],errorcode) or from a i-type EXTRACT(@RECORD,...,0,0);SUBR(IN.XDOM.XPATHS,@1,/ONIXmessage/Product/MediaFile[2]/MediaFileLink[text()],'') The code: ** * Input: xml.doc : le fichier xml (ex : FSO.IN.XML/test.xml) *xpathAM : les xpaths (ex : '/bookstore/book[price35.00][*]/title[*]') *Dans l'exemple ci-dessous, on veut les titres de tous les livres *du document xml dont le prix est que 35 * * *?xml version=1.0 encoding=ISO-8859-1? *bookstore * book *price29.99/price *title lang=frHarry Potter/title *typetiti/type * /book * book *price37.95/price *title lang=engLearning XML/title *title lang=engXML POUR LES NUL/title *typetoto/type * /book * book *price42.95/price *title lang=frMartine à la ferme/title *typetoto/type * /book */bookstore * * * Output: p.result : les noeuds du xpath * (ex : p.result1,1 = title lang=engLearning XML/title * p.result1,2 = title lang=engXML POUR LES NUL/title * p.result2,1 = title lang=frMartine à la ferme/title * Si on a plusieurs XPath, les p.result de chaque XPath sont séparé par des | * * p.err : err1: numérique, 0 si OK (XML.SUCCESS) * err2: message éventuel ** subroutine IN.XDOM.XPATHS(p.result,xml.doc,xpath,p.err) $INCLUDE UNIVERSE.INCLUDE XML.H err.xpath = 0 p.result = p.err = 0 pos = index(xml.doc,,1) if pos 0 then Status = XDOMOpen(xml.doc,XML.FROM.STRING,XDDO) end else xml.doc = CHANGE(xml.doc, ,/) xml.doc = CHANGE(xml.doc,\,/) Status = XDOMOpen(xml.doc,XML.FROM.FILE,XDDO) end if Status # XML.SUCCESS then Status2 = XMLGetError(code,valeur) p.err1 = Status p.err2 = Impossible d'ouvrir le DOM xml [:code:] : :valeur return end nbrXpath = DCOUNT(xpath,@AM) for i = 1 to nbrXpath para.xpath = xpathi CALL IN.XDOM.XPATH(result.xpath,xml.doc,para.xpath,XDDO,err.xpath) if err.xpath = 0 then if p.result = then p.result = result.xpath end else p.result := @AM:result.xpath end end else gosub CLOSE.DOM p.err = err.xpath return end next i gosub CLOSE.DOM return CLOSE.DOM: Status = XDOMClose(XDDO) if Status # XML.SUCCESS then p.err1 = Status p.err2 = Impossible de fermer le DOM xml return end return end *--- subroutine IN.XDOM.XPATH(p.result,xml.doc,xpath,dom,p.err) * ATTENTION TO BE CALLED FROM ...XPATHS $OPTIONS PICK $INCLUDE UNIVERSE.INCLUDE XML.H INCLUDE DMSKELCODE COMMON EQU EQU_TEXT TO [text()] EQU EQU_MAX_ERR TO 5 p.err = 0 p.result = err = 0 size = dcount(xpath,*) if size 1 then cpt.err = 0 for i = 1 to 999 xpath2 = CHANGE(xpath,*,i,1) CALL IN.XDOM.XPATH(p.result2,xml.doc,xpath2,dom,err) if err1 # 0 and err1 # 10 then p.err = err return end else if err1 = 10 then return end else pos = index(xpath,EQU_TEXT,1) if pos 0 then if p.result2 = then cpt.err = cpt.err + 1 end else p.result2 = LOWER(p.result2) p.result-1 = p.result2 cpt.err = 0 end end else if p.result2 = then cpt.err = cpt.err + 1 end else p.result2 = LOWER(p.result2) p.result-1 = p.result2 cpt.err = 0 end end end if cpt.err EQU_MAX_ERR then return end end next i end else ** on test pour savoir si on veut le text du noeud ou le noeud gosub TRT.ONE.XPATH if p.err1 = 0 then p.result = value end end return **TRAITEMENT D'UN XPATH TRT.ONE.XPATH: value = pos = index(xpath,EQU_TEXT,1) if pos 0 then ** si on veut le texte xpathTxt = change(xpath,[text()],) Status = XDOMLocate(dom,xpathTxt,,XROOT) if Status = XML.SUCCESS then Status = XDOMLocate(XROOT,text(),,NODEH) if Status = XML.SUCCESS then Status = XDOMGetNodeValue(NODEH, value) value = change(value,char(13),) value = change(value,char(10),) HANDLE = XROOT gosub CLOSE.DOM end HANDLE = NODEH
[U2] [uv] from uv/linux, execute a remote mysql/sql stmt ?
Hi group, I'm looking for your experiences... From Universe/linux, I'll execute a mySQL sql phrase. mySQL is installed on a remote server. - What is the mysql-client to be installed beside Universe ? - How to execute a sql-phrase from UV/BASIC ? and capture the result !? Thanks for any advice. Manu ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Job scheduling in UniVerse
Hi, If you start a uv from os scheduller and want to run a SBprocess ; you go to trouble ... because before running your process you must start a SBenvironment Release 5.2 introduce the SB.REMOTE.PROCESS which give ability to start a process from uv shell (then from os shell) without starting a SB+ user login and it works very fine. But you run 3.3.. If you want a SBprocess on phantom scheduled each 15 minutes ... create a parent process with a loop EXEC process ; SLEEP 900 and make a JobScheduling for these parent process. You start it manually one time from within SB+ session. I hope this help. Manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Martin Hlasensky Envoyé : mardi 13 septembre 2011 08:26 À : u2-users@listserver.u2ug.org Objet : [U2] Job scheduling in UniVerse Hello, I need help with UniVerse and job scheduling. Now we have UniVerse 9.5 and System Builder 3.3.2 (SB) and I want to run process every 15 minutes. I am able schedule job once only in SB. How can I schedule periodically recurring job in UniVerse or SB? Thanks for answer Martin Hlasensky Czech republic ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Printing to Remote Warehouse
Hello bryan, We do it using the passtrough Accuterm print sequence (AUX Printer) On Universe side, We have a uvprinter called auxport associate to a spool-script (device /dev/null) SETPTR charge USEROPT with @TTY var (/dev/pts/xx) ('SETPTR USEROPT ':@TTY:' ') # SCHEMA OF THE SCRIPT ... The spool-script receive the uvspool arguments uv_uid=$1; shift uv_jobnr=$1 ; shift uv_jobsize=$1; shift uv_banner=$1; shift uv_form=$1 ; shift uv_printer=$1 ; shift uv_7=$1; shift uv_8=$1; shift uv_9=$1; shift uv_10=$1 ; shift uv_useropts=$* ; shift # get spool-data into a temp file tmpfile=$tmp_path/spool_$$.tmp cat tmpfile AccutermAuxPrinterOpen = check accuterm doc ? esc[5i AccutermAuxPrinterClose = check accuterm doc ? esc [4i if uv_printer = auxport echo $AccutermAuxPrinterOpen $useropt cat tmpfile $useropt echo $AccutermAuxPrinterClose $useropt end I hope this help. Manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Bryan Evans Envoyé : mercredi 25 mai 2011 23:23 À : U2 Users List Objet : [U2] Printing to Remote Warehouse I apologize upfront if this is more related to Unix rather than UniVerse. We have a remote warehouse that connects to us via telent on a dumb terminal. They have a line printer hooked up to the dumb terminal. When we print packing lists, we open up the aux port and send the print job to the printer. We are looking to eliminate the dumb terminal, but we are stuck on how to send a print job to a local printer hooked to a PC. Has anyone done this before? Is it possible? The remote warehouse is not on our network - the only way they can connect is via telent. We are running UniVerse 10.2 on HP-UX and use AccuTerm as our emulation software. Thanks in advance, Bryan Evans ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] serial #
Another one, ANALYZE.SHM -c -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Dan Fitzgerald Envoyé : samedi 7 mai 2011 19:30 À : u2-users@listserver.u2ug.org Objet : [U2] serial # Someone asked me the other day how they could determine their uv serial number. I didn't know, and can't find it when I RTFM on uvlictool. Anyone know? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] serial #
Hi group Two methods : Os shell : uvregen -z basic : SYSTEM(31) manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Dan Fitzgerald Envoyé : samedi 7 mai 2011 19:30 À : u2-users@listserver.u2ug.org Objet : [U2] serial # Someone asked me the other day how they could determine their uv serial number. I didn't know, and can't find it when I RTFM on uvlictool. Anyone know? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Limitations of uvrestore
Hi group, I'm using uvbackup/uvrestore as the system to backup uv accounts. Imho the only tool to perform : - a uvdb backup with binary level db integrity. - a cross plateform compatible backup We perform account level uvbackup sent to a local file (uvbackup accountfile.uvb). I can't talk about block sizes impact. About perf, I use the option -limit set to 1 ; then uvbackup don't start two process (reader/writer) this is really more quick. I know a problem with Type1 files when uvbackup from unix and uvrestore on windows. uvrestore 'restore' dir and subs-dir on windows like prepared on unix but uvwindows don't respect Type1 subs dir ... You must resize Type1 to Type19 on uvunix before uvbackup and uvrestore on uvwin. My 2 pence manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Gregor Scott Envoyé : mardi 3 mai 2011 04:13 À : U2 Users List Objet : [U2] Limitations of uvrestore I have just finished some testing of uvbackup and uvrestore on AIX and Linux to see if there are areas to improve performance. The results were interesting, and somewhat alarming - see http://gdoesu2.wordpress.com/2011/05/02/facts-about-uvbackup-and- uvrestore/ for details. What I am interested in is: a) Do UV platforms other than AIX and Linux have similar issues with uvrestore? b) Does anyone use block sizes beyond 1mb for uvbackup and uvrestore? If so, what size and what impact does it have on backup performance? Thanks Gregor This email and any attachments to it are confidential. You must not use, disclose or act on the email if you are not the intended recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] [uv] file header sica region structure
Hi group, I've some uvfiles where I set triggers (no SQL Schema defn). I'll check the TRIGGER defn by BASIC ! FILEINFO, STATUS ? ? I found no documentation about uvfile's SICA Region structure/access. Is there someone with idea ? (yes, I can execute a LIST.SICA and analyse the text-output but if possible I prefer use of a better interface than text) Thanks. Manu ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Question about uvbackup dd and uvrestore
Hi, Do a Backup of universe on snapshot ; to perform a binary backup. Yes, if you don't use Type30 / dynamic files because while a T30 file is open, some header file's information stays in memory. You must close the T30 files (all users) to be sure the header is flushed. I prefer using uvbackup. To avoid the 2gb limit, I prepare files-list to uvbackup and run multiple uvbackup -cmdfil . For uvfiles which are greather than 2gb himself, I use Distribution (DEFINE.DF) then I manage only files smaller than 2gb (a easy solution to make resizing administration regarding administation of 64bit nGb files). My 2 pence. manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de bpa...@serta.com Envoyé : vendredi 15 avril 2011 23:39 À : u2-users@listserver.u2ug.org Objet : Re: [U2] Question about uvbackup dd and uvrestore The product provided by Ashwood handles this nicely. On an AIX system, it pauses the database, performs a JFS2 snapshot (in seconds), releases the database, then the customizable backup script (we use tar and gzip) backs up the snapshot. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Friday, April 15, 2011 12:54 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Question about uvbackup dd and uvrestore On 15/04/11 13:30, Rex Gozar wrote: Unless you need record-level restores, I would recommend using tar to backup your Universe accounts. While UV is running and being used? tar is all very well, but if the database is being used 24/7 it could easily lead to a corrupt backup. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material not intended for Public use. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this communication in error, please notify the sender and delete the material from any and all computers or devices. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] backing up system
Hello, For a best *uv*backup with on-line system, use uvbackup, it perform a file by file, record by record dump ; not a blind binary copy. Here is a little shell script which create one uvdb file for one account. When done, you can copy the uvbfile out of system. My two pence. Manu more uvbackup-account #!/bin/sh # UV Backup of one account # Syntax : uvbackup-account accountName # UVDB is the path to the root of uvdatabase # UVBACKUP is the path to the repository of uvb files if [ $1 ] then find $UVDB/$1 -print | uvbackup -f -v -s $UVBACKUP/$1.log -limit 1 -cachedetail - $UVBACKUP/$1.uvb echo --- echo `date` echo $1.uvb is available on $UVBACKUP else echo Syntaxe : uvbackup-account accountname fi -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de david yu Envoyé : vendredi 11 mars 2011 23:54 À : u2-users@listserver.u2ug.org Objet : [U2] backing up system hello, We are using HP-UX 11.23 and I have a question in regards to backing up system by account, In the root directory we have 6 accounts, DBCAlive, DBCAtest, DBAZlive, DBAZtest, DBUPGCA, DBUPGAZ. When we do our nightly backup, we backup all the accounts by using cpio but sometimes we just want to backup 2 accounts at the same time, anyone knows how this is done? here is the command that we use to backup: mt -t /dev/rmt/1mb rewind cd / find . -print|cpio -ovcB/dev/rmt/1mb Any assistance will be greatly appreciated. thanks! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] XML Parser
Hi, For big interchange, we use Altova MapForce, - you build xml mapping from/to other structure in wyswyg, - MapForce build a java jar Library you can deliver as free runtime executable . - you start java ... from uv -- the source can be a sql source, a text file, ... -- the result can be text, sql, ... other format Else, more programatically, we build function with python called from uv. Under UV, we store the complete xml CLOB, the use a xpath query to read a value. (detail available off list) I hope this help. Manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Perry Taylor Envoyé : mercredi 23 février 2011 14:50 À : U2 Users List Objet : [U2] [UV] XML Parser Can someone recommend an XML parser to run on RHEL? I'm tired of fighting trying to get the XML support in BASIC to work. Any suggestions? Thanks. Perry Taylor Zirmed, Inc. CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Input or Output screen?
Hi, Loop on @PROC.NAME1..x until F('XXPROCESS',@PROC.NAMEx)1 = 'I' or F('XXPROCESS',@PROC.NAMEx)1 = 'O' then if = I run your extra validation. My 2 pence. Manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Nigel Laidlow Envoyé : jeudi 10 février 2011 18:04 À : u2-commun...@listserver.u2ug.org; u2-users@listserver.u2ug.org Objet : [U2] Input or Output screen? My dilemma... I have a process that is used validate a field in an input screen and in a display screen (in Avante Explorer), but for the input screen extra validation is needed. Is there some variable in Avante that tells if the current screen is an input or output, that I can check to do my extra validation? My alternative is to create some variable to pass in, but if something already exists I'd rather use that instead. Any help would be appreciated. Best Regards, Nigel Laidlow ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Books?
Hi, Try with the beginning : Universe System Description by Universe's editor : http://www.rocketsoftware.com/u2/products/universe/resources/technical-manuals/sysdesc-v11r1.pdf Sometime return to the base is usefull. Manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Michael McGlothlin Envoyé : vendredi 4 février 2011 00:31 À : U2 Users List Objet : [U2] Universe Books? I'm trying to find books on Universe but very little seems to come up. Is there anything you can recommend for someone trying to teach themselves? Thanks, Michael McGlothlin ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] LIST.READU - clear lock table ?
Hi Garry, Look the statement UNLOCK --- snip from HELP UNLOCK Use UNLOCK to clear file, group, and update record locks. You must be a UniVerse Administrator logged in to the uniVerse account to execute UNLOCK. SYNTAX UNLOCK [NODE node] [USER user.number] [FILE pathname | [DEVICE device.number] [INODE i.node.number]] [GROUP group.address] [RECORD record.ID] {FILELOCK | GROUPLOCK | READULOCK | READLLOCK | ALL} Sample regarding your LIST.READU ; if you want to unlock the record S1970557 use : UNLOCK INODE 32810 RECORD S1970557 READULOCK if you want to unlock all locks of userno 31 use : UNLOCK USER 31 ALL warning, use LIST.READU EVERY to see all locks levels and eventually the locks waiters when you get a deadlock condition. manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Garry Smith Envoyé : mercredi 19 janvier 2011 01:27 À : U2 Users List Objet : [U2] LIST.READU - clear lock table ? So great -- LIST.READU shows you some information ... but how do you clear these locks Active Record Locks: Device Inode Netnode Userno Lmode Pid Login Id Item-ID. 2621441 328100 50 4 RUS1970666 2621441 328100 48 30 RUS1970676 2621441 328100 44885 31 RUS1970557 = PID kill what ?? clear ?? 26214417866190 36393 31 RU448659~VG.6 2621441 328100 82 32 RUS1970438 When I try to kill 44885 as reported by Userno Unix says no such user. clear.locks only looks at your current login session. Any suggestions ? UV 9.6 and Aix 5.2 Garry L. Smith ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] PORT.STATUS questions.
Hi, Yes, you are right, Allowing PORT.STATUS to show all users when run by a non-root user this following is from a IBM/U2 technote I found one time. chmod u=rws /usr/bin/ipcs chmod u=rws uvhome/bin/list_readu manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de inquieti Envoyé : mardi 4 janvier 2011 13:38 À : u2-users@listserver.u2ug.org Objet : Re: [U2] [UV] PORT.STATUS questions. We use UniVerse on RedHat and get around the problem of only showing your own port.status details with the following method:- Port status Setting, up the port.status is quite easy if you have or can get sudo. If you have the file /etc/sudoers then sudo is already on your system. Logged in as root, go to the /etc directory and use visudo to edit the file (you must be logged in as root or the session will hang). There will be an example for the group wheel with a remark about uncommenting the line to allow the people in the wheel group to run all commands. Insert a line that will allow sbgrp to run commands without entering the su password. This can be limited to specific commands, there are examples at the bottom of this page http://www.gratisoft.us/sudo/man/sudoers.html By adding the following line into ours %sbgrp ALL=(ALL) NOPASSWD: ALL All our sb+ users can run root commands. I created a symbolic link in the /bin directory (ln -s /usr/ibm/uv/bin/list_readu port.status) rather than on an account basis. The list_readu file itself (/usr/ibm/uv/bin/list_readu) should be chmodded using 4751 and the group set as other using chgrp. This way the user details will also be available in /LOCKS Then copied the MD item for PORT.STATUS to ORIG.PORT.STATUS (just in case) and replaced PORT.STATUS with the following:- 0001 PA 0002 SH -c sudo port.status === HTH David Buss, Troy (Logitek Systems)-2 wrote: Fyi.. On universe 10.2 running on windows, this system(1302) seems to work without contention between users and executes very quickly, about 100 times per second on 2 sessions. From: Don Robinson donr_w...@yahoo.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, January 3, 2011 1:06:41 PM Subject: Re: [U2] [UV] PORT.STATUS questions. Manu, The INTERNAL option looks promising for what I need. I do read manuals but somehow missed it. It doesn't solve the One user at a time issue but will make parsing the output easier. Your other suggestions may be useful, too. Thanks to you and the others that responded. Don Robinson __ ___ Scanned by IBM Email Security Management Services powered by MessageLabs. For more information please visit http://www.ers.ibm.com This email is intended only for the use of the party to which it is addressed and may contain information that is privileged, confidential, or protected by law. If you are not the intended recipient you are hereby notified that any dissemination, copying or distribution of the email or its contents is strictly prohibited. If you have received this message in error, please notify us immediately, by replying to the message and deleting it from your computer. WARNING: Internet communications are not assured to be secure or clear of inaccuracies as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Therefore, we do not accept responsibility for any errors or omissions that are present in this email, or any attachment, that have arisen as a result of e-mail transmission. __ ___ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- View this message in context: http://old.nabble.com/-UD--Killing-a-UO- connection-tp30547618p30586311.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse On RedHat?
Hi group, hi bill, My company is a software house, Linux RH is the dev-plateform and the primary platform of our deployment. Rocket/U2 certifies under RH and RH Enterprise, but UV run perfectly on Fedora release too. We run with RH from years without problem. If you choose Enterprise, you get a very good support and additional service from RH. Our customers run all release of UV (windows, linux, aix, hp-ux, ... ) and we deliver our software via cpio or tar but the best cross platform tool is uvbackup/uvrestore because uvrestore create a new uvfile, new indexes, ... when it restores datas; you get no binary problem. You don't need to re-compile you basics, you must use ''fnuxi'' on all datafiles and basic object copied by OS method. find path -exec fnuxi {}\; You don't need to re- global catalog, you can copy manually the content of $UVHOME/catdir, just pass a fnuxi on this directory. Exchange from linux to hp-ux and return, works perfectly, use fnuxi if you copy via OS. Your major problem are not under Universe, but on external tools, application, scripts, ... you actually run under hp-ux, that you must check and sometimes switch to similar tools available under linux. If you work with extended characters set in os-filename be careful about the os language setting. Regarding RH on HP Integrity(Itanium) it's not a U2 problem, it's a RH problem. Actually, UV runs under RH 5.2, you can read this on HP website : Red Hat announces that it is committed to protecting Itanium customers' investments, that all Itanium related development will be incorporated into Red Hat Enterprise Linux 5 exclusively, and that the next major release of Red Hat Enterprise Linux (version 6) will not support Itanium. My 2 pence. Manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Bill Brutzman Envoyé : vendredi 5 novembre 2010 22:59 À : u2-users@listserver.u2ug.org Objet : [U2] UniVerse On RedHat? 0. We are considering migrating from HP-Ux to RedHat. 1. How is RedHat? 2. Will I have to re-compile and re-catalog everything? 3. Did anyone migrate from HP-Ux to RedHat and then back to HP-Ux? 4. Is the RedHat Standard Edition Suitable? 5. Did anyone try running UV on RedHat on an HP Integritity (Itanium) server? 6. Are there any gotchas? 7. Insights and hind-sights would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV 10.3.3/SB+ 6.0.3
Hi group, I don't know if it is relevant but wen Paragraph use a CLOSE x, SB+ run CALL SB.FILEVAR.S(FILES.OPENEDx, 2, FILEVAR(x), ERR) Into SB.FILEVAR.S(FNAME, MODE, F.VAR, ERR), we found : * --- found with VLIST DM SB.FILEVAR.S - INCLUDE DMSKELCODE COMMON COMMON /SBFILES/ SBF.NAMES,SBF.PTR,SBF.DELLIST,SBF.HANDLES(750) ... if mode = 2 then CLOSE F.VAR ** look on the primary file cache LOCATE(FNAME,FILES.OPENED ; RG) THEN FILES.OPENEDRG = '' FILEVAR(RG) = 0 END ** look on the secondary file cache LEN.FNAME = LEN(FNAME) LOCATE(FNAME, SBF.NAMES, 1, LEN.FNAME; RG) THEN POSFILE = SBF.NAMES2, LEN.FNAME, RG SBF.HANDLES(POSFILE) = 0 SBF.DELLIST(-1) = POSFILE ;** remember the available pos SBF.NAMES = DELETE(SBF.NAMES, 1, LEN.FNAME, RG) SBF.NAMES = DELETE(SBF.NAMES, 2, LEN.FNAME, RG) END end ... There is no CLOSE basic statement executed; only a free(filevar) filevar='' Is it the problem for UV ?? My 2 pence. Manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Kevin King Envoyé : mercredi 3 novembre 2010 22:45 À : u2-users@listserver.u2ug.org Objet : [U2] UV 10.3.3/SB+ 6.0.3 On earlier versions of SB+ - running on Unidata - we have created a couple of processes that can be used to create and delete a temporary work file for use by whatever logic falls between the CREATE.WORK.FILE and DELETE.WORK.FILE processes. In trying to port these to SB/XA on UV we're running into a situation where Universe won't delete the data portion of the work file. Basically these process are wrappers for the CREATE.FILE and DELETE.FILE TCL verbs. Each process builds a variable with the appropriate command and then calls a subroutine to silently EXECUTE the command and return the results. If I run the two back to back from TCL the file is created and deleted without incident. If, however, something is written into the work file between these two commands - as might be done from a program or paragraph - the DELETE.WORK.FILE process (calling the DELETE.FILE TCL verb) will remove the dictionary of the file, but not the data nor the VOC pointer. The error returned from the DELETE.FILE command (executed by this process) is Unable to delete file WRK. where the 's are the current port #. Before the file is deleted, both the dictionary and data portions are closed using the CLOSE statement in an SB+ paragraph. Even more interesting is that after the process is complete and has returned to its caller, the DELETE.WORK.FILE process works without incident. It's almost like SB+ is holding an open file buffer after the file has been closed or somehow the DELETE.FILE is running at a different execution level than the CREATE.FILE that originally made the file. So to factor SB+ out of the mix I created a real simple test program: 001: EXECUTE 'CREATE.FILE WRK.3604 1 1' 002: OPEN 'WRK.3604' TO F.WRK THEN 003: WRITE '' ON F.WRK,'X' 004: CLOSE F.WRK 005: END 006: EXECUTE 'DELETE.FILE WRK.3604' CAPTURING OUTPUT 007: CRT OUTPUT This program reliably creates and deletes the file each time, yet it is almost identical to what we're trying to do from the SB+ paragraph. So here's my question: Is UV sensitive about execution levels when deleting a work file? What might make Universe think the file is open when we've attempted to close it using the CLOSE statement in an SB+ paragraph (other than the obvious possibility that CLOSE might be broken)? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] how to round to 2 decimals?
Hi, Use OCONV(21632.468,'MR20') Manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Chris Austin Envoyé : mercredi 13 octobre 2010 23:22 À : u2-users@listserver.u2ug.org Objet : [U2] how to round to 2 decimals? I'm trying to figure out how to round to 2 decimal places with a floating point in UniVerse For example 2596 x 8.333 = 21,632.468 How would you round that in UniVerse to 21,632.47? Thanks! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB Client - Disable TAB
Hi group, At our side, we solve these problem with a system wide validation process defined on all SBfields which check if mandatory fields sequentially defined before the current field are empty. If one is found it output a error message and exit with @RTN.FLAG = {mandatoryfield} else it execute the validation expression for the current field. I'm ok with you, this is a trick that SB+ can do. My two pence. Manu *-- For info : @MAINFILE is the current datafile @LINE1,18 is the current fieldname @LINE1,1 is the current AMC value ; if negative this is a @WORK field (ABS(@LINE1,1) is the AMC of @WORK @CNT the current mv value @PROC.NAMEx is the process names ... check 1,2,3,... until you found Readv XXPROCESS1 = 'I' ; this is the input-process-defn Read PROC.DEFN then PROC.DEFN5 is the DICT.FILE where 'INPUT.DEFN' reside PROC.DEFN6 is the DICT.FILE KEY of input.defn of the current screen Read INPUT.DEFN FROM 'DICT ': PROC.DEFN5, PROC.DEFN6 Then LOCATE(@LINE1,18,INPUT.DEFN,15;POS) Then check all field sequentially before the current FOR I = 1 TO RG -1 IF INPUT.DEFN22,I = 'Y' THEN Read field.defn from DICT.FILE,INUT.DEFN15,I If field.defn2,1 0 then check @WORK else check @RECORD IF field.defn2,2 0 then mv'ed else am'ed Then check if the value is empty or not If yes, output a error, rtn.flag = INPUT.DEFN15,I END NEXT I -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Israel, John R. Envoyé : vendredi 24 septembre 2010 21:04 À : u2-users@listserver.u2ug.org Objet : [U2] SB Client - Disable TAB This may be old news to most folks, but we have found that if a user navigates through a GUI SB+ screen and uses their mouse to click on an input, none of the logic tied to the prior inputs are run. This includes being able to skip right past mandatory fields. For example, a screen has 5 required inputs followed by 5 non-required inputs. If the user is in input 2 and uses their mouse to click into input 8, SB allows this to happen and the required fields and any associated logic tied to inputs 2 through 7 are ignored. This appears to be a huge SB bug. Sure we could fix it for a specific screen, but that does nothing for the hundreds (or thousands) of other screens. Does anyone have a realistic solution to this condition? John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata - Hardware sizing for 550 telnet users
Hi group, This post to ask your opinion about the hardware sizing to serve this type of usage, within a IBM / AIX system : - Unidata unix - 550 telnet users - 100gb datafiles Any advise is welcome. Manu ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Distributed file on Unidata Unix (DEFINE.DF)
Hello, I'm looking for a solution to distribute a Unidata/Unix Hashed file like Universe does with the DEFINE.DF verb and PartKey algorythm. Is there someone with any idea ? With kind regards. Manu ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV:basic readu lock promote to filelock when locktable is full !!
Hello, Thanks for your very good suggests. I put some comment on each part of your reply. My solution is probably : - isolate the TRANSACTION BEGIN/COMMIT/ABORT on a TransactionSubr (already done). - allocate a TransactionName to the transaction when BEGIN (stored into a namedcomon) - into ReaduSubr, associate the locks_id (filename/key) with the Active TransactionName -- then if a defined limit is reach the ReaduSubr can escalate to FILELOCK - into the TransactionSubr when COMMIT/ABORT, free the TransactionName/locks_id table. Looks like maintain a application level locks table. I'll probably do it like this because it is a global solution with no dependencies (OS,OE,...) only BASIC . With kind regards. Manu Ps : I put some comment on each part of your reply. -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Charles Stevenson Envoyé : lundi 7 septembre 2009 17:10 À : u2-users@listserver.u2ug.org Objet : Re: [U2] UV:basic readu lock promote to filelock when locktable is full !! Manu, 1. As to your specific question about figuring out how many locks your process or transaction owns, I don't know a quick function for that, but there is a little known INTERNAL keyword for LIST.READU ( PORT.STATUS). E.g., EXECUTE LIST.READU USER nnn INTERNAL CAPTURING XYZ then parse XYZ. Sounds expensive to do frequently, but infrequent is reasonable. [manu:] Yes, seems more quick than a EXECUTE 'LIST.READU ':@USERNO CAPTURING CAPT but heavy to check How many locks have I. --- 2. If I read your question correctly, your readus are isolated to a particular subroutine or set of routines. [manu:] Yes If so, how about defining labeled common where you, yourself, can increment/reset a lock counter and check it if it is so big that you need to promote from record- to filelock? (I'm not crazy about this. It moves what is properly dbms-level tuning deep down into the application layer, requiring future tweaks each time the platform changes.) [Manu:] yes, that the IBM approach, yes, and my choice to build a BASIC locks table. --- 3. More generally, it seems like the simplest solution would be to just increase the size of the lock table. It means taking some memory out of general service reserving it for these rare large transactions, but memory is relatively cheap. That is, it's cheap unless you're already at the upper edge of hardware capability at the moment. [manu:] my first solution yes --- 4. I assume you have a fairly even distribution of locks over the whole lock table? If it is lumpy, one part can be full, and the solution may be to define ids or files a little differently. But let's talk about that solution only if that is really the problem. [manu:] no trouble at this level, keys are numeric and fully distributed into locks table. --- 5. Just to be clear, when you say TRANSACTION, you mean a formal UV transaction using TRANSACTION START/COMMIT/ABORT,etc. syntax, right? Or do you mean it informally, a logical transaction at the application layer? [manu:] yes, Universe TRANSACTION Processing START/COMMIT/ABORT Chuck ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] [UV][UX] @USERNO @LOGNAME/PID ;...
Hi all, When I perform a READU ... LOCKED ... I can use the STATUS() to retrieve the USERNO which maintain the requested lock. Into BASIC, from a USERNO value, how to retrieve the @LOGNAME and the @PID ?? Any idea ? Manu ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 University 2009, Denver
Hi, I'll be there. Manu. -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] De la part de Norman Bauer Envoyé : vendredi 11 septembre 2009 21:40 À : u2-users@listserver.u2ug.org Objet : [U2] U2 University 2009, Denver I look forward to meeting many of you there. I am really looking forward to Creating RESTful ADO.NET Data Services and Consuming Them Using Silverlight, AJAX, and .NET Client presented by Rajan Kumar. Norm ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UV:basic readu lock promote to filelock when locktable is full !!
Hello U2Group, I'm in a trouble with size of the lock table and transaction, Here is my situation : - I run a basic program which analyze a order composed of piece to manufacture. These analyze is done within a TRANSACTION. - Each piece analyzed result on a set of tasks - Each task record is store individually into a file OrderTasks (+ OrderTasksStatusHistory ~ updated via triggers on OrderTasks.) - For a piece we get +- 20 tasks. Then when we analyze a big order which contain more than 150 pieces the transaction contain at least (150x20x2) 6000 records updates . Ok, my uvconfig settings about locks mngr are FSEMNUM= 23 GSEMNUM= 499 FLTABSZ= 11 GLTABSZ= 113 RLTABSZ= 79 RLOWNER= 75 Usually, it works good without problem. But sometime, I get a very large order with 200 pieces and then the transaction's locks request exceed the capacity of the locks table (+- 9000) I known the solution reside into a escalate the readu lock to a filelock for my OrderTask /OrderTaskStatusHistory files but ... Here is my question : On a isolate subroutine which perform a readu can I check the number of recordlock already acquired by me ? - 1 - on a central subr to handle READU - 2 - on a trigger subr Any idea is welcome Regards. Manu ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] What ETL?
Hi, E.T.L. which one ? A in-house SB+/BASIC dev composed with 2 parts : - SB+ interfaces to define mapping extract options (Extract, Transform E.T. ) -- tablename --- link to filename(s) (same file into multi-account or multi-file with the same structure) --- human name of the table (for metadata providing to request tool) --- long description of the table (for metadata providing to request tool) -- columnname --- linked to Itype or SB+ expression to extract data --- sql-datatype --- human name of the column (for metadata providing to request tool) --- long descrition of the column (for metadata providing to request tool) --- specify the column indexing properties into dw -- options --- process before extract (to prepare temp file if necessary) --- select clauses to filter data --- process after read record (to transform the datas by BASIC if necessary) --- dw refresh rhythm incremental real time (based on trigger update trap) incremental time stamp (based on a time stamp, if exist into record) partial, based on select criteria complete - BASIC subr to extract data from files via E.T. and build SQL stmt to update data warehouse (Load L.) We run under Universe, Unidata, D3. We run in front of data warehouse running under MS-Sql, Orable, DB2, mySQL, Unidata, Universe(sql-schema), or direct access - Datawarehouse can be on the same server or separate. We have routines to interfaces data from outside U2 (xls, mdb, other-sql db, ...) and merge it into DW. The really big advantage is : - we work directly into the native structure of U2 (mv'ed, sv'ed, record_on_fixed_key, special storage organisation) - we use BASIC power to extract, transform data - the deployment consist to deploy one account with subr and one file with ETL defn per application - we build SQL stmt via template which can be dedicated by sql-db specificity Manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Debster Envoyé : mercredi 29 juillet 2009 06:50 À : u2-users@listserver.u2ug.org Objet : [U2] What ETL? Just takin' a survey What ETL tool do you use - Why do you like it? Ease of use Anyone can hold the helm when the sea is calm. -Syrus Publilius ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] [UV]recurring database, indexing and deadlatch errors
Hello U2 group, Probably a good question. We define a recurring file. Attribute1 refer to a record in the same file (pointer to a parent record). We have a I-Type SUBR which return the root key/item of a current item (read the parent until parent = @NULL ) Then we create a index with this I-type to retrieve easily the items childs of a root-id. All work fine ... except when the root-item is stored on the same FileGroup of the child-item. (at TCL, *RECORD file root-id* return the same value then *RECORD file child-id*) If this occurs, at the write step (save a child record) into the SUBR called by indices processing, we get a Self deadlatch error and return to TCL. This occurs because we are in a write which is a internal transaction with isolation level 0 and we try to read a record already in the isolation. Do you have any idea to solve it ? Thanks by advance. Manu ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV]recurring database, indexing and deadlatch errors
Hi Brian, Thanks for your interest. Keys are alpha chars like this Code Parent RP0907166311 11/5 RE0907162560 1108 RE0907162561 113305 RE0907162562 113502 RE0907162563 113502 RE0907162564 119BPL WP0907133832 RE0907162564 RE090721XRE0907162564 WP0907093668 RE0907162562 WP0907204811 RE0907162562 WP0907113771 RE0907162560 Actually we have 12'000 records but each day it's growing. Yes, if we RESIZE the file when the problem occurs, it solve ... until next time. Manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Brian Leach Envoyé : mercredi 29 juillet 2009 16:35 À : u2-users@listserver.u2ug.org Objet : Re: [U2] [UV]recurring database, indexing and deadlatch errors Hi Manu It is a good question... What do the record keys look like, and how many records are there? Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Manu Fernandes Sent: 29 July 2009 13:54 To: U2 Users List Subject: [U2] [UV]recurring database, indexing and deadlatch errors Hello U2 group, Probably a good question. We define a recurring file. Attribute1 refer to a record in the same file (pointer to a parent record). We have a I-Type SUBR which return the root key/item of a current item (read the parent until parent = @NULL ) Then we create a index with this I-type to retrieve easily the items childs of a root-id. All work fine ... except when the root-item is stored on the same FileGroup of the child-item. (at TCL, *RECORD file root-id* return the same value then *RECORD file child-id*) If this occurs, at the write step (save a child record) into the SUBR called by indices processing, we get a Self deadlatch error and return to TCL. This occurs because we are in a write which is a internal transaction with isolation level 0 and we try to read a record already in the isolation. Do you have any idea to solve it ? Thanks by advance. Manu ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV]recurring database, indexing and deadlatch errors
I suppose you think about a DEFINE.DF based on the key structure ! That can be a solution... Manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Brian Leach Envoyé : mercredi 29 juillet 2009 16:35 À : u2-users@listserver.u2ug.org Objet : Re: [U2] [UV]recurring database, indexing and deadlatch errors Hi Manu It is a good question... What do the record keys look like, and how many records are there? Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Manu Fernandes Sent: 29 July 2009 13:54 To: U2 Users List Subject: [U2] [UV]recurring database, indexing and deadlatch errors Hello U2 group, Probably a good question. We define a recurring file. Attribute1 refer to a record in the same file (pointer to a parent record). We have a I-Type SUBR which return the root key/item of a current item (read the parent until parent = @NULL ) Then we create a index with this I-type to retrieve easily the items childs of a root-id. All work fine ... except when the root-item is stored on the same FileGroup of the child-item. (at TCL, *RECORD file root-id* return the same value then *RECORD file child-id*) If this occurs, at the write step (save a child record) into the SUBR called by indices processing, we get a Self deadlatch error and return to TCL. This occurs because we are in a write which is a internal transaction with isolation level 0 and we try to read a record already in the isolation. Do you have any idea to solve it ? Thanks by advance. Manu ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
RE: [U2][SB+] Extended Character Set (ALT+...)
Hi, The trouble is probably under SB+ Ter Defn Setting. /Admin / Printers Terminals / Terminal Definitions / (load the term you use)) {F7} Keys+ Make empty the field Limit value of Displayable Characters. {F2} {F2} Then you get the extended chars authorized. My two pence. Manu -Message d'origine- De : owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] De la part de Brutzman, Bill Envoyi : lundi 4 mai 2009 15:53 @ : u2-users@listserver.u2ug.org Objet : RE: [U2][SB+] Extended Character Set (ALT+...) If there is a way to get UniBasic into the picture, consider using char(XX). Some code follows... *R0 Bill BrutzmanDec.2005 crt @(0) prompt '' crt @(-1) for Char.Count = 32 to 255 This.Char = char(Char.Count) *This.Char = 'x' Crt.Str = @(-5) Crt.Str := Char.Count 'R#3' : ' ' : @(-6) Crt.Str := This.Char begin case case Char.Count = 21 ; X.Posn = 1 ; Y.Posn = Char.Count case Char.Count21 and Char.Count = 43 ; X.Posn = 7 ; Y.Posn = Char.Count - 22 case Char.Count43 and Char.Count = 65 ; X.Posn = 14 ; Y.Posn = Char.Count - 44 case Char.Count65 and Char.Count = 87 ; X.Posn = 21 ; Y.Posn = Char.Count - 66 case Char.Count87 and Char.Count = 109 ; X.Posn = 28 ; Y.Posn = Char.Count - 88 case Char.Count 109 and Char.Count = 131 ; X.Posn = 35 ; Y.Posn = Char.Count - 110 case Char.Count 131 and Char.Count = 153 ; X.Posn = 42 ; Y.Posn = Char.Count - 132 case Char.Count 153 and Char.Count = 175 ; X.Posn = 49 ; Y.Posn = Char.Count - 154 case Char.Count 175 and Char.Count = 197 ; X.Posn = 56 ; Y.Posn = Char.Count - 176 case Char.Count 197 and Char.Count = 219 ; X.Posn = 63 ; Y.Posn = Char.Count - 198 case Char.Count 219 and Char.Count = 241 ; X.Posn = 70 ; Y.Posn = Char.Count - 220 case Char.Count 241 and Char.Count = 255 ; X.Posn = 77 ; Y.Posn = Char.Count - 242 end case crt @(X.Posn, Y.Posn) : Crt.Str next Char.Count crt @(76, 18) : ' _ ' crt @(76, 19) : ' / \' crt @(76, 20) : ' \ ASCII /' crt @(76, 21) : ' \___/ ' crt @(76, 23) : '[] ' : input Ans, 1 *--- --- The.End: crt @(-1) END *--- --- -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Bjorn Behr Sent: Monday, May 04, 2009 5:59 AM To: u2-users@listserver.u2ug.org Subject: [U2][SB+] Extended Character Set (ALT+...) Morning all Does anybody know of a way / setting that I can get the extended character setting to work in UniVerse / SB+ / SB Client ie ALT+148 = v If I type this in, I get nothing. I think it is because there are seen as non-prinitable characters by UniVerse, but I am no sure. System Info Universe 10.1.24 (PICK) System Builder 5.3 Emulator: SB Client 5.3 Regards Bjvrn Behr SUMMIT CORE Developer Tel No: +27 12 673 3251 Fax No: +27 12 673 4681 E-Mail: be...@frstia.co.zamailto:be...@frstia.co.za The information in or attached to this e-mail message is confidential and may be subject to legal privilege and client confidentiality. If you are not the intended recipient of this e-mail or the authorised representative of the recipient then please notify the sender of this e-mail immediately by return e-mail and delete this message from your system. You may not print, store, forward or copy this message or any part thereof or disclose or cause information in this message to be disclosed to any other person. FRSTIA cannot be held liable for any harm or loss resulting from malicious software code or viruses in this message or attachments, including data corruption resulting there from. Employees or representatives of FRSTIA are not permitted to send unsolicited messages (spam) and FRSTIA cannot be held liable for their sending of such mail. If you regard this message as spam, please inform us immediately by sending an email to i...@frstia.co.za. If this message contains offensive, derogatory or defamatory statements or materials, it means the message has been sent outside the sender's scope of employment with FRSTIA and only the sender can be held liable in his/her personal capacity. --- 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
RE: [U2] Does anybody have a hot backup server?
Hi, Under Universe/Linux we use Data Replication Block Device. www.drbd.com (open source linux product) A low level software called between logical partition and hdd partition. Cluster over LAN. We define it on partitions where Universe db is installed (including universe himself). On the hot-standby server, the same partition is created and not mounted (universe is not started ~ for this raison, we don't need IBM's license) On fail-over, we switch the ip adress to the hot-standby server, we mount the partition, we boot uv and users can work ... 2 minutes. One restriction, we don't use DYNAMIC files because the headers are not permanently flushed when write occurs files. Coupled with Universe Transaction Logger set on strategic files to ensure record update integrity. My two pence. Manu -Message d'origine- De : owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] De la part de Jeff Powell Envoyi : mercredi 18 mars 2009 20:07 @ : u2-users@listserver.u2ug.org Objet : [U2] Does anybody have a hot backup server? I am trying to put together a backup strategy that involves keeping a standby server within two data hours of the primary. The idea is to be able to have users log into the backup server and keep the business running in the event of a crash. I'd like to hear what solutions others have found for this. I've been trying to contact IBM for the last 6 months but they haven't answered and my ERP vendor doesn't know how to do this. Any ideas are appreciated. TIA --- 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 triggers (still more)
Hello Susan, It seems that the SetDiagnostics() is a Function, you must use VAR=SetDiagnostics('errtxt') (I have not tested it into a trigger set on a non-SQL file !) If I want to refuse the update into the trigger, I make : newrec = oldrec. This don't change the record and don't crash the program :-) You must set the trigger on event UPDATE and time BEFORE. My two pence. Manu -Message d'origine- De : [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] De la part de Susan Joslyn Envoyi : lundi 1 dicembre 2008 17:16 @ : u2-users@listserver.u2ug.org Objet : [U2] Universe triggers (still more) Hi everyone, I have the triggers working - yay! Thanks Manu! - but now I'm to the next step, and of course stumbling again! My program sets a flag when it wants to disallow the write that called the trigger. The manual seems to suggest that I could use SetDiagnostic to fail this . but I'm not even getting my program to compile and can't find further information on the syntax of that command. Anyone know how to tell the trigger to refuse the write? Susan --- 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 triggers (still more)
Hi, Thanks Susan for the resume of the method. From IBM U2U UK, I read announcement for new Rapid Triggers on Universe 10.3 (or 11) ; I receive no specs but I hope the new implementation consider theses stuffs. Regards. Manu. -Message d'origine- De : [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] De la part de Susan Joslyn Envoyi : mardi 2 dicembre 2008 14:16 @ : u2-users@listserver.u2ug.org Objet : Re: [U2] Universe triggers (still more) Thanks to the folks who gave me info on Unidata triggers. I've had those implemented for years and they do work very simply and well. Universe has been a whole different ballgame. It turns out that Universe has cleverly adapted the triggers from SQL. I say cleverly because it probably really is on some esoteric mathematical level. And certain from a viewpoint of 'using what you have'. But for an old Pickie like me it has been very foreign. Also they have made use of the Begin Transaction business - so that the writes can be rolled back using that existing logic, I reckon. Again, good re-use. But this is also an area that I'm not familiar with. The three problems that I had were with: 1) The SB+ COMMON block - this was resolved by adding $OPTIONS PICK to the trigger program - and to all the programs down the line that it called. 2) WRITES requiring locks: The Begin Transaction relies on a system variable called ISOMODE which can be set to 0,1 or 2 to control how rigorous the locking requirements are - as part of the 'transaction/rollback' stuff. I was able to get my programs working by making sure I had a READU before each WRITE (which I didn't have in some cases - where I had decided in my own wisdom that it was safe not to do it - audit logs, new items, etc.) but I can't get into the SB+ code and the authors thereof were also of this same wisdom. But it turned out that by using Uniadmin to set ISOMODE to 0, this problem was alleviated. 3) Last, I wanted to be able to control whether the write should occur. I can do it - the manual was not clear on the syntax and I kept thinking there was something more, but apparently as long as I put: DUMMY = SetDiagnostics(This message is about why the item cannot be written), the trigger will fail the write and display that message. I don't display that message, I don't use the variable DUMMY, I don't set any particular flag. The display and the failure to write is not pretty. 4) One thing I cannot overcome is that the triggers in Universe will not permit any interaction. So my program can't explain to the user why it doesn't think they should write and then allow them to make a decision. It throws them back into their item, though, so I guess they can save the item somewhere else or something from there. Again, thanks to Manu in particular who has obviously fought the exact same battle - and to those of you who offered up the how to in Unidata. You are so lucky you are doing it in Unidata! Hope this helps someone else, some day. Susan Joslyn SJ+ Systems Associates, Inc. PRC(r) Complete software development life-cycle management for U2. --- 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] Printing Graphics from UniVerse
Hi, We build postscript file from within universe, then we can spool it or convert to pdf,pcl, Contact me by private for details. Manu -Message d'origine- De : [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] De la part de Adam Taylor Envoyi : lundi 1 dicembre 2008 22:50 @ : u2-users@listserver.u2ug.org Objet : [U2] Printing Graphics from UniVerse Hey folks, I've got a multi-part question. Does anyone have a good method of printing graphics from UV programs other than the 2-bit black and white? We'd like to expand into color logos on some of our document and wanted to know if anyone had come up with a method of including those on reports/invoices/etc. As well, does anyone have a good method of printing graphics and reports to file instead of to hardcopy? Obviously we can print straight text to the HOLD file, but we'd also like to include graphics in some documents we print to file. Thanks. Adam Taylor Sr. Programmer Analyst INX Inc. 6401 Southwest Freeway Houston, Texas 77074 Phone: 713/795-2352 [EMAIL PROTECTED] --- 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] PCL Help
Hi, Add (Esc)k2G in your init PCL sequence. To instruct the printer LF=CRLF Manu -Message d'origine- De : [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] De la part de Caminiti, Marc Envoyi : vendredi 28 novembre 2008 17:28 @ : u2-users@listserver.u2ug.org Objet : [U2] PCL Help I was wondering if anyone could help We recently upgraded to Universe 10.2.7 on Red Hat Enterprise Linux 5.2 and are now having problems printing out compressed reports on a HP LaserJet 4050 For the compressed reports, I send the PCL codes to switch the printer to landscape and to compress to 17cpi. When the report prints, it is only printing the first line of data and nothing else. It is compressing and in landscape. If I send it to a file, all of the data is there. Below is what is being sent. The only thing that is printing is the MC 10:41:09am 28 Nov 2008 BIKE NASHBAR PAGE 1 Within RedHat (CUPS) the make Model is Local Raw Printer. Even when I try without any compression codes, it only prints the first line of data. When I have the RedHat (CUPS) make model to HP LaserJet 4050, the non-compressed/non-landscaped print, prints fine. But when I try and send the PCL codes, it just spits out plan sheets of paper. Any suggestions will be greatly appreciated. Already spend 3 1/2 hours of different combinations and cannot come up with anything that works. Thanks in advance Marc l1O(s22H MC 10:41:09am 28 Nov 2008 BIKE NASHBAR PAGE 1 DAILY PURCHASING REPORT AS OF 28 Nov 2008 BYR PGC ITEM NUMBER. DESCRIPTION QAV.. QOR. QOH.. ONORD DLD.. WK1.. WK2.. WK3.. WK4.. YACT YTD LY DMD.. MSRP $ CAT $. WEB $. LAST. EXT'D COST MARGIN PO #'S. VEND# ST INV PIC. LS. COST. LIFE TKV N IS-TEST2-A BLAH 0 0 0 0 0 0 0 0 0 0 2.50 2.500 *** 0.500 0.000 80.00% A JB N IS-TEST-DEVON IS TEST SKU 0 0 0 0 0 0 0 0 0 0 2.00 2.000 2.00 0.001 0.000 99.95% 6103 A TKV N IS-TEST-JIM IS TEST SKU 0 0 0 0 0 0 0 0 0 0 2.00 2.000 2.00 0.001 0.000 99.95% 6103 A JB N IS-TEST-MARC IS TEST SKU 0 0 0 1 05/15 0 0 0 0 0 0 0 2.00 2.000 2.00 0.001 0.000 99.95% 20325 9 A 1 03/31 20390 6103 1 10/21 21120 6103 1 07/09 6103-12 6103 3 1 11/03 6103-MC 6103 1 11/19 6103MAR 6103 C TKV N IS-TEST-TAMMY IS TEST SKU 0 0 0 0 0 0 0 0 0 0 2.00 2.000 2.00 0.001 0.000 99.95% 6103 A *** 0 0 0 6 0 0 0 0 0.000 Marc Caminiti IS Manager Nashbar Direct, Inc 6103 State Route 446 Canfield, OH 44406 330.533.1989, ext 336 330.702.9733, fax Reality is merely an illusion, albeit a very persistent one CONFIDENTIALITY NOTICE: This e-mail and any attachments may contain confidential information that is legally privileged. The information is solely for the use of the intended recipient(s). Any disclosure, copying, distribution, or other use of this information is strictly prohibited. If you have received this e-mail in error, please notify the sender by return e-mail and delete this message. --- 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] Remote backup
Hi, Me too, I use uvbackup to perform backups. I have a little BASIC prog called UV.MULTI.BACKUP whoch select all UV.ACCOUNT and create a uvbackup file per account. I start the BASIC program from a Windows .bat / unix script Scheduled on Windows Task Manager / crontab like this : UVHOME= PATH=... ; %UVHOME% Cd %UVHOME% Uv UV.MULTI.BACKUP params... Xcopy *.uvb \\server\... UVHOME= PATH=... :$UVHOME Cd $UVHOME Uv UV.MULTI.BACKUP params... Xcopy *.uvb \\server\... Rsync *.uvb serveur:path.. I'm ready to share this UV.MULTI.BACKUP. Manu -Message d'origine- De : [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] De la part de Augusto Alonso Envoyi : jeudi 27 novembre 2008 11:16 @ : u2-users@listserver.u2ug.org Objet : [U2] Remote backup Hi All. I have a variety of Universe servers running in a variety of Unix and windows flavours. I'm facing the problem to manage unattended daily scheduled backups of it. I need to keep the copy, out of the Universe server. It is impossible to design a universal sollution, but all my servers have a common utility: uvbackup. My question is, does anybody knows the way to run uvbackup dumping to a remote device? So that, I could hold the uvbackup image on a small Linux box or eventually send it to some internet-backup-server. TIA -Augusto Alonso --- 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 triggers + SB+
Hi, Yes, a trigger starts a automatic BEGIN TRANSACTION !! With SB+, this is a trouble I suffer too, I've already submited to IBM to request a ISOMODE enforcement of SB+ internals subroutines. The IBM's doc says **we recommend that you modify any transactions that do not follow this rule as soon as possible** ; but The shoemaker is always the worst shod. Yes, there is a uvconfig param to change it : ISOMODE ( UV docs, Basic ref - Isolation levels - ISOMODE ) If set to 0, you don't need to acquire the READU lock before WRITE/DELETE !! (be carefull with it)) Manu Using the ISOMODE Configurable Parameter The ISOMODE parameter controls the minimum locking requirements for each UniVerse system. By enforcing a minimum level of locking, the transaction management subsystem guarantees that no transaction suffers a lost update due to the actions of another transaction. Protection against lost updates is an important property of serializability. You can set ISOMODE to one of the following settings: ISOMODE Settings Setting Description 0 Provides backward compatibility. Transactions are not required to use well-formed writes. 1 Enforces well-formed writes in UniVerse BASIC transactions. This is the default. 2 Enforces well-formed writes in UniVerse BASIC programs, whether or not they are in a transaction. The default ISOMODE setting 1 ensures that BASIC transactions obey the locking rules for isolation level 1, as described in the following table. This means a record cannot be written or deleted in a transaction unless the record or file is locked for update. A write or delete of a locked record is known as a well-formed write. ISOMODE setting 0 provides compatibility with earlier UniVerse releases that did not enforce the requirement for well-formed writes in transactions. Since transactions should always use well-formed writes, we recommend that you modify any transactions that do not follow this rule as soon as possible, so that you can set ISOMODE to 1. Setting ISOMODE to 2 enforces all writes and deletes in UniVerse BASIC to be well-formed. This mode is available so that when converting an application to use transactions, you can determine whether any programs have not yet been converted. You should not use ISOMODE 2 permanently since many UniVerse system programs are not (and need not be) transactional. -Message d'origine- De : [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] De la part de Susan Joslyn Envoyi : mercredi 26 novembre 2008 11:26 @ : u2-users@listserver.u2ug.org Objet : RE: [U2] Universe triggers + SB+ Manu, You are a life-saver! Thank you! I didn't know about $OPTIONS PICK and that truly solves the problem! Which took me to the next problem. The trigger program appears to be much more rigorous about record locks. That's fine for code that I can get to, but it announces that I don't have the record locked for stuff that's happening inside SB+ that I can't get to. Is there a way loosen up these constrictions? Program UV.ED: pc = 73EC, Program SB.GEN.DRIV.I: Line 793, FATAL: The locks necessary for database operations at the current isolation level (0) are not held by this process. Susan Date: Tue, 25 Nov 2008 19:43:20 +0100 From: Manu Fernandes [EMAIL PROTECTED] Subject: Hi, Do you use the $OPTIONS PICK into the basic code before INCLUDE DMSKELCODE COMMON ? My two pence. Manu -Message d'origine- De : [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] De la part de Susan Joslyn Envoyi : mardi 25 novembre 2008 18:10 @ : u2-users@listserver.u2ug.org Objet : [U2] Universe triggers + SB+ Has anyone successfully enabled Universe trigger programs that call SB+ enabled programs? I'm getting COMMON mis-match and other errors. TIA, Susan Joslyn --- --- 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 triggers + SB+$ OPTIONS PICK
Hi, About $OPTIONS PICK, Yes it is important - to fix, we put it into the DMSKELCODE COMMON record ; on the first line - before COMMON statement. SB+ is PICK flavor compiled . On certain site, we have SB+ running under INFORMATION flavor account (backward compatibility of old application mixed with SB+ UI. To be in ad equation with SB+, the new basic code must be (force) compiled under PICK FLAVOR. Manu -Message d'origine- De : [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] De la part de Susan Joslyn Envoyi : mercredi 26 novembre 2008 11:26 @ : u2-users@listserver.u2ug.org Objet : RE: [U2] Universe triggers + SB+ Manu, You are a life-saver! Thank you! I didn't know about $OPTIONS PICK and that truly solves the problem!snip --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe triggers + SB+$ OPTIONS PICK
Hi, Yes, SB+ work with DIM arrays. The difference between PICK/PI DIM arrays is the ability to redimension an array at runtime (PICK arrays are DIMed at compile time). Dimensioned arrays are allocated either at compile time or at run time, depending on the flavor of the account (or compile $OPTIONS FLAVOR directive). Arrays allocated at run time are called standard arrays. Arrays allocated at compile time are called fixed arrays. Standard arrays are redimensionable; Fixed arrays are not redimensionable and do not have a zero element. All arrays are standard unless the program is compiled in a PICK, IN2, or REALITY flavor account, in which case they are fixed arrays. To use fixed arrays in PIOPEN, INFORMATION and IDEAL flavor accounts, use the STATIC.DIM option of the $OPTIONS statement. To use standard arrays in PICK, IN2, and REALITY flavor accounts, use $OPTIONS bSTATIC.DIM Both vectors **var(n)** and matrices **var(n,n)** have a special zero element that is used in MATPARSE statement, MATREAD statements, and MATWRITE statements. The zero element of a vector is specified by vector.name(0), and the zero element of a matrix is specified by matrix.name(0,0). Zero elements are used to store fields that do not fit in the dimensioned elements on MATREAD or MATPARSE statements. My two pence. Manu -Message d'origine- DeB : [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] De la part de Anthony Youngman EnvoyC)B : mercredi 26 novembre 2008 15:48 CB : u2-users@listserver.u2ug.org ObjetB : RE: [U2] Universe triggers + SB+$ OPTIONS PICK Does the common contain dimensioned arrays? Quite likely, I would have thought. And that would be why you need OPTIONS PICK. Ideal-flavour UV uses PI- style arrays which have an element (0). Pick-style arrays don't. I think there may also be something to do with how many entries in the common table are taken up by an array. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Manu Fernandes Sent: 26 November 2008 12:47 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe triggers + SB+$ OPTIONS PICK Hi, About $OPTIONS PICK, Yes it is important - to fix, we put it into the DMSKELCODE COMMON record ; on the first line - before COMMON statement. SB+ is PICK flavor compiled . On certain site, we have SB+ running under INFORMATION flavor account (backward compatibility of old application mixed with SB+ UI. To be in ad equation with SB+, the new basic code must be (force) compiled under PICK FLAVOR. Manu -Message d'origine- De : [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] De la part de Susan Joslyn Envoyi : mercredi 26 novembre 2008 11:26 @ : u2-users@listserver.u2ug.org Objet : RE: [U2] Universe triggers + SB+ Manu, You are a life-saver! Thank you! I didn't know about $OPTIONS PICK and that truly solves the problem!snip --- 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 triggers + SB+
Hi, Do you use the $OPTIONS PICK into the basic code before INCLUDE DMSKELCODE COMMON ? My two pence. Manu -Message d'origine- De : [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] De la part de Susan Joslyn Envoyi : mardi 25 novembre 2008 18:10 @ : u2-users@listserver.u2ug.org Objet : [U2] Universe triggers + SB+ Has anyone successfully enabled Universe trigger programs that call SB+ enabled programs? I'm getting COMMON mis-match and other errors. TIA, Susan Joslyn --- 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] Convert AREV/Paint definition to SB+
Hi, I'm in contact with a site where a package written in AREV is running under Universe/NT. They are using AREV/PAINT tool to draw screen input. AREV/PAINT seems to be near of SB+ concept. Is there someone with experience to port AREV/PAINT definition to SB+ ? Thanks for any advice. Manu Fernandes --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Pentaho/ETL Tools [ad]
Hi, [ Does anyone have ETL tools in mind that natively talk to Unidata?] Not exactly Talk to Unidata ... Use Unidata to prepare tables/columns. At Infodata, we have our in-house ETL, written in SB+ and BASIC routines running under Unidata, Universe, D3. All definition's interfaces are in SB+, you define tables/columns from u2files and SB+ Expression (direct field or derived field) easily from am, vm, svm levels. The system generate SQL statements into script.sql files to create table on a sql datawarehouse Script.sql files are routed and submitted to sql Datawarehouse. We have experience with UniverseSQLSchema,DB2, MS-SQL, mySQL, Oracle. At runtime, some Basic routines extract data from u2files and create script.sql (INSERT,UPDATE,DELETE). You can specify a scheduled extraction, full, conditionnal, you can have incremental if triggers are set. Simple, easy, . If you are interested please reply to [EMAIL PROTECTED] (remove antispam.) Manu Fernandes Infodata-group.eu -Message d'origine- De : [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] De la part de Jeff Butera Envoyi : samedi 15 novembre 2008 04:45 @ : u2-users@listserver.u2ug.org Objet : [U2] Pentaho/ETL Tools We're in the midst of creating a data warehouse from our UniData databases and exploring the possibility of using Pentaho. Their ETL tool does have an entry for Universe (not Unidata), but the connection methods are JDBC, ODBC or JNDI. We don't want to create an SQL-view of Unidata merely for ETL, we'd prefer to find an ETL tool that can natively talk with Unidata. Has anyone worked with Pentaho? Any thoughts? Does anyone have ETL tools in mind that natively talk to Unidata? Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 But Dad, I'm not listening to you. Catherine Butera --- 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] uv account
Hi, Check the UV VOC LOGIN record. There must be a line MOTIF SYSADM.MENU Usually add a test like this before MOTIF to avoid the menu on these conditions. IF @TTY = 'phantom' THEN GO END.OF.LOGIN IF @TTY = 'uvcs' THEN GO END.OF.LOGIN Also, you can create a VOC MENU entry : 000 MENU 001 PA 002 MOTIF SYSADM.MENU Or start at TCL MOTIF SYSADM.MENU Regards. Manu -Message d'origine- De : [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] De la part de doug chanco Envoyi : jeudi 4 septembre 2008 16:52 @ : u2-users@listserver.u2ug.org Objet : [U2] uv account hey all, on my linux system when I logto UV I get the uv maint. menu (you know with categories at the top -- create account ,etc, etc, etc.) anyway on our aix system when I logto uv I get to TCL and for the life of me cannot figure out how to get that menu to come up and the admin document ONLY talks about the windows admin tool uniadmin (this has been an issue with me as they should also cover the non GUI ways of administering universe, what happens if you need to admin universe from the system console and cannot access it via a windows PC anyway I digress) can anyone share the secret of getting the universe admin menu to come up from TCL in the UV account? thanks dougc --- 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: DQM (was [U2] Using ETL to extract data from UD to SQL)
Hello, My 2 pences. We use SQL dbms as datawarehouse repository where we put all our U2 datas (Uv,Ud) but also XLS sheet, MDB files, other sql db, ... We use standard client tool like BusinessObject, Cognos, HummingbirdBI to request datawarehouse. To prepare U2 datas, we have a in-house tool written in SB+:U2 ETL 1 - we define table (sql image) regarding a u2file-monovaluedfields and/or a u2file-assocmultivaluedfields 1.1 - the system build sql statement CREATE TABLE, DROP TABLE,... 2 - for each field/column we extract/transform field value to column value datatype conformity, decomposition of multipart field via SB+ expressions or I-Types. 2.1 - the system do it for each level - am, vm, svm 2.2 - the system build sql statements INSERT, UPDATE, DELETE, .. CREATE INDEX ... 4 - for each tables an columns we define meta data for human readability (table/column label, shot/long description, relational model) For performance, all SQL statements are set into a sequential file and are routed to the datawarehouse dbms via OS-script. We have scheduler to refresh fully, incrementally, conditionally, ... We can adress all SQL db system as datawarehouse ; done for mySQL, ms-sql, Oracle, DB2 A sample of usage : 12 productions sites for one company , on each site there is one unidata server (ux win). On each one we deploy the U2 ETL defn and Extract scheduler. Each night, extract data and build sql statement in a txt file, these text file is ftp'ed to the HQ site. On the HQ, we've one datawarehouse server (mysql), it receive all text file and load it into datawarehouse for consolidation. Another sample: One server - ud ! uv; 20 accounts (20 instance of the same application) Only one ETL defn (file to table, fields to column;) define n-source datafiles (account,datafile(s)) Extract from all datafiles-source and load it into one datawarehouse repository. Very easy to use, very powerfull. Deployment is independent of applications accounts; U2 ETL it is a autonomic account. Manu -Message d'origine- De : [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] De la part de Clifton Oliver Envoyi : vendredi 9 mai 2008 07:39 @ : u2-users@listserver.u2ug.org Objet : DQM (was [U2] Using ETL to extract data from UD to SQL) I wanted to change the subject line to see is we Listizens have any interest in discussing Data Quality Management. How do you cleanse MultiValue non-typed data for integration with strongly datatyped non-MV applications? Anyone want to kick off the discussion? Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On May 8, 2008, at 6:00 PM, Boydell, Stuart wrote: nd dirty data to get to a set of data suitable for your DW/reporting requirements. --- 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] {Blocked Content} RE : [U2][UV] User/Port history
Warning: This message has had one or more attachments removed Warning: (not named). Warning: Please read the AngelicHost-Attachment-Warning.txt attachment(s) for more information. hi, I do it with a little BASIC called at login user. ED BP B.ACCLOG OPEN 'DICT ACCLOG' TO DF ELSE STOP OPEN 'ACCLOG' TO F ELSE STOP READU NEXTID FROM DF,'NEXT.AVAILABLE' ELSE NEXTID = 0 LOOP NEXTID +=1 WHILE READ BUF FROM F,NEXTID DO REPEAT WRITE NEXTID ON DF,'NEXT.AVAILABLE' LOG = @DATE LOG2 = @TIME LOG3 = @USERNO LOG4 = @LOGNAME LOG5 = @TTY * and whatyou want... WRITE LOG ON F,NEXTID END BASIC it CATALOG BP *ACCLOG B.ACCLOG place it into UV VOC UV.LOGIN 001 PA 002 *ACCLOG Regards. Manu De: [EMAIL PROTECTED] de la part de [EMAIL PROTECTED] Date: ven. 25/04/2008 21:39 @: u2-users@listserver.u2ug.org Objet : [U2][UV] User/Port history Hello all! Is there anywhere in uniVerse that keeps a history of which users have been logged in on which ports? Basically, I'm looking for something equivalent to the old ACC file in the Pick world. I'm trying to track down some software/licensing issues, and to do so I need to know who the last person was that was on a particular port. Note that I'm talking UV ports here, not unix ports. Any help would be appreciated - even if it's someone telling me no such thing exists so that I stop looking. Thanks! Brian F. Paige Serta International [EMAIL PROTECTED] Direct line: 847-747-0451 Internal extension: 2051 Fax: 847-747-0551 _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material not intended for Public use. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this communication in error, please notify the sender and delete the material from any and all computers or devices. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This is a message from the MailScanner E-Mail Virus Protection Service -- The original e-mail attachment winmail.dat was believed to be infected by a virus and has been replaced by this warning message. If you wish to receive a copy of the *infected* attachment, please e-mail helpdesk and include the whole of this message in your request. Alternatively, you can call them, with the contents of this message to hand when you call. At Sat Apr 26 08:56:53 2008 the virus scanner said: Could not parse Outlook Rich Text attachment Note to Help Desk: Look on the AngelicHost MailScanner in /home/virtual/site2/fst/var/spool/mail.quarantine/20080426 (message m3QFulu7001615). -- Postmaster --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UV - XDOM - XPath - loop on nodes from xPath criteria ?
Hi, I'll use Universe's XDOM functions and I don't understand how to work with multiple xml nodes within a xPath result. Into XDOMLocate I can use xPath like /bookstore/book[price50.00]' ; it return a nodehandle to the first node which is ok with condition but when I have many nodes I don't understand how to loop on all nodes Any idea, experiences ? Thanks by advance Manu -- Here is the XML Sample store into XML booktore.xml. ?xml version=1.0 encoding=ISO-8859-1? bookstore book title lang=frHarry Potter/title price29.99/price typepaper/type /book book title lang=engLearning XML/title price39.95/price typepdf/type /book book title lang=frDracula/title price18.50/price typepaper/type /book /bookstore I try this basic code to extract information. Status = XDOMOpen('bookstore.xml',XML.FROM.FILE,XDDO) if Status # XML.SUCCESS then stop Status = XDOMLocate(XDDO,'/bookstore/book[price30.00]',,XBOOKS) *this must return 2 nodes Loop xml = Status = XDOMWrite(XBOOKS,xml,XML.TO.STRING) CRT book xml : :xml while status = XML.SUCCESS do Status = XDOM what to get the next node which is ok with the xpath condition ? repeat end --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [uvrestore] - help with a couple errors..
Hi, 1) You can/must use the uvrestore option -F origpath=destpath if the destination path is different from original. 2) You must be defined as uvbackup/uvrestore userid authorized into UV UV.ACCESS UVBACKUP 001 domain\userid My two pence. Manu -Message d'origine- De : [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] De la part de LuckY07 Envoyi : mercredi 30 janvier 2008 21:03 @ : u2-users@listserver.u2ug.org Objet : [U2] [uvrestore] - help with a couple errors.. I am trying to test the uvbackup/uvrestore and I can build the backup image using: path = %path%;c:\IBM\UV\bin uvbackup -f -v -s c:\BACKUP\backuptest\backup.log -walk c:\CHRIS c:\BACKUP\backuptest\backup.dat I am trying to restore this image to a BLANK region/account and get a couple errors/warnings: WARNING: Error encountered creating file 'c:\ROGER/CHRISREPORT'. Parent directory does not exist or privileges are not sufficient for creating path to file. File not restored. Restoring c:\ROGER/CHRISSECURITY (10:59:26) WARNING: Unable to write block at address 0x800. WARNING: Unable to complete group update operation! The current group may be incomplete or corrupted and should be examined by the 'fixtool' utility. Further operations to this file may be questionable! Enter 'C' to retry gaining exclusive group lock. Any other key will SKIP the restoration of THIS group AND the remainder of the file:Unable to write item MTN. --- --- Restoring c:\ROGER/CHRISVOC (10:59:26) WARNING: Error encountered creating file 'c:\ROGER/CHRISVOC'. Parent directory does not exist or privileges are not sufficient for creating path to file. File not restored. WARNING: Error encountered creating file 'c:\ROGER/I_AGE01/INDEX.000'. Parent directory does not exist or privileges are not sufficient for creating path to file. File not restored. Restoring c:\ROGER/I_AGE01/INDEX.001 (11:02:42) --- -- View this message in context: http://www.nabble.com/-uvrestorehelp- with-a-couple-errors..-tp15188081p15188081.html Sent from the U2 - Users mailing list archive at Nabble.com. --- 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] question..
Re, LOGTO UV WHO{enter} :to see what is your domain\userid REVISE UV.ACCESS{enter} Function=UVBACKUP{enter} S2{enter} Type the number of line witout userid 4? {enter} Users=DomainNAME\CHRIS {enter} !! respect the CASE (check value with WHO ) {enter} {enter} {enter} back to TCL manu -Message d'origine- De : [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] De la part de LuckY07 Envoyi : jeudi 31 janvier 2008 15:56 @ : u2-users@listserver.u2ug.org Objet : [U2] question.. Manu, I appreciate the quick response. I was wondering how I can check this? I did this: CHRIS LIST UV.ACCESS and get: UVBACKUP uvadminREAD root WRITE NTAUTHORITY\system I want to add user 'CHRIS' to be user autheroized to do a UVRESTORE, any ideas? tks. -- View this message in context: http://www.nabble.com/-uvrestorehelp- with-a-couple-errors..-tp15188081p15206107.html Sent from the U2 - Users mailing list archive at Nabble.com. --- 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] should i do this..
Re, -F options of uvrestore require : Uvrestore -F c:\CHRIS=C:\ROGER A old release works with Uvrestore -F c:/CHRIS=C:/ROGER -F is also a filter to restore one file from uvbackup tape give the full path+filename Manu -Message d'origine- De : [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] De la part de LuckY07 Envoyi : jeudi 31 janvier 2008 15:58 @ : u2-users@listserver.u2ug.org Objet : [U2] should i do this.. should I change: c:\CHRIS=c:\ROGER to: .\CHRIS=.\ROGER thanks :) -- View this message in context: http://www.nabble.com/-uvrestorehelp- with-a-couple-errors..-tp15188081p15206153.html Sent from the U2 - Users mailing list archive at Nabble.com. --- 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] VMWare Server (free) Product - UV virtualization?
Hi, Yes, I use the VMWARE with uv-linux and uv-windows on different vm but only for development, training, demo, test and db convertion. I have linux host for dev and training session and windows-XP host (my workstation) for dev - test - demo - db convertion. Not on production with many users. It works good, the performance depends on ram allocate to vm and host power - A linux host seems more powerful like a windows host. My 2 pence. Manu -Message d'origine- De : [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] De la part de Gabriel Green Envoyi : mardi 29 janvier 2008 11:11 @ : u2-users@listserver.u2ug.org Objet : [U2] VMWare Server (free) Product - UV virtualization? Hi all: Was wondering if anyone has had any luck running VMWare Server (their free Virtualization product which runs on top of Windows or Linux) to run multiple instances of UV on one piece of hardware. Any performance issues? We're going to do an experiment shortly with a powerful server and see how it performs... What about the free ones (Xen, etc) ESX is tasty, but pricey... Gabe --- 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] [UV/NT] T.LOAD from d3/T-DUMP pseudo floppy diskfile
Hi Dave, Thanks for your reply. When I want to transfer a full account, I perform a account-save to a pseudo tape and then on universe I use D3RESTORE which work good. In this case, I got a pseudo tape with a t-dump structure and for it there is no tool into universe. I can look into the code of D3RESTORE and transform it to a D3TLOAD but before do it I search the community for any advice. I'm surprised that nobody use diskfile as a pseudotape, when I read the uv's doc I understand that must be possible but how to define it ? Regards. Manu -Message d'origine- De : [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] De la part de Dave Taylor Envoyi : mercredi 12 dicembre 2007 03:17 @ : u2-users@listserver.u2ug.org Objet : Re: [U2] [UV/NT] T.LOAD from d3/T-DUMP pseudo floppy diskfile AD - Original Message - From: Manu Fernandes [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, December 10, 2007 10:09 AM Subject: RE: [U2] [UV/NT] T.LOAD from d3/T-DUMP pseudo froppy diskfile Right, But which value to use on which field ? Thanks Manu snip Manu, I am not aware of any way to create a virtual floppy disk on UV/NT, either directly or using UniAdmin. I've tried to do it with UniAdmin and failed because UniAdmin expects an Operating System device, like a physical tape drive or floppy disk drive, and there is none in a virtual floppy disk. Perhaps someone else on the list has the answer. We use three tools for transferring software from generic Pick databases to Universe and Unidata: 1.the d3conv program pre-processes a virual d3 account save into a record that can be restored onto a Universe account using the Universe uvrestore program. 2.AD Our File Caddy programs, TAPE-DUMP and TAPE.LOAD, create multiple T-DUMPs (your choice of any one file to all the files on an account) and then T-LOADs each file onto a Universe account, creating the file as it goes if it does not already exist on the account. /AD Also, mvBase supports virtual files that can have a BLOCK-SIZE of 500. I haven't tried it, but you might be able to T-LOAD a virtual d3 floppy disk file onto an mvBase virtual tape file, but then you will still have to get it from mvBase to Universe. 3. If you are talking just about 1 file or a few files, and if you have access to the machine on which it resides today, I would use either Accuterm or Dynamic Connect/wIntegrate to move the data and/or dict sections of that one file to Universe. If you don't have access to the machine on which this file exists, I would try restoring it onto mvBase and then using Accuterm or Dynamic Connect/wIntegrate to move it to Universe. If you have more than one account, please feel free to contact me off- line if you would like to consider using either d3conv or TAPE.DUMP and TAPE.LOAD, with or without the intermediate transfer to mvBase. AD We also offer SpoolerPlus, our generic Pick print spooler for Universe and Unidata, to eliminate the need to rewrite all the print commands embedded in your D3 (or any generic Pick) software to Universe print commands and giving up your generic Pick print spooler functionality. /AD hth, Dave Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com --- 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] [UV/NT] T.LOAD from d3/T-DUMP pseudo froppy diskfile
Hi group, I've got a diskfile result of a T.DUMP from d3 /pseudo floppy. I'll load it in to my Universe/Windows via the T.LOAD but I need to build a DEVICE entry to describe my pseudo tape. I don't found how to do it ! Any advice are welcome. Thanks. Manu --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV/NT] T.LOAD from d3/T-DUMP pseudo froppy diskfile
Hi, Thanks you very much. It's better but only on Linux ... :-( On UV/Windows I get this : Error, cannot access floppy drive (87). I progress. Manu -Message d'origine- De : [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] De la part de Antonio C. Nobrega de Oliveira Envoyi : lundi 10 dicembre 2007 16:31 @ : u2-users@listserver.u2ug.org Objet : Re: [U2] [UV/NT] T.LOAD from d3/T-DUMP pseudo froppy diskfile Hi Manu, First make sure to T-DUMP your diskfile without compression. Here is my DEVICE definition: ED DEVICE ARQUIVO 19 lines long. : P 0001: comment=para t-dump / t-load 0002: /o04/pick/ARQUIVO 0003: 500 0004: F 0005: 0006: /o04/pick/ARQUIVO 0007: /o04/pick/ARQUIVO 0008: 0009: 0010: 0011: tape rewind $tape 0012: tape rewind $tape 0013: 0014: 0015: 0016: 500 0017: 0018: 0019: Bottom at line 19. : Now you can do: ASSIGN ARQUIVO TO MTU 0 T-REW T-LOAD your file UNASSIGN ARQUIVO Good luck Antonio Carlos Departamento TC)cnico Integral Sistemas Telefone 11 3205-6000 - Fax 11 3205-6001 www.integral.com.br __ GPG signed/encrypted mail welcome. OpenPGP ID: 0xC1FD2134 Fingerprint: 294C DF90 1648 D58B C279 0C9A 46B9 7DE2 C1FD 2134 Manu Fernandes wrote: Hi group, I've got a diskfile result of a T.DUMP from d3 /pseudo floppy. I'll load it in to my Universe/Windows via the T.LOAD but I need to build a DEVICE entry to describe my pseudo tape. I don't found how to do it ! Any advice are welcome. Thanks. Manu --- 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] [UV/NT] T.LOAD from d3/T-DUMP pseudo froppy diskfile
Right, But which value to use on which field ? Thanks Manu -Message d'origine- De : [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] De la part de Kathleeni M Hunter Envoyi : lundi 10 dicembre 2007 18:30 @ : u2-users@listserver.u2ug.org Objet : RE: [U2] [UV/NT] T.LOAD from d3/T-DUMP pseudo froppy diskfile On windows use UV Admin tools to setup the devices. -Original Message- From: Manu Fernandes [mailto:[EMAIL PROTECTED] Sent: Monday, December 10, 2007 8:29 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV/NT] T.LOAD from d3/T-DUMP pseudo froppy diskfile Hi, Thanks you very much. It's better but only on Linux ... :-( On UV/Windows I get this : Error, cannot access floppy drive (87). I progress. Manu -Message d'origine- De : [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] De la part de Antonio C. Nobrega de Oliveira Envoyi : lundi 10 dicembre 2007 16:31 @ : u2-users@listserver.u2ug.org Objet : Re: [U2] [UV/NT] T.LOAD from d3/T-DUMP pseudo froppy diskfile Hi Manu, First make sure to T-DUMP your diskfile without compression. Here is my DEVICE definition: ED DEVICE ARQUIVO 19 lines long. : P 0001: comment=para t-dump / t-load 0002: /o04/pick/ARQUIVO 0003: 500 0004: F 0005: 0006: /o04/pick/ARQUIVO 0007: /o04/pick/ARQUIVO 0008: 0009: 0010: 0011: tape rewind $tape 0012: tape rewind $tape 0013: 0014: 0015: 0016: 500 0017: 0018: 0019: Bottom at line 19. : Now you can do: ASSIGN ARQUIVO TO MTU 0 T-REW T-LOAD your file UNASSIGN ARQUIVO Good luck Antonio Carlos Departamento TC)cnico Integral Sistemas Telefone 11 3205-6000 - Fax 11 3205-6001 www.integral.com.br __ GPG signed/encrypted mail welcome. OpenPGP ID: 0xC1FD2134 Fingerprint: 294C DF90 1648 D58B C279 0C9A 46B9 7DE2 C1FD 2134 Manu Fernandes wrote: Hi group, I've got a diskfile result of a T.DUMP from d3 /pseudo floppy. I'll load it in to my Universe/Windows via the T.LOAD but I need to build a DEVICE entry to describe my pseudo tape. I don't found how to do it ! Any advice are welcome. Thanks. Manu --- 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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] U2:UV: Dynamo
Hi all, Is there someone who have experience with Dynamo product under Universe 9 Unix ? I've a resurrected customer site (UV/AIX)) where I want to go on Linux, but Dynamo is not moveable. Thanks for any help, contact, advice. Manu --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [uv] SBClient - vt220 CHAR mode - How to colors ?
hello, Thanks for your advice. About the choice of SBClient, we plan a switch of the old application to SB+ step by step with, in the same run-time, oldBASIC and newSB modules. To start the project oldBASIC MUST run without SB+ (request from end-user) After test with advice of david, (loginto sb+) I receive colors under SB+ but no colors when I switch to oldBASIC. I'll try to flag ANSI colors in term emualtion like david suggest,... read the result on next thread Thanks Manu - Original Message - From: Kevin King [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, September 21, 2007 8:43 PM Subject: Re: [U2] [uv] SBClient - vt220 CHAR mode - How to colors ? Good advice David. I was merely pointing out that the information for what characters to send for which colors is in the SB+ terminal definition, but if Manu never logs in to SB+, that won't help. Then again, why would you use SBClient if you never login to SB+? Certainly you could save yourself some serious coin with other terminal emulation products? --- 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] [uv] SBClient - vt220 CHAR mode - How to colors ?
Hi all, I've a project to convert a old PICK basic application to Universe/NT. I want to use SBClient in character mode, with vt220 terminal emulation. (We build new modules with SB+.) In BASIC, I convert colors sequences like background black from @(-40) to @(-38,0) and so on for all colors. But SBClient don't display any colors Is there someone with experience or any advice Thanks. Manu --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [uv] SBClient - vt220 CHAR mode - How to colors ?
Hi, Precision, I do'nt login into SB+, I do'nt use it ! I'll use SBClient like a character based term emulator without SB+. SB+ interface is the next step ~future not defined. Thanks for help Manu - Original Message - From: David Murray [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, September 20, 2007 1:19 PM Subject: RE: [U2] [uv] SBClient - vt220 CHAR mode - How to colors ? Manu, What terminal definition have you setup within SB+ for the user/port? Definition VT220 in SB+ does not support colour. Definition TU.VT220 does support colour. You may have to tweak one of the existing SB+ terminal definitions to get the correct functionality required. Cheers, David Murray .learn and do .excel and share -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Manu Fernandes Sent: Thursday, September 20, 2007 4:28 AM To: u2-users@listserver.u2ug.org Subject: [U2] [uv] SBClient - vt220 CHAR mode - How to colors ? Hi all, I've a project to convert a old PICK basic application to Universe/NT. I want to use SBClient in character mode, with vt220 terminal emulation. (We build new modules with SB+.) In BASIC, I convert colors sequences like background black from @(-40) to @(-38,0) and so on for all colors. But SBClient don't display any colors Is there someone with experience or any advice Thanks. Manu --- 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] Question - retrieving file separation setting
Use the STATUS stmt FROM filevar OPEN yourfile TO F.DUMMY ELSE EXIT STATUS F.STATUS FROM F.DUMMY ELSE EXIT TYPE = F.STATUS21,1,1 IF TYPE 2 OR TYPE 18 THEN EXIT MODULO= F.STATUS22,1,1 SEPARATOR = F.STATUS23,1,1 Regards Manu -Message d'origine- De : [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] De la part de Allen Egerton Envoyi : vendredi 14 septembre 2007 05:00 @ : .U2 List Objet : [U2] Question - retrieving file separation setting In a Universe environment, (running either on Windows or *nix), does anyone know a fast way to determine the separation of a file? Type, Modulo, etc are easily returned via the FILEINFO function, but separation doesn't appear to be retrievable that way. Thank you. -- Allen Egerton aegerton at pobox dot com --- 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] : Cleaner Case Statement
Try this ON index('AB2',Ans,1) GOSUB Check.A, Check.B, Check.B Manu - Original Message - From: Brutzman, Bill [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, July 25, 2007 5:48 PM Subject: [U2] [u2] : Cleaner Case Statement How can this structure be cleaned-up? begin case case Ans = 'A' ; gosub Check.A case Ans = 'B' ; gosub Check.B case Ans = '2' ; gosub Check.B end case The following is more difficult to read. begin case case Ans = 'A' ; gosub Check.A case Ans = 'B' or Ans = '2' ; gosub Check.B end case I would like something like... begin case case Ans = 'A' ; gosub Check.A case Ans = 'B' case Ans = '2' ; gosub Check.B end case so that the gosub Check.B command is not repeated. I have tried a few alternatives without a victory. Suggestions would be appreciated. --Bill --- 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] UD Backups - DBPAUSE for UniVerse?
SUSPEND.FILES ON/OFF Manu - Original Message - From: Scott Richardson [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, July 04, 2007 6:54 PM Subject: Re: [U2] UD Backups - DBPAUSE for UniVerse? I have followed this thread with much interest. I have scoured the U2 / UniVerse documentation, but I see no DBPAUSE command or equivilent for UniVerse. Are there any commands with similar functionaility for UV, or does IBM have any plans to introduce such command equilivents in UV as currently exist in UD? For any Backup solution that uses the Microsoft VSS Snapshot functionality, or an Advanced Open File Manager option, would it be safe to say that for UD applications, they should issue the DBPAUSE command, grab a snapshot, then DBRESUME - *for each Backup requested*, to ensure optimal consistency of the Backup's integrity? Would it also be safe to say that for UV Applications, the only sure way to grab a consistent Backup of the UV environment would be when the UV Database is shutdown, or in a state where there are no users logged on and No PHANTOMs running? It would be nice if UV had the same operational level commands that UD has in this area. I would appreciate any insight on this. Happy Indepedence Day / Fourth of July to all. Thank you. Regards, Scott Richardson * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * Prime Information / UniVerse / Unidata / Sequoia PICK / mvBase Pr1me Computer \ Encore Computer Corporation \ Sequoia Systems * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * Senior Systems Engineer / Consultant Product Support Engineer * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * - Original Message - From: Stephen O'Neal [EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 8:16 PM Subject: RE: [U2] UD Backups Colin Alfke asked: Along that line - would there be anything else that may be holding up DBPAUSE? A cause of a slow response back from DBPAUSE is not enough disk drives under a system. When DBPAUSE is initiated, it flushes all of the UDT disk buffers to disk. If there is a lot of data waiting to be written, it can take a while. Another cause, is when a single disk drive is hot. Example: if a file, that has a lot of updates, is on a single disk drive. Optimally, files with a lot of updates should be striped across multiple disk drives. Steve Stephen M. O'Neal U2 Lab Services Sales Specialist Information Management, IBM Software Group --- --- 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] New UV system
Hi, You can run a 5 users of uv on a lite box (I do it on a notebook) Use W2003 server (W2003 is more demanding in ressource like UV, it can run on XP too ). To switch from sco to windows, you must use *uvbackup* tool into sco to prepare a file, then copy these file to windows and use *uvrestore* to restore the datas. (problem with special chars on unix vs windows)) There is a trouble with Type1 file, convert it to Type19 before copy. Under Windows, you must upgrade all your VOC entry where there is OS full path (check your datas eventually) I hope this help. Manu - Original Message - From: MAJ Programming [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, June 13, 2007 3:17 PM Subject: [U2] New UV system All: I have a client running UV on SCO on a 486/Pentium-1 looking box. They would like to move everything to a contemporary box. While I don't create systems, I would like some suggestions on which kind of W2000-class server to hold a 5 user version of UV. I don't want to switch databases to UD or D3 etc as the $ isn't there for the conversion (me). Unless absolutely imperative, I do not want a unix-based system. I would also be in the market for some phone-based assistance on the backup as it's done through an automated process in the UV app and I'm not that familiar with UV/UD backups or restores. One thing I would like would be to resize (down) most of the data files. I think it is a dds4 tape. I'm even game for a gently-used smaller system. Thanks in advance Mark Johnson --- 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] read secuencial a table
Hi, To read sequentially all records use : ic_open (file_id, dict_flag, filename, file_len, status_func, code) ic_select (file_id, select_list_num, code) and loop on ic_readnext (select_list_num, record_id, max_id_size, id_len, code) if code != 0 { ic_read (file_id, lock, record_id, id_len, record, max_rec_size, record_len, status_func, code) } My two cents. Manu - Original Message - From: pam [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, May 18, 2007 4:28 PM Subject: [U2] read secuencial a table Hi, i'm working in C with the api intercall.h and I would like to know a way for reading a table in a secuencial way. Because with ic_read i must give a record id. Other way i try is with ic_execute but I get a buffer with the result of the select statement but it has not a unique format, also it dependet in the number of attribute I ask on the select. I aslo try to use UCI.h but althougth I could read it in the way I want I couldn't read multivalue columns, with the BindMvCol on the PCArray it say the rigth number but on pCArray-Data I have not the content. I follow the ucisample, and it does not work too with multivalue columns. I'm on a dilema, I could do somethings with a api and other with the other api.!!! Well I will appreciate any help . Thanks in advanced Pamela --- 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] [UV] Every UV Shop needs to read Jeff's note on: Nice SET.INDEX enhancement
You are right. Remarq, I use uvbackup for daily backups on all deployed sites without trouble and with great flexibility to restore something. I perform one uvbackup to file per account into one directory per day-of-week and the OS perform copy to tapes (or backup server) of the entires directories backup not of the production directories. My 1 cent Manu - Original Message - From: Hona, David S [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, May 17, 2007 9:09 AM Subject: RE: [U2] [UV] Every UV Shop needs to read Jeff's note on: Nice SET.INDEX enhancement This reminds me that I've always thought that IBM should document a clear warning in the UV manuals about that the: A) backup B) moving C) copying D) renaming E) deletion Of any UniVerse hashed file - especially dynamic files (type 30) - using any non-UV utilities *can* cause serious problems if improperly used/done, including lost of data and/or data corruption. Backups performed with any utility other than uvbackup need to be done with no users accessing the files being backed-up. Of course, in the real world almost no one uses uvbackup. :-) Most people find this out the hard way. Of course, having it in the manuals doesn't mean that anyone will read it. ;-) Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen O'Neal Sent: Thursday, May 17, 2007 10:11 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Every UV Shop needs to read Jeff's note on: Nice SET.INDEX enhancement The COPYing of files and the failure to perform the set SET.INDEX command after the copy, has caused numerous system failures. (One site failed just last week.) Jeff Fitzgerald's excellent e-mail is a must be read by all UV shops. You may wish to consider changing every index you have on your system to RELATIVE.PATH, just to avoid the problem in the future (should you copy a file). I propose that you should CHANGE your STANDARD OPERATING PROCEDURES immediately to increase stability. In addition, all applications development personnel should be educated to implement this for every new index added. --- 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] Restricted TCL prompt - UniVerse 10.2?
Hi, See Universe Admin Doc, chapter 8 section 10+11 Security Subroutine and R-emote Pointer. I hope this help. Manu - Original Message - From: Gabriel Green [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Sunday, May 13, 2007 5:12 AM Subject: [U2] Restricted TCL prompt - UniVerse 10.2? Is there a way in UniVerse to create a restricted TCL prompt with access to only a few verbs (and whatever they call) ? Thanks Gabe --- 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] Upgrade to Unidata Server Edition
Hi, Workgroup is reserved for Intel Plateform and max 24 users. When you goes to AIX, you must use Server or Enterpise Edition. The price is the difeerence between workgroup and Serve Edition. See your dealer I do'nt known the US price. There is no function difference. Except, you run under AIX.. You loose device licence. Then Server edition is a per session licence. To get device licence, you must go to Enterprise Edition I hope this help Manu - Original Message - From: George R Smith [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Saturday, May 12, 2007 4:47 PM Subject: [U2] Upgrade to Unidata Server Edition All, Because I am changing platforms IBM informed me by email late Friday that I will need to do an edition upgrade from workgroup to server or enterprise. Anyone know what the additional cost per user might be ? Does server bring any additional benefits ? The system is used for development only - not a production box. Thanks grs --- 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] Moving UniVerse over to another machine...
Hi, Simple if you have the same paths for uv and for your accounts in the target server. You can use Os file copying (with universe stopped on source server.) If you use SQL Schema you must prepare some informations with format.conv -export before file copying and run a format.conv -import. You must be carefull with uv (and subdirectories) some files must be copied : - uv\UV.ACCOUNT - uv\catdir (global catdir) - check the uv\VOC --- and other elements added/modified into uv account I you change the paths of uv or accounts, you must update all VOC files (there is full-OS-path inside records. We do it with a SEARCH-REPLACE prog here : * run as : UPDATE.UVACCOUNT startdir * startdir is a base-path for searching VOC files * -- * EFV 20-01-06 *--- EQU UVNT TO SYSTEM(91) EQU UVHOME TO SYSTEM(32) EQU OS.SEPTO IFS(SYSTEM(91),'\','/') EQU OS.RUN TO IFS(SYSTEM(91),'DOS /C ','SH -c ') * open UV.ACCOUNT OPEN 'UV.ACCOUNT' TO F.UVA ELSE EXECUTE 'SET.FILE UV UV.ACCOUNT UV.ACCOUNT' CAPTURING RIEN OPEN 'UV.ACCOUNT' TO F.UVA ELSE STOP 'UV.ACCOUNT NOT OPENED' END END * check start dir if @NULL, start fom first level of uvhomepath STMT = CHANGE(TRIM(@SENTENCE),' ',@AM) STARTDIR = '' IF STMT1 = 'RUN' THEN STARTDIR = TRIM(STMT4) END ELSE STARTDIR = TRIM(STMT2) END IF STARTDIR = '' THEN STARTDIR = FIELD(UVHOME,OS.SEP,1,2) * OPEN 'UV.ACCOUNT' TO F.UVA ELSE EXECUTE 'SET.FILE UV UV.ACCOUNT UV.ACCOUNT' CAPTURING RIEN OPEN 'UV.ACCOUNT' TO F.UVA ELSE STOP 'UV.ACCOUNT NOT OPENED' END END * lecture des fichiers VOC CRT 'Recherche dans 'STARTDIR:' de tous les VOC...' IF UVNT THEN EXECUTE OS.RUN:'DIR /B/S ':STARTDIR:'\VOC' CAPTURING VOCFILES END ELSE EXECUTE OS.RUN:'find ':STARTDIR: '-name VOC' CAPTURING VOCFILES END HEADING Mise ` jour de UV.ACCOUNT depuis :CHANGE(STARTDIR,'\','/'): 'TL' * upate uv.account with all VOC I can open LOOP REMOVE ID FROM VOCFILES SETTING EOS OPENPATH ID TO F.VOC THEN ACNT.NAME = UPCASE(FIELD(ID,OS.SEP,DCOUNT(ID,OS.SEP)-1)) ACNT.PATH = ID[1,COL2()-1] READ UVA FROM F.UVA,ACNT.NAME THEN IF UPCASE(UVA11) # UPCASE(ACNT.PATH) THEN PRINT '# ':FMT(ACNT.NAME,'ML#20'):' ':UVA11,ACNT.PATH END ELSE PRINT '= ':FMT(ACNT.NAME,'ML#20'):' ':ACNT.PATH END END ELSE WRITEV ACNT.PATH ON F.UVA,ACNT.NAME,11 PRINT '+ ':FMT(ACNT.NAME,'ML#20'):' ':ACNT.PATH END END WHILE EOS DO REPEAT * CHECK all UV.ACCOUNT if open VOC is ok SELECT F.UVA LOOP WHILE READNEXT ID DO READ UVA FROM F.UVA,ID THEN OPENPATH UVA11:OS.SEP:'VOC' TO F.DUMMY ELSE DELETE F.UVA,ID PRINT '- ':FMT(ID,'ML#20'):' ':UVA11 CONTINUE END END REPEAT I hope this help. Manu - Original Message - From: Gabriel Green [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, May 09, 2007 5:24 AM Subject: [U2] Moving UniVerse over to another machine... This weekend, I plan to move UniVerse (10.2, Win Server 2003 x64 Standard Edition, SP2) to another machine running the same OS. What is the proper procedure? I have already installed and authorized UV on the other machine. I take it it's not as simple as copying D:\IBM over to the other machine (the few UV accounts we use live in D:\IBM\CONV) Anybody have some tricks or tips? Thanks-- Gabe --- 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] [sbs] - Totals Only
When you look into the generated code for a report process, you understand it is a local varialbe, not available into a the SBPLUS common block. If you need to check it (Y/N), you must compile the process and add yourself a SBCommon assignment :-( Manu - Original Message - From: Bjorn Behr [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, March 19, 2007 1:47 PM Subject: [U2] [sbs] - Totals Only Afternoon all Can anybody tell me where SB+ keeps the TOTALS ONLY Flag on a Report Thanks Bjorn --- 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/