Re: [U2] File pointer question
Nice idea - but change @WHO to @PATH to catch the situation that you have two accounts with the same name under different paths. When we were bit by this - as PI newbees in the early 80's - we just banned logto's and never used'em since. -- mats [EMAIL PROTECTED] skrev: > I was bit by that one a long while ago. > > If that's the case, best to do something like the following to make sure the > info is relevant to the current account. > > COMMON /PGMNAME/ FILE.POINTER,PGMNAME.INIT > IF NOT(ASSIGNED(PGMNAME.INIT)) THEN PGMNAME.INIT='' > IF [EMAIL PROTECTED] THEN > PGMNAME.INIT='' > OPEN '',FILE.NAME TO FILE.POINTER ELSE WHATEVER > [EMAIL PROTECTED] > END > > > -- Original message -- > From: "Mats Carlid" <[EMAIL PROTECTED]> > > >> Another possibility is that You opened the file in the other >> directory and then LOGTO'ed the current. >> Especially watch out for file pointers kept in common - >> if You use them the open and logto may have been done >> outside the current program. >> -- mats >> >> Jeff Fitzgerald skrev: >> >>> If you are on a UNIX system the file may be a symbolic link to a file in >>> another account. If this is the case, it is a really bad idea in my >>> opinion. (1) It is very confusing! (2) It can cause problems, >>> especially on UniVerse, when the file is resized. If you find the file >>> is a symbolic link it would probably be worth your while to get rid of >>> the link and modify the F pointer to point to the real location. >>> >>> HTH >>> >>> Jeff Fitzgerald >>> Fitzgerald & Long, Inc. >>> www.fitzlong.com >>> >>> >>> -Original Message- >>> From: [EMAIL PROTECTED] >>> [mailto:[EMAIL PROTECTED] On Behalf Of T Stokes >>> Sent: Wednesday, June 11, 2008 4:22 PM >>> To: u2-users@listserver.u2ug.org >>> Subject: [U2] File pointer question >>> >>> I have a file that is a F pointer in the VOC yet when a BASIC STATUS is >>> ran on the file it points to a file in another account. >>> Have not been able to locate the reason for this. I am sure it is >>> something simple. >>> The VOC entry look like this >>> F >>> FILENAME >>> D_FILENAME >>> >>> The results from STATUS looks like this D:\directory other than the >>> directory I am current located\FILENAME >>> >> --- >> 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] UD: Indexes
Kevin: Building a name in last, first mi format. A list looks like: 2 Dev (0)-> LIST ARTMASTER INDEX_2 LIST ARTMASTER INDEX_2 21:44:57 Jun 12 2008 1 ARTMASTER... INDEX_2. 260*50/6 0260PETTY, MICHAEL J & DEENA M00050/6 400*48 0400NELSON, MATTHEW048 260*35/3 0260MILLER, BRUCE00035/3 135*4712 0135MARTIN, ROBERT K & MARY L0004712 . . The 1st 4 bytes are from the key. The next data is the name (built by the subroutine "T.LFM" from an address book) followed by the 2nd part of the key. It doesn't matter if the address book data (the secondary file) is changed because if it is then a flag is set and the "ARTMASTER" file (the primary file) is reindexed upon the next login by anyone. Bill >-Original Message- >From: [EMAIL PROTECTED] [mailto:owner-u2- >[EMAIL PROTECTED] On Behalf Of Kevin King >Sent: Thursday, June 12, 2008 9:41 PM >To: u2-users@listserver.u2ug.org >Subject: Re: [U2] UD: Indexes > >What exactly are these subroutines doing? > >On Thu, Jun 12, 2008 at 6:51 PM, Bill Haskett <[EMAIL PROTECTED]> >wrote: > >> As a follow up, here's an index that was corrupted earlier: >> >> 2 Dev (0)-> LIST-INDEX ARTMASTER >> Alternate Key Index Details for File ARTMASTER Page 1 >> >> File.. ARTMASTER >> Alternate key length.. 45 >> Node/Block size... 4K >> OV blocks. 1 (0 in use, 0 overflowed) >> Indices... 3 (0 D-type) >> Index updates. Enabled, No updates pending >> >> Index-Name.. F-type K-type Built Empties Dups In-DICT S/M >> F-no/VF-expr >> INDEX_1 V TxtYes Yes Yes Yes M SUBR( >> '-CATS', S >> UBR( "T.LFM", >> NI >> D, @ >> FILE.NAME, @ >> RECORD ), >> REUSE( >>OCONV( >> *OCONV( >> @ID, 'G1*1' >> )*, >> 'MR%7' ) ) ) >> INDEX_2 V TxtYes Yes Yes Yes M SUBR( >> '-CATS', S >> UBR( >> "T.CLLFM", >> NID, @ >> FILE.NAME, >>@RECORD, @ID >> ), >>REUSE( >> OCONV( * >> OCONV( @ID, >> 'G1* >> 1' )*, 'MR%7' >> ) >> ) ) >> INDEX_3 V TxtYes Yes Yes Yes M OCONV( >> *OCONV( @ >> ID, 'G*1' )*, >> 'M >> R%4' ) : >> EXTRACT >> ( PHADD, 1, >> 1, 0 >>) >> >> >> Thanks, >> >> Bill >> >> >> >-Original Message- >> >From: [EMAIL PROTECTED] [mailto:owner-u2- >> >[EMAIL PROTECTED] On Behalf Of Bill Haskett >> >Sent: Thursday, June 12, 2008 5:38 PM >> >To: u2-users@listserver.u2ug.org >> >Subject: [U2] UD: Indexes >> > >> >Has anyone had trouble with UniData indexes? We moved an application from >> >D3 to UD and it's been reported that indexes are needing to be rebuilt on >> >a recurring basis. >> > >> >We created a program that will delete the index then rebuild it for needed >> >dictionary items. After this program is run everything works fine, until >> >the next time. >> > >> >Any thoughts would be appreciated. Thanks, >> > >> >Bill Haskett >> >Advantos Systems, Inc. >> --- >> u2-users mailing list >> u2-users@listserver.u2ug.org >> To unsubscribe please visit http://listserver.u2ug.org/ >> > > > >-- >-Kevin >http://www.PrecisOnline.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] UD: Indexes
Colin: The data in the index is extracted from another file. It's an address book file. Here's what a listing looks like: 2 Dev (0)-> LIST ARTMASTER INDEX_2 LIST ARTMASTER INDEX_2 21:44:57 Jun 12 2008 1 ARTMASTER... INDEX_2. 260*50/6 0260PETTY, MICHAEL J & DEENA M00050/6 400*48 0400NELSON, MATTHEW048 260*35/3 0260MILLER, BRUCE00035/3 135*4712 0135MARTIN, ROBERT K & MARY L0004712 . . The 1st 4 bytes are from the key. The next data is a built name in (L, F MI) format, followed by the 2nd part of the key. It doesn't matter if the address book data is changed because if it is then a flag is set and the "ARTMASTER" file is reindexed upon the next login by anyone. Do you think this may be a problem? Bill >-Original Message- >From: [EMAIL PROTECTED] [mailto:owner-u2- >[EMAIL PROTECTED] On Behalf Of Colin Alfke >Sent: Thursday, June 12, 2008 9:31 PM >To: u2-users@listserver.u2ug.org >Subject: RE: [U2] UD: Indexes > >Bill; > >We haven't had trouble since an early version of version 6 had an "overly >optimized" version of udtsort. > >Are any of those subroutines returning data from a remote file? UniData >doesn't have a link to the remote file to know when it's updated so the index >won't be updated. > >Are they supposed to be multivalued? > >hth >Colin Alfke >Calgary Canada > >> From: wphaskett >> >> As a follow up, here's an index that was corrupted earlier: >> >> 2 Dev (0)-> LIST-INDEX ARTMASTER >> Alternate Key Index Details for File ARTMASTER Page 1 >> >> File.. ARTMASTER >> Alternate key length.. 45 >> Node/Block size... 4K >> OV blocks. 1 (0 in use, 0 overflowed) >> Indices... 3 (0 D-type) >> Index updates. Enabled, No updates pending >> >> Index-Name.. F-type K-type Built Empties Dups In-DICT S/M >F-no/VF-expr >> INDEX_1 V TxtYes Yes Yes Yes M >> SUBR( '-CATS', SUBR( "T.LFM", NID, @FILE.NAME, @RECORD ), >> REUSE(OCONV( *OCONV(@ID, 'G1*1' )*,'MR%7' ) ) ) > >> INDEX_2 V TxtYes Yes Yes Yes M >> SUBR( '-CATS', SUBR( "T.CLLFM",NID, @FILE.NAME,@RECORD, @ID ), >> REUSE( >OCONV( *OCONV( @ID, 'G1*1' )*, 'MR%7' ))) >> INDEX_3 V TxtYes Yes Yes Yes M >> OCONV( *OCONV( @ID, 'G*1' )*, 'MR%4' ) : EXTRACT( PHADD, 1, 1, 0) >> >> >> Thanks, >> >> Bill >> >> >> >-Original Message- >> > >> >Has anyone had trouble with UniData indexes? We moved an application from >> >D3 to UD and it's been reported that indexes are needing to be rebuilt on >> >a recurring basis. >> > >> >We created a program that will delete the index then rebuild it for needed >> >dictionary items. After this program is run everything works fine, until >> >the next time. >> > >> >Any thoughts would be appreciated. Thanks, >> > >> >Bill Haskett >> >Advantos Systems, Inc. > > >_ >Find hidden words, unscramble celebrity names, or try the ultimate crossword >puzzle with Live Search Games. Play now! >http://g.msn.ca/ca55/212 >--- >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] UD: Indexes
What exactly are these subroutines doing? On Thu, Jun 12, 2008 at 6:51 PM, Bill Haskett <[EMAIL PROTECTED]> wrote: > As a follow up, here's an index that was corrupted earlier: > > 2 Dev (0)-> LIST-INDEX ARTMASTER > Alternate Key Index Details for File ARTMASTER Page 1 > > File.. ARTMASTER > Alternate key length.. 45 > Node/Block size... 4K > OV blocks. 1 (0 in use, 0 overflowed) > Indices... 3 (0 D-type) > Index updates. Enabled, No updates pending > > Index-Name.. F-type K-type Built Empties Dups In-DICT S/M > F-no/VF-expr > INDEX_1 V TxtYes Yes Yes Yes M SUBR( > '-CATS', S > UBR( "T.LFM", > NI > D, @ > FILE.NAME, @ > RECORD ), > REUSE( >OCONV( > *OCONV( > @ID, 'G1*1' > )*, > 'MR%7' ) ) ) > INDEX_2 V TxtYes Yes Yes Yes M SUBR( > '-CATS', S > UBR( > "T.CLLFM", > NID, @ > FILE.NAME, >@RECORD, @ID > ), >REUSE( > OCONV( * > OCONV( @ID, > 'G1* > 1' )*, 'MR%7' > ) > ) ) > INDEX_3 V TxtYes Yes Yes Yes M OCONV( > *OCONV( @ > ID, 'G*1' )*, > 'M > R%4' ) : > EXTRACT > ( PHADD, 1, > 1, 0 >) > > > Thanks, > > Bill > > > >-Original Message- > >From: [EMAIL PROTECTED] [mailto:owner-u2- > >[EMAIL PROTECTED] On Behalf Of Bill Haskett > >Sent: Thursday, June 12, 2008 5:38 PM > >To: u2-users@listserver.u2ug.org > >Subject: [U2] UD: Indexes > > > >Has anyone had trouble with UniData indexes? We moved an application from > >D3 to UD and it's been reported that indexes are needing to be rebuilt on > >a recurring basis. > > > >We created a program that will delete the index then rebuild it for needed > >dictionary items. After this program is run everything works fine, until > >the next time. > > > >Any thoughts would be appreciated. Thanks, > > > >Bill Haskett > >Advantos Systems, Inc. > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > -- -Kevin http://www.PrecisOnline.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD: Indexes
Bill; We haven't had trouble since an early version of version 6 had an "overly optimized" version of udtsort. Are any of those subroutines returning data from a remote file? UniData doesn't have a link to the remote file to know when it's updated so the index won't be updated. Are they supposed to be multivalued? hth Colin Alfke Calgary Canada > From: wphaskett > > As a follow up, here's an index that was corrupted earlier: > > 2 Dev (0)-> LIST-INDEX ARTMASTER > Alternate Key Index Details for File ARTMASTER Page 1 > > File.. ARTMASTER > Alternate key length.. 45 > Node/Block size... 4K > OV blocks. 1 (0 in use, 0 overflowed) > Indices... 3 (0 D-type) > Index updates. Enabled, No updates pending > > Index-Name.. F-type K-type Built Empties Dups In-DICT S/M F-no/VF-expr > INDEX_1 V TxtYes Yes Yes Yes M > SUBR( '-CATS', SUBR( "T.LFM", NID, @FILE.NAME, @RECORD ), > REUSE(OCONV( *OCONV(@ID, 'G1*1' )*,'MR%7' ) ) ) > INDEX_2 V TxtYes Yes Yes Yes M > SUBR( '-CATS', SUBR( "T.CLLFM",NID, @FILE.NAME,@RECORD, @ID ), > REUSE( OCONV( *OCONV( @ID, 'G1*1' )*, 'MR%7' ))) > INDEX_3 V TxtYes Yes Yes Yes M > OCONV( *OCONV( @ID, 'G*1' )*, 'MR%4' ) : EXTRACT( PHADD, 1, 1, 0) > > > Thanks, > > Bill > > > >-Original Message- > > > >Has anyone had trouble with UniData indexes? We moved an application from > >D3 to UD and it's been reported that indexes are needing to be rebuilt on > >a recurring basis. > > > >We created a program that will delete the index then rebuild it for needed > >dictionary items. After this program is run everything works fine, until > >the next time. > > > >Any thoughts would be appreciated. Thanks, > > > >Bill Haskett > >Advantos Systems, Inc. _ Find hidden words, unscramble celebrity names, or try the ultimate crossword puzzle with Live Search Games. Play now! http://g.msn.ca/ca55/212 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniSubroutine question
Yes. -- From: <[EMAIL PROTECTED]> Sent: Thursday, June 12, 2008 3:19 PM To: Subject: RE: [U2] UniSubroutine question We make calls to our UV box (Linux) from network apps (Windows) passing whatever variables collected on the net. The calls, call subroutines on the UV server that create whatever the Net application needs to display or process the information. Sometimes HTML, sometimes XML, and sometimes arrays of data. It is much faster to do it this way then to just do other types of calls to the database. The Linux system is faster at crunching the data and building the pages then trying to quiry for the data and building the pages in Windows. Jerry, Do you build the HTML in the UniBasic subs? e.g. PAGE = "" PAGE := "" PAGE := "This is the title" . . . RETURN PAGE Charles Shaffer Senior Analyst NTN-Bower Corporation --- 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] UD: Indexes
As a follow up, here's an index that was corrupted earlier: 2 Dev (0)-> LIST-INDEX ARTMASTER Alternate Key Index Details for File ARTMASTER Page 1 File.. ARTMASTER Alternate key length.. 45 Node/Block size... 4K OV blocks. 1 (0 in use, 0 overflowed) Indices... 3 (0 D-type) Index updates. Enabled, No updates pending Index-Name.. F-type K-type Built Empties Dups In-DICT S/M F-no/VF-expr INDEX_1 V TxtYes Yes Yes Yes M SUBR( '-CATS', S UBR( "T.LFM", NI D, @FILE.NAME, @ RECORD ), REUSE( OCONV( *OCONV( @ID, 'G1*1' )*, 'MR%7' ) ) ) INDEX_2 V TxtYes Yes Yes Yes M SUBR( '-CATS', S UBR( "T.CLLFM", NID, @FILE.NAME, @RECORD, @ID ), REUSE( OCONV( * OCONV( @ID, 'G1* 1' )*, 'MR%7' ) ) ) INDEX_3 V TxtYes Yes Yes Yes M OCONV( *OCONV( @ ID, 'G*1' )*, 'M R%4' ) : EXTRACT ( PHADD, 1, 1, 0 ) Thanks, Bill >-Original Message- >From: [EMAIL PROTECTED] [mailto:owner-u2- >[EMAIL PROTECTED] On Behalf Of Bill Haskett >Sent: Thursday, June 12, 2008 5:38 PM >To: u2-users@listserver.u2ug.org >Subject: [U2] UD: Indexes > >Has anyone had trouble with UniData indexes? We moved an application from >D3 to UD and it's been reported that indexes are needing to be rebuilt on >a recurring basis. > >We created a program that will delete the index then rebuild it for needed >dictionary items. After this program is run everything works fine, until >the next time. > >Any thoughts would be appreciated. Thanks, > >Bill Haskett >Advantos Systems, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UD: Indexes
Has anyone had trouble with UniData indexes? We moved an application from D3 to UD and it's been reported that indexes are needing to be rebuilt on a recurring basis. We created a program that will delete the index then rebuild it for needed dictionary items. After this program is run everything works fine, until the next time. L Any thoughts would be appreciated. Thanks, Bill Haskett Advantos Systems, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Error Opening &HOLD& file
Have you looked in errlog? Are you using a READU and could you have so many simultaneous processes opening &HOLD& that you are exceeding the READU threshold? Craig --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Error Opening &HOLD& file
Have you been able to a record in the &HOLD& file with in Universe. -Original Message- From: Martel, Henry [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2008 10:43 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Error Opening &HOLD& file Our system is HP-UX 11i Universe is ver 10.1 Our &HOLD& file is a type 19 file. There is no limit to this directory since it is a vxfs file system with largefiles enabled on it Currently there are only 2968 files in the &HOLD& file. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of JPB-U2UG Sent: Wednesday, June 11, 2008 12:11 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Error Opening &HOLD& file If your &HOLD& file is a type 1 or 19 file it is a directory file and subject to the maximum number of files (records) that can be put into a directory on your operating system. If the &HOLD& file is a static hashed file, which it is probably not, then it would be limited to a maximum of 2 GB on a 32 bit operating system. More than likely this is a symptom of the maximum number of files you have open. Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Martel, Henry Sent: Wednesday, June 11, 2008 9:04 AM To: u2-users@listserver.u2ug.org Subject: [U2] Error Opening &HOLD& file We seem to have a sporatic issue with some of our nightly jobs. They run for months at a time then all of a sudden, for 3 or 4 days in a row we start to see the following error "*PRINT.ONE.SEE.ATTACHED": Line 555, Cannot open file &HOLD&. Job seem to just fail because it can not open the &HOLD& file. Its more than just this one job, it happens to many jobs. So I suspect is some kind of issue with the &HOLD& file and not the job it's self. Has anyone else seen this before? Is there a max number of entries that can be in the &HOLD& file at one time? Thanks in advance. Henry. --- 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] New .Net data provider [ad]
Since this discussion is about MV / .NET data exchanges as much as the U2/DB2 data provider for .NET, I felt it safe to interject some helpful comments about DataTables (and Vista) without too much repercussion. But this sort of information applies to all MV platforms, not just U2, so I blogged it instead: remove.pleaseNebula-RnD.com/blog/tech/mv/2008/06/mvrelational02.h tml I quoted Brian's excellent notes and added follow-ups. Since products and services which we sell are mentioned without subtlety I've tagged this and the blog post as ads. HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula R&D sells mv.NET worldwide, and provides related development and training services --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniSubroutine question
Jerry, Thanks. I think I see how to do this. Charles Shaffer Senior Analyst NTN-Bower Corporation --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniSubroutine question
Hello It's been a couple years since I was doing this, so the details are getting fuzzy. But as I recall, UniObjects provides a class that has a query method. You pass your uniquery command as a string to the Query method which returns the XML. Now, I forgotten what the mechanism was for converting the xml to a dataset object, but it's built in to either UniObjects or .net. We found that besides the TOXML keyword, it was best to also always include the ELEMENTS keyword. With UniData, the default is to return the data as attributes. But the ELEMENTS keyword causes the data columns to be returned as elements.The main significance was that if your data set had a case where for a given field, none of the rows had a value in UniData, then that field was omitted from the xml results. So later, if your code referenced that column by name, you had an error condition to handle. The other point I remember is that it got slow with large data sets. By large I mean 50k+ rows of data. Most of the time (about 95%) is used in converting the uniquery results to xml then converting the XML to ADO. hth Victor St. Clair Sr. Analyst Jenkon [EMAIL PROTECTED] 360-256-4400 Phone 360-256-9623 Fax www.jenkon.com All information contained within this email is Confidential and Proprietary. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, June 12, 2008 1:14 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniSubroutine question >>In UO.NET I get my databasic to return xml - that way I can bind it to >>most any control. XML would be great. I am not sure about the syntax still. For example: LIST INVENTORY-MASTER WITH PART_TYPE = "5" PARTNUM DESCRIPTION TOXML This will list the XML to the screen. How do I capture the XML text and return it to the calling program? Also, my understanding is that you can generate DTD as well. Do you use this? If so, how do you capture the DTD? Also, in cases where something more complex is needed than a query, can XML be generated? Say you wanted to pull items from different files and do calculations, etc. Do you have to build dictionary attributes in all cases? Charles Shaffer Senior Analyst NTN-Bower Corporation --- 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] UniSubroutine question
>>We make calls to our UV box (Linux) from network apps (Windows) passing >>whatever variables collected on the net. The calls, call subroutines on the UV >>server that create whatever the Net application needs to display or process >>the information. Sometimes HTML, sometimes XML, and sometimes arrays of data. >>It is much faster to do it this way then to just do other types of calls to >>the database. The Linux system is faster at crunching the data and building >>the pages then trying to quiry for the data and building the pages in Windows. Jerry, Do you build the HTML in the UniBasic subs? e.g. PAGE = "" PAGE := "" PAGE := "This is the title" . . . RETURN PAGE Charles Shaffer Senior Analyst NTN-Bower Corporation --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniSubroutine question
If it's just a list report then you can call a Unibasic subroutine that uses an execute with the capture keyword then pass the captured data back to the calling program. If the report comes from many sources I would have a Unibasic subroutine that gathers the data and sends it back as html pages or in xml created in the subroutine. You could also generate the xml with the list toxml keyword but capture it to the &hold& file then read it back into the program and send it out to the calling program. Jerry > To: u2-users@listserver.u2ug.org> Subject: RE: [U2] UniSubroutine question> From: [EMAIL PROTECTED]> Date: Thu, 12 Jun 2008 13:13:51 -0500> > >>In UO.NET I get my databasic to return xml - that way I can bind it to> >>most any control.> > XML would be great. I am not sure about the syntax still. For example:> > LIST INVENTORY-MASTER WITH PART_TYPE = "5" PARTNUM DESCRIPTION TOXML> > This will list the XML to the screen. How do I capture the XML text and > return it to the calling program? > > Also, my understanding is that you can generate DTD as well. Do you use > this? If so, how do you capture the DTD?> > Also, in cases where something more complex is needed than a query, can > XML be generated? Say you wanted to pull items from different files and > do calculations, etc. Do you have to build dictionary attributes in all > cases?> > Charles Shaffer> Senior Analyst> NTN-Bower Corporation> ---> u2-users mailing list> u2-users@listserver.u2ug.org> To unsubscribe please visit http://listserver.u2ug.org/ _ Now you can invite friends from Facebook and other groups to join you on Windows Live Messenger. Add now. https://www.invite2messenger.net/im/?source=TXT_EML_WLH_AddNow_Now --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniSubroutine question
We make calls to our UV box (Linux) from network apps (Windows) passing whatever variables collected on the net. The calls, call subroutines on the UV server that create whatever the Net application needs to display or process the information. Sometimes HTML, sometimes XML, and sometimes arrays of data. It is much faster to do it this way then to just do other types of calls to the database. The Linux system is faster at crunching the data and building the pages then trying to quiry for the data and building the pages in Windows. Jerry _ Now you can invite friends from Facebook and other groups to join you on Windows Live Messenger. Add now. https://www.invite2messenger.net/im/?source=TXT_EML_WLH_AddNow_Now --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] File pointer question
I was bit by that one a long while ago. If that's the case, best to do something like the following to make sure the info is relevant to the current account. COMMON /PGMNAME/ FILE.POINTER,PGMNAME.INIT IF NOT(ASSIGNED(PGMNAME.INIT)) THEN PGMNAME.INIT='' IF [EMAIL PROTECTED] THEN PGMNAME.INIT='' OPEN '',FILE.NAME TO FILE.POINTER ELSE WHATEVER [EMAIL PROTECTED] END -- Original message -- From: "Mats Carlid" <[EMAIL PROTECTED]> > Another possibility is that You opened the file in the other > directory and then LOGTO'ed the current. > Especially watch out for file pointers kept in common - > if You use them the open and logto may have been done > outside the current program. > -- mats > > Jeff Fitzgerald skrev: > > If you are on a UNIX system the file may be a symbolic link to a file in > > another account. If this is the case, it is a really bad idea in my > > opinion. (1) It is very confusing! (2) It can cause problems, > > especially on UniVerse, when the file is resized. If you find the file > > is a symbolic link it would probably be worth your while to get rid of > > the link and modify the F pointer to point to the real location. > > > > HTH > > > > Jeff Fitzgerald > > Fitzgerald & Long, Inc. > > www.fitzlong.com > > > > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of T Stokes > > Sent: Wednesday, June 11, 2008 4:22 PM > > To: u2-users@listserver.u2ug.org > > Subject: [U2] File pointer question > > > > I have a file that is a F pointer in the VOC yet when a BASIC STATUS is > > ran on the file it points to a file in another account. > > Have not been able to locate the reason for this. I am sure it is > > something simple. > > The VOC entry look like this > > F > > FILENAME > > D_FILENAME > > > > The results from STATUS looks like this D:\directory other than the > > directory I am current located\FILENAME > --- > 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] UniSubroutine question
>>In UO.NET I get my databasic to return xml - that way I can bind it to >>most any control. XML would be great. I am not sure about the syntax still. For example: LIST INVENTORY-MASTER WITH PART_TYPE = "5" PARTNUM DESCRIPTION TOXML This will list the XML to the screen. How do I capture the XML text and return it to the calling program? Also, my understanding is that you can generate DTD as well. Do you use this? If so, how do you capture the DTD? Also, in cases where something more complex is needed than a query, can XML be generated? Say you wanted to pull items from different files and do calculations, etc. Do you have to build dictionary attributes in all cases? Charles Shaffer Senior Analyst NTN-Bower Corporation --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Error Opening &HOLD& file
Our system is HP-UX 11i Universe is ver 10.1 Our &HOLD& file is a type 19 file. There is no limit to this directory since it is a vxfs file system with largefiles enabled on it Currently there are only 2968 files in the &HOLD& file. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of JPB-U2UG Sent: Wednesday, June 11, 2008 12:11 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Error Opening &HOLD& file If your &HOLD& file is a type 1 or 19 file it is a directory file and subject to the maximum number of files (records) that can be put into a directory on your operating system. If the &HOLD& file is a static hashed file, which it is probably not, then it would be limited to a maximum of 2 GB on a 32 bit operating system. More than likely this is a symptom of the maximum number of files you have open. Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Martel, Henry Sent: Wednesday, June 11, 2008 9:04 AM To: u2-users@listserver.u2ug.org Subject: [U2] Error Opening &HOLD& file We seem to have a sporatic issue with some of our nightly jobs. They run for months at a time then all of a sudden, for 3 or 4 days in a row we start to see the following error "*PRINT.ONE.SEE.ATTACHED": Line 555, Cannot open file &HOLD&. Job seem to just fail because it can not open the &HOLD& file. Its more than just this one job, it happens to many jobs. So I suspect is some kind of issue with the &HOLD& file and not the job it's self. Has anyone else seen this before? Is there a max number of entries that can be in the &HOLD& file at one time? Thanks in advance. Henry. --- 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] UniSubroutine question
Hello That's the way we do it also, except we use C#. We do it by executing a command with TOXML tag on the end. Pretty easy to do, though there were a few gotchas along the way. Also, for very large datasets, it gets to be slow. Victor St. Clair Sr. Analyst Jenkon [EMAIL PROTECTED] 360-256-4400 Phone 360-256-9623 Fax www.jenkon.com All information contained within this email is Confidential and Proprietary. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen Sent: Thursday, June 12, 2008 10:23 AM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: RE: [U2] UniSubroutine question In UO.NET I get my databasic to return xml - that way I can bind it to most any control. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 12 June 2008 13:52 To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED]; u2-users@listserver.u2ug.org Subject: Re: [U2] UniSubroutine question A SQL compliant dataset would be OK.. A dynamic array would be OK. I have a routine returning one record in a dynamic array, but it comes into the UOJ code as a string. I guess I am looking for the best way to move multiple Unidata records in one bunch to UOJ code on the web server for further processing. Since I have never done it, I am looking for a best practice. . Charles Shaffer Senior Analyst NTN-Bower Corporation "Kevin King" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/11/2008 09:34 PM Please respond to u2-users To: u2-users@listserver.u2ug.org cc: Subject:Re: [U2] UniSubroutine question You want a subroutine to return a SQL compliant dataset? On Wed, Jun 11, 2008 at 8:05 AM, <[EMAIL PROTECTED]> wrote: > I am working on accessing Unidata from PHP. Installed the PHP Java Bridge > on Linux and have simple validation routines working. Ready to start > acquiring datasets from the Unidata server. Based on past discussions I > plan to write UniBasic subroutines for the bulk of the work. The > Uniobjects for Java Developer's Guide describes how to make the call from > Java usingUniSubroutine objects and how to get the result. I have a > question. > > What is the syntax in the UniBasic subroutine to return a dataset? > > Charles Shaffer > Senior Analyst > NTN-Bower Corporation > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > -- -Kevin http://www.PrecisOnline.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This email was Anti Virus checked by Astaro Security Gateway. http://www.astaro.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG. Version: 8.0.100 / Virus Database: 270.3.0/1498 - Release Date: 6/11/2008 7:13 PM --- 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] UniSubroutine question
When you say 'get your databasic to retutn XML' -- do you mean you've coded your XML in the databasic by hand, or do you use the XMLDB tools and UniBASIC XML extensions from IBM? Just curious how you do the process!! It's an area we're doing more and more of > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen > Sent: Thursday, June 12, 2008 10:23 AM > To: u2-users@listserver.u2ug.org > Cc: [EMAIL PROTECTED] > Subject: RE: [U2] UniSubroutine question > > In UO.NET I get my databasic to return xml - that way I can > bind it to most any control. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniSubroutine question
In UO.NET I get my databasic to return xml - that way I can bind it to most any control. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 12 June 2008 13:52 To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED]; u2-users@listserver.u2ug.org Subject: Re: [U2] UniSubroutine question A SQL compliant dataset would be OK.. A dynamic array would be OK. I have a routine returning one record in a dynamic array, but it comes into the UOJ code as a string. I guess I am looking for the best way to move multiple Unidata records in one bunch to UOJ code on the web server for further processing. Since I have never done it, I am looking for a best practice. . Charles Shaffer Senior Analyst NTN-Bower Corporation "Kevin King" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/11/2008 09:34 PM Please respond to u2-users To: u2-users@listserver.u2ug.org cc: Subject:Re: [U2] UniSubroutine question You want a subroutine to return a SQL compliant dataset? On Wed, Jun 11, 2008 at 8:05 AM, <[EMAIL PROTECTED]> wrote: > I am working on accessing Unidata from PHP. Installed the PHP Java Bridge > on Linux and have simple validation routines working. Ready to start > acquiring datasets from the Unidata server. Based on past discussions I > plan to write UniBasic subroutines for the bulk of the work. The > Uniobjects for Java Developer's Guide describes how to make the call from > Java usingUniSubroutine objects and how to get the result. I have a > question. > > What is the syntax in the UniBasic subroutine to return a dataset? > > Charles Shaffer > Senior Analyst > NTN-Bower Corporation > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > -- -Kevin http://www.PrecisOnline.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This email was Anti Virus checked by Astaro Security Gateway. http://www.astaro.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG. Version: 8.0.100 / Virus Database: 270.3.0/1498 - Release Date: 6/11/2008 7:13 PM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniSubroutine question
A SQL compliant dataset would be OK.. A dynamic array would be OK. I have a routine returning one record in a dynamic array, but it comes into the UOJ code as a string. I guess I am looking for the best way to move multiple Unidata records in one bunch to UOJ code on the web server for further processing. Since I have never done it, I am looking for a best practice. . Charles Shaffer Senior Analyst NTN-Bower Corporation "Kevin King" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/11/2008 09:34 PM Please respond to u2-users To: u2-users@listserver.u2ug.org cc: Subject:Re: [U2] UniSubroutine question You want a subroutine to return a SQL compliant dataset? On Wed, Jun 11, 2008 at 8:05 AM, <[EMAIL PROTECTED]> wrote: > I am working on accessing Unidata from PHP. Installed the PHP Java Bridge > on Linux and have simple validation routines working. Ready to start > acquiring datasets from the Unidata server. Based on past discussions I > plan to write UniBasic subroutines for the bulk of the work. The > Uniobjects for Java Developer's Guide describes how to make the call from > Java usingUniSubroutine objects and how to get the result. I have a > question. > > What is the syntax in the UniBasic subroutine to return a dataset? > > Charles Shaffer > Senior Analyst > NTN-Bower Corporation > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > -- -Kevin http://www.PrecisOnline.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This email was Anti Virus checked by Astaro Security Gateway. http://www.astaro.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] File pointer question
Is it possible some other program has the file open in the other directory and its sharing the file handle? Either a COMMON issue or the rotating file pool? David -- From: "T Stokes" <[EMAIL PROTECTED]> Sent: Wednesday, June 11, 2008 11:21 PM To: Subject: [U2] File pointer question I have a file that is a F pointer in the VOC yet when a BASIC STATUS is ran on the file it points to a file in another account. Have not been able to locate the reason for this. I am sure it is something simple. The VOC entry look like this F FILENAME D_FILENAME The results from STATUS looks like this D:\directory other than the directory I am current located\FILENAME -- View this message in context: http://www.nabble.com/File-pointer-question-tp17788496p17788496.html 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] File pointer question
Another possibility is that You opened the file in the other directory and then LOGTO'ed the current. Especially watch out for file pointers kept in common - if You use them the open and logto may have been done outside the current program. -- mats Jeff Fitzgerald skrev: If you are on a UNIX system the file may be a symbolic link to a file in another account. If this is the case, it is a really bad idea in my opinion. (1) It is very confusing! (2) It can cause problems, especially on UniVerse, when the file is resized. If you find the file is a symbolic link it would probably be worth your while to get rid of the link and modify the F pointer to point to the real location. HTH Jeff Fitzgerald Fitzgerald & Long, Inc. www.fitzlong.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of T Stokes Sent: Wednesday, June 11, 2008 4:22 PM To: u2-users@listserver.u2ug.org Subject: [U2] File pointer question I have a file that is a F pointer in the VOC yet when a BASIC STATUS is ran on the file it points to a file in another account. Have not been able to locate the reason for this. I am sure it is something simple. The VOC entry look like this F FILENAME D_FILENAME The results from STATUS looks like this D:\directory other than the directory I am current located\FILENAME --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/