Re: [U2] How to copy only @ID from one file to anothers

2013-06-18 Thread Greg Coelho
George, We are using a proprietary version of Unidata and it appears that I can setup a Secondary Pointer. Once setup this works like a charm. Thanks for steering me in the right direction. Greg From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users

Re: [U2] How to copy only @ID from one file to anothers

2013-06-17 Thread Greg Coelho
Guys, I am attempting to create a store computed column data from a 'co' file. How do I set this up so the stored computed column file see a new record from the parent file? and how do I initially load the ID's? Thanks, Greg ___ U2-Users mailing

Re: [U2] How do I find the code?

2013-03-05 Thread Greg Coelho
All, I am not versed in (PQ) PROC. Can anybody tell where I have to go to find the code for A26.ISS.EMPLOYMENT? :AE VOC A26.ISS.EMPLOYMENT 3 lines long. : P 0001: PQ 0002: HRUN WBP A26.ISS.EMPLOYMENT 0003: P Bottom at line 3. As Always, THANKS! Greg

Re: [U2] How do I find the code?

2013-03-05 Thread Greg Coelho
Unfortunately that was one of the first things I tried... :AE WBP A26.ISS.EMPLOYMENT Top of New A26.ISS.EMPLOYMENT in WBP. *--: P Top. Top of new record. It looks like A26.ISS.EMPLOYMENT doesn't live in WBP. Greg From: Wjhonson wjhon...@aol.com To: u2-users@listserver.u2ug.org

Re: [U2] How do I find the code?

2013-03-05 Thread Greg Coelho
Kate, Thanks! We do have WBP.OBS and it is populated with some 20 items - none of which is A26.ISS.EMPLOYMENT. Any other place this could be stashed? Greg From: Kate Stanton k...@walstan.com To: U2 Users List u2-users@listserver.u2ug.org, Date: 03/05/2013 08:52 PM Subject

Re: [U2] How do I find the code?

2013-03-05 Thread Greg Coelho
Then Greg I suggest someone has stripped the source, and left you with only the object. You can do ED WBP.O A26.ISS.EMPLOYMENT to verify that it exists, but DO NOT LIST IT it will screw up your terminal emulator software most likely if you display the object code ED only gives you Top, then you

Re: [U2] How do I find the code?

2013-03-05 Thread Greg Coelho
: 03/05/2013 09:33 PM Subject:Re: [U2] How do I find the code? Sent by:u2-users-boun...@listserver.u2ug.org It might be a non-runnable command. Have you tried to actually RUN this to see if it complains that the code is missing? -Original Message- From: Greg

Re: [U2] Searching for 'Bad' Dates

2013-01-29 Thread Greg Coelho
everything. Is there a way I can 'turn off' formatting for this field within the query? Thanks, Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Searching for 'Bad' Dates

2013-01-29 Thread Greg Coelho
Bill, This is only returning those records that do not have a value in MPAR.STATUS.DATE. Unfortunately I looking for records where an external date has been written instead of the internal date. Greg From: Bill Haskett wphask...@advantos.net To: U2 Users List u2-users

Re: [U2] Searching for 'Bad' Dates

2013-01-29 Thread Greg Coelho
better at flushing these out. Thanks, Greg From: Bill Haskett wphask...@advantos.net To: U2 Users List u2-users@listserver.u2ug.org Date: 01/29/2013 06:17 PM Subject:Re: [U2] Searching for 'Bad' Dates Sent by:u2-users-boun...@listserver.u2ug.org Greg

Re: [U2] ASCII ^010^013 Removal (LF CR)

2012-04-26 Thread Greg Coelho
Thanks all! I was trying to remove both CR and LF with a CONVERT and it did not appear to be working... but when remove one item (CR or LF) at a time it does indeed work. Tony and Will - Thanks! Greg From: Tony Gravagno 3xk547...@sneakemail.com To: u2-users@listserver.u2ug.org Date

Re: [U2] ASCII ^010^013 Removal (LF CR)

2012-04-26 Thread Greg Coelho
Bob, Good idea! Currently I'm wrestling with just 2 control characters (010 and 013), but as you point out there are others that can cause trouble as well. I should create an array of Trouble Makers and just loop through them! Thanks again, Greg From: Bob Witney b...@explore.co.uk

Re: [U2] ASCII ^010^013 Removal (LF CR)

2012-04-26 Thread Greg Coelho
Thanks Scott for the insight... From: Scott Howder howd...@cedarville.edu To: U2 Users List u2-users@listserver.u2ug.org Date: 04/26/2012 10:16 AM Subject:Re: [U2] ASCII ^010^013 Removal (LF CR) Sent by:u2-users-boun...@listserver.u2ug.org Sorry...I was a bit hasty in

Re: [U2] ASCII ^010^013 Removal (LF CR)

2012-04-25 Thread Greg Coelho
Hey Guys, Any suggestions how I can use CONVERT to strip ASCII control characters DEC 010 and 013 (LFCR) from a variable? CONVERT '?' TO '' IN X.ID Thanks! Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org

Re: [U2] Unwanted Duplicated

2012-04-06 Thread Greg Coelho
multiple SELECT lists you have to put $OPTIONS -x (I think) at the top on the program. Shot in the dark. On 4/5/12, Greg Coelho coe...@american.edu wrote: Hey Guys, I am selecting SAVING UNIQUE on a multivalue field. I then MERGE.LIST these ID's with a larger group - which should itself only return

Re: [U2] Unwanted Duplicated

2012-04-06 Thread Greg Coelho
Thanks Jeff! From: Jeff Butera jbut...@hampshire.edu To: u2-users@listserver.u2ug.org Date: 04/06/2012 09:28 AM Subject:Re: [U2] Unwanted Duplicated Sent by:u2-users-boun...@listserver.u2ug.org On 04/06/12 09:10, Greg Coelho wrote: John, Thanks for the response

Re: [U2] Unwanted Duplicated

2012-04-05 Thread Greg Coelho
TO 3' 'SAVE.LIST WORKING.IMOD.7 FROM 3' *** WORKING.IMOD.7 is full of dups! I was thinking about trying - SELECT ADDRESS WITH ADDRESS.CHANGE.DATE GE ':X.CHG.DATE:' SAVING UNIQUE RESIDENTS NO.NULLS' Any recommendations? As Aways - Thanks! Greg

Re: [U2] Using 'MATCH'

2011-10-31 Thread Greg Coelho
Hey Guys, I am concatenating an alpha code into a string providing that the code does not already exist (in the string). If my existing string = X.STRING and my code = X.CODE should the following work? IF X.STRING MATCH X.CODE THEN END ELSE X.STRING = X.STRING:',':X.CODE END Thanks! Greg

Re: [U2] Using 'MATCH'

2011-10-31 Thread Greg Coelho
Guys, Thanks for the great suggestions. I believe that I did get MATCH confused with COUNT thinking that it could navigate a delimiter... In this situation I'm thinking that just using COUNT would be the best solution. I do appreciate the diversity of the solutions presented. Thanks! Greg

Re: [U2] Using 'MATCH'

2011-10-31 Thread Greg Coelho
George, Thanks! This is a good point. I will retain the ',' delimiter when I do my COUNT. Greg From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Date: 10/31/2011 04:45 PM Subject:Re: [U2] Using 'MATCH' Sent by:u2-users-boun

Re: [U2] Using 'MATCH'

2011-10-31 Thread Greg Coelho
George, Thanks for pointing this out. I'm running a test now... if it there are any issues I'll switch to MATCH and @VM. Greg From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Date: 10/31/2011 05:10 PM Subject:Re: [U2] Using 'MATCH

Re: [U2] Using 'MATCH'

2011-10-31 Thread Greg Coelho
Guys, I've run a test against 10,000 records and COUNT is performing flawlessly. When I get a minute I'll switch it to MATCH and see how it runs. I agree with the comment that MATCH would be clearer code and would easier to follow... Thanks again, Greg From: Wjhonson wjhon...@aol.com

Re: [U2] Using 'MATCH'

2011-10-31 Thread Greg Coelho
is simple and just using COUNT against the comma delimited value. Initially I thought that I might go upstream and use LOCATE while we were still dealing with a multi-valued field, there are subroutines in place that are considering other criteria... Thanks, Greg From: Mecki Foerthmann

Re: [U2] Modifying DICT - 101

2011-07-06 Thread Greg Coelho
.CHECK.RECON 0003: DATA/DATA_X/D_A26.CHECK.RECON Bottom at line 3. Thanks! Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Convert to Numeric

2011-07-01 Thread Greg Coelho
, from the database, straight into Excel V.B.ORIG.APPROVED.AMT does not appear numeric (LEFT justified etc.) though it is defined as numeric in the DICT. Thanks, Greg From: Kevin King precisonl...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Date: 06/30/2011 09:16 PM

Re: [U2] Convert to Numeric

2011-06-30 Thread Greg Coelho
: In CF.OBJ/_A26S.GET.GLS.INFO at line 212 Non-numeric found when numeric required. Any suggestions how I can force these values numeric? Thanks, Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Intergration of an existing file?

2011-06-21 Thread Greg Coelho
with a recognizable file? As always - Thanks! Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Intergration of an existing file?

2011-06-21 Thread Greg Coelho
appreciated. Greg From: Glorfield, Gordon gglorfi...@vertisinc.com To: 'U2 Users List' u2-users@listserver.u2ug.org Date: 06/21/2011 03:47 PM Subject:Re: [U2] Intergration of an existing file? Sent by:u2-users-boun...@listserver.u2ug.org What do you mean your system does

Re: [U2] Intergration of an existing file?

2011-06-21 Thread Greg Coelho
Bob, Yep, you are correct - this is all about Envision. As Jeff Butera mentioned - there is no simple way to do this. I've gotten a couple of suggestions - I'll give them a shot. Thanks, Greg From: Bob Woodward bob_woodw...@k2sports.com To: U2 Users List u2-users

Re: [U2] Selecting a List

2011-06-08 Thread Greg Coelho
,' ',VL.JS.LIST.VAR1):' The hope here is to replace @VM with ' ' and then place the ' at each end... but CONVERT will only switch one for one - one @VM for a single single quote (') which results in a quote mismatch. Any suggestions? Greg ___ U2-Users

Re: [U2] Selecting a List

2011-06-08 Thread Greg Coelho
Guys, As always a number of great options! I was able to throw in SWAP with the least effort and it's working great! Thanks again, Greg From: Bob Woodward bob_woodw...@k2sports.com To: U2 Users List u2-users@listserver.u2ug.org Date: 06/08/2011 12:06 PM Subject:Re: [U2

Re: [U2] Selecting a List

2011-06-08 Thread Greg Coelho
Jeff, Thanks for the info on EREPLACE! It looks like this would allow me to replace a specified number of the substrings - something I've been wrestling with on another assignment... Thanks again, Greg From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users

Re: [U2] Uniquery

2011-05-27 Thread Greg Coelho
the internal date regardless how I try to format it. Any insight would be greatly appreciated. Thanks, Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] Unsubscribe

2011-01-05 Thread Greg
___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] unibasic's sort function

2009-02-03 Thread Greg Schraiber
me what I am doing wrong? Thanks for your help! Greg Schraiber Beloit College --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

[U2] Not a UniData data file error

2008-12-11 Thread Greg Fraser
Over the past week, we have gotten the not a UniData data file error several times on a few different files (and repeatedly on one particular file). An example of the error returned when trying to do any kind of access (list, count, file.stat, etc.) is as follows: File size(24576) is

RE: [U2] UV: LOOP;EXECUTE cmd CAPTURING X; REPEAT fatal memory fault.

2008-03-18 Thread Greg Schraiber
Try increasing your paging space. At 01:21 AM 3/18/2008, Tony G wrote: I'll take a wild guess. Maybe IBM can confirm this. When you run a BASIC program the runtime allocates memory space for BASIC variables. When you use these variables for strings, integers, or dynamic arrays the BASIC

RE: [U2] Device Licensing

2007-07-31 Thread Greg L. Bonebrake
. I suspect you may be having a similar issue. Each of your connections to a terminal server needs to resolve to a unique hostname via GetHostByName(). I may have an exe you can run for testing of this. Hope this helps, I fought IBM on this one for several weeks. Greg -Original Message

[U2] unsubscribe * [EMAIL PROTECTED]

2007-06-29 Thread Greg York
--- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

[U2] unsubscribe *

2007-06-27 Thread Greg York
On 28/06/2007, at 2:08 AM, Hennessey, Mark F. wrote: snip What is the best way to get information to and from a SQLServer database using Universe Basic? /snip What do you plan on doing? Are you pushing small records to SQLServer, retrieving small records or pushing/getting large tables?

[U2] unsubscribe * [EMAIL PROTECTED]

2007-06-27 Thread Greg York
--- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

[U2] unibasic select woes

2007-05-30 Thread Greg Schraiber
this type of search? Any help is greatly appreciated! Thank you, Greg --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] unibasic select woes

2007-05-30 Thread Greg Schraiber
Thanks Karen! Is there really no other way? Seems odd that you can't use functions in the select statement. Greg At 12:42 PM 5/30/2007, Karen Bessel wrote: Create a new dictionary item with conversion code 'MCU' pointing at the same attribute#. Use that dictionary item in your select

RE: [U2] unibasic select woes

2007-05-30 Thread Greg Schraiber
Dave, Wyatt Karen, Thank you so much for the tips! Works like a charm! Thanks again, Greg At 12:45 PM 5/30/2007, Dave Davis wrote: In ECLTYPE u SELECT HRPER WITH EVAL OCONV(HRP.LAST.NAME,'MCU') LIKE SC... If you are currently in ECLTYPE p, you can put the word SELECT in lowercase

Re: [U2] AIX sysback manual?

2007-05-21 Thread Greg Schraiber
There is an IBM redbook titled: IBM Tivoli Storage Manager: Bare Machine Recovery for AIX with SYSBACK http://www.redbooks.ibm.com/redpapers/pdfs/redp3705.pdf HTH, Greg At 04:05 PM 5/18/2007, you wrote: I have a customer with an AIX v5.1 system and they're looking for some mods

Re: RE: [U2] VB.NET UniObjects Example

2007-04-11 Thread Greg Schraiber
Hi Colin, You wouldn't by chance have an URL to those examples would you? Thanks a lot! Greg If you have access to the IBM knowledge base there are a couple of example projects in there that will give you everything you need. hth Colin Alfke Calgary Canada - Los Angeles this month

RE: RE: [U2] VB.NET UniObjects Example

2007-04-11 Thread Greg Schraiber
Thanks Bill, That echoes what Colin has also said. Sad that IBM is making it so difficult for new programmers to use unidata, universe and uniobjects. Makes me want to push for an oracle database. ;) Thanks for your help. Greg At 02:41 PM 4/11/2007, you wrote: Greg: This is a very

[U2] [AD] Job Posting: Colleague/UniData DBA/Analyst

2006-06-28 Thread Greg Fraser
primary fields of study. In addition, we will also begin phasing in graduate level programs over the next few years. Greg Fraser Director of Information Technology Services College for Creative Studies 201 E Kirby Detroit, MI 48202 313-664-7660 --- u2-users mailing list u2-users

RE: [U2] Text to PDF Converter

2004-10-21 Thread Greg L. Bonebrake
Look into enscript and ghostscript. Enscript will take text and output postscript, ghostscript will take the postscript and output pdf. Have used these products to convert HOLD items to pdf on UV running on W2K. Greg From: [EMAIL PROTECTED] on behalf of Cooper

[U2] Unidata equivilent to uvlictool

2004-09-08 Thread Greg L. Bonebrake
business. Also, one of these dead sessions has a readu lock set on an item. Have tried SUPERRELEASE and unlocking the lock via Uniadmin, neither seem to work. Thanks in advance for helping a Universe guy with a few newbie Unidata issues. Greg --- u2-users mailing list [EMAIL PROTECTED

[U2] Bverify equivalent on Reality flavor UV accounts

2004-05-19 Thread Greg L. Bonebrake
Working with a few Reality flavor accounts for a conversion and running into problems with multiple copies of source in different BP files. Does anyone know of any tricks or an equivalent to Reality's BVERIFY? Thanks- Greg --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org