RE: [U2] Creating a file in a different account
You could try changing CREATE.FILE to a Remote verb and adding your own wrapper. That way you can extend the syntax of the command and add VOC updates to suit your requirements. Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: 16 May 2008 21:30 To: u2-users@listserver.u2ug.org Subject: 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-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/
Re: [U2] Creating a file in a different account
> 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 Status<27> 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
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 > 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
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 Status<27> 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
$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
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 Status<27> 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
> 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
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 Status<27> 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] 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 Status<27> 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/