[U2] OPENSEQ
Please educate me on OPENSEQ. I have some code that is giving me an error. The funny thing is that I stole the code from a working program: The code: 064: FNAME = 'LLV':FNAME:'.XLS' 065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances,FNAME TO OUT.FILE ELSE 066: *OPENSEQ LRGLBRVARS,FNAME TO OUT.FILE ELSE 067: ERRCD = STATUS() 068: GOSUB 900 069: CALL SB.DISP(3,'SFC9667 OPENSEQ Error: ':ERRMSG:' Program is aborting.') 070: GO 071: END If I run it as is ERRCD = 2. If I comment out 65 and uncomment 66 ERRCD = 0. According to manual 2 means: The file does not exist. A 0 means The record does not exist. In my voc file I have an entry for LRGLBRVARS. It looks like this: Top of LRGLBRVARS in VOC, 3 lines, 48 characters. 001: DIR 002: \\led\fs-styl\Public\LrgLbrVariances 003: D_HOLD_ Bottom. What is OPENSEQ looking for and where does it expect it to find it? Thanks. Albert DeWitt, CPIM ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] OPENSEQ
I've never used OPENSEQ on a remote drive like that. I presume you can LIST LRGLBRVARS @ TCL without difficulty right? If so, I would think the OPENSEQ should work with that just fine. May I also presume that you looed at FNAME and a file with that name really does exist in that directory file? On Mon, Aug 5, 2013 at 7:10 AM, Al DeWitt adew...@stylmark.com wrote: Please educate me on OPENSEQ. I have some code that is giving me an error. The funny thing is that I stole the code from a working program: The code: 064: FNAME = 'LLV':FNAME:'.XLS' 065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances,FNAME TO OUT.FILE ELSE 066: *OPENSEQ LRGLBRVARS,FNAME TO OUT.FILE ELSE 067: ERRCD = STATUS() 068: GOSUB 900 069: CALL SB.DISP(3,'SFC9667 OPENSEQ Error: ':ERRMSG:' Program is aborting.') 070: GO 071: END If I run it as is ERRCD = 2. If I comment out 65 and uncomment 66 ERRCD = 0. According to manual 2 means: The file does not exist. A 0 means The record does not exist. In my voc file I have an entry for LRGLBRVARS. It looks like this: Top of LRGLBRVARS in VOC, 3 lines, 48 characters. 001: DIR 002: \\led\fs-styl\Public\LrgLbrVariances 003: D_HOLD_ Bottom. What is OPENSEQ looking for and where does it expect it to find it? Thanks. Albert DeWitt, CPIM ___ 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] OPENSEQ
I'm pretty sure Universe can open windows SMB drives, but I don't know that I ever tried it with other MV systems. Keep in mind the most important thing about windows SMB drive shares: unless you are logged into the desktop, it doesn't automatically map them. You may need to issue a net use command to authenticate the share (or set it up within windows so that authentication is not needed.) *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Mon, Aug 5, 2013 at 9:31 AM, Kevin King ke...@precisonline.com wrote: I've never used OPENSEQ on a remote drive like that. I presume you can LIST LRGLBRVARS @ TCL without difficulty right? If so, I would think the OPENSEQ should work with that just fine. May I also presume that you looed at FNAME and a file with that name really does exist in that directory file? On Mon, Aug 5, 2013 at 7:10 AM, Al DeWitt adew...@stylmark.com wrote: Please educate me on OPENSEQ. I have some code that is giving me an error. The funny thing is that I stole the code from a working program: The code: 064: FNAME = 'LLV':FNAME:'.XLS' 065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances,FNAME TO OUT.FILE ELSE 066: *OPENSEQ LRGLBRVARS,FNAME TO OUT.FILE ELSE 067: ERRCD = STATUS() 068: GOSUB 900 069: CALL SB.DISP(3,'SFC9667 OPENSEQ Error: ':ERRMSG:' Program is aborting.') 070: GO 071: END If I run it as is ERRCD = 2. If I comment out 65 and uncomment 66 ERRCD = 0. According to manual 2 means: The file does not exist. A 0 means The record does not exist. In my voc file I have an entry for LRGLBRVARS. It looks like this: Top of LRGLBRVARS in VOC, 3 lines, 48 characters. 001: DIR 002: \\led\fs-styl\Public\LrgLbrVariances 003: D_HOLD_ Bottom. What is OPENSEQ looking for and where does it expect it to find it? Thanks. Albert DeWitt, CPIM ___ 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] OPENSEQ
If you have LRGLBRVARS as a VOC pointer and can LIST LRGLBRVARS then OPENSEQ 'LRGLBRVARS',FNAME TO OUT.FILE ELSE NULL should do it if you know it is present (if the XLS is open with Excel you will usually get an abort) Although I personally would check it is actually there via normal read syntax first OPEN 'LRGLBRVARS' TO LRGLBRVARS ELSE STOP 201,'LRGLBRVARS' READ CHECKITSTHERE FROM LRGLBRVARS,FNAME ELSE STOP 201,FNAME - Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. - -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: 05 August 2013 14:31 To: U2 Users List Subject: Re: [U2] OPENSEQ I've never used OPENSEQ on a remote drive like that. I presume you can LIST LRGLBRVARS @ TCL without difficulty right? If so, I would think the OPENSEQ should work with that just fine. May I also presume that you looked at FNAME and a file with that name really does exist in that directory file? On Mon, Aug 5, 2013 at 7:10 AM, Al DeWitt adew...@stylmark.com wrote: Please educate me on OPENSEQ. I have some code that is giving me an error. The funny thing is that I stole the code from a working program: The code: 064: FNAME = 'LLV':FNAME:'.XLS' 065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances,FNAME TO OUT.FILE ELSE 066: *OPENSEQ LRGLBRVARS,FNAME TO OUT.FILE ELSE 067: ERRCD = STATUS() 068: GOSUB 900 069: CALL SB.DISP(3,'SFC9667 OPENSEQ Error: ':ERRMSG:' Program is aborting.') 070: GO 071: END If I run it as is ERRCD = 2. If I comment out 65 and uncomment 66 ERRCD = 0. According to manual 2 means: The file does not exist. A 0 means The record does not exist. In my voc file I have an entry for LRGLBRVARS. It looks like this: Top of LRGLBRVARS in VOC, 3 lines, 48 characters. 001: DIR 002: \\led\fs-styl\Public\LrgLbrVariances 003: D_HOLD_ Bottom. What is OPENSEQ looking for and where does it expect it to find it? Thanks. Albert DeWitt, CPIM This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] OPENSEQ
Spot the spilling miss steak. and that will of course be 202,FNAME - Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. - -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Braid Sent: 05 August 2013 14:48 To: U2 Users List Subject: Re: [U2] OPENSEQ If you have LRGLBRVARS as a VOC pointer and can LIST LRGLBRVARS then OPENSEQ 'LRGLBRVARS',FNAME TO OUT.FILE ELSE NULL should do it if you know it is present (if the XLS is open with Excel you will usually get an abort) Although I personally would check it is actually there via normal read syntax first OPEN 'LRGLBRVARS' TO LRGLBRVARS ELSE STOP 201,'LRGLBRVARS' READ CHECKITSTHERE FROM LRGLBRVARS,FNAME ELSE STOP 201,FNAME - Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. - -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: 05 August 2013 14:31 To: U2 Users List Subject: Re: [U2] OPENSEQ I've never used OPENSEQ on a remote drive like that. I presume you can LIST LRGLBRVARS @ TCL without difficulty right? If so, I would think the OPENSEQ should work with that just fine. May I also presume that you looked at FNAME and a file with that name really does exist in that directory file? On Mon, Aug 5, 2013 at 7:10 AM, Al DeWitt adew...@stylmark.com wrote: Please educate me on OPENSEQ. I have some code that is giving me an error. The funny thing is that I stole the code from a working program: The code: 064: FNAME = 'LLV':FNAME:'.XLS' 065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances,FNAME TO OUT.FILE ELSE 066: *OPENSEQ LRGLBRVARS,FNAME TO OUT.FILE ELSE 067: ERRCD = STATUS() 068: GOSUB 900 069: CALL SB.DISP(3,'SFC9667 OPENSEQ Error: ':ERRMSG:' Program is aborting.') 070: GO 071: END If I run it as is ERRCD = 2. If I comment out 65 and uncomment 66 ERRCD = 0. According to manual 2 means: The file does not exist. A 0 means The record does not exist. In my voc file I have an entry for LRGLBRVARS. It looks like this: Top of LRGLBRVARS in VOC, 3 lines, 48 characters. 001: DIR 002: \\led\fs-styl\Public\LrgLbrVariances 003: D_HOLD_ Bottom. What is OPENSEQ looking for and where does it expect it to find it? Thanks. Albert DeWitt, CPIM This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/xTPlpmVs7T!GX2PQPOmvUnx5AcfplCJVvID731zL8nSDZHbh!LQJTNwGoUldJppTIyW01XaW!eLX405xsHCs!A== to report this email as spam. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] OPENSEQ
I could be wrong, but I seem to recall that OPENSEQ supports two syntaxes Option 1 has 2 arguments: openseq voc.pointer, filename to ... Option 2 has only 1 argument: openseq absolute.path.to.filename to ... Also, if the server where your shared folder resides is not Windows, then filenames will be case sensitive. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Al DeWitt Sent: Monday, August 05, 2013 6:10 AM To: (u2-users@listserver.u2ug.org) Subject: [U2] OPENSEQ Please educate me on OPENSEQ. I have some code that is giving me an error. The funny thing is that I stole the code from a working program: The code: 064: FNAME = 'LLV':FNAME:'.XLS' 065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances,FNAME TO OUT.FILE ELSE 066: *OPENSEQ LRGLBRVARS,FNAME TO OUT.FILE ELSE 067: ERRCD = STATUS() 068: GOSUB 900 069: CALL SB.DISP(3,'SFC9667 OPENSEQ Error: ':ERRMSG:' Program is aborting.') 070: GO 071: END If I run it as is ERRCD = 2. If I comment out 65 and uncomment 66 ERRCD = 0. According to manual 2 means: The file does not exist. A 0 means The record does not exist. In my voc file I have an entry for LRGLBRVARS. It looks like this: Top of LRGLBRVARS in VOC, 3 lines, 48 characters. 001: DIR 002: \\led\fs-styl\Public\LrgLbrVariances 003: D_HOLD_ Bottom. What is OPENSEQ looking for and where does it expect it to find it? Thanks. Albert DeWitt, CPIM ___ 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] OPENSEQ
Thanks for your reply Kevin. I can list LRGLBRVARS at TCL. I put a dummy file inside to prove it. FNAME does not exist. In the code I stole this from the name is created anew each time. It always open the file empty, allows me to populate and close it. However, in this code it's not working. Since we're running SB+/SBClient I thought the '.XLS' extension was causing issues (grasping at straws) but I'm getting the same errors. Albert DeWitt, CPIM Sr. Programmer Analyst Stylmark, Inc. 6536 Main St NE | Minneapolis MN 55432 | USA DD: 763-574-8705 | PH: 763-574-7474 | F: 763-574-1415 adew...@stylmark.com www.stylmark.com Stylmark is a proud member of RDI, ARE, NGA You can now find Stylmark on LinkedIn and Facebook -Original Message- From: Kevin King [mailto:ke...@precisonline.com] Sent: Monday, August 05, 2013 8:31 AM To: U2 Users List Subject: Re: [U2] OPENSEQ I've never used OPENSEQ on a remote drive like that. I presume you can LIST LRGLBRVARS @ TCL without difficulty right? If so, I would think the OPENSEQ should work with that just fine. May I also presume that you looed at FNAME and a file with that name really does exist in that directory file? On Mon, Aug 5, 2013 at 7:10 AM, Al DeWitt adew...@stylmark.com wrote: Please educate me on OPENSEQ. I have some code that is giving me an error. The funny thing is that I stole the code from a working program: The code: 064: FNAME = 'LLV':FNAME:'.XLS' 065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances,FNAME TO OUT.FILE ELSE 066: *OPENSEQ LRGLBRVARS,FNAME TO OUT.FILE ELSE 067: ERRCD = STATUS() 068: GOSUB 900 069: CALL SB.DISP(3,'SFC9667 OPENSEQ Error: ':ERRMSG:' Program is aborting.') 070: GO 071: END If I run it as is ERRCD = 2. If I comment out 65 and uncomment 66 ERRCD = 0. According to manual 2 means: The file does not exist. A 0 means The record does not exist. In my voc file I have an entry for LRGLBRVARS. It looks like this: Top of LRGLBRVARS in VOC, 3 lines, 48 characters. 001: DIR 002: \\led\fs-styl\Public\LrgLbrVariances 003: D_HOLD_ Bottom. What is OPENSEQ looking for and where does it expect it to find it? Thanks. Albert DeWitt, CPIM ___ 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] OPENSEQ
Does the code still fail with the dummy file out there? If not, I'd guess permissions. From: Al DeWitt adew...@stylmark.com To: U2 Users List u2-users@listserver.u2ug.org, Date: 08/05/2013 09:04 AM Subject:Re: [U2] OPENSEQ Sent by:u2-users-boun...@listserver.u2ug.org Thanks for your reply Kevin. I can list LRGLBRVARS at TCL. I put a dummy file inside to prove it. FNAME does not exist. In the code I stole this from the name is created anew each time. It always open the file empty, allows me to populate and close it. However, in this code it's not working. Since we're running SB+/SBClient I thought the '.XLS' extension was causing issues (grasping at straws) but I'm getting the same errors. Albert DeWitt, CPIM Sr. Programmer Analyst Stylmark, Inc. 6536 Main St NE | Minneapolis MN 55432 | USA DD: 763-574-8705 | PH: 763-574-7474 | F: 763-574-1415 adew...@stylmark.com www.stylmark.com Stylmark is a proud member of RDI, ARE, NGA You can now find Stylmark on LinkedIn and Facebook -Original Message- From: Kevin King [mailto:ke...@precisonline.com] Sent: Monday, August 05, 2013 8:31 AM To: U2 Users List Subject: Re: [U2] OPENSEQ I've never used OPENSEQ on a remote drive like that. I presume you can LIST LRGLBRVARS @ TCL without difficulty right? If so, I would think the OPENSEQ should work with that just fine. May I also presume that you looed at FNAME and a file with that name really does exist in that directory file? On Mon, Aug 5, 2013 at 7:10 AM, Al DeWitt adew...@stylmark.com wrote: Please educate me on OPENSEQ. I have some code that is giving me an error. The funny thing is that I stole the code from a working program: The code: 064: FNAME = 'LLV':FNAME:'.XLS' 065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances,FNAME TO OUT.FILE ELSE 066: *OPENSEQ LRGLBRVARS,FNAME TO OUT.FILE ELSE 067: ERRCD = STATUS() 068: GOSUB 900 069: CALL SB.DISP(3,'SFC9667 OPENSEQ Error: ':ERRMSG:' Program is aborting.') 070: GO 071: END If I run it as is ERRCD = 2. If I comment out 65 and uncomment 66 ERRCD = 0. According to manual 2 means: The file does not exist. A 0 means The record does not exist. In my voc file I have an entry for LRGLBRVARS. It looks like this: Top of LRGLBRVARS in VOC, 3 lines, 48 characters. 001: DIR 002: \\led\fs-styl\Public\LrgLbrVariances 003: D_HOLD_ Bottom. What is OPENSEQ looking for and where does it expect it to find it? Thanks. Albert DeWitt, CPIM ___ 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 U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] OPENSEQ
I'm a Domain Admin so permissions is not an issue. I'm going back to the beginning and start over. Maybe I have an issue I'm not seeing. Thanks for all your help. Albert DeWitt, CPIM Sr. Programmer Analyst Stylmark, Inc. 6536 Main St NE | Minneapolis MN 55432 | USA DD: 763-574-8705 | PH: 763-574-7474 | F: 763-574-1415 adew...@stylmark.com www.stylmark.com Stylmark is a proud member of RDI, ARE, NGA You can now find Stylmark on LinkedIn and Facebook -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com Sent: Monday, August 05, 2013 9:10 AM To: U2 Users List Subject: Re: [U2] OPENSEQ Does the code still fail with the dummy file out there? If not, I'd guess permissions. From: Al DeWitt adew...@stylmark.com To: U2 Users List u2-users@listserver.u2ug.org, Date: 08/05/2013 09:04 AM Subject:Re: [U2] OPENSEQ Sent by:u2-users-boun...@listserver.u2ug.org Thanks for your reply Kevin. I can list LRGLBRVARS at TCL. I put a dummy file inside to prove it. FNAME does not exist. In the code I stole this from the name is created anew each time. It always open the file empty, allows me to populate and close it. However, in this code it's not working. Since we're running SB+/SBClient I thought the '.XLS' extension was causing issues (grasping at straws) but I'm getting the same errors. Albert DeWitt, CPIM Sr. Programmer Analyst Stylmark, Inc. 6536 Main St NE | Minneapolis MN 55432 | USA DD: 763-574-8705 | PH: 763-574-7474 | F: 763-574-1415 adew...@stylmark.com www.stylmark.com Stylmark is a proud member of RDI, ARE, NGA You can now find Stylmark on LinkedIn and Facebook -Original Message- From: Kevin King [mailto:ke...@precisonline.com] Sent: Monday, August 05, 2013 8:31 AM To: U2 Users List Subject: Re: [U2] OPENSEQ I've never used OPENSEQ on a remote drive like that. I presume you can LIST LRGLBRVARS @ TCL without difficulty right? If so, I would think the OPENSEQ should work with that just fine. May I also presume that you looed at FNAME and a file with that name really does exist in that directory file? On Mon, Aug 5, 2013 at 7:10 AM, Al DeWitt adew...@stylmark.com wrote: Please educate me on OPENSEQ. I have some code that is giving me an error. The funny thing is that I stole the code from a working program: The code: 064: FNAME = 'LLV':FNAME:'.XLS' 065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances,FNAME TO OUT.FILE ELSE 066: *OPENSEQ LRGLBRVARS,FNAME TO OUT.FILE ELSE 067: ERRCD = STATUS() 068: GOSUB 900 069: CALL SB.DISP(3,'SFC9667 OPENSEQ Error: ':ERRMSG:' Program is aborting.') 070: GO 071: END If I run it as is ERRCD = 2. If I comment out 65 and uncomment 66 ERRCD = 0. According to manual 2 means: The file does not exist. A 0 means The record does not exist. In my voc file I have an entry for LRGLBRVARS. It looks like this: Top of LRGLBRVARS in VOC, 3 lines, 48 characters. 001: DIR 002: \\led\fs-styl\Public\LrgLbrVariances 003: D_HOLD_ Bottom. What is OPENSEQ looking for and where does it expect it to find it? Thanks. Albert DeWitt, CPIM ___ 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 U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ 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] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers
Rocket added an @variable (don't recall the name of it) that tells which call is being made. Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Saturday, August 03, 2013 9:40 AM To: U2 Users List Subject: Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers David, I didn't understand your 1st clause, Now that (from UV10.1) Index-based triggers are officially supported, By index-based triggers, I assume you mean the trick of indexing an I-descriptor that calls a subroutine that updates some other file, which is generally not the sort of thing you expect such a subroutine to do. What is this official support? Did I miss an announcement, a change in the documentation, or a whitepaper? And by support - just to get my hopes up beyond all reason - does that mean they've introduced some mechanism (@variable?) to help distinguish among calls of the subroutine for insert (where indexing calls the subroutine once, to find the new value to index) delete (where indexing calls the subroutine 1x, to find the value to delete), and change (where indexing calls the subroutine 2x, once with the old version of the record, once with the new, to see whether the indexed value has changed and, if so, what to delete, what to add. Distinguishing these has always been tricky for the general case. Hope springs eternal, Chuck On 8/1/2013 12:32 PM, Hona, David wrote: Now that (from UV10.1) Index-based triggers are officially supported, can these replace your SQL-based triggers? These have less functionality and less overhead, but that's the price you have to pay Can't say I had a chance to try it for myself...yet...! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Saturday, 27 July 2013 5:32 AM To: U2 Users List Subject: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers How many people avoid using triggers BECAUSE of the virtual impossibility of using RAID with Triggers? On 7/26/2013 12:33 PM, Phil Walker wrote: I won't be holding my breath Charles ;-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Friday, 26 July 2013 9:22 p.m. To: U2 Users List Subject: Re: [U2] Universe Triggers re. triggers Raid, I could not agree with Phil more. Well said. Come on, Rocket! On 7/19/2013 1:32 AM, Phil Walker wrote: Ken, I am glad you raised the issue about debugging a program with a file which has a trigger attached. I have been on to UV (Vmark/Ardent/IBM/Rocket for ages about fixing this pushing for the ability to be able to step into the trigger code, but at a VERY MINIMUM being able to debug the program and perform the write on the file, and in effect step over the trigger subroutine and carry on debugging. The issue is the trigger subroutine cannot support input, so what UV have done is basically say you are using the debugger so you are inputting debug commands so you will abort. They need to turn this restriction off for debugging so that either of the above two scenarios is supported. In a Microsoft world I can debug anything through the connected world of web/databases etc.. Have had no feedback from UV -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford Sent: Friday, 19 July 2013 9:48 a.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe Triggers Dan, In addition to the other responses you have received, I suggest the following: 1. Have one master file trigger subroutine (globally catalogued) that calls subroutines (locally catalogued) tailored to individual files. This means you don't have to stop and restart Universe when a new trigger is required or a change to an existing one. If the master subroutine changes, you do have to restart Universe. 2. Use a control record that records the subroutine name and state of the trigger for each file having a trigger. 3. Use a program to change the state of a trigger, using the control records in 2 above. 4. Make sure all background processes that have a file with a trigger open are logged out when recompiling the subroutine for that file trigger. 5. Remember that you can't do anything to a file with an active trigger whilst in the RAID debugger (it will crash). Rather, if you are testing a file trigger subroutine, drop the trigger and use a trigger testing program that calls the subroutine after taking a copy of the record being changed, pausing whilst you change it in another session, and then resuming, calling
Re: [U2] OPENSEQ
...Aaaah. If it is NOT there then do this:- OPEN 'LRGLBRVARS' TO LRGLBRVARS ELSE STOP 201,'LRGLBRVARS' WRITE ON LRGLBRVARS,FNAME OPENSEQ 'LRGLBRVARS',FNAME TO OUT.FILE ELSE NULL - Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. - -Original Message- From: Martin Braid Sent: 05 August 2013 14:52 To: U2 Users List Subject: RE: [U2] OPENSEQ Spot the spilling miss steak. and that will of course be 202,FNAME -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Braid Sent: 05 August 2013 14:48 To: U2 Users List Subject: Re: [U2] OPENSEQ If you have LRGLBRVARS as a VOC pointer and can LIST LRGLBRVARS then OPENSEQ 'LRGLBRVARS',FNAME TO OUT.FILE ELSE NULL should do it if you know it is present (if the XLS is open with Excel you will usually get an abort) Although I personally would check it is actually there via normal read syntax first OPEN 'LRGLBRVARS' TO LRGLBRVARS ELSE STOP 201,'LRGLBRVARS' READ CHECKITSTHERE FROM LRGLBRVARS,FNAME ELSE STOP 201,FNAME - Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail and any attachments to it are confidential and is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. - -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: 05 August 2013 14:31 To: U2 Users List Subject: Re: [U2] OPENSEQ I've never used OPENSEQ on a remote drive like that. I presume you can LIST LRGLBRVARS @ TCL without difficulty right? If so, I would think the OPENSEQ should work with that just fine. May I also presume that you looked at FNAME and a file with that name really does exist in that directory file? On Mon, Aug 5, 2013 at 7:10 AM, Al DeWitt adew...@stylmark.com wrote: Please educate me on OPENSEQ. I have some code that is giving me an error. The funny thing is that I stole the code from a working program: The code: 064: FNAME = 'LLV':FNAME:'.XLS' 065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances,FNAME TO OUT.FILE ELSE 066: *OPENSEQ LRGLBRVARS,FNAME TO OUT.FILE ELSE 067: ERRCD = STATUS() 068: GOSUB 900 069: CALL SB.DISP(3,'SFC9667 OPENSEQ Error: ':ERRMSG:' Program is aborting.') 070: GO 071: END If I run it as is ERRCD = 2. If I comment out 65 and uncomment 66 ERRCD = 0. According to manual 2 means: The file does not exist. A 0 means The record does not exist. In my voc file I have an entry for LRGLBRVARS. It looks like this: Top of LRGLBRVARS in VOC, 3 lines, 48 characters. 001: DIR 002: \\led\fs-styl\Public\LrgLbrVariances 003: D_HOLD_ Bottom. What is OPENSEQ looking for and where does it expect it to find it? Thanks. Albert DeWitt, CPIM This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/xTPlpmVs7T!GX2PQPOmvUnx5AcfplCJVvID731zL8nSDZHbh!LQJTNwGoUldJppTIyW01XaW!eLX405xsHCs!A== to report this email as spam.
Re: [U2] OPENSEQ
Can someone point me to the page where we can use DIR type files at all? It would make my job a lot easier! -Original Message- From: Al DeWitt adew...@stylmark.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Aug 5, 2013 7:04 am Subject: Re: [U2] OPENSEQ Thanks for your reply Kevin. I can list LRGLBRVARS at TCL. I put a dummy file inside to prove it. FNAME does not exist. In the code I stole this from the name is created anew each time. It always open the file empty, allows me to populate and close it. However, in this code it's not working. Since we're running SB+/SBClient I thought the '.XLS' extension was causing issues (grasping at straws) but I'm getting the same errors. Albert DeWitt, CPIM Sr. Programmer Analyst Stylmark, Inc. 6536 Main St NE | Minneapolis MN 55432 | USA DD: 763-574-8705 | PH: 763-574-7474 | F: 763-574-1415 adew...@stylmark.com www.stylmark.com Stylmark is a proud member of RDI, ARE, NGA You can now find Stylmark on LinkedIn and Facebook -Original Message- From: Kevin King [mailto:ke...@precisonline.com] Sent: Monday, August 05, 2013 8:31 AM To: U2 Users List Subject: Re: [U2] OPENSEQ I've never used OPENSEQ on a remote drive like that. I presume you can LIST LRGLBRVARS @ TCL without difficulty right? If so, I would think the OPENSEQ should work with that just fine. May I also presume that you looed at FNAME and a file with that name really does exist in that directory file? On Mon, Aug 5, 2013 at 7:10 AM, Al DeWitt adew...@stylmark.com wrote: Please educate me on OPENSEQ. I have some code that is giving me an error. The funny thing is that I stole the code from a working program: The code: 064: FNAME = 'LLV':FNAME:'.XLS' 065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances,FNAME TO OUT.FILE ELSE 066: *OPENSEQ LRGLBRVARS,FNAME TO OUT.FILE ELSE 067: ERRCD = STATUS() 068: GOSUB 900 069: CALL SB.DISP(3,'SFC9667 OPENSEQ Error: ':ERRMSG:' Program is aborting.') 070: GO 071: END If I run it as is ERRCD = 2. If I comment out 65 and uncomment 66 ERRCD = 0. According to manual 2 means: The file does not exist. A 0 means The record does not exist. In my voc file I have an entry for LRGLBRVARS. It looks like this: Top of LRGLBRVARS in VOC, 3 lines, 48 characters. 001: DIR 002: \\led\fs-styl\Public\LrgLbrVariances 003: D_HOLD_ Bottom. What is OPENSEQ looking for and where does it expect it to find it? Thanks. Albert DeWitt, CPIM ___ 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] OPENSEQ
Al:
UniData help shows...
Help Information For: UNIBASIC OPENSEQ
Page: 1/5
OPENSEQ
Syntax
OPENSEQ [absolutepath | seq.filename,record.id] [READONLY] TO seq.file.var
[ON ERROR statements] [LOCKED statements] {THEN statements [END]
| ELSE statements [END]}
OPENSEQ [absolutepath | seq.filename,record.id] [READONLY] TO seq.file.var
[LOCKED statements] [ON ERROR statements] {THEN statements [END]
| ELSE statements [END]}
Description
The UniBasic OPENSEQ command opens a sequential file for access,
starting at the specified record. UniData limits to 150 the number
of sequential files you can open in a UniBasic program.
It would seem your path uses the seq.filename, record.id format
instead of the absolute path format. e.g.
065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances\:FNAME TO
OUT.FILE ELSE
HTH (and fixes it).
Bill
Untitled Page
- Original Message -
*From:* adew...@stylmark.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 8/5/2013 7:17 AM
*Subject:* Re: [U2] OPENSEQ
I'm a Domain Admin so permissions is not an issue. I'm going back to the
beginning and start over. Maybe I have an issue I'm not seeing.
Thanks for all your help.
Albert DeWitt, CPIM
Sr. Programmer Analyst
Stylmark, Inc.
6536 Main St NE | Minneapolis MN 55432 | USA
DD: 763-574-8705 | PH: 763-574-7474 | F: 763-574-1415
adew...@stylmark.com
www.stylmark.com
Stylmark is a proud member of RDI, ARE, NGA
You can now find Stylmark on LinkedIn and Facebook
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
bradley.sch...@usbank.com
Sent: Monday, August 05, 2013 9:10 AM
To: U2 Users List
Subject: Re: [U2] OPENSEQ
Does the code still fail with the dummy file out there? If not, I'd guess
permissions.
From: Al DeWitt adew...@stylmark.com
To: U2 Users List u2-users@listserver.u2ug.org,
Date: 08/05/2013 09:04 AM
Subject:Re: [U2] OPENSEQ
Sent by:u2-users-boun...@listserver.u2ug.org
Thanks for your reply Kevin.
I can list LRGLBRVARS at TCL. I put a dummy file inside to prove it.
FNAME does not exist. In the code I stole this from the name is created
anew each time. It always open the file empty, allows me to populate
and close it. However, in this code it's not working.
Since we're running SB+/SBClient I thought the '.XLS' extension was
causing issues (grasping at straws) but I'm getting the same errors.
Albert DeWitt, CPIM
Sr. Programmer Analyst
Stylmark, Inc.
6536 Main St NE | Minneapolis MN 55432 | USA
DD: 763-574-8705 | PH: 763-574-7474 | F: 763-574-1415
adew...@stylmark.com
www.stylmark.com
Stylmark is a proud member of RDI, ARE, NGA
You can now find Stylmark on LinkedIn and Facebook
-Original Message-
From: Kevin King [mailto:ke...@precisonline.com]
Sent: Monday, August 05, 2013 8:31 AM
To: U2 Users List
Subject: Re: [U2] OPENSEQ
I've never used OPENSEQ on a remote drive like that. I presume you can
LIST LRGLBRVARS @ TCL without difficulty right? If so, I would think the
OPENSEQ should work with that just fine. May I also presume that you
looed at FNAME and a file with that name really does exist in that
directory file?
On Mon, Aug 5, 2013 at 7:10 AM, Al DeWitt adew...@stylmark.com wrote:
Please educate me on OPENSEQ. I have some code that is giving me an
error. The funny thing is that I stole the code from a working program:
The code:
064: FNAME = 'LLV':FNAME:'.XLS'
065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances,FNAME TO
OUT.FILE ELSE
066: *OPENSEQ LRGLBRVARS,FNAME TO OUT.FILE ELSE
067: ERRCD = STATUS()
068: GOSUB 900
069: CALL SB.DISP(3,'SFC9667 OPENSEQ Error: ':ERRMSG:' Program is aborting.')
070: GO
071: END
If I run it as is ERRCD = 2. If I comment out 65 and uncomment 66
ERRCD = 0. According to manual 2 means: The file does not exist. A 0
means The record does not exist.
In my voc file I have an entry for LRGLBRVARS. It looks like this:
Top of LRGLBRVARS in VOC, 3 lines, 48 characters.
001: DIR
002: \\led\fs-styl\Public\LrgLbrVariances
003: D_HOLD_
Bottom.
What is OPENSEQ looking for and where does it expect it to find it?
Thanks.
Albert DeWitt, CPIM
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Pick flavor in U2 personal edition
Thanks, Brian and Will. I got it working. Eric Armstrong Programmer/Analyst Lobel Financial 714-816-1207 direct -- Message: 2 Date: Sun, 4 Aug 2013 11:16:49 +0100 From: Brian Leach br...@brianleach.co.uk To: 'U2 Users List' u2-users@listserver.u2ug.org Subject: Re: [U2] Pick flavor in U2 personal edition Message-ID: 000c01ce90fb$bbac37e0$3304a7a0$@co.uk Content-Type: text/plain; charset=us-ascii Eric The easiest way is to run Universe in a directory that isn't already set up as an account. Start - Run - cmd.exe Then: Cd \parent_for_accounts Mkdir myaccount Cd myaccount \u2\uv\bin\uv This will then pop up asking you to create the account, and the flavor. Choose option 3. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 02 August 2013 21:30 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Pick flavor in U2 personal edition Eric see https://docs.rocketsoftware.com/nxt/gateway.dll/RKB14/universe/103/newinstal l.pdf When you Create an Account it asks for the flavor, or at least allows you to specify the flavor. LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] OPENSEQ
*Falls out of my chair*
What ? What ?
I never knew you could DO this!
After some fiddling about I finally was able to make OPENSEQ open an UNC path.
Of course the one I tried, actually points to the exact same server and account
the code is already running in, but I didn't even know you could OPEN an UNC
path at all before! I've been translating the UNC paths into DOS paths.
Now to try to open remote UNC path
-Original Message-
From: Bill Haskett wphask...@advantos.net
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Mon, Aug 5, 2013 10:05 am
Subject: Re: [U2] OPENSEQ
Al:
UniData help shows...
Help Information For: UNIBASIC OPENSEQ
Page: 1/5
OPENSEQ
Syntax
OPENSEQ [absolutepath | seq.filename,record.id] [READONLY] TO seq.file.var
[ON ERROR statements] [LOCKED statements] {THEN statements [END]
| ELSE statements [END]}
OPENSEQ [absolutepath | seq.filename,record.id] [READONLY] TO seq.file.var
[LOCKED statements] [ON ERROR statements] {THEN statements [END]
| ELSE statements [END]}
Description
The UniBasic OPENSEQ command opens a sequential file for access,
starting at the specified record. UniData limits to 150 the number
of sequential files you can open in a UniBasic program.
It would seem your path uses the seq.filename, record.id format
instead of the absolute path format. e.g.
065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances\:FNAME TO
OUT.FILE ELSE
HTH (and fixes it).
Bill
Untitled Page
- Original Message -
*From:* adew...@stylmark.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 8/5/2013 7:17 AM
*Subject:* Re: [U2] OPENSEQ
I'm a Domain Admin so permissions is not an issue. I'm going back to the
beginning and start over. Maybe I have an issue I'm not seeing.
Thanks for all your help.
Albert DeWitt, CPIM
Sr. Programmer Analyst
Stylmark, Inc.
6536 Main St NE | Minneapolis MN 55432 | USA
DD: 763-574-8705 | PH: 763-574-7474 | F: 763-574-1415
adew...@stylmark.com
www.stylmark.com
Stylmark is a proud member of RDI, ARE, NGA
You can now find Stylmark on LinkedIn and Facebook
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org]
On Behalf Of bradley.sch...@usbank.com
Sent: Monday, August 05, 2013 9:10 AM
To: U2 Users List
Subject: Re: [U2] OPENSEQ
Does the code still fail with the dummy file out there? If not, I'd guess
permissions.
From: Al DeWitt adew...@stylmark.com
To: U2 Users List u2-users@listserver.u2ug.org,
Date: 08/05/2013 09:04 AM
Subject:Re: [U2] OPENSEQ
Sent by:u2-users-boun...@listserver.u2ug.org
Thanks for your reply Kevin.
I can list LRGLBRVARS at TCL. I put a dummy file inside to prove it.
FNAME does not exist. In the code I stole this from the name is created
anew each time. It always open the file empty, allows me to populate
and close it. However, in this code it's not working.
Since we're running SB+/SBClient I thought the '.XLS' extension was
causing issues (grasping at straws) but I'm getting the same errors.
Albert DeWitt, CPIM
Sr. Programmer Analyst
Stylmark, Inc.
6536 Main St NE | Minneapolis MN 55432 | USA
DD: 763-574-8705 | PH: 763-574-7474 | F: 763-574-1415
adew...@stylmark.com
www.stylmark.com
Stylmark is a proud member of RDI, ARE, NGA
You can now find Stylmark on LinkedIn and Facebook
-Original Message-
From: Kevin King [mailto:ke...@precisonline.com]
Sent: Monday, August 05, 2013 8:31 AM
To: U2 Users List
Subject: Re: [U2] OPENSEQ
I've never used OPENSEQ on a remote drive like that. I presume you can
LIST LRGLBRVARS @ TCL without difficulty right? If so, I would think the
OPENSEQ should work with that just fine. May I also presume that you
looed at FNAME and a file with that name really does exist in that
directory file?
On Mon, Aug 5, 2013 at 7:10 AM, Al DeWitt adew...@stylmark.com wrote:
Please educate me on OPENSEQ. I have some code that is giving me an
error. The funny thing is that I stole the code from a working program:
The code:
064: FNAME = 'LLV':FNAME:'.XLS'
065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances,FNAME TO
OUT.FILE ELSE
066: *OPENSEQ LRGLBRVARS,FNAME TO OUT.FILE ELSE
067: ERRCD = STATUS()
068: GOSUB 900
069: CALL SB.DISP(3,'SFC9667 OPENSEQ Error: ':ERRMSG:' Program is
aborting.')
070: GO
071: END
If I run it as is ERRCD = 2. If I comment out 65 and uncomment 66
ERRCD = 0. According to manual 2 means: The file does not exist. A 0
means The record does not exist.
In my voc file I have an entry for LRGLBRVARS. It looks like this:
Top
Re: [U2] OPENSEQ
Remember, if you're using Windows 2008 (Vista Server) or later (I use
2008 R2 - Windows 7 Server) then you have to be careful about how you
share the network directory you want to share.
For testing purposes, if you're using Windows, it may be a good idea to
share the directory to everyone, with full permissions.
Bill
Untitled Page
- Original Message -
*From:* wjhon...@aol.com
*To:* u2-users@listserver.u2ug.org
*Date:* 8/5/2013 10:16 AM
*Subject:* Re: [U2] OPENSEQ
*Falls out of my chair*
What ? What ?
I never knew you could DO this!
After some fiddling about I finally was able to make OPENSEQ open an UNC path.
Of course the one I tried, actually points to the exact same server and account
the code is already running in, but I didn't even know you could OPEN an UNC
path at all before! I've been translating the UNC paths into DOS paths.
Now to try to open remote UNC path
-Original Message-
From: Bill Haskett wphask...@advantos.net
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Mon, Aug 5, 2013 10:05 am
Subject: Re: [U2] OPENSEQ
Al:
UniData help shows...
Help Information For: UNIBASIC OPENSEQ
Page: 1/5
OPENSEQ
Syntax
OPENSEQ [absolutepath | seq.filename,record.id] [READONLY] TO seq.file.var
[ON ERROR statements] [LOCKED statements] {THEN statements [END]
| ELSE statements [END]}
OPENSEQ [absolutepath | seq.filename,record.id] [READONLY] TO seq.file.var
[LOCKED statements] [ON ERROR statements] {THEN statements [END]
| ELSE statements [END]}
Description
The UniBasic OPENSEQ command opens a sequential file for access,
starting at the specified record. UniData limits to 150 the number
of sequential files you can open in a UniBasic program.
It would seem your path uses the seq.filename, record.id format
instead of the absolute path format. e.g.
065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances\:FNAME TO
OUT.FILE ELSE
HTH (and fixes it).
Bill
Untitled Page
- Original Message -
*From:* adew...@stylmark.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 8/5/2013 7:17 AM
*Subject:* Re: [U2] OPENSEQ
I'm a Domain Admin so permissions is not an issue. I'm going back to the
beginning and start over. Maybe I have an issue I'm not seeing.
Thanks for all your help.
Albert DeWitt, CPIM
Sr. Programmer Analyst
Stylmark, Inc.
6536 Main St NE | Minneapolis MN 55432 | USA
DD: 763-574-8705 | PH: 763-574-7474 | F: 763-574-1415
adew...@stylmark.com
www.stylmark.com
Stylmark is a proud member of RDI, ARE, NGA
You can now find Stylmark on LinkedIn and Facebook
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org]
On Behalf Of bradley.sch...@usbank.com
Sent: Monday, August 05, 2013 9:10 AM
To: U2 Users List
Subject: Re: [U2] OPENSEQ
Does the code still fail with the dummy file out there? If not, I'd guess
permissions.
From: Al DeWitt adew...@stylmark.com
To: U2 Users List u2-users@listserver.u2ug.org,
Date: 08/05/2013 09:04 AM
Subject:Re: [U2] OPENSEQ
Sent by:u2-users-boun...@listserver.u2ug.org
Thanks for your reply Kevin.
I can list LRGLBRVARS at TCL. I put a dummy file inside to prove it.
FNAME does not exist. In the code I stole this from the name is created
anew each time. It always open the file empty, allows me to populate
and close it. However, in this code it's not working.
Since we're running SB+/SBClient I thought the '.XLS' extension was
causing issues (grasping at straws) but I'm getting the same errors.
Albert DeWitt, CPIM
Sr. Programmer Analyst
Stylmark, Inc.
6536 Main St NE | Minneapolis MN 55432 | USA
DD: 763-574-8705 | PH: 763-574-7474 | F: 763-574-1415
adew...@stylmark.com
www.stylmark.com
Stylmark is a proud member of RDI, ARE, NGA
You can now find Stylmark on LinkedIn and Facebook
-Original Message-
From: Kevin King [mailto:ke...@precisonline.com]
Sent: Monday, August 05, 2013 8:31 AM
To: U2 Users List
Subject: Re: [U2] OPENSEQ
I've never used OPENSEQ on a remote drive like that. I presume you can
LIST LRGLBRVARS @ TCL without difficulty right? If so, I would think the
OPENSEQ should work with that just fine. May I also presume that you
looed at FNAME and a file with that name really does exist in that
directory file?
On Mon, Aug 5, 2013 at 7:10 AM, Al DeWitt adew...@stylmark.com wrote:
Please educate me on OPENSEQ. I have some code that is giving me an
error. The funny thing is that I stole the code from a working program:
The code:
064: FNAME = 'LLV':FNAME:'.XLS'
065: OPENSEQ
Re: [U2] OPENSEQ
Ummm, if the file doesn't exist then it's *supposed* to take the else clause, when I'm creating new files I use THEN and put the abort in there. When you borrowed this code did it have all of the validation? I don't have my error codes handy - but if you let it continue does it let you do the writeseq? Hth Colin -Original Message- From: Al DeWitt Sent: Monday, August 05, 2013 8:04 AM To: U2 Users List Subject: Re: [U2] OPENSEQ Thanks for your reply Kevin. I can list LRGLBRVARS at TCL. I put a dummy file inside to prove it. FNAME does not exist. In the code I stole this from the name is created anew each time. It always open the file empty, allows me to populate and close it. However, in this code it's not working. Since we're running SB+/SBClient I thought the '.XLS' extension was causing issues (grasping at straws) but I'm getting the same errors. Albert DeWitt, CPIM Sr. Programmer Analyst Stylmark, Inc. -Original Message- From: Kevin King Sent: Monday, August 05, 2013 8:31 AM To: U2 Users List Subject: Re: [U2] OPENSEQ I've never used OPENSEQ on a remote drive like that. I presume you can LIST LRGLBRVARS @ TCL without difficulty right? If so, I would think the OPENSEQ should work with that just fine. May I also presume that you looed at FNAME and a file with that name really does exist in that directory file? On Mon, Aug 5, 2013 at 7:10 AM, Al DeWitt wrote: Please educate me on OPENSEQ. I have some code that is giving me an error. The funny thing is that I stole the code from a working program: The code: 064: FNAME = 'LLV':FNAME:'.XLS' 065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances,FNAME TO OUT.FILE ELSE 066: *OPENSEQ LRGLBRVARS,FNAME TO OUT.FILE ELSE 067: ERRCD = STATUS() 068: GOSUB 900 069: CALL SB.DISP(3,'SFC9667 OPENSEQ Error: ':ERRMSG:' Program is aborting.') 070: GO 071: END If I run it as is ERRCD = 2. If I comment out 65 and uncomment 66 ERRCD = 0. According to manual 2 means: The file does not exist. A 0 means The record does not exist. In my voc file I have an entry for LRGLBRVARS. It looks like this: Top of LRGLBRVARS in VOC, 3 lines, 48 characters. 001: DIR 002: \\led\fs-styl\Public\LrgLbrVariances 003: D_HOLD_ Bottom. What is OPENSEQ looking for and where does it expect it to find it? Thanks. Albert DeWitt, CPIM ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] OPENSEQ
As I mentioned earlier I went back and started over. This is my Top of LRGLBRVARS in VOC, 3 lines, 48 characters. 001: DIR 002: \\ServerName\ShareName\Folder\LrgLbrVariances 003: D_HOLD_ Bottom. My OPENSEQ statement is this: OPENSEQ LRGLBRVARS,FNAME TO OUT.FILE ELSE NULL This opens my previously non-existing file, allows me to write to it and closes it. It does what I want it to. As I mentioned to someone else I have no idea why the above statement worked, but trying to error catching showed an error condition. Go figure. Albert DeWitt, CPIM Sr. Programmer Analyst Stylmark, Inc. 6536 Main St NE | Minneapolis MN 55432 | USA DD: 763-574-8705 | PH: 763-574-7474 | F: 763-574-1415 adew...@stylmark.com www.stylmark.com Stylmark is a proud member of RDI, ARE, NGA You can now find Stylmark on LinkedIn and Facebook -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Alfke Sent: Monday, August 05, 2013 12:32 PM To: 'U2 Users List' Subject: Re: [U2] OPENSEQ Ummm, if the file doesn't exist then it's *supposed* to take the else clause, when I'm creating new files I use THEN and put the abort in there. When you borrowed this code did it have all of the validation? I don't have my error codes handy - but if you let it continue does it let you do the writeseq? Hth Colin -Original Message- From: Al DeWitt Sent: Monday, August 05, 2013 8:04 AM To: U2 Users List Subject: Re: [U2] OPENSEQ Thanks for your reply Kevin. I can list LRGLBRVARS at TCL. I put a dummy file inside to prove it. FNAME does not exist. In the code I stole this from the name is created anew each time. It always open the file empty, allows me to populate and close it. However, in this code it's not working. Since we're running SB+/SBClient I thought the '.XLS' extension was causing issues (grasping at straws) but I'm getting the same errors. Albert DeWitt, CPIM Sr. Programmer Analyst Stylmark, Inc. -Original Message- From: Kevin King Sent: Monday, August 05, 2013 8:31 AM To: U2 Users List Subject: Re: [U2] OPENSEQ I've never used OPENSEQ on a remote drive like that. I presume you can LIST LRGLBRVARS @ TCL without difficulty right? If so, I would think the OPENSEQ should work with that just fine. May I also presume that you looed at FNAME and a file with that name really does exist in that directory file? On Mon, Aug 5, 2013 at 7:10 AM, Al DeWitt wrote: Please educate me on OPENSEQ. I have some code that is giving me an error. The funny thing is that I stole the code from a working program: The code: 064: FNAME = 'LLV':FNAME:'.XLS' 065: OPENSEQ \\SERVER\SHARE-NAME\FOLDER-NAME\LrgLbrVariances,FNAME TO OUT.FILE ELSE 066: *OPENSEQ LRGLBRVARS,FNAME TO OUT.FILE ELSE 067: ERRCD = STATUS() 068: GOSUB 900 069: CALL SB.DISP(3,'SFC9667 OPENSEQ Error: ':ERRMSG:' Program is aborting.') 070: GO 071: END If I run it as is ERRCD = 2. If I comment out 65 and uncomment 66 ERRCD = 0. According to manual 2 means: The file does not exist. A 0 means The record does not exist. In my voc file I have an entry for LRGLBRVARS. It looks like this: Top of LRGLBRVARS in VOC, 3 lines, 48 characters. 001: DIR 002: \\ServerName\ShareName\Folder\LrgLbrVariances 003: D_HOLD_ Bottom. What is OPENSEQ looking for and where does it expect it to find it? Thanks. Albert DeWitt, CPIM ___ 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] Anti-fraud software
Jerry, Yeah, that sort of thing is very specific to the software application itself. Called an 'application control' in the cool crowd (er, auditors). Not much way around it but to code it right into the programs that do the work. SJ Message: 1 Date: Sun, 4 Aug 2013 14:23:37 -0500 From: Jerry mailto:jpb-u...@hotmail.com jpb-u...@hotmail.com To: mailto:u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org Subject: Re: [U2] Anti-fraud software Message-ID: mailto:blu0-smtp46649d718e54e61aa466015cf...@phx.gbl blu0-smtp46649d718e54e61aa466015cf...@phx.gbl Content-Type: text/plain; charset=ISO-8859-1; format=flowed Thanks Susan, Basically what the bosses want is to monitor our clients activity, any deviation from the normal adding and removing customers or raising or lowering of payment amounts. We probably will have to go in house because all of our software is home grown. Jerry ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] OPENSEQ
What you're seeing is the correct behavior of OPENSEQ. I think what's causing the confusion is there are multiple error conditions possible when dealing with opening a flat file for writing. The non-existence of the file prior to opening may or may not be an error depending on your usage scenario, but it is important information, and using an error code along with the ELSE clause is the only way it can be conveyed. If you're writing a per-instance error log, for example, you might choose to loop through OPENSEQ statements and increment the ID until you hit the non-existence condition so you don't overwrite prior logs. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Al DeWitt Sent: Monday, August 05, 2013 11:03 AM To: U2 Users List Subject: Re: [U2] OPENSEQ As I mentioned earlier I went back and started over. This is my Top of LRGLBRVARS in VOC, 3 lines, 48 characters. 001: DIR 002: \\ServerName\ShareName\Folder\LrgLbrVariances 003: D_HOLD_ Bottom. My OPENSEQ statement is this: OPENSEQ LRGLBRVARS,FNAME TO OUT.FILE ELSE NULL This opens my previously non-existing file, allows me to write to it and closes it. It does what I want it to. As I mentioned to someone else I have no idea why the above statement worked, but trying to error catching showed an error condition. Go figure. Albert DeWitt, CPIM Sr. Programmer Analyst Stylmark, Inc. 6536 Main St NE | Minneapolis MN 55432 | USA DD: 763-574-8705 | PH: 763-574-7474 | F: 763-574-1415 adew...@stylmark.com www.stylmark.com Stylmark is a proud member of RDI, ARE, NGA You can now find Stylmark on LinkedIn and Facebook ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pick flavor in U2 personal edition
Dan, Thanks. I downloaded and installed the Extensible Administration Tool it. Do I have to create a new U2 Server in order to use it? Eric Armstrong IT Dept -- Message: 6 Date: Fri, 2 Aug 2013 21:31:58 + From: Daniel McGrath dmcgr...@rocketsoftware.com To: U2 Users List u2-users@listserver.u2ug.org Subject: Re: [U2] Pick flavor in U2 personal edition Message-ID: 8e17b0ffe20e47db8ffcae5d1b91e...@wal-vm-mbx1.rocketsoftware.com Content-Type: text/plain; charset=us-ascii XAdmin, part of our U2 DBTools package: http://www.rocketsoftware.com/products/rocket-u2-clients-and-dbtools/try-now Regards, Dan McGrath Managing Director, U2 Servers Lab Rocket Software LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] XAdmin wiki?
From: Daniel McGrath Subject: Re: [U2] Pick flavor in U2 personal edition XAdmin, part of our U2 DBTools package: http://www.rocketsoftware.com/products/rocket-u2-clients-and-dbtools/t ry-now I confess that I've always had a lack of skill with detailed U2 administration. Some people pretend that all MV environments are the same but when you move away from R83 compatibility they become very different. XAdmin presents a wide variety of tools to the U2 DBA but I'm not aware of any tutorials that take users through the various features. Is anyone aware of a wiki or ebook that documents each of the features with notes about how they can be of use, when to use various features, etc? A wiki can be infinitely better than company documentation because it would include real-world tips and tricks that developers never include. And when a public wiki is open to the vendor/developers, they can occasionally add insight that we'd never see in company-provided documentation. (Personally I think ALL MV documentation should be in wiki format but getting that off the ground is an exercise in futility.) Is a wiki for XAdmin something that would get any traction at RS, U2UG, or PickWiki? I'd be happy to help coordinate the effort but frankly I'm not qualified to contribute detailed content. My contribution would be more about asking questions for others to provide answers, as well as editing, formatting, etc. As to motivation or de-motivation - I'm sure there are companies that offer training on U2 administration with focus on XAdmin. People from these companies aren't motivated to provide a lot of data for free on a public wiki. Then again, demonstration of expertise is like a business card which lets people know who are the experts on the topic. I'm not one to fall for carrots dump everything you know into a free web page and you'll get lots of business but there is some value for people in efforts like this depending on how it's approached. Anyway - am I missing something that's already in progress? Thanks. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com http://Nebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://www.LinkedIn.com/in/TonyGravagno http://groups.google.com/group/mvdbms ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] XAdmin wiki?
I am attempting to install right now. While looking for answers, this site keeps cropping up in my search. http://sbxa.wikia.com/wiki/ From: 3xk547...@sneakemail.com To: u2-users@listserver.u2ug.org Date: Mon, 5 Aug 2013 14:49:37 -0700 Subject: [U2] XAdmin wiki? From: Daniel McGrath Subject: Re: [U2] Pick flavor in U2 personal edition XAdmin, part of our U2 DBTools package: http://www.rocketsoftware.com/products/rocket-u2-clients-and-dbtools/t ry-now I confess that I've always had a lack of skill with detailed U2 administration. Some people pretend that all MV environments are the same but when you move away from R83 compatibility they become very different. XAdmin presents a wide variety of tools to the U2 DBA but I'm not aware of any tutorials that take users through the various features. Is anyone aware of a wiki or ebook that documents each of the features with notes about how they can be of use, when to use various features, etc? A wiki can be infinitely better than company documentation because it would include real-world tips and tricks that developers never include. And when a public wiki is open to the vendor/developers, they can occasionally add insight that we'd never see in company-provided documentation. (Personally I think ALL MV documentation should be in wiki format but getting that off the ground is an exercise in futility.) Is a wiki for XAdmin something that would get any traction at RS, U2UG, or PickWiki? I'd be happy to help coordinate the effort but frankly I'm not qualified to contribute detailed content. My contribution would be more about asking questions for others to provide answers, as well as editing, formatting, etc. As to motivation or de-motivation - I'm sure there are companies that offer training on U2 administration with focus on XAdmin. People from these companies aren't motivated to provide a lot of data for free on a public wiki. Then again, demonstration of expertise is like a business card which lets people know who are the experts on the topic. I'm not one to fall for carrots dump everything you know into a free web page and you'll get lots of business but there is some value for people in efforts like this depending on how it's approached. Anyway - am I missing something that's already in progress? Thanks. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com http://Nebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://www.LinkedIn.com/in/TonyGravagno http://groups.google.com/group/mvdbms ___ 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] OPENSEQ
From: Al DeWitt I'm a Domain Admin so permissions is not an issue. I understand the sentiment there but we may not be aware of the permissions required for the operation in question, so it's tough to know if the right permissions have not been granted. My related experiences, dunno if this helps anyone... Some products need their own access to remote data resources. The permissions of the current user, especially telnet, are not used to access remote resource, because it's the DBMS not the user that is doing the access. Most sites don't run their DBMS services with Administrator privs - that's a huge security issue. (I can just see people now going huh? really? and checking their services ... go ahead, we'll be here when you get back...) I'll sometimes temporarily open full permissions to the target and give admin privs to the client application just to see if that resolves the issue. You'd be surprised at how often this does reveal a permissions issue - but again you shouldn't leave it like that because this is a huge security issue. NOT being a domain admin I usually have issues getting the right restricted permissions back so I always try to have someone else handy to fix it. :) I also use Sysinternals tools to find out exactly what the system is trying to do. Maybe in this OpenSEQ case it's not actually reading from the intended target. Again, you might be surprised at all of the disk reads that need to be done to get to the real data you're trying to access. This could help to identify performance issues too. http://technet.microsoft.com/en-us/sysinternals/bb795533.aspx HTH T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] XAdmin wiki?
Whoe dude, hang on. :) The answer to the question does this exist or what do you folks think isn't to do an install. There are already generic resources available. We don't need yet another wiki site with yet another login and markup language. I was hoping we could make use of one of the existing, well-known resources before jumping to something completely new. Yeah, I know the SB/XA wiki has been around a while but unless a site uses SB, chances are they don't know about that site ... like me. I didn't even know that SB/XA Wiki existed - there isn't a single mention of it at PickWiki. Honestly, I don't believe yet another site will thrive in isolation. There are too many of these already. And ... SB/XA is NOT the XAdmin. These two offerings deserve their own homes... Regards, T From: Jo Lester I am attempting to install right now. While looking for answers, this site keeps cropping up in my search. http://sbxa.wikia.com/wiki/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pick flavor in U2 personal edition
Eric: Yes. Bill - Original Message - *From:* earmstr...@lobelfinancial.com *To:* u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org *Date:* 8/5/2013 1:24 PM *Subject:* Re: [U2] Pick flavor in U2 personal edition Dan, Thanks. I downloaded and installed the Extensible Administration Tool it. Do I have to create a new U2 Server in order to use it? Eric Armstrong IT Dept -- Message: 6 Date: Fri, 2 Aug 2013 21:31:58 + From: Daniel McGrath dmcgr...@rocketsoftware.com To: U2 Users List u2-users@listserver.u2ug.org Subject: Re: [U2] Pick flavor in U2 personal edition Message-ID: 8e17b0ffe20e47db8ffcae5d1b91e...@wal-vm-mbx1.rocketsoftware.com Content-Type: text/plain; charset=us-ascii XAdmin, part of our U2 DBTools package: http://www.rocketsoftware.com/products/rocket-u2-clients-and-dbtools/try-now Regards, Dan McGrath Managing Director, U2 Servers Lab Rocket Software LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. ___ 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] XAdmin wiki?
Sorry Mr. Tony G., I did not know it existed until last week. I believe I misunderstood what you guys were talking about. Perhaps I still do. I have learned a lot from lurking on your boards. Thank You. Jo From: 3xk547...@sneakemail.com To: u2-users@listserver.u2ug.org Date: Mon, 5 Aug 2013 16:22:38 -0700 Subject: Re: [U2] XAdmin wiki? Whoe dude, hang on. :) The answer to the question does this exist or what do you folks think isn't to do an install. There are already generic resources available. We don't need yet another wiki site with yet another login and markup language. I was hoping we could make use of one of the existing, well-known resources before jumping to something completely new. Yeah, I know the SB/XA wiki has been around a while but unless a site uses SB, chances are they don't know about that site ... like me. I didn't even know that SB/XA Wiki existed - there isn't a single mention of it at PickWiki. Honestly, I don't believe yet another site will thrive in isolation. There are too many of these already. And ... SB/XA is NOT the XAdmin. These two offerings deserve their own homes... Regards, T From: Jo Lester I am attempting to install right now. While looking for answers, this site keeps cropping up in my search. http://sbxa.wikia.com/wiki/ ___ 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] XAdmin wiki?
Hi: The problem is not whether you need a wiki or not. The problem is the documentation is terrible and in most cases non-existent. A year ago at U2 University a majority of us discussed this with the board of Rocket U2. The agreed with us they would fix this and show some examples as well. Well, here we are a year and many months later with the same problem. New users and non-eclipse users cannot figure out how this tool works. Since U2logic is a U2 VAR, U2logic does get paid to tell our clients how to use this tool and the others. However, since the tools are given away by Rocket there is little money in the pot for any meaningful help. Regards, Doug www.u2logic.com Better documentation for our XLr8 Tools ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] XAdmin wiki?
*If* someone were to start a section, page, whatever at Pickwiki for example, I would be happy to contribute what little I know about the U2 Admin tool. At least as far as it works on Windows. -Original Message- From: Doug Averch dave...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Aug 5, 2013 4:57 pm Subject: Re: [U2] XAdmin wiki? Hi: The problem is not whether you need a wiki or not. The problem is the documentation is terrible and in most cases non-existent. A year ago at U2 University a majority of us discussed this with the board of Rocket U2. The agreed with us they would fix this and show some examples as well. Well, here we are a year and many months later with the same problem. New users and non-eclipse users cannot figure out how this tool works. Since U2logic is a U2 VAR, U2logic does get paid to tell our clients how to use this tool and the others. However, since the tools are given away by Rocket there is little money in the pot for any meaningful help. Regards, Doug www.u2logic.com Better documentation for our XLr8 Tools ___ 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] XAdmin wiki?
You know, I'd have no problem updating documentation to a wiki site, where I know all documentation would go and I could continue to reference the documentation in the future. The Pickwiki is a little disorganized, but since I do most of my database work with U2 I'd be happy to update anything to a wiki they provide. The biggest problem I see is the changing technology. Everything changes, including wikis! Simple is always better, and since we're all developers to one degree or another, we don't need a completely idiot-proof environment; just someone at U2's end who can keep us idiots in line and keep the site organized. Just my $.02. :-) Bill - Original Message - *From:* dave...@gmail.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 8/5/2013 4:57 PM *Subject:* Re: [U2] XAdmin wiki? Hi: The problem is not whether you need a wiki or not. The problem is the documentation is terrible and in most cases non-existent. A year ago at U2 University a majority of us discussed this with the board of Rocket U2. The agreed with us they would fix this and show some examples as well. Well, here we are a year and many months later with the same problem. New users and non-eclipse users cannot figure out how this tool works. Since U2logic is a U2 VAR, U2logic does get paid to tell our clients how to use this tool and the others. However, since the tools are given away by Rocket there is little money in the pot for any meaningful help. Regards, Doug www.u2logic.com Better documentation for our XLr8 Tools ___ 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
