[U2] ODBC Connection Hanging Around

2008-05-16 Thread Kevin King
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 vi

RE: [U2] Creating a file in a different account

2008-05-16 Thread John Jenkins
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 Wolvert

RE: [U2] Creating a file in a different account

2008-05-16 Thread David Wolverton
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 > direc

Re: [U2] Creating a file in a different account

2008-05-16 Thread Jeffrey Butera
> 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 repl

RE: [U2] Creating a file in a different account

2008-05-16 Thread Colin Alfke
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 a

RE: [U2] Creating a file in a different account

2008-05-16 Thread Robert Houben
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, 20

Re: [U2] Creating a file in a different account

2008-05-16 Thread Wally Terhune
$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

RE: [U2] Creating a file in a different account

2008-05-16 Thread Thomas Derwin
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 d

Re: [U2] Creating a file in a different account

2008-05-16 Thread 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. > > Bjorn > > > > You can call out to the mkdbfile executable in the > > $UVHOME\bin directory. > > > > mkdbfile filepath type modulus separation

[U2] Position Available

2008-05-16 Thread James F Thompson
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 comm

Re: [U2] locking code question

2008-05-16 Thread Rex Gozar
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

RE: [U2] Creating a file in a different account

2008-05-16 Thread David Wolverton
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 >

RE: [U2] Global Catalog - Recovery

2008-05-16 Thread Tom Dodds
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 th

RE: [U2] Creating a file in a different account

2008-05-16 Thread Brian Leach
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

[U2] Creating a file in a different account

2008-05-16 Thread Bjorn Behr
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, qual

RE: [U2] locking code question

2008-05-16 Thread Dennis Bartlett
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 trig