Re: [U2] OPEN Statement DICT Default
You mean sthg like: FOR I=31 TO 365 STEP 28 PRINT (I,'DMAL')[1,3] NEXT I Tried 'DMBL' but the abbreviations were only two characters. But printing the actual string is somewhat shorter ... -- mats Mark Johnson wrote: >I specifically remember being taught >X=STR("0",5-LEN(X)):X >for the 1 concept. >Before the % was allowed, a shorter form was >X=("0":X)"R#5" >which I recall using until % came about. > >On that note, I stole "R-10" and "C#10" from UD and offered it to D3 >hopefully for their next release. > >Thanks >Mark Johnson > >P.S. Many use OCONV(DATE(),"D2/")[7,2] for the month. I think DATE()"DM" is >the shortest way. >Puzzle: Illustrate the simplest way to generate Jan thru Dec. > > >- Original Message - >From: "Roger Glenfield" <[EMAIL PROTECTED]> >To: >Sent: Monday, May 08, 2006 9:42 AM >Subject: Re: [U2] OPEN Statement DICT Default > > > > >>The same programmer that doesn't read the manual does an >> >>EXECUTE instead of a SELECTINDEX, and yes, the index already existed >> >>or >>A=STR('0',20-LEN(B)):B >>instead of >>A=FMT(B,'L%20') or for the Universe Pick/Ideal flavor people in the >>crowd A= B'L%20' >> >>or >>TODAY=OCONV(DATE(),'D2/') >>CONVERT '/' TO @VM IN TODAY >>MONTH=TODAY<1,2> >>instead of >>MONTH=OCONV(DATE(),'DM') >> >> >>And yes, I have observed all of the above recently. >> >>;) Just 15 minutes a week to look through the current manuals to find >>out about a new option that you might not know existed? >> >>Roger >> >>Louie Bergsagel wrote: >> >> >>>I've never used the null dict indicator. Who ever reads the syntax book >>>unless a command doesn't work? >>> >>>*":)* >>>-- Louie Bergsagel >>> >>> >>>On 5/5/06, Mark Johnson <[EMAIL PROTECTED]> wrote: >>> >>> >>> To All: Was there ever a real requirement on any prior flavor to have the typically non-used DICT portion of the OPEN statement be the set of quotes and a comma. I accidentally forgot it in 1978 on a Microdata and it still compiled. >To > > this day I have not seen a reason for the OPEN "","FILE" null dict indicator and have not used it since unless I actually want the DICT level. Just wondering. Thanks Mark Johnson --- 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/
RE: [U2] OPEN Statement DICT Default
All the months order (full names): CRT OCONVS(ICONVS("1}2}3}4}5}6}7}8}9}10}11}12","DM"),"DMAL") Abbreviations: CRT OCONVS(ICONVS("1}2}3}4}5}6}7}8}9}10}11}12","DM"),"DMAL[3]") -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Tuesday, 9 May 2006 10:50 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] OPEN Statement DICT Default I meant all of the months in order. Thanks. DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] OPEN Statement DICT Default
You did mean OCONV(DATE(),"D2/")[1,2] for month, at least in the Western Hemisphere and [4,2] for the Eastern, right? ;-) Roger Mark Johnson wrote: I specifically remember being taught X=STR("0",5-LEN(X)):X for the 1 concept. Before the % was allowed, a shorter form was X=("0":X)"R#5" which I recall using until % came about. On that note, I stole "R-10" and "C#10" from UD and offered it to D3 hopefully for their next release. Thanks Mark Johnson P.S. Many use OCONV(DATE(),"D2/")[7,2] for the month. I think DATE()"DM" is the shortest way. Puzzle: Illustrate the simplest way to generate Jan thru Dec. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] OPEN Statement DICT Default
I meant all of the months in order. Thanks. - Original Message - From: "Adrian Overs" <[EMAIL PROTECTED]> To: Sent: Monday, May 08, 2006 9:53 PM Subject: Re: [U2] OPEN Statement DICT Default > Solution to "puzzle" : > Month = OCONV(DATE(),"DMBL") > D = Date > MB = Abbreviated Month Name > L = Lower Case > > > On 9/5/06 9:45 AM, "Mark Johnson" <[EMAIL PROTECTED]> wrote: > > > I specifically remember being taught > > X=STR("0",5-LEN(X)):X > > for the 1 concept. > > Before the % was allowed, a shorter form was > > X=("0":X)"R#5" > > which I recall using until % came about. > > > > On that note, I stole "R-10" and "C#10" from UD and offered it to D3 > > hopefully for their next release. > > > > Thanks > > Mark Johnson > > > > P.S. Many use OCONV(DATE(),"D2/")[7,2] for the month. I think DATE()"DM" is > > the shortest way. > > Puzzle: Illustrate the simplest way to generate Jan thru Dec. > > > > > > - Original Message - > > From: "Roger Glenfield" <[EMAIL PROTECTED]> > > To: > > Sent: Monday, May 08, 2006 9:42 AM > > Subject: Re: [U2] OPEN Statement DICT Default > > > > > >> The same programmer that doesn't read the manual does an > >> > >> EXECUTE instead of a SELECTINDEX, and yes, the index already existed > >> > >> or > >> A=STR('0',20-LEN(B)):B > >> instead of > >> A=FMT(B,'L%20') or for the Universe Pick/Ideal flavor people in the > >> crowd A= B'L%20' > >> > >> or > >> TODAY=OCONV(DATE(),'D2/') > >> CONVERT '/' TO @VM IN TODAY > >> MONTH=TODAY<1,2> > >> instead of > >> MONTH=OCONV(DATE(),'DM') > >> > >> > >> And yes, I have observed all of the above recently. > >> > >> ;) Just 15 minutes a week to look through the current manuals to find > >> out about a new option that you might not know existed? > >> > >> Roger > >> > >> Louie Bergsagel wrote: > >>> I've never used the null dict indicator. Who ever reads the syntax book > >>> unless a command doesn't work? > >>> > >>> *":)* > >>> -- Louie Bergsagel > >>> > >>> > >>> On 5/5/06, Mark Johnson <[EMAIL PROTECTED]> wrote: > >>> > To All: > > Was there ever a real requirement on any prior flavor to have the > typically > non-used DICT portion of the OPEN statement be the set of quotes and a > comma. > > I accidentally forgot it in 1978 on a Microdata and it still compiled. > > To > this > day I have not seen a reason for the OPEN "","FILE" null dict indicator > and > have not used it since unless I actually want the DICT level. > > Just wondering. > > Thanks > Mark Johnson > --- > 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/ > > > > -- > Adrian Overs > Phone : +61 (0)2 9484-7160 > Mobile: +61 (0)411 358 354 > --- > 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] OPEN Statement DICT Default
PRINT "JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC" I WIN!!! BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Monday, May 08, 2006 4:46 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] OPEN Statement DICT Default I specifically remember being taught X=STR("0",5-LEN(X)):X for the 1 concept. Before the % was allowed, a shorter form was X=("0":X)"R#5" which I recall using until % came about. On that note, I stole "R-10" and "C#10" from UD and offered it to D3 hopefully for their next release. Thanks Mark Johnson P.S. Many use OCONV(DATE(),"D2/")[7,2] for the month. I think DATE()"DM" is the shortest way. Puzzle: Illustrate the simplest way to generate Jan thru Dec. - Original Message - From: "Roger Glenfield" <[EMAIL PROTECTED]> To: Sent: Monday, May 08, 2006 9:42 AM Subject: Re: [U2] OPEN Statement DICT Default > The same programmer that doesn't read the manual does an > > EXECUTE instead of a SELECTINDEX, and yes, the index already existed > > or > A=STR('0',20-LEN(B)):B > instead of > A=FMT(B,'L%20') or for the Universe Pick/Ideal flavor people in the > crowd A= B'L%20' > > or > TODAY=OCONV(DATE(),'D2/') > CONVERT '/' TO @VM IN TODAY > MONTH=TODAY<1,2> > instead of > MONTH=OCONV(DATE(),'DM') > > > And yes, I have observed all of the above recently. > > ;) Just 15 minutes a week to look through the current manuals to find > out about a new option that you might not know existed? > > Roger > > Louie Bergsagel wrote: > > I've never used the null dict indicator. Who ever reads the syntax book > > unless a command doesn't work? > > > > *":)* > > -- Louie Bergsagel > > > > > > On 5/5/06, Mark Johnson <[EMAIL PROTECTED]> wrote: > > > >> To All: > >> > >> Was there ever a real requirement on any prior flavor to have the > >> typically > >> non-used DICT portion of the OPEN statement be the set of quotes and a > >> comma. > >> > >> I accidentally forgot it in 1978 on a Microdata and it still compiled. To > >> this > >> day I have not seen a reason for the OPEN "","FILE" null dict indicator > >> and > >> have not used it since unless I actually want the DICT level. > >> > >> Just wondering. > >> > >> Thanks > >> Mark Johnson > >> --- > >> 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/
Re: [U2] OPEN Statement DICT Default
Solution to "puzzle" : Month = OCONV(DATE(),"DMBL") D = Date MB = Abbreviated Month Name L = Lower Case On 9/5/06 9:45 AM, "Mark Johnson" <[EMAIL PROTECTED]> wrote: > I specifically remember being taught > X=STR("0",5-LEN(X)):X > for the 1 concept. > Before the % was allowed, a shorter form was > X=("0":X)"R#5" > which I recall using until % came about. > > On that note, I stole "R-10" and "C#10" from UD and offered it to D3 > hopefully for their next release. > > Thanks > Mark Johnson > > P.S. Many use OCONV(DATE(),"D2/")[7,2] for the month. I think DATE()"DM" is > the shortest way. > Puzzle: Illustrate the simplest way to generate Jan thru Dec. > > > - Original Message - > From: "Roger Glenfield" <[EMAIL PROTECTED]> > To: > Sent: Monday, May 08, 2006 9:42 AM > Subject: Re: [U2] OPEN Statement DICT Default > > >> The same programmer that doesn't read the manual does an >> >> EXECUTE instead of a SELECTINDEX, and yes, the index already existed >> >> or >> A=STR('0',20-LEN(B)):B >> instead of >> A=FMT(B,'L%20') or for the Universe Pick/Ideal flavor people in the >> crowd A= B'L%20' >> >> or >> TODAY=OCONV(DATE(),'D2/') >> CONVERT '/' TO @VM IN TODAY >> MONTH=TODAY<1,2> >> instead of >> MONTH=OCONV(DATE(),'DM') >> >> >> And yes, I have observed all of the above recently. >> >> ;) Just 15 minutes a week to look through the current manuals to find >> out about a new option that you might not know existed? >> >> Roger >> >> Louie Bergsagel wrote: >>> I've never used the null dict indicator. Who ever reads the syntax book >>> unless a command doesn't work? >>> >>> *":)* >>> -- Louie Bergsagel >>> >>> >>> On 5/5/06, Mark Johnson <[EMAIL PROTECTED]> wrote: >>> To All: Was there ever a real requirement on any prior flavor to have the typically non-used DICT portion of the OPEN statement be the set of quotes and a comma. I accidentally forgot it in 1978 on a Microdata and it still compiled. > To this day I have not seen a reason for the OPEN "","FILE" null dict indicator and have not used it since unless I actually want the DICT level. Just wondering. Thanks Mark Johnson --- 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/ > -- Adrian Overs Phone : +61 (0)2 9484-7160 Mobile: +61 (0)411 358 354 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] OPEN Statement DICT Default
I specifically remember being taught X=STR("0",5-LEN(X)):X for the 1 concept. Before the % was allowed, a shorter form was X=("0":X)"R#5" which I recall using until % came about. On that note, I stole "R-10" and "C#10" from UD and offered it to D3 hopefully for their next release. Thanks Mark Johnson P.S. Many use OCONV(DATE(),"D2/")[7,2] for the month. I think DATE()"DM" is the shortest way. Puzzle: Illustrate the simplest way to generate Jan thru Dec. - Original Message - From: "Roger Glenfield" <[EMAIL PROTECTED]> To: Sent: Monday, May 08, 2006 9:42 AM Subject: Re: [U2] OPEN Statement DICT Default > The same programmer that doesn't read the manual does an > > EXECUTE instead of a SELECTINDEX, and yes, the index already existed > > or > A=STR('0',20-LEN(B)):B > instead of > A=FMT(B,'L%20') or for the Universe Pick/Ideal flavor people in the > crowd A= B'L%20' > > or > TODAY=OCONV(DATE(),'D2/') > CONVERT '/' TO @VM IN TODAY > MONTH=TODAY<1,2> > instead of > MONTH=OCONV(DATE(),'DM') > > > And yes, I have observed all of the above recently. > > ;) Just 15 minutes a week to look through the current manuals to find > out about a new option that you might not know existed? > > Roger > > Louie Bergsagel wrote: > > I've never used the null dict indicator. Who ever reads the syntax book > > unless a command doesn't work? > > > > *":)* > > -- Louie Bergsagel > > > > > > On 5/5/06, Mark Johnson <[EMAIL PROTECTED]> wrote: > > > >> To All: > >> > >> Was there ever a real requirement on any prior flavor to have the > >> typically > >> non-used DICT portion of the OPEN statement be the set of quotes and a > >> comma. > >> > >> I accidentally forgot it in 1978 on a Microdata and it still compiled. To > >> this > >> day I have not seen a reason for the OPEN "","FILE" null dict indicator > >> and > >> have not used it since unless I actually want the DICT level. > >> > >> Just wondering. > >> > >> Thanks > >> Mark Johnson > >> --- > >> 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/
RE: [U2] "extra" UDT.EXE's
Yes, I wondered about phantoms also -- so I have been manually monitoring the _ph_ directory over the past couple weeks, but no clues so far. Thanks for the other observations, they may help also. The extraneous UDT.EXE's grow in number at about an 80% rate daily, in relation to the "real" connections. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson Sent: Monday, May 08, 2006 10:20 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] "extra" UDT.EXE's I don't think that UniObjects puppy runs an UDT.EXE - It runs a RPC server variant instead... a matched pair of "udapi_server.exe" and "udapi_slave.exe" running under the "unirpcd.exe" tree. I would look at your telnetd service as spawning them with "login: " prompts scrolling by on the client side... (Esp if under the process explorer they are under the telnetd service process) What I see is when the "login: " repeats, UDT starts a new UDT.EXE and the old one dies at that moment. I changed my timeout settings in UniAdmin to slow this process down a bit. The other thought would be phantoms spawning and not killing their UDT.EXE. These puppies appear as thou they do not have a parent process if you login, spawn phantom, logout. The reason would be that the parent PID handle is no longer valid. On windows 2003 they seem to die, but on your 2000 box they could be staying alive... (evil?) How fast are they stacking up? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hammer, Mark Sent: Monday, May 08, 2006 9:27 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] "extra" UDT.EXE's Thanks to Marc/Victor/Anthony for the responses. We do have one VB.NET app that uses UniObjects to access the DB -- that's about the only thing I haven't totally exhausted yet... I'll see if I can find anything odd occurring with those processes. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Victor St Clair Sent: Thursday, May 04, 2006 3:25 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] "extra" UDT.EXE's Hello Mark We had a situation recently that sounds similar to yours, but only on a development machine. Unfortunately it happened over the weekend and the system admin rebooted the box, to get rid of the extra udt.exe processes, before I could get in to examine the situation thoroughly. In our case there were only 4, but they were all grabbing all the cpu they could get, pegging it out at 100% all the time. We're on UniData 7.1 on W2K3. In our case, I believe the cause was terminated UniObjects connections. A UniObjects process was calling a UniBasic program via the uniCommand method. The UniBasic program had a debug statement in it, which caused the UniObjects app to hang. It had to be terminated. Don't know if you're using UniObjects, but maybe our experience will give you a hint you can use. Victor St. Clair -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hammer, Mark Sent: Thursday, May 04, 2006 11:27 AM To: u2-users@listserver.u2ug.org Subject: [U2] "extra" UDT.EXE's Has anyone ever had a problem with extra unidentified UDT.EXE processes spawning -- and then never dying? For example, on our main server running Unidata 6.012 on Windows 2000, the UniAdmin tool usually shows around 100 connections during production hours. When I then dump the process list end examine it, I count over 300 UDT.EXE's -- these extraneous processes consuming an average of 2.3MB - 2.5MB of RAM and 0% processor. This is after about 3 days of uptime, indicating that the number steadily grows as time passes -- forcing us to reboot about twice per week. Hardware: Dell 2650 2GB RAM dual 2.GHz Xeons split backplane, RAID 5 on the DB volume Thanks, Mark J. Hammer Systems Analyst Manitowoc Beverage Equipment 812-246-7000 x360 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. --- 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/
RE: [U2] "extra" UDT.EXE's
I don't think that UniObjects puppy runs an UDT.EXE - It runs a RPC server variant instead... a matched pair of "udapi_server.exe" and "udapi_slave.exe" running under the "unirpcd.exe" tree. I would look at your telnetd service as spawning them with "login: " prompts scrolling by on the client side... (Esp if under the process explorer they are under the telnetd service process) What I see is when the "login: " repeats, UDT starts a new UDT.EXE and the old one dies at that moment. I changed my timeout settings in UniAdmin to slow this process down a bit. The other thought would be phantoms spawning and not killing their UDT.EXE. These puppies appear as thou they do not have a parent process if you login, spawn phantom, logout. The reason would be that the parent PID handle is no longer valid. On windows 2003 they seem to die, but on your 2000 box they could be staying alive... (evil?) How fast are they stacking up? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hammer, Mark Sent: Monday, May 08, 2006 9:27 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] "extra" UDT.EXE's Thanks to Marc/Victor/Anthony for the responses. We do have one VB.NET app that uses UniObjects to access the DB -- that's about the only thing I haven't totally exhausted yet... I'll see if I can find anything odd occurring with those processes. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Victor St Clair Sent: Thursday, May 04, 2006 3:25 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] "extra" UDT.EXE's Hello Mark We had a situation recently that sounds similar to yours, but only on a development machine. Unfortunately it happened over the weekend and the system admin rebooted the box, to get rid of the extra udt.exe processes, before I could get in to examine the situation thoroughly. In our case there were only 4, but they were all grabbing all the cpu they could get, pegging it out at 100% all the time. We're on UniData 7.1 on W2K3. In our case, I believe the cause was terminated UniObjects connections. A UniObjects process was calling a UniBasic program via the uniCommand method. The UniBasic program had a debug statement in it, which caused the UniObjects app to hang. It had to be terminated. Don't know if you're using UniObjects, but maybe our experience will give you a hint you can use. Victor St. Clair -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hammer, Mark Sent: Thursday, May 04, 2006 11:27 AM To: u2-users@listserver.u2ug.org Subject: [U2] "extra" UDT.EXE's Has anyone ever had a problem with extra unidentified UDT.EXE processes spawning -- and then never dying? For example, on our main server running Unidata 6.012 on Windows 2000, the UniAdmin tool usually shows around 100 connections during production hours. When I then dump the process list end examine it, I count over 300 UDT.EXE's -- these extraneous processes consuming an average of 2.3MB - 2.5MB of RAM and 0% processor. This is after about 3 days of uptime, indicating that the number steadily grows as time passes -- forcing us to reboot about twice per week. Hardware: Dell 2650 2GB RAM dual 2.GHz Xeons split backplane, RAID 5 on the DB volume Thanks, Mark J. Hammer Systems Analyst Manitowoc Beverage Equipment 812-246-7000 x360 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. --- 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/
Re: [U2] OPEN Statement DICT Default
The same programmer that doesn't read the manual does an EXECUTE instead of a SELECTINDEX, and yes, the index already existed or A=STR('0',20-LEN(B)):B instead of A=FMT(B,'L%20') or for the Universe Pick/Ideal flavor people in the crowd A= B'L%20' or TODAY=OCONV(DATE(),'D2/') CONVERT '/' TO @VM IN TODAY MONTH=TODAY<1,2> instead of MONTH=OCONV(DATE(),'DM') And yes, I have observed all of the above recently. ;) Just 15 minutes a week to look through the current manuals to find out about a new option that you might not know existed? Roger Louie Bergsagel wrote: I've never used the null dict indicator. Who ever reads the syntax book unless a command doesn't work? *":)* -- Louie Bergsagel On 5/5/06, Mark Johnson <[EMAIL PROTECTED]> wrote: To All: Was there ever a real requirement on any prior flavor to have the typically non-used DICT portion of the OPEN statement be the set of quotes and a comma. I accidentally forgot it in 1978 on a Microdata and it still compiled. To this day I have not seen a reason for the OPEN "","FILE" null dict indicator and have not used it since unless I actually want the DICT level. Just wondering. Thanks Mark Johnson --- 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] "extra" UDT.EXE's
Thanks to Marc/Victor/Anthony for the responses. We do have one VB.NET app that uses UniObjects to access the DB -- that's about the only thing I haven't totally exhausted yet... I'll see if I can find anything odd occurring with those processes. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Victor St Clair Sent: Thursday, May 04, 2006 3:25 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] "extra" UDT.EXE's Hello Mark We had a situation recently that sounds similar to yours, but only on a development machine. Unfortunately it happened over the weekend and the system admin rebooted the box, to get rid of the extra udt.exe processes, before I could get in to examine the situation thoroughly. In our case there were only 4, but they were all grabbing all the cpu they could get, pegging it out at 100% all the time. We're on UniData 7.1 on W2K3. In our case, I believe the cause was terminated UniObjects connections. A UniObjects process was calling a UniBasic program via the uniCommand method. The UniBasic program had a debug statement in it, which caused the UniObjects app to hang. It had to be terminated. Don't know if you're using UniObjects, but maybe our experience will give you a hint you can use. Victor St. Clair -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hammer, Mark Sent: Thursday, May 04, 2006 11:27 AM To: u2-users@listserver.u2ug.org Subject: [U2] "extra" UDT.EXE's Has anyone ever had a problem with extra unidentified UDT.EXE processes spawning -- and then never dying? For example, on our main server running Unidata 6.012 on Windows 2000, the UniAdmin tool usually shows around 100 connections during production hours. When I then dump the process list end examine it, I count over 300 UDT.EXE's -- these extraneous processes consuming an average of 2.3MB - 2.5MB of RAM and 0% processor. This is after about 3 days of uptime, indicating that the number steadily grows as time passes -- forcing us to reboot about twice per week. Hardware: Dell 2650 2GB RAM dual 2.GHz Xeons split backplane, RAID 5 on the DB volume Thanks, Mark J. Hammer Systems Analyst Manitowoc Beverage Equipment 812-246-7000 x360 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. --- 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] CPFR
Barry, Not the CP, but certainly the FR parts. I've done a lot of Forecasting and Replenishment, also Model Stock. You can call me tomorrow (718) 762-3884 x 1 or e-mail me off-list. I'm actually doing a series in Intl Spectrum right now which touchs on some of these issues. -- Charles Barouch [EMAIL PROTECTED] - Consulting [EMAIL PROTECTED] - ETL/Migration/Integration (718) 762-3884x1 Barry Rogen wrote: | Is (or has) anybody been involved in the development and implementation of a CPFR (Collaborative Planning, Forecasting and Replenishment) system. If so, would love to pick your brain on this topic. Please contact me offline if you can spare me a few moments to discuss this topic... --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] CPFR
Is (or has) anybody been involved in the development and implementation of a CPFR (Collaborative Planning, Forecasting and Replenishment) system. If so, would love to pick your brain on this topic. Please contact me offline if you can spare me a few moments to discuss this topic... Cheers, Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat.t. roosevelt NOT INTENDED AS A SUBSTITUTE FOR A WRITING NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER. This e-mail message from PNY Technologies, Inc. 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] Unit testing and UniObjects for Java
Great post Brian It made me think about some of the code I'm working on right now and I think I'll make a few changes as a direct result. Thanks! Rob Wills (rob dot wills at tigerinfotech dot com) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unit testing and UniObjects for Java
Wendy Sorry for the long answer, and some of this sounds like it may be too late, but you've hit a hobby horse of mine here ! It looks from your example (and apologies if I am misreading this) that you have business logic and file interaction inside your UO code. That really makes life hard. I ALWAYS teach clients to write all the business logic in server subroutines first for any client/server or web project - and for precisely this reason. Debugging any client/server program is difficult and time consuming, web/multiplexed programs even more so, tracking down where errors occur (especially if you have different teams for front and back end) is bad news and there is also the 'hey wow' factor of the front end obscuring development and testing of the business logic. So the route I always teach (and hopefully follow ) is: 1. Write all the database interaction as subroutines. 2. Where possible use a standard calling convention - I know this goes against the grain for some, but it is specifically to allow logging/debugging/testing using a simple harness: Call MySubroutine( Action, InData, OutData, ErrText ) Where InData, OutData are dynamic arrays, ErrText adds error text to a dynamic array of error messages, and Action allows the routine to vary e.g. new for a new version whilst retaining backward compatibility. 3. Then I recommend people QA the server before even THINKING about the front end: if it is well designed, the subroutine library effectively becomes an API for you application and can be reusable eg. From UO (or UOJ in your case), web applications such as mvScript (quick plug) or RedBack via interface subs, the new U2 web services etc. It is also comforting to be able to concentrate on the client whilst knowing that the logic behind it is secure. 4. Since the front end is the more likely to change, this route isolates the logic but a good test harness should allow for regression testing at the server. 5. Since I use a standard calling convention, I can use a single function to call the server. Which means I can use a single place to add logging/auditing etc and and I guess I could also write a dummy function to simulate this (though that is a step I haven't had to perform yet - I just use refreshable test account on virtual PC images) against another source. I would also recommend NOT doing opens, reads, executes, select list handling etc directly in UO - not because they do not work, but because your logic gets scattered. That was a lesson I learned early on in the days of VB and UO when I took on a project where the requirements changed almost weekly: it eventually became unmanageable and I wasn't proud of the result (though it delivered what they wanted :) ), but boy did it teach some lessons! Keeping all the business logic in one place is a high priority: we don't need mainstream 3 tier logic as we have the database run machine to provide the logic tier. Just keep everything there where it works, and everything will be fine: but as soon as you allow it to creep into the presentation layer, you will be storing up trouble. Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Wendy Smoak > Sent: 05 May 2006 19:45 > To: u2-users@listserver.u2ug.org > Subject: [U2] Unit testing and UniObjects for Java > > I'm going to set this project aside for the day, but I want > to toss the question out to see if anyone else has an answer. > > I'm having a horrible time trying to unit test code that uses > UOJ. In the past I've just 'cheated' and tested against the > database itself, but that really shouldn't be necessary. > It's also not "unit" testing as the tests then cover the > interaction between the code and the database. > > Here's an example of the code under test: > > uFile = uSession.openFile( filename ); > uString = uFile.read( key ); > > I'm attempting to mock the UniFile object, but I get: >asjava.uniobjects.UniFileException: Cannot instantiate > this object in this manner. > Must use the UniSession object > > (So why even *have* a default constructor in UniFile?) > > I'd love to hear how you're unit testing your UOJ dependent code. > > Thanks, > Wendy Smoak > --- > 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] [JOB] UniVerse Developers
OUTsurance is a dynamic company that runs world-class in-house IT systems and uses state of the art technologies. We are one of the largest users of Universe technologies in South Africa. Job Requirements: We require an individual with at least 6 years of UNIVERSE DATABASE experience to join our dynamic team of system developers. We are looking for a 'hands-on' technical expert with excellent programming skill and the ability to work independently and under pressure. Attention to detail and a quality orientation are essential. Salient Features: The incumbent will be specialist in both UNIVERSE and SB+ technologies. Web design including .Net skills would be advantageous. Job Responsibilities: Together with a team of developers, the incumbent will assume full responsibility for development and maintenance work on the in-house system. This includes meeting stringent quantity and quality criteria. A high tolerance for stress is essential. Interested South African applicants must email a comprehensive CV to [EMAIL PROTECTED] or fax to Suren Naidoo on 012 673 4940. Important Notice: This email is subject to important restrictions, qualifications and disclaimers ("the Disclaimer") that must be accessed and read at the following address or by copying and pasting the following address into your Internet browser's address bar: http://www.frstia.co.za/Disclaimer.asp The Disclaimer is deemed to form part of the content of this email in terms of Section 11 of the Electronic Communications and Transactions Act, 25 of 2002. If you cannot access the Disclaimer, please obtain a copy thereof from us by sending an email to mailto:[EMAIL PROTECTED] FirstRand STI Admin (Pty) Ltd is an Authorised Financial Services Provider --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/