Re: [U2] [UD] Key Length Limit? [REPOST]

type 19 files key length is based on the OS. so if HP-UX has a limit of 48 so will UD Chris Don V wrote: Is there a key length limit in UD [or SB]? I have a DIR type file (Type 19 in UV) that I'm using to download my bank files to and the filename length is 49. Yet if I do a LIST JPMORGAN_TEST I

Re: [U2] How to use change(), inside a I-Desc (UV)

maybe try using CONVERT or try adding the occurrence and begin flag to CHANGE HTH Chris George Gallen wrote: OK. Can't figure out how to execute the change function inside an I-desc. I'm trying to do: CHANGE(@ID,X,(X)) George --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please

Re: [U2] PDF docs

David Tod Sigafoos wrote: It appears now that all pdfs are for ONLINE only reading. Have I just not found the 'download' section? I think you can open them online then click save as. and save on you local drive. HTH Chris --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please

[U2] Uniobjects.NET speed/performance

over a quarter of a second. Any thoughts? Cheers Chris --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Uniobjects.NET speed/performance

a word, I happen to quite Like VB.NET) and I'm stuck with trying to make UO.NET work with it. To answer Kurt's question - I have been informed by those who know that the server is running Universe 10.1.3 - the same version as the client software. Cheers Chris -Original Message- From: [EMAIL

RE: [U2] UniObjects.NET speed/performance - PERFORMANCE SURVEY

of uodotnet.dll. In our testing, the version shipped with the current UniDK works fine on a local Universe (I was using the personal edition) but fell over *hard* when trying to communicate over the network. I'm afraid I have no More detail than that at the mo. Cheers Chris -Original Message- From

RE: [U2] K = K

that REMOVE isn't universal amongst U2 BASICs. Regards, Chris Bill writes - In UniData and D3 the REMOVE statement looks like: REMOVE variable FROM dynamic.array AT position.variable SETTING delimiter.variable This allows the explicit setting of the pointer, without resorting

RE: [U2] K = K

Doh ! And there I was thinking u2 related to any multi-value/post-relational/pick-derived or whatever it's generically called database. Thanks for the correction. And many thanks for those who pointed out the $OPTIONS EXT. This is a great help to me, not only with REMOVE but also with stuff like

RE: [U2] [UV] SYSTEM() for execution level?

HI there, Not sure that there is a SYSTEM() code but there is a UniVerse variable @LEVEL that returns the nesting level of execution statements. Hope this helps, Chris Day Pre-Sales Consultant Meier Business Systems Melbourne * Sydney * Kuala Lumpur * Singapore -Original Message

RE: [U2] UV Version

Hi Ray, If you use the command CT VOC RELLEVEL You will see the release level of the account, or to see what the version of UniVerse is installed, do the above command in the UV account. Hope this helps Chris Day Technical Pre-Sales Specialist Meier Business Systems Melbourne * Sydney

RE: [U2] U2 - MITS versus Informer

for integrating with preexisting security models, such as when Informer is sold as an embedded OEM tool. Informer 3.2 (official release date June 5th) requires only a Java 1.5 compliant JRE installed on the web server - no sdk needed. Clients require only a web browser. Chris Reeves Entrinsik

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

RE: [U2] PDF Document

Andrew We use the open source Apache Formatting Objects Processor, freely available here: http://xmlgraphics.apache.org/fop/ Chris Reeves Entrinsik, Inc. 919.848.4828 x114 [EMAIL PROTECTED] http://www.entrinsik.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED

[U2] Universe ODBC driver performance issues

things the UniVerse is using a SAN for storage. Multiple processors on the box and they are set to multi-threaded operations. During the download the CPU is utilized less than 10%. Anyone have any ideas of additional performance things to check in UniVerse? Thanks Chris --- u2-users

RE: [U2] Universe ODBC driver performance issues {Unclassified}

Mike, The NIC is reporting 1-2% busy. Can you explain I-Type Dictionary items? Is an I-Type Dictionary Item equivalent to a I-descriptor? Sorry I am new to UniVerse, Thanks for your patience!!! Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf

RE: [U2] Universe ODBC driver performance issues {Unclassified}

John, It is abysmal because the NIC and the Ethernet are both gigabit. Thanks, Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Hester Sent: Thursday, August 10, 2006 7:19 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe ODBC

RE: [U2] Universe ODBC driver performance issues {Unclassified}

David We are pulling data into SQL Server from UniVerse through an ODBC connection. Thanks Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: Friday, August 11, 2006 4:44 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2

RE: [U2] Universe ODBC driver performance issues {Unclassified}

Does anyone have experience changing the MAXFETCHCOLS and MAXFETCHBUFF. Are they change on both the client and the server? Thanks Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: Friday, August 11, 2006 4:44 AM To: u2-users

Re: [U2] UniData telnet

Hi Bill, I've seen similar problems with DataStage, caused by firewalls timing out sessions for you. If you can't change the firewall, not sure what the solution would be. Regards - Chris Thornton _ Chris Thornton DataStage

RE: [U2] spam using u2

I just won $100, apparently. Regards - Chris Thornton _ Chris Thornton DataStage development engineer [EMAIL PROTECTED] IBM United Kingdom Limited Power House Harrison Close Knowlhill Milton Keynes Buckinghamshire MK5 8RR U.K

[U2] [AD] Entrinsik is hiring [/AD]

programming experience a plus; Working knowledge of Multi-value database concepts; applicable work experience. Interested individuals should send resume and cover letter to [EMAIL PROTECTED] Chris Reeves Entrinsik, Inc. 919-848-4828 x114 [EMAIL PROTECTED] http://www.entrinsik.com --- u2-users

[U2] JMS and Unidata

Has anyone had any experience integrating from Unibasic to JMS? We were thinking of using the XML tools to map the database then use a Database Trigger to send a XML message to a JMS server... -- View this message in context: http://www.nabble.com/JMS-and-Unidata-tf4059332.html#a11532415 Sent

RE: [U2] secure ftp

Hi Theo, On-line information on AIX ssh / sftp bundling is here: http://www-128.ibm.com/developerworks/eserver/articles/openssh_aix.html Regards - Chris _ Chris Thornton DataStage development engineer aivazian [EMAIL PROTECTED

Re: [U2] Determining double-byte status of a character

Hi Craig, Assuming UniVerse NLS on, and that you mean double-byte in the external characterset, I would use BYTELEN( OCONV( mychar, NLS:mapname) ) Regards - Chris Thornton _ Chris Thornton DataStage development engineer Craig

RE: [U2] port.status

Unsubscribe * [EMAIL PROTECTED] Thank you, Chris Louis Asset Management Outsourcing, Inc. 5655 Peachtree Parkway, Suite 213 Norcross, GA 30092 800-893-3501 x 1106 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday

RE: [U2] [UD] Unexpected telnet/SSH error

Hi Tony, Would this be a UniData PE problem, or would it be a problem with some other (unrelated) software listening on port 22 ? Regards - Chris Thornton Tony G 1tlx6h...@sneakemail.com Sent by: owner-u2-us...@listserver.u2ug.org 06/03/2009 06:43 Please respond to u2-users

[U2] UV ODBC Driver

from the ODBC client:- [IBM][UVODBC][0301931]Error ID:46 Severity: ERROR Facility: DBCAPERR - UCI Error. Func: SQLConnect(); State: IM997; uniVerse code: 0; Msg: [IBM][SQL Client] An illegal configuration option was found. Thanks, Chris ___ U2-Users

Re: [U2] UV ODBC Driver

version. Cheers, Chris On Tue, Aug 11, 2009 at 9:21 AM, Brutzman, Bill bi...@hkmetalcraft.comwrote: The UCI Editor on the PC is a necessary first step. In Windows it can be found in the \ IBM U2 \ UniVerse ODBC Driver \ --Bill -Original Message- From: u2-users-boun

[U2] 2 servers - how do I point to a VOC on another server?

Hello, We're running UniVerse 10.1.8 on our main server and we just bought another server with UniVerse 10.3.3. I would like to setup the old server as the development server and keep the new server as the production server. The problem is we want to elevate some programs to the new server.

Re: [U2] 2 servers - how do I point to a VOC on another server?

CHRIS PROJECT 2487 ON 11:25:11 01 SEP 2009 0002 ..\CHRISSYS\LFUTILS.O/TEST_HARNESS2 0003 B 0004 BNP 0005 0006 PICK.FORMAT 0007 S²N²P²I²A²E²H 0008 NO.WARN²NOPAGE²LPTR²KEEP.COMMON²²TRAP²HDR-SUPP 0009 ..\CHRISSYS\LFUTILS.O I'm confused what 'mnt' would be in your notes? If you could clarify what our

Re: [U2] 2 servers - how do I point to a VOC on another server?

to setup NFS on them. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Tuesday, March 30, 2010 5:56 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] 2 servers - how do I point to a VOC

Re: [U2] 2 servers - how do I point to a VOC on another server?

Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Wednesday, March 31, 2010 10:51 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] 2 servers - how do I point to a VOC on another server? Our

Re: [U2] 2 servers - how do I point to a VOC on another server?

: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Wednesday, March 31, 2010 10:51 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] 2 servers - how do I point to a VOC on another server? Our configuration

Re: [U2] 2 servers - how do I point to a VOC on another server?

...that's easy to test once you get the link setup. Just try it. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Wednesday, March 31, 2010 11:38 AM To: u2-users@listserver.u2ug.org Subject

Re: [U2] 2 servers - how do I point to a VOC on another server?

...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Wednesday, March 31, 2010 12:23 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] 2 servers - how do I point to a VOC on another server? I setup a mapped drive drive on ServerA and i called it S:\ which maps to my CHRISSYS (programming

Re: [U2] Subject: 2 servers - how do I point to a VOC on another server?

solution. -Chris From: sjos...@sjplus.com To: u2-users@listserver.u2ug.org Date: Wed, 31 Mar 2010 15:28:48 -0400 Subject: [U2] Subject: 2 servers - how do I point to a VOC on another server? Hi Chris, I can't help myself - everyone knows it. Just like most know that I have a version

Re: [U2] Quick poll - how many use 3-tier or N-tier Architecture

We're also using Apache Tomcat 6 w/ a Java Servlet. The front end has Java 1.6, hibernate (writing to PICK), ajax, and html. The back end is done in UniVerse BASIC which we use for our reports and database. It's basically one medium size web application. -Chris Date: Thu, 8 Apr 2010

Re: [U2] import data to excel sheet...

CSV.FILE.NAME = 'c:\path\testCSV.csv' OPENSEQ CSV.FILE.NAME TO CSV.FILE THEN WEOFSEQ CSV.FILE CSV.REC := 'data1, data2, data3':CHAR(13) WRITESEQ CSV.REC TO CSV.FILE THEN NULL The above is a really easy way to write to a CSV file. Maybe you want to get a simple read from the txt and write to the

Re: [U2] import data to excel sheet...

in the spreadsheet. If I wanted to make a word appear as blue or in bold, how are you guys doing this? Thanks. -Chris Date: Mon, 12 Apr 2010 11:47:20 -0700 From: jacque...@yahoo.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] import data to excel sheet... Hi Jaweed, If you

Re: [U2] import data to excel sheet...

be very useful for our needs here. I appreciate the response. -Chris From: br...@brianleach.co.uk To: u2-users@listserver.u2ug.org Date: Tue, 13 Apr 2010 16:44:31 +0100 Subject: Re: [U2] import data to excel sheet... Chris I'm using OpenXML to create spreadsheets in Excel 2007 format

Re: [U2] import data to excel sheet...

there for that? I know Brian mentioned he was writing an article, I would be very inclined to read it. -Chris From: ggal...@wyanokegroup.com To: u2-users@listserver.u2ug.org Date: Tue, 13 Apr 2010 10:47:58 -0500 Subject: Re: [U2] import data to excel sheet... also see: http

Re: [U2] import data to excel sheet...

That program actually seems perfect for what I'm looking to do Bill. Do you guys use this at your work? Is it a decent product? -Chris Date: Tue, 13 Apr 2010 09:11:25 -0700 From: wphask...@advantos.net To: U2-users@listserver.u2ug.org Subject: Re: [U2] import data to excel sheet

Re: [U2] import data to excel sheet...

Brian, I really appreciate the reply. I'm going to spend some time over the weekend on this. I'll probably give Tony's product a try first and then go from there. Thanks! -Chris From: br...@brianleach.co.uk To: u2-users@listserver.u2ug.org Date: Wed, 14 Apr 2010 09:48:48 +0100 Subject

[U2] Basic Developers Toolkit - how to create a program?

within the toolkit. Does anyone know how to do this? Chris _ Hotmail has tools for the New Busy. Search, chat and e-mail from your inbox. http://www.windowslive.com/campaign/thenewbusy?ocid

[U2] problem - Attempted WRITE with record ID larger than file/table maximum

of 255 characters. -- I checked our MAXKEYSIZE in UniAdmin and it's set to 255. I guess my question is why is it saying the ID/primary key is too large if it should be - 15500*60431*EJK ? Also, what do we do to fix this? Any help is appreciated, thanks! Chris

Re: [U2] problem - Attempted WRITE with record ID larger than file/table maximum

Of Chris Austin Sent: Wednesday, June 09, 2010 8:19 AM To: u2-users@listserver.u2ug.org Subject: [U2] problem - Attempted WRITE with record ID larger than file/table maximum We encountered a problem during our nightly batch processing last night and it pertains to a specific record/key

Re: [U2] problem - Attempted WRITE with record ID larger than file/table maximum

, Chris Austin wrote: I believe that is the problem, the key for record '15500*60431*EJK' must have more than 255 characters. Is there a way to check the # of characters on a key from a telnet prompt? I'm confused why the key would be so big? There must be 'historical encoding of record locks

[U2] XLr8 + Subversion

I just downloaded the Eclipse XLr8 plug-in and we want to setup Eclipse with Subversion. I wasn't sure how to do this, I tried a couple things and it didn't seem to work. If someone could steer me down the right direction I would really appreciate it. We're using the latest version of UniVerse

[U2] easiest way to COMPILE/CATALOG for a build?

Hello, We just recently changed our entire repository from Source Safe to SVN and we're now using hudson to automate our builds. This works great for Java since we can simply compile ALL the programs using the JAVA compiler in a batch file. Universe however seems to require us sign into a

Re: [U2] easiest way to COMPILE/CATALOG for a build?

for a build? Chris, Are you on Windows or Unix/Linux? On the ?nix version, you can execute uv/bin program basic to compile your programs (and assume you can catalog, as well, but never tried it.) Assuming uv/bin is in your PATH, if the folder/directory is SOURCE, and you want to compile

Re: [U2] easiest way to COMPILE/CATALOG for a build?

So it seems like it wants to compile it but can't open the VOC. I'm not sure which VOC it's trying to use (the one c:\Chris or the one in c:\IBM\uv\bin). This is what I get from the command line C:\IBM\UV\binBASIC C:\CHRISSYS\LFUTILS TEST_HARNESS5 Unable to open 'VOC' file I have made sure

Re: [U2] easiest way to COMPILE/CATALOG for a build?

Thanks Robert, That actually worked. There is one issue however. I had to copy my VOC into my programing folder for it to work. Our setup is as follows: c:\CHRIS this is where we keep our DATA tables. (VOC is also kept here) c:\CHRISSYS this is where we keep our SOURCE code

Re: [U2] easiest way to COMPILE/CATALOG for a build?

the fact that it is elsewhere should work. Flying half from memory, so it might not work... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Wednesday, August 18, 2010 2:21 PM To: u2-users

Re: [U2] easiest way to COMPILE/CATALOG for a build?

:\CHRISudt CATALOG LFUTILS TEST_HARNESS5 Or use phantom instead of udt... Ed -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: 19 August 2010 14:37 To: u2-users@listserver.u2ug.org Subject

Re: [U2] easiest way to COMPILE/CATALOG for a build?

...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: 19 August 2010 14:56 To: u2-users@listserver.u2ug.org Subject: Re: [U2] easiest way to COMPILE/CATALOG for a build? Ed, I tried both with no luck. Here was my output: C:\CHRISUDT CATALOG LFUTILS TEST_HARNESS5 'UDT

Re: [U2] easiest way to COMPILE/CATALOG for a build?

\uv.exe Chris Austin wrote: If someone knows of a way I would be interested in hearing it. It appears that it's trying to CATALOG the file but the 'COMMAND LINE PARSING ERROR' usually indicates the syntax is incorrect I though. Date: Thu, 19 Aug 2010 14:57:44 +0100 From

[U2] possible to reverse engineer unibasic object?

I was wondering if there was an easy way to reverse engineer unibasic object and turn it into source code? We have some old (but necessary) programs that we can't seem to find the source anywhere for. However we do have the object code. Any help is appreciated. Chris

Re: [U2] possible to reverse engineer unibasic object?

Sweet!! Thanks a ton Carl. -Chris From: c...@pulsarsystems.com To: u2-users@listserver.u2ug.org Date: Tue, 31 Aug 2010 11:41:56 -0400 Subject: Re: [U2] possible to reverse engineer unibasic object? Take a look at: http://www.srs4uv.com

[U2] UVRESTORE error

workaround that people have found? Thanks, Chris ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] where did everyone go ?

I'm still here :) I noticed the same thing though. Wonder if some people dropped off the mailing list.. -Chris Date: Fri, 1 Oct 2010 06:52:26 +0530 From: anantkum...@gmail.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] where did everyone go ? Same here :-) Anant On Tue

Re: [U2] where did everyone go ?

--- Maybe this has something to do with it?? -Chris Date: Fri, 1 Oct 2010 06:52:26 +0530 From: anantkum...@gmail.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] where did everyone go ? Same here :-) Anant On Tue, Sep 28, 2010 at 12:58 PM, bpar...@nemianlife.lu wrote

Re: [U2] where did everyone go ?

--- Maybe this has something to do with it?? -Chris Date: Fri, 1 Oct 2010 06:52:26 +0530 From: anantkum...@gmail.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] where did everyone go ? Same here :-) Anant On Tue, Sep 28, 2010 at 12:58 PM, bpar...@nemianlife.lu wrote

Re: [U2] UV index with duplicate nodes

I assume you have tried rebuilding the indices? That usually fixes almost all of our issues with index problems. Otherwise I would delete the index and build it back again. If you need any code that we use just ask me and I can email it to you. -Chris From: jpb-u...@hotmail.com

Re: [U2] UVRESTORE error

above which -REV flag would work? -Chris From: jpb-u...@hotmail.com To: u2-users@listserver.u2ug.org Date: Tue, 28 Sep 2010 17:35:08 -0500 Subject: Re: [U2] UVRESTORE error Look up the command in the documentation. You will notice that if you are going to restore to a lower revision you

[U2] how to round to 2 decimals?

I'm trying to figure out how to round to 2 decimal places with a floating point in UniVerse For example 2596 x 8.333 = 21,632.468 How would you round that in UniVerse to 21,632.47? Thanks! ___ U2-Users

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

Thanks so much! X = 2597 * 8.333 PRINT OCONV(X,MR2) PRINT OCONV(X,MD2) PRINT OCONV(ICONV(X,'MD2'),'MD2') PRINT OCONV(X,'MR20') yields the following: 216.41 216.41 21640.80 21640.80 so basically the 2 that worked are: OCONV(ICONV(X,'MD2'),'MD2') OCONV(X,'MR20') you guys rock! :-) -Chris

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

, just rounding Regards John Woollam | Group Function Support 1 (Finance Systems) | Travis Perkins PLC | 01604 682751 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: 13 October 2010 22

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

[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: 13 October 2010 22:22 To: u2-users@listserver.u2ug.org Subject: [U2] how to round to 2 decimals? I'm trying to figure out how to round to 2 decimal places with a floating point in UniVerse For example 2596 x

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

Thanks George, I know this will be helpful with scaling, I know the need will arise for this in the future. -Chris From: ggal...@wyanokegroup.com To: u2-users@listserver.u2ug.org Date: Thu, 14 Oct 2010 12:23:50 -0500 Subject: Re: [U2] how to round to 2 decimals? I always used int

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

with 5,000+ records lets says. That would shave off 5 1/2 minutes of processing time! -Chris Date: Thu, 14 Oct 2010 11:00:08 -0700 From: donr_w...@yahoo.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] how to round to 2 decimals? How about this? X = 2596 * 8.333 ;* [X will contain

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

oops.. I should have read your post closer. ' one million times' - so yeah that wouldn't make a huge difference but it's still good to know! -Chris Date: Thu, 14 Oct 2010 11:00:08 -0700 From: donr_w...@yahoo.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] how to round to 2

[U2] AUTO: Chris Thornton, Milton Keynes DataStage software engineer, is on leave. (returning 03/03/2011)

I am out of the office until 03/03/2011. I am on leave until Thursday 3rd March. For 8.5 / Concierge issues please contact lha...@us.ibm.com For other support issues, please contact dave.cheese...@uk.ibm.com For all other urgent issues please contact julian.vi...@uk.ibm.com Note: This is an

Re: [U2] Is this worth rewriting?

try this, your loops are using too many conditionals. What kind of data is this, string, integer, etc? MONTHLY.USAGE: -- CM = MONTH + LY.CNT TEA = PARMS(12)101,CM EAT = PARMS(12)133,CM ATE = PARMS(12)134,CM FOR M = 1 TO 12 IF TEA+EAT+ATE '' THEN CUM(M) = TEA+EAT+ATE YAM =

Re: [U2] Is this worth rewriting?

I didn't realize the CM var could be used so I re-wrote it. This program logic looks horrible though, I would definitely re-write it with consideration of indexing some fields to make it run more efficient. Chris MONTHLY.USAGE: CM = MONTH+LY.CNT FOR M = 1 TO 12 TEA = PARMS(12)101,CM EAT

[U2] AUTO: Chris Thornton, Milton Keynes DataStage software engineer, is on leave. (returning 15/03/2011)

I am out of the office until 15/03/2011. I am on leave until Tuesday 15th March. For 8.5 migration and concierge issues, please email conci...@us.ibm.com For other support issues please email dave.cheese...@uk.ibm.com For techlist (IBM internal mailing list) please contact Tony Curcio. For any

[U2] AUTO: Chris Thornton, Milton Keynes DataStage software engineer, is on leave. (returning 04/04/2011)

I am out of the office until 04/04/2011. I am on leave until Monday 4th April For 8.5 migration and concierge issues, please email conci...@us.ibm.com For DataStage core support issues please email andrew.curs...@uk.ibm.com and ewan.pa...@uk.ibm.com For techlist (IBM internal mailing list)

[U2] AUTO: Milton Keynes office closed for English public holidays (returning 26/04/2011)

I am out of the office until 26/04/2011. The Milton Keynes office is closed on Friday and Monday for Easter public holidays. For 8.5 migration and concierge queries issues requiring attention before Tuesday, please email lha...@us.ibm.com and pkl...@us.ibm.com. For urgent problems please raise

Re: [U2] AUTO: Milton Keynes office closed for English public holidays (returning 26/04/2011)

Sorry about this - I will try to work out a way to block these. Regards - Chris Thornton From: Chris Thornton1/UK/IBM@IBMGB To: U2 Users List u2-users@listserver.u2ug.org Date: 21/04/2011 16:40 Subject:[U2] AUTO: Milton Keynes office closed for English public holidays

Re: [U2] AUTO: Milton Keynes office closed for English public holidays (returning 26/04/2011)

From: George Gallen ggal...@wyanokegroup.com Do I forsee any upcoming t-shirts? Royal Wedding holiday is not till next Thursday; I've so far resisted that particular temptation. Regards - Chris Thornton Unless stated otherwise above: IBM United Kingdom Limited - Registered

[U2] in DICT - how to make this 'yes'.

corresponding field So based on what it's saying, the dictionary doesn't contain the corresponding field. Any help is appreciate, thanks. Chris ___ U2-Users mailing list U2-Users@listserver.u2ug.org http

[U2] RPC timeouts

We recently switched to a new server and I've been having some weird RPC failures. Every night we run a nightly cycle that processes our batches and transactions. During the monthly cycles (which take a little longer), we have a process at the very end that will connect to our java data pool

[U2] SELECT question, paginated select.

clients? Is there a way to do this? For example if I wanted to return the next 10 CLIENTS, without including any of the first 10. Chris ___ U2-Users mailing list U2-Users@listserver.u2ug.org http

Re: [U2] SELECT question, paginated select.

] ' Date: Wed, 20 Jul 2011 11:38:50 -0600 From: dave...@gmail.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] SELECT question, paginated select. Hi Chris: This is a problem we first tried to figure out when we went to the Web. The easiest way for us was to save off the client

Re: [U2] SELECT question, paginated select.

Bill, I was curious if you had a quick example? I'm just curious how you guys are suggesting to do this Chris Date: Wed, 20 Jul 2011 11:13:04 -0700 From: wphask...@advantos.net To: u2-users@listserver.u2ug.org Subject: Re: [U2] SELECT question, paginated select. Chris: I'm betting

Re: [U2] SELECT question, paginated select.

WITH INDEX_1 = 00CAPGE] how would you limit that to the first 10 entries? And then how would you get the next 10 after that? We're on UniVerse so I assume the UniData commands below won't work for our application. Chris Date: Wed, 20 Jul 2011 11:39:42 -0700 From: wphask...@advantos.net

Re: [U2] SELECT question, paginated select.

this, Bill says that you have to do a dance in UniVerse. I guess I'm curious what this dance is that I need to do? If it's not handled in the SELECT then what technique are you using in UniVerse? Chris Date: Wed, 20 Jul 2011 13:59:48 -0500 From: cstew...@tri-sysconsulting.com To: u2-users

Re: [U2] SELECT question, paginated select.

I have no idea what the BSCAN directive is? Is that a UniVerse command? It seems that there's not really a straightforward consensus on the solution to this problem. Chris From: lar...@wcs-corp.com To: u2-users@listserver.u2ug.org Date: Wed, 20 Jul 2011 12:42:10 -0700 Subject: Re: [U2

Re: [U2] SELECT question, paginated select.

Interesting, I wonder if anyone still has an example of this? Chris From: ggal...@wyanokegroup.com To: u2-users@listserver.u2ug.org Date: Wed, 20 Jul 2011 15:15:58 -0500 Subject: Re: [U2] SELECT question, paginated select. I thought we discussed this about a year ago, with the solution

Re: [U2] SELECT question, paginated select.

George, Is the dictionary change below used for the SQL solution you mentioned? In other words, do I have to add this to use the SQL queries to paginate it based on row? Or is this a trick to use a UniVerse SELECT? Chris From: ggal...@wyanokegroup.com To: u2-users@listserver.u2ug.org Date

Re: [U2] SELECT question, paginated select.

#'s. To paginate in order using the 2 selects are you suggesting I do something like SELECT CLIENT WITH NAME = A] and then save that to a LIST where I use it in the 2nd SELECT with PAGE = 4? Thanks for the help so far, I believe I have the PAGE I-descriptor setup properly. Chris From: ggal

Re: [U2] SELECT question, paginated select.

Thank you! We don't do a lot of double select statements in our programs, I assume you do the 1st SELECT and then do some sort of CAPTURED or PASSLIST command to pass the first selected values into the 2nd SELECT. Chris From: ggal...@wyanokegroup.com To: u2-users@listserver.u2ug.org

Re: [U2] SELECT question, paginated select.

CLIENT WITH PAGE = A Without setting up a VOC entry is there an easy way to execute 2 selects in a program (just like in telnet)? Chris From: ggal...@wyanokegroup.com To: u2-users@listserver.u2ug.org Date: Wed, 20 Jul 2011 16:50:08 -0500 Subject: Re: [U2] SELECT question, paginated select

Re: [U2] SELECT question, paginated select.

George, The first example worked beautifully, thanks for all help! :) Chris From: ggal...@wyanokegroup.com To: u2-users@listserver.u2ug.org Date: Wed, 20 Jul 2011 16:58:38 -0500 Subject: Re: [U2] SELECT question, paginated select. If your doing the selects from a Basic program

Re: [U2] SELECT question, paginated select.

OK cool, thanks. Just out of curiosity how would you do 2 selects using a PASSLIST? Chris From: ggal...@wyanokegroup.com To: u2-users@listserver.u2ug.org Date: Wed, 20 Jul 2011 17:06:50 -0500 Subject: Re: [U2] SELECT question, paginated select. SORRY, My mistake. that should have

Re: [U2] SELECT question, paginated select.

it, or is it a system level command when you stack select's that the system processes 1 first, then the 2nd with the first's results. Chris From: cjausti...@hotmail.com To: u2-users@listserver.u2ug.org Date: Wed, 20 Jul 2011 17:14:53 -0500 Subject: Re: [U2] SELECT question, paginated

[U2] CONV MCU on indexed field?

indexed the field name it doesn't seem that we can use CONV MCU, is there a work around to this? Thanks, Chris ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2

Re: [U2] CONV MCU on indexed field?

I'm not exactly following you. Would this dict item called NAME.UPCASE, would that be a new field to test this or woudl that be a specific field used to do the conversion? What would the dictionary look like. Chris From: bl...@shaklee.com To: u2-users@listserver.u2ug.org Date: Tue, 26 Jul

Re: [U2] CONV MCU on indexed field?

I changed the DICT entry for field NAME on the CLIENT table to the following: NAME 0001 D 0002 5 0003 MCU 0004 Name 0005 25L 0006 S 0007 0008 CHARACTER,25 But it still doesn't seem to work in regards to the case-sensitive. Chris From: bl...@shaklee.com To: u2-users

Re: [U2] CONV MCU on indexed field?

Basically what I tried was editing the existing DICT entry for the field NAME, by placing the value MCU in line #3. I don't think this is what John referred to though. Should I keep the field NAME like it is now (without the MCU) and create another DICT entry? Chris From: bl...@shaklee.com

Re: [U2] CONV MCU on indexed field?

: NAME 0001 D 0002 5 0003 0004 Name 0005 25L 0006 S 0007 0008 CHARACTER,25 So I would be creating another DICT entry called NAME.UPCASE, the part I don't understand is #1) what that DICT would look like #2) how that DICT entry would be used Sorry for the numerous questions. Chris

  1   2   >