Re: [U2] Simple Export to Excel

2009-06-23 Thread Ross Ferris
Careful Tony, the AD police will be after you :-) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Tony G Sent: Tuesday, 23 June 2009 7:22 AM To:

Re: [U2] I Descriptor for long filename in type 1 file

2009-06-23 Thread Jeff Schasny
Why not just resize UFD to a type 19? Norman, David (Health) wrote: UV 10.2.16 HP-UX 11i UFD is a type 1 file by default. I have some files in UFD with long filenames that go down 1 level. I have created an I-type to extract delimited fields within the @ID which either spans the 2 levels, or

Re: [U2] I Descriptor for long filename in type 1 file

2009-06-23 Thread jpb-u2ug
Create a type 19 file and redirect the logs to the new file. UFD is a bad place to store these types of files anyway because it is the account directory. When yo go to clean up the file you may accidently remove part of your account. Jerry Banker -Original Message- From:

[U2] [OT] STATUS() returning 4 digit uid, need to be 5 digits

2009-06-23 Thread Buffington, Wyatt
Can some one help me with a problem we have. The STATUS() is returning a 4 digit uid of the person who has a record locked. I need this to reflect the actual 5 digit uid number. It is causing a problem by informed a user that a record is locked by user 1234 but it is actually locked by user 51234.

Re: [U2] [OT] STATUS() returning 4 digit uid, need to be 5 digits

2009-06-23 Thread Steve Romanow
What OS? I _think_ we had that issue with aix 5.3, and it was resolved with one of the July patch releases. Buffington, Wyatt wrote: Can some one help me with a problem we have. The STATUS() is returning a 4 digit uid of the person who has a record locked. I need this to reflect the actual 5

Re: [U2] [OT] STATUS() returning 4 digit uid, need to be 5 digits

2009-06-23 Thread Buffington, Wyatt
Sorry, I should know better. We are running Unidata 7.2 on a HP Unix 11.23. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Tuesday, June 23, 2009 9:23 AM To: U2 Users List Subject: Re: [U2]

[U2] XML mapping to multiple files records

2009-06-23 Thread Joshua Gallant
Hi Folks, Here's a scenario for you: Let's say there is an XML file containing album track data that we'd like to import into 2 different Universe files. A sample layout might be something like: albums album album_ID/ album_title/ album_total_runtime/

Re: [U2] XML mapping to multiple files records

2009-06-23 Thread Larry Hiscock
Why two files? That would be the approach with a SQL type database, but in Universe, you can make the track data multi-valued related fields in the albums file. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] XML mapping to multiple files records

2009-06-23 Thread Joshua Gallant
The scenario and sample I posted is theoretical. The actual data structure is much larger and has way too many nested levels. Unfortunately splitting data is a must. The two files piece is working fine it's just the multiple records in the second file that's an issue. - Josh -Original

[U2] FW: Valid Backup on Windows Universe

2009-06-23 Thread Kevin Gusler
All - We are attempting to enact IBM's double mirrored striped set backup alternative. This is where your server has a RAID array of 0+1 and then a second Raid 1 that is mirrored to the first mirror. The process as IBM describes it is: 1. Quiesce the database (pause all writes,

Re: [U2] FW: Valid Backup on Windows Universe

2009-06-23 Thread Steve Romanow
Kevin Gusler wrote: All - We are attempting to enact IBM's double mirrored striped set backup alternative. This is where your server has a RAID array of 0+1 and then a second Raid 1 that is mirrored to the first mirror. The process as IBM describes it is: 1. Quiesce the

Re: [U2] I Descriptor for long filename in type 1 file

2009-06-23 Thread Ron Hutchings
The suggestion about including the OCONV in the i-descriptor should do it for you. It has to do with how the system looks at the data in input or output format. The D2 conversion is not part of the ouput but moving the OCONV up should change the data to match the with clause. From:

Re: [U2] FW: Valid Backup on Windows Universe

2009-06-23 Thread Kevin Gusler
How many disks are in your array and are they all raid 0? What kind of controller (if hardware) are you using that is doing a Raid 0+1+1?? Kevin Gusler Applications Developer Mortgage Builder Software, Inc. Main:    800.850.8060 ext. 106 Fax:  248.304.0601 www.mortgagebuilder.com

Re: [U2] FW: Valid Backup on Windows Universe

2009-06-23 Thread Steve Romanow
Kevin Gusler wrote: How many disks are in your array and are they all raid 0? What kind of controller (if hardware) are you using that is doing a Raid 0+1+1?? Kevin Gusler Applications Developer Mortgage Builder Software, Inc. Main:800.850.8060 ext. 106 Fax: 248.304.0601

Re: [U2] FW: Valid Backup on Windows Universe

2009-06-23 Thread Kevin Gusler
Steve - Why do you think this? The failure I see of this system is that even though the db is paused, it is not in a safe state for backup. Once you broke the mirror would it not be safe to backup that array?? Kevin Gusler Applications Developer Mortgage Builder Software, Inc. Main:   

Re: [U2] FW: Valid Backup on Windows Universe

2009-06-23 Thread Steve Romanow
Kevin Gusler wrote: Steve - Why do you think this? The failure I see of this system is that even though the db is paused, it is not in a safe state for backup. Once you broke the mirror would it not be safe to backup that array?? Kevin Gusler Applications Developer Mortgage Builder

Re: [U2] FW: Valid Backup on Windows Universe

2009-06-23 Thread Kevin Gusler
Are you using the Quiesce database command? (pause all writes, data can still be read, no loss of data)? Kevin Gusler Applications Developer Mortgage Builder Software, Inc. Main:    800.850.8060 ext. 106 Fax:  248.304.0601 www.mortgagebuilder.com -Original Message- From:

Re: [U2] FW: Valid Backup on Windows Universe

2009-06-23 Thread Steve Romanow
Kevin Gusler wrote: Are you using the Quiesce database command? (pause all writes, data can still be read, no loss of data)? we use dbpause in unidata. ___ U2-Users mailing list U2-Users@listserver.u2ug.org

Re: [U2] FW: Valid Backup on Windows Universe

2009-06-23 Thread Charles Stevenson
Why do you think this? The failure I see of this system is that even though the db is paused, it is not in a safe state for backup. Once you broke the mirror would it not be safe to backup that array?? The db is basically in mid sentence. The commits are not atomic. If you restore to

Re: [U2] FW: Valid Backup on Windows Universe

2009-06-23 Thread Kevin Gusler
Charles - When you did this: so we used the same double mirror/pause/split/tape backup as described by others How many disks were in your array and were they all raid 0? What kind of controller were you using that was doing a Raid 0+1+1?? Sounds like you were on Universe, was it windows as

Re: [U2] FW: Valid Backup on Windows Universe

2009-06-23 Thread Steve Romanow
Charles Stevenson wrote: with one variation: We left the mirror split and stale for most of the day. That way if problems arose (e.g., broken file, file cleared inappropriately, etc.) I had fast access to the previous day's data. I occasionally took advantage of that feature. We never

Re: [U2] FW: Valid Backup on Windows Universe

2009-06-23 Thread Charles Stevenson
UV on HPUX. Disks were part of a huge SAN (vendor slips my mind at the moment) where our ap was just a small part of a mix of unix, windows, linux. I don't recall raid level. The SAN was administered by someone else. Tape backup was Legato. I really liked the idea of keeping the backups

[U2] What Program Am I?

2009-06-23 Thread David A Barrett
We've got a UV client/server application with a thick VB client. The vintage is around 1997, and the architecture has a debug mode that I leave on all the time that logs the calls back to the server and the arguments passed back and forth. The server side stuff is all phantomed off, so the

Re: [U2] What Program Am I? {Unclassified}

2009-06-23 Thread HENDERSON MIKE, MR
Dave, From (IIRC) 10.0 onwards, there's the SYSTEM(9001) pseudo-variable which contains the UV CALL Stack. It's formatted a bit funny, but there may be a routine on the Pickwiki to make it a sensible format. HTH Regards Mike -Original Message- From:

Re: [U2] What Program Am I?

2009-06-23 Thread phil walker
Depending on the version of UV you are on you should be able to access SYSTEM(9001) from memory. This is an array which contains the call stack. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of David A Barrett

Re: [U2] I Descriptor for long filename in type 1 file

2009-06-23 Thread Walter
David, In the second LIST you're looking for 29.5.09 yet the I-desc is returning 29.05.09. Try LIST UFD WITH DATE2 = 29.05.09. Just a thought. Norman, David (Health) wrote: UV 10.2.16 HP-UX 11i UFD is a type 1 file by default. I have some files in UFD with long filenames that go down 1

Re: [U2] [OT] STATUS() returning 4 digit uid, need to be 5 digits

2009-06-23 Thread Charles Stevenson
Here's a lead, not an answer. When we upgraded from 11.11 on HP Risc to 11.23 on HP Itanium, some of the permissions on files in /etc changed from rw-r--r-- to rw---. Owner remained root. That made a couple UV (not UD) utilities that relied on that unix info to yield up user counts stop

Re: [U2] I Descriptor for long filename in type 1 file

2009-06-23 Thread Norman, David (Health)
Thanks to those who responded - changing the I-Type didn't work, but Jerry offered sound advice to not use UFD anyway. What were temporary debugging files are now in use everyday, so a specific type 19 file is appropriate. I've now moved all these entries from UFD to their own file and all's