Re: [U2] FW: [UV] Change in behaviour of "EXECUTE ... CAPTURING"at 10.1.18 {Unclassified}
Sorry, saw this a little late - Try setting term type to PAPER (DUMB) before generating the xml and CAPTURING. This would remove any top of form controls from output destined to a users terminal session Rgds Ian Stuart ___ DISCLAIMER ___ This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [AD] Re: [U2] SETPTR MODE 1
Well, there is a third choice. Clifton Oliver & Associates Extended SPooler system (ESP) was written on UniVerse Windows to overcome a similar problems, in this case, to port UniVerse Unix applications to UniVerse Windows and to overcome the limitations and performance issues of the UniVerse spooler on Unix in large shops with hundreds of "hold" files. (Had to get a plug in there, took, Dave ) If anyone would like more information, please contact me off-list. Phone number is in the sig block. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER & ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On Jun 12, 2006, at 7:11 PM, Dave Taylor wrote: John, As others have suggested, there is no print spooler in Universe on Windows. If your goal is to provide a "gui front end for spooler management" that works for UV under both .nix and Windows, then I think you have two choices. 1.Write a print spooler for UV/NT that functions like the print spooler in UV/nix with a gui front end (but does not look anything like the print spooler found in generic Pick databases). 2.Write (or purchase) a generic Pick print spooler that runs on both UV/NT and UV/nix with a gui front end. Most of our customers have been running on generic Pick databases for the past 20+ years, and we wanted to be able to move them to Universe on Windows or .nix, so we wrote a generic Pick print spooler, SpoolerPlus, to make that transition as easy and as transparent as possible. We then ported Spooler Plus to Unidata/NT with only minor modifications. Our next step is to port SpoolerPlus to Universe/nix, and then to Unidata/nix, to provide a consistent generic Pick print and spooler management environment on all U2 platforms. Since there are so many different "gui" tools and environments, SpoolerPlus is written in Basic and Proc, with the option of converting its menus, entry screens, displays and reports to the gui environment of your choice. I'll be glad to provide you information about SpoolerPlus if you wish and answer any questions you may have to help you achieve your goal. Best regards, Dave Dave Taylor President Sysmark Information Systems, Inc. IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (C) 310-561-5200 (P) 800-339-1497 (F) 310-377-3550 Your Source for Integrated EDI Translation and DataSync Integration www.sysmarkinfo.com - Original Message - From: "John Kent" <[EMAIL PROTECTED]> To: "U2Users" Sent: Thursday, June 08, 2006 4:52 PM Subject: [U2] SETPTR MODE 1 I have been looking at Universe in PICK flavour on Windows. Does anyone know where the output goes with setptr mode 1 and HOLD. (I have always used mode 3) Is it accessible in basic with a file read. where is the SPOOL - LIST job description data kept and can i access this in basic It seems like there is a gui front end for spooler management under unix but not in windows I would like to be able to come up with something that works with either if thats possible. jak --- 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] ICONV 'DW' [was:UniVerse Internal Date Blackout]
Speaking of ICONV, anyone noticed that `DWx' conversions are fubar. For example, the `W' token gets ignored on ICONV and you can't reciprocally ICONV the day name of week as below using DWA. Also converting oconv/iconv using `DW' (leaving the `A'/'B' off) converts the day of the week to the day of January, current year. e.g. Tuesday gets turned into Monday 2^nd Jan where with the `W' token I would expect it to convert to maybe convert to the first Tuesday of the year. This, along with my other gripe of not easily handling ISO standard dates (-mm-ddTHH:mm:ssZ) it seems like an incompleteness to an otherwise excellent function. Stuart X = OCONV(DATE(),'DWA') Y = ICONV(X,'DWA') Z = STATUS() CRT X,'>':Y:'<',Z ;* => TUESDAY_><_1 X = OCONV(DATE(),'DW') Y = ICONV(X,'DW') Z = STATUS() CRT X,'>':Y:'<',Z,OCONV(Y,'DWDMBYL') ;* => 2_>13882<_0_Mon 02 Jan 2006 END __ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of "Ray Wurlod" <[EMAIL PROTECTED]> Sent: Sunday, 11 June 2006 07:57 To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse Internal Date Blackout See http://www.pickwiki.com/cgi-bin/wiki.pl?Date_Conversion_With_ICONV for a discussion of how ICONV deals with wholly numeric external dates. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[AD] Re: [U2] SETPTR MODE 1
John, As others have suggested, there is no print spooler in Universe on Windows. If your goal is to provide a "gui front end for spooler management" that works for UV under both .nix and Windows, then I think you have two choices. 1.Write a print spooler for UV/NT that functions like the print spooler in UV/nix with a gui front end (but does not look anything like the print spooler found in generic Pick databases). 2.Write (or purchase) a generic Pick print spooler that runs on both UV/NT and UV/nix with a gui front end. Most of our customers have been running on generic Pick databases for the past 20+ years, and we wanted to be able to move them to Universe on Windows or .nix, so we wrote a generic Pick print spooler, SpoolerPlus, to make that transition as easy and as transparent as possible. We then ported Spooler Plus to Unidata/NT with only minor modifications. Our next step is to port SpoolerPlus to Universe/nix, and then to Unidata/nix, to provide a consistent generic Pick print and spooler management environment on all U2 platforms. Since there are so many different "gui" tools and environments, SpoolerPlus is written in Basic and Proc, with the option of converting its menus, entry screens, displays and reports to the gui environment of your choice. I'll be glad to provide you information about SpoolerPlus if you wish and answer any questions you may have to help you achieve your goal. Best regards, Dave Dave Taylor President Sysmark Information Systems, Inc. IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (C) 310-561-5200 (P) 800-339-1497 (F) 310-377-3550 Your Source for Integrated EDI Translation and DataSync Integration www.sysmarkinfo.com - Original Message - From: "John Kent" <[EMAIL PROTECTED]> To: "U2Users" Sent: Thursday, June 08, 2006 4:52 PM Subject: [U2] SETPTR MODE 1 > I have been looking at Universe in PICK flavour on Windows. > > Does anyone know where the output goes with setptr mode 1 and HOLD. > (I have always used mode 3) > > Is it accessible in basic with a file read. > > where is the SPOOL - LIST job description data kept and can i access this in > basic > > It seems like there is a gui front end for spooler management under unix but > not in windows > I would like to be able to come up with something that works with either if > thats possible. > > jak > --- > 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] SETPTR MODE 1
Brian, thanks for the kind offer, i may take you up on this. I am working in C# so i suspect its a matter of adding one or more of the WMI com references I can see 3... wmbemads.tlb, wbemcntl.dll, wmiscriptutils.dll Hope to get around to this later in the week. jak - Original Message - From: "Brian Leach" <[EMAIL PROTECTED]> To: Sent: Friday, June 09, 2006 7:01 PM Subject: RE: [U2] SETPTR MODE 1 Chris, The shd files are not meant to be readable. To get the printer and job information you really need to go through the Windows APIs - but it's not as bad as that sounds . You can get printer and job information through the WMI library (search on MSDN for WMI Printer). WMI is a COM based model, which means you can call it from VBScript or a simple executable in VB or Delphi. VBScript you can execute from UniVerse using a verb pointer to the cscript command (copy the pointer for DOS and change cmd.exe to cscript.exe), or a simple executable can be made into a verb pointer directly. Both will allow you to capture output. (IF you haven't met VBScript before, I have an article on the U2UG knowledge base on using VBScript with UniObjects. VBScript is very useful.) I have done something similar for interfacing UniVerse to the Windows Fax Manager. If you need some help getting started, email me off list. Regards, Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Day Sent: 09 June 2006 05:25 To: u2-users@listserver.u2ug.org Subject: RE: [U2] SETPTR MODE 1 Hi John, Good that you have found where the print files are located on the system. Unfortunately, I have not tried to read the details contained in the .shd file at all, but someone else on the list may be able to assist with this. Chris Day Technical Pre-Sales Specialist Meier Business Systems Melbourne * Sydney * Kuala Lumpur * Singapore -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Kent Sent: Friday, 9 June 2006 12:31 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] SETPTR MODE 1 Chris, aha found it. But how does one read the shd file ? This look like where the job description etc SPOOL -LIST uses on windows So i am guessing there is a way to read this and define the data delimiters jak - Original Message - From: "Chris Day" <[EMAIL PROTECTED]> To: Sent: Friday, June 09, 2006 11:38 AM Subject: RE: [U2] SETPTR MODE 1 > Hi John, > > On windows if you use the HOLD keyword on the SETPTR statement, the > resulting print job will end up in the spooler directory of the system. > > On my XP based system this directory is > > WINDOWS\system32\spool\PRINTERS > > There will be two files, one being a control file and the other being > the actual print job. > > Hope that this helps > > Chris Day > Technical Pre-Sales Specialist > Meier Business Systems > Melbourne * Sydney * Kuala Lumpur * Singapore > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of John Kent > Sent: Friday, 9 June 2006 9:52 AM > To: U2Users > Subject: [U2] SETPTR MODE 1 > > I have been looking at Universe in PICK flavour on Windows. > > Does anyone know where the output goes with setptr mode 1 and HOLD. > (I have always used mode 3) > > Is it accessible in basic with a file read. > > where is the SPOOL - LIST job description data kept and can i access > this in > basic > > It seems like there is a gui front end for spooler management under unix > but > not in windows > I would like to be able to come up with something that works with either > if > thats possible. > > jak > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > CAUTION: This email and any attachments are confidential, may be privileged, and are intended for use solely by the addressee. The confidentiality and/or privilege in this email is not waived, lost or destroyed if it has been transmitted to you in error. If you receive this email in error, please notify MBS by reply email immediately, delete the email and destroy any printed copies. You must not disclose, disseminate, distribute, reproduce or use the information contained in this email if you are not the intended recipient. The content and opinions contained in this email are those of the individual sender and may not necessarily reflect the views and opinions of MBS. MBS does not guarantee that this email is free from viruses, errors, interception or interference. Use of this email and any attachments is at the sole risk of the user. MBS does not accept any liability for any loss or damage to your computer system or network (including any consequential damage) which may occ! ur directly or indirectly from the use of this email. --- 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 u
Re: [U2] SETPTR MODE 1
Jeff, of course it would be easier, but i have become aware of several sites that dont do that and print straight out. If the printer screws up 2 bad, rerun the report. Is this common practice ? I had assumed most people would use mode 3 and write to the HOLD file, so that you could reprint those eod/eom reports or cheque runs if required. I suppose the 'advantage' is the sites dont have any spooler management software to monitor. So what do you do if they now want any those reports to go to excel ? The quickest thing would be to pass the spl file (on windows) to the text import wizard. The shd file has a lot of useful info re filtering and would be a bonus but reading it doesnt look easy. jak - Original Message - From: "Jeff Schasny" <[EMAIL PROTECTED]> To: Sent: Saturday, June 10, 2006 12:32 AM Subject: RE: [U2] SETPTR MODE 1 Would it not be easier to just setptr mode 3 and read the resulting item from &HOLD&? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brian Leach Sent: Friday, June 09, 2006 3:01 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] SETPTR MODE 1 Chris, The shd files are not meant to be readable. To get the printer and job information you really need to go through the Windows APIs - but it's not as bad as that sounds . You can get printer and job information through the WMI library (search on MSDN for WMI Printer). WMI is a COM based model, which means you can call it from VBScript or a simple executable in VB or Delphi. VBScript you can execute from UniVerse using a verb pointer to the cscript command (copy the pointer for DOS and change cmd.exe to cscript.exe), or a simple executable can be made into a verb pointer directly. Both will allow you to capture output. (IF you haven't met VBScript before, I have an article on the U2UG knowledge base on using VBScript with UniObjects. VBScript is very useful.) I have done something similar for interfacing UniVerse to the Windows Fax Manager. If you need some help getting started, email me off list. Regards, Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Day Sent: 09 June 2006 05:25 To: u2-users@listserver.u2ug.org Subject: RE: [U2] SETPTR MODE 1 Hi John, Good that you have found where the print files are located on the system. Unfortunately, I have not tried to read the details contained in the .shd file at all, but someone else on the list may be able to assist with this. Chris Day Technical Pre-Sales Specialist Meier Business Systems Melbourne * Sydney * Kuala Lumpur * Singapore -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Kent Sent: Friday, 9 June 2006 12:31 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] SETPTR MODE 1 Chris, aha found it. But how does one read the shd file ? This look like where the job description etc SPOOL -LIST uses on windows So i am guessing there is a way to read this and define the data delimiters jak - Original Message - From: "Chris Day" <[EMAIL PROTECTED]> To: Sent: Friday, June 09, 2006 11:38 AM Subject: RE: [U2] SETPTR MODE 1 > Hi John, > > On windows if you use the HOLD keyword on the SETPTR statement, the > resulting print job will end up in the spooler directory of the system. > > On my XP based system this directory is > > WINDOWS\system32\spool\PRINTERS > > There will be two files, one being a control file and the other being > the actual print job. > > Hope that this helps > > Chris Day > Technical Pre-Sales Specialist > Meier Business Systems > Melbourne * Sydney * Kuala Lumpur * Singapore > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of John Kent > Sent: Friday, 9 June 2006 9:52 AM > To: U2Users > Subject: [U2] SETPTR MODE 1 > > I have been looking at Universe in PICK flavour on Windows. > > Does anyone know where the output goes with setptr mode 1 and HOLD. > (I have always used mode 3) > > Is it accessible in basic with a file read. > > where is the SPOOL - LIST job description data kept and can i access > this in > basic > > It seems like there is a gui front end for spooler management under unix > but > not in windows > I would like to be able to come up with something that works with either > if > thats possible. > > jak > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > CAUTION: This email and any attachments are confidential, may be privileged, and are intended for use solely by the addressee. The confidentiality and/or privilege in this email is not waived, lost or destroyed if it has been transmitted to you in error. If you receive this email in error, please notify MBS by reply email immediately, delete the email and destroy any printed copies. You must not disclose, disseminate, distribute, reproduce or use the information contained in this
RE: [U2] ODBC question [ad]
Angelo Collazo wrote: > After researching the data extraction from an SQL database via > UniData/BCI running on AIX I have realized that a third party ODBC > driver is needed for UNIX to behave like a client. An install > document called "How to set up the Easysoft ODBC-ODBC Bridge with > UniData was sent to me by one of our fellow groupies.( Brian Leach). > I have found the following so far(still searching): > > 1- Easysoft USD 1399.00 for a single license > 2- OpenAccessSoftware USD $995.00for a single cpu > > Question: > a- Anyone using another lower cost vendor's ODBC driver and can > share the cost? And if so, are you happy with it. I really don't like the idea of hard-coding SQL for a relational database into code that is in another database. That's really bad form in terms of separation of functions and tiers - anyone who reads material on Design Patterns (Gang of Four, et al) should cringe at this sort of thing. The best approach is to have your U2 code invoke a business process that says "I need data", pass the request up to a tier that specializes in getting that sort of data, and return pure data to your application. If you change which database you're using on the outside (relational, XML or otherwise), or the schema or rules used to interact with your external database, you shouldn't need to change your U2 code. ADO.NET was created to solve problems like this, and mv.NET is an ideal solution for lots of problems that involve exchanging data between MV and other databases and environments. Specifically, you can send your request up from U2 to a middle tier and then use completely free data access tools to get into any one or more databases out there. Write the requests in real SQL, not via BCI, get back a result set, and pass it back to U2 as a set of files and/or dynamic arrays, or callbacks to BASIC programs. Why can't you use UO, UOJ, or UO.NET? These libraries don't provide for server-side triggers that invoke remote events - mv.NET does. There is a license for an mv.NET developer but: 1) You can use mv.NET for _many_ purposes, not just one. It seems like whenever people have a specific problem they get an answer specific to that problem - have another problem, get another answer. With development tools like mv.NET you get one solution to lots of problems, making your collection of tools much smaller and more manageable. 2) End-user sites don't need developer licenses and the low cost for an end-user session license is quite reasonable. This is far better than the above mentioned prices per server - and I believe those products are limited to processing one query at a time, which is hardly acceptable in a multi-user environment. In the next week or so I'll try to write up another freeware offering which will demonstrate what I'm describing above. Your U2 code should just call a BASIC program which makes a request, and the return parameters will be the data you want - with no SQL or ODBC or other stuff involved in the U2 side. My freeware that relies on mv.NET of course requires an mv.NET license - you can contact me for a free evaluation or regular license. Inquiries welcome, especially from someone willing to test the code, or from people with special relational database requirements (SQL Server, Oracle, DB2, MS Access, MySQL, Firebird, etc). Until that's done, some of you may be interested in another freeware offering I wrote that uses mv.NET to invoke any command or query from any MV DBMS from any PC. So you can go to your DOS prompt and run programs in your AIX system, run reports from .BAT files, or shell out from VB code to execute U2 functions and return results for rendering or data transfer, etc. See this link for files related to MVExec: http:// removethisNebula-RnD.com/freeware/ (anti-spam precaution: just copy the text starting at Nebula into your browser address area.) HTH Tony Gravagno, Nebula R&D TG@ again,removethispartNebula-RnD.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] FW: [UV] Change in behaviour of "EXECUTE ... CAPTURING" at 10.1.18 {Unclassified}
Thanks, Kurt
This is a good suggestion, but unfortunately it will not work for
us - the guy doing the work has tested it.
It won't work because we are using UV SQL to produce XML not UV
RetrieVe, because our process needs to join multiple files. The "TO"
key-word is not permitted in the UV SQL Select statement syntax.
Regards
Mike
> -Original Message-
> From: [EMAIL PROTECTED] On Behalf Of Kurt Neumann
> Sent: Monday, 12 June 2006 18:44
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] FW: [UV] Change in behaviour of "EXECUTE
> ... CAPTURING" at 10.1.18 {Unclassified}
>
> Hi Mike
>
> Sorry I am responding so late. Another option you could use
> is to add to your RetrieVe statement: TO docname. This will
> then send your XML output to the &XML& file with no page
> breaks. Your syntax would be something like:
> EXECUTE "LIST filename criteria TOXML TO xmldocname".
>
> Thanks
> Kurt Neumann; IBM Certified Solutions Expert
> U2 Support and Training @ Workgroup
> Work Phone: +2711 654 6175
> Fax Number: +2711 654 6375
> Cell Phone: +2782 825 5011
> Website:www.utwo.co.za
> e-Mail: [EMAIL PROTECTED]
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] ODBC question
After researching the data extraction from an SQL database via UniData/BCI running on AIX I have realized that a third party ODBC driver is needed for UNIX to behave like a client. An install document called "How to set up the Easysoft ODBC-ODBC Bridge with UniData was sent to me by one of our fellow groupies.( Brian Leach). I have found the following so far(still searching): 1- Easysoft USD 1399.00 for a single license 2- OpenAccessSoftware USD $995.00for a single cpu Question: a- Anyone using another lower cost vendor's ODBC driver and can share the cost? And if so, are you happy with it. Cheers, Angelo Collazo System Administrator Silver Line Windows -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dana Baron Sent: Thursday, June 08, 2006 9:33 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] ODBC question Hi Marc, Good question. Yes we have licenses for both Unidata and ODBC, however, our server crashed hard a few months ago and I had to re-install Unidata (and just about everything else). I haven't tried using ODBC since then. It could be that the ODBC license wasn't re-installed correctly. Dana Baron System Manager Smugglers' Notch Resort -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson Sent: Thursday, June 08, 2006 8:08 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] ODBC question Do you have a license to use ODBC? Or Is your UniData licensed? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dana Baron Sent: Thursday, June 08, 2006 8:11 AM To: U2-Users Subject: [U2] ODBC question Hi, While we're talking Unidata ODBC... I'm having trouble getting UNIDATA ODBC working here. Server is Tru64 Unix. Client is windows. UCI seems to be set up correctly. I can access the data and create views, etc with VSG. But, when I try to import or link to the data from Access or Excel, I get the following error: The ODBC screen pops up with most of the parameters filled in, except my password. I put in the password (and yes, I've tried it a million times and the password is correct!) and an error pop-up says: [Ardent][Unidata ODBC Driver][IBM][SQL Client][UNIDATA]Server is not authorized Anyone have any suggestions? Dana Baron System Manager Smugglers' Notch Resort --- 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/
Re: [U2] RESIZE DYNAMIC FILES
[EMAIL PROTECTED] wrote on 06/12/2006 12:57:03 PM: > What does the guide -r option do ? > > We have been using the -a option. The -r option sends guide output to a hashed file. This makes it very easy to select for files that are undersized, or that have corruption. So I'll often do a CREATE.FILE DATA UDT_GUIDE 101, then edit the VOC entry of UDT_GUIDE so attribute 3 points to @UDTHOME/sys/D_UDT_GUIDE. Then I can do something like this from ECL: !guide /some_dir/some_file -na -ne -ns -r UDT_GUIDE This will create a record in UDT_GUIDE keyed as /some_dir/some_file. With that information for all of your files, you can do something like this: list UDT_GUIDE WITH STATUS LIKE ...2 (to find files with level 2 overflow) list UDT_GUIDE WITH STATUS LIKE Err... (to file files with corruption) list UDT_GUIDE MAXSIZ AVGSIZ DEVSIZ COUNT AVGKEY (to get the info for the dynamic file sizing calculations) It's SO much easier than writing code to parse through the text output of guide. Tim Snyder Consulting I/T Specialist , U2 Professional Services North American Lab Services DB2 Information Management, IBM Software Group 717-545-6403 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RESIZE DYNAMIC FILES
We have used the product here before. I think our license on it lapsed. I have been using the guide for several years instead of using fast. "Hennessey, Mark F." <[EMAIL PROTECTED]> wrote: Should I put [AD] in the subject line for an "unsolicited testimonial"? :) The best advice I can give you is to buy a product called FAST: http://www.fitzlong.com/ A great tool for analyzing and resizing files, be they dynamic or standard hashed files. Excellent support from excellent people at a great price. There might be more expensive utilities out there, but I can't imagine that there is anything better. Mark Hennessey (a FAST Customer since 2002) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave S Sent: Monday, June 12, 2006 10:25 AM To: u2-users@listserver.u2ug.org Subject: [U2] RESIZE DYNAMIC FILES Does anyone have any tech tips on how to select parameters when resizing dynamic files ? __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.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/ __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RESIZE DYNAMIC FILES
What does the guide -r option do ? We have been using the -a option. Timothy Snyder <[EMAIL PROTECTED]> wrote: [EMAIL PROTECTED] wrote on 06/12/2006 10:24:51 AM: > Does anyone have any tech tips on how to select parameters when > resizing dynamic files ? The following is from a published tech tip. It provides guidelines, but of course the nature of MV files makes it difficult to predict optimal sizing. To get the appropriate input data, run guide with the -r option to send the output to a hashed file. Point the dictionary of that file as directed, and you'll have what you need. It's important to note that this only applies to KEYONLY files. === Formula for determining base modulo, block size, SPLIT_LOAD, and MERGE_LOAD for UniData KEYONLY Dynamic Files Note that the variables used are the same as the DICT items in $UDTHOME/sys/D_UDT_GUIDE. Considerations: a) The following does not take into account the Unix disk record (frame) size so it is best to select a block size based on the number of items you?d like in a group. b) No one method will provide absolute results but these calculations will minimize level one overflow caused by a high SPLIT_LOAD value. c) Type 0 works best for most Dynamic Files but it is best to check a small sample via the GROUP.STAT command. Step 1: Determine the blocksize. (Use 4096 unless the Items per group is larger then 35 or less then 2) A) If the MAXSIZ < 1K ITEMSIZE = 10 * MAXSIZ B) If 1 K < MAXSIZ < 3 K ITEMSIZE = 5 * MAXSIZ C) If MAXSIZ > 3 K ITEMSIZE = 5 * (AVGSIZ + DEVSIZ) Once you determine the item size, use it to determine the NEWBLOCKSIZE. A) ITEMSIZE < 1024; NEWBLOCKSIZE = 1024 B) 1024 > ITEMSIZE < 2048; NEWBLOCKSIZE = 2048 C) 2048 > ITEMSIZE < 4096; NEWBLOCKSIZE = 4096 D) 4096 > ITEMSIZE < 8192; NEWBLOCKSIZE = 8192 E) 8192 > ITEMSIZE < 16384; NEWBLOCKSIZE = 16384 Step 2: Determine the actual number of items per group. ITEMS_PER_GROUP = NEWBLOCKSIZE-32 / AVGSIZ Step 3: Determine the base modulo BASEMODULO = COUNT / ITEMS_PER_GROUP Step 4: Determine SPLIT_LOAD SPLIT_LOAD=INTAVGKEY + 9)*ITEMS_PER_GROUP)/NEW_BLOCKSIZE)*100)+1 If the SPLIT_LOAD is less then ten then: SPLIT_LOAD = 10 Step 5: Determine MERGE_LOAD MERGE_LOAD = SPLIT_LOAD / 2 (Rounded up) Tim Snyder Consulting I/T Specialist , U2 Professional Services North American Lab Services DB2 Information Management, IBM Software Group 717-545-6403 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RESIZE DYNAMIC FILES
[EMAIL PROTECTED] wrote on 06/12/2006 10:24:51 AM: > Does anyone have any tech tips on how to select parameters when > resizing dynamic files ? The following is from a published tech tip. It provides guidelines, but of course the nature of MV files makes it difficult to predict optimal sizing. To get the appropriate input data, run guide with the -r option to send the output to a hashed file. Point the dictionary of that file as directed, and you'll have what you need. It's important to note that this only applies to KEYONLY files. === Formula for determining base modulo, block size, SPLIT_LOAD, and MERGE_LOAD for UniData KEYONLY Dynamic Files Note that the variables used are the same as the DICT items in $UDTHOME/sys/D_UDT_GUIDE. Considerations: a) The following does not take into account the Unix disk record (frame) size so it is best to select a block size based on the number of items you?d like in a group. b) No one method will provide absolute results but these calculations will minimize level one overflow caused by a high SPLIT_LOAD value. c) Type 0 works best for most Dynamic Files but it is best to check a small sample via the GROUP.STAT command. Step 1: Determine the blocksize. (Use 4096 unless the Items per group is larger then 35 or less then 2) A) If the MAXSIZ < 1K ITEMSIZE = 10 * MAXSIZ B) If 1 K < MAXSIZ < 3 K ITEMSIZE = 5 * MAXSIZ C) If MAXSIZ > 3 K ITEMSIZE = 5 * (AVGSIZ + DEVSIZ) Once you determine the item size, use it to determine the NEWBLOCKSIZE. A) ITEMSIZE < 1024; NEWBLOCKSIZE = 1024 B) 1024 > ITEMSIZE < 2048; NEWBLOCKSIZE = 2048 C) 2048 > ITEMSIZE < 4096; NEWBLOCKSIZE = 4096 D) 4096 > ITEMSIZE < 8192; NEWBLOCKSIZE = 8192 E) 8192 > ITEMSIZE < 16384; NEWBLOCKSIZE = 16384 Step 2: Determine the actual number of items per group. ITEMS_PER_GROUP = NEWBLOCKSIZE-32 / AVGSIZ Step 3: Determine the base modulo BASEMODULO = COUNT / ITEMS_PER_GROUP Step 4: Determine SPLIT_LOAD SPLIT_LOAD=INTAVGKEY + 9)*ITEMS_PER_GROUP)/NEW_BLOCKSIZE)*100)+1 If the SPLIT_LOAD is less then ten then: SPLIT_LOAD = 10 Step 5: Determine MERGE_LOAD MERGE_LOAD = SPLIT_LOAD / 2 (Rounded up) Tim Snyder Consulting I/T Specialist , U2 Professional Services North American Lab Services DB2 Information Management, IBM Software Group 717-545-6403 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] IBM U2 UniData ODBC sample working program
Symeon, 1- What vendor are you using for the ODBC libraries/driver running under UNIX? 2- Are you happy with them 3- Cheers, Angelo Collazo System Administrator Silver Line Windows -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Symeon Breen Sent: Friday, June 02, 2006 9:48 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] IBM U2 UniData ODBC sample working program Angelo - I have lots - i will send one on to you off list if that is ok Symeon. On 02/06/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Angelo > > Do you mean ODBC from UniData (BCI) or into UniData (UniODBC?) > > For BCI, check the (new) knowledge base at: > www.mvopen.org/kb/ > > There is an article on there "Accessing SQL Data through BCI". > This takes you through the steps and there is demo data/programs > available. > > For ODBC, I have a similar article - but I can't post it yet! (I'm still > waiting for the official publication before I'm allowed to do that). But if > you email me offlist I can send you a copy. > > Brian > > >After searching the archive and to no avail, I would like to know if > anyone > >has a sample working program or (BCI.DEMO) working that could share a > copy > >of it. > > > >Cheers, > > > >Angelo > >--- > >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/
RE: [U2] RESIZE DYNAMIC FILES
Should I put [AD] in the subject line for an "unsolicited testimonial"? :) The best advice I can give you is to buy a product called FAST: http://www.fitzlong.com/ A great tool for analyzing and resizing files, be they dynamic or standard hashed files. Excellent support from excellent people at a great price. There might be more expensive utilities out there, but I can't imagine that there is anything better. Mark Hennessey (a FAST Customer since 2002) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave S Sent: Monday, June 12, 2006 10:25 AM To: u2-users@listserver.u2ug.org Subject: [U2] RESIZE DYNAMIC FILES Does anyone have any tech tips on how to select parameters when resizing dynamic files ? __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.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] RESIZE DYNAMIC FILES
Does anyone have any tech tips on how to select parameters when resizing dynamic files ? __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
