Re: [U2] 1
.Magic erection is possible! http://relaxationstation.biz/links.php?es=15z1 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] -1 and Null values
Actually, I think I've just remembered part of it, but not the rest. Appends an empty string: REC = A REC-1 = Doesn't append an empty string: REC = REC-1 = Sets REC2 to an empty string: REC = A REC2,-1 = Doesn't append an empty string: REC = REC1,-1 = I think my mind hasn't returned from vacation yet... Interesting that it changed in UniVerse though, Kate. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kate Stanton Sent: Monday, May 03, 2010 3:53 PM To: U2 Users List Subject: Re: [U2] -1 and Null values Hi Dan, You are not the crazy one. It changed some years ago (UniVerse anyway) - we found out the hard way. That and the user number not being the user number for phantom (ie client) users have caused a great deal of heartache for us. Scary thing is what else might change! We avoid use of NOT() when data might be alpha, in case that changes to give runtime error. Kate Stanton Walstan Systems Ltd 4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand Ph: +64 9 360 5310 Fax: +64 9 376 0750 Mobile: +64 21 400 486 Email: k...@walstan.com - Original Message - From: Dan McGrath dmc...@imb.com.au To: U2 Users List u2-users@listserver.u2ug.org Sent: Monday, May 03, 2010 5:35 PM Subject: [U2] -1 and Null values Hi all, Hopefully I'm not going crazy, but I could have sworn in UD 7.1 that doing a -1 to append an empty string would not actually appended anything. For example: REC = 'A' REC-1 = '' Would result in REC equaling 'A', not 'A':@AM In fact, I even have some in-house tools I wrote that rely on -1 trimming out empty strings. Now, it appears in UD 7.2.5 that this is no longer the case and it does equal 'A':@AM. I've been through all the release notes and cannot see any changes that would have affected this. I've also looked through all the UDT.OPTIONS and see nothing relevant... Am I going crazy or has this indeed changed? Cheers, Dan ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. 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 prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. 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 prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] -1 and Null values
I think it depends on what flavour you are in as well - a number of the older pickies I work with keep forgetting this behaviour so i assume it is newer rather than older... it is rather annoying when you are building up some associated arrays and for some reason a null pops up in the data somewhere - it throws the arrays out of synch -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: 03 May 2010 07:13 To: U2 Users List Subject: Re: [U2] -1 and Null values Actually, I think I've just remembered part of it, but not the rest. Appends an empty string: REC = A REC-1 = Doesn't append an empty string: REC = REC-1 = Sets REC2 to an empty string: REC = A REC2,-1 = Doesn't append an empty string: REC = REC1,-1 = I think my mind hasn't returned from vacation yet... Interesting that it changed in UniVerse though, Kate. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kate Stanton Sent: Monday, May 03, 2010 3:53 PM To: U2 Users List Subject: Re: [U2] -1 and Null values Hi Dan, You are not the crazy one. It changed some years ago (UniVerse anyway) - we found out the hard way. That and the user number not being the user number for phantom (ie client) users have caused a great deal of heartache for us. Scary thing is what else might change! We avoid use of NOT() when data might be alpha, in case that changes to give runtime error. Kate Stanton Walstan Systems Ltd 4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand Ph: +64 9 360 5310 Fax: +64 9 376 0750 Mobile: +64 21 400 486 Email: k...@walstan.com - Original Message - From: Dan McGrath dmc...@imb.com.au To: U2 Users List u2-users@listserver.u2ug.org Sent: Monday, May 03, 2010 5:35 PM Subject: [U2] -1 and Null values Hi all, Hopefully I'm not going crazy, but I could have sworn in UD 7.1 that doing a -1 to append an empty string would not actually appended anything. For example: REC = 'A' REC-1 = '' Would result in REC equaling 'A', not 'A':@AM In fact, I even have some in-house tools I wrote that rely on -1 trimming out empty strings. Now, it appears in UD 7.2.5 that this is no longer the case and it does equal 'A':@AM. I've been through all the release notes and cannot see any changes that would have affected this. I've also looked through all the UDT.OPTIONS and see nothing relevant... Am I going crazy or has this indeed changed? Cheers, Dan ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. 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 prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. 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 prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users
Re: [U2] -1 and Null values
Well, I always thought this was an inconsistency. After all unlike SQL in Pick Null is a valid value. I've never used -1 to suppress the writing of null values into multi-valued fields because I hoped they would eventually fix that bug. And for populating attributes I wouldn't use it anyway. If I don't want to write nulls I test for it (IF VALUE # THEN...). I think otherwise it's just lazy programming. And isn't it just the opposite to what Symeon is saying? Not putting nulls in gets associated arrays out of sync and therefore you couldn't use X,-1 before to populate them. You needed to keep track of the position and use code like VARC-1 = VALUE1; POS = DCOUNT(VARC,@VM);VARX,POS = VALUE to make sure your array stays in sync if VALUE could be null. If your controlling attribute contains product codes for instance and dependent attributes contain colour codes, serial or lot numbers or bin locations you would want nulls in there if those are optional, or wouldn't you? just my 2 pennies Mecki Symeon Breen wrote: I think it depends on what flavour you are in as well - a number of the older pickies I work with keep forgetting this behaviour so i assume it is newer rather than older... it is rather annoying when you are building up some associated arrays and for some reason a null pops up in the data somewhere - it throws the arrays out of synch -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: 03 May 2010 07:13 To: U2 Users List Subject: Re: [U2] -1 and Null values Actually, I think I've just remembered part of it, but not the rest. Appends an empty string: REC = A REC-1 = Doesn't append an empty string: REC = REC-1 = Sets REC2 to an empty string: REC = A REC2,-1 = Doesn't append an empty string: REC = REC1,-1 = I think my mind hasn't returned from vacation yet... Interesting that it changed in UniVerse though, Kate. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kate Stanton Sent: Monday, May 03, 2010 3:53 PM To: U2 Users List Subject: Re: [U2] -1 and Null values Hi Dan, You are not the crazy one. It changed some years ago (UniVerse anyway) - we found out the hard way. That and the user number not being the user number for phantom (ie client) users have caused a great deal of heartache for us. Scary thing is what else might change! We avoid use of NOT() when data might be alpha, in case that changes to give runtime error. Kate Stanton Walstan Systems Ltd 4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand Ph: +64 9 360 5310 Fax: +64 9 376 0750 Mobile: +64 21 400 486 Email: k...@walstan.com - Original Message - From: Dan McGrath dmc...@imb.com.au To: U2 Users List u2-users@listserver.u2ug.org Sent: Monday, May 03, 2010 5:35 PM Subject: [U2] -1 and Null values Hi all, Hopefully I'm not going crazy, but I could have sworn in UD 7.1 that doing a -1 to append an empty string would not actually appended anything. For example: REC = 'A' REC-1 = '' Would result in REC equaling 'A', not 'A':@AM In fact, I even have some in-house tools I wrote that rely on -1 trimming out empty strings. Now, it appears in UD 7.2.5 that this is no longer the case and it does equal 'A':@AM. I've been through all the release notes and cannot see any changes that would have affected this. I've also looked through all the UDT.OPTIONS and see nothing relevant... Am I going crazy or has this indeed changed? Cheers, Dan ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. 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 prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] -1 and Null values
In UniVerse this is configurable via the $OPTIONS EXTRA.DELIM flag as well as being flavor dependent. But also in UniVerse, there is a specific null value (@NULL) as opposed to an empty string which is logically different. Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] -1 and Null values
In message ddc8e880ea0e4f438407b6fa651ca12f07eae...@es02.imb.net, Dan McGrath dmc...@imb.com.au writes Hi all, Hopefully I'm not going crazy, but I could have sworn in UD 7.1 that doing a -1 to append an empty string would not actually appended anything. For example: As I understood it, the problem was always appending TO an empty string, not appending an empty string (though I was always used to INFORMATION :-) Because an empty string could have no values, or 1 empty value, PI always assumed it had no values. So ... VAR = VAR-1 = VAR-1 = A would leave VAR equal to A But a further VAR-1 = would then append a null to give A:@FM All very logical (as I would expect from Prime :-) Cheers, Wol -- Anthony W. Youngman pi...@thewolery.demon.co.uk 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] -1 and Null values
Hi all, Hopefully I'm not going crazy, but I could have sworn in UD 7.1 that doing a -1 to append an empty string would not actually appended anything. For example: REC = 'A' REC-1 = '' Would result in REC equaling 'A', not 'A':@AM In fact, I even have some in-house tools I wrote that rely on -1 trimming out empty strings. Now, it appears in UD 7.2.5 that this is no longer the case and it does equal 'A':@AM. I've been through all the release notes and cannot see any changes that would have affected this. I've also looked through all the UDT.OPTIONS and see nothing relevant... Am I going crazy or has this indeed changed? Cheers, Dan ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. 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 prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] -1 and Null values
Hi Dan, You are not the crazy one. It changed some years ago (UniVerse anyway) - we found out the hard way. That and the user number not being the user number for phantom (ie client) users have caused a great deal of heartache for us. Scary thing is what else might change! We avoid use of NOT() when data might be alpha, in case that changes to give runtime error. Kate Stanton Walstan Systems Ltd 4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand Ph: +64 9 360 5310 Fax: +64 9 376 0750 Mobile: +64 21 400 486 Email: k...@walstan.com - Original Message - From: Dan McGrath dmc...@imb.com.au To: U2 Users List u2-users@listserver.u2ug.org Sent: Monday, May 03, 2010 5:35 PM Subject: [U2] -1 and Null values Hi all, Hopefully I'm not going crazy, but I could have sworn in UD 7.1 that doing a -1 to append an empty string would not actually appended anything. For example: REC = 'A' REC-1 = '' Would result in REC equaling 'A', not 'A':@AM In fact, I even have some in-house tools I wrote that rely on -1 trimming out empty strings. Now, it appears in UD 7.2.5 that this is no longer the case and it does equal 'A':@AM. I've been through all the release notes and cannot see any changes that would have affected this. I've also looked through all the UDT.OPTIONS and see nothing relevant... Am I going crazy or has this indeed changed? Cheers, Dan ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. 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 prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] 1 - 4 Years
OUCH! Probably not without looking at the manual though.. :-) On 6/29/07, MAJ Programming [EMAIL PROTECTED] wrote: Aside from the historical rambling, your question on LOCATE can be easily answered tenfold by the persons on this forum. Mark Johnson - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, June 29, 2007 2:38 PM Subject: RE: [U2] 1 - 4 Years I resemble that comment (Pick Aware 2003). As a side note: Early in our test/evaluation, our software vendor salesperson had said that the database system used by the application was Informix. Oh Yeah, that sounds familiar. I took some sailing classes in the San Francisco Bay with a gal that worked at Informix. So needless to say that I spent about 3 months on the IIUG.org list-serv. I even hired a Informix consultant to help get our Web application hooked up to our new application software's database via ODBC. After about 3 hours of mucking about on our system, the consultant reported back that: In an attempt to assess the Informix installation I looked around on the machine for the location of the normal Informix tools and configurations. I found none of them. I called Mr. Smith and he ran me though some of his standard commands and locations that he uses with the application. This was when I found a Universe system, which has an Informix copyright but I was unfamiliar with the product. I made several phone calls and did some investigations and got understand the basis of the product. Universe is a tool acquired when Informix obtained (I believe) DataStage from a third party. Universe is its own database system based upon the Pick Database system. Universe is a flat file pseudo relational database system but allows multi-values within fields. Universe does allow ODBC and JDBC connections but certain field types require some translation to be correctly transferred. Universe does not follow any of the standard Informix conventions and does not use the same configuration files and Charles McMurray should seek out a Universe Consultant to help with their ODBC problem. IBM did acquire all the rights to Universe with the purchase of Informix and does state that it supports Universe. So I say to myself what the heck is Universe? So what is a newbie to do? But, Google it - which leads to some guy Cliff Olivier and sites in Australia. I get in touch with Janet Oswald and some of her group. And finally I found this fledging users group u2ug.org that was just getting going and the rest is history. About one month later I got hooked up with a group out of Los Angeles [AdvancedWare] that saved the day, in getting us technical training(Unix, MV, Universe, DICT, I-desc, getting the ODBC hooked up, etc..). About a year later after numerous pleadings, demands, etc .., we got technical training on our Eclipse Enterpise Software application. Those Intuit-Eclipse software developers think they are guarding the Crown Jewels (or are southern border patrol .. I got in anyway .. Amigos). They are more of an impedment than help. It is a great system they wrote and works really well. But, since it was originally written by some hackers in a garage, I guess they do not have any documentation on the system (dig.. Dig... prove my wrong Denver Dudes). Ok so now I have about 4 years on U2 and still trying to get to know the difference in LOCATE x in MVvs LOCATE x in MV1,1 returns what? I think I have figured out how to read an product item that is on backorder from the convoluted MV design on the order entry system. Probably this is the same path followed by many U2 newbies. -- I hope not Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] On Behalf Of Charles Barouch Sent: Friday, June 29, 2007 10:03 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [AD] UniVerse Programmer needed in New Jersey Ron, Actually, I train new programmers. The problem is that most new people don;t know there's a community, so we don't meet them. There's actually a lot of new blood. We just have to find them and invite them inside. - Chuck Ron Hutchings wrote: Has anyone actually run across someone with only 1-5 years experience? --- 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/ -- john --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] 1 - 4 Years
I resemble that comment (Pick Aware 2003). As a side note: Early in our test/evaluation, our software vendor salesperson had said that the database system used by the application was Informix. Oh Yeah, that sounds familiar. I took some sailing classes in the San Francisco Bay with a gal that worked at Informix. So needless to say that I spent about 3 months on the IIUG.org list-serv. I even hired a Informix consultant to help get our Web application hooked up to our new application software's database via ODBC. After about 3 hours of mucking about on our system, the consultant reported back that: In an attempt to assess the Informix installation I looked around on the machine for the location of the normal Informix tools and configurations. I found none of them. I called Mr. Smith and he ran me though some of his standard commands and locations that he uses with the application. This was when I found a Universe system, which has an Informix copyright but I was unfamiliar with the product. I made several phone calls and did some investigations and got understand the basis of the product. Universe is a tool acquired when Informix obtained (I believe) DataStage from a third party. Universe is its own database system based upon the Pick Database system. Universe is a flat file pseudo relational database system but allows multi-values within fields. Universe does allow ODBC and JDBC connections but certain field types require some translation to be correctly transferred. Universe does not follow any of the standard Informix conventions and does not use the same configuration files and Charles McMurray should seek out a Universe Consultant to help with their ODBC problem. IBM did acquire all the rights to Universe with the purchase of Informix and does state that it supports Universe. So I say to myself what the heck is Universe? So what is a newbie to do? But, Google it - which leads to some guy Cliff Olivier and sites in Australia. I get in touch with Janet Oswald and some of her group. And finally I found this fledging users group u2ug.org that was just getting going and the rest is history. About one month later I got hooked up with a group out of Los Angeles [AdvancedWare] that saved the day, in getting us technical training(Unix, MV, Universe, DICT, I-desc, getting the ODBC hooked up, etc..). About a year later after numerous pleadings, demands, etc .., we got technical training on our Eclipse Enterpise Software application. Those Intuit-Eclipse software developers think they are guarding the Crown Jewels (or are southern border patrol .. I got in anyway .. Amigos). They are more of an impedment than help. It is a great system they wrote and works really well. But, since it was originally written by some hackers in a garage, I guess they do not have any documentation on the system (dig.. Dig... prove my wrong Denver Dudes). Ok so now I have about 4 years on U2 and still trying to get to know the difference in LOCATE x in MVvs LOCATE x in MV1,1 returns what? I think I have figured out how to read an product item that is on backorder from the convoluted MV design on the order entry system. Probably this is the same path followed by many U2 newbies. -- I hope not Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] On Behalf Of Charles Barouch Sent: Friday, June 29, 2007 10:03 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [AD] UniVerse Programmer needed in New Jersey Ron, Actually, I train new programmers. The problem is that most new people don;t know there's a community, so we don't meet them. There's actually a lot of new blood. We just have to find them and invite them inside. - Chuck Ron Hutchings wrote: Has anyone actually run across someone with only 1-5 years experience? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] 1 - 4 Years
Aside from the historical rambling, your question on LOCATE can be easily answered tenfold by the persons on this forum. Mark Johnson - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, June 29, 2007 2:38 PM Subject: RE: [U2] 1 - 4 Years I resemble that comment (Pick Aware 2003). As a side note: Early in our test/evaluation, our software vendor salesperson had said that the database system used by the application was Informix. Oh Yeah, that sounds familiar. I took some sailing classes in the San Francisco Bay with a gal that worked at Informix. So needless to say that I spent about 3 months on the IIUG.org list-serv. I even hired a Informix consultant to help get our Web application hooked up to our new application software's database via ODBC. After about 3 hours of mucking about on our system, the consultant reported back that: In an attempt to assess the Informix installation I looked around on the machine for the location of the normal Informix tools and configurations. I found none of them. I called Mr. Smith and he ran me though some of his standard commands and locations that he uses with the application. This was when I found a Universe system, which has an Informix copyright but I was unfamiliar with the product. I made several phone calls and did some investigations and got understand the basis of the product. Universe is a tool acquired when Informix obtained (I believe) DataStage from a third party. Universe is its own database system based upon the Pick Database system. Universe is a flat file pseudo relational database system but allows multi-values within fields. Universe does allow ODBC and JDBC connections but certain field types require some translation to be correctly transferred. Universe does not follow any of the standard Informix conventions and does not use the same configuration files and Charles McMurray should seek out a Universe Consultant to help with their ODBC problem. IBM did acquire all the rights to Universe with the purchase of Informix and does state that it supports Universe. So I say to myself what the heck is Universe? So what is a newbie to do? But, Google it - which leads to some guy Cliff Olivier and sites in Australia. I get in touch with Janet Oswald and some of her group. And finally I found this fledging users group u2ug.org that was just getting going and the rest is history. About one month later I got hooked up with a group out of Los Angeles [AdvancedWare] that saved the day, in getting us technical training(Unix, MV, Universe, DICT, I-desc, getting the ODBC hooked up, etc..). About a year later after numerous pleadings, demands, etc .., we got technical training on our Eclipse Enterpise Software application. Those Intuit-Eclipse software developers think they are guarding the Crown Jewels (or are southern border patrol .. I got in anyway .. Amigos). They are more of an impedment than help. It is a great system they wrote and works really well. But, since it was originally written by some hackers in a garage, I guess they do not have any documentation on the system (dig.. Dig... prove my wrong Denver Dudes). Ok so now I have about 4 years on U2 and still trying to get to know the difference in LOCATE x in MVvs LOCATE x in MV1,1 returns what? I think I have figured out how to read an product item that is on backorder from the convoluted MV design on the order entry system. Probably this is the same path followed by many U2 newbies. -- I hope not Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] On Behalf Of Charles Barouch Sent: Friday, June 29, 2007 10:03 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [AD] UniVerse Programmer needed in New Jersey Ron, Actually, I train new programmers. The problem is that most new people don;t know there's a community, so we don't meet them. There's actually a lot of new blood. We just have to find them and invite them inside. - Chuck Ron Hutchings wrote: Has anyone actually run across someone with only 1-5 years experience? --- 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/