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: 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 -- 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] 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] 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
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] 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
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
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] 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 RD 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] 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] 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/
[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] 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/
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] 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/
