RE: [U2] UV objects question
We found the best way is to have all the logic in databasic. Call a subroutine to return the data you want. This can be tested before it is used within VB. Les Sherlock Hewkin Project Manager Group Financial Systems I.T. Department Rye Hill House T 01604 592289 M 07917 856195 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brenda Price Sent: 02 June 2008 22:44 To: u2-users@listserver.u2ug.org Subject: [U2] UV objects question We have a VB process that looks for a record in a set of files PRINT.TODAY (today's file), PRINT.HIST.0508, PRINT.HIST.0408 etc. If the record is not in those files it reads a file called INTERIM.LETTERS. Once the data is found a IE html document is displayed to screen. We keep the date in the record id, so a record written today would first try the PRINT.TODAY file, then the PRINT.HIST.0608 (which does not get created until after 5 pm on the first business day of the month), then the INTERIM.LETTERS file. Each night after 5 pm all data in the file PRINT.TODAY is moved to current month year file. Tonight it would be the PRIINT.HIST.0608 file, normally it would find that the file isn't there and create it. On the first business day of the month, this file has not yet been created and when the process gets to that file something is happening that causes the next file INTERIM.LETTERS to be skipped. When they decided the problem must be that the file is not there yet and had me create the file, the problem went away. Our VB programmers say they have checked every error they can think of and the process is not returning an error that they can recognize. What error would be returned when a program tries via UV Objects to read a file that does not exist? Brenda Price Affiliated Acceptance Corporation Sunrise Beach, MO --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD
Jak: This worked fine for me in an EVAL. UD v7.1 in Win 2K3 with ECLTYPE = Pick. :list APOPEN ACCTS AMTS EVAL "DCOUNT(EXTRACT(@RECORD, 9, 0, 0), @VM)" COL.HDG "Cnt" APOPEN ACCT. ACCT/AMTS Cnt... 69*7 2090270.06 1 830*38779 3060120.64 2 3070111.13 830*38750 3060 63.03 2 3070 51.78 830*38895 3060 37.15 2 3070 52.51 Bill >-Original Message- >From: [EMAIL PROTECTED] [mailto:owner-u2- >[EMAIL PROTECTED] On Behalf Of John Kent >Sent: Monday, June 02, 2008 8:11 PM >To: u2-users@listserver.u2ug.org >Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD > >Jeff, >what actually worked was... > >DCOUNT(EXTRACT(@RECORD,30,0,0),@VM) > >doesn't seem to work in an EVAL though >eg >LIST STK EVAL "DCOUNT(EXTRACT(@RECORD,30,0,0),@VM)" A30 > >jak >- Original Message - >From: "John Kent" <[EMAIL PROTECTED]> >To: >Sent: Tuesday, June 03, 2008 11:38 AM >Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD > > >> Jeff, >>that'll do, thanks >> jak >> - Original Message - >> From: "Jeff Butera" <[EMAIL PROTECTED]> >> To: >> Sent: Tuesday, June 03, 2008 11:08 AM >> Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD >> >> >>> On Tue, 3 Jun 2008, John Kent wrote: >>> Ken, i want to create a simple dict item like ED DICT STK JAK Top of "JAK" in "DICT STK", 6 lines, 38 characters. *--: P7 001: I 002: DCOUNT(@RECORD<30>,@VM) >>> >>> Try this: >>> >>> DCOUNT(EXTRACT(@RECORD,@AM,30),@VM) >>> >>> Jeff Butera, Ph.D. >>> Administrative Systems >>> Hampshire College >>> [EMAIL PROTECTED] >>> 413-559-5556 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Can the catalog space get full?
We're having weird issues here where programs that have worked forever are suddenly being reported as "UNABLE TO LOAD XYZ". Indiviually cataloging the programs fixes the problem. I'm not sure each time what the original method of cataloging was so I'm simply doing a local catalog. The problem this way is that I have to wait for something to not be found to fix it. And the way this system is written it won't tell me if it can't run a subroutine, it simply won't run it. One only picks up the data issues later. If possible I would prefer not to have to recompile anything, and I don't know how specifically these things were originally cataloged. Can the catalog space get full? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD
Jeff, what actually worked was... DCOUNT(EXTRACT(@RECORD,30,0,0),@VM) Yeah - I mixed the syntax for EXTRACT with that for FIELD. doesn't seem to work in an EVAL though eg LIST STK EVAL "DCOUNT(EXTRACT(@RECORD,30,0,0),@VM)" A30 jak - Original Message - From: "John Kent" <[EMAIL PROTECTED]> To: Sent: Tuesday, June 03, 2008 11:38 AM Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD Jeff, that'll do, thanks jak - Original Message - From: "Jeff Butera" <[EMAIL PROTECTED]> To: Sent: Tuesday, June 03, 2008 11:08 AM Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD On Tue, 3 Jun 2008, John Kent wrote: Ken, i want to create a simple dict item like ED DICT STK JAK Top of "JAK" in "DICT STK", 6 lines, 38 characters. *--: P7 001: I 002: DCOUNT(@RECORD<30>,@VM) Try this: DCOUNT(EXTRACT(@RECORD,@AM,30),@VM) Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 "He works out of his home office doing technical training. I call it gambling." Overheard at grocery store. --- 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/ Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 "He works out of his home office doing technical training. I call it gambling." Overheard at grocery store. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] wsdl
Are there any implementations of a unibasic program calling web service (jax-ws)? Our desire is to connect a SBClient screen to a web service interface hosted at one of our vendors. TIA --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] HP Laserjets and AIX/Unix
Looks like HP has discontinued the 4240, 4250, 4350 LaserJets and their various tnd models and replaced them with various models P4014, P4015 and P4515 with some new letters. While we can still find leftovers of the old models, it is only a matter of time. The only Supported operating systems Windows 2000; Windows XP Home; Windows XP Professional; Windows Server 2003; Certified for Windows Vista(R); Mac OS X v 10.2; Mac OS X v 10.3 or higher No Unix or AIX. Nor Linux for that matter. Has anybody tried one of these printers with ##IX or Linux so far? Thanks. Roger --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Windows Unidata -- adding users?
Good morning from Central Texas, I am trying to understand the ODBC connectivity with Unidata. I am having problems with privileges assigned to tables and views in my 6.0 production Unix version so I installed the 7.1 Windows personal version to do some testing with. Now I can't determine how to create a new user in the database. The install didn't create a Unidata group as the documentation suggests nor does it detail how that groups permissions should be assigned to Unidata. Any insight would be greatly appreciated. Mark This email was Anti Virus checked by Astaro Security Gateway. http://www.astaro.com MGC --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Can the catalog space get full?
For UniData: B' $UDTBIN/sbcsprogs displays active shared programs B' Size of each segment is set in udtconfig SBCS_SHM_SIZE B' $UDTBIN/ipcstat bmb | grep sbcs b Lists all sbcs segments. B' udt processes attach sbcs segments as needed b Depends on which segments contain the programs they are running B' Canbt have more than 20 sbcs segments. A udt process trying to load another program that requires the 21st sbcs segment to be created will fail with: bNumra is maxed out in installshmidb Wally Terhune SWG Client Support - Information Management Software U2 Support Architect - IBM U2 Client Support Team 4700 S. Syracuse St., Denver, CO 80237 Tel: (303) 773-7969 Mobile: (303) 807-6222 T/L: 656-7969 [EMAIL PROTECTED] From: "Dennis Bartlett" <[EMAIL PROTECTED]> To: Date: 06/03/2008 07:14 AM Subject:[U2] Can the catalog space get full? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] wsdl
Hi yes - take a look at the unibasic extensions manual for the http and soap client functions. If you want an example I can provide some. Rgds Symeon. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Sent: 03 June 2008 13:39 To: u2-users@listserver.u2ug.org Subject: [U2] wsdl Are there any implementations of a unibasic program calling web service (jax-ws)? Our desire is to connect a SBClient screen to a web service interface hosted at one of our vendors. TIA --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG. Version: 8.0.100 / Virus Database: 269.24.6/1480 - Release Date: 6/3/2008 7:00 AM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] HP Laserjets and AIX/Unix
Seems strange that HP would have done that since they have their own 'nix, HP-UX. Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, June 03, 2008 9:36 AM To: u2-users@listserver.u2ug.org Subject: [U2] HP Laserjets and AIX/Unix Looks like HP has discontinued the 4240, 4250, 4350 LaserJets and their various tnd models and replaced them with various models P4014, P4015 and P4515 with some new letters. While we can still find leftovers of the old models, it is only a matter of time. The only Supported operating systems Windows 2000; Windows XP Home; Windows XP Professional; Windows Server 2003; Certified for Windows Vista(R); Mac OS X v 10.2; Mac OS X v 10.3 or higher No Unix or AIX. Nor Linux for that matter. Has anybody tried one of these printers with ##IX or Linux so far? Thanks. Roger --- 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] Unidata 7.1 ODBC Threading Problems?
Is the Unidata 7.1 ODBC driver thread/process safe? As I've written in previous posts, one of my customers has this Zeacom phone system that has the ability to call a (VBScript) script to gather information from a back-end database so that it can display that information for a customer service rep handing the call. Conceptually, it's really slick. I had originally written the script using UniObjects, but the customer demanded that we use only ODBC to gather the information from Unidata, so I rewrote the script using ODBC. This script opens a connection to Unidata, calls a subroutine, gathers the results, and then returns the text result to the phone system. Like I said, it's really slick... ...except when there are two calls that come in basically at the same time. If there's a open ODBC connection to Unidata processing one call and another call comes in and opens up another ODBC connection (from the same Windows machine from a different process) one or both of the connections craps out, leaving a connection open and a license consumed. We can log these off with UniAdmin no problem, but it's a hassle having to watch the user table pretty much all day to prevent all of the licenses from being consumed. The message as logged by the phone system looks like this: 11:33:46.26 01803d90 QueryThread x755fe0: !! ERROR !! QmScript::Script: Error 0x80004005 Line 114 "'D:\Program Files\Zeacom\CTI\Enhanced Routing\EnhancedRouting.vbs' line 114: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed" Line 114 of this script is opening the ODBC connection. Not only did this particular connection fail, but the connection that was in progress when this one was started died unexpectedly as well, leaving an open connection and consumed license. This script really isn't rocket science, and it's vexing me that we can't seem to have multiple open ODBC connections from the same Windows server into Unidata. Is this just a fact of life with Unidata and ODBC, or is there a solution? -Kevin http://www.PrecisOnline.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] HP Laserjets and AIX/Unix
The 4250 doesn't have *nix listed as a supported operating system, either. Since you're probably just sending plain text or embedding your own PCL commands, I would expect it to work ok. I suspect the "supported" is really referring to the interoperability of the printer with the OS ("Hi, I'm an HP 4250dtn! Please tell me you're not Windows Vista!") ;-) Drew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of JPB-U2UG Sent: Tuesday, June 03, 2008 11:35 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] HP Laserjets and AIX/Unix Seems strange that HP would have done that since they have their own 'nix, HP-UX. Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, June 03, 2008 9:36 AM To: u2-users@listserver.u2ug.org Subject: [U2] HP Laserjets and AIX/Unix Looks like HP has discontinued the 4240, 4250, 4350 LaserJets and their various tnd models and replaced them with various models P4014, P4015 and P4515 with some new letters. While we can still find leftovers of the old models, it is only a matter of time. The only Supported operating systems Windows 2000; Windows XP Home; Windows XP Professional; Windows Server 2003; Certified for Windows Vista(R); Mac OS X v 10.2; Mac OS X v 10.3 or higher No Unix or AIX. Nor Linux for that matter. Has anybody tried one of these printers with ##IX or Linux so far? Thanks. Roger --- 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] re:form multiple spreadsheets excel file in universe
Hi everyone, We have the program which runs and creates separate excel files for relational data. We want to put all this data in one file but on separate work sheets. Does anyone know how we can implement it? Irina Lissok. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] wsdl
o;?Symeon, My manual (Version 6.0) don't have any reference to SOAP. Is this UV only? I have Unidata ver 6.1.15. Thanks. On Tue, 2008-06-03 at 15:19 +0100, Symeon Breen wrote: > Hi yes - take a look at the unibasic extensions manual for the http and soap > client functions. If you want an example I can provide some. > > > Rgds > Symeon. > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Jeff > Sent: 03 June 2008 13:39 > To: u2-users@listserver.u2ug.org > Subject: [U2] wsdl > > Are there any implementations of a unibasic program calling web service > (jax-ws)? > > Our desire is to connect a SBClient screen to a web service interface > hosted at one of our vendors. > > TIA > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > No virus found in this incoming message. > Checked by AVG. > Version: 8.0.100 / Virus Database: 269.24.6/1480 - Release Date: 6/3/2008 > 7:00 AM > --- > 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] Wellington, New Zealand User Group
I have recently moved back to Wellington. Anyone interested in getting together informally or even formally to establish a user group around U2? You can email here or contact me directly if interested. Cheers, David Murray [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] re:form multiple spreadsheets excel file in universe
Import each excel file on a separate tab? - Original Message - From: Irina Lissok Date: Tuesday, June 3, 2008 5:32 pm Subject: [U2] re:form multiple spreadsheets excel file in universe To: u2-users@listserver.u2ug.org > Hi everyone, > > We have the program which runs and creates separate excel files for > relational data. We want to put all this data in one file but on > separate work sheets. Does anyone know how we can implement it? > > > > Irina Lissok. > --- > 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] wsdl
You should be able to find some info in the UniBASIC Extensions manual for 6.1. On Tue, Jun 3, 2008 at 2:42 PM, Jeff Powell <[EMAIL PROTECTED]> wrote: > o;?Symeon, > > My manual (Version 6.0) don't have any reference to SOAP. Is this UV > only? > > I have Unidata ver 6.1.15. > > Thanks. > > > On Tue, 2008-06-03 at 15:19 +0100, Symeon Breen wrote: > > > Hi yes - take a look at the unibasic extensions manual for the http and > soap > > client functions. If you want an example I can provide some. > > > > > > Rgds > > Symeon. > > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Jeff > > Sent: 03 June 2008 13:39 > > To: u2-users@listserver.u2ug.org > > Subject: [U2] wsdl > > > > Are there any implementations of a unibasic program calling web service > > (jax-ws)? > > > > Our desire is to connect a SBClient screen to a web service interface > > hosted at one of our vendors. > > > > TIA > > --- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > > No virus found in this incoming message. > > Checked by AVG. > > Version: 8.0.100 / Virus Database: 269.24.6/1480 - Release Date: 6/3/2008 > > 7:00 AM > > --- > > 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/ > -- -Kevin http://www.PrecisOnline.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] re:form multiple spreadsheets excel file in universe
You can use Excel's XML features to create one sheet that has multiple tabs, colors, formulae, etc. Warning, however, it's complicated. Create a sheet in Excel and save it as XML and you'll see the basic structure of the document. I used to have a link to a page @ Microsoft that described the different tags, but that page is gone now for some reason. On Tue, Jun 3, 2008 at 3:50 PM, <[EMAIL PROTECTED]> wrote: > Import each excel file on a separate tab? > > - Original Message - > From: Irina Lissok > Date: Tuesday, June 3, 2008 5:32 pm > Subject: [U2] re:form multiple spreadsheets excel file in universe > To: u2-users@listserver.u2ug.org > > > Hi everyone, > > > > We have the program which runs and creates separate excel files for > > relational data. We want to put all this data in one file but on > > separate work sheets. Does anyone know how we can implement it? > > > > > > > > Irina Lissok. > > --- > > 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/ > -- -Kevin http://www.PrecisOnline.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD
Bill, not for me though LIST STK EVAL "DCOUNT(EXTRACT(@RECORD,30,0,0),@VM)" 09:01:48 04 Jun 2008 1 STK... Illegal attribute: select criteria EVAL is not a field. whereas an itype will ED DICT STK JAK Top of "JAK" in "DICT STK", 6 lines, 50 characters. 001: I 002: DCOUNT(EXTRACT(@RECORD,30,0,0),@VM) 003: MD0 i am not familiar with Unidata nor they way this machine is configured but it annoying when simple things like this dont work jak - Original Message - From: "Bill Haskett" <[EMAIL PROTECTED]> To: Sent: Tuesday, June 03, 2008 7:06 PM Subject: RE: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD Jak: This worked fine for me in an EVAL. UD v7.1 in Win 2K3 with ECLTYPE = Pick. :list APOPEN ACCTS AMTS EVAL "DCOUNT(EXTRACT(@RECORD, 9, 0, 0), @VM)" COL.HDG "Cnt" APOPEN ACCT. ACCT/AMTS Cnt... 69*7 2090270.06 1 830*38779 3060120.64 2 3070111.13 830*38750 3060 63.03 2 3070 51.78 830*38895 3060 37.15 2 3070 52.51 Bill -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of John Kent Sent: Monday, June 02, 2008 8:11 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD Jeff, what actually worked was... DCOUNT(EXTRACT(@RECORD,30,0,0),@VM) doesn't seem to work in an EVAL though eg LIST STK EVAL "DCOUNT(EXTRACT(@RECORD,30,0,0),@VM)" A30 jak - Original Message - From: "John Kent" <[EMAIL PROTECTED]> To: Sent: Tuesday, June 03, 2008 11:38 AM Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD Jeff, that'll do, thanks jak - Original Message - From: "Jeff Butera" <[EMAIL PROTECTED]> To: Sent: Tuesday, June 03, 2008 11:08 AM Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD On Tue, 3 Jun 2008, John Kent wrote: Ken, i want to create a simple dict item like ED DICT STK JAK Top of "JAK" in "DICT STK", 6 lines, 38 characters. *--: P7 001: I 002: DCOUNT(@RECORD<30>,@VM) Try this: DCOUNT(EXTRACT(@RECORD,@AM,30),@VM) Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 --- 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] Is there a UNIDATA equivalent of Universe Itype
Hi, Note that in Bill's example, he typed "list" in *lower-case*. That's why it worked. If you're running ECLTYPE P (Pick mode) and you issue Unidata commands in lower-case, the commands will run using ECLTYPE U, which is required to use EVAL. This (possibly undocumented) feature is a great way to get the best of both ECL worlds, and we use it all the time here. Enjoy, Tom Derwin >>> [EMAIL PROTECTED] 06/03/08 6:41 PM >>> Bill, not for me though LIST STK EVAL "DCOUNT(EXTRACT(@RECORD,30,0,0),@VM)" 09:01:48 04 Jun 2008 1 STK... Illegal attribute: select criteria EVAL is not a field. whereas an itype will ED DICT STK JAK Top of "JAK" in "DICT STK", 6 lines, 50 characters. 001: I 002: DCOUNT(EXTRACT(@RECORD,30,0,0),@VM) 003: MD0 i am not familiar with Unidata nor they way this machine is configured but it annoying when simple things like this dont work jak - Original Message - From: "Bill Haskett" <[EMAIL PROTECTED]> To: Sent: Tuesday, June 03, 2008 7:06 PM Subject: RE: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD > Jak: > > This worked fine for me in an EVAL. UD v7.1 in Win 2K3 with ECLTYPE = > Pick. > > :list APOPEN ACCTS AMTS EVAL "DCOUNT(EXTRACT(@RECORD, 9, 0, 0), @VM)" > COL.HDG "Cnt" > > APOPEN ACCT. ACCT/AMTS Cnt... > > 69*7 2090270.06 1 > 830*38779 3060120.64 2 > 3070111.13 > 830*38750 3060 63.03 2 > 3070 51.78 > 830*38895 3060 37.15 2 > 3070 52.51 > > Bill > >>-Original Message- >>From: [EMAIL PROTECTED] [mailto:owner-u2- >>[EMAIL PROTECTED] On Behalf Of John Kent >>Sent: Monday, June 02, 2008 8:11 PM >>To: u2-users@listserver.u2ug.org >>Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD >> >>Jeff, >>what actually worked was... >> >>DCOUNT(EXTRACT(@RECORD,30,0,0),@VM) >> >>doesn't seem to work in an EVAL though >>eg >>LIST STK EVAL "DCOUNT(EXTRACT(@RECORD,30,0,0),@VM)" A30 >> >>jak >>- Original Message - >>From: "John Kent" <[EMAIL PROTECTED]> >>To: >>Sent: Tuesday, June 03, 2008 11:38 AM >>Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD >> >> >>> Jeff, >>>that'll do, thanks >>> jak >>> - Original Message - >>> From: "Jeff Butera" <[EMAIL PROTECTED]> >>> To: >>> Sent: Tuesday, June 03, 2008 11:08 AM >>> Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype >>> @RECORD >>> >>> On Tue, 3 Jun 2008, John Kent wrote: > Ken, > i want to create a simple dict item like > > ED DICT STK JAK > Top of "JAK" in "DICT STK", 6 lines, 38 characters. > *--: P7 > 001: I > 002: DCOUNT(@RECORD<30>,@VM) Try this: DCOUNT(EXTRACT(@RECORD,@AM,30),@VM) Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 > --- > 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/ - This e-mail and any attachments may contain CONFIDENTIAL information, including PROTECTED HEALTH INFORMATION. If you are not the intended recipient, any use or disclosure of this information is STRICTLY PROHIBITED; you are requested to delete this e-mail and any attachments, notify the sender immediately, and notify the LabCorp Privacy Officer at [EMAIL PROTECTED] or call (877) 23-HIPAA / (877) 234-4722. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] re:form multiple spreadsheets excel file in universe
Depends a lot on HOW you are getting data into the spreadsheet in the first place --> we normally just use script & the DOM to go & create new worksheets, load data etc --> if your current mechanism is simply to write flat data out to a text file, then you are likely to have more of a problem ... or at least the format of your flat data is likely to need a more radical change Ross Ferris Stamina Software Visage > Better by Design! >-Original Message- >From: [EMAIL PROTECTED] [mailto:owner-u2- >[EMAIL PROTECTED] On Behalf Of Irina Lissok >Sent: Wednesday, 4 June 2008 6:33 AM >To: u2-users@listserver.u2ug.org >Subject: [U2] re:form multiple spreadsheets excel file in universe > >Hi everyone, > >We have the program which runs and creates separate excel files for >relational data. We want to put all this data in one file but on >separate work sheets. Does anyone know how we can implement it? > > > >Irina Lissok. >--- >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] Is there a UNIDATA equivalent of Universe Itype @RECORD
John Kent wrote: LIST STK EVAL "DCOUNT(EXTRACT(@RECORD,30,0,0),@VM)" 09:01:48 04 Jun 2008 1 STK... Illegal attribute: select criteria EVAL is not a field. whereas an itype will ED DICT STK JAK Top of "JAK" in "DICT STK", 6 lines, 50 characters. 001: I 002: DCOUNT(EXTRACT(@RECORD,30,0,0),@VM) 003: MD0 i am not familiar with Unidata nor they way this machine is configured but it annoying when simple things like this dont work It does work just fine in UniData in ECLTYPE U It does not work in ECLTYPE P (pick). Try your statement in the $UDTHOME/demo account using filename STUDENT and attribute 6 instead of 30 Wally Terhune SWG Client Support - Information Management Software U2 Support Architect - IBM U2 Client Support Team 4700 S. Syracuse St., Denver, CO 80237 Tel: (303) 773-7969 Mobile: (303) 807-6222 T/L: 656-7969 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD
John, Try using lower case "list", this will force ECLTYPE U (Unidata) flavor. Don Verhagen - Original Message - From: "John Kent" <[EMAIL PROTECTED]> To: Sent: Tuesday, June 03, 2008 6:41 PM Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD | Bill, |not for me though | | LIST STK EVAL "DCOUNT(EXTRACT(@RECORD,30,0,0),@VM)" 09:01:48 04 Jun 2008 1 | STK... | | Illegal attribute: | select criteria EVAL is not a field. | | whereas an itype will | ED DICT STK JAK | Top of "JAK" in "DICT STK", 6 lines, 50 characters. | 001: I | 002: DCOUNT(EXTRACT(@RECORD,30,0,0),@VM) | 003: MD0 | | i am not familiar with Unidata nor they way this machine is configured but | it annoying when simple things like this dont work | | jak | | - Original Message - | From: "Bill Haskett" <[EMAIL PROTECTED]> | To: | Sent: Tuesday, June 03, 2008 7:06 PM | Subject: RE: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD | | | > Jak: | > | > This worked fine for me in an EVAL. UD v7.1 in Win 2K3 with ECLTYPE = | > Pick. | > | > :list APOPEN ACCTS AMTS EVAL "DCOUNT(EXTRACT(@RECORD, 9, 0, 0), @VM)" | > COL.HDG "Cnt" | > | > APOPEN ACCT. ACCT/AMTS Cnt... | > | > 69*7 2090270.06 1 | > 830*38779 3060120.64 2 | > 3070111.13 | > 830*38750 3060 63.03 2 | > 3070 51.78 | > 830*38895 3060 37.15 2 | > 3070 52.51 | > | > Bill | > | >>-Original Message- | >>From: [EMAIL PROTECTED] [mailto:owner-u2- | >>[EMAIL PROTECTED] On Behalf Of John Kent | >>Sent: Monday, June 02, 2008 8:11 PM | >>To: u2-users@listserver.u2ug.org | >>Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD | >> | >>Jeff, | >>what actually worked was... | >> | >>DCOUNT(EXTRACT(@RECORD,30,0,0),@VM) | >> | >>doesn't seem to work in an EVAL though | >>eg | >>LIST STK EVAL "DCOUNT(EXTRACT(@RECORD,30,0,0),@VM)" A30 | >> | >>jak | >>- Original Message - | >>From: "John Kent" <[EMAIL PROTECTED]> | >>To: | >>Sent: Tuesday, June 03, 2008 11:38 AM | >>Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD | >> | >> | >>> Jeff, | >>>that'll do, thanks | >>> jak | >>> - Original Message - | >>> From: "Jeff Butera" <[EMAIL PROTECTED]> | >>> To: | >>> Sent: Tuesday, June 03, 2008 11:08 AM | >>> Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype | >>> @RECORD | >>> | >>> | On Tue, 3 Jun 2008, John Kent wrote: | | > Ken, | > i want to create a simple dict item like | > | > ED DICT STK JAK | > Top of "JAK" in "DICT STK", 6 lines, 38 characters. | > *--: P7 | > 001: I | > 002: DCOUNT(@RECORD<30>,@VM) | | Try this: | | DCOUNT(EXTRACT(@RECORD,@AM,30),@VM) | | Jeff Butera, Ph.D. | Administrative Systems | Hampshire College | [EMAIL PROTECTED] | 413-559-5556 | > --- | > 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] Is there a UNIDATA equivalent of Universe Itype
Tom, at last it makes sense jak - Original Message - From: "Thomas Derwin" <[EMAIL PROTECTED]> To: Sent: Wednesday, June 04, 2008 10:02 AM Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype Hi, Note that in Bill's example, he typed "list" in *lower-case*. That's why it worked. If you're running ECLTYPE P (Pick mode) and you issue Unidata commands in lower-case, the commands will run using ECLTYPE U, which is required to use EVAL. This (possibly undocumented) feature is a great way to get the best of both ECL worlds, and we use it all the time here. Enjoy, Tom Derwin [EMAIL PROTECTED] 06/03/08 6:41 PM >>> Bill, not for me though LIST STK EVAL "DCOUNT(EXTRACT(@RECORD,30,0,0),@VM)" 09:01:48 04 Jun 2008 1 STK... Illegal attribute: select criteria EVAL is not a field. whereas an itype will ED DICT STK JAK Top of "JAK" in "DICT STK", 6 lines, 50 characters. 001: I 002: DCOUNT(EXTRACT(@RECORD,30,0,0),@VM) 003: MD0 i am not familiar with Unidata nor they way this machine is configured but it annoying when simple things like this dont work jak - Original Message - From: "Bill Haskett" <[EMAIL PROTECTED]> To: Sent: Tuesday, June 03, 2008 7:06 PM Subject: RE: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD Jak: This worked fine for me in an EVAL. UD v7.1 in Win 2K3 with ECLTYPE = Pick. :list APOPEN ACCTS AMTS EVAL "DCOUNT(EXTRACT(@RECORD, 9, 0, 0), @VM)" COL.HDG "Cnt" APOPEN ACCT. ACCT/AMTS Cnt... 69*7 2090270.06 1 830*38779 3060120.64 2 3070111.13 830*38750 3060 63.03 2 3070 51.78 830*38895 3060 37.15 2 3070 52.51 Bill -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of John Kent Sent: Monday, June 02, 2008 8:11 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD Jeff, what actually worked was... DCOUNT(EXTRACT(@RECORD,30,0,0),@VM) doesn't seem to work in an EVAL though eg LIST STK EVAL "DCOUNT(EXTRACT(@RECORD,30,0,0),@VM)" A30 jak - Original Message - From: "John Kent" <[EMAIL PROTECTED]> To: Sent: Tuesday, June 03, 2008 11:38 AM Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD Jeff, that'll do, thanks jak - Original Message - From: "Jeff Butera" <[EMAIL PROTECTED]> To: Sent: Tuesday, June 03, 2008 11:08 AM Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD On Tue, 3 Jun 2008, John Kent wrote: Ken, i want to create a simple dict item like ED DICT STK JAK Top of "JAK" in "DICT STK", 6 lines, 38 characters. *--: P7 001: I 002: DCOUNT(@RECORD<30>,@VM) Try this: DCOUNT(EXTRACT(@RECORD,@AM,30),@VM) Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 --- 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/ - This e-mail and any attachments may contain CONFIDENTIAL information, including PROTECTED HEALTH INFORMATION. If you are not the intended recipient, any use or disclosure of this information is STRICTLY PROHIBITED; you are requested to delete this e-mail and any attachments, notify the sender immediately, and notify the LabCorp Privacy Officer at [EMAIL PROTECTED] or call (877) 23-HIPAA / (877) 234-4722. --- 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] Is there a UNIDATA equivalent of Universe Itype @RECORD
Jak: Are you in Pick mode or UniData mode at TCL? If in Pick mode the verb should be lower-cased "list". Bill >-Original Message- >From: [EMAIL PROTECTED] [mailto:owner-u2- >[EMAIL PROTECTED] On Behalf Of John Kent >Sent: Tuesday, June 03, 2008 3:41 PM >To: u2-users@listserver.u2ug.org >Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD > >Bill, >not for me though > >LIST STK EVAL "DCOUNT(EXTRACT(@RECORD,30,0,0),@VM)" 09:01:48 04 Jun 2008 1 >STK... > >Illegal attribute: >select criteria EVAL is not a field. > >whereas an itype will >ED DICT STK JAK >Top of "JAK" in "DICT STK", 6 lines, 50 characters. >001: I >002: DCOUNT(EXTRACT(@RECORD,30,0,0),@VM) >003: MD0 > >i am not familiar with Unidata nor they way this machine is configured but >it annoying when simple things like this dont work > >jak > >- Original Message - >From: "Bill Haskett" <[EMAIL PROTECTED]> >To: >Sent: Tuesday, June 03, 2008 7:06 PM >Subject: RE: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD > > >> Jak: >> >> This worked fine for me in an EVAL. UD v7.1 in Win 2K3 with ECLTYPE = >> Pick. >> >> :list APOPEN ACCTS AMTS EVAL "DCOUNT(EXTRACT(@RECORD, 9, 0, 0), @VM)" >> COL.HDG "Cnt" >> >> APOPEN ACCT. ACCT/AMTS Cnt... >> >> 69*7 2090270.06 1 >> 830*38779 3060120.64 2 >> 3070111.13 >> 830*38750 3060 63.03 2 >> 3070 51.78 >> 830*38895 3060 37.15 2 >> 3070 52.51 >> >> Bill >> >>>-Original Message- >>>From: [EMAIL PROTECTED] [mailto:owner-u2- >>>[EMAIL PROTECTED] On Behalf Of John Kent >>>Sent: Monday, June 02, 2008 8:11 PM >>>To: u2-users@listserver.u2ug.org >>>Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD >>> >>>Jeff, >>>what actually worked was... >>> >>>DCOUNT(EXTRACT(@RECORD,30,0,0),@VM) >>> >>>doesn't seem to work in an EVAL though >>>eg >>>LIST STK EVAL "DCOUNT(EXTRACT(@RECORD,30,0,0),@VM)" A30 >>> >>>jak >>>- Original Message - >>>From: "John Kent" <[EMAIL PROTECTED]> >>>To: >>>Sent: Tuesday, June 03, 2008 11:38 AM >>>Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD >>> >>> Jeff, that'll do, thanks jak - Original Message - From: "Jeff Butera" <[EMAIL PROTECTED]> To: Sent: Tuesday, June 03, 2008 11:08 AM Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD > On Tue, 3 Jun 2008, John Kent wrote: > >> Ken, >> i want to create a simple dict item like >> >> ED DICT STK JAK >> Top of "JAK" in "DICT STK", 6 lines, 38 characters. >> *--: P7 >> 001: I >> 002: DCOUNT(@RECORD<30>,@VM) > > Try this: > > DCOUNT(EXTRACT(@RECORD,@AM,30),@VM) > > Jeff Butera, Ph.D. > Administrative Systems > Hampshire College > [EMAIL PROTECTED] > 413-559-5556 >> --- >> 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] wsdl
Thanks Kevin, I downloaded the 6.1 series from IBM and it is in there. On Tue, 2008-06-03 at 16:08 -0600, Kevin King wrote: > You should be able to find some info in the UniBASIC Extensions manual for > 6.1. > > On Tue, Jun 3, 2008 at 2:42 PM, Jeff Powell <[EMAIL PROTECTED]> wrote: > > > o;?Symeon, > > > > My manual (Version 6.0) don't have any reference to SOAP. Is this UV > > only? > > > > I have Unidata ver 6.1.15. > > > > Thanks. > > > > > > On Tue, 2008-06-03 at 15:19 +0100, Symeon Breen wrote: > > > > > Hi yes - take a look at the unibasic extensions manual for the http and > > soap > > > client functions. If you want an example I can provide some. > > > > > > > > > Rgds > > > Symeon. > > > > > > -Original Message- > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] On Behalf Of Jeff > > > Sent: 03 June 2008 13:39 > > > To: u2-users@listserver.u2ug.org > > > Subject: [U2] wsdl > > > > > > Are there any implementations of a unibasic program calling web service > > > (jax-ws)? > > > > > > Our desire is to connect a SBClient screen to a web service interface > > > hosted at one of our vendors. > > > > > > TIA > > > --- > > > u2-users mailing list > > > u2-users@listserver.u2ug.org > > > To unsubscribe please visit http://listserver.u2ug.org/ > > > No virus found in this incoming message. > > > Checked by AVG. > > > Version: 8.0.100 / Virus Database: 269.24.6/1480 - Release Date: 6/3/2008 > > > 7:00 AM > > > --- > > > 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] re:form multiple spreadsheets excel file in universe
If you have an emulator which allows access to the Excel COM object or implements Windows Scripting (eg SBClient) it's relatively easy to do this. >-Original Message- >We have the program which runs and creates separate excel files for >relational data. We want to put all this data in one file but on >separate work sheets. Does anyone know how we can implement it? ** 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 communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/