Re: [U2] Advantage of indirect call in BASIC

2012-12-04 Thread Manu Fernandes
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

[U2] UV win 2008 Workgroup - ED / COPY very slow

2012-12-11 Thread Manu Fernandes
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.

Re: [U2] [UV Retrieve] Selecting file based on partial key

2013-01-14 Thread Manu Fernandes
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 FILEN

Re: [U2] How do you print a ".pdf" from inside a Unix Box

2013-04-04 Thread Manu Fernandes
hi Bruce, on 'ux, we use ghostscript http://ghostscript.com/doc/current/Use.htm Manu Bruce Conway - Bamac LTD 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.

[U2] uvuidlog.txt - who is parent & error codes

2013-04-12 Thread Manu Fernandes
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

Re: [U2] uvbackup linux command line - multiple specific files

2013-04-17 Thread Manu Fernandes
hey, Another method, put the list of files to backup into a textfile, use the -cmdfil param of uvbackup cmd. Manu Perry Taylor 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

Re: [U2] [UV] RESIZE INPLACE

2013-04-28 Thread Manu Fernandes
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 distrib

Re: [U2] What tools do you use for data warehouse...

2013-04-28 Thread Manu Fernandes
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/s

Re: [U2] Help needed..

2013-04-30 Thread Manu Fernandes
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

Re: [U2] SB and Printers

2013-05-07 Thread Manu Fernandes
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

Re: [U2] select query..

2013-05-15 Thread Manu Fernandes
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'ori

Re: [U2] select query..

2013-05-15 Thread Manu Fernandes
.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 infodata.lu> writes: > > > > > > Hi > &

Re: [U2] select query..

2013-05-15 Thread Manu Fernandes
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] U2 demos and sample code now on Github

2013-05-22 Thread Manu Fernandes
Hi Dan, Without doubt about Github quality, I have just a question. Why dont you extend u2devzone/accelerate ? Regards Manu Daniel McGrath 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. h

Re: [U2] [UV] UniObjects.Net vs Thrid-party Products

2013-05-28 Thread Manu Fernandes
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 ea

Re: [U2] Signature Capture and use

2013-06-07 Thread Manu Fernandes
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 in

Re: [U2] Writing into metadata

2013-06-11 Thread Manu Fernandes
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.ph

Re: [U2] sbclient and multi-language

2013-07-10 Thread Manu Fernandes
yes, we use it with french, dutch, german, english, ... translation. please, what's your question ? Manu "Fingerle, Julius" 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

Re: [U2] [UV] and the Hebrew character set

2013-07-21 Thread Manu Fernandes
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 t

Re: [U2] [UV] and the Hebrew character set

2013-07-21 Thread Manu Fernandes
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.

Re: [U2] Type 30 files modified when LISTed? (UV 10.0.2)

2013-08-07 Thread Manu Fernandes
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 a écrit : If I LIST a Type 30 file, Then exe

Re: [U2] TU.SQL.CONNECT

2013-08-22 Thread Manu Fernandes
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.* subrtoutin

Re: [U2] Select from one file with save-list from another file

2013-08-28 Thread Manu Fernandes
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.I

Re: [U2] uvbackup and uvrestore

2013-10-09 Thread Manu Fernandes
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 recor

Re: [U2] Self Deadlatch error on device 655372, inode 610205, group 11460608, latch 80000 to WRITE.

2014-02-03 Thread Manu Fernandes
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

[U2] Unidata - Hardware sizing for 550 telnet users

2010-09-03 Thread Manu Fernandes
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.u2

Re: [U2] SB Client - Disable TAB

2010-09-25 Thread Manu Fernandes
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

Re: [U2] how to round to 2 decimals?

2010-10-13 Thread Manu Fernandes
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

Re: [U2] UV 10.3.3/SB+ 6.0.3

2010-11-04 Thread Manu Fernandes
Hi group, I don't know if it is relevant but wen Paragraph use a CLOSE x, SB+ run CALL SB.FILEVAR.S(FILES.OPENED, 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 /

Re: [U2] UniVerse On RedHat?

2010-11-06 Thread Manu Fernandes
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

Re: [U2] [UV] PORT.STATUS questions.

2011-01-03 Thread Manu Fernandes
Hi group, You can use uv provided subroutine !GET.USERS; search the uvdoc. If you use in basic EXECUTE "PORT.STATUS INTERNAL" CAPTURING VAR you get the port.status output in a dynamic array VAR ; @am,@vm You can also use in basic VAR=SYSTEM(1301) which return a dynamic Array, each attribute

Re: [U2] [UV] PORT.STATUS questions.

2011-01-04 Thread Manu Fernandes
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 [mai

Re: [U2] LIST.READU - clear lock table ?

2011-01-18 Thread Manu Fernandes
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.

Re: [U2] Universe Books?

2011-02-04 Thread Manu Fernandes
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.

Re: [U2] Input or Output screen?

2011-02-11 Thread Manu Fernandes
Hi, Loop on @PROC.NAME<1..x> until F('XXPROCESS',@PROC.NAME)<1> = 'I' or F('XXPROCESS',@PROC.NAME)<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 pa

Re: [U2] [UV] XML Parser

2011-02-23 Thread Manu Fernandes
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

Re: [U2] backing up system

2011-03-14 Thread Manu Fernandes
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 m

Re: [U2] Question about uvbackup dd and uvrestore

2011-04-16 Thread Manu Fernandes
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 uvbacku

Re: [U2] Limitations of uvrestore

2011-05-02 Thread Manu Fernandes
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

[U2] [uv] file header sica region structure

2011-05-03 Thread Manu Fernandes
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 b

Re: [U2] serial #

2011-05-07 Thread Manu Fernandes
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

Re: [U2] serial #

2011-05-08 Thread Manu Fernandes
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

Re: [U2] Printing to Remote Warehouse

2011-05-26 Thread Manu Fernandes
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 .

Re: [U2] Adding capabilities in the sort term

2011-07-06 Thread Manu Fernandes
Hi, We do it with handheld terminal (LXE MX-8) ; which run a TotalCross/superwaba application. The TotalCross application capture the signature as a bmp and submit it to universe via webservice as Bas64 encoded string. we store these string into universe and when we need to use it, we can decod

Re: [U2] Job scheduling in UniVerse

2011-09-13 Thread Manu Fernandes
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 start

[U2] [uv] from uv/linux, execute a remote mysql/sql stmt ?

2011-10-01 Thread Manu Fernandes
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

Re: [U2] XML and UV

2011-10-16 Thread Manu Fernandes
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

[U2] uv/win - PHANTOM <> JOBS not sync'ed

2012-06-14 Thread Manu Fernandes
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

Re: [U2] uv/win - PHANTOM <> JOBS not sync'ed

2012-06-15 Thread Manu Fernandes
> Objet : Re: [U2] uv/win - PHANTOM <> JOBS not sync'ed > > Post the VOC entry for JOBS > > > > -Original Message- > From: Manu Fernandes > To: u2-users > Sent: Thu, Jun 14, 2012 7:11 am > Subject: [U2] uv/win - PHANTOM <> JOBS not s

[U2] How to adresse OracleClientInterface from UV/Basic

2012-06-19 Thread Manu Fernandes
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 sampl

Re: [U2] UV Unix File Recovery

2012-06-21 Thread Manu Fernandes
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é :

Re: [U2] Virtualizing a Universe server of 100+ users

2012-08-21 Thread Manu Fernandes
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

Re: [U2] Virtualizing a Universe server of 100+ users

2012-08-21 Thread Manu Fernandes
ATA/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 > To: U2 Users List > Sent: Tue, Aug 21, 2012 4:14 am &

Re: [U2] RESIZE error - Replication?

2012-09-28 Thread Manu Fernandes
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 re

Re: [U2] UPLOAD not DOWNLOAD

2012-10-27 Thread Manu Fernandes
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 r

RE: [U2] uv account

2008-09-04 Thread Manu Fernandes
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 0

RE: [U2] Pentaho/ETL Tools [ad]

2008-11-15 Thread Manu Fernandes
ggers 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

RE: [U2] Triggers on PICK flavor of UV

2008-11-20 Thread Manu Fernandes
Hi, Yes, it run under PICK flavor, A trigger is not linked to the flavor of the current VOC, it is a definition into the header of the file. A subroutine is always executed into his compilation's flavor (from VOC wehre BASICed or $OPTIONS in source) Under PICK Flavor you must create a CATALOG

[U2] Convert AREV/Paint definition to SB+

2008-11-23 Thread Manu Fernandes
o 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] Universe triggers + SB+

2008-11-25 Thread Manu Fernandes
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.u

RE: [U2] Universe triggers + SB+

2008-11-26 Thread Manu Fernandes
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:

RE: [U2] Universe triggers + SB+$ OPTIONS PICK

2008-11-26 Thread Manu Fernandes
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 mix

RE: [U2] Universe triggers + SB+$ OPTIONS PICK

2008-11-26 Thread Manu Fernandes
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] [m

RE: [U2] Remote backup

2008-11-27 Thread Manu Fernandes
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=

RE: [U2] PCL Help

2008-11-29 Thread Manu Fernandes
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

RE: [U2] Universe triggers (still more)

2008-12-02 Thread Manu Fernandes
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 progr

RE: [U2] Universe triggers (still more)

2008-12-02 Thread Manu Fernandes
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:

RE: [U2] Printing Graphics from UniVerse

2008-12-02 Thread Manu Fernandes
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:

RE: [U2] Batch conversion of 32bit files to 64bit

2008-12-28 Thread Manu Fernandes
Hi, Do it with RESIZE * * * 64BIT Manu > -Message d'origine- > De : owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- > us...@listserver.u2ug.org] De la part de Arnold Bosch > Envoyi : mardi 23 dicembre 2008 10:17 > @ : u2-users@listserver.u2ug.org > Objet : [U2] Batch conversion of 3

RE: [U2] Does anybody have a hot backup server?

2009-03-18 Thread Manu Fernandes
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 ho

RE: [U2][SB+] Extended Character Set (ALT+...)

2009-05-04 Thread Manu Fernandes
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 > -Me

Re: [U2] What ETL?

2009-07-29 Thread Manu Fernandes
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 meta

[U2] [UV]recurring database, indexing and deadlatch errors

2009-07-29 Thread Manu Fernandes
Hello U2 group, Probably a good question. We define a < recurring > file. Attribute<1> 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 wit

Re: [U2] [UV]recurring database, indexing and deadlatch errors

2009-07-29 Thread Manu Fernandes
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 Fernande

Re: [U2] [UV]recurring database, indexing and deadlatch errors

2009-07-29 Thread Manu Fernandes
> -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 deadla

[U2] UV:basic readu lock promote to filelock when locktable is full !!

2009-09-07 Thread Manu Fernandes
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 task

Re: [U2] UV:basic readu lock promote to filelock when locktable is full !!

2009-09-11 Thread Manu Fernandes
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 Re

[U2] [UV][UX] @USERNO > @LOGNAME/PID ;...

2009-09-11 Thread Manu Fernandes
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-U

Re: [U2] U2 University 2009, Denver

2009-09-11 Thread Manu Fernandes
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 forwa

[U2] Distributed file on Unidata Unix (DEFINE.DF)

2009-10-20 Thread Manu Fernandes
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.or

Re: [U2] Moving UniVerse over to another machine...

2007-05-09 Thread Manu Fernandes
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.

Re: [U2] Upgrade to Unidata Server Edition

2007-05-12 Thread Manu Fernandes
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

Re: [U2] Restricted TCL prompt - UniVerse 10.2?

2007-05-13 Thread Manu Fernandes
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: Sent: Sunday, May 13, 2007 5:12 AM Subject: [U2] Restricted TCL prompt - UniVerse 10.2? Is there a

Re: [U2] [UV] Every UV Shop needs to read Jeff's note on: Nice SET.INDEX enhancement

2007-05-17 Thread Manu Fernandes
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 direct

Re: [U2] read secuencial a table

2007-05-18 Thread Manu Fernandes
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,

Re: [U2] New UV system

2007-06-13 Thread Manu Fernandes
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 *uvrest

Re: [U2] UD Backups - DBPAUSE for UniVerse?

2007-07-04 Thread Manu Fernandes
SUSPEND.FILES ON/OFF Manu - Original Message - From: "Scott Richardson" <[EMAIL PROTECTED]> To: 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

Re: [U2] [u2] : Cleaner Case Statement

2007-07-25 Thread Manu Fernandes
Try this ON index('AB2',Ans,1) GOSUB Check.A, Check.B, Check.B Manu - Original Message - From: "Brutzman, Bill" <[EMAIL PROTECTED]> To: Sent: Wednesday, July 25, 2007 5:48 PM Subject: [U2] [u2] : Cleaner Case Statement How can this structure be cleaned-up? begin case cas

RE: [U2] Question - retrieving file separation setting

2007-09-14 Thread Manu Fernandes
Use the STATUS stmt FROM filevar OPEN yourfile TO F.DUMMY ELSE EXIT STATUS F.STATUS FROM F.DUMMY ELSE EXIT TYPE = F.STATUS<21,1,1> IF TYPE <2 OR TYPE > 18 THEN EXIT MODULO= F.STATUS<22,1,1> SEPARATOR = F.STATUS<23,1,1> Regards Manu > ---

[U2] [uv] SBClient - vt220 CHAR mode - How to colors ?

2007-09-20 Thread Manu Fernandes
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.

Re: [U2] [uv] SBClient - vt220 CHAR mode - How to colors ?

2007-09-20 Thread Manu Fernandes
ou 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, Septembe

Re: [U2] [uv] SBClient - vt220 CHAR mode - How to colors ?

2007-09-21 Thread Manu Fernandes
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

[U2] U2:UV: Dynamo

2007-10-05 Thread Manu Fernandes
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.

[U2] [UV/NT] T.LOAD from d3/T-DUMP pseudo froppy diskfile

2007-12-10 Thread Manu Fernandes
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 mail

RE: [U2] [UV/NT] T.LOAD from d3/T-DUMP pseudo froppy diskfile

2007-12-10 Thread Manu Fernandes
>T-REW >>T-LOAD >>UNASSIGN ARQUIVO >Good luck > > Antonio Carlos > Departamento TC)cnico > Integral Sistemas > Telefone 11 3205-6000 - Fax 11 3205-6001 > www.integral.com.br > ___

RE: [U2] [UV/NT] T.LOAD from d3/T-DUMP pseudo froppy diskfile

2007-12-10 Thread Manu Fernandes
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

RE: [U2] [UV/NT] T.LOAD from d3/T-DUMP pseudo floppy diskfile

2007-12-11 Thread Manu Fernandes
> 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 > > > - Original Mess

RE: [U2] VMWare Server (free) Product - UV virtualization?

2008-01-29 Thread Manu Fernandes
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.

RE: [U2] [uvrestore] - help with a couple errors..

2008-01-31 Thread Manu Fernandes
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 PR

RE: [U2] question..

2008-01-31 Thread Manu Fernandes
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 > -

  1   2   >