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 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

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 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

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.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

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.* 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)

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 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

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 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

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.

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

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

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.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

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 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

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 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

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 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..

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'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..

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

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] 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

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 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..

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é : 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

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 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...

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/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

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 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

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 ?
- 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

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 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

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 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

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

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 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

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 
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?

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 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

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

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é : 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

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 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

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

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




___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] XML and UV

2011-10-17 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 : 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 ?

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.
Manu




___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


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 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] Adding capabilities in the sort term

2011-07-07 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 decode 
to save on the OS level (OPENSEQ/WRITEBLK) 
then we can convert it to EPS and push into a postscript jobs to output a 
delivery form with customer signature. (or convert to other picture format 
using imagemagick)

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 Oaks, Harold
 Envoyé : mercredi 6 juillet 2011 20:35
 À : u2-users@listserver.u2ug.org
 Objet : [U2] Adding capabilities in the sort term
 
 Has anyone done either of the following with a U2 system (we have
 Universe) and can give me some recommendations?
 
 (1) Added a signature pad so that captured signatures can be stored for
 future use. (We have Print Wizard, so can easily print graphical images if
 they can just be captured.)
 
 (2) Worked with Web Services from within your U2 application?
 
 Thanks-
 Harold Oaks
 
 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] 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 ...

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 #

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 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 #

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
 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

2011-05-03 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 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

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 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

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 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

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


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

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 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?

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

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.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 ?

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.   

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.

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 [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?

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 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

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.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?

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 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

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 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

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.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[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.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


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 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 ;...

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-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


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 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 !!

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 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?

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 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

2009-07-29 Thread Manu Fernandes

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

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

2009-07-29 Thread Manu Fernandes
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+...)

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



 -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?

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 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)

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 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)

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: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

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: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

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] 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

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=
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+

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

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 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

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

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.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+

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

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

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
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)

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

2008-04-26 Thread Manu Fernandes
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 ?

2008-03-14 Thread Manu Fernandes
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..

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 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..

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




 -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..

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

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. 
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

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

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 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

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

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

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.org
To unsubscribe please visit http://listserver.u2ug.org/


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 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 ?

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.

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 ?

2007-09-20 Thread Manu Fernandes

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

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.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

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: 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?

2007-07-04 Thread Manu Fernandes

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

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 *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

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, 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

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 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?

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: 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

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 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...

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.
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/


  1   2   >