Re: [U2] Help needed..
Hi, Personally, I would use OPENSEQ and READSEQ. Each READSEQ would read the next field in the record. The file needs to be a type 1 or type 19 for OPENSEQ. An example of this is: OPENSEQ FILE.NAME2, KEY.TXT TO SOURCE.FN ELSE STOP 'Unable to open ':KEY.TXT LOOP READSEQ ROW FROM SOURCE.FN ELSE EXIT ROW=CONVERT(CHAR(9),ATFM,ROW) WRITE ROW TO F.XXX,KEY REPEAT If the file isn't a type 1 or 19 then use the REMOVE function on the internal array. It is very fast. An example is: READ TXT.REC FROM F., KEY.TXT TXT.REC=TXT.REC LOOP REMOVE ROW FROM TXT.REC SETTING POS UNTIL ROW='' AND POS=0 ROW=CONVERT(CHAR(9),ATFM,ROW) WRITE ROW TO F.XXX,KEY REPEAT If you need to reprocess the array then add TXT.REC=TXT.REC and start the process again. The reason is that assigning the array to itself will reset the internal pointer REMOVE uses to keep track of where it is. One caveat, REMOVE goes to the next delimiter (field, value, subvalue or text mark) so you need to know the data you are working with. Tom RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya Sent: Tuesday, May 07, 2013 12:36 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Help needed.. Wjhonson wjhonson at aol.com writes: That's interesting John, but the del *does* in fact *shift* the entire array forward each time. It really does :) You can traverse without re-scanning by using the SELECT or SELECTV to transform the entire contents *once* into a type of Get List (it works try it!) You can then use a READNEXT to extract each row, without the need to rescan from the beginning, since READNEXT has always maintainted a pointer to where it left off. It doesn't start at the front each time. Hi I just used OSOPEN to open the file and the file is not getting recognized. Here is the piece of script I have used. OSOPEN FILE.NAME2 TO F.KEYFILE ELSE STOP CAN Not find file Where FILE.NAME2 is the path and the file name. Also as suggested below, how could I use get list for a file which is opened from server. Thanks in Advance, Sathya V. -Original Message- From: Israel, John R. JohnIsrael at daytonsuperior.com To: 'U2 Users List' u2-users at listserver.u2ug.org Sent: Tue, Apr 30, 2013 9:27 am Subject: Re: [U2] Help needed.. Here is some fast and loose code that I often use. READ TXT.REC FROM F., KEY.TXT LOOP ROW = TXT1 WHILE ROW # DEL TXT1 ;* Make the TXT file smaller and smaller and not traversing deeper and deeper CONVERT CHAR(9) TO at FM IN ROW KEY = ROW1;* extract the key out of the row DEL ROW1 ;* Remove the key from the row - all that is left is the record WRITE ROW ON F.XXX, KEY REPEAT JRI -Original Message- From: u2-users-bounces at listserver.u2ug.org [mailto:u2-users-bounces at listserver.u2ug.org] On Behalf Of Sathya Sent: Tuesday, April 30, 2013 11:21 AM To: u2-users at listserver.u2ug.org Subject: [U2] Help needed.. Hi all,.. I have a requirement here. Need guidance in doing that. Any help will be useful. TIA. I have a flat file with tab delimited records and the file looks like below: abcd 1234 cdef 3478 ghae 6284 ... I have to fetch the data 'abcd' and 'cdef' from this flat file and fetch some corresponding attributes from a file which has 'abcd' and 'cdef' as the key values. Please let me know if this could be done. If yes any kinda basic suggestions in doing that will be helpful. Thanks again, Sathya V. ___ U2-Users mailing list U2-Users at listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users at listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users at listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help needed..
Note that if the file was built in Windows, it may have a CR:LF combination at the end of each line. Reading it in, PICK will cleanly distinguish one as a line delimiter, but you will still have the extra (unwanted) character at the end of ROW. I forget which one is which, but any time you read in a row from a TXT file, you will want to convert the unwanted character (I believe it is a CHAR(13)). JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore Sent: Tuesday, May 07, 2013 7:46 AM To: U2 Users List Subject: Re: [U2] Help needed.. Hi, Personally, I would use OPENSEQ and READSEQ. Each READSEQ would read the next field in the record. The file needs to be a type 1 or type 19 for OPENSEQ. An example of this is: OPENSEQ FILE.NAME2, KEY.TXT TO SOURCE.FN ELSE STOP 'Unable to open ':KEY.TXT LOOP READSEQ ROW FROM SOURCE.FN ELSE EXIT ROW=CONVERT(CHAR(9),ATFM,ROW) WRITE ROW TO F.XXX,KEY REPEAT If the file isn't a type 1 or 19 then use the REMOVE function on the internal array. It is very fast. An example is: READ TXT.REC FROM F., KEY.TXT TXT.REC=TXT.REC LOOP REMOVE ROW FROM TXT.REC SETTING POS UNTIL ROW='' AND POS=0 ROW=CONVERT(CHAR(9),ATFM,ROW) WRITE ROW TO F.XXX,KEY REPEAT If you need to reprocess the array then add TXT.REC=TXT.REC and start the process again. The reason is that assigning the array to itself will reset the internal pointer REMOVE uses to keep track of where it is. One caveat, REMOVE goes to the next delimiter (field, value, subvalue or text mark) so you need to know the data you are working with. Tom RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya Sent: Tuesday, May 07, 2013 12:36 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Help needed.. Wjhonson wjhonson at aol.com writes: That's interesting John, but the del *does* in fact *shift* the entire array forward each time. It really does :) You can traverse without re-scanning by using the SELECT or SELECTV to transform the entire contents *once* into a type of Get List (it works try it!) You can then use a READNEXT to extract each row, without the need to rescan from the beginning, since READNEXT has always maintainted a pointer to where it left off. It doesn't start at the front each time. Hi I just used OSOPEN to open the file and the file is not getting recognized. Here is the piece of script I have used. OSOPEN FILE.NAME2 TO F.KEYFILE ELSE STOP CAN Not find file Where FILE.NAME2 is the path and the file name. Also as suggested below, how could I use get list for a file which is opened from server. Thanks in Advance, Sathya V. -Original Message- From: Israel, John R. JohnIsrael at daytonsuperior.com To: 'U2 Users List' u2-users at listserver.u2ug.org Sent: Tue, Apr 30, 2013 9:27 am Subject: Re: [U2] Help needed.. Here is some fast and loose code that I often use. READ TXT.REC FROM F., KEY.TXT LOOP ROW = TXT1 WHILE ROW # DEL TXT1 ;* Make the TXT file smaller and smaller and not traversing deeper and deeper CONVERT CHAR(9) TO at FM IN ROW KEY = ROW1;* extract the key out of the row DEL ROW1 ;* Remove the key from the row - all that is left is the record WRITE ROW ON F.XXX, KEY REPEAT JRI -Original Message- From: u2-users-bounces at listserver.u2ug.org [mailto:u2-users-bounces at listserver.u2ug.org] On Behalf Of Sathya Sent: Tuesday, April 30, 2013 11:21 AM To: u2-users at listserver.u2ug.org Subject: [U2] Help needed.. Hi all,.. I have a requirement here. Need guidance in doing that. Any help will be useful. TIA. I have a flat file with tab delimited records and the file looks like below: abcd 1234 cdef 3478 ghae 6284 ... I have to fetch the data 'abcd' and 'cdef' from this flat file and fetch some corresponding attributes from a file which has 'abcd' and 'cdef' as the key values. Please let me know if this could be done. If yes any kinda basic suggestions in doing that will be helpful. Thanks again, Sathya V. ___ U2-Users mailing list U2-Users at listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users at listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users at listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help needed..
I don't think you should be using OSOPEN. This is for block IO. Aren't you reading a sequential file one line a t a time? *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Tue, May 7, 2013 at 7:54 AM, Israel, John R. johnisr...@daytonsuperior.com wrote: Note that if the file was built in Windows, it may have a CR:LF combination at the end of each line. Reading it in, PICK will cleanly distinguish one as a line delimiter, but you will still have the extra (unwanted) character at the end of ROW. I forget which one is which, but any time you read in a row from a TXT file, you will want to convert the unwanted character (I believe it is a CHAR(13)). JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore Sent: Tuesday, May 07, 2013 7:46 AM To: U2 Users List Subject: Re: [U2] Help needed.. Hi, Personally, I would use OPENSEQ and READSEQ. Each READSEQ would read the next field in the record. The file needs to be a type 1 or type 19 for OPENSEQ. An example of this is: OPENSEQ FILE.NAME2, KEY.TXT TO SOURCE.FN ELSE STOP 'Unable to open ':KEY.TXT LOOP READSEQ ROW FROM SOURCE.FN ELSE EXIT ROW=CONVERT(CHAR(9),ATFM,ROW) WRITE ROW TO F.XXX,KEY REPEAT If the file isn't a type 1 or 19 then use the REMOVE function on the internal array. It is very fast. An example is: READ TXT.REC FROM F., KEY.TXT TXT.REC=TXT.REC LOOP REMOVE ROW FROM TXT.REC SETTING POS UNTIL ROW='' AND POS=0 ROW=CONVERT(CHAR(9),ATFM,ROW) WRITE ROW TO F.XXX,KEY REPEAT If you need to reprocess the array then add TXT.REC=TXT.REC and start the process again. The reason is that assigning the array to itself will reset the internal pointer REMOVE uses to keep track of where it is. One caveat, REMOVE goes to the next delimiter (field, value, subvalue or text mark) so you need to know the data you are working with. Tom RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya Sent: Tuesday, May 07, 2013 12:36 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Help needed.. Wjhonson wjhonson at aol.com writes: That's interesting John, but the del *does* in fact *shift* the entire array forward each time. It really does :) You can traverse without re-scanning by using the SELECT or SELECTV to transform the entire contents *once* into a type of Get List (it works try it!) You can then use a READNEXT to extract each row, without the need to rescan from the beginning, since READNEXT has always maintainted a pointer to where it left off. It doesn't start at the front each time. Hi I just used OSOPEN to open the file and the file is not getting recognized. Here is the piece of script I have used. OSOPEN FILE.NAME2 TO F.KEYFILE ELSE STOP CAN Not find file Where FILE.NAME2 is the path and the file name. Also as suggested below, how could I use get list for a file which is opened from server. Thanks in Advance, Sathya V. -Original Message- From: Israel, John R. JohnIsrael at daytonsuperior.com To: 'U2 Users List' u2-users at listserver.u2ug.org Sent: Tue, Apr 30, 2013 9:27 am Subject: Re: [U2] Help needed.. Here is some fast and loose code that I often use. READ TXT.REC FROM F., KEY.TXT LOOP ROW = TXT1 WHILE ROW # DEL TXT1 ;* Make the TXT file smaller and smaller and not traversing deeper and deeper CONVERT CHAR(9) TO at FM IN ROW KEY = ROW1;* extract the key out of the row DEL ROW1 ;* Remove the key from the row - all that is left is the record WRITE ROW ON F.XXX, KEY REPEAT JRI -Original Message- From: u2-users-bounces at listserver.u2ug.org [mailto:u2-users-bounces at listserver.u2ug.org] On Behalf Of Sathya Sent: Tuesday, April 30, 2013 11:21 AM To: u2-users at listserver.u2ug.org Subject: [U2] Help needed.. Hi all,.. I have a requirement here. Need guidance in doing that. Any help will be useful. TIA. I have a flat file with tab delimited records and the file looks like below: abcd 1234 cdef 3478 ghae 6284 ... I have to fetch the data 'abcd' and 'cdef' from this flat file and fetch some corresponding attributes from a file which has 'abcd' and 'cdef' as the key values. Please let me know if this could be done. If yes any kinda basic suggestions in doing that will be helpful. Thanks again, Sathya V. ___ U2-Users mailing list U2-Users at listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users
Re: [U2] Help needed..
I believe this problem might exist if you are reading a Windows file with a Unix-based version of U2. However, I can read Windows files with a Windows-based version of Universe without the need to convert any line endings -Original Message- From: Israel, John R. johnisr...@daytonsuperior.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, May 7, 2013 4:55 am Subject: Re: [U2] Help needed.. Note that if the file was built in Windows, it may have a CR:LF combination at the end of each line. Reading it in, PICK will cleanly distinguish one as a line delimiter, but you will still have the extra (unwanted) character at the end of ROW. I forget which one is which, but any time you read in a row from a TXT file, you will want to convert the unwanted character (I believe it is a CHAR(13)). JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore Sent: Tuesday, May 07, 2013 7:46 AM To: U2 Users List Subject: Re: [U2] Help needed.. Hi, Personally, I would use OPENSEQ and READSEQ. Each READSEQ would read the next field in the record. The file needs to be a type 1 or type 19 for OPENSEQ. An example of this is: OPENSEQ FILE.NAME2, KEY.TXT TO SOURCE.FN ELSE STOP 'Unable to open ':KEY.TXT LOOP READSEQ ROW FROM SOURCE.FN ELSE EXIT ROW=CONVERT(CHAR(9),ATFM,ROW) WRITE ROW TO F.XXX,KEY REPEAT If the file isn't a type 1 or 19 then use the REMOVE function on the internal array. It is very fast. An example is: READ TXT.REC FROM F., KEY.TXT TXT.REC=TXT.REC LOOP REMOVE ROW FROM TXT.REC SETTING POS UNTIL ROW='' AND POS=0 ROW=CONVERT(CHAR(9),ATFM,ROW) WRITE ROW TO F.XXX,KEY REPEAT If you need to reprocess the array then add TXT.REC=TXT.REC and start the process again. The reason is that assigning the array to itself will reset the internal pointer REMOVE uses to keep track of where it is. One caveat, REMOVE goes to the next delimiter (field, value, subvalue or text mark) so you need to know the data you are working with. Tom RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya Sent: Tuesday, May 07, 2013 12:36 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Help needed.. Wjhonson wjhonson at aol.com writes: That's interesting John, but the del *does* in fact *shift* the entire array forward each time. It really does :) You can traverse without re-scanning by using the SELECT or SELECTV to transform the entire contents *once* into a type of Get List (it works try it!) You can then use a READNEXT to extract each row, without the need to rescan from the beginning, since READNEXT has always maintainted a pointer to where it left off. It doesn't start at the front each time. Hi I just used OSOPEN to open the file and the file is not getting recognized. Here is the piece of script I have used. OSOPEN FILE.NAME2 TO F.KEYFILE ELSE STOP CAN Not find file Where FILE.NAME2 is the path and the file name. Also as suggested below, how could I use get list for a file which is opened from server. Thanks in Advance, Sathya V. -Original Message- From: Israel, John R. JohnIsrael at daytonsuperior.com To: 'U2 Users List' u2-users at listserver.u2ug.org Sent: Tue, Apr 30, 2013 9:27 am Subject: Re: [U2] Help needed.. Here is some fast and loose code that I often use. READ TXT.REC FROM F., KEY.TXT LOOP ROW = TXT1 WHILE ROW # DEL TXT1 ;* Make the TXT file smaller and smaller and not traversing deeper and deeper CONVERT CHAR(9) TO at FM IN ROW KEY = ROW1;* extract the key out of the row DEL ROW1 ;* Remove the key from the row - all that is left is the record WRITE ROW ON F.XXX, KEY REPEAT JRI -Original Message- From: u2-users-bounces at listserver.u2ug.org [mailto:u2-users-bounces at listserver.u2ug.org] On Behalf Of Sathya Sent: Tuesday, April 30, 2013 11:21 AM To: u2-users at listserver.u2ug.org Subject: [U2] Help needed.. Hi all,.. I have a requirement here. Need guidance in doing that. Any help will be useful. TIA. I have a flat file with tab delimited records and the file looks like below: abcd 1234 cdef 3478 ghae 6284 ... I have to fetch the data 'abcd' and 'cdef' from this flat file and fetch some corresponding attributes from a file which has 'abcd' and 'cdef' as the key values. Please let me know if this could be done. If yes any kinda basic suggestions in doing that will be helpful. Thanks again, Sathya V. ___ U2-Users mailing list U2-Users at listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users
Re: [U2] Help needed..
Wjhonson wjhonson at aol.com writes: That's interesting John, but the del *does* in fact *shift* the entire array forward each time. It really does :) You can traverse without re-scanning by using the SELECT or SELECTV to transform the entire contents *once* into a type of Get List (it works try it!) You can then use a READNEXT to extract each row, without the need to rescan from the beginning, since READNEXT has always maintainted a pointer to where it left off. It doesn't start at the front each time. Hi I just used OSOPEN to open the file and the file is not getting recognized. Here is the piece of script I have used. OSOPEN FILE.NAME2 TO F.KEYFILE ELSE STOP CAN Not find file Where FILE.NAME2 is the path and the file name. Also as suggested below, how could I use get list for a file which is opened from server. Thanks in Advance, Sathya V. -Original Message- From: Israel, John R. JohnIsrael at daytonsuperior.com To: 'U2 Users List' u2-users at listserver.u2ug.org Sent: Tue, Apr 30, 2013 9:27 am Subject: Re: [U2] Help needed.. Here is some fast and loose code that I often use. READ TXT.REC FROM F., KEY.TXT LOOP ROW = TXT1 WHILE ROW # DEL TXT1 ;* Make the TXT file smaller and smaller and not traversing deeper and deeper CONVERT CHAR(9) TO at FM IN ROW KEY = ROW1;* extract the key out of the row DEL ROW1 ;* Remove the key from the row - all that is left is the record WRITE ROW ON F.XXX, KEY REPEAT JRI -Original Message- From: u2-users-bounces at listserver.u2ug.org [mailto:u2-users-bounces at listserver.u2ug.org] On Behalf Of Sathya Sent: Tuesday, April 30, 2013 11:21 AM To: u2-users at listserver.u2ug.org Subject: [U2] Help needed.. Hi all,.. I have a requirement here. Need guidance in doing that. Any help will be useful. TIA. I have a flat file with tab delimited records and the file looks like below: abcd 1234 cdef 3478 ghae 6284 ... I have to fetch the data 'abcd' and 'cdef' from this flat file and fetch some corresponding attributes from a file which has 'abcd' and 'cdef' as the key values. Please let me know if this could be done. If yes any kinda basic suggestions in doing that will be helpful. Thanks again, Sathya V. ___ U2-Users mailing list U2-Users at listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users at listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users at listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help needed..
On 4/30/2013 11:21 AM, Sathya wrote: Hi all,.. I have a requirement here. Need guidance in doing that. Any help will be useful. TIA. I have a flat file with tab delimited records and the file looks like below: abcd 1234 cdef 3478 ghae 6284 ... I have to fetch the data 'abcd' and 'cdef' from this flat file and fetch some corresponding attributes from a file which has 'abcd' and 'cdef' as the key values. Please let me know if this could be done. If yes any kinda basic suggestions in doing that will be helpful. Lots of ways to solve this problem, here's a very quick and dirty untested piece of code written off the top of my head... PROMPT EQUATE TABCHAR TO CHAR(7) * OPEN , UFD TO F.UFD ELSE STOP CAN'T OPEN UFD READ D.UFD FROM F.UFD, xxx.tabdelimitedname ELSE CRT Can't read tab-delimited file from current directory STOP END OPEN , OTHERFILE TO F.OTHER ELSE CRT Can't open OTHERFILE file to retrieve data from STOP END REM1 = 999 LOOP WHILE REM1 NE 0 REMOVE LINE FROM D.UFD SETTING REM1 K.OTHER = FIELD(LINE, TABCHAR, 1) READ D.OTHER FROM F.OTHER, K.OTHER THEN ONE = D.OTHER1 TWO = D.OTHER2 do something with the fields... END ELSE CRT Cant' read record : K.OTHER: from OTHERFILE. END REPEAT * CRT DONE STOP -- Allen Egerton; aeger...@pobox.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help needed..
OPENPATH directory-of-tab-delimited-file TO F.PATH ELSE STOP Can not find directory OPEN ,Name-of-file-with-keys TO F.KEYFILE ELSE STOP CAN Not find file * READ XDATA FROM F.PATH,flat-file-name ELSE STOP Can not find flat filename MAXLINES=DCOUNT(XDATA,CHAR(254)) FOR T=1 TO MAXLINES LIN=XDATAT KEYVALUE=FIELD(LIN,CHAR(9),1) VALUE=FIELD(LIN,CHAR(9),2) READ VDATA FROM F.KEYFILE,KEYVALUE ELSE PRINT KEYVALUE: Not in Key File ; CONTINUE * * could also read: * READ VDATA FROM F.KEYFILE,KEYVALUE ELSE Insert code here as to what to do if the KEYVALUE does not exist in the FILE on the system END * * ... ... Insert code here as to what to do with the VALUES in the FILE on the system, and what To do with the VALUE in the flatfile ... ... NEXT T * ... ... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya Sent: Tuesday, April 30, 2013 11:21 AM To: u2-users@listserver.u2ug.org Subject: [U2] Help needed.. Hi all,.. I have a requirement here. Need guidance in doing that. Any help will be useful. TIA. I have a flat file with tab delimited records and the file looks like below: abcd 1234 cdef 3478 ghae 6284 ... I have to fetch the data 'abcd' and 'cdef' from this flat file and fetch some corresponding attributes from a file which has 'abcd' and 'cdef' as the key values. Please let me know if this could be done. If yes any kinda basic suggestions in doing that will be helpful. Thanks again, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help needed..
I never used UFD before - I like that one. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen Egerton Sent: Tuesday, April 30, 2013 11:57 AM To: U2 Users List Subject: Re: [U2] Help needed.. OPEN , UFD TO F.UFD ELSE STOP CAN'T OPEN UFD READ D.UFD FROM F.UFD, xxx.tabdelimitedname ELSE CRT Can't read tab-delimited file from current directory STOP END OPEN , OTHERFILE TO F.OTHER ELSE CRT Can't open OTHERFILE file to retrieve data from STOP END REM1 = 999 LOOP WHILE REM1 NE 0 REMOVE LINE FROM D.UFD SETTING REM1 K.OTHER = FIELD(LINE, TABCHAR, 1) READ D.OTHER FROM F.OTHER, K.OTHER THEN ONE = D.OTHER1 TWO = D.OTHER2 do something with the fields... END ELSE CRT Cant' read record : K.OTHER: from OTHERFILE. END REPEAT * CRT DONE STOP -- Allen Egerton; aeger...@pobox.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help needed..
Here is some fast and loose code that I often use. READ TXT.REC FROM F., KEY.TXT LOOP ROW = TXT1 WHILE ROW # DEL TXT1 ;* Make the TXT file smaller and smaller and not traversing deeper and deeper CONVERT CHAR(9) TO @FM IN ROW KEY = ROW1;* extract the key out of the row DEL ROW1 ;* Remove the key from the row - all that is left is the record WRITE ROW ON F.XXX, KEY REPEAT JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya Sent: Tuesday, April 30, 2013 11:21 AM To: u2-users@listserver.u2ug.org Subject: [U2] Help needed.. Hi all,.. I have a requirement here. Need guidance in doing that. Any help will be useful. TIA. I have a flat file with tab delimited records and the file looks like below: abcd 1234 cdef 3478 ghae 6284 ... I have to fetch the data 'abcd' and 'cdef' from this flat file and fetch some corresponding attributes from a file which has 'abcd' and 'cdef' as the key values. Please let me know if this could be done. If yes any kinda basic suggestions in doing that will be helpful. Thanks again, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help needed..
Hi, For fun : EXECUTE QSELECT UFD tabdelimitedname LOOP WHILE READNEXT LINE DO K = FIELD(LINE, ,1) ... REPEAT manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Allen Egerton Envoyé : mardi 30 avril 2013 17:57 À : U2 Users List Objet : Re: [U2] Help needed.. On 4/30/2013 11:21 AM, Sathya wrote: Hi all,.. I have a requirement here. Need guidance in doing that. Any help will be useful. TIA. I have a flat file with tab delimited records and the file looks like below: abcd 1234 cdef 3478 ghae 6284 ... I have to fetch the data 'abcd' and 'cdef' from this flat file and fetch some corresponding attributes from a file which has 'abcd' and 'cdef' as the key values. Please let me know if this could be done. If yes any kinda basic suggestions in doing that will be helpful. Lots of ways to solve this problem, here's a very quick and dirty untested piece of code written off the top of my head... PROMPT EQUATE TABCHAR TO CHAR(7) * OPEN , UFD TO F.UFD ELSE STOP CAN'T OPEN UFD READ D.UFD FROM F.UFD, xxx.tabdelimitedname ELSE CRT Can't read tab- delimited file from current directory STOP END OPEN , OTHERFILE TO F.OTHER ELSE CRT Can't open OTHERFILE file to retrieve data from STOP END REM1 = 999 LOOP WHILE REM1 NE 0 REMOVE LINE FROM D.UFD SETTING REM1 K.OTHER = FIELD(LINE, TABCHAR, 1) READ D.OTHER FROM F.OTHER, K.OTHER THEN ONE = D.OTHER1 TWO = D.OTHER2 do something with the fields... END ELSE CRT Cant' read record : K.OTHER: from OTHERFILE. END REPEAT * CRT DONE STOP -- Allen Egerton; aeger...@pobox.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help needed..
That's interesting John, but the del *does* in fact *shift* the entire array forward each time. It really does :) You can traverse without re-scanning by using the SELECT or SELECTV to transform the entire contents *once* into a type of Get List (it works try it!) You can then use a READNEXT to extract each row, without the need to rescan from the beginning, since READNEXT has always maintainted a pointer to where it left off. It doesn't start at the front each time. -Original Message- From: Israel, John R. johnisr...@daytonsuperior.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Tue, Apr 30, 2013 9:27 am Subject: Re: [U2] Help needed.. Here is some fast and loose code that I often use. READ TXT.REC FROM F., KEY.TXT LOOP ROW = TXT1 WHILE ROW # DEL TXT1 ;* Make the TXT file smaller and smaller and not traversing deeper and deeper CONVERT CHAR(9) TO @FM IN ROW KEY = ROW1;* extract the key out of the row DEL ROW1 ;* Remove the key from the row - all that is left is the record WRITE ROW ON F.XXX, KEY REPEAT JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya Sent: Tuesday, April 30, 2013 11:21 AM To: u2-users@listserver.u2ug.org Subject: [U2] Help needed.. Hi all,.. I have a requirement here. Need guidance in doing that. Any help will be useful. TIA. I have a flat file with tab delimited records and the file looks like below: abcd 1234 cdef 3478 ghae 6284 ... I have to fetch the data 'abcd' and 'cdef' from this flat file and fetch some corresponding attributes from a file which has 'abcd' and 'cdef' as the key values. Please let me know if this could be done. If yes any kinda basic suggestions in doing that will be helpful. Thanks again, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help needed..
Yes, I understand it shifts everything, but you are not traversing deeper with each loop. You are only going 1 deep every time. Old school. :-) John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 30, 2013 12:48 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Help needed.. That's interesting John, but the del *does* in fact *shift* the entire array forward each time. It really does :) You can traverse without re-scanning by using the SELECT or SELECTV to transform the entire contents *once* into a type of Get List (it works try it!) You can then use a READNEXT to extract each row, without the need to rescan from the beginning, since READNEXT has always maintainted a pointer to where it left off. It doesn't start at the front each time. -Original Message- From: Israel, John R. johnisr...@daytonsuperior.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Tue, Apr 30, 2013 9:27 am Subject: Re: [U2] Help needed.. Here is some fast and loose code that I often use. READ TXT.REC FROM F., KEY.TXT LOOP ROW = TXT1 WHILE ROW # DEL TXT1 ;* Make the TXT file smaller and smaller and not traversing deeper and deeper CONVERT CHAR(9) TO @FM IN ROW KEY = ROW1;* extract the key out of the row DEL ROW1 ;* Remove the key from the row - all that is left is the record WRITE ROW ON F.XXX, KEY REPEAT JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya Sent: Tuesday, April 30, 2013 11:21 AM To: u2-users@listserver.u2ug.org Subject: [U2] Help needed.. Hi all,.. I have a requirement here. Need guidance in doing that. Any help will be useful. TIA. I have a flat file with tab delimited records and the file looks like below: abcd 1234 cdef 3478 ghae 6284 ... I have to fetch the data 'abcd' and 'cdef' from this flat file and fetch some corresponding attributes from a file which has 'abcd' and 'cdef' as the key values. Please let me know if this could be done. If yes any kinda basic suggestions in doing that will be helpful. Thanks again, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help needed..
But the shifting is more expensive than the traversing :) -Original Message- From: Israel, John R. johnisr...@daytonsuperior.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Tue, Apr 30, 2013 10:02 am Subject: Re: [U2] Help needed.. Yes, I understand it shifts everything, but you are not traversing deeper with each loop. You are only going 1 deep every time. Old school. :-) John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, April 30, 2013 12:48 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Help needed.. That's interesting John, but the del *does* in fact *shift* the entire array forward each time. It really does :) You can traverse without re-scanning by using the SELECT or SELECTV to transform the entire contents *once* into a type of Get List (it works try it!) You can then use a READNEXT to extract each row, without the need to rescan from the beginning, since READNEXT has always maintainted a pointer to where it left off. It doesn't start at the front each time. -Original Message- From: Israel, John R. johnisr...@daytonsuperior.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Tue, Apr 30, 2013 9:27 am Subject: Re: [U2] Help needed.. Here is some fast and loose code that I often use. READ TXT.REC FROM F., KEY.TXT LOOP ROW = TXT1 WHILE ROW # DEL TXT1 ;* Make the TXT file smaller and smaller and not traversing deeper and deeper CONVERT CHAR(9) TO @FM IN ROW KEY = ROW1;* extract the key out of the row DEL ROW1 ;* Remove the key from the row - all that is left is the record WRITE ROW ON F.XXX, KEY REPEAT JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Sathya Sent: Tuesday, April 30, 2013 11:21 AM To: u2-users@listserver.u2ug.org Subject: [U2] Help needed.. Hi all,.. I have a requirement here. Need guidance in doing that. Any help will be useful. TIA. I have a flat file with tab delimited records and the file looks like below: abcd 1234 cdef 3478 ghae 6284 ... I have to fetch the data 'abcd' and 'cdef' from this flat file and fetch some corresponding attributes from a file which has 'abcd' and 'cdef' as the key values. Please let me know if this could be done. If yes any kinda basic suggestions in doing that will be helpful. Thanks again, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help with REVISE (AKA ENTRO/ENTROC)
Hi Clif Why are you using REVISE? It's HORRIBLE .. grin If you want a free, command-line field-driven screen update processor, download ENTER from my website .. highly configurable and functional. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: 24 January 2013 05:35 To: U2 Users List Subject: Re: [U2] Help with REVISE (AKA ENTRO/ENTROC) According to the UV11 System Description manual: --snip-- Inserts a new line item above the current line item. ReVise displays an explanation and prompts you to enter the new set of associated multivalues. #n Copies all associated multivalues of line item n and puts it above the current line item. --snip-- Perahps the double is causing the grief? This email and any attachments to it are confidential. You must not use, disclose or act on the email if you are not the intended recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help with REVISE (AKA ENTRO/ENTROC)
Thanks, Gregor. Yes. Single not double does it. The System Description was one place I forgot to check. I would have thought it would be in the Reference manual with the REVISE documentation. Silly me. I appreciate the assist. Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 225 341 1778Web: www.oliver.com On Jan 23, 2013, at 11:35 PM, Gregor Scott gregor.sc...@pentanasolutions.com wrote: According to the UV11 System Description manual: --snip-- Inserts a new line item above the current line item. ReVise displays an explanation and prompts you to enter the new set of associated multivalues. #n Copies all associated multivalues of line item n and puts it above the current line item. --snip-- Perahps the double is causing the grief? This email and any attachments to it are confidential. You must not use, disclose or act on the email if you are not the intended recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help with REVISE (AKA ENTRO/ENTROC)
I quite agree, Brian. It's horrible. But it's what I had available at time I started this particular assignment. And I'm required to use a client-issued laptop, at first without administrator rights. So installing anything at that time was not possible. But I'll D/L ENTER for my own machine and check it out. Thanks. Regards, Clif On Jan 24, 2013, at 4:51 AM, Brian Leach br...@brianleach.co.uk wrote: Hi Clif Why are you using REVISE? It's HORRIBLE .. grin If you want a free, command-line field-driven screen update processor, download ENTER from my website .. highly configurable and functional. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: 24 January 2013 05:35 To: U2 Users List Subject: Re: [U2] Help with REVISE (AKA ENTRO/ENTROC) According to the UV11 System Description manual: --snip-- Inserts a new line item above the current line item. ReVise displays an explanation and prompts you to enter the new set of associated multivalues. #n Copies all associated multivalues of line item n and puts it above the current line item. --snip-- Perahps the double is causing the grief? This email and any attachments to it are confidential. You must not use, disclose or act on the email if you are not the intended recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help with REVISE (AKA ENTRO/ENTROC)
According to the UV11 System Description manual: --snip-- Inserts a new line item above the current line item. ReVise displays an explanation and prompts you to enter the new set of associated multivalues. #n Copies all associated multivalues of line item n and puts it above the current line item. --snip-- Perahps the double is causing the grief? This email and any attachments to it are confidential. You must not use, disclose or act on the email if you are not the intended recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help in removing erroneous character from data file {Unclassified}
I can't help finding a certain delicious irony in seeing a UniVerse support request coming from someone who works for the former owner of the product. Gayathru, I expect that IBM India should still have some internal support people who know about UniVerse, or at least know where they've gone. Do you have a local Value Added Reseller or are you a direct support customer of Rocket Software? From your postings, it appears that you have a potentially badly corrupted file and are a little light on in-depth understanding of the platform. You also need to think about how did the bad data get there? The routine that puts the data into your UniVerse file may need amendment to better control the quality of the incoming data, if that is the seat of the problem. Just 'correcting' the apparently bad data may not solve the problem at all Good luck, I'm afraid you're going to need some Mike -Original Message- From: u2-users-boun...@listserver.u2ug.org On Behalf Of ggayat...@in.ibm.com Sent: Friday, 17 September 2010 8:39 p.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] Help in removing erroneous character from data file Another application had problem processing the file that it had pulled from my application with the data. In Line Number : 2506 a field(field comes from a UniVerse table) had a value of 11 and the application is looking for time (XX:XX:XX format) After this field all data is incorrect. Also, the line 2506 is unusually long. Gayathru Mecki Foerthmann wrote: More information would be helpful. On 17/09/2010 06:10, ggayathri wrote: I have a data file that is sent from my application(on UniVerse) to an interfacing application. In the huge amount of data, an erroneous character has been introduced. Can someone suggest a way to remove that character? May be a routine that would do it? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- View this message in context: http://old.nabble.com/Help-in-removing-erroneous-character-from-data-fil e-tp29735223p29736257.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help in removing erroneous character from data file
More information would be helpful. On 17/09/2010 06:10, ggayathri wrote: I have a data file that is sent from my application(on UniVerse) to an interfacing application. In the huge amount of data, an erroneous character has been introduced. Can someone suggest a way to remove that character? May be a routine that would do it? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help in removing erroneous character from data file
Another application had problem processing the file that it had pulled from my application with the data. In Line Number : 2506 a field(field comes from a UniVerse table) had a value of 11 and the application is looking for time (XX:XX:XX format) After this field all data is incorrect. Also, the line 2506 is unusually long. Gayathru Mecki Foerthmann wrote: More information would be helpful. On 17/09/2010 06:10, ggayathri wrote: I have a data file that is sent from my application(on UniVerse) to an interfacing application. In the huge amount of data, an erroneous character has been introduced. Can someone suggest a way to remove that character? May be a routine that would do it? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- View this message in context: http://old.nabble.com/Help-in-removing-erroneous-character-from-data-file-tp29735223p29736257.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help with encryption
Thanks SO MUCH! OCONV(RESULT,'MX0C') works like a charm, but ICONV(RESULT,'MY') had no effect (at least not in UD7.2, on Windows.) I would have never mananaged to arrive at that conversion on my own. I can't believe it's not just a matter of supplying some parameter in the DIGEST function itself. Oh well, that's the crazy world of programming I guess. Thanks again. andy baum-2 wrote: Using OCONV(RESULT,'MX0C') seems to work OK on Windows but I'm sure I had problems with this on UV 10.2 on hp-ux. However, ICONV(RESULT,'MY') worked on both. Cheers, Andy - Original Message From: m3p jr...@go.com To: u2-users@listserver.u2ug.org Sent: Tuesday, 11 August, 2009 20:36:25 Subject: Re: [U2] Help with encryption Hello all, The code below: RESULT = '' STATUS = DIGEST('MD5','THIS IS A TEST',1,RESULT) PRINT 'STATUS = ' : STATUS PRINT 'RESULT = ' : OCONV(RESULT,'MX') works fine, except... I keep getting binary data displayed, despite the OCONV(RESULT,'MX') Anyone have an idea how to turn the RESULT into a string of Hex characters? Replies are much appreciated, thanks. IT-Laure Hansen wrote: Does anyone know how to cause MD5 hashing in Universe? UV 10.2.3 on Win2003 server. I am hoping for a Basic command that I can run on a desired piece of data. Reading documentation so far hasn't helped, am I wanting to do something that is not available to me? Thanks in advance! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.orgmailto:lhan...@redwoodcity.org P Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribehttp://www.redwoodcity.org/eGov/login.aspx?ref=/egov/index .aspx --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- View this message in context: http://www.nabble.com/Help-with-encryption-tp23508833p24924344.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- View this message in context: http://www.nabble.com/Help-with-encryption-tp23508833p24937398.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help with encryption
Hello all, The code below: RESULT = '' STATUS = DIGEST('MD5','THIS IS A TEST',1,RESULT) PRINT 'STATUS = ' : STATUS PRINT 'RESULT = ' : OCONV(RESULT,'MX') works fine, except... I keep getting binary data displayed, despite the OCONV(RESULT,'MX') Anyone have an idea how to turn the RESULT into a string of Hex characters? Replies are much appreciated, thanks. IT-Laure Hansen wrote: Does anyone know how to cause MD5 hashing in Universe? UV 10.2.3 on Win2003 server. I am hoping for a Basic command that I can run on a desired piece of data. Reading documentation so far hasn't helped, am I wanting to do something that is not available to me? Thanks in advance! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.orgmailto:lhan...@redwoodcity.org P Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribehttp://www.redwoodcity.org/eGov/login.aspx?ref=/egov/index .aspx --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- View this message in context: http://www.nabble.com/Help-with-encryption-tp23508833p24924344.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help with encryption
Try MX0C. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of m3p Sent: Tuesday, August 11, 2009 12:36 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Help with encryption Hello all, The code below: RESULT = '' STATUS = DIGEST('MD5','THIS IS A TEST',1,RESULT) PRINT 'STATUS = ' : STATUS PRINT 'RESULT = ' : OCONV(RESULT,'MX') works fine, except... I keep getting binary data displayed, despite the OCONV(RESULT,'MX') Anyone have an idea how to turn the RESULT into a string of Hex characters? Replies are much appreciated, thanks. IT-Laure Hansen wrote: Does anyone know how to cause MD5 hashing in Universe? UV 10.2.3 on Win2003 server. I am hoping for a Basic command that I can run on a desired piece of data. Reading documentation so far hasn't helped, am I wanting to do something that is not available to me? Thanks in advance! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.orgmailto:lhan...@redwoodcity.org P Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribehttp://www.redwoodcity.org/eGov/login.aspx?ref=/egov/index .aspx --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- View this message in context: http://www.nabble.com/Help-with-encryption-tp23508833p24924344.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help with encryption
Actually, you need to parse character by character: NB.CS = LEN(HASHED.TEXT) NEW.TEXT = FOR THE.C = 1 TO NB.CS NEW.TEXT := OCONV(HASHED.TEXT[THE.C,1],MX0C) NEXT THE.C Where HASHED.TEXT is your encrypted string. Took me by surprise too! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.org Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribe -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Henry Unger Sent: Tuesday, August 11, 2009 12:38 PM To: 'U2 Users List' Subject: Re: [U2] Help with encryption Try MX0C. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of m3p Sent: Tuesday, August 11, 2009 12:36 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Help with encryption Hello all, The code below: RESULT = '' STATUS = DIGEST('MD5','THIS IS A TEST',1,RESULT) PRINT 'STATUS = ' : STATUS PRINT 'RESULT = ' : OCONV(RESULT,'MX') works fine, except... I keep getting binary data displayed, despite the OCONV(RESULT,'MX') Anyone have an idea how to turn the RESULT into a string of Hex characters? Replies are much appreciated, thanks. IT-Laure Hansen wrote: Does anyone know how to cause MD5 hashing in Universe? UV 10.2.3 on Win2003 server. I am hoping for a Basic command that I can run on a desired piece of data. Reading documentation so far hasn't helped, am I wanting to do something that is not available to me? Thanks in advance! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.orgmailto:lhan...@redwoodcity.org P Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribehttp://www.redwoodcity.org/eGov/login.aspx?ref=/egov/index .aspx --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- View this message in context: http://www.nabble.com/Help-with-encryption-tp23508833p24924344.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help with encryption
We run UD and have the following lines: RET = DIGEST(SHA1, VALUE, 1, SHA1.RESULT) VALUE = OCONV(SHA1.RESULT, HEX) IF VALUE = '' THEN VALUE = OCONV(SHA1.RESULT, MX) END Not sure if that helps you or not -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of IT-Laure Hansen Sent: Wednesday, 12 August 2009 5:44 AM To: U2 Users List Subject: Re: [U2] Help with encryption Actually, you need to parse character by character: NB.CS = LEN(HASHED.TEXT) NEW.TEXT = FOR THE.C = 1 TO NB.CS NEW.TEXT := OCONV(HASHED.TEXT[THE.C,1],MX0C) NEXT THE.C Where HASHED.TEXT is your encrypted string. Took me by surprise too! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.org Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribe -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Henry Unger Sent: Tuesday, August 11, 2009 12:38 PM To: 'U2 Users List' Subject: Re: [U2] Help with encryption Try MX0C. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of m3p Sent: Tuesday, August 11, 2009 12:36 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Help with encryption Hello all, The code below: RESULT = '' STATUS = DIGEST('MD5','THIS IS A TEST',1,RESULT) PRINT 'STATUS = ' : STATUS PRINT 'RESULT = ' : OCONV(RESULT,'MX') works fine, except... I keep getting binary data displayed, despite the OCONV(RESULT,'MX') Anyone have an idea how to turn the RESULT into a string of Hex characters? Replies are much appreciated, thanks. IT-Laure Hansen wrote: Does anyone know how to cause MD5 hashing in Universe? UV 10.2.3 on Win2003 server. I am hoping for a Basic command that I can run on a desired piece of data. Reading documentation so far hasn't helped, am I wanting to do something that is not available to me? Thanks in advance! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.orgmailto:lhan...@redwoodcity.org P Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribehttp://www.redwoodcity.org/eGov/login.aspx?ref=/egov/index .aspx --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- View this message in context: http://www.nabble.com/Help-with-encryption-tp23508833p24924344.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help with encryption
*Sorry, the formatting looked fine in the email editor, just not once sent. Here it is again, hopefully it looks fine this time* We run UD and have the following lines: RET = DIGEST(SHA1, VALUE, 1, SHA1.RESULT) VALUE = OCONV(SHA1.RESULT, HEX) IF VALUE = '' THEN VALUE = OCONV(SHA1.RESULT, MX) END Not sure if that helps you or not -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of IT-Laure Hansen Sent: Wednesday, 12 August 2009 5:44 AM To: U2 Users List Subject: Re: [U2] Help with encryption Actually, you need to parse character by character: NB.CS = LEN(HASHED.TEXT) NEW.TEXT = FOR THE.C = 1 TO NB.CS NEW.TEXT := OCONV(HASHED.TEXT[THE.C,1],MX0C) NEXT THE.C Where HASHED.TEXT is your encrypted string. Took me by surprise too! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.org Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribe -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Henry Unger Sent: Tuesday, August 11, 2009 12:38 PM To: 'U2 Users List' Subject: Re: [U2] Help with encryption Try MX0C. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of m3p Sent: Tuesday, August 11, 2009 12:36 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Help with encryption Hello all, The code below: RESULT = '' STATUS = DIGEST('MD5','THIS IS A TEST',1,RESULT) PRINT 'STATUS = ' : STATUS PRINT 'RESULT = ' : OCONV(RESULT,'MX') works fine, except... I keep getting binary data displayed, despite the OCONV(RESULT,'MX') Anyone have an idea how to turn the RESULT into a string of Hex characters? Replies are much appreciated, thanks. IT-Laure Hansen wrote: Does anyone know how to cause MD5 hashing in Universe? UV 10.2.3 on Win2003 server. I am hoping for a Basic command that I can run on a desired piece of data. Reading documentation so far hasn't helped, am I wanting to do something that is not available to me? Thanks in advance! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.orgmailto:lhan...@redwoodcity.org P Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribehttp://www.redwoodcity.org/eGov/login.aspx?ref=/egov/index .aspx --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- View this message in context: http://www.nabble.com/Help-with-encryption-tp23508833p24924344.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Help with encryption
Using OCONV(RESULT,'MX0C') seems to work OK on Windows but I'm sure I had problems with this on UV 10.2 on hp-ux. However, ICONV(RESULT,'MY') worked on both. Cheers, Andy - Original Message From: m3p jr...@go.com To: u2-users@listserver.u2ug.org Sent: Tuesday, 11 August, 2009 20:36:25 Subject: Re: [U2] Help with encryption Hello all, The code below: RESULT = '' STATUS = DIGEST('MD5','THIS IS A TEST',1,RESULT) PRINT 'STATUS = ' : STATUS PRINT 'RESULT = ' : OCONV(RESULT,'MX') works fine, except... I keep getting binary data displayed, despite the OCONV(RESULT,'MX') Anyone have an idea how to turn the RESULT into a string of Hex characters? Replies are much appreciated, thanks. IT-Laure Hansen wrote: Does anyone know how to cause MD5 hashing in Universe? UV 10.2.3 on Win2003 server. I am hoping for a Basic command that I can run on a desired piece of data. Reading documentation so far hasn't helped, am I wanting to do something that is not available to me? Thanks in advance! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.orgmailto:lhan...@redwoodcity.org P Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribehttp://www.redwoodcity.org/eGov/login.aspx?ref=/egov/index .aspx --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- View this message in context: http://www.nabble.com/Help-with-encryption-tp23508833p24924344.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
RE: [U2] Help with encryption
I know someone already mentioned it but since there are so many responses trying to do something more difficult I figured I'd throw it out there again. Won't the DIGEST() function do what you're looking for? - Josh -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of IT-Laure Hansen Sent: Tuesday, May 12, 2009 5:17 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Help with encryption Thanks. These seem to only handle symmetrical encryption, not one-way hashing (like MD5), but maybe I am missing something. Still reading...! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.org o Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribe -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Dave Greer Sent: Tuesday, May 12, 2009 12:43 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Help with encryption I'm only aware of RC5 and some des. See ENCRYPT function in Basic Ref. -Original Message- From: IT-Laure Hansen [mailto:lhan...@redwoodcity.org] Sent: Tuesday, May 12, 2009 2:48 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Help with encryption Does anyone know how to cause MD5 hashing in Universe? UV 10.2.3 on Win2003 server. I am hoping for a Basic command that I can run on a desired piece of data. Reading documentation so far hasn't helped, am I wanting to do something that is not available to me? Thanks in advance! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.orgmailto:lhan...@redwoodcity.org P Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribehttp://www.redwoodcity.org/eGov/login.aspx?ref=/egov/ index .aspx --- 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] Help with encryption
Thanks so much to all who responded. Yes, it sounds like DIGEST is indeed what I need. Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.org o Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribe -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Joshua Gallant Sent: Wednesday, May 13, 2009 6:14 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Help with encryption I know someone already mentioned it but since there are so many responses trying to do something more difficult I figured I'd throw it out there again. Won't the DIGEST() function do what you're looking for? - Josh -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of IT-Laure Hansen Sent: Tuesday, May 12, 2009 5:17 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Help with encryption Thanks. These seem to only handle symmetrical encryption, not one-way hashing (like MD5), but maybe I am missing something. Still reading...! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.org o Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribe -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Dave Greer Sent: Tuesday, May 12, 2009 12:43 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Help with encryption I'm only aware of RC5 and some des. See ENCRYPT function in Basic Ref. -Original Message- From: IT-Laure Hansen [mailto:lhan...@redwoodcity.org] Sent: Tuesday, May 12, 2009 2:48 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Help with encryption Does anyone know how to cause MD5 hashing in Universe? UV 10.2.3 on Win2003 server. I am hoping for a Basic command that I can run on a desired piece of data. Reading documentation so far hasn't helped, am I wanting to do something that is not available to me? Thanks in advance! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.orgmailto:lhan...@redwoodcity.org P Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribehttp://www.redwoodcity.org/eGov/login.aspx?ref=/egov/ index .aspx --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Help with encryption
The documentation on DIGEST() (in UniData) is as follows: DIGEST Syntax DIGEST(algorithm, data, dataLoc, result) Description The DIGEST function generates a message digest of supplied data. A message digest is the result of a one-way hash function (digest algorithm) performed on the message. Message digest has the unique properties that alight change in the input results in a significant difference in the resulting digest. Therefore, the probability of two different messages resulting in the same digest (collision) is very unlikely. It is also virtually impossible to reverse to the original message from a digest. Message digest is widely used for digital signatures and other purposes. The desired digest algorithm is specified in algorithm. UniData supports the MD5 (Message Digest 5, 128-bit) and SHA1 (Secure Hash Algorithm 1, 160-bit) algorithms. You specify data and its location are with data and dataLoc, respectively. UniData puts the arrived digest into a dynamic array in result. Since digest is short and has a fixed length, it is always put into a string, and no file option is provided. The result can be in either binary or hex format. Parameters The following table describes each parameter of the syntax. Parameter. Description. algorithm A string containing the digest algorithm name (either bMD5b or bSHA1b). dataData or the name of the file containing the data to be digested. dataLoc 1 - Data in a string 2 - Data in a file result A string to store the digest result. The following table describes the status of each return code. Return Code.Status 0 Success 1 Unsupported digest algorithm 2 The data file cannot be read 3 Message digest cannot be obtained 4 Invalid parametersdata. I can't be certain, but, Rex Gozar supplied a straightforward example of what you appear to be looking for. HTH, Bill __ From: Joshua Gallant jgall...@cbd.com Sent: 5/13/2009 6:14 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Help with encryption I know someone already mentioned it but since there are so many responses trying to do something more difficult I figured I'd throw it out there again. Won't the DIGEST() function do what you're looking for? - Josh -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of IT-Laure Hansen Sent: Tuesday, May 12, 2009 5:17 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Help with encryption Thanks. These seem to only handle symmetrical encryption, not one-way hashing (like MD5), but maybe I am missing something. Still reading...! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.org o Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribe -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Dave Greer Sent: Tuesday, May 12, 2009 12:43 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Help with encryption I'm only aware of RC5 and some des. See ENCRYPT function in Basic Ref. -Original Message- From: IT-Laure Hansen [mailto:lhan...@redwoodcity.org] Sent: Tuesday, May 12, 2009 2:48 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Help with encryption Does anyone know how to cause MD5 hashing in Universe? UV 10.2.3 on Win2003 server. I am hoping for a Basic command that I can run on a desired piece of data. Reading documentation so far hasn't helped, am I wanting to do something that is not available to me? Thanks in advance! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.orgmailto:lhan...@redwoodcity.org P Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribehttp://www.redwoodcity.org/eGov/login.aspx?ref=/egov/ index .aspx --- 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
Re: [U2] Help with encryption
FUNCTION MD5SUM(TEXT) * Return an MD5 hash * CVS $Revision: 1.2 $ $Date: 2009/04/14 17:13:27 $ ** EQU ALGORITHM$MD5 TO MD5 EQU DATALOC$STRING TO 1 EQU DATALOC$FILE TO 2 RESULT = ERRCODE = DIGEST(ALGORITHM$MD5, TEXT, DATALOC$STRING, RESULT) RESULT = UPCASE(OCONV(RESULT, MX)) RETURN (RESULT) END IT-Laure Hansen wrote: Does anyone know how to cause MD5 hashing in Universe? UV 10.2.3 on Win2003 server. I am hoping for a Basic command that I can run on a desired piece of data. Reading documentation so far hasn't helped, am I wanting to do something that is not available to me? Thanks in advance! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.orgmailto:lhan...@redwoodcity.org P Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribehttp://www.redwoodcity.org/eGov/login.aspx?ref=/egov/index .aspx --- 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] Help with encryption
I'm only aware of RC5 and some des. See ENCRYPT function in Basic Ref. -Original Message- From: IT-Laure Hansen [mailto:lhan...@redwoodcity.org] Sent: Tuesday, May 12, 2009 2:48 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Help with encryption Does anyone know how to cause MD5 hashing in Universe? UV 10.2.3 on Win2003 server. I am hoping for a Basic command that I can run on a desired piece of data. Reading documentation so far hasn't helped, am I wanting to do something that is not available to me? Thanks in advance! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.orgmailto:lhan...@redwoodcity.org P Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribehttp://www.redwoodcity.org/eGov/login.aspx?ref=/egov/index .aspx --- 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] Help with encryption
Thanks. These seem to only handle symmetrical encryption, not one-way hashing (like MD5), but maybe I am missing something. Still reading...! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.org o Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribe -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Dave Greer Sent: Tuesday, May 12, 2009 12:43 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Help with encryption I'm only aware of RC5 and some des. See ENCRYPT function in Basic Ref. -Original Message- From: IT-Laure Hansen [mailto:lhan...@redwoodcity.org] Sent: Tuesday, May 12, 2009 2:48 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Help with encryption Does anyone know how to cause MD5 hashing in Universe? UV 10.2.3 on Win2003 server. I am hoping for a Basic command that I can run on a desired piece of data. Reading documentation so far hasn't helped, am I wanting to do something that is not available to me? Thanks in advance! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.orgmailto:lhan...@redwoodcity.org P Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribehttp://www.redwoodcity.org/eGov/login.aspx?ref=/egov/index .aspx --- 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] Help with encryption
Charles, If you have Outlook you have to use the out of office assistant on the tools menu. You can make it so no message goes to the list. Jerry Banker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Tuesday, May 12, 2009 3:38 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Help with encryption Hello, This is to the moderator. I will be going on vacation next week for two weeks and will set my out of office message before I go. How do I stop from sending these messages to the list and how do I reenable the list when I get back. 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] Help with encryption
Hi Laure, The U2 encryption is symmetrical. I have asked about one-way, but I have been informed that this is not available. We use gpg to provide a level of one-way encryption. It's not the best, but it is the only option we could find. Tom Thomas Whitmore Director of Product Development RATEX Business Solutions, Inc. Web: http://www.ratex.com 2250 Hickory Road, Suite 10 Plymouth Meeting, PA 19462-1047 -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of IT-Laure Hansen Sent: Tuesday, May 12, 2009 5:17 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Help with encryption Thanks. These seem to only handle symmetrical encryption, not one-way hashing (like MD5), but maybe I am missing something. Still reading...! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.org o Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribe -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Dave Greer Sent: Tuesday, May 12, 2009 12:43 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Help with encryption I'm only aware of RC5 and some des. See ENCRYPT function in Basic Ref. -Original Message- From: IT-Laure Hansen [mailto:lhan...@redwoodcity.org] Sent: Tuesday, May 12, 2009 2:48 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Help with encryption Does anyone know how to cause MD5 hashing in Universe? UV 10.2.3 on Win2003 server. I am hoping for a Basic command that I can run on a desired piece of data. Reading documentation so far hasn't helped, am I wanting to do something that is not available to me? Thanks in advance! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.orgmailto:lhan...@redwoodcity.org P Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribehttp://www.redwoodcity.org/eGov/login.aspx?ref=/egov/index .aspx --- 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] Help with encryption
From: Tom Whitmore We use gpg to provide a level of one-way encryption. It's not the best, but it is the only option we could find. Does Universe or Unidata have a way to link custom functions into the monitor? This would facilitate in-process execution of code directly from BASIC. For example in D3 we can link in MD5 encryption from an external C library and then run it using: success=%md5(valuein,valueout,options) or use common libraries like this: result=%curl(url,page,options) etc... Not many people use this functionality but the benefit is that a new process doesn't need to be created and destroyed on every execution, as is the case with something like this: EXECUTE SH -C gpg :PARAMS: CAPTURING OUT This functionality opens the door to all sorts of possibilities - allowing us to make use to a world full of function libraries when people here are always trying to reinvent the wheel with BASIC. Unfortunately because of geeky words like C, link, and monitor, this topic is hardly ever discussed. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET and other Pick/MultiValue products worldwide, and provides related development services Visit PickWiki.com! Contribute! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help with encryption
In Unidata there is a CALLC function -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Tony G Sent: Wednesday, 13 May 2009 10:27 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Help with encryption From: Tom Whitmore We use gpg to provide a level of one-way encryption. It's not the best, but it is the only option we could find. Does Universe or Unidata have a way to link custom functions into the monitor? This would facilitate in-process execution of code directly from BASIC. For example in D3 we can link in MD5 encryption from an external C library and then run it using: success=%md5(valuein,valueout,options) or use common libraries like this: result=%curl(url,page,options) etc... Not many people use this functionality but the benefit is that a new process doesn't need to be created and destroyed on every execution, as is the case with something like this: EXECUTE SH -C gpg :PARAMS: CAPTURING OUT This functionality opens the door to all sorts of possibilities - allowing us to make use to a world full of function libraries when people here are always trying to reinvent the wheel with BASIC. Unfortunately because of geeky words like C, link, and monitor, this topic is hardly ever discussed. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET and other Pick/MultiValue products worldwide, and provides related development services Visit PickWiki.com! Contribute! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help with encryption
We link over 300 C functions that we have written into UniVerse using its GCI. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Tony G Sent: Tuesday, May 12, 2009 5:27 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Help with encryption From: Tom Whitmore We use gpg to provide a level of one-way encryption. It's not the best, but it is the only option we could find. Does Universe or Unidata have a way to link custom functions into the monitor? This would facilitate in-process execution of code directly from BASIC. For example in D3 we can link in MD5 encryption from an external C library and then run it using: success=%md5(valuein,valueout,options) or use common libraries like this: result=%curl(url,page,options) etc... Not many people use this functionality but the benefit is that a new process doesn't need to be created and destroyed on every execution, as is the case with something like this: EXECUTE SH -C gpg :PARAMS: CAPTURING OUT This functionality opens the door to all sorts of possibilities - allowing us to make use to a world full of function libraries when people here are always trying to reinvent the wheel with BASIC. Unfortunately because of geeky words like C, link, and monitor, this topic is hardly ever discussed. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET and other Pick/MultiValue products worldwide, and provides related development services Visit PickWiki.com! Contribute! --- 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] Help with sockets
-Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Joshua Gallant Sent: Monday, May 04, 2009 9:33 AM To: u2-users@listserver.u2ug.org Subject: [U2] Help with sockets Hi Folks, Maybe one of you can help... Let's assume I'm writing a piece of client software to connect to a server using the basic socket calls simply dump data through a port and receive a response back. Let's also assume the server shuts down mid process and sends a FINACK packet to the client. From what I've seen it would appear the proper response is for the client to respond with an ACK and then a FINACK to close the connection down. This should all be handled by the network subsystem. When a socket is closed on side A, the connection is set to FIN-WAIT-1 state and a FIN segment is sent to side B. Side A can continue to receive data but it can not send. When side B receives the FIN segment it should also go to FIN-WAIT-1 and the subsystem would then mark the connection as closed. Any data remaining in the outgoing queue to side B will be sent to A along with an ACK for the closing of side B. Both addresses then go into TIME_WAIT. First off, is this the correct communication for shutdown in the event the server dies. If the server dies without sending a FIN to the other side then you can not perform a proper closing. The SO_REUSEADDR socket flag allows you to take over an existing address that may have been closed improperly. Otherwise you will have to wait until the subsystem clears the lingering sockets(seconds to minutes depending on your network kernel config), or in the case of Windows, you reboot. I'm not sure if the winsock issues regarding this were fixed in Vista, but I know that it still happens in XP. Secondly, does anyone know how the client software (written in BASIC) can be aware of the FINACK from the server? I tried the getsocketinformation() function run against the peer side but it just tells me the socket is open. It seems I need the software to know the server wants to shut down so that I can issue the closesocket() call. I'm assuming the closesocket() call is sending a FINACK packet. Is this true? You don't need to be aware of it. When you try to read or write, the socket function will tell you what the status of the handle is. Blocking mode changes the status codes a bit, so you'd have to read up on the socket calls and the different error codes for your platform. Anyone have any insight for me? - Josh --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ Glen Batchelor IT Director All-Spec Industries phone: (910) 332-0424 fax: (910) 763-5664 E-mail: webmas...@all-spec.com Web: http://www.all-spec.com Blog: http://blog.all-spec.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help!
Hi Laura Have they check the temp directory access rights, users require read write access to the temp directory. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Help!
I replied to the customer and to Laura Hirsch and David Wolverton separately, but just to keep other people from pulling out their hair, we have seen this symptom when the rgwresp.ini file references C:\WInNT rather than C:\Windows - this is a fairly common symptom when changing Windows versions on the db server. Susan Lynch F.W. Davison Company, Inc. - Original Message - From: David Jordan [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: 08/24/2008 7:46 AM Subject: RE: [U2] Help! Hi Laura Have they check the temp directory access rights, users require read write access to the temp directory. Regards David Jordan --- 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] Help diagnosing mysterious database hangs (UV 10.1.25, HP-UX 11.11)
We recently had an issue on a Window 2003 server that would seem to hang just on one secession, but not always the same secession. It was not on any specific program, file, subsystem, just completely random. What we, think, we found is that it had recently been added to an additional domain and it seemed that the excess time was being taken by authenticating over the internet to that new domain. When we took it off of that domain the hangs stopped. Our hangs were more like 15,30, 60 second hangs, not minutes that I am aware of. HTH Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Geoffrey Mitchell Sent: Friday, August 01, 2008 11:34 AM To: U2 Users List Subject: [U2] Help diagnosing mysterious database hangs (UV 10.1.25, HP-UX 11.11) We are experiencing periodic hangs (up to 5 minutes in duration) accessing the UV database. These hangs are manifesting when accessing the database through JDBC, sometimes when calling a stored procedure, sometimes when running queries directly through JDBC. The problem has appeared in two different, unrelated sub-systems (no common tables are accessed by both). Of course, we first suspected locking issues, but we have not been able to find any evidence that this is the case. In most cases, only one process seems to be accessing the table(s) in question at the time of the problem. Any ideas on how to go about diagnosing this? Or thoughts as to what might be the problem? It would be awfully nice to have a log of all of the queries being executed and how long they took, such as you can easily get from other databases, like mysql, or PostGresql. -- Geoffrey Mitchell Programmer/Analyst Home Decorator's Collection 314-684-1062 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ Information from ESET NOD32 Antivirus, version of virus signature database 3317 (20080801) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] help!
Is it possible your work server is subscribed and you're on the internal distribution list? See if you can look at the email header to find out if it's been forwarded from somewhere. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of doug chanco Sent: 08 October 2007 15:24 To: u2-users@listserver.u2ug.org Subject: [U2] help! I am unscribed from this list with my work address ([EMAIL PROTECTED]) BUT I am still getting emails .. I even emailed majordomo the which command (from my work address) and it says that I am NOT subscribed to any lists BUT yet I am still getting emails and when I try to email the list from my work account it bounced back to me because it says I am not a member of the list and yet I still get emails! help! I still want to receive thsi on my home account, I just need to stop receiving it on my work email ([EMAIL PROTECTED]) thanks! dougc --- 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] help!
Doug, You're not subscribed to any of the lists with an activant.com email address. It is possible that you're just seeing a trickle of emails that were already in the queue at the time you unsubscribed. Larry Hiscock Moderator -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of doug chanco Sent: Monday, October 08, 2007 7:24 AM To: u2-users@listserver.u2ug.org Subject: [U2] help! I am unscribed from this list with my work address ([EMAIL PROTECTED]) BUT I am still getting emails .. I even emailed majordomo the which command (from my work address) and it says that I am NOT subscribed to any lists BUT yet I am still getting emails and when I try to email the list from my work account it bounced back to me because it says I am not a member of the list and yet I still get emails! help! I still want to receive thsi on my home account, I just need to stop receiving it on my work email ([EMAIL PROTECTED]) thanks! dougc --- 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] help!
Thanks Larry I bet that was the issue dougc Larry Hiscock wrote: Doug, You're not subscribed to any of the lists with an activant.com email address. It is possible that you're just seeing a trickle of emails that were already in the queue at the time you unsubscribed. Larry Hiscock Moderator -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of doug chanco Sent: Monday, October 08, 2007 7:24 AM To: u2-users@listserver.u2ug.org Subject: [U2] help! I am unscribed from this list with my work address ([EMAIL PROTECTED]) BUT I am still getting emails .. I even emailed majordomo the which command (from my work address) and it says that I am NOT subscribed to any lists BUT yet I am still getting emails and when I try to email the list from my work account it bounced back to me because it says I am not a member of the list and yet I still get emails! help! I still want to receive thsi on my home account, I just need to stop receiving it on my work email ([EMAIL PROTECTED]) thanks! dougc --- 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] Help in creating Retrieve statement for a multivalue field
You can use an EVAL or an i-descriptor. For example, assuming your field is the ID, then EVAL @ID[2] will give you the year, and EVAL FIELD(@ID, '*', 4, 1) will give you the route. (or you could use field(5) for the year :-) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 06 June 2007 10:42 To: [EMAIL PROTECTED] Subject: [U2] Help in creating Retrieve statement for a multivalue field Thank you all for the help. BY-EXP did the work. I need another help to sort the data by one or multiple characters in a field. 01*GAN100*GAN100*WS09*07-In this filed how do I query the last two characters like 07 (year) or WS09 (Route)? Thanks again. Krish --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help in creating Retrieve statement for a multivalue field
You want BY-EXP not BY -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, June 05, 2007 1:42 PM To: u2-users@listserver.u2ug.org Subject: [U2] Help in creating Retrieve statement for a multivalue field My retrieve statement produced below is not formatting properly. I want the first column to be repeated for each period. SORT SACM.AOS.P BY FDX.Period FDX.Period FMT 30L @ID FMT 35L FDX.NumOfDel LPTR SACM.AOS.P Period ##. SACM.AOS.P. Num Of Del 06 4 01*GAN100* 01 01*GAN100*GAN100*WS09*07 1 GAN100*WS0 9*07 02 1 03 4 04 4 05 2 06 Thanks Krish --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Help in creating Retrieve statement for a multivalue field
[EMAIL PROTECTED] wrote: My retrieve statement produced below is not formatting properly. I want the first column to be repeated for each period. SORT SACM.AOS.P BY FDX.Period FDX.Period FMT 30L @ID FMT 35L FDX.NumOfDel LPTR SACM.AOS.P Period ##. SACM.AOS.P. Num Of Del 06 4 01*GAN100* 01 01*GAN100*GAN100*WS09*071 GAN100*WS0 9*07 02 1 03 4 04 4 05 2 06 Look up BY.EXPLD -- Allen Egerton aegerton at pobox dot com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help with File Pointers
How about using the FILEINFO function? This will return the path name of the 2 different files. OPEN CUSTOMER TO F1 ELSE STOP OPEN CUSTOMER2 TO F2 ELSE STOP PATH1 = FILEINFO(F1,2) PATH2 = FILEINFO(F2,2) Rgds Bernard Lubin Development Department Reynolds and Reynolds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Friday, 16 March 2007 3:40 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Help with File Pointers But doesn't the locking let the same session set the same lock many times? BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Rajkowski Sent: Thursday, March 15, 2007 7:52 AM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED]; u2-users@listserver.u2ug.org Subject: RE: [U2] Help with File Pointers If you are trying to determine that two files are pointing to the same thing, you could set a lock on one and try to set it on the other. If it will not let you do it, then you have the same file. ( note that my first thought was to write an item, but that could cause problems if anyone else was using the file. ) give the lock a unique name like testingFilePointerTestProgram so you don't have issues with existing data. --- 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] Help with File Pointers
So Simple, yet effective. Regards, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8115 On 3/15/2007 at 10:52 am, in message [EMAIL PROTECTED], Michael Rajkowski [EMAIL PROTECTED] wrote: If you are trying to determine that two files are pointing to the same thing, you could set a lock on one and try to set it on the other. If it will not let you do it, then you have the same file. ( note that my first thought was to write an item, but that could cause problems if anyone else was using the file. ) give the lock a unique name like testingFilePointerTestProgram so you don't have issues with existing data. --- 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] Help with File Pointers
If you are trying to determine that two files are pointing to the same thing, you could set a lock on one and try to set it on the other. If it will not let you do it, then you have the same file. ( note that my first thought was to write an item, but that could cause problems if anyone else was using the file. ) give the lock a unique name like testingFilePointerTestProgram so you don't have issues with existing data. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help with File Pointers
But doesn't the locking let the same session set the same lock many times? BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Rajkowski Sent: Thursday, March 15, 2007 7:52 AM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED]; u2-users@listserver.u2ug.org Subject: RE: [U2] Help with File Pointers If you are trying to determine that two files are pointing to the same thing, you could set a lock on one and try to set it on the other. If it will not let you do it, then you have the same file. ( note that my first thought was to write an item, but that could cause problems if anyone else was using the file. ) give the lock a unique name like testingFilePointerTestProgram so you don't have issues with existing data. --- 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] Help with File Pointers
Good point, so release it on the other file pointer, and then look at the locktable to see if it is gone. Bob Woodward [EMAIL PROTECTED] sale.com To Sent by: u2-users@listserver.u2ug.org [EMAIL PROTECTED] cc stserver.u2ug.org Subject RE: [U2] Help with File Pointers 03/15/2007 10:40 AM Please respond to [EMAIL PROTECTED] er.u2ug.org But doesn't the locking let the same session set the same lock many times? BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Rajkowski Sent: Thursday, March 15, 2007 7:52 AM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED]; u2-users@listserver.u2ug.org Subject: RE: [U2] Help with File Pointers If you are trying to determine that two files are pointing to the same thing, you could set a lock on one and try to set it on the other. If it will not let you do it, then you have the same file. ( note that my first thought was to write an item, but that could cause problems if anyone else was using the file. ) give the lock a unique name like testingFilePointerTestProgram so you don't have issues with existing data. --- 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/ [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic22882.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help with File Pointers
Another thing you can try is something like this: 001: * 002: OPEN CUSTOMER TO FILEONE ELSE STOP 003: OPEN MYCUSTOMER TO FILETWO ELSE STOP 004: * 005: READU REC FROM FILEONE, MIKETEST ELSE REC = 006: STATUS = RECORDLOCKED(FILETWO, MIKETEST ) 007: PRINT STATUS Note that the RECORDLOCKED function will 0 if not locked, so if 0 no lock, and different files. Bob Woodward [EMAIL PROTECTED] sale.com To Sent by: u2-users@listserver.u2ug.org [EMAIL PROTECTED] cc stserver.u2ug.org Subject RE: [U2] Help with File Pointers 03/15/2007 10:40 AM Please respond to [EMAIL PROTECTED] er.u2ug.org But doesn't the locking let the same session set the same lock many times? BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Rajkowski Sent: Thursday, March 15, 2007 7:52 AM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED]; u2-users@listserver.u2ug.org Subject: RE: [U2] Help with File Pointers If you are trying to determine that two files are pointing to the same thing, you could set a lock on one and try to set it on the other. If it will not let you do it, then you have the same file. ( note that my first thought was to write an item, but that could cause problems if anyone else was using the file. ) give the lock a unique name like testingFilePointerTestProgram so you don't have issues with existing data. --- 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/ [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic04151.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help with File Pointers
Oh and one more thing came to mind. Windows still supports the old DOS SUBST command. Brian Susan Joslyn wrote: On help with file pointers thanks to everyone who has pitched in. So far I'm no joy. FILEINFO doesn't return just a hard path. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help with File Pointers
Susan Joslyn wrote: On help with file pointers thanks to everyone who has pitched in. So far I'm no joy. FILEINFO doesn't return just a hard path. STATUS doesn't seem to return anything. Ls -I might do the trick on UNIX but I need a Windows solution, too (and first). I think I can do the peel back/parsing thing. Was hoping not to have to do that. As far as parsing is concerned, you just need to realise that every 'abc\..\' can just be removed. I'd run the FILEINFO, then convert '/\' to @FM:@FM in the result and then walk the resulting dynamic array. Everytime you hit a '..' you can back up one, delete two attributes and resume your walk from where you are. As to the ls -i idea on UNIX to sort out sym links, a better bet would be to start with FILEINFO as before, hack off the last bit of the path - the file - and then execute '(cd THE_PATH_BIT; /usr/bin/pwd)' and capture the output which will be the real path. Make sure to use a standalone pwd program though, not the shell built-in. Of course, the real nasty is that on Windows there is a sym link concept called a junction that does the same thing, and I can't think of a way to resolve that. Luckily very few people use them (there's a tool at sysinternals.com for creating, querying and deleting them). Cheers, Ken --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help with File Pointers
Susan, The FILEINFO path probabily isn't a good recommendation in that it relies on the entry being their and it will take a lot more overhead. Here is a small basic program that will parse a relative path. 0001 x=../../this.path/that.path/BANANA 0002 h=/u1/uv/spool 0003 if x[1,1] ne / then x=h:/:x 0004 dim a(30) 0005 matparse a from x using / setting n 0006 i=0 0007 j=0 0008 loop while i n 0009 i+=1 0010 j+=1 0011 if a(i) eq .. then j=j-1 0012 else a(j)=a(i) 0013 repeat 0014 matbuild x from a,1,j using / 0015 print x Hope this is what you can use... Rod Hills -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, March 12, 2007 1:19 PM To: [EMAIL PROTECTED] Cc: u2-users@listserver.u2ug.org Subject: RE: [U2] Help with File Pointers quote who=Susan Joslyn Hi Karl, Thanks! The thing is, I can figure out where I am, but I need to figure out where two Fpointers are pointing. Say I have two Fpointers (VOC entries): 001 F 002 ../../this.path/that.path/BANANA 003 ../../this.path/that.path/D_BANANA And another 001 F 002 /u1/ud/this.path/that.path/BANANA 003 /u1/ud/this.path/that.path/BANANA How do I determine for certain that they are (or are not) pointing to the same exact file? If you SH out to a command prompt, then you can do cd line 2 on each F-Ptr minus the file itself. If you do this in 2 different command prompts, then type PWD in each, you'll see the exact path, and if it matches, then you are looking at the same file. This is one reason not to use relative file points to 'remote' files. It's better to use Q-pointers. I hope this is more clear that my previous feeble attempt. Karl Susan -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ___ This e-mail and any attachments are for the sole use of the intended recipient(s) and may contain privileged and confidential information. Any unauthorized review, use, disclosure or distribution is strictly prohibited. If you are not the intended recipient(s), please contact the sender by reply e-mail and destroy all copies of the original message. Thank you. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Help with File Pointers
quote who=Susan Joslyn Hi group. I'm trying to compare two file pointers to see if they are the same. Like this example: ../../this.path/that.path/BANANA And /u1/ud/this.path/that.path/BANANA I think what I'd want to do is start by resolving a path that had the relative path indicators ../ in it. Anyone know an easy way to do that? pwd = print working directory. The account you are in is the results of pwd. This command is run at the OS level. You can also just type SH at TCL/ECL and the type cd ../.. and see where you find yourself. Likewise, paths can begin with @UDTHOME (and something similar on Universe?) You can type echo $UDTHOME to find out what the path is. Anyone know of a comprehensive list of the options on both platforms (all I know about is the ../.. stuff for like this path and @UDTHOME for the udt home path variable (PATH = GETENV(UDTHOME)) and the easiest way to resolve them? env|grep $PWD will give you the working directory of a session. I don't know if that helps, but I use it... Karl Susan P.s. digest subscriber, so copy me directly or be patient for my response! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help with File Pointers
Susan UniVerse thankfully doesn't have the @ variable insertion. Remember that on Windows, forward and backward slashes can be generally used indiscrimiately, e.g. C:\data\myaccount/myfile Then of course there are symbolic links under UNIX, case insensitivity in Windows.. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: 12 March 2007 19:35 To: u2-users@listserver.u2ug.org Subject: [U2] Help with File Pointers Hi group. I'm trying to compare two file pointers to see if they are the same. Like this example: ../../this.path/that.path/BANANA And /u1/ud/this.path/that.path/BANANA I think what I'd want to do is start by resolving a path that had the relative path indicators ../ in it. Anyone know an easy way to do that? Likewise, paths can begin with @UDTHOME (and something similar on Universe?) Anyone know of a comprehensive list of the options on both platforms (all I know about is the ../.. stuff for like this path and @UDTHOME for the udt home path variable (PATH = GETENV(UDTHOME)) and the easiest way to resolve them? Susan P.s. digest subscriber, so copy me directly or be patient for my response! --- 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] Help with File Pointers
Hi Karl, Thanks! The thing is, I can figure out where I am, but I need to figure out where two Fpointers are pointing. Say I have two Fpointers (VOC entries): 001 F 002 ../../this.path/that.path/BANANA 003 ../../this.path/that.path/D_BANANA And another 001 F 002 /u1/ud/this.path/that.path/BANANA 003 /u1/ud/this.path/that.path/BANANA How do I determine for certain that they are (or are not) pointing to the same exact file? Susan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help with File Pointers
Karl, Thanks again. It is clear -- I think. But unless I'm still misunderstanding, you are giving me tools that I could use with my fingers on a keyboard and I'm wanting to build a program smart enough to look at static file pointers (fpointers) and resolve them to determine if they are pointing to the same place. Susan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 4:19 PM To: [EMAIL PROTECTED] Cc: u2-users@listserver.u2ug.org Subject: RE: [U2] Help with File Pointers quote who=Susan Joslyn Hi Karl, Thanks! The thing is, I can figure out where I am, but I need to figure out where two Fpointers are pointing. Say I have two Fpointers (VOC entries): 001 F 002 ../../this.path/that.path/BANANA 003 ../../this.path/that.path/D_BANANA And another 001 F 002 /u1/ud/this.path/that.path/BANANA 003 /u1/ud/this.path/that.path/BANANA How do I determine for certain that they are (or are not) pointing to the same exact file? If you SH out to a command prompt, then you can do cd line 2 on each F-Ptr minus the file itself. If you do this in 2 different command prompts, then type PWD in each, you'll see the exact path, and if it matches, then you are looking at the same file. This is one reason not to use relative file points to 'remote' files. It's better to use Q-pointers. I hope this is more clear that my previous feeble attempt. Karl Susan -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help with File Pointers
Try opening the two files, then comparing using FILEINFO(filename,2); this gives the path to file. -Original Message- Thanks again. It is clear -- I think. But unless I'm still misunderstanding, you are giving me tools that I could use with my fingers on a keyboard and I'm wanting to build a program smart enough to look at static file pointers (fpointers) and resolve them to determine if they are pointing to the same place. p://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [Spam-Low] RE: [U2] Help with File Pointers
Susan, You can execute an ls -i for each path (ls -i ../../blahblah). This returns the inode for the file. If the inode is the same, the files are the same (one inode for each file). Lee H. Burstein President Dynamic Systems, Inc. 302-477-0180 Fax: 270-574-0180 www.dynamicsys.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Monday, March 12, 2007 4:09 PM To: [EMAIL PROTECTED]; u2-users@listserver.u2ug.org Subject: [Spam-Low] RE: [U2] Help with File Pointers Hi Karl, Thanks! The thing is, I can figure out where I am, but I need to figure out where two Fpointers are pointing. Say I have two Fpointers (VOC entries): 001 F 002 ../../this.path/that.path/BANANA 003 ../../this.path/that.path/D_BANANA And another 001 F 002 /u1/ud/this.path/that.path/BANANA 003 /u1/ud/this.path/that.path/BANANA How do I determine for certain that they are (or are not) pointing to the same exact file? Susan --- 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] Help with File Pointers
I like this answer even better!! I forget about FILEINFO! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Eastwood Sent: Monday, March 12, 2007 3:31 PM To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED] Subject: RE: [U2] Help with File Pointers Try opening the two files, then comparing using FILEINFO(filename,2); this gives the path to file. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help with File Pointers
If you have the current 'path' then .. is always the path before... So if you are sitting in c:\IBM\ACCOUNTS\TESTIT And the path in the VOC is to ..\..\bin You can 'peel back' on each .. to the layer before: So ..\..\bin would turn C:\IBM\ACCOUNTS\TESTIT into C:\IBM\bin You would count the number of ..s and chop that number of segments off the end of the current path... Two ..s peel off 2 segments. Then stick whatever is after the ..s on the end... As for the @UDTHOME and the like - you'd want to do a 'swap' to get those to work. And I'd likely 'fix' the path \ or / to be whichever you'd rather work with since they behave the same in UniData... DW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Monday, March 12, 2007 3:23 PM To: [EMAIL PROTECTED] Cc: u2-users@listserver.u2ug.org Subject: RE: [U2] Help with File Pointers Karl, Thanks again. It is clear -- I think. But unless I'm still misunderstanding, you are giving me tools that I could use with my fingers on a keyboard and I'm wanting to build a program smart enough to look at static file pointers (fpointers) and resolve them to determine if they are pointing to the same place. Susan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Help with File Pointers
This: ../.. means the directory above the directory above the one I'm in right now, so by knowing where you are right now (pwd) you can fill in the complete path.and compare apples to apples Susan Joslyn wrote: Hi Karl, Thanks! The thing is, I can figure out where I am, but I need to figure out where two Fpointers are pointing. Say I have two Fpointers (VOC entries): 001 F 002 ../../this.path/that.path/BANANA 003 ../../this.path/that.path/D_BANANA And another 001 F 002 /u1/ud/this.path/that.path/BANANA 003 /u1/ud/this.path/that.path/BANANA How do I determine for certain that they are (or are not) pointing to the same exact file? Susan --- 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: [Spam-Low] RE: [U2] Help with File Pointers
Re: Susan, You can execute an ls -i for each path (ls -i ../../blahblah). This returns the inode for the file. If the inode is the same, the files are the same (one inode for each file). Lee H. Burstein Lee, this is on face value okay, but technically wrong; there is a chance that filea in file system x has the same inode as fileb in file system y share the same inode number. I wouldn't want to calculate those odds or chances, but ... Inode numbers are assigned per file system, I believe... Bob Wyatt --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help with File Pointers
Just to add one more possible complication to your scenario. Depending on the software or the UNIX admin people, you may need to worry about symbolic links at a UNIX level. For example, lets say you are in Unidata in the directory /usr/ud/ROD. In the VOC for this directory is a file called RODS.FILE, where the VOC entry looked like: 1. D 2. RODS.FILE 3. D_RODS.FILE It would appear that this file lived in the current directory where the VOC is. But at a UNIX level, there could be a symbolic links that says: lrwxrwxrwx 1 root udtgrp 34 Mar 6 20:18 ROD.FILE - /usr/ud/SUSAN/RODS.FILE So RODS.FILE is really lives in another directory called SUSAN. The person doing this should have changed the VOC pointer. But a lot of times UNIX (Unidata phobic) types will move the file to keep a file system from filling up and create a symbolic link to where it lives now. Just thought I would throw that scenario out there just in case you had not thought about it. -Rod -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Susan Joslyn Sent: Monday, March 12, 2007 1:35 PM To: u2-users@listserver.u2ug.org Subject: [U2] Help with File Pointers Hi group. I'm trying to compare two file pointers to see if they are the same. Like this example: ../../this.path/that.path/BANANA And /u1/ud/this.path/that.path/BANANA I think what I'd want to do is start by resolving a path that had the relative path indicators ../ in it. Anyone know an easy way to do that? Likewise, paths can begin with @UDTHOME (and something similar on Universe?) Anyone know of a comprehensive list of the options on both platforms (all I know about is the ../.. stuff for like this path and @UDTHOME for the udt home path variable (PATH = GETENV(UDTHOME)) and the easiest way to resolve them? Susan P.s. digest subscriber, so copy me directly or be patient for my response! --- 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] Help with File Pointers
The FILEINFO idea is a good one -- but it will not serve. [SJ] Here's one file pointer PRCPROCESS: F PRCPROCESS D_PRCPROCESS Here's the other: DEMO.DOTS: F ..\PRC\PRCPROCESS ..\PRC\D_PRCPROCESS They actually do point to the same file. But the output of FILEINFO IS THIS: FILE NAME = DEMO.DOTS, FILEINFO.PATH = C:\SJ\REALMS\PRC\..\PRC\PRCPROCESS FILE NAME = PRCPROCESS, FILEINFO.PATH = C:\SJ\REALMS\PRC\PRCPROCESS So you wouldn't be able to tell by comparing those that they were the same. You still have to resolve the dot business somehow. Susan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help with File Pointers
That's a pain. Have you dont the STATUS test to see if it points out the correct file path? I will guess it will produce the same results as FILEINFO, however am curious. We use nothing but Q-pointers for just this reason. This, however, brings me to what I think is an undocumented feature of uniVerse. In a past life, I setup and managed a test server for training clients. I found that uniVerse could operate very nicely without entering accounts into the UV.ACCOUNT file. In fact, if accounts were NOT entered into that system-wide file, uniVerse could be secured pretty nicely and the same product could be installed many times as long as one rule was followed: Each product installation had to be in the same directory. I.e. DBACCT where the database files are kept USRACCT where the users login to work ADMINACCT where the client admin controls whatever BPACCT where the source code the users run is kept If they were in /u1/TRAIN1 you could put another identical set in /u1/TRAIN2, etc. You would then create a login mechanism that allows users to login to a specific account depending on the classroom used, or some other criteria. Doing a LOGTO ADMINACCT from TRAIN1, for example, would work and never be confused with TRAIN2, etc. The admin (me in this case) could do CHDIR /u1/TRAIN2/ADMINACCT if wanted to change environments, however. Since the users can't get to TCL, and the menuing software used LOGTO, it wasn't a security risk in our case. Now then, not applicable to this issue, but maybe someone can use it some time, some where. Karl quote who=Susan Joslyn The FILEINFO idea is a good one -- but it will not serve. [SJ] Here's one file pointer PRCPROCESS: F PRCPROCESS D_PRCPROCESS Here's the other: DEMO.DOTS: F ..\PRC\PRCPROCESS ..\PRC\D_PRCPROCESS They actually do point to the same file. But the output of FILEINFO IS THIS: FILE NAME = DEMO.DOTS, FILEINFO.PATH = C:\SJ\REALMS\PRC\..\PRC\PRCPROCESS FILE NAME = PRCPROCESS, FILEINFO.PATH = C:\SJ\REALMS\PRC\PRCPROCESS So you wouldn't be able to tell by comparing those that they were the same. You still have to resolve the dot business somehow. Susan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help with File Pointers
You're back to this logic then... Count the number of .. and chop that number of elements off the end. Then stuff everything AFTER the last ..s onto the end. There are dozens of ways to do this that would blow up your logic -- I suspect you'll get to find them one by one. ;-) David W. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Monday, March 12, 2007 3:49 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Help with File Pointers If you have the current 'path' then .. is always the path before... So if you are sitting in c:\IBM\ACCOUNTS\TESTIT And the path in the VOC is to ..\..\bin You can 'peel back' on each .. to the layer before: So ..\..\bin would turn C:\IBM\ACCOUNTS\TESTIT into C:\IBM\bin You would count the number of ..s and chop that number of segments off the end of the current path... Two ..s peel off 2 segments. Then stick whatever is after the ..s on the end... As for the @UDTHOME and the like - you'd want to do a 'swap' to get those to work. And I'd likely 'fix' the path \ or / to be whichever you'd rather work with since they behave the same in UniData... DW --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Help with File Pointers
Susan, I noticed that err..that other software...had problems with relative paths. With SB Installed (and maybe without) you can get the base path of the ACCOUNT that the VOC from DMACCOUNTS1. You can then work with what the VOC entry from the path ACCOUNT in the account. I think you're asking how to determine the full path even when you're not LOGGED to the ACCOUNT, correct? Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8115 On 3/12/2007 at 5:18 pm, in message [EMAIL PROTECTED], Jeff Schasny [EMAIL PROTECTED] wrote: This: ../.. means the directory above the directory above the one I'm in right now, so by knowing where you are right now (pwd) you can fill in the complete path.and compare apples to apples Susan Joslyn wrote: Hi Karl, Thanks! The thing is, I can figure out where I am, but I need to figure out where two Fpointers are pointing. Say I have two Fpointers (VOC entries): 001 F 002 ../../this.path/that.path/BANANA 003 ../../this.path/that.path/D_BANANA And another 001 F 002 /u1/ud/this.path/that.path/BANANA 003 /u1/ud/this.path/that.path/BANANA How do I determine for certain that they are (or are not) pointing to the same exact file? Susan --- 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] Help with File Pointers
It looks like !VOC.PATHNAME will work to return the fully qualified path of two VOC F file pointer entries. Here's what I did: ED BOBW.BP TEST.VOC.PATH 8 lines long. : P 0001: CALL !VOC.PATHNAME(,TESTFILE,VOC.PATH,STATUS) 0002: IF STATUS = 0 THEN 0003: PRINT TESTFILE PATH=:VOC.PATH 0004: END 0005: CALL !VOC.PATHNAME(,TESTFILE2,VOC.PATH2,STATUS) 0006: IF STATUS = 0 THEN 0007: PRINT TESTFILE2 PATH = :VOC.PATH2 0008: END Bottom at line 8. : Q ED VOC TESTFILE TESTFILE2 SELECTed record name = TESTFILE. 3 lines long. : P 0001: F 0002: TESTFILE 0003: D_TESTFILE Bottom at line 3. : N SELECTed record name = TESTFILE2. 3 lines long. : P 0001: F 0002: ..\DEVACCT\TESTFILE 0003: ..\DEVACCT\D_TESTFILE Bottom at line 3. : Q 03 RUN BOBW.BP TEST.VOC.PATH PM PATH=D:/data/adv/data/DEVACCT/TESTFILE PM2 PATH = D:/data/adv/data/DEVACCT/TESTFILE In both cases, I got the full path returned. This is on a Windows 2003 system using Universe 10.1.18. BobW --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help with File Pointers
FILEINFO always returns the correct fully resolved path (without any double dots) under Universe on Unix. Maybe this problem only affects Windows. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Tuesday, 13 March 2007 6:40 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Help with File Pointers The FILEINFO idea is a good one -- but it will not serve. [SJ] Here's one file pointer PRCPROCESS: F PRCPROCESS D_PRCPROCESS Here's the other: DEMO.DOTS: F ..\PRC\PRCPROCESS ..\PRC\D_PRCPROCESS They actually do point to the same file. But the output of FILEINFO IS THIS: FILE NAME = DEMO.DOTS, FILEINFO.PATH = C:\SJ\REALMS\PRC\..\PRC\PRCPROCESS FILE NAME = PRCPROCESS, FILEINFO.PATH = C:\SJ\REALMS\PRC\PRCPROCESS So you wouldn't be able to tell by comparing those that they were the same. You still have to resolve the dot business somehow. Susan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ 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] HELP!!! with MVEnterprise and DigiPort Problem
It's probably not mventerprise's fault. You need to debug the digiport from AIX. Do you have a file /dev/tty82 and does it have read/write permissions for the user that mventerprise runs as? You probably need to configure the digiport through smit to get the range of tty numbers that you want. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Varney Sent: Monday, March 05, 2007 9:39 AM To: u2-users@listserver.u2ug.org Subject: [U2] HELP!!! with MVEnterprise and DigiPort Problem I have a REAL strange problem here. We just went from an old box to new box. AIX version 5.3 MVEnterprise 4.2 Digi Realport v3.8.7 We went from AIX v5.2 to 5.3 MVEnterprise 4.1 to 4.2 Most everything went painlessly except when we tried to get our Digiports up. The error we get is as follows: ** prodpick 82 tty82 ** Terminal path '/dev/tty82' open errno 11 * prodpick 82 tty82 ** Child exit; mvEnterprise status 11 Trying to go back to the old box yields the SAME error. Has anyone seen this before? Does anyone have a solution for this? --- 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 Free Edition. Version: 7.5.446 / Virus Database: 268.18.7/711 - Release Date: 3/5/2007 9:41 AM -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.7/711 - Release Date: 3/5/2007 9:41 AM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Help ! UNIRPC
On 2/17/07, Patricia Wilson [EMAIL PROTECTED] wrote: Has anyone experienced any issues with unirpc? Once we sorted the timeout issue as below using UOJ and the unirpc has been rock solid. - Has anyone experienced issues with setting the unirpc timeout parameter via the command line and having the service not behave correctly? We didn't set the time-out on the command line but in the unirpcservices file. The issue we found was the server would time-out the connection but the connection object wasn't aware the link had gone and would still report itself as connected. Attempting to execute methods on the connection object would cause a problem. The simple fix was to up the time-out parameter and then run a very simple lightweight command to keep the connections alive. For java apps I would recommend the excellent quartz scheduler library, no idea for MS clients but I presume there is something similar or you could roll your own using a timer. HTH Adrian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Help -- UD System hang...
ran out of message headers? kernel MSGTQL $UDTBIN/ipcstat -qonwill just show message queues with non-zero CBYTES or QNUM or 'ipcs -qop' - look at QNUM total and compare to kernel MSGTQL Wally Terhune U2 Support Architect IBM Information Management 4700 South Syracuse Street, Denver, CO 80237 Tel: 303.773.7969 Fax: 303.773.5915 [EMAIL PROTECTED] Larry Hiscock [EMAIL PROTECTED] com To Sent by: u2-users@listserver.u2ug.org [EMAIL PROTECTED] cc stserver.u2ug.org Subject [U2] Help -- UD System hang... 10/23/2006 10:20 AM Please respond to [EMAIL PROTECTED] er.u2ug.org I recently upgraded a client to UniData 6.1.12 running on SCO OpenServer 5.0.7. The installation (fresh installs of both) went smoothly, and everything seemed fine after the upgrade. This morning, however, once all of the users logged in, they are intermittently experiencing hangs (i.e. no response from their terminals). Unix is still up and running fine, but the Unidata sessions can't be killed using stopudt pid. They CAN be killed using kill -9, but a 'listuser' shows them as still logged in to Unidata. The hang affects ALL Unidata users. If I attempt to begin a new Unidata session, it starts, but immediately hangs. I'm not seeing any obvious problems in the Unidata log files. The hang may or may not be related to a couple of cron jobs that we have running once per hour. After the last two, I noticed that there were PHANTOM users in the listuser output. There were no errors in the _PH_ output files or the log files that the PHANTOM jobs created. All of the kernel tunable parameters are set at or above recommended settings (I can provide the config settings if needed). Any ideas? Larry Hiscock Western Computer Services http://www.wcs-corp.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic11604.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help -- UD System hang...
Hi Wally, Thanks for the suggestion. Here's what I've currently got configured: MSGTQL is set to 1024. ipcstat -qon shows nothing ipcs -qop shows 5 queues (0-4) all with 0 in the CBYTES and QNUM columns I ran udtconf allowed it to autoconf, then rebooted the system. So far (knock on wood) we haven't had another hang, BUT I have all of the cron jobs that start Unidata phantoms temporarily disabled. Larry Hiscock Western Computer Services -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wally Terhune Sent: Monday, October 23, 2006 10:11 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Help -- UD System hang... ran out of message headers? kernel MSGTQL $UDTBIN/ipcstat -qonwill just show message queues with non-zero CBYTES or QNUM or 'ipcs -qop' - look at QNUM total and compare to kernel MSGTQL Wally Terhune U2 Support Architect IBM Information Management 4700 South Syracuse Street, Denver, CO 80237 Tel: 303.773.7969 Fax: 303.773.5915 [EMAIL PROTECTED] Larry Hiscock [EMAIL PROTECTED] com To Sent by: u2-users@listserver.u2ug.org [EMAIL PROTECTED] cc stserver.u2ug.org Subject [U2] Help -- UD System hang... 10/23/2006 10:20 AM Please respond to [EMAIL PROTECTED] er.u2ug.org I recently upgraded a client to UniData 6.1.12 running on SCO OpenServer 5.0.7. The installation (fresh installs of both) went smoothly, and everything seemed fine after the upgrade. This morning, however, once all of the users logged in, they are intermittently experiencing hangs (i.e. no response from their terminals). Unix is still up and running fine, but the Unidata sessions can't be killed using stopudt pid. They CAN be killed using kill -9, but a 'listuser' shows them as still logged in to Unidata. The hang affects ALL Unidata users. If I attempt to begin a new Unidata session, it starts, but immediately hangs. I'm not seeing any obvious problems in the Unidata log files. The hang may or may not be related to a couple of cron jobs that we have running once per hour. After the last two, I noticed that there were PHANTOM users in the listuser output. There were no errors in the _PH_ output files or the log files that the PHANTOM jobs created. All of the kernel tunable parameters are set at or above recommended settings (I can provide the config settings if needed). Any ideas? Larry Hiscock Western Computer Services http://www.wcs-corp.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic11604.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- 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] Help -- UD System hang...
So - generate a udtdiag dump when the problem is occuring and open a support case with your UniData support provider. (would be my next suggestion) 1) Log in to your system as 'root' 2) In the UNIX shell, cd to a directory that has as much as 200MB of available disk space. Note: For systems without the Recoverable File System (RFS) enabled, you may only need 50MB or so. The size of the dump depends on udtdconfig settings and the size of your logs and errlogs in $UDTBIN. 3) Decide on a name for the dump directory you want to create. This directory must not already exist in the directory you are now positioned in. Folks often construct a unique name involving the current date (e.g. udtdiagdump_080105). If you already have an IBM U2 Support case opened, you may want to use the case number. The choice is yours. The rest of the instructions use this example dump directory name. 4) Run the udtdiag script (using the example above): $UDTBIN/udtdiag udtdiagdump_080105 The script runs a series of commands that copy logs and capture the current state of UniData and your system environment. 5) Use the UNIX tar command to make a relative path tar image of the dump directory. For example: tar cvf udtdiagdump_080105.tar udtdiagdump_080105 6) Compress the tar image: compress udtdiagdump_080105.tar 7) Use ftp it to send this compressed tar image to IBM U2 Support: ftp testcase.boulder.ibm.com login as anonymous, use your email address as password cd /software/toibm/u2 bin put udtdiagdump_080105.tar.Z quit Note: If you move the compressed tar file to another system in order to access testcase.boulder.ibm.com, be sure to treat it as a binary file at every step. 8) Contact the appropriate IBM U2 support office (for your geography) where you have opened a support case and advise them of the name of the compressed tar file you just posted. Note: If you are creating a diagnostic dump because you are having a problem with UniData Replication, please create dumps on all systems involved in your replication setup - the publishing system and the subscribing system(s). Wally Terhune U2 Support Architect IBM Information Management 4700 South Syracuse Street, Denver, CO 80237 Tel: 303.773.7969 Fax: 303.773.5915 [EMAIL PROTECTED] Larry Hiscock [EMAIL PROTECTED] com To Sent by: u2-users@listserver.u2ug.org [EMAIL PROTECTED] cc stserver.u2ug.org Subject RE: [U2] Help -- UD System hang... 10/23/2006 11:56 AM Please respond to [EMAIL PROTECTED] er.u2ug.org Hi Wally, Thanks for the suggestion. Here's what I've currently got configured: MSGTQL is set to 1024. ipcstat -qon shows nothing ipcs -qop shows 5 queues (0-4) all with 0 in the CBYTES and QNUM columns I ran udtconf allowed it to autoconf, then rebooted the system. So far (knock on wood) we haven't had another hang, BUT I have all of the cron jobs that start Unidata phantoms temporarily disabled. Larry Hiscock Western Computer Services [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic25008.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help! Uniobjects for .NET Users
C# or VB? Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Patricia Wilson Sent: Monday, August 14, 2006 10:38 AM To: u2-users@listserver.u2ug.org Subject: [U2] Help! Uniobjects for .NET Users Ok - here's the deal fellow board members. My boss is trying out Uniobjects for .NET for an app and has some simple Questions for the experienced user of which he has asked me (who he knowingly doesn't use that technology), and asked me to Post them. However, I think it would be much easier if I could just have someone spend 10 minutes answering his questions on The phone then me interpreting what he says and posting it... Any takers here? I am desperate!!! Patricia M. Wilson MIS Programmer x 3095 813.635.3095 [EMAIL PROTECTED] --- 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] Help! Uniobjects for .NET Users
C# - Are you my white in shining armor? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Cipollina Sent: Monday, August 14, 2006 11:23 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Help! Uniobjects for .NET Users C# or VB? Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Patricia Wilson Sent: Monday, August 14, 2006 10:38 AM To: u2-users@listserver.u2ug.org Subject: [U2] Help! Uniobjects for .NET Users Ok - here's the deal fellow board members. My boss is trying out Uniobjects for .NET for an app and has some simple Questions for the experienced user of which he has asked me (who he knowingly doesn't use that technology), and asked me to Post them. However, I think it would be much easier if I could just have someone spend 10 minutes answering his questions on The phone then me interpreting what he says and posting it... Any takers here? I am desperate!!! Patricia M. Wilson MIS Programmer x 3095 813.635.3095 [EMAIL PROTECTED] --- 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] Help with non functional printer
Louis GDI mode in UV is exactly that: it uses Windows device calls to render on the printer. These calls render text/graphics at a high/abstract level, leaving the specific implementation of e.g. Font handling to the device driver. The problem comes when you want to send sequences that are not part of the text, eg. PCL. In effect this is duplicating the work of the GDI itself - PCL is not directly supported by Windows GDI - even if the HP drivers map some GDI calls into PCL. Most GDI switches into graphics mode so escape sequences like PCL get lost OR interpreted as literal characters. Quite simply, Windows has no way of knowing that you want to pass these sequences through unmodified. The only way to force through PCL without interpretation is to use a generic/text only driver, if it will work with your printer. Unfortunately (increasingly) that isn't always the case. It isn't really a UV failing but a clash of models: Windows, unlike Unix, expects applications to play by its rules and that doesn't include sendiny raw control sequences to devices. AD - sort of: I've become frustrated by this and other spooler limits and so wrote an API that now produces PDF documents and Windows prints directly from UV bypassing the spooler. This supports full text and graphics control, and conversion of existing prints. I'm packaging this for release hopefully in a couple of months - it has been running at a client site for about 9 months - and I have plans to add PCL interpretation as well. Anyone interested please contact me off-list. Brian prints windows - -Original Message- From: Louis Windsor[EMAIL PROTECTED] Sent: 22/05/06 03:53:25 To: u2-users@listserver.u2ug.orgu2-users@listserver.u2ug.org Subject: Re: [U2] Help with non functional printer With further messing about using the GDI,DEFAULT addition I now can print text at least. It doesn't seem to support even PCL3 as a simple orientation string (to select landscape printing) is ignored. Also the graphic set, like light down and left/light down and right/light horizontal etc are completely screwed. Well, at least I can now print text so that is a gain but any further suggestions to print graphic characters would be appreciated. I am really puzzled as under Windows it is a superb printer. Does everything I hoped it would but un UniVerse Thanks for the responses so far, Louis - Original Message - From: Bruce Nichol [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, May 22, 2006 9:02 AM Subject: Re: [U2] Help with non functional printer [Message truncated. Tap Edit-Mark for Download to get remaining portion.] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Help with non functional printer
Thanks for a most informative answer. I just want to print nice boxes etc for my Sudoku solver. The solver is written in UniVerse Basic so I wanted to print results (and intermediate results) etc. My prior printer (an el cheapo HP) did print graphic boxes etc so I thought my new printer would too. I don't doubt your claims but I find it difficult to understand why defined characters in the ^179 to ^217 range don't print correctly through UV. Oh, well Life wasn't meant to be easy! Louis GDI mode in UV is exactly that: it uses Windows device calls to render on the printer. These calls render text/graphics at a high/abstract level, leaving the specific implementation of e.g. Font handling to the device driver. The problem comes when you want to send sequences that are not part of the text, eg. PCL. In effect this is duplicating the work of the GDI itself - PCL is not directly supported by Windows GDI - even if the HP drivers map some GDI calls into PCL. Most GDI switches into graphics mode so escape sequences like PCL get lost OR interpreted as literal characters. Quite simply, Windows has no way of knowing that you want to pass these sequences through unmodified. The only way to force through PCL without interpretation is to use a generic/text only driver, if it will work with your printer. Unfortunately (increasingly) that isn't always the case. It isn't really a UV failing but a clash of models: Windows, unlike Unix, expects applications to play by its rules and that doesn't include sendiny raw control sequences to devices. AD - sort of: I've become frustrated by this and other spooler limits and so wrote an API that now produces PDF documents and Windows prints directly from UV bypassing the spooler. This supports full text and graphics control, and conversion of existing prints. I'm packaging this for release hopefully in a couple of months - it has been running at a client site for about 9 months - and I have plans to add PCL interpretation as well. Anyone interested please contact me off-list. Brian prints windows - -Original Message- From: Louis Windsor[EMAIL PROTECTED] Sent: 22/05/06 03:53:25 To: u2-users@listserver.u2ug.orgu2-users@listserver.u2ug.org Subject: Re: [U2] Help with non functional printer With further messing about using the GDI,DEFAULT addition I now can print text at least. It doesn't seem to support even PCL3 as a simple orientation string (to select landscape printing) is ignored. Also the graphic set, like light down and left/light down and right/light horizontal etc are completely screwed. Well, at least I can now print text so that is a gain but any further suggestions to print graphic characters would be appreciated. I am really puzzled as under Windows it is a superb printer. Does everything I hoped it would but un UniVerse Thanks for the responses so far, Louis - Original Message - From: Bruce Nichol [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, May 22, 2006 9:02 AM Subject: Re: [U2] Help with non functional printer [Message truncated. Tap Edit-Mark for Download to get remaining portion.] --- 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] Help with non functional printer
What kind of printer are you using and with which driver? You might need to either: install it using the generic/text only driver (won't work with some printer models) OR issue the GDI flag as part of your SETPTR to switch to graphic mode printing if not: SETPTR ,,AT yourprinter,GDI,NODEFAULT Brian I have the Personal Edition (V10.1.11) installed on Windows XP Professional and had printing working on a printer on the printer port. I installed a new printer on a USB port and shared it as UVDEFAULT just like the old printer. I removed the old printer and made the new one default etc. Now when I print (spool) from UV it goes through the motions but nothing actually prints. No error messages from UV or Windows. Help Please! What am I doing wrong? Or what am I not doing right? Louis PS my expertise was on UniVerse on Unix. --- 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] Help with non functional printer
The reported symptoms sounds as if you purchased a host-based printer...a printer with no inherent support for PCL. At this time UniVerse/Windows is not supporting these new printers. Warning.new host-based printers are hitting the main stream with attractive pricing.they are not compatible with PCL printing. These printers are ideal for Windows application printing ONLY. Resolution/Information: Attach the printer to another Windows based PC on the same network, share the printer and on the UniVerse system create a new local printer that points to the shared printer by name, \\computername\sharename. We have made these printers print this way through another PC. Printers purchased for printing must have inherent support for PCL code. Host-based printers today will not accept PCL code. Host-based printers rely on the computer's CPU to do the rasterization of the pages. Host-based printers are lower-cost printers that place a greater demand on the host processor than traditional printers. Traditional, non-host-based printers, accept a command language from the computer, such as PostScript and PCL, and perform the rasterization internally. They may be slightly more expensive but perform the rasterization function within the printer and therefore do not rely on the host system to do their work. A short list we have gathered so far... A list of non-supported host-based printers are HP LaserJet 1500 HP LaserJet 2600n HP LaserJet 3500 HP LaserJet 3550 Supported non-host based printers are HP Color LaserJet 3700 HP LaserJet 2430tn HP LaserJet 4250n HP LaserJet 4240n HP LaserJet 4610n Paul H. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Louis Windsor Sent: Sunday, May 21, 2006 11:10 AM To: u2-users@listserver.u2ug.org Subject: [U2] Help with non functional printer I have the Personal Edition (V10.1.11) installed on Windows XP Professional and had printing working on a printer on the printer port. I installed a new printer on a USB port and shared it as UVDEFAULT just like the old printer. I removed the old printer and made the new one default etc. Now when I print (spool) from UV it goes through the motions but nothing actually prints. No error messages from UV or Windows. Help Please! What am I doing wrong? Or what am I not doing right? Louis PS my expertise was on UniVerse on Unix. --- 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] Help with non functional printer
It's a Canon PIXMA iP4000 printer using the driver off the installation CD. Needless to say the printer works fine under windows. When I do a SPOOL -LIST UV lists:- Printer: Microsoft Office Document Image Writer no entries. Printer: Canon PIXMA iP4000 no entries When I append the GDI,NODEFAULT it prints but it lists the file with line numbers and a Record 1 File HOLD Account ... and time and date Header and Footer The escape character is printed as ^027 graphic characters printed as ^218^196^194 etc Thanks, at least it prints sofar. More help please. Louis - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, May 22, 2006 2:36 AM Subject: RE: [U2] Help with non functional printer What kind of printer are you using and with which driver? You might need to either: install it using the generic/text only driver (won't work with some printer models) OR issue the GDI flag as part of your SETPTR to switch to graphic mode printing if not: SETPTR ,,AT yourprinter,GDI,NODEFAULT Brian I have the Personal Edition (V10.1.11) installed on Windows XP Professional and had printing working on a printer on the printer port. snip --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Help with non functional printer
Goo'day, Louis,At 06:56 22/05/06 +0800, you wrote: It's a Canon PIXMA iP4000 printer using the driver off the installation CD. Needless to say the printer works fine under windows. When I do a SPOOL -LIST UV lists:- Printer: Microsoft Office Document Image Writer no entries. Printer: Canon PIXMA iP4000 no entries When I append the GDI,NODEFAULT it prints but it lists the file with line numbers and a Record 1 File HOLD Account ... and time and date Header and Footer The escape character is printed as ^027 graphic characters printed as ^218^196^194 etc Thanks, at least it prints sofar. More help please. As far as I can determine, a PIXMA printer is a jet printer, and as far back as I can recall, jet printers are all Windows GDI printers, that is, they have no local intelligence, all work is done by the printer driver. They usually come with a minimum of PCL capability (a sub-set of PCL3, normally), and because of this, are unsuitable for UV work. They normally can't even draw a straight line. You are limited, in all probability, to straight text, and with a very limited number of fonts - at least we always were. We have found sometimes, as a previous poster said, that we can redirect printing from a fully-capable PCL printer to a jet printer and get reasonable output, but not without a deal of work, and support thereafter (Users? It's a printer, isn't it? What's wrong with your software? Everything else prints ) About the only permanent fix we've found is usually bound up in non-freebie third-party tools... or a change, now from UV to Reality (I believe Northgate now supports Windows GDI printers)... And, don't let UV's SETPTR option of GDI fool you... It's not really there to support el-cheapo Windows GDI printers. There is a difference... Sorry I cannot be of more assistance. Louis - Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.392 / Virus Database: 268.6.1/344 - Release Date: 19/05/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Help with non functional printer
With further messing about using the GDI,DEFAULT addition I now can print text at least. It doesn't seem to support even PCL3 as a simple orientation string (to select landscape printing) is ignored. Also the graphic set, like light down and left/light down and right/light horizontal etc are completely screwed. Well, at least I can now print text so that is a gain but any further suggestions to print graphic characters would be appreciated. I am really puzzled as under Windows it is a superb printer. Does everything I hoped it would but un UniVerse Thanks for the responses so far, Louis - Original Message - From: Bruce Nichol [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, May 22, 2006 9:02 AM Subject: Re: [U2] Help with non functional printer Goo'day, Louis,At 06:56 22/05/06 +0800, you wrote: It's a Canon PIXMA iP4000 printer using the driver off the installation CD. Needless to say the printer works fine under windows. When I do a SPOOL -LIST UV lists:- Printer: Microsoft Office Document Image Writer no entries. Printer: Canon PIXMA iP4000 no entries When I append the GDI,NODEFAULT it prints but it lists the file with line numbers and a Record 1 File HOLD Account ... and time and date Header and Footer The escape character is printed as ^027 graphic characters printed as ^218^196^194 etc Thanks, at least it prints sofar. More help please. As far as I can determine, a PIXMA printer is a jet printer, and as far back as I can recall, jet printers are all Windows GDI printers, that is, they have no local intelligence, all work is done by the printer driver. They usually come with a minimum of PCL capability (a sub-set of PCL3, normally), and because of this, are unsuitable for UV work. They normally can't even draw a straight line. You are limited, in all probability, to straight text, and with a very limited number of fonts - at least we always were. We have found sometimes, as a previous poster said, that we can redirect printing from a fully-capable PCL printer to a jet printer and get reasonable output, but not without a deal of work, and support thereafter (Users? It's a printer, isn't it? What's wrong with your software? Everything else prints ) About the only permanent fix we've found is usually bound up in non-freebie third-party tools... or a change, now from UV to Reality (I believe Northgate now supports Windows GDI printers)... And, don't let UV's SETPTR option of GDI fool you... It's not really there to support el-cheapo Windows GDI printers. There is a difference... Sorry I cannot be of more assistance. Louis - Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.392 / Virus Database: 268.6.1/344 - Release Date: 19/05/06 --- 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] Help with non functional printer
Goo'day, again, Louis, At 10:53 22/05/06 +0800, you wrote: With further messing about using the GDI,DEFAULT addition I now can print text at least. It doesn't seem to support even PCL3 as a simple orientation string (to select landscape printing) is ignored. Also the graphic set, like light down and left/light down and right/light horizontal etc are completely screwed. As I said... A sub-set of PCL 3, but I'm surprised it doesn't support ESC:'l0O' for landscape. Perhaps as time passes, these sorts of printers are further removed from the ability to programatically control them. But you should consider sending the PCL landscape, A4 (??), etc to the printer as a page separator (.sep file). We also use: GDI FONTNAME Courier New --- Notethe Upper/lower case FONTSIZE 8 in SETPTR statements which gives about 178 charsx60 lines per A4 page. Perhaps *you* will be the one who gives IBM the straw that breaks the camel's back and they set about looking to use Winblows printer drivers, but you'll have to fight the *nix side of the fence first Nobody that I know of in the past 12 years has been able to convince anybody involved with UV (from VMark onward) that Windows printer drivers are used by the rest of the world. HTH Well, at least I can now print text so that is a gain but any further suggestions to print graphic characters would be appreciated. I am really puzzled as under Windows it is a superb printer. Does everything I hoped it would but un UniVerse Bits vs characters... Thanks for the responses so far, Louis - Original Message - From: Bruce Nichol [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, May 22, 2006 9:02 AM Subject: Re: [U2] Help with non functional printer Goo'day, Louis,At 06:56 22/05/06 +0800, you wrote: It's a Canon PIXMA iP4000 printer using the driver off the installation CD. Needless to say the printer works fine under windows. When I do a SPOOL -LIST UV lists:- Printer: Microsoft Office Document Image Writer no entries. Printer: Canon PIXMA iP4000 no entries When I append the GDI,NODEFAULT it prints but it lists the file with line numbers and a Record 1 File HOLD Account ... and time and date Header and Footer The escape character is printed as ^027 graphic characters printed as ^218^196^194 etc Thanks, at least it prints sofar. More help please. As far as I can determine, a PIXMA printer is a jet printer, and as far back as I can recall, jet printers are all Windows GDI printers, that is, they have no local intelligence, all work is done by the printer driver. They usually come with a minimum of PCL capability (a sub-set of PCL3, normally), and because of this, are unsuitable for UV work. They normally can't even draw a straight line. You are limited, in all probability, to straight text, and with a very limited number of fonts - at least we always were. We have found sometimes, as a previous poster said, that we can redirect printing from a fully-capable PCL printer to a jet printer and get reasonable output, but not without a deal of work, and support thereafter (Users? It's a printer, isn't it? What's wrong with your software? Everything else prints ) About the only permanent fix we've found is usually bound up in non-freebie third-party tools... or a change, now from UV to Reality (I believe Northgate now supports Windows GDI printers)... And, don't let UV's SETPTR option of GDI fool you... It's not really there to support el-cheapo Windows GDI printers. There is a difference... Sorry I cannot be of more assistance. Louis - Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.392 / Virus Database: 268.6.1/344 - Release Date: 19/05/06 --- 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/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.1.392 / Virus Database: 268.6.1/344 - Release Date: 19/05/06 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.392 / Virus Database: 268.6.1/344 - Release Date: 19/05/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Help with non functional printer
Gudday Bruce, Thanks for your reply and hopes that IBM will come to the party with Windows printers. Do you believe in a fat man, read coat, big bushy beard too. Drives a reindeer drawn carriage I have used UniVerse for over twenty years and the solution to most programs is to program around them as you get very response from whomever is in control. Sad to say Back to the drawingboard. Thanks again Louis - Original Message - From: Bruce Nichol [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, May 22, 2006 11:43 AM Subject: Re: [U2] Help with non functional printer Goo'day, again, Louis, At 10:53 22/05/06 +0800, you wrote: With further messing about using the GDI,DEFAULT addition I now can print text at least. It doesn't seem to support even PCL3 as a simple orientation string (to select landscape printing) is ignored. Also the graphic set, like light down and left/light down and right/light horizontal etc are completely screwed. As I said... A sub-set of PCL 3, but I'm surprised it doesn't support ESC:'l0O' for landscape. Perhaps as time passes, these sorts of printers are further removed from the ability to programatically control them. But you should consider sending the PCL landscape, A4 (??), etc to the printer as a page separator (.sep file). We also use: GDI FONTNAME Courier New --- Notethe Upper/lower case FONTSIZE 8 in SETPTR statements which gives about 178 charsx60 lines per A4 page. Perhaps *you* will be the one who gives IBM the straw that breaks the camel's back and they set about looking to use Winblows printer drivers, but you'll have to fight the *nix side of the fence first Nobody that I know of in the past 12 years has been able to convince anybody involved with UV (from VMark onward) that Windows printer drivers are used by the rest of the world. HTH Well, at least I can now print text so that is a gain but any further suggestions to print graphic characters would be appreciated. I am really puzzled as under Windows it is a superb printer. Does everything I hoped it would but un UniVerse Bits vs characters... Thanks for the responses so far, Louis Goo'day, Louis,At 06:56 22/05/06 +0800, you wrote: It's a Canon PIXMA iP4000 printer using the driver off the installation CD. Needless to say the printer works fine under windows. When I do a SPOOL -LIST UV lists:- Printer: Microsoft Office Document Image Writer no entries. Printer: Canon PIXMA iP4000 no entries When I append the GDI,NODEFAULT it prints but it lists the file with line numbers and a Record 1 File HOLD Account ... and time and date Header and Footer The escape character is printed as ^027 graphic characters printed as ^218^196^194 etc Thanks, at least it prints sofar. More help please. As far as I can determine, a PIXMA printer is a jet printer, and as far back as I can recall, jet printers are all Windows GDI printers, that is, they have no local intelligence, all work is done by the printer driver. They usually come with a minimum of PCL capability (a sub-set of PCL3, normally), and because of this, are unsuitable for UV work. They normally can't even draw a straight line. You are limited, in all probability, to straight text, and with a very limited number of fonts - at least we always were. We have found sometimes, as a previous poster said, that we can redirect printing from a fully-capable PCL printer to a jet printer and get reasonable output, but not without a deal of work, and support thereafter (Users? It's a printer, isn't it? What's wrong with your software? Everything else prints ) About the only permanent fix we've found is usually bound up in non-freebie third-party tools... or a change, now from UV to Reality (I believe Northgate now supports Windows GDI printers)... And, don't let UV's SETPTR option of GDI fool you... It's not really there to support el-cheapo Windows GDI printers. There is a difference... Sorry I cannot be of more assistance. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] help with multivalue and when
This is a classic MV situation that is over 25 years old. I don't know the platform and if it supports associated fields. But, traditionally, selects against 2 fields are often taken as 2 separate selects. The classic repair is to concatenate the requested pair into one dict item and select it as follows: ED DICT ORDER.LOG COMBO 002 ACTION:ACT.DATE or to the effect. Insure ACT.DATE is oconv'd D2/ Then you would select ORDER.LOG WITH COMBO = PCK10/15/05 My 1 cent. Mark Johnson P.S. Is this RESULTS. Nice to see it's still around. - Original Message - From: Jeff Powell [EMAIL PROTECTED] To: u2 users group u2-users@listserver.u2ug.org Sent: Tuesday, October 11, 2005 9:02 AM Subject: [U2] help with multivalue and when I am querying a file with multivalued fields but I am not getting a precise enough selection. I want to find only those records where the multivalues for two separate fields meet the criteria within the same index. The file is the order-log file. There is only one record for each order number but within that record there is an activity log stored in multivalued fields. My desire is to construct (using uniobjects for java) a list command that returns a list of ids where the transaction matches. In this case I want to see only those records where action = PCK and act.date = (today). Here is my query: list order-log when action=pck and when act.date=10/11/05 id.supp hdr.supp col.hdr.supp count.sup @id fmt 132l What I get as a result of this is a record where there is a action of PCK and there is a act.date of 10/11/05 but these are not the record. Here is sample of one of those records. LIST ORDER-LOG 100TU093370 ACTION ACT.DATE ACT.TIME REF.NUM 07:44:50 Oct 11 2005 1 ORDER-LOG. Code Act Date Time Reference Number 100TU09337 C09/09/05 10:37 CALL IN ORDER 0 FUT 09/13/05 18:17 D3660RFBLMSS FUT 09/19/05 18:16 D2.5X18STUD FUT 09/21/05 18:37 D3660NASBRGMSS FUT 09/21/05 18:37 TDW3660BLKIT ALC 10/03/05 09:41 TDW3660BLKIT PCK 10/04/05 09:23 TU093370-1 Whse TUL SAV 10/11/05 06:52 TU093370-1 No Update Through RCE PAK 10/11/05 06:52 TU093370-1 1 record listed As you can see the PCK occurred on 10/04 and the SAV occurred on 10/11. I need a list of records where there is a PCK on 10/11. Any suggestions? Thanks. Jeff --- 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] help with multivalue and when
This is only a stab... if you make field 7 the name of a phrase, say ACT.ACT, for the dict item, with the phrase being in the same dict as PH ACTION ACT.DTE then do the same query? On 10/11/05, Jeff Powell [EMAIL PROTECTED] wrote: I am querying a file with multivalued fields but I am not getting a precise enough selection. I want to find only those records where the multivalues for two separate fields meet the criteria within the same index. The file is the order-log file. There is only one record for each order number but within that record there is an activity log stored in multivalued fields. My desire is to construct (using uniobjects for java) a list command that returns a list of ids where the transaction matches. In this case I want to see only those records where action = PCK and act.date = (today). Here is my query: list order-log when action=pck and when act.date=10/11/05 id.supp hdr.supp col.hdr.supp count.sup @id fmt 132l What I get as a result of this is a record where there is a action of PCK and there is a act.date of 10/11/05 but these are not the record. Here is sample of one of those records. LIST ORDER-LOG 100TU093370 ACTION ACT.DATE ACT.TIME REF.NUM 07:44:50 Oct 11 2005 1 ORDER-LOG. Code Act Date Time Reference Number 100TU09337 C09/09/05 10:37 CALL IN ORDER 0 FUT 09/13/05 18:17 D3660RFBLMSS FUT 09/19/05 18:16 D2.5X18STUD FUT 09/21/05 18:37 D3660NASBRGMSS FUT 09/21/05 18:37 TDW3660BLKIT ALC 10/03/05 09:41 TDW3660BLKIT PCK 10/04/05 09:23 TU093370-1 Whse TUL SAV 10/11/05 06:52 TU093370-1 No Update Through RCE PAK 10/11/05 06:52 TU093370-1 1 record listed As you can see the PCK occurred on 10/04 and the SAV occurred on 10/11. I need a list of records where there is a PCK on 10/11. Any suggestions? Thanks. Jeff --- 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] help with multivalue and when
U2 is not a database. UniData or UniVerse ? On UniData try HELP WHEN and look at the explanation of the ASSOCIATED keyword I think you're looking for WHEN ASSOCIATED action = PCK AND act.date = (today) but you need to make sure the file dictionary is correctly set up also only works in ECLTYPE U Piers -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jeff Powell Sent: 11 October 2005 14:02 To: u2 users group Subject: [U2] help with multivalue and when --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] help with multivalue and when
Jeff Powell wrote: I am querying a file with multivalued fields but I am not getting a precise enough selection. I want to find only those records where the multivalues for two separate fields meet the criteria within the same index. The file is the order-log file. There is only one record for each order number but within that record there is an activity log stored in multivalued fields. My desire is to construct (using uniobjects for java) a list command that returns a list of ids where the transaction matches. In this case I want to see only those records where action = PCK and act.date = (today). Here is my query: list order-log when action=pck and when act.date=10/11/05 id.supp hdr.supp col.hdr.supp count.sup @id fmt 132l Try list order-log when ( action=pck and act.date=10/11/05 ) ... and make sure action and act.date are formally associated. ( Not tested ) hth -- mats --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] help with multivalue and when
Jeff: If you don't have the usual U2 dictionary types (you have Pick S/A types) try: LIST ORDER-LOG BY-EXP ACTION = pck BY-EXP ACT.DATE = 10/11/05 . That should do the trick. Hope this helps. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Powell Sent: Tuesday, October 11, 2005 6:02 AM To: u2 users group Subject: [U2] help with multivalue and when I am querying a file with multivalued fields but I am not getting a precise enough selection. I want to find only those records where the multivalues for two separate fields meet the criteria within the same index. The file is the order-log file. There is only one record for each order number but within that record there is an activity log stored in multivalued fields. My desire is to construct (using uniobjects for java) a list command that returns a list of ids where the transaction matches. In this case I want to see only those records where action = PCK and act.date = (today). Here is my query: list order-log when action=pck and when act.date=10/11/05 id.supp hdr.supp col.hdr.supp count.sup @id fmt 132l What I get as a result of this is a record where there is a action of PCK and there is a act.date of 10/11/05 but these are not the record. Here is sample of one of those records. LIST ORDER-LOG 100TU093370 ACTION ACT.DATE ACT.TIME REF.NUM 07:44:50 Oct 11 2005 1 ORDER-LOG. Code Act Date Time Reference Number 100TU09337 C09/09/05 10:37 CALL IN ORDER 0 FUT 09/13/05 18:17 D3660RFBLMSS FUT 09/19/05 18:16 D2.5X18STUD FUT 09/21/05 18:37 D3660NASBRGMSS FUT 09/21/05 18:37 TDW3660BLKIT ALC 10/03/05 09:41 TDW3660BLKIT PCK 10/04/05 09:23 TU093370-1 Whse TUL SAV 10/11/05 06:52 TU093370-1 No Update Through RCE PAK 10/11/05 06:52 TU093370-1 1 record listed As you can see the PCK occurred on 10/04 and the SAV occurred on 10/11. I need a list of records where there is a PCK on 10/11. Any suggestions? Thanks. Jeff --- 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] help with multivalue and when
WITH selects records. WHEN only suppresses display of multivalued fields that do not meet your selection criteria. UniVerse/SQL makes this clearer, since you must specify both the selection clause and the suppression clause. You can do this with LIST as well. LIST filename field_list WITH condition WHEN condition. AND WHEN doesn't accomplish anything. But you can use two WHEN phrases. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help!
Dana: It's now Sunday, so hopefully Wally Terhune and U2 support helped you get your system back up and healthy. Off the top of my head, you may run into issues with the following: You may have to re-catalog any programs that were in the global catalog table. Of course, determining what the programs are will also be a problem If there were any symbolic links in @UDTHOME, you will need to re-create them. These links are used with the LOGTO command. If you used them, you will need to re-build the uniapi server and database tables. It might be a good idea to search through your voc files for any references to @UDTHOME or unidata paths. They should still work, but I would check them anyway. Good luck! Charlie Rubeor Unix/Database Admin The Wiremold Company 800.338.1315 x3498 860.523.3690 fax --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help!
It's now Sunday, so hopefully Wally Terhune and U2 support helped you get your system back up and healthy. Greetings, Thanks to everyone for their support, moral and technical, throughout this ordeal. The U2 support folks were GREAT!, especially Paul Chang and Jim Abshire. I'm not out of the woods yet, but I'm in much better shape now than yesterday at this time! Some things that helped: I ran a sys_check after the first crash, which saved a lot of important information in a .html file Almost all of my Unidata install was on a separate disk which was unaffected by the crash After the second crash, we saw where we were headed and had everyone start preparing for the worst while the system was available And excellent support from both IBM (UniData) and HP (the OS) Some things I still have to figure out: Print queues seem to be set up correctly, but they're not printing (jobs hang in the queue) We're running on a 40-user 30-day temporary license. Gotta fix that Monday. Our normal login routines aren't working. (see below) And I have to rebuild a lot of OS startup files, etc Login procedure problem: We used to point user logins to a udt startup script by naming it as the shell in /etc/passwd. So, for example, a user name TEST would have as the default shell in /etc/password something like /unidata/local/bin/udtlogin. That script would set UDTBIN, UDTHOME, etc then cd to the unidata account directory, then start unidata. The advantage of this is that the user never gets to the Unix command prompt. When they leave Unidata, their session goes away. It doesn't work now for some reason. It never goes into Unidata. Instead the session starts up then ends abruptly. OK, back to work I go. Dana Baron System Manager Smugglers' Notch Resort --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help!
JOLT may be better than coffee for Sunday :-( -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dana Baron Sent: Saturday, 13 August 2005 10:17 PM To: U2-Users (E-mail) Subject: [U2] Help! Hi folks, Here's your worst nightmare come true: your production system crashes with a bad system disk. You find that the backups you've been doing every day don't backup the system, only the data. Now you have to get up and running - fast. Well, that's where I'm sitting right now. I think I'm going to need some help from UniData, but it may be hard to reach them on a Saturday so I thought I'd try the list. Here's what I have: There is a new hard disk in the system. I'm installing a clean OS (Tru64 Unix) right now. The data, including most of the Unidata install, is on a disk array and appears to be safe for now. After the OS install finishes, I need to get UniData up and running. One component I will be missing is the stuff in /usr/ud511, which includes udtconfig. Anything else I might need? Anyone know where I can get a good udtconfig for this? I have the UniData CD, but I don't want to re-install this unless I have to. Thanks in advance. I am a most embarrassed... Dana Baron System Manager Smugglers' Notch Resort --- 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] Help!
Call 800-729-3553 (U2 Support phone number) and tell them you have a down system. U2 support is staffed 24X7 for stuff like this. We'll say a prayer too. Hope it goes a well as possible considering the circumstances. Steve Stephen M. O'Neal, CDP IBM U2 Certified Services Sales Specialist North America U2 Lab Services Information Management, IBM Software Group 303.471.8227 [EMAIL PROTECTED] Ross Ferris [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/13/2005 09:23 AM Please respond to u2-users To u2-users@listserver.u2ug.org cc Subject RE: [U2] Help! JOLT may be better than coffee for Sunday :-( -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dana Baron Sent: Saturday, 13 August 2005 10:17 PM To: U2-Users (E-mail) Subject: [U2] Help! Hi folks, Here's your worst nightmare come true: your production system crashes with a bad system disk. You find that the backups you've been doing every day don't backup the system, only the data. Now you have to get up and running - fast. Well, that's where I'm sitting right now. I think I'm going to need some help from UniData, but it may be hard to reach them on a Saturday so I thought I'd try the list. Here's what I have: There is a new hard disk in the system. I'm installing a clean OS (Tru64 Unix) right now. The data, including most of the Unidata install, is on a disk array and appears to be safe for now. After the OS install finishes, I need to get UniData up and running. One component I will be missing is the stuff in /usr/ud511, which includes udtconfig. Anything else I might need? Anyone know where I can get a good udtconfig for this? I have the UniData CD, but I don't want to re-install this unless I have to. Thanks in advance. I am a most embarrassed... Dana Baron System Manager Smugglers' Notch Resort --- 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/