[U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
Hi all,.. Im getting the below error while running my code,..Can someone please help me with this issue? Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX ,MQS, SOAP or database variable. Code snippet : OSOPEN TEMP.FILE1 TO temp_file1 ELSE STOP CAN Not find file READ DATA FROM temp_file1 ELSE STOP Can not find temp filename Where TEMP.FILE1 is something like Filepath/filename.txt. Its a text file in the server and I want to read the contents and do some comparison. TIA, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
OPENSEQ TEMP.FILE1 to temp_file1 else READSEQ... WRITESEQ CLOSESEQ... On 7 May 2013 16:37, Sathya sathya8...@gmail.com wrote: Hi all,.. Im getting the below error while running my code,..Can someone please help me with this issue? Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX ,MQS, SOAP or database variable. Code snippet : OSOPEN TEMP.FILE1 TO temp_file1 ELSE STOP CAN Not find file READ DATA FROM temp_file1 ELSE STOP Can not find temp filename Where TEMP.FILE1 is something like Filepath/filename.txt. Its a text file in the server and I want to read the contents and do some comparison. TIA, 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] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
Dennis Bartlett dqbartlett at gmail.com writes: OPENSEQ TEMP.FILE1 to temp_file1 else READSEQ... WRITESEQ CLOSESEQ... Hi Dennis,.. Thanks a lot for your help. However let me explain my requirement. I need to open and read a file from the server. That means a text file from a path and not the Unidata file. Can you please let me know how to do it? as Im facing issues with opening the file. Thanks Regards, Sathya V. On 7 May 2013 16:37, Sathya sathya83aa at gmail.com wrote: Hi all,.. Im getting the below error while running my code,..Can someone please help me with this issue? Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX ,MQS, SOAP or database variable. Code snippet : OSOPEN TEMP.FILE1 TO temp_file1 ELSE STOP CAN Not find file READ DATA FROM temp_file1 ELSE STOP Can not find temp filename Where TEMP.FILE1 is something like Filepath/filename.txt. Its a text file in the server and I want to read the contents and do some comparison. TIA, 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@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Fwd: [1] job on LinkedIn
If the employer will sponsor your application it is pretty much a formality (providing you pass security checks that is) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 06 May 2013 17:51 To: u2-users@listserver.u2ug.org Subject: [U2] Fwd: [1] job on LinkedIn Bracknell, looks like its about 20 miles from London (as the crow flies) The job doesn't *state* that you need a work visa, but I assume you would ? Is it difficult to get a permit to work in Britain? -Original Message- From: Rocket Software Group Members group-dige...@linkedin.com To: Will Johnson wjhon...@aol.com Sent: Mon, May 6, 2013 9:42 am Subject: [1] job on LinkedIn Rocket Software May 6, 2013 Job Discussions (1) Epicor Software is looking for Application Support Analyst. Posted by Sharon Small, Recruiter at Epicor Software Corp LikeFlag Stop inappropriate content the moment it is posted. Send me an email for each new discussion Do you know anybody that might like this group? Invite others to join You are receiving Group Digest emails. Unsubscribe. This email was intended for Will Johnson (Pick / Universe BASIC I.T. Analyst at City of Redwood City). Learn why we included this. 2013, LinkedIn Corporation. 2029 Stierlin Ct. Mountain View, CA 94043, USA ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2241 / Virus Database: 3162/5801 - Release Date: 05/05/13 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
Hi back, Here's what I usually do. I create a file record in the voc pointing to that directory and give it D_BP as a dictionary. If that VOC record is named TEMP.FILE; I can then open it in a program and read TEMP.FILE1 as a record from that file. Then every flat file record is a field in your U2 record. Fixed length you have to count, space or other delimiter I use the FIELD within a FOR/NEXT. Dale On 05/07/2013 01:37 AM, Sathya wrote: Hi all,.. Im getting the below error while running my code,..Can someone please help me with this issue? Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX ,MQS, SOAP or database variable. Code snippet : OSOPEN TEMP.FILE1 TO temp_file1 ELSE STOP CAN Not find file READ DATA FROM temp_file1 ELSE STOP Can not find temp filename Where TEMP.FILE1 is something like Filepath/filename.txt. Its a text file in the server and I want to read the contents and do some comparison. TIA, 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, 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] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
I usually: OPENPATH directory of file to temp_filedir else STOP CAN NOT OPEN directory READ FDATA FROM temp_filedir,filename ELSE STOP CAN NOT READ filedir But creating a VOC file entry: 0001: F 0002: directory of file 0003: D_BP Also works. If you get errors opening the file (esp on unix), it is most like a unix user Permissions issue. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley Sent: Tuesday, May 07, 2013 7:37 AM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. Hi back, Here's what I usually do. I create a file record in the voc pointing to that directory and give it D_BP as a dictionary. If that VOC record is named TEMP.FILE; I can then open it in a program and read TEMP.FILE1 as a record from that file. Then every flat file record is a field in your U2 record. Fixed length you have to count, space or other delimiter I use the FIELD within a FOR/NEXT. Dale On 05/07/2013 01:37 AM, Sathya wrote: Hi all,.. Im getting the below error while running my code,..Can someone please help me with this issue? Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX ,MQS, SOAP or database variable. Code snippet : OSOPEN TEMP.FILE1 TO temp_file1 ELSE STOP CAN Not find file READ DATA FROM temp_file1 ELSE STOP Can not find temp filename Where TEMP.FILE1 is something like Filepath/filename.txt. Its a text file in the server and I want to read the contents and do some comparison. TIA, 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..
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] Relative Path for SET.INDEX in Universe
Tried it at 10.3.9 and there were some problems. I don't recall exactly what it was but I had to revert back to absolute pathing. Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls Sent: Monday, May 06, 2013 1:59 PM To: 'U2 Users List' Subject: [U2] Relative Path for SET.INDEX in Universe I was told, at one point, that it was possible to use a relative path in the SET.INDEX command for UV. If anyone knows that syntax, please advise! Thanks, Rick Nuckolls Lynden Inc ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SB and Printers
Hi everyone, I have not used the printer admin parts of SB very much. I have a customer trying to set up printers in SB but when he runs a report (/ARD type) and uses 'P' to go to the printer he gets this message about the printer not being 'started'. Anyone know what step we missed? Screen shot below if you can see it. Basically it's the SB Print Manager window, then centered on the bottom row 'THIS PRINTER IS NOT STARTED'. Susan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Relative Path for SET.INDEX in Universe
Has anyone else used relative paths for Universe indexes? Perry, if you remember what problems you had, please get back to me! Thanks, Rick On May 7, 2013, at 6:38 AM, Perry Taylor perry.tay...@zirmed.com wrote: Tried it at 10.3.9 and there were some problems. I don't recall exactly what it was but I had to revert back to absolute pathing. Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls Sent: Monday, May 06, 2013 1:59 PM To: 'U2 Users List' Subject: [U2] Relative Path for SET.INDEX in Universe I was told, at one point, that it was possible to use a relative path in the SET.INDEX command for UV. If anyone knows that syntax, please advise! Thanks, Rick Nuckolls Lynden Inc ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org 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 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] SB and Printers
Hi susan, After defining the sbprinter into /ADMIN Printers Term Printer Mng Physical Prn Defn You must start it into /ADMIN Printers Term Printer Mng Maintain Printers Then you add the sb physical printer in the table. Then f2. !! on UV/unix, At f2, SB+ will try to add the printer on sp.config and restart uvspoold via usa commands. You must be root to add a sbprinter. !! on UV/Windows, there is no uvspoold ; but you need to add your sb+printers into the list. (not sure about the sb's actions on Udt/ux~win) SB+ store the table into DMSECURITY PRINTERS.STARTED ; the list of started printers ... SB Print Manager use it to check if the printer is started. I hope this help Manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Susan Joslyn Envoyé : mardi 7 mai 2013 17:19 À : sjos...@sjplus.com; u2-users@listserver.u2ug.org Objet : Re: [U2] SB and Printers Hi everyone, I have not used the printer admin parts of SB very much. I have a customer trying to set up printers in SB but when he runs a report (/ARD type) and uses 'P' to go to the printer he gets this message about the printer not being 'started'. Anyone know what step we missed? Screen shot below if you can see it. Basically it's the SB Print Manager window, then centered on the bottom row 'THIS PRINTER IS NOT STARTED'. Susan ___ 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] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
Wjhonson wjhonson at aol.com writes: Satya the OSOPEN command.. what version of the system are you running? Hi,. Thanks everyone for the suggestions and I have sorted out the issue. Now I want to write some dollar values to a file. But the format in which it is in the file is XXX.XX, but I need to write it as X. Without the decimals the simple numbers. Can some help me in doing so. Thanks Regards, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
Use OCONV and ICONV and the MD (Move Decimal) type. Ex. NODEC=ICONV(WITHDEC,MD2) ICONV - moves decimal to the right OCONV - moves decimal to the left MD# - where # is the number of decimal places to move. George -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 1:04 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. Wjhonson wjhonson at aol.com writes: Satya the OSOPEN command.. what version of the system are you running? Hi,. Thanks everyone for the suggestions and I have sorted out the issue. Now I want to write some dollar values to a file. But the format in which it is in the file is XXX.XX, but I need to write it as X. Without the decimals the simple numbers. Can some help me in doing so. Thanks Regards, 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] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
Type HELP BASIC ICONV at the command prompt. You'll see examples of decimal conversions on the 4th page down. Use ICONV to remove the decimal from a number prior to writing to a file. Use OCONV to add the decimal to a number prior to displaying. -John -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 10:04 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP,XML, SCTX , MQS, SOAP or database variable. Wjhonson wjhonson at aol.com writes: Satya the OSOPEN command.. what version of the system are you running? Hi,. Thanks everyone for the suggestions and I have sorted out the issue. Now I want to write some dollar values to a file. But the format in which it is in the file is XXX.XX, but I need to write it as X. Without the decimals the simple numbers. Can some help me in doing so. Thanks Regards, 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] SB and Printers
Manu, Thank you so much! Susan -Original Message- From: Manu Fernandes [mailto:e...@infodata.lu] Sent: Tuesday, May 07, 2013 12:41 PM To: sjos...@sjplus.com; U2 Users List Subject: RE: [U2] SB and Printers Hi susan, After defining the sbprinter into /ADMIN Printers Term Printer Mng Physical Prn Defn You must start it into /ADMIN Printers Term Printer Mng Maintain Printers Then you add the sb physical printer in the table. Then f2. !! on UV/unix, At f2, SB+ will try to add the printer on sp.config and restart uvspoold via usa commands. You must be root to add a sbprinter. !! on UV/Windows, there is no uvspoold ; but you need to add your sb+printers into the list. (not sure about the sb's actions on Udt/ux~win) SB+ store the table into DMSECURITY PRINTERS.STARTED ; the list of started printers ... SB Print Manager use it to check if the printer is started. I hope this help Manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Susan Joslyn Envoyé : mardi 7 mai 2013 17:19 À : sjos...@sjplus.com; u2-users@listserver.u2ug.org Objet : Re: [U2] SB and Printers Hi everyone, I have not used the printer admin parts of SB very much. I have a customer trying to set up printers in SB but when he runs a report (/ARD type) and uses 'P' to go to the printer he gets this message about the printer not being 'started'. Anyone know what step we missed? Screen shot below if you can see it. Basically it's the SB Print Manager window, then centered on the bottom row 'THIS PRINTER IS NOT STARTED'. Susan ___ 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] FYI off topic
Dont throw away those flat screens when they die. I fixed one today, 30 minutes and 5 capacitors on the output power supply. They seem to be made with under rated caps. So far since last year i've fixed 9 flat screen monitors, all capacitors in the output power supply. I've change the caps but up'd the rated voltage on each so if it 470uf 10v, i put in a 470uf at 25v. Easier than fixing tube monitors, takes about 30 minutes. Nice side job in the future, everyone will have a couple. Robert ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FYI off topic
Hi Robert, Are you talking about LCD monitors or LCD/plasma TVs? Charlie On 05-07-2013 4:05 PM, Robert Frailey wrote: Dont throw away those flat screens when they die. I fixed one today, 30 minutes and 5 capacitors on the output power supply. They seem to be made with under rated caps. So far since last year i've fixed 9 flat screen monitors, all capacitors in the output power supply. I've change the caps but up'd the rated voltage on each so if it 470uf 10v, i put in a 470uf at 25v. Easier than fixing tube monitors, takes about 30 minutes. Nice side job in the future, everyone will have a couple. Robert ___ 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] FYI off topic
Were these capacitors visibly bulging on top? The story goes that a few years ago, a cap provider in China got their mix wrong for the dielectric, and tens of thousands (maybe more) of these caps got put in all kinds of devices. They didn't fail immediately, but a well after the warranty had run out. On Tue, 7 May 2013, Robert Frailey wrote: Dont throw away those flat screens when they die. I fixed one today, 30 minutes and 5 capacitors on the output power supply. They seem to be made with under rated caps. So far since last year i've fixed 9 flat screen monitors, all capacitors in the output power supply. I've change the caps but up'd the rated voltage on each so if it 470uf 10v, i put in a 470uf at 25v. Easier than fixing tube monitors, takes about 30 minutes. Nice side job in the future, everyone will have a couple. Robert ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FYI off topic
LCD - Original Message - From: Charlie Noah cwn...@comcast.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, May 07, 2013 3:10 PM Subject: Re: [U2] FYI off topic Hi Robert, Are you talking about LCD monitors or LCD/plasma TVs? Charlie On 05-07-2013 4:05 PM, Robert Frailey wrote: Dont throw away those flat screens when they die. I fixed one today, 30 minutes and 5 capacitors on the output power supply. They seem to be made with under rated caps. So far since last year i've fixed 9 flat screen monitors, all capacitors in the output power supply. I've change the caps but up'd the rated voltage on each so if it 470uf 10v, i put in a 470uf at 25v. Easier than fixing tube monitors, takes about 30 minutes. Nice side job in the future, everyone will have a couple. Robert ___ 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] FYI off topic
sounds about right, most caps the cover was shrinking due to overheating, the one today was a 1000uf ar 10 volts, the top wrap was sightly pulling away. The screen had not totally failed but had a 60hrz ripple running to to bottom. most of the caps looked good but I changed all the output, isolated side to be safe. Screen looks great now Robert - Original Message - From: Bob Rasmussen r...@anzio.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, May 07, 2013 3:17 PM Subject: Re: [U2] FYI off topic Were these capacitors visibly bulging on top? The story goes that a few years ago, a cap provider in China got their mix wrong for the dielectric, and tens of thousands (maybe more) of these caps got put in all kinds of devices. They didn't fail immediately, but a well after the warranty had run out. On Tue, 7 May 2013, Robert Frailey wrote: Dont throw away those flat screens when they die. I fixed one today, 30 minutes and 5 capacitors on the output power supply. They seem to be made with under rated caps. So far since last year i've fixed 9 flat screen monitors, all capacitors in the output power supply. I've change the caps but up'd the rated voltage on each so if it 470uf 10v, i put in a 470uf at 25v. Easier than fixing tube monitors, takes about 30 minutes. Nice side job in the future, everyone will have a couple. Robert ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA ___ 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] FYI off topic
Better be careful, the division of stopping people from fixing things will be after you! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Frailey Sent: Tuesday, May 07, 2013 5:34 PM To: U2 Users List Subject: Re: [U2] FYI off topic sounds about right, most caps the cover was shrinking due to overheating, the one today was a 1000uf ar 10 volts, the top wrap was sightly pulling away. The screen had not totally failed but had a 60hrz ripple running to to bottom. most of the caps looked good but I changed all the output, isolated side to be safe. Screen looks great now Robert - Original Message - From: Bob Rasmussen r...@anzio.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, May 07, 2013 3:17 PM Subject: Re: [U2] FYI off topic Were these capacitors visibly bulging on top? The story goes that a few years ago, a cap provider in China got their mix wrong for the dielectric, and tens of thousands (maybe more) of these caps got put in all kinds of devices. They didn't fail immediately, but a well after the warranty had run out. On Tue, 7 May 2013, Robert Frailey wrote: Dont throw away those flat screens when they die. I fixed one today, 30 minutes and 5 capacitors on the output power supply. They seem to be made with under rated caps. So far since last year i've fixed 9 flat screen monitors, all capacitors in the output power supply. I've change the caps but up'd the rated voltage on each so if it 470uf 10v, i put in a 470uf at 25v. Easier than fixing tube monitors, takes about 30 minutes. Nice side job in the future, everyone will have a couple. Robert ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA ___ 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] FYI off topic
If everyone learned how to fix something, and did it a couple days every week. Maybe we wouldn't throw so much away. Fixing things is how I relax, I hate computers after work. I won't throw something away if it still has value and I can fix it. Rob - Original Message - From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, May 07, 2013 3:36 PM Subject: Re: [U2] FYI off topic Better be careful, the division of stopping people from fixing things will be after you! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Frailey Sent: Tuesday, May 07, 2013 5:34 PM To: U2 Users List Subject: Re: [U2] FYI off topic sounds about right, most caps the cover was shrinking due to overheating, the one today was a 1000uf ar 10 volts, the top wrap was sightly pulling away. The screen had not totally failed but had a 60hrz ripple running to to bottom. most of the caps looked good but I changed all the output, isolated side to be safe. Screen looks great now Robert - Original Message - From: Bob Rasmussen r...@anzio.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, May 07, 2013 3:17 PM Subject: Re: [U2] FYI off topic Were these capacitors visibly bulging on top? The story goes that a few years ago, a cap provider in China got their mix wrong for the dielectric, and tens of thousands (maybe more) of these caps got put in all kinds of devices. They didn't fail immediately, but a well after the warranty had run out. On Tue, 7 May 2013, Robert Frailey wrote: Dont throw away those flat screens when they die. I fixed one today, 30 minutes and 5 capacitors on the output power supply. They seem to be made with under rated caps. So far since last year i've fixed 9 flat screen monitors, all capacitors in the output power supply. I've change the caps but up'd the rated voltage on each so if it 470uf 10v, i put in a 470uf at 25v. Easier than fixing tube monitors, takes about 30 minutes. Nice side job in the future, everyone will have a couple. Robert ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA ___ 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] FYI off topic
I know some people who fix a stiff drink after work. That relaxes them as well (or better). On Tue, 7 May 2013, Robert Frailey wrote: If everyone learned how to fix something, and did it a couple days every week. Maybe we wouldn't throw so much away. Fixing things is how I relax, I hate computers after work. I won't throw something away if it still has value and I can fix it. Rob - Original Message - From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, May 07, 2013 3:36 PM Subject: Re: [U2] FYI off topic Better be careful, the division of stopping people from fixing things will be after you! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Frailey Sent: Tuesday, May 07, 2013 5:34 PM To: U2 Users List Subject: Re: [U2] FYI off topic sounds about right, most caps the cover was shrinking due to overheating, the one today was a 1000uf ar 10 volts, the top wrap was sightly pulling away. The screen had not totally failed but had a 60hrz ripple running to to bottom. most of the caps looked good but I changed all the output, isolated side to be safe. Screen looks great now Robert - Original Message - From: Bob Rasmussen r...@anzio.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, May 07, 2013 3:17 PM Subject: Re: [U2] FYI off topic Were these capacitors visibly bulging on top? The story goes that a few years ago, a cap provider in China got their mix wrong for the dielectric, and tens of thousands (maybe more) of these caps got put in all kinds of devices. They didn't fail immediately, but a well after the warranty had run out. On Tue, 7 May 2013, Robert Frailey wrote: Dont throw away those flat screens when they die. I fixed one today, 30 minutes and 5 capacitors on the output power supply. They seem to be made with under rated caps. So far since last year i've fixed 9 flat screen monitors, all capacitors in the output power supply. I've change the caps but up'd the rated voltage on each so if it 470uf 10v, i put in a 470uf at 25v. Easier than fixing tube monitors, takes about 30 minutes. Nice side job in the future, everyone will have a couple. Robert ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA ___ 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 Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
if var is XXX.XX ICONV(var,MD2) then OCONV(var,MD0) Dale On 05/07/2013 12:04 PM, Sathya wrote: Wjhonsonwjhonsonat aol.com writes: Satya the OSOPEN command.. what version of the system are you running? Hi,. Thanks everyone for the suggestions and I have sorted out the issue. Now I want to write some dollar values to a file. But the format in which it is in the file is XXX.XX, but I need to write it as X. Without the decimals the simple numbers. Can some help me in doing so. Thanks Regards, 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] FYI off topic
thanks for the heads up! although i make recreations of vintage guitar tube amplifiers it never occurred to me to pop open a monitor and look for bad caps the number one problem with vintage tube amps are the electrolytic caps in the power filter section. the electrolyte drys up (or oozes out) and starts leaking DC into the AC section of the circuit. i have one out in my shop right now that i'm gonna open up tonight! On 5/7/2013 2:05 PM, Robert Frailey wrote: Dont throw away those flat screens when they die. I fixed one today, 30 minutes and 5 capacitors on the output power supply. They seem to be made with under rated caps. So far since last year i've fixed 9 flat screen monitors, all capacitors in the output power supply. I've change the caps but up'd the rated voltage on each so if it 470uf 10v, i put in a 470uf at 25v. Easier than fixing tube monitors, takes about 30 minutes. Nice side job in the future, everyone will have a couple. Robert ___ 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] FYI off topic
ah, yes, the DOSPFFT hate those guys 'NO USER SERVICEABLE PARTS INSIDE yeah. those guys. On 5/7/2013 2:36 PM, George Gallen wrote: Better be careful, the division of stopping people from fixing things will be after you! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Frailey Sent: Tuesday, May 07, 2013 5:34 PM To: U2 Users List Subject: Re: [U2] FYI off topic sounds about right, most caps the cover was shrinking due to overheating, the one today was a 1000uf ar 10 volts, the top wrap was sightly pulling away. The screen had not totally failed but had a 60hrz ripple running to to bottom. most of the caps looked good but I changed all the output, isolated side to be safe. Screen looks great now Robert - Original Message - From: Bob Rasmussen r...@anzio.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, May 07, 2013 3:17 PM Subject: Re: [U2] FYI off topic Were these capacitors visibly bulging on top? The story goes that a few years ago, a cap provider in China got their mix wrong for the dielectric, and tens of thousands (maybe more) of these caps got put in all kinds of devices. They didn't fail immediately, but a well after the warranty had run out. On Tue, 7 May 2013, Robert Frailey wrote: Dont throw away those flat screens when they die. I fixed one today, 30 minutes and 5 capacitors on the output power supply. They seem to be made with under rated caps. So far since last year i've fixed 9 flat screen monitors, all capacitors in the output power supply. I've change the caps but up'd the rated voltage on each so if it 470uf 10v, i put in a 470uf at 25v. Easier than fixing tube monitors, takes about 30 minutes. Nice side job in the future, everyone will have a couple. Robert ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA ___ 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] Manage $ values
Dale: Be careful with this if running UniData. Here are some UDT.OPTIONS documentation: UDT.OPTIONS 56 - U_CONV_BADRETURN Normally, if an OCONV or ICONV conversion fails due to invalid data or an invalid conversion code, UniData returns the input string. In BASICTYPE P, if you turn on UDT.OPTIONS 56, UniData returns an empty string. ON If this option is on, UniData returns an empty string when an OCONV or ICONV conversion fails. Note: For compatibility with most Pick® systems, turn this option on. OFF If this option is off, UniData returns the original string when an OCONV or ICONV conversion fails. I've been bitten by this in the past. :-( Bill - Original Message - *From:* dalekel...@dalewkelleyinc.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 5/7/2013 3:06 PM *Subject:* Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. if var is XXX.XX ICONV(var,MD2) then OCONV(var,MD0) Dale On 05/07/2013 12:04 PM, Sathya wrote: Hi,. Thanks everyone for the suggestions and I have sorted out the issue. Now I want to write some dollar values to a file. But the format in which it is in the file is XXX.XX, but I need to write it as X. Without the decimals the simple numbers. Can some help me in doing so. Thanks Regards, Sathya V. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Manage $ values
On 07/05/13 23:23, Bill Haskett wrote: Dale: Be careful with this if running UniData. Here are some UDT.OPTIONS documentation: UDT.OPTIONS 56 - U_CONV_BADRETURN Normally, if an OCONV or ICONV conversion fails due to invalid data or an invalid conversion code, UniData returns the input string. This is what INFORMATION did. In BASICTYPE P, if you turn on UDT.OPTIONS 56, UniData returns an empty string. ON If this option is on, UniData returns an empty string when an OCONV or ICONV conversion fails. Note: For compatibility with most Pick® systems, turn this option on. This is how - I believe - all systems based on true Pick code behaved. OFF If this option is off, UniData returns the original string when an OCONV or ICONV conversion fails. I've been bitten by this in the past. :-( The option was introduced in UV and UD because the two main codebases (PI and Pick) had these different behaviours. I've got bitten by a similar-but-different behaviour. Dunno how, but I fed a number like 9012 into a date ICONV, and wondered why I got a truly weird result. I think I was trying to convert an internal date for display and got my ICONV and OCONV mixed up ... Bill Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Manage $ values
Bill, I've had a little UniData experience, but nowdays I'm all UniVerse; I'm not sure what happens but hopefully I'd catch it before it went to homeland security. Thanks for the tip. Dale On 05/07/2013 05:23 PM, Bill Haskett wrote: Dale: Be careful with this if running UniData. Here are some UDT.OPTIONS documentation: UDT.OPTIONS 56 - U_CONV_BADRETURN Normally, if an OCONV or ICONV conversion fails due to invalid data or an invalid conversion code, UniData returns the input string. In BASICTYPE P, if you turn on UDT.OPTIONS 56, UniData returns an empty string. ON If this option is on, UniData returns an empty string when an OCONV or ICONV conversion fails. Note: For compatibility with most Pick® systems, turn this option on. OFF If this option is off, UniData returns the original string when an OCONV or ICONV conversion fails. I've been bitten by this in the past. :-( Bill - Original Message - *From:* dalekel...@dalewkelleyinc.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 5/7/2013 3:06 PM *Subject:* Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. if var is XXX.XX ICONV(var,MD2) then OCONV(var,MD0) Dale On 05/07/2013 12:04 PM, Sathya wrote: Hi,. Thanks everyone for the suggestions and I have sorted out the issue. Now I want to write some dollar values to a file. But the format in which it is in the file is XXX.XX, but I need to write it as X. Without the decimals the simple numbers. Can some help me in doing so. Thanks Regards, 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