[U2] RE: [ID] Copying from AIX box to Linux box

2007-07-13 Thread Jon Wells
You guys were on the right track. My Sys. Admin. traced her connection to the network and found she was on the wrong kind of port. After switching that around, scp works much much faster. Now I'm going to look into this rsync folks have been talking about. THANKS, Jon Wells At 04:55 PM

[U2] Unidata ODBC

2007-07-13 Thread Jeffrey Butera
We may embark down the ODBC connectivity path with Unidata (7.1.8 on solaris 9). My understanding is that I need to get the UniData clients toolkit and, in particular: UniODBC, the UniDK developer's Toolkit, and the Visual Schema Generator. Can anyone confirm this, and how/where I obtain

Re: [U2] BCI Interface

2007-07-13 Thread David Beahm
I have not found any way to force SQL type compatibility, but I have worked around it by using CAST/CONVERT in the SQL statement to make UniData see the data as a type it did recognize. In my case it was a matter of BigInt not being handled (which is ironic, since U2 doesn't usually fuss

RE: [U2] UniData 7.1 vs. MS SQL 2005 performance

2007-07-13 Thread Nick Cipollina
I agree. Trying to compare a relational database (such as SQL Server) and a post-relational database (such as UniData) is like trying to compare apples and oranges. Your best bet is to analyze how you are going to use the data, and pick the database that can handle those needs. Thanks, Nick

Re: [U2] Unidata ODBC

2007-07-13 Thread Andy Pflueger
On 7/13/07, Jeffrey Butera [EMAIL PROTECTED] wrote: We may embark down the ODBC connectivity path with Unidata (7.1.8 on solaris 9). My understanding is that I need to get the UniData clients toolkit and, in particular: UniODBC, the UniDK developer's Toolkit, and the Visual Schema Generator.

RE: [U2] Error code 2

2007-07-13 Thread Jerry Banker
The 'o' option is not available on Red Hat Linux 3. Is there a problem report that I can look at. And, yes any system administrator worth their salt is not going to use commands in the cron that will potentially cause the s..t to hit the fan. -Original Message- From: John Jenkins

[U2] RE: U2 Users Digest V1 #1760

2007-07-13 Thread Glenn Sallis
Hi Jeff If you go to the following link: http://www14.software.ibm.com/download/data/web/en_US/trialprograms/Z955 364D40826J60.html?S_TACT=104CBW71 and select UniData Clients this will download UniODBC etc. You can use these for all your needs and I don't believe they will expire. Good luck!

[U2] BCI Interface

2007-07-13 Thread Trey Miller
Hello, I'm on a system running UniData 6.0. I'm attempting to use the BCI to return an SQL table from a 2003 MsSql server. I've established a connection and can execute the SQLExecDirect with a select * from tablename against several tables with no issue, but any table which includes a

RE: [U2] [UV] Conversion code for week number

2007-07-13 Thread Susan Joslyn
This is silly and a bit off-topic - but I remember the day I found out that you could perform a date conversion in Universe to get the Chinese year! I had so much fun adding The Year of the Pig at the top of all the reports at the customer site where I was working at the time. I wonder if they

Re: [U2] BCI Interface

2007-07-13 Thread hemiiim2k
Thank you David. I suspected I might be reduced to trying a cast on the server side. I should also mention that I am using the Easysoft driver and I've posited the question to them, just to see their take. Kind regards! -- Original message -- From: David Beahm [EMAIL

[U2] Unidata Printing Question

2007-07-13 Thread Dave
We have one HP printer here that is acting weird. When I enter SORT CUSTOMERS LPTR at TCL all of the printers here format the report properly. The font is compressed. One HP printer does not print compressed and page breaks prematurely. We are also running SB + here.

[U2] FW: HP Disaster Recovery video on YouTube

2007-07-13 Thread Jerry Banker
This is an excellent video getting lots of coverage (almost 5,000 hits/day) - showing failover from one datacenter to another, using HP Linux Clusters w/ServiceGuard, HP-UX Clusters w/ServiceGuard, NonStop clusters, VMSclusters, and Windows clusters - using StorageEssentials to easily show the

[U2] RE: [ID] Copying from AIX box to Linux box

2007-07-13 Thread Wang, Cody
NFS can be a good option when I work on our new Windows box. It is just like another hard drive. Best regards, Cody Wang Datatel System Analyst Ohio Dominican University 1-614-251-4799 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jon Wells

RE: [U2] [UV] Conversion code for week number

2007-07-13 Thread Brian Leach
Actually that was one of my earliest support calls to VMARK, and AFAIK it still ain't fixed.. The Chinese year does not change on the 1st of January... Brian Year of the Horse (or just an old nag) This is silly and a bit off-topic - but I remember the day I found out that you could perform

RE: [U2] Unidata Printing Question

2007-07-13 Thread Jerry Banker
Either your printers internal setup is different or the driver/script you are using on your system is different from the others. All I can say is, you have to do some changes to one or the other. -Original Message- From: Dave [mailto:[EMAIL PROTECTED] Sent: Friday, July 13, 2007 10:32 AM

RE: [U2] [UV] Conversion code for week number

2007-07-13 Thread Bob Woodward
What was that Susan? A tee-hee-SNORRRT! Tee-hee-SNORRRT! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Friday, July 13, 2007 8:16 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Conversion code for week number This is

[U2] RE: Unidata Printing Question

2007-07-13 Thread KidFromBrooklyn
We tried different settings. Do you have any other ideas ? Jerry Banker wrote: Either your printers internal setup is different or the driver/script you are using on your system is different from the others. All I can say is, you have to do some changes to one or the other. -Original

RE: [U2] Copying from AIX box to Linux box

2007-07-13 Thread Keith Johnson
If push comes to shove network them directly and forget the security... :) (I am assuming they are both in the same room) Otherwise I would say an NFS mount and rsync is your best bet. PS I have had issue in the past with an old AIX system that kept dropping its NIC to half duplex. This made

RE: [U2] RE: Unidata Printing Question

2007-07-13 Thread Jerry Banker
What are you running? -Original Message- From: KidFromBrooklyn [mailto:[EMAIL PROTECTED] Sent: Friday, July 13, 2007 3:23 PM To: u2-users@listserver.u2ug.org Subject: [U2] RE: Unidata Printing Question We tried different settings. Do you have any other ideas ? Jerry Banker wrote:

RE: [U2] RE: Unidata Printing Question

2007-07-13 Thread bpaige
You may or may not have things set up the same, but when this happens on our system, the solutions are: 1. font size - the PCL font size (or pitch or whatever it's called on that specific model of printer) needs to be set to match all the other printers 2. page breaks - the unix page length

RE: [U2] Unidata ODBC

2007-07-13 Thread John Jenkins
Jeff Please make sure your DICTionaries are accurate and reflect the date. All Single values should be described as S, all Multi-Values should be described as MVs and all sub-values should be described as MS All associated MV and MS should be in Phrases - ideally all unassociated MVs should

[U2] syntax for joining two files in Retrieve statement using Universe

2007-07-13 Thread k_hw
I would like to populate a Retrieve statement in Universe joining two files linking common fields in those two files. What would be the syntax to use to accomplish my need? If I want to list in that Retrieve statement, dictionary and non-dictionary items, is it just enough to Prefix the file

Re: [U2] syntax for joining two files in Retrieve statement using Universe

2007-07-13 Thread MAJ Programming
My suggestion would for Krish to get a very good understanding of what normal outputs are available in Retrieve and to understand the way our post-dictionary items work. AFAIK, all queries function on a primary data file and everything is relative to that file. Therefore, the answer is NO, you can

RE: [U2] syntax for joining two files in Retrieve statement using Universe

2007-07-13 Thread Bob Woodward
If I understand what you're asking for, I'm not aware of a way to use two dictionaries in one Retrieve statement. You would, instead, create dictionary entries in your primary file that accomplish the linking to other files for an attribute by attribute connection. Look up xlate or trans to be