[U2] How bad is "badly" in ANALYZE.FILE [filename] STATS?
How bad is "badly" in ANALYZE.FILE [filename] STATS? File name .. ALPHA Pathname ... ALPHA File type .. DYNAMIC Hashing Algorithm .. GENERAL No. of groups (modulus) 252220 current ( minimum 1607, 0 empty, 44930 overflowed, 3605 badly ) Number of records .. 8156067 Large record size .. 3257 bytes Number of large records 872 Group size . 4096 bytes Load factors ... 80% (split), 50% (merge) and 80% (actual) Total size . 1277140992 bytes Total size of record data .. 645693155 bytes Total size of record IDs ... 197406821 bytes Unused space ... 434032824 bytes Total space for records 1277132800 bytes Press any key to continue... File name .. ALPHA Number per group ( total of 252220 groups ) AverageMinimumMaximum StdDev Group buffers .. 1.19 1 6 0.42 Records 32.34 9 91 8.29 Large records .. 0.00 1 1 0.06 Data bytes . 2560.04413 207151056.37 Record ID bytes 782.68208 2246 203.29 Unused bytes ... 1521.33 24 91361009.91 Total bytes 4864.04 4096 24576 0.00 Number per record ( total of 8156067 records ) AverageMinimumMaximum StdDev Data bytes . 79.17 43 16402 142.01 Record ID bytes 24.20 5 46 5.74 Total bytes 103.37 48 16448 141.41 Press any key to continue... File name .. ALPHA Histogram of record and ID lengths 70.9% Bytes - up to 4| up to 8| up to 16| up to 32| up to 64| > up to 128| up to 256| >> up to 512| >> up to 1K| up to 2K| up to 4K| up to 8K| up to 16K| More| - > -- Louie In Seattle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] biztalk adapter
Hi Bob, I believe Biztalk will talk to SOAP so have you might want to investigate the U2 Soap Server (assuming Biztalk can be customised to work within its limitations). Craig --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] biztalk adapter {Unclassified}
There are simple, but rather crude and nasty, ways of doing this. The most obvious is to use the BizTalk 'file' adapter, with the target BizTalk directories described as UniVerse Type 19 files. The UniVerse 'send' process drops XML messages as 'records' in the Type 19 file into the directory for BizTalk to pick up. The universe 'receive' process is a phantom that monitors the receiving Type 19 file for incoming XML messages which it parses and processes. I would recommend that the 'sending' directory has a parallel 'sent' directory and the BizTalk orchestration which grabs the file moves it from 'sending' to 'sent'. Similarly the UV process that receives messages should move them into a 'received' directory. These measures allow auditing and re-playing of messages as may be needed. HTH Mike > From: Bob Witney > I am happily going from aix5.3 running universe 10.2 to ms sql via MS > BizTalk, works fine > > Does anyone have knowledge of a BizTalk adapter (ms don't > have one) that will le me go the other way? > i.e. BizTalk to Universe The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Speeding up processing through large dynamic table
REMOVE is the fastest way I've found to do this. You must remember not to re-assign or change the array while you are processing it. Assuming the array is THAT, even a THAT = THAT will reset the array processing pointer and give you grief. The following code will break the array up into attributes. LOOP THIS = '' LOOP REMOVE PART FROM THAT SETTING MARK THIS := PART WHILE MARK GT 2 DO THIS := CHAR(256-MARK) REPEAT GOSUB PROCESS.THIS WHILE MARK DO REPEAT The penultimate line perhaps should be WHILE MARK GT 1 DO - I have never seen the char(255) delimiter in a real situation, so it's never been an issue. The following code is what I used in the past. It's not quite so fast, but it was always good enough. This is the mechanism I used to process associated multivalues. In the 80's an invoice with lots of lines could cause an excruciatingly long delay without this technique. From memory, I saw this first in an article by Jim Cronin. $OPTIONS INFORMATION DIM PART(100) MAXMATTR = DCOUNT(THAT,@AM) MATPARSE PART FROM THAT, @AM FOR ATTR = 1 TO MAXMATTR HERE = REM(ATTR,100) IF HERE THEN THIS = PART(HERE) ELSE THIS = PART(100) MATPARSE PART FROM PART(0), @AM END GOSUB PROCESS.THIS NEXT ATTR Note that the above method needs to be written differently if you use PICK style (static dimensioned arrays) because there is no zeroth array element. $OPTIONS PICK DIM PART(101) MAXMATTR = DCOUNT(THAT,@AM) MATPARSE PART FROM THAT, @AM FOR ATTR = 1 TO MAXMATTR HERE = REM(ATTR,100) IF HERE THEN THIS = PART(HERE) ELSE THIS = PART(100) MATPARSE PART FROM PART(101), @AM END GOSUB PROCESS.THIS NEXT ATTR Lastly, I have a vague memory that somewhere I may have been forced to use a temporary variable like this TEMP = PART(101) MATPARSE PART FROM TEMP, @AM Regards, Keith --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe triggers + SB+
Hi, Do you use the $OPTIONS PICK into the basic code before INCLUDE DMSKELCODE COMMON ? My two pence. Manu > -Message d'origine- > De : [EMAIL PROTECTED] [mailto:owner-u2- > [EMAIL PROTECTED] De la part de Susan Joslyn > Envoyi : mardi 25 novembre 2008 18:10 > @ : u2-users@listserver.u2ug.org > Objet : [U2] Universe triggers + SB+ > > Has anyone successfully enabled Universe trigger programs that call SB+ > enabled programs? I'm getting COMMON mis-match and other errors. > > > > TIA, > > Susan Joslyn > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] 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/
RE: [U2] FYI: Relocation To Philadelphia/West Chester Area
Hi Don, Welcome to the neighborhood. I'm in DE. Feel free to contact me if you need someone close by. Best of luck. Lee H. Burstein President 302-477-0180 Fax: 270-574-0180 www.dynamicsys.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, November 25, 2008 5:24 AM To: u2-users@listserver.u2ug.org Subject: [U2] FYI: Relocation To Philadelphia/West Chester Area Group, This is just an FYI to all that know me. I wanted to inform you that have moved from South Florida (Fort Lauderdale) to the Philadelphia / West Chester area of Pennsylvania. Regards, Don Verhagen Formerly of Tandem Staffing Solutions Formerly of M&M Aerospace Hardware, Inc, a B/E Aerospace Company email: [EMAIL PROTECTED] (remove the "removethis" from the domain name). --- 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] biztalk adapter [ad]
Tony Many thanks The reason I asked is because I didn't want to write it myself I have a webservice fronting the U2 already so I'll go thru that It just that an adapter would have been nice Not to worry Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony G Sent: 25 November 2008 10:15 To: u2-users@listserver.u2ug.org Subject: RE: [U2] biztalk adapter [ad] Since there's only been one response so far and it doesn't look like there are any alternatives, I can ask one of our guys to write a BizTalk/U2 interface on a T&M basis. The solution might be an adapter, web service, or functoids, depending on how it will be used. Just email if interested. HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula R&D sells mv.NET and other Pick/MultiValue products worldwide, and provides related development and training services > From:Hona, David > Bob > You're probably going to have to use the BizTalk to MQSeries adaptor. > However, you'd need MQSeries installed on your server...not really a > cheap option to do. MQ may not give you want you need, > depending on your business/technical requirements. > From: Bob Witney > I am happily going from aix5.3 running universe 10.2 to ms sql via MS > BizTalk, works fine > > Does anyone have knowledge of a BizTalk adapter (ms don't > have one) that will le me go the other way? > i.e. BizTalk to Universe --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ Confidentiality Notice: This e-mail and any attachments are intended solely for the addressee and may contain confidential or privileged information. If you are not the named addressee, or the person responsible for delivering the message to the named addressee, please notify the sender as soon as possible and delete the material from your computer. This message will be protected by copyright. If it has come to you in error, you must not take any action based on its contents nor must you copy or show the message to any person other than the intended recipient. _ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] SSH Tectia and Dynamic Connect
Hi, Has anyone had any success setting up Dynamic Connect 4.2.3 to connect to a UniVerse 10.1 server over Telnet using SSH Port Forwarding with the SSH Tectia Client? Thanks, Andrew Andrew Warhurst --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] biztalk adapter [ad]
Since there's only been one response so far and it doesn't look like there are any alternatives, I can ask one of our guys to write a BizTalk/U2 interface on a T&M basis. The solution might be an adapter, web service, or functoids, depending on how it will be used. Just email if interested. HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula R&D sells mv.NET and other Pick/MultiValue products worldwide, and provides related development and training services > From:Hona, David > Bob > You're probably going to have to use the BizTalk to MQSeries adaptor. > However, you'd need MQSeries installed on your server...not really a > cheap option to do. MQ may not give you want you need, > depending on your business/technical requirements. > From: Bob Witney > I am happily going from aix5.3 running universe 10.2 to ms sql via MS > BizTalk, works fine > > Does anyone have knowledge of a BizTalk adapter (ms don't > have one) that will le me go the other way? > i.e. BizTalk to Universe --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] FYI: Relocation To Philadelphia/West Chester Area
Group, This is just an FYI to all that know me. I wanted to inform you that have moved from South Florida (Fort Lauderdale) to the Philadelphia / West Chester area of Pennsylvania. Regards, Don Verhagen Formerly of Tandem Staffing Solutions Formerly of M&M Aerospace Hardware, Inc, a B/E Aerospace Company email: [EMAIL PROTECTED] (remove the "removethis" from the domain name). --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/