Re: [U2] Saying Goodbye...

2011-04-28 Thread Israel, John R.
I am NOT ignoring this. We have all heard (or experienced) the horror stories of companies that went away from a reliable PICK db to something that the new CFO (or whoever) wanted, the implementation was a disaster, went grossly over budget, and in the end, they ended up with a result that was

[U2] UniData Upgrade

2011-04-28 Thread Israel, John R.
The other day, we experienced a lot of users getting locked up. We did the normal steps of trying to cleanly log off the users that were stuck, releasing locks, etc. However in the end, we wound up having to reboot and the problems have not returned. While not the solution I like, we got to

Re: [U2] Say Galaxay--multiverse

2011-04-28 Thread Israel, John R.
Back in my old Prime days, I actually used WordMARC as my basic programming editor. You could not start a new program with it because it would through in some unwanted stuff, but if you just build a new program with a single line of code, WordMARC worked like a charm after that. Man! It has

Re: [U2] UniData Upgrade

2011-04-28 Thread Israel, John R.
Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Thursday, April 28, 2011 9:20 AM To: 'U2 Users List' Subject: [U2] UniData Upgrade The other day, we experienced a lot of users getting locked up. We did

Re: [U2] UniData Upgrade

2011-04-28 Thread Israel, John R.
-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Thursday, April 28, 2011 9:45 AM To: 'U2 Users List' Subject: Re: [U2] UniData Upgrade Wally, Yeah, I saw your comments in the E-mail stream that came back to us. Thanks for the info about the locking issue in early 7.2.x. I did

Re: [U2] Saying Goodbye...

2011-04-27 Thread Israel, John R.
However, a mature interface can not reasonably be achieved if it is a canned package with vendor support that is still old style. Even the GUI interface with SB leaves things to be desired. We are locked into whatever our vendor supports - writing our oun interface for a large ERP system will

Re: [U2] Saying Goodbye...

2011-04-27 Thread Israel, John R.
This would be a vendor decision to keep their clients (management). Otherwise, as we have all seen, management may make a call to go to something with a more familiar interface. Thus, the vendor looses a client. I was not suggesting WE rewrite this. Has anyone ever used the conversion tool

Re: [U2] Say Galaxay

2011-04-27 Thread Israel, John R.
UniDataVerse? -- Sent using BlackBerry - Original Message - From: u2-users-boun...@listserver.u2ug.org u2-users-boun...@listserver.u2ug.org To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed Apr 27 16:44:37 2011 Subject: Re: [U2] Say Galaxay One universe

Re: [U2] Very Weird Trigger Behavior

2011-04-21 Thread Israel, John R.
Just a thought would be to change your select to use the non-default active select list. For example, instead of: CMD='SELECT TRADES WITH TRADE_CODE = ':CODE_DEF_ID:'' try CMD='SELECT TRADES WITH TRADE_CODE = ':CODE_DEF_ID:' TO 2' If you are running in PICK flavor, change the SELECT to select

Re: [U2] Very Weird Trigger Behavior

2011-04-21 Thread Israel, John R.
of DONE, you probably would hate to index that 'status' field since it would be a VERY large index for the DONE set of keys... DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Thursday, April 21

Re: [U2] Very Weird Trigger Behavior

2011-04-21 Thread Israel, John R.
The one risk I see here is if you are at TCL and have a bunch of keys in an active select that you are going to delete. If THAT select list is not loaded into one of the higher active select buffers (i.e. 1-9), you will have some nightmares when the SELECT in the trigger clobbers the SELECT

Re: [U2] Question about uvbackup dd and uvrestore

2011-04-15 Thread Israel, John R.
I am not familiar with the specific backup product, but I used to work for Ashwood years ago. They are VERY good people and leaving them was one of the hardest decisions I ever had to make. If you call, tell Doug I said hi. John Israel Senior Programmer/Analyst Dayton Superior Corporation

Re: [U2] Game changer for U2 editors ([AD] added for Doug)

2011-04-05 Thread Israel, John R.
Or to make things worse, JavaScript does NOT give an error. It just doesn't work and you are left scratching your head wondering why. John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH  45342 -Original Message- From:

Re: [U2] Redback Limit

2011-03-31 Thread Israel, John R.
Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Wednesday, March 30, 2011 10:33 AM To: 'U2 Users List' Subject: Re: [U2] Redback Limit It was not timing out. I have other pages that take longer. It really

Re: [U2] Redback Limit

2011-03-31 Thread Israel, John R.
- From: Israel, John R. [johnisr...@daytonsuperior.com] Date: 03/30/2011 11:33 AM To: 'U2 Users List' Subject: Re: [U2] Redback Limit It was not timing out. I have other pages that take longer. It really seemed to be a size limit. I develop with FF with a Web Developer plug-in that helps a lot

Re: [U2] Redback Limit

2011-03-31 Thread Israel, John R.
that there was any limit, but after I demo-ed to them, they were believers! HTH, Laura -Original Message- From: Israel, John R. [johnisr...@daytonsuperior.com] Date: 03/31/2011 01:08 PM To: 'U2 Users List' Subject: Re: [U2] Redback Limit Thanks Laura, You are the first to confirm a size limit

Re: [U2] Redback Limit

2011-03-30 Thread Israel, John R.
...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Wednesday, March 30, 2011 8:33 AM To: 'U2 Users List' Subject: Re: [U2] Redback Limit I was exporting all the user info we track with Avanté's ePortal from ePortal back to a web page which rips the data apart and automatically opens it in Excel. Over

Re: [U2] Redback Limit

2011-03-30 Thread Israel, John R.
-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Wednesday, March 30, 2011 10:33 AM To: 'U2 Users List' Subject: Re: [U2] Redback Limit It was not timing out. I have other pages that take longer. It really seemed to be a size limit. I develop with FF with a Web Developer plug

[U2] Redback Limit

2011-03-28 Thread Israel, John R.
Is there a limit to how much data can be passed from UniData through Redback? I am getting a: Server Error: 500 - Internal server error. If I reduce the # of records processed, select the data in different order, skip the apparent offending record, it continues to blow up. I have not

Re: [U2] Catalog copy error

2011-02-22 Thread Israel, John R.
We are also using Avanté, but we do not have a program called SYSS4915.2. Nor do we have SYSS4915.1. I don't believe that TRUE UniData triggers are part of Avanté. We use them, but they have all been written in house. Epicor uses things that they CALL triggers, but they are not true

Re: [U2] Catalog copy error

2011-02-22 Thread Israel, John R.
ERROR still comes up when I try to catalog any programs. Maybe we should just start all over again and call the UDTHOME directory exactly the same as on the old system. Setting up logical file pointers in Solaris may have screwed things up. On 22/02/2011 14:07, Israel, John R. wrote: We are also

Re: [U2] Purging and Indexing

2011-02-16 Thread Israel, John R.
Building the index will take some time. Purging data from the index as you purge the actual data will also take extra time. The more indexing there is, the longer it takes to completely file or delete a record. Purge the data first, then build your index with nothing but clean data. John

Re: [U2] Input or Output screen?

2011-02-10 Thread Israel, John R.
Take the process ID and read F1 from IIPROCESS. John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH  45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Nigel Laidlow

Re: [U2] Pick Dinosaurs

2011-02-04 Thread Israel, John R.
Speaking of dinos, here is an interesting article I recently found. It has some REALLY old history: http://www.microdata-alumni.org/historical.htm John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH  45342

Re: [U2] Data in Dict

2011-01-25 Thread Israel, John R.
This problem might also disappear as hardware gets faster. John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH  45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of

[U2] Job Opening in Dayton

2011-01-19 Thread Israel, John R.
Dayton Superior Corp. is looking for a senior level programmer/analyst. We are running UniData/System Builder and using Epicor's Avanté software. Go to the following link at Monster.com for details. http://jobview.monster.com/Programmer-Analyst-Sr-Job-Miamisburg-OH-94539747.aspx Along with a

Re: [U2] Uppercasing in SELECT

2010-12-03 Thread Israel, John R.
The EVAL is nice on the fly, but having an I-Desc that does the uppercase r you means it is always there. Give these I-Descs a consistent naming convention (always starts with a U. or ends with a .U) and you are set for live. John Israel Senior Programmer/Analyst Dayton Superior Corporation

Re: [U2] where did everyone go ?

2010-09-30 Thread Israel, John R.
I have received several of those mystery E-mails as well, plus that attachment. The attachment has always had the same name but been variable in size, and I have not opened it. John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380

Re: [U2] SB Client - Disable TAB

2010-09-24 Thread Israel, John R.
. If it's important that the user not enter a field until other fields before it have been entered, bounce them out by using the process before field slot. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John

Re: [U2] EREPLACE Function

2010-08-23 Thread Israel, John R.
I have done something similar, but I was willing to have punctuation too. My intent was to just get rid of unprintable/escape characters. If you do an: XXX=OCONV(XXX, MCP) it will convert all nonprinting characters to tildas (~). You could convert all PRINTABLE but unwanted characters to

Re: [U2] Universe Triggers

2010-07-30 Thread Israel, John R.
While the trigger needs to be globally cataloged, it can call a locally cataloged routine. Every trigger we have simply calls a 2nd locally cataloged program that does all the work. Without this, it makes testing very difficult between a system that has live/test accounts on the same box.

Re: [U2] HP-Ux, Samba, and Windows 7

2010-07-22 Thread Israel, John R.
I am not the SAMBA guy at our place, but we use it all the time w/o many issues. I personally use Windows 7, 64 bit w/o any problems. However, 2008 server DOES have a problem. It does not communicate well (or at all) with HP-UX (and maybe others). This is a known bug, but there does not

Re: [U2] UniData 'QUIT'

2010-06-24 Thread Israel, John R.
If QUIT just exists the udt process, why does it run a SB program instead of just do a BYE? I would think QUIT must do something else otherwise why go to the effort of doing something already provided by UniData. John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers

Re: [U2] UniData 'QUIT'

2010-06-24 Thread Israel, John R.
Good find! It looks like a generic account uses the QUIT you showed below, but a System Builder account replaces the canned QUIT for a SB version. Is the problem in an SB account or not? That would steer us one way or the other. John Israel Senior Programmer/Analyst Dayton Superior

Re: [U2] Division Issues

2010-06-21 Thread Israel, John R.
While not the RIGHT answer, maybe a work around would be to multiply (or ICONV) both numbers by some large factor (maybe 1), do your division, then divide/OCONV the number back to the real number. I have resolved similar situations when we needed lots of precision. John Israel Senior

Re: [U2] pick item date/time modification

2010-06-21 Thread Israel, John R.
Only in a dir file where each record is its own file. John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH  45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of doug

Re: [U2] SB Dict with User Subroutine and TCL

2010-05-24 Thread Israel, John R.
Stuart, You rock!!! This works perfectly! You the man! John Israel Senior Programmer/Analyst Dayton Superior Corporation 721 Richard St. Miamisburg, OH  45342 937-866-0711 x44380 -Original Message- From: u2-users-boun...@listserver.u2ug.org

[U2] SB Dict with User Subroutine and TCL

2010-05-21 Thread Israel, John R.
I need help building a SB Dict that calls a User Subroutine with several arguments. This needs to work from both within SB screens and from TCL. Originally, I have a derived field defined as: (B(SYSS9075.1,'VIA',SHIP_VIA)) where SYSS9075.1 had three arguments, 'VIA' was hard coded and

[U2] CLEAN.SYSTEM

2010-05-05 Thread Israel, John R.
I am getting an error in RedBack. Error code = 0XF002001E Sorry, an error has occurred in RGWSCHED I am being told to run /CLEAN.SYSTEM to see if this solves the problem. 1) what does this SB command do? 2) is this likely to fix the problem with RedBack? John Israel Senior Programmer/Analyst

Re: [U2] U2 on Windows wierdness

2010-03-24 Thread Israel, John R.
I've seen things like this when using a mapped drive from Windows to UNIX. I create something in upper case yet it is in lower case on the UNIX box. If I build it on the UNIX box first (even just an empty file), the file name is in the upper/lower as I wanted. It appears to only be an issue

Re: [U2] UniData Guide Command

2009-12-17 Thread Israel, John R.
...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Thursday, December 17, 2009 6:35 AM To: U2 Users List Subject: Re: [U2] UniData Guide Command Wally, Thanks for the help on the guide stuff. My co-worker ran the guide_ndx command on all of the indexed files. He is getting an error on one of the files

Re: [U2] UniData Guide Command

2009-12-17 Thread Israel, John R.
the NO.NULLS index setting? Israel, John R. johnisr...@daytonsuperior.com 12/17/2009 10:39 AM I believe I have the solution. 1) The field in question, ALT.BILL.TO, is not being used on our system. 2) It is indexed to speed up SELECT statements that came from the vendor (ex: SELECT filename

[U2] UniData Guide Command

2009-12-16 Thread Israel, John R.
We use the UniData guide51 command to test the integrity of our files each night and whenever our system takes a hit. We are also using alternate indexing on some of our larger files. Does guide51 test alternate index files? If not, is there anything that DOES test the alternate index files? Is

Re: [U2] UniData Guide Command

2009-12-16 Thread Israel, John R.
, Suite 400 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Wednesday, December 16, 2009 6:21 AM

Re: [U2] How to Extract Selected multivalue colums

2009-11-30 Thread Israel, John R.
This looks a bit dangerous. It is converting all @AMs and @VMs to pipes. This is assuming that the number of AMs and VMs will be consistent for each REC - a very bad idea in general considering the whole concept of multi-values (and for that matter, multi-attributes). To extract just

Re: [U2] Windows 2003, UniData 7.1.20: Please Explain This Message

2009-11-10 Thread Israel, John R.
I believe that someone mentioned in a post a few days ago that this limit is 1.5. John Israel Senior Programmer/Analyst Dayton Superior Corporation 721 Richard St. Miamisburg, OH  45342 937-866-0711 x44380 -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] Microdata Conversion

2009-11-03 Thread Israel, John R.
It's been a long time since I did one of these, but UniData has a conversion tool to switch DICTs. It's pretty good, but as always, you need to verify. John Israel Senior Programmer/Analyst Dayton Superior Corporation 721 Richard St. Miamisburg, OH  45342 937-866-0711 x44380 -Original

Re: [U2] Sequentially Hashed Files

2009-10-21 Thread Israel, John R.
I agree with both setting a min modulus AND doing a CLEARFILE if the file is empty. Just remember that if an empty file has a big modulus, it can still take some time for the select to chug through all the groups. That time will be determined by the mod and the performance of your machine.

Re: [U2] Unibasic: Sample program - to extract data from Table

2009-10-14 Thread Israel, John R.
for you that your system works well, but I hope I never have to come in after you all retire! ;-) Susan Lynch - Original Message - From: Israel, John R. johnisr...@daytonsuperior.com To: U2 Users List u2-users@listserver.u2ug.org Sent: 10/14/2009 12:14 PM Subject: Re: [U2] Unibasic: Sample

Re: [U2] How to check data dictionary?

2009-10-07 Thread Israel, John R.
Dattatraya, What do you mean by the 3 hidden columns? Are they fields that exist in the DATA files but have no DICT that defines the fields? If that is the case, you should determine what program is updating these fields, what type of data it is, then build the missing Dicts. This is simply

Re: [U2] How to check data dictionary?

2009-10-07 Thread Israel, John R.
Here is an unlikely reason for the missing Dicts (I am assuming they are missing): Whoever created the fields did not want people to easily access them. For example, un-encrypted passwords. I seriously doubt this is the situation, but I thought I would just throw it out. My vote is still

Re: [U2] How to extract data from such tables

2009-10-06 Thread Israel, John R.
If I understand your question, you are simply wanting a dump of every field in a file because, potentially, you do not know all the field names. Try: LIST filename ALL However, this has several issues: 1 - you can have synonyms for the same field - how would the command know which one to

Re: [U2] Rocket Software + U2

2009-09-30 Thread Israel, John R.
Link did not work. John Israel Senior Programmer/Analyst Dayton Superior Corporation 721 Richard St. Miamisburg, OH  45342 937-866-0711 x44380 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of BraDav Sent: Tuesday,

Re: [U2] just a suggestion but ......

2009-09-18 Thread Israel, John R.
I agree. I am also a little disappointed that nobody from Rocket has chimed in to this group. I know they may not be able to say anything officially, but they ought to say SOMETHING!!! John Israel Senior Programmer/Analyst Dayton Superior Corporation 721 Richard St. Miamisburg, OH  45342

Re: [U2] Change is a coming!

2009-09-15 Thread Israel, John R.
What is your source? It is not on the http://www.rocketsoftware.com/ web site (at least not that I have found). John Israel Senior Programmer/Analyst Dayton Superior Corporation 721 Richard St. Miamisburg, OH  45342 937-866-0711 x44380 -Original Message- From:

Re: [U2] SBClient 5.3.8 on 64 bit vista

2009-08-21 Thread Israel, John R.
I am using SB 5.4 on Vista64 w/o any problems. John Israel Senior Programmer/Analyst Dayton Superior Corporation 721 Richard St. Miamisburg, OH  45342 937-866-0711 x44380 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On

[U2] Mass Disabling Triggers

2009-08-06 Thread Israel, John R.
There are 5 arguments passed with a trigger: STATUS.FLAG DICT.FLAG File Pointer Key Record The File Pointer is a handle to the OPENED file, not the NAME of the file. How would I determine the name of the file that has the trigger assigned to it? Purpose: We have MANY triggers. Due to

Re: [U2] Mass Disabling Triggers

2009-08-06 Thread Israel, John R.
Of Israel, John R. Sent: 06 August 2009 16:39 To: 'U2 Users List' Subject: [U2] Mass Disabling Triggers There are 5 arguments passed with a trigger: STATUS.FLAG DICT.FLAG File Pointer Key Record The File Pointer is a handle to the OPENED file, not the NAME of the file. How would I determine the name

Re: [U2] Your shell program

2009-08-04 Thread Israel, John R.
I put all my standard code in various INCLUDES. One of these includes standard bailout values (EX,Q,EXIT,...), the name of the program running: THIS.PROGRAM = SYSTEM(40) CONVERT / TO @FM IN THIS.PROGRAM NO.FLDS = DCOUNT(THIS.PROGRAM, @FM) THIS.PROGRAM = THIS.PROGRAMNO.FLDS[2,99] and

Re: [U2] UniData File Upgrade

2009-08-03 Thread Israel, John R.
it might be a good idea to rebuild all index's. Do you have a var doing the upgrade or an IBM rep? The docs probably address this. Israel, John R. wrote: We are migrating from UniData 6.0.4 to UniData 7.2.1. Can we do a simple UNIX cp from the old box to the new box, or have the guts

Re: [U2] ESC in Unidata

2009-07-31 Thread Israel, John R.
If you dig enough, you will find that ESC is defined somewhere as CHAR(27). It may be buried in INCLUDES. John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: u2-users-boun...@listserver.u2ug.org

[U2] UniData File Upgrade

2009-07-31 Thread Israel, John R.
We are migrating from UniData 6.0.4 to UniData 7.2.1. Can we do a simple UNIX cp from the old box to the new box, or have the guts of the UniData files changed in some minor way? Thus far, it looks like it will work, but I don't want to be a month into a LIVE deployment and find there is some

Re: [U2] Slow selects

2009-07-30 Thread Israel, John R.
The first pass on a file has to start from scratch. Once it has been read and is still fresh in memory, a 2nd pass will run much faster. John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From:

Re: [U2] UV and triggers

2009-07-20 Thread Israel, John R.
Company On 7/13/2009 10:25 AM, Israel, John R. wrote: It has been my experience that you can RETURN out any program or subroutine. If it is the top-level code, it simply stops. If it was called, it simply returns back to the calling routine. John Israel Sr. Programmer/Analyst Dayton

Re: [U2] More questions on indexing

2009-07-16 Thread Israel, John R.
In your program, do a CRT @(-1) at the top of the program to disable the paging. John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: u2-users-boun...@listserver.u2ug.org

[U2] 2 GIG Limit

2009-07-13 Thread Israel, John R.
UniData has a 2 gig limit on hashed files. What is the exact limit? Is it really 2,147,483,648 (2**32)or is 2 gig a loose term. What is the true threat level? Is it truly 2**31, or is it something else? We will need to do something soon, but how soon is what I am trying to determine.

Re: [U2] UV and triggers (ERROR -4)

2009-07-13 Thread Israel, John R.
Since it's a subroutine, shouldn't you RETURN to get out, not STOP? Also, once you get this running, be sure to CLOSE any files that it OPENs or you will have problems. Here is another tip: triggers need to be cataloged globally. However, they can call other subroutines that are cataloged

Re: [U2] UV and triggers (ERROR -4)

2009-07-13 Thread Israel, John R.
in the RETURN cleared up the error. Thanks George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, July 13, 2009 11:04 AM To: 'U2 Users List' Subject: Re: [U2] UV and triggers

Re: [U2] SQL Error / Trigger - Have to establish a lock first?

2009-07-13 Thread Israel, John R.
To be safe, yes. John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, July

Re: [U2] Simple Export to Excel

2009-07-06 Thread Israel, John R.
I agree completely. However, Excel has the nasty habit of doing things to the data. For example, leading zeros are removed from numeric data. This is a bad thing if you have valid data like 123, 0123 00123. Excel will make then all 123. Sure, I can put quotes around them, but when the

Re: [U2] Simple Export to Excel

2009-07-06 Thread Israel, John R.
the = method, =1234567890,=001234,=01234,=1234 Will cause the import to treat as literalswhich might be a downside. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, July 06, 2009 10:15 AM

Re: [U2] Mixed Case UV Basic Programming Standards.

2009-06-24 Thread Israel, John R.
I use all upper case for everything except comments. This ensures that if I am looking for code via an ESEARCH, I will have a better chance to find it. Some of my tools don't case, but some do. It will also be backward compatible. John Israel Sr. Programmer/Analyst Dayton Superior

[U2] Simple Export to Excel

2009-06-22 Thread Israel, John R.
We have lots of programs that export our data from UniData to tab-delimited text files. Some of these are opened by Excel (which has its faults), some are imported into other databases. These files will be 1) E-mailed as attachments or written to specific location on the network. If I know

Re: [U2] Simple Export to Excel

2009-06-22 Thread Israel, John R.
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: 22 June 2009 14:56 To: 'U2 Users List' Subject: [U2] Simple Export to Excel We have lots of programs that export our data from UniData to tab-delimited text files. Some of these are opened by Excel (which has

Re: [U2] Simple Export to Excel

2009-06-22 Thread Israel, John R.
: [U2] Simple Export to Excel Dunno, how about converting double quotes in the data to single quotes? Or stripping them out entirely? Ed -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: 22 June

Re: [U2] Simple Export to Excel

2009-06-22 Thread Israel, John R.
This took some tweaking of my test program, but I think with all the needed tests and data scrubbing, this is the way to go. It took some playing around with the commas and quotes (the raw data could have either or both of these conditions). It also deals with putting multiple lines in a

Re: [U2] Simple Export to Excel

2009-06-22 Thread Israel, John R.
data. Israel, John R. wrote: This took some tweaking of my test program, but I think with all the needed tests and data scrubbing, this is the way to go. It took some playing around with the commas and quotes (the raw data could have either or both of these conditions). It also deals

Re: [U2] Basic Developer Toolkit - Eclipse SDK

2009-06-18 Thread Israel, John R.
I believe the newest version of Redback (called WEB DE) uses Eclipse to develop ASP web pages. In fact, IBM is saying you can convert all your SB+ stuff over to ASP! That could be a big savings on SB licenses, but unless you have a home grown system, your vendor is not likely to support this

[U2] Upgrade Compatablility

2009-06-15 Thread Israel, John R.
Our on-again/off again upgrade has finally been approved and we are moving ahead (money on the table). After a lot of back and forth, we have chosen the hardware and software that we want. Unfortunately, our vendor has just told us that they do not support the OS we want. We are pushing hard

Re: [U2] Send output from query to text file

2009-06-12 Thread Israel, John R.
Set your page size to 99 and send results to _HOLD_ via SETPTR. You will have one header at the top. John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 From:

Re: [U2] Send output from query to text file

2009-06-12 Thread Israel, John R.
Exactly! But also set the page length to something huge (99) so that you only have 1 header. Scrape the first couple of lines (if needed) and the reset is raw text. John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380

RE: [U2] UV BASIC Flowing Charting Tools

2009-05-27 Thread Israel, John R.
, -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Wednesday, 27 May 2009 6:50 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] UV BASIC Flowing Charting Tools I wrote something like this a while

RE: [U2] UV BASIC Flowing Charting Tools

2009-05-26 Thread Israel, John R.
I wrote something like this a while ago. It has a driver program that prompts for what you want (includes, calls, etc) and what program to start on, then calls the main external subroutine. This external subroutine recursively calls itself for each call and include. The trick to this is to

RE: [U2] Auto-updating of secondary indices.

2009-05-18 Thread Israel, John R.
Just to be 100% clear - it's not just indexes on subroutines that will get out of sync. Even indexing a simple TRANS statements will cause problems. This is because the index is updated whenever the primary file (the one with the index) is updated. If the data is in the 2nd file (the TRANS or

RE: [U2]

2009-05-15 Thread Israel, John R.
Is this done from a SB+ screen? If so, you should be able to pull from one of their variables. If not, you would have to do a select on the DICT to find the one you want. The problem here is what to do it you get multiple hits or no hits? John Israel Sr. Programmer/Analyst Dayton Superior

RE: [U2] I-descriptor subroutine / SELECT question

2009-04-24 Thread Israel, John R.
By default, selecting uses the default of select list 0. In the 2nd/internal subroutine, have the SELECT use a different select # and then read from that select #. For example: STMT = SELECT WIGETS TO 4 EXECUTE STMT LOOP WHILE READNEXT KEY FROM 4 (your code) REPEAT John Israel Sr.

RE: [U2] I-descriptor subroutine / SELECT question

2009-04-24 Thread Israel, John R.
After all my advice, I do agree with Jeff that doing selects within I-desc creates a LOT of overhead and in general, is not a good idea. If you can get around this and put it all in one piece of code, you will get better results. I was assuming you had a reason for doing it the way you

RE: [U2] I-descriptor subroutine / SELECT question

2009-04-24 Thread Israel, John R.
Beloit, Wisconsin 608-363-2290 wel...@beloit.edu 608-363-2100 (fax) *---* -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Friday

RE: [U2] UV 10.1.22; Dynamic File question

2009-04-23 Thread Israel, John R.
You can set a min modulo on a dynamic file when you build it (or rebuild it). In theory, this will reduce the splitting until you hit that min modulo. This does of course assume your files hash fairly evenly, etc, etc. However, if you purge the file, it will still take up all that space based

RE: [U2] UV to SAP mig... GOOGLE funds for MV worldwide !

2009-04-22 Thread Israel, John R.
This sounds very interesting and a worthy concept. But as others have stated, there are already packages of one kind or another in place. Even if yours is better, it will be a huge hurtle to get them to convert and getting them to do duel entry (current system plus your new system) simply

[U2] Select Problem

2009-04-14 Thread Israel, John R.
I have just encountered an inconsistency between the native UniData select and the PICK flavored select. From a PICK flavored account, it I use the lower case sselect to force native UniData syntax, I get: sselect ITMMST WITH F2 LIKE ...J1A... (6,213 keys - wrong) If I immediately follow this

RE: [U2] Select Problem

2009-04-14 Thread Israel, John R.
Subject: Re: [U2] Select Problem Is it taking 1A as a mask? One Alphanumeric character? How many do you get with ...J...? Charles Shaffer Senior Analyst NTN-Bower Corporation Israel, John R. johnisr...@daytonsuperior.com Sent by: owner-u2-us...@listserver.u2ug.org 04/14/2009 11:06 AM Please

Re: [U2] SQL Injection (was Select Problem)

2009-04-14 Thread Israel, John R.
Point well taken. However, in this case it is a partial part description search from a web page, so the user could type anything. I have locked this down every way I can think of (I have to deal with it otherwise and I hate addressing the same issue more than once). There is other criteria

[U2] RE: IDE

2009-03-17 Thread Israel, John R.
Our UniData database is on a Unix box. I have mapped the key dirs to my PC. This allows me to use any PC editor I wish. I usually use SlickEdit because that is an editor that lots of other folks here use for other applications, but I have also used Primal Script (the 2nd most popular editor

[U2] Upgrades

2009-02-27 Thread Israel, John R.
We are looking to do a big upgrade on our hardware and software, and I was hoping to get any positive or negative feedback folks might have had. CURRENT HP Ux 11i v1 UniData 6.0.4 SB 5.2 RedBack 4.2.6 DataStage 7.5 PROPOSED HP Ux 11i v3 UniData 7.1.17 SB 5.2.4 U2 WEB DE 4.4

[U2] RE: DO/WHILE vs IF THEN

2009-02-27 Thread Israel, John R.
If you might also want to play with putting the WHILE... line just before the REPEAT. This would be dependent upon your actual program (might need to consider if the loop starts with a failed condition). Your mileage may vary. John Israel -Original Message- From:

RE: [U2] DO/WHILE vs IF THEN

2009-02-27 Thread Israel, John R.
I agree completely with David. I make it a habit to have one way in and one way out for my loops and subroutines. It makes it much easier to enhance/debug in the future (which is what most of us spend most of our time doing). I will not say I NEVER break this rule, but it is rare. John

RE: [U2] DO/WHILE vs IF THEN

2009-02-27 Thread Israel, John R.
In all your examples, you support my position. 1 way in, 1 way out. Though to your point, you have clean, concise clean code. John Israel -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of MAJ Programming Sent: Friday,

[U2] RE: Inter-Process Control...

2009-02-26 Thread Israel, John R.
Could you have the first PHANTOM fire off the 2nd PHANTOM when that critical point is reached? John Israel -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Tom Whitmore Sent: Thursday, February 26, 2009 7:57 AM To:

RE: [U2] [UV] HP, Cron, Como, Execute, Capturing . Not

2009-02-23 Thread Israel, John R.
We are running UniData on HP-UX and I capture Unix info regularly. Rather than using a COMO, just do it with the EXECUTE command like so: STMT = !ls -lia (or whatever you need to capture) EXECUTE STMT CAPTURING UNIX.TXT Then loop through UNIX.TXT as needed. If the results can be big, use

<    1   2   3   4   >