[U2] RE: [ID] Copying from AIX box to Linux box
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 7/12/2007, Matthew E. Lauterbach wrote: I agree with Clayton. Sounds like a duplex issue. It sounds like the port on the switch is erroring (- is that even a word?) out. Matthew E. Lauterbach Programming/Systems Administration Support Specialist Academic and Information Services West Texas AM University 8066512177 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clayton Burton Sent: Thursday, July 12, 2007 3:40 PM To: Jon Wells; [EMAIL PROTECTED] Subject: Re: [ID] Copying from AIX box to Linux box That ought to be a pretty fast process. Are either of these boxes new to the network? Are the duplex/simplex and network speeds set appropiately on the boxes and on the routers/switches? --Clayton --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Unidata ODBC
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 these downloads if I already have a licensed Unidata product (yes, I have serial number, etc). All I've found on the IBM website is trials/demos. Thanks, -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Daddy - did you lose your mind? Catherine Butera --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] BCI Interface
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 about whether something is a string or a number). I don't know if that is going to work for your situation, though. HTH, David Beahm Date: Fri, 13 Jul 2007 05:43:44 -0600 From: Trey Miller [EMAIL PROTECTED] Subject: [U2] BCI Interface 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 binary column fails with an unsupported data type error. The documentation shows that there are provisions for binding SQL.B.BINARY data types when pushing data out of UniData and onto the data source. I'm wondering if there are any provisions for binding to a binary data column when attempting to bring an entire table into UniData through the BCI. I can not seem to find any. Thanks in advance! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData 7.1 vs. MS SQL 2005 performance
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 Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: Thursday, July 12, 2007 10:27 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniData 7.1 vs. MS SQL 2005 performance Hi Robert Performance Benchmarking needs to be aligned with a business measure. Most performance benchmarks are done on the basis of Simple transactions per second. However where U2 realy bolts ahead is in complex transactions per second. In the realworld we have complex transactions, not always the simple Dr,Cr of a general ledger. A transaction will often involve various business rules and accessing multiple files for checks and process tables. With most RDBMS as the complexity increases, the more likely they will have to resort to processing outside of the database which causes a performance hit. With U2, the processing remains inside the database where basic code resides. Hence before doing performance benchmarking, make sure that the benchmarking represents the business process. It is like using a ferrari to delive furniture, it may be fast but it is the wrong vehicle for the job. Regards David Jordan Is anyone aware of any performance benchmarks for UniData 7.1? How does it stack up against SQL 2005? Robert K. Kubarych Network Services Bergen Community College --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unidata ODBC
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. Can anyone confirm this, and how/where I obtain these downloads if I already have a licensed Unidata product (yes, I have serial number, etc). All I've found on the IBM website is trials/demos. Hi Jeff, The first place to start would be contact [EMAIL PROTECTED] to submit a product procurement request. This is the same method you'd go through for obtaining the Unidata 7.1.8 server media. I recently submitted an e-mail 2 days ago for the latest Unidata 7.1.8 Client Tools and received an FTP link where I could download the server, docs, and client media ZIP files. :-) Regards, Andy Pflueger Ivy Hill Corp. Louisville, KY --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Error code 2
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 [mailto:[EMAIL PROTECTED] Sent: Thursday, July 12, 2007 3:04 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Error code 2 Jerry It relates to the UniVerse user number (which is now DERIVED from the PID by a means of information reduction to cater for long PIDs). There are a maximum of 32K foreground processes and 32K PHANTOM processes. So you launch from crontab (a starting PID) and it generates a UV user number and attempts to attach to shared memory at that point (as root). The answer is (of course) sir - certainly - right on - love you root. Whether you see a problem is moot - it depends, but it's not a good idea (and root is not a good idea for other reasons as Doug mentioned). You MAY see a peripheral symptom of this: ipcs -mop|grep 0x Do you get these building up? Are they attached to the UV shared memory segment? (compare ipcs -mop output for aceb, acec and ). I'll try and force it tomorrow time permitting, but the system I have is not heavily loaded and replication is not guaranteed. Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: 12 July 2007 13:37 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Error code 2 John, You've said this before. Could you elaborate a little more on this? We run many tasks on cron as root and have never had any problems both with Solaris and Linux. Jerry -Original Message- From: John Jenkins [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 11, 2007 6:19 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Error code 2 Karl I can't see enough from your posting, but if you are running UniVerse foreground processes from crontab as root then please don't especially AIX. Change to a non-root crontab Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 11 July 2007 15:07 To: u2-users@listserver.u2ug.org Subject: [U2] Error code 2 The following cron response came to me at 2:30pm in the day. We have programs that run at various times, but this is the first time I've seen this. What are the probable causes? TIA, Karl * BEGIN CRON EMAIL 1537 record(s) selected to SELECT list #0. A fatal error has occurred in UniVerse. Unable to re-open operating system file Error code 2 * cron: The previous message is the standard output and standard error of one of the cron commands. END CRON EMAIL --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: U2 Users Digest V1 #1760
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! Glenn Sallis Systems Developer Insurance Company Limited Insurance with a different perspective Telephone: +44 (0) 115 934 8990 Fax: +44 (0) 115 941 1316 Website: www.igi.co.uk -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 13 July 2007 14:09 To: [EMAIL PROTECTED] Subject: U2 Users Digest V1 #1760 U2 Users Digest Friday, July 13 2007 Volume 01 : Number 1760 In this issue: [U2] Unidata ODBC [U2] RE: [ID] Copying from AIX box to Linux box RE: [U2] UniData 7.1 vs. MS SQL 2005 performance Re: [U2] Tracking Disk Writes - AIX, Unidata -- Date: Fri, 13 Jul 2007 08:30:05 -0400 From: Jeffrey Butera [EMAIL PROTECTED] Subject: [U2] Unidata ODBC 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 these downloads if I already have a licensed Unidata product (yes, I have serial number, etc). All I've found on the IBM website is trials/demos. Thanks, - -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Daddy - did you lose your mind? Catherine Butera -- Date: Fri, 13 Jul 2007 07:57:41 -0500 From: Jon Wells [EMAIL PROTECTED] Subject: [U2] RE: [ID] Copying from AIX box to Linux box 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 7/12/2007, Matthew E. Lauterbach wrote: I agree with Clayton. Sounds like a duplex issue. It sounds like the port on the switch is erroring (- is that even a word?) out. Matthew E. Lauterbach Programming/Systems Administration Support Specialist Academic and Information Services West Texas AM University 8066512177 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clayton Burton Sent: Thursday, July 12, 2007 3:40 PM To: Jon Wells; [EMAIL PROTECTED] Subject: Re: [ID] Copying from AIX box to Linux box That ought to be a pretty fast process. Are either of these boxes new to the network? Are the duplex/simplex and network speeds set appropiately on the boxes and on the routers/switches? --Clayton -- Date: Fri, 13 Jul 2007 09:11:13 -0400 From: Nick Cipollina [EMAIL PROTECTED] Subject: RE: [U2] UniData 7.1 vs. MS SQL 2005 performance 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 Cipollina - -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: Thursday, July 12, 2007 10:27 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniData 7.1 vs. MS SQL 2005 performance Hi Robert Performance Benchmarking needs to be aligned with a business measure. Most performance benchmarks are done on the basis of Simple transactions per second. However where U2 realy bolts ahead is in complex transactions per second. In the realworld we have complex transactions, not always the simple Dr,Cr of a general ledger. A transaction will often involve various business rules and accessing multiple files for checks and process tables. With most RDBMS as the complexity increases, the more likely they will have to resort to processing outside of the database which causes a performance hit. With U2, the processing remains inside the database where basic code resides. Hence before doing performance benchmarking, make sure that the benchmarking represents the business process. It is like using a ferrari to delive furniture, it may be fast but it is the wrong vehicle for the job. Regards David Jordan Is anyone aware of any performance benchmarks for UniData 7.1? How does it stack up against SQL 2005? Robert K. Kubarych Network Services Bergen Community College --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain
[U2] BCI Interface
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 binary column fails with an unsupported data type error. The documentation shows that there are provisions for binding SQL.B.BINARY data types when pushing data out of UniData and onto the data source. I'm wondering if there are any provisions for binding to a binary data column when attempting to bring an entire table into UniData through the BCI. I can not seem to find any. Thanks in advance! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Conversion code for week number
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 are still seeing that on some of their reports. geek giggle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] BCI Interface
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 PROTECTED] 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 about whether something is a string or a number). I don't know if that is going to work for your situation, though. HTH, David Beahm Date: Fri, 13 Jul 2007 05:43:44 -0600 From: Trey Miller Subject: [U2] BCI Interface 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 against several tables with no issue, but any table which includes a binary column fails with an unsupported data type error. The documentation shows that there are provisions for binding SQL.B.BINARY data types when pushing data out of UniData and onto the data source. I'm wondering if there are any provisions for binding to a binary data column when attempting to bring an entire table into UniData through the BCI. I can not seem to find any. Thanks in advance! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Unidata Printing Question
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. - Get the Yahoo! toolbar and be alerted to new email wherever you're surfing. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] FW: HP Disaster Recovery video on YouTube
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 storage topology before after. It starts out with a previous video showing a bullet shot through an XP12000 Storage Array that keeps running. http://youtube.com/watch?v=qMCHpUtJnEI http://youtube.com/watch?v=qMCHpUtJnEI --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: [ID] Copying from AIX box to Linux box
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 Sent: Thursday, July 12, 2007 4:11 PM To: [EMAIL PROTECTED]; u2-users@listserver.u2ug.org Subject: [ID] Copying from AIX box to Linux box Hi all, We are trying to copy Unidata accounts from our AIX box to our Linux box. We do not have a common tape drive we can use which would seem the ideal way to copy large amounts of stuff. We decided to try using scp (SSH version of cp) and managed to get some small accounts copied over and working. It is a very slow process :-( While trying to use scp on an account with larger files (not huge mind you), the process will stall and then it is disconnected. Does anyone know what would cause scp to stall like that? It does not seem to use up a lot of resources on either box. Any suggestions on what else would work in both a secure and, preferably, a faster manor? Thanks, *---* Jon Wells Database Administrator Beloit College Information Services ResourcesBeloit, Wisconsin 608-363-2290[EMAIL PROTECTED] 608-363-2100(fax) *---* Colleague 17 Benefactor 5.1 AIX 5.1.3IBM RS6000 F50UniData 6.1.11 *---* Please send ALL answers to questions to the list. List maintenance can be done at discuss.datatel.com with your www.datatel.com login, as well as via email to [EMAIL PROTECTED] Send subscription problems to [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Conversion code for week number
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 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 are still seeing that on some of their reports. geek giggle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata Printing Question
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 To: u2-users@listserver.u2ug.org Subject: [U2] Unidata Printing Question 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. - Get the Yahoo! toolbar and be alerted to new email wherever you're surfing. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Conversion code for week number
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 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 are still seeing that on some of their reports. geek giggle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: Unidata Printing Question
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 Message- From: Dave [mailto:[EMAIL PROTECTED] Sent: Friday, July 13, 2007 10:32 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata Printing Question 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. - Get the Yahoo! toolbar and be alerted to new email wherever you're surfing. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- View this message in context: http://www.nabble.com/Unidata-Printing-Question-tf4075390.html#a11586905 Sent from the U2 - Users mailing list archive at Nabble.com. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Copying from AIX box to Linux box
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 data transfers a bear. Have you looked for things like this? -Keith Johnson LCSC -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Merrall Sent: Thursday, July 12, 2007 5:28 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Copying from AIX box to Linux box On 7/13/07, Jon Wells [EMAIL PROTECTED] wrote: Hi all, We are trying to copy Unidata accounts from our AIX box to our Linux box. We do not have a common tape drive we can use which would seem the ideal way to copy large amounts of stuff. We decided to try using scp (SSH version of cp) and managed to get some small accounts copied over and working. It is a very slow process :-( While trying to use scp on an account with larger files (not huge mind you), the process will stall and then it is disconnected. Does anyone know what would cause scp to stall like that? It does not seem to use up a lot of resources on either box. Any suggestions on what else would work in both a secure and, preferably, a faster manor? John, Apart from NFS mounts, rsync is your new best friend here (assuming you have it on the aix box - a quick google shows it is available.) I would do something like rsync -vaze ssh localdir remotehost:/remotedir Where v = verbose, a=archive mode (preserve directory structure, dates, times, perms etc.), z= compress/decompress on the fly and e ssh is the transport mechanism. Test it on a small directory first as trailing slashes on the local directory has an effect on what you copy. Rsync will only copy differences so if you get 1/2 way through a directory and kill it, it will restart where it left off, or pick up any changes to files already copied in the meantine. If you kill it 1/2 way through an individual file it will restart that whole file though. When moving files around multiple machines it is one of those can't live without tools. If you need to share the machine or network, you can also use the --bwlimit flag to reduce the net copy speed so you don't impede on other users. Not sure if this will help your stall problem though - if that is an ssh problem you will see the same issue. Possibly using -v on scp to see the debug messages? HTH Adrian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: Unidata Printing Question
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: 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 To: u2-users@listserver.u2ug.org Subject: [U2] Unidata Printing Question 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. - Get the Yahoo! toolbar and be alerted to new email wherever you're surfing. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- View this message in context: http://www.nabble.com/Unidata-Printing-Question-tf4075390.html#a11586905 Sent from the U2 - Users mailing list archive at Nabble.com. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: Unidata Printing Question
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 (defined in the unix printer queue setup) is different from the printer page length - in this case, less. They should be equal. (this assumes you're running on unix) Now, if you're controlling the font size within your programs or drivers, the driver you're using for this printer should match the driver you're using for the other printers (which may not necessarily be the driver that matches the model of this printer). For example, for much of our PCL code, we always tell AIX that our printers are HP LJ3's even if they're 4200's. The AIX driver for the LJ3 works the best with our code (or vice-versa, depending on how you want to look at it). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of KidFromBrooklyn 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: 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 To: u2-users@listserver.u2ug.org Subject: [U2] Unidata Printing Question 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. - Get the Yahoo! toolbar and be alerted to new email wherever you're surfing. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- View this message in context: http://www.nabble.com/Unidata-Printing-Question-tf4075390.html#a11586905 Sent from the U2 - Users mailing list archive at Nabble.com. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material not intended for Public use. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this communication in error, please notify the sender and delete the material from any and all computers or devices. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata ODBC
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 have their own PHrase. Don't have DICTionary entries you don't want (makes both speed and VSG so much easier - Add All.). I set up a separate account for ODBC access (by group of users) with separate DICTionaries for ODBC accessible files and pointers to the live data level (only) files. Create you DICTionary entries here, not in the live dictionary file (unless you are VERY unusual and only have clean dictionaries (I've never seen it). All names should be SQL compatible (no periods or @s, etc - VSG will do this for you but again I like to have control). If you change the dictionary drop the schema first and then recreate it afterwards. Save the SQL used to create each schema from VSG - put it in paragraphs in case of need. Create all schemas using a HAT (functional user) not an individual user name. Whoever creates them owns them - and you do not want that user id deleted. Regards JayJay -Original Message- From: 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 these downloads if I already have a licensed Unidata product (yes, I have serial number, etc). All I've found on the IBM website is trials/demos. Thanks, -- Jeff Butera, Ph.D. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] syntax for joining two files in Retrieve statement using Universe
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 name with a period after -example PM.PMID, POLI.VENDOR. Thanks for the help. Krish --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] syntax for joining two files in Retrieve statement using Universe
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 not just type PM.PMID or POLI.VENDOR and the desired results magically appear. His illustrated suggestions indicate that he comes from a different database where the filedotfield style is normal and virtually required. Him learning that our applications do not need all the fields defined at the dicitonary level in order to work in Data/Basic will be one of his first surprises. From there he can learn that there's really 2 sides to the database: The unregulated updates from Basic and the later usage using retrieval languages. Therefore, the data/basic program need not know of the dictionary item called VENDOR to put data in the proper attribute assumed to be the vendor. It updates the field by field number, not by field name. While this may not cover his exact question, it should lay the foundation for learning how MV works in general and to begin to identify the differences between MV and SQL-style databases. If anyone is using a 4GL or other hamburger helper that performs the functions, then it should be made aware that these are private extensions of the MV data model and not MV by itself. My 2 cents Mark Johnson - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, July 13, 2007 8:35 PM Subject: [U2] syntax for joining two files in Retrieve statement using Universe 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 name with a period after -example PM.PMID, POLI.VENDOR. Thanks for the help. Krish --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] syntax for joining two files in Retrieve statement using Universe
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 used in i-descriptor dictionary entries. You're not in SQL-Kansas an more, Toto. :-) BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, July 13, 2007 5:35 PM To: u2-users@listserver.u2ug.org Subject: [U2] syntax for joining two files in Retrieve statement using Universe 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 name with a period after -example PM.PMID, POLI.VENDOR. Thanks for the help. Krish --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/