Re: [U2] UniVerse On RedHat?

Hi Bill Just to add my twopence worth:- 1 RedHat is excellent but it's best to use the Enterprise version or you may run into problems (ran out of inodes on the normal version) 2 It's always best to re-compile and re-catalog anyway. Also, you will need to fnuxi the files beforehand. 3 Went from

Re: [U2] Accuterm Historical question

And let's not forget that oldie but goodie AccuPlot on the old Ultimate systems. Barry Rogen Senior Programmer/Analyst 973 560-5327 bro...@pny.com - We are continually faced with great opportunities brilliantly disguised as insoluble

[U2] Index based on an I desc of TRANS data

I just created an Index on a fairly large file based on an I Desc. The IDESC is combination of Concatenating 5 TRANS()'d fields. After the index was built, it works greatbut just curious, Will the index get updated automatically, when the source file's data changes? (remember, the index is

Re: [U2] Index based on an I desc of TRANS data

On 09/11/10 20:47, George Gallen wrote: I just created an Index on a fairly large file based on an I Desc. The IDESC is combination of Concatenating 5 TRANS()'d fields. After the index was built, it works greatbut just curious, Will the index get updated automatically, when the source

Re: [U2] Index based on an I desc of TRANS data

It will not get updated automatically. That would be magic. For that to happen the index must be based entirely on the contents of the record and/or record id. Things like that I would tend to build the index on the key to the TRANS'd data, and maybe have another index on the field in the

Re: [U2] Index based on an I desc of TRANS data

I didn't think so It's not worth the trigger route. The data isn't used on a daily basis, and when it used, it's not an issue to delete and rebuild the index. For the 3 minutes it takes to build the index, it will make life much easier when we are using that field to do manual searches. A

Re: [U2] Index based on an I desc of TRANS data

With a 3 minute build time of the index, you might be able to do a timed process, like every 6 hours, to keep it fairly current. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, November

Re: [U2] Index based on an I desc of TRANS data

There is only 1 program that updates the source file, I was going to add an execute to the end of it, to build the index when it's done. No programs access the source file during the course of a normal day, so if an exclusive lock gets created on it, it won't hold any other processes up. In this

[U2] Strange index issue (nothing to do with last question)

I copied a UV account from an NT system to a Unix UV system to do some testing. First I had to update the account because the versions were different, no problem Then I compiled the programs, and recatalog anything that needed to be cataloged. OK. Then... I tried to create an index on one of

Re: [U2] Strange index issue (nothing to do with last question)

Check out the SET.INDEX command... SET.INDEX filename TO NULL Robert Robert F. Porter, MCSE, CCNA, ZCE Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged

Re: [U2] Strange index issue (nothing to do with last question)

That worked...Is there a place where that info is stored that I can run through the account to change the rest of the files? Thanks -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Robert Porter Sent: Tuesday,

Re: [U2] Strange index issue (nothing to do with last question)

No problem, glad I could help. I'm not positive but I seem to remember hearing or reading that the path to the index is stored in the header of the file itself. George Gallen ggal...@wyanokegroup.com 11/9/2010 3:55 PM That worked...Is there a place where that info is stored that I can run

Re: [U2] Strange index issue (nothing to do with last question)

that makes sense. I was look thorugh the SET.INDEX program in UV/BP to see what it does, and that's what it looked like. Knew it couldn't be that easy to fix! George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf

[U2] Reading a Unix file from another machine.

Hi all, I am trying to read a Unix file from and old aix machine. The people who sent it will not bend in how they sent it. What I got was in binary format so I used 'od' to convert it to ascii. When I tried to cat the file before trying to READSEQ records it looked like gibberish! I

Re: [U2] Reading a Unix file from another machine.

Try using at the unix command line String filename newfilenamer This will strip out all control characters - Original Message - From: Roy Beard [mailto:r...@cfl.rr.com] Sent: Tuesday, November 09, 2010 05:05 PM To: 'U2 Users List' u2-users@listserver.u2ug.org Subject: [U2] Reading a

Re: [U2] Reading a Unix file from another machine.

was the original file in EBCDIC? otherwise why convert it to ascii? Is it a directory structure written out as a binary file? Will cpio read the file? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Roy Beard

Re: [U2] Reading a Unix file from another machine.

It apparently is a 7 bit file, hence when I use vt100 (7 bit) I can read it, But not vt220 (8 bit). It is not a directory but a pipe delimited file. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen

Re: [U2] Reading a Unix file from another machine.

NO joy! # cd /dbms # ls -l master -rwxrwxrwx 1 root system 54683259 Nov 08 18:16 master # string master newmaster ksh: string: not found. # -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Goble Sent:

Re: [U2] Reading a Unix file from another machine.

That helped but only in 7 bit mode! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Goble Sent: Tuesday, November 09, 2010 5:25 PM To: 'u2-users@listserver.u2ug.org' Subject: Re: [U2] Reading a Unix file from

Re: [U2] Reading a Unix file from another machine.

# cat master | more °³üªü·¶ üªüªü ü ü ü ü ü ü ü ü M-^M° üªü·¶ üªüªü ü ü ü ü ü ü ü ü M-^M°µüªü·¶ üªü ü ü ü ü ü ü ü M-^M°¶üªü·¶ üªüªü ü ü ü ü ü ü ü ü M-^M°·üªü·¶ üªüªü ü ü ü ü ü ü üM ° üªü·¶ üªüªü ü ü ü ü ü ü ü ü M-^M°¹üªü·¶ üªüªü ü ü ü ü ü ü ü ü M-^M°³üªüÌDz°²Íü °°± ³°üü ü ü ü ü ü

Re: [U2] Reading a Unix file from another machine.

Sorry ... The command is strings Not string. Typing from a blackberry - Original Message - From: Roy Beard [mailto:r...@cfl.rr.com] Sent: Tuesday, November 09, 2010 05:23 PM To: 'U2 Users List' u2-users@listserver.u2ug.org Subject: Re: [U2] Reading a Unix file from another machine.

Re: [U2] Reading a Unix file from another machine.

I suggest using dos2unix to convert it to Unix format. Clive On Tue, Nov 9, 2010 at 10:23 PM, Roy Beard r...@cfl.rr.com wrote: NO joy! # cd /dbms # ls -l master -rwxrwxrwx 1 root system 54683259 Nov 08 18:16 master # string master newmaster ksh: string: not found. #

Re: [U2] Reading a Unix file from another machine.

Is AIX ebcdic? I use dd to convert files from ebcdic to ascii. Are they sending you packed data? I used to have to read the records using OSBREAD and then do an OCONV to unpack them. -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] Reading a Unix file from another machine.

No the file seems to be ascii but 7 bit. After using the strings command, I can readseq and writeseq records from it to another file, but only when using a vt100 emulator. When I try too read the new file with vt220 it is gibberish. ? Roy -Original Message- From:

Re: [U2] Reading a Unix file from another machine.

Try /usr/bin/strings -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Roy Beard Sent: Tuesday, November 09, 2010 4:23 PM To: 'U2 Users List' Subject: Re: [U2] Reading a Unix file from another machine. NO joy! # cd

Re: [U2] Upgrading and Migrating from Unix to Windows

Thanks for that, I hadn't actually downloaded it at that point and I didn't see it elsewhere on their web site. My main concern is how the existing data and programs written in Unibasic actually handle the move from a Unix environment to a Windows one. I know there is at least one call to a

Re: [U2] Reading a Unix file from another machine.

You could try converting the ^M (carriage return) into a linefeed using the command: cat master | tr \r \n | new.master And cating the file might not be a true indication of your ability to open and read the file within UV/UD. The vt100 view indicates that the content is legible. The vt220

Re: [U2] Upgrading and Migrating from Unix to Windows

On 09/11/10 23:14, Richard Conway wrote: Thanks for that, I hadn't actually downloaded it at that point and I didn't see it elsewhere on their web site. My main concern is how the existing data and programs written in Unibasic actually handle the move from a Unix environment to a Windows

Re: [U2] Upgrading and Migrating from Unix to Windows

Hi Richard, We have both a Relational Data Access Server and a Direct Data Access Server that are written in fairly generic PICK/BASIC but with specific subroutines to do platform-specific stuff. We run on pretty well all MV platforms including Unidata, Universe, PI/Open and even some very

Re: [U2] Reading a Unix file from another machine.

On 09/11/10 22:21, Roy Beard wrote: It apparently is a 7 bit file, hence when I use vt100 (7 bit) I can read it, But not vt220 (8 bit). It is not a directory but a pipe delimited file. It looks to me a bit like a Prime file! Can you look at the file with a hex viewer? If you've got access to

Re: [U2] Index based on an I desc of TRANS data

George: The answer, in short, is /*no*/! You'll have to periodically rebuild the index. In our application we have a single address book. An entry could be associated with an A/R customer, an A/P vendor, a P/R employee, a property's unit, and a few other entity type records. When the user

Re: [U2] Reading a Unix file from another machine.

Hi Roy, What you need to do is to add a line feed LF char(10) to your carriage returns char(13). This can either be done at unix level by cat file | tr '\l' '\l\015' file2 (15 being the octal equivalent of 13) or programatically by CHANGE(RECORD,CHAR(13),CHAR(10):CHAR(13),-1) I don't have an AIX

Re: [U2] Reading a Unix file from another machine.

If the binary file it truly 7 bit, try dos2unix -c 7bit master newfile, then see if you can cat newfile. rex On Tue, Nov 9, 2010 at 7:28 PM, Adrian Overs u2u...@gmail.com wrote: Hi Roy, What you need to do is to add a line feed LF char(10) to your carriage returns char(13). This can either