RE: [U2] Creating a file in a different account
Bjorn You can call out to the mkdbfile executable in the $UVHOME\bin directory. mkdbfile filepath type modulus separation Depending on how you want to do this, here is a suggestion: 1. Create a Q pointer to the remote VOC 2. Open the Q pointer and get the path (use Status27 and strip out the /VOC at the end) 3. Call mkdbfile to create the data file in that path. 4. call mkdbfile to create the dict file in that path as D_name 5. Write a new file pointer to the remote VOC. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bjorn Behr Sent: 16 May 2008 10:04 To: u2-users@listserver.u2ug.org Subject: [U2] Creating a file in a different account I am wondering how you could create a file in a different account to the one I am logged into EG: I am logged into LIVE and would like to create a new file in ODBC through a program without loggin into ODBC Many Thanks Bjorn Important Notice: This email is subject to important restrictions, qualifications and disclaimers (the Disclaimer) that must be accessed and read at the following address or by copying and pasting the following address into your Internet browser's address bar: http://www.frstia.co.za/Disclaimer.asp The Disclaimer is deemed to form part of the content of this email in terms of Section 11 of the Electronic Communications and Transactions Act, 25 of 2002. If you cannot access the Disclaimer, please obtain a copy thereof from us by sending an email to mailto:[EMAIL PROTECTED] FirstRand STI Admin (Pty) Ltd is an Authorised Financial Services Provider --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Creating a file in a different account
I am wondering how you could create a file in a different account to the one I am logged into EG: I am logged into LIVE and would like to create a new file in ODBC through a program without loggin into ODBC Many Thanks Bjorn Important Notice: This email is subject to important restrictions, qualifications and disclaimers (the Disclaimer) that must be accessed and read at the following address or by copying and pasting the following address into your Internet browser's address bar: http://www.frstia.co.za/Disclaimer.asp The Disclaimer is deemed to form part of the content of this email in terms of Section 11 of the Electronic Communications and Transactions Act, 25 of 2002. If you cannot access the Disclaimer, please obtain a copy thereof from us by sending an email to mailto:[EMAIL PROTECTED] FirstRand STI Admin (Pty) Ltd is an Authorised Financial Services Provider --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] locking code question
BP files only have to be type 1/19 if you want to compile / run from them. Why not store your code in type {whatever else} files, then get the {revised home-grown} ED to copy source out to a GLOBALBP type 1 file to compile, catalog program then delete the source. A trigger on the storage file will handle all auditing, SICA etc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: 16 May 2008 03:52 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] locking code question BP files have to be either type 1 or type 19 (directories). Not having a file header, you can't have a SICA, can you? Same reason you can't have indexes or transaction logging on them. At least that's my understanding. I'd love to find out there is a way to do it. Regards, Clif On May 15, 2008, at 4:14 PM, David Jordan wrote: You could look at SQLising the BP file. Having a SICA, you could restrict read and update to all users and have a BASIC program manager with the AUTHORIZATION command, handle check out, check in, compilation, etc. This means that programs could only be accessed through the program manager and not directly. This would only work on UniVerse as I believe UniData does not have the AUTHORIZATION Command. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG. Version: 8.0.100 / Virus Database: 269.23.2/1432 - Release Date: 5/14/2008 7:49 AM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Global Catalog - Recovery
The host O/S file copy. (cp) Tom Dodds [EMAIL PROTECTED] 630.235.2975 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Thursday, May 15, 2008 8:54 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Global Catalog - Recovery Was the copy done with the COPY verb, or with the host O/S file copy? Regards, Clif On May 15, 2008, at 6:01 PM, Tom Dodds wrote: My experience says that you have to be careful copying the catdir directory. You can get some corrupt data because of the funny characters in the object code stored in catdir. Be careful and verify the content, maybe with VCATALOG, before you stash it away. You will have to verify it each time to copy it because the object may change. I lost a migration weekend because of copying catdir and getting corrupt data. Tom Dodds [EMAIL PROTECTED] 630.235.2975 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Thursday, May 15, 2008 4:55 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Global Catalog - Recovery Cataloging locally might not be an option if there are a lot of programs that CALL *XYZ(...) or the old Prime way of XYZ = *XYZ CALL @XYZ(...) Bill, Globally cataloged programs (the ones with the * as the first character) are stored in the catalog space which is really a subdirectory in the UV account called catdir. If you copy the catdir directory, I believe you will have what you need. Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On May 15, 2008, at 1:51 PM, Israel, John R. wrote: Catalog locally and you will never need to re-catalog (assuming local cataloging is acceptable). or Catalogging hundreds of pgms should not be a big deal. SELECT BP (or SELECT BP_O) CATALOG BP FORCE John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Thursday, May 15, 2008 4:36 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Global Catalog - Recovery I am trying to validate an emergency recovery scenario. I want to install UV on a disk and lock the disk (unpowered) in a safe. So, if our main disk has a problem, I would just insert the (cold) hot-plugable disk, copy the latest data to this disk and then we are LIVE again... rapidly. To do this, it appears that I need to reCatalog all 100 of our global subs on the new disk. Is there any way around this reCataloging hitch? Suggestions would be appreciated. We are using HP-Ux 11i v2 and UV v10.1. This scenario would also help with smoothly upgrading HP-Ux and UV versions. --Bill Bill Brutzman Manager, IT HK MetalCraft Mfg Corp PO Box 775 35 Industrial Road Lodi NJ 07644-0775 973.471.7770 x145 .voice 973.471.9666 .fax [EMAIL PROTECTED] [demime 1.01d removed an attachment of type application/octet-stream which had a name of Brutzman, Bill.vcf] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Creating a file in a different account
There is not a version of this for UniData is there?!? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Friday, May 16, 2008 4:35 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Creating a file in a different account Bjorn You can call out to the mkdbfile executable in the $UVHOME\bin directory. mkdbfile filepath type modulus separation Depending on how you want to do this, here is a suggestion: 1. Create a Q pointer to the remote VOC 2. Open the Q pointer and get the path (use Status27 and strip out the /VOC at the end) 3. Call mkdbfile to create the data file in that path. 4. call mkdbfile to create the dict file in that path as D_name 5. Write a new file pointer to the remote VOC. Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] locking code question
Doug, If you're using a scc tool like subversion or cvs, you don't need to use locking. You don't want to use locking. The concern that I hear from most pickies is: How do I keep my developers from stepping on each others changes? And inevitably they come to the conclusion that the only way to do that is by locking others out while they make changes -- hey, that's what you do with database records, right? Subversion and CVS don't use a locking model; they use a merge model. Instead of a single BP file that gets locked, the programs are stored in a repository. Developers checkout or update their personal program copy from the repository and proceed to slice and dice it. Now here's where the magic happens: when the developer commits his changes, the scc tool *merges* the lines of code changed back into the repository. When the commit process detects a conflict, it let's the developer know so he can fix it. This dynamic works well for 1 to 1,000 developers working on a single application. There are some implications that are typically different from a locking model pick shop: (1) Every developer has his own development area (directory). Developers typically don't share a single account. Pickies tend to have a single development area for everybody. (2) Every developer updates his own development area on a regular basic, usually every morning. This one-line command grabs all the recent changes to the repository and updates the programs. If a change was made to a program that the developer was working on, the change is seemlessly merged in. Any conflicts are reported and the developer is expected to resolve it. (3) When the developer has completed and tested his mods, he commits them to the repository (again a one-line command). Again, any conflicting changes are reported for the developer to resolve. How often do conflicting changes occur? Rarely, because seldom do two developers work on the same exact lines of code at the exact same time. As soon as one developer makes his change and commits it, the other developer's update automagically merges it into his version. As long as all developers do updates before they change code, nobody gets hurt. With these tools and procedures, you don't really gain anything by locking. Like Ian mentioned, your developers are more likely to forget to unlock a program. rex doug chanco wrote: hey all, we are beginning to use subversion for version control and I was wondering if there was good way to lock code besides the usual READU in a program or AE/EDing the record. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Position Available
Cypress Business Solutions, an eCommerce / Catalog Manage software provider currently has a System Analysis/programmer position available. We are located in Acworth, Ga (North of Atlanta). Salary is based on experience. Require a working knowledge of Universe and Unibasic Require good communicate skills (verbal and written) Web Development, ASP.net and VB.net a plus Please forward resume to James F Thompson at [EMAIL PROTECTED] James F Thompson Senior System Analyst Cypress Business Solutions 678.494.9353 x1410 [EMAIL PROTECTED] www.cypressesolutions.com http://www.cypressesolutions.com/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Creating a file in a different account
quote who='David Wolverton' date='Friday 16 May 2008' There is not a version of this for UniData is there?!? There is a 'udfile' in $UDTBIN, but not sure if it's the same as mkdbfile on Universe. Bjorn You can call out to the mkdbfile executable in the $UVHOME\bin directory. mkdbfile filepath type modulus separation -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 He works out of his home office doing technical training. I call it gambling. Overheard at grocery store. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Creating a file in a different account
Unidata's CREATE.FILE command allows you to specify the directory path. So you could replace the mkdbfile commands in steps 3 and 4 with CREATE.FILE DICT /dir/subdir/FILENAME mod,sep and CREATE.FILE DATA /dir/subdir/FILENAME mod,sep In step 5, copy VOC FILENAME to the remote VOC and optionally delete it from the current VOC Hope this helps, Tom Derwin [EMAIL PROTECTED] 05/16/08 12:30 PM There is not a version of this for UniData is there?!? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Friday, May 16, 2008 4:35 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Creating a file in a different account Bjorn You can call out to the mkdbfile executable in the $UVHOME\bin directory. mkdbfile filepath type modulus separation Depending on how you want to do this, here is a suggestion: 1. Create a Q pointer to the remote VOC 2. Open the Q pointer and get the path (use Status27 and strip out the /VOC at the end) 3. Call mkdbfile to create the data file in that path. 4. call mkdbfile to create the dict file in that path as D_name 5. Write a new file pointer to the remote VOC. Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ - This e-mail and any attachments may contain CONFIDENTIAL information, including PROTECTED HEALTH INFORMATION. If you are not the intended recipient, any use or disclosure of this information is STRICTLY PROHIBITED; you are requested to delete this e-mail and any attachments, notify the sender immediately, and notify the LabCorp Privacy Officer at [EMAIL PROTECTED] or call (877) 23-HIPAA / (877) 234-4722. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Creating a file in a different account
$UDTBIN/udfile is NOT for creating files in other accounts in UniData. It can be used to see if a file is flagged as Recoverable or to set/unset the recoverable file bit (with the database down or up with RFS off). In UniData, you can specify a path to a remote directory in the command line. This particular test happens to have been done in 7.2 beta on Windows, but this has been available for earlier releases. Current UniData home is C:\IBM\ud72\. Current working directory is C:\IBM\ud72\wallytest. : :CREATE.FILE C:\IBM\ud72\demo\REMOTE_TEST 11,1 Create file C:\IBM\ud72\demo\D_REMOTE_TEST, modulo/1,blocksize/1024 Hash type = 0 Create file C:\IBM\ud72\demo\REMOTE_TEST, modulo/11,blocksize/1024 Hash type = 0 Added @ID, the default record for UniData to DICT C:\IBM\ud72\demo\REMOTE_TEST. : :AE VOC REMOTE_TEST Create file D_AE_COMS, modulo/1,blocksize/1024 Hash type = 0 Create file AE_COMS, modulo/3,blocksize/1024 Hash type = 0 Added @ID, the default record for UniData to DICT AE_COMS. Create DIR type file AE_SCRATCH. Create file D_AE_SCRATCH, modulo/1,blocksize/1024 Hash type = 0 Added @ID, the default record for UniData to DICT AE_SCRATCH. Top of REMOTE_TEST in VOC, 3 lines, 61 characters. *--: P 001: F 002: C:\IBM\ud72\demo\REMOTE_TEST 003: C:\IBM\ud72\demo\D_REMOTE_TEST Bottom. *--: EX Quit REMOTE_TEST in file VOC unchanged. : :COPY FROM VOC TO REMOTE_TEST ALL 567 records copied :COUNT REMOTE_TEST COUNT REMOTE_TEST 567 record(s) counted. : Wally Terhune SWG Client Support - Information Management Software U2 Support Architect b IBM U2 Client Support Team 4700 S. Syracuse St., Denver, CO 80237 Tel: (303) 773-7969 T/L 656-7969 Mobile: (303) 807-6222 [EMAIL PROTECTED] [demime 1.01d removed an attachment of type image/jpeg which had a name of 25029181.jpg] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Creating a file in a different account
If you copy the VOC entry, you may wish to remove the absolute path references and make it relative, otherwise, if you ever move the account, the VOC entry will break. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Derwin Sent: Friday, May 16, 2008 11:36 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Creating a file in a different account Unidata's CREATE.FILE command allows you to specify the directory path. So you could replace the mkdbfile commands in steps 3 and 4 with CREATE.FILE DICT /dir/subdir/FILENAME mod,sep and CREATE.FILE DATA /dir/subdir/FILENAME mod,sep In step 5, copy VOC FILENAME to the remote VOC and optionally delete it from the current VOC Hope this helps, Tom Derwin [EMAIL PROTECTED] 05/16/08 12:30 PM There is not a version of this for UniData is there?!? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Friday, May 16, 2008 4:35 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Creating a file in a different account Bjorn You can call out to the mkdbfile executable in the $UVHOME\bin directory. mkdbfile filepath type modulus separation Depending on how you want to do this, here is a suggestion: 1. Create a Q pointer to the remote VOC 2. Open the Q pointer and get the path (use Status27 and strip out the /VOC at the end) 3. Call mkdbfile to create the data file in that path. 4. call mkdbfile to create the dict file in that path as D_name 5. Write a new file pointer to the remote VOC. Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ - This e-mail and any attachments may contain CONFIDENTIAL information, including PROTECTED HEALTH INFORMATION. If you are not the intended recipient, any use or disclosure of this information is STRICTLY PROHIBITED; you are requested to delete this e-mail and any attachments, notify the sender immediately, and notify the LabCorp Privacy Officer at [EMAIL PROTECTED] or call (877) 23-HIPAA / (877) 234-4722. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Creating a file in a different account
No. But you don't need it. CREATE.FILE will work with the full path. So the instructions are similar: 1. create a pointer to the VOC in the remote account 2. CREATE.FILE fullpath\filename etc. 3. create an item in the remote VOC to point to the file 4. If required, delete local VOC item pointing at remote file (DELETE VOC filename) which will warn it's synonym. hth Colin Alfke Calgary Canada -Original Message- From: Jeffrey Butera quote who='David Wolverton' date='Friday 16 May 2008' There is not a version of this for UniData is there?!? There is a 'udfile' in $UDTBIN, but not sure if it's the same as mkdbfile on Universe. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Creating a file in a different account
quote who='Thomas Derwin' date='Friday 16 May 2008' Unidata's CREATE.FILE command allows you to specify the directory path. Sure, but this isn't a OS command. I think he was excited about the possibility of creating a new database file on the fly from the OS, not from within Unidata. (But perhaps I misunderstood his ?!?) So you could replace the mkdbfile commands in steps 3 and 4 with CREATE.FILE DICT /dir/subdir/FILENAME mod,sep and CREATE.FILE DATA /dir/subdir/FILENAME mod,sep In step 5, copy VOC FILENAME to the remote VOC and optionally delete it from the current VOC Hope this helps, Tom Derwin [EMAIL PROTECTED] 05/16/08 12:30 PM There is not a version of this for UniData is there?!? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Friday, May 16, 2008 4:35 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Creating a file in a different account Bjorn You can call out to the mkdbfile executable in the $UVHOME\bin directory. mkdbfile filepath type modulus separation Depending on how you want to do this, here is a suggestion: 1. Create a Q pointer to the remote VOC 2. Open the Q pointer and get the path (use Status27 and strip out the /VOC at the end) 3. Call mkdbfile to create the data file in that path. 4. call mkdbfile to create the dict file in that path as D_name 5. Write a new file pointer to the remote VOC. Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ - This e-mail and any attachments may contain CONFIDENTIAL information, including PROTECTED HEALTH INFORMATION. If you are not the intended recipient, any use or disclosure of this information is STRICTLY PROHIBITED; you are requested to delete this e-mail and any attachments, notify the sender immediately, and notify the LabCorp Privacy Officer at [EMAIL PROTECTED] or call (877) 23-HIPAA / (877) 234-4722. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 He works out of his home office doing technical training. I call it gambling. Overheard at grocery store. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Creating a file in a different account
OK - I was hoping there was a 'One Stop Shopping' that would build the 'remote file' and update the 'remote VOC' -- much like the UniVerse command appears to do -- we don't have that in UniData it would appear from the thread Unidata's CREATE.FILE command allows you to specify the directory path. So you could replace the mkdbfile commands in steps 3 and 4 with CREATE.FILE DICT /dir/subdir/FILENAME mod,sep and CREATE.FILE DATA /dir/subdir/FILENAME mod,sep In step 5, copy VOC FILENAME to the remote VOC and optionally delete it from the current VOC Hope this helps, Tom Derwin --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] ODBC Connection Hanging Around
I have a VBScript script that makes an ODBC connection to Unidata, calls a subroutine, and returns the results. Usually everything goes swimmingly, but occasionally, and for no apparent reason, an ODBC connection will not get disconnected from the Unidata side. The ODBC session is instantiated via: DSN = DSN=;Uid=;Pwd=__ Session.Open DSN And is closed via: Session.Close Set Session = Nothing And yet occasionally UniAdmin will show one of these connections hanging on unexpectedly. Any ideas? (Incidentally, while I would have preferred to write this via UO, the client demanded this solution be written for an ODBC connection.) -Kevin http://www.PrecisOnline.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/