Re: [U2] [uv]CREATE.FILE syntax for remote directories
They (IBM) paid US$11 for Ascential. And that's not a binary number!! Are you and Dave going to moonlight as U2 engineers again?!! :D - Original Message - From: Glenn Herbert [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Subject: [U2] [uv]CREATE.FILE syntax for remote directories Date: Wed, 15 Jun 2005 12:19:29 -0400 And yes, I am now in the employ of IBM, which acquired Ascential and DataStage. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [uv]CREATE.FILE syntax for remote directories
One might think there was no useful info in the attached post, but then one notices that the From address tells us that Glenn Herbert now has an IBM address. If one assumes Glenn still has some association with DataStage, one may deduce that there may have been some truth to the rumour that DataStage now has some association with IBM. And it looks like things have progressed beyond the idea stage. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glenn Herbert [EMAIL PROTECTED] Sent: Wednesday, June 15, 2005 6:27 AM To: [EMAIL PROTECTED]; u2-users@listserver.u2ug.org Subject: RE: [U2] [uv]CREATE.FILE syntax for remote directories --- 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] [uv]CREATE.FILE syntax for remote directories
Dear all, Thanks for responses. I start to use mkdbfile and I post this CREATE.REMOTEFILE filename type modulo separator. Regards. Manu -boundary --- * CREATE A FILE IN OTHER DIRECTORY * SYNTAX : CREATE.REMOTEFILE FILENAME TYPE MODULO SEPRATOR PRINT @SENTENCE FILENAME = FIELD(TRIM(@SENTENCE),' ',2) IF FILENAME = '' THEN GOTO SYNTAX TYPE = FIELD(TRIM(@SENTENCE),' ',3) IF NOT(NUM(TYPE)) OR TYPE 2 OR TYPE 18 THEN TYPE = 18 MODULO = FIELD(TRIM(@SENTENCE),' ',4) IF NOT(NUM(MODULO)) OR MODULO 1 THEN MODULO = 53 SEPARATOR= FIELD(TRIM(@SENTENCE),' ',5) IF NOT(NUM(SEPARATOR)) OR SEPARATOR 1 THEN SEPARATOR = 4 OPEN 'VOC' TO F.VOC ELSE STOP 201,'VOC' READ BUF FROM F.VOC,FILENAME THEN STOP FILENAME:' exist in VOC ! Process Abort' PATH = '' ; FILE = ''; STATUS = '' CALL !GET.PATHNAME(FILENAME,PATH,FILE,STATUS) IF STATUS # 0 THEN STOP Error ON GET.PATH [:STATUS:']' FILE = UPCASE(FILE) OPENPATH PATH TO F.PATH ELSE STOP 201,PATH FILENAME = PATH:'/':FILE DICTFILENAME = PATH:'/D_':FILE MKDBFILE = SYSTEM(32):'/bin/mkdbfile' EXECUTE 'SH -c ':MKDBFILE:' ':FILENAME:' ':TYPE:' ':MODULO:' ':SEPARATOR:'' EXECUTE 'SH -c ':MKDBFILE:' ':DICTFILENAME:' 18 37 1' VOCENTRY = '' VOCENTRY1 = 'F' VOCENTRY2 = FILENAME VOCENTRY3 = DICTFILENAME WRITE VOCENTRY ON F.VOC,FILE OPEN FILE TO F.FILE ELSE STOP 201,FILE OPEN 'DICT',FILE TO FD.FILE ELSE STOP 201,'DICT ':FILE READ ID FROM F.VOC,'@ID' THEN WRITE ID ON FD.FILE,'@ID' STOP SYNTAX: PRINT 'SYNTAX :CREATE.REMOTEFILE filename type modulo separator' STOP END -boundary --- - Original Message - From: Martin Phillips [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, June 13, 2005 11:51 AM Subject: Re: [U2] [uv]CREATE.FILE syntax for remote directories Question : Is there a way to specify a full path+filename instead a filename in the CREATE.FILE command ? No but the underlying operating system level program that does the CREATE.FILE can do this. /usr/uv/bin/mkdbfile pathname type modulo separation (with the appropriate path on the mkdbfile program) It is relatively easy to wrap a bit of Basic around this and build your own CREATE.PATH verb. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- 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] [uv]CREATE.FILE syntax for remote directories
Charles, No rumor. IBM bought Ascential. - Chuck Another Chuck Barouch Stevenson, Charles wrote: One might think there was no useful info in the attached post, but then one notices that the From address tells us that Glenn Herbert now has an IBM address. If one assumes Glenn still has some association with DataStage, one may deduce that there may have been some truth to the rumour that DataStage now has some association with IBM. And it looks like things have progressed beyond the idea stage. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [uv]CREATE.FILE syntax for remote directories
--- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [uv]CREATE.FILE syntax for remote directories
I think something's got Glenn's tongue (or fingers in this case...) :-) Colin Alfke Calgary, AB -Original Message- From: Glenn Herbert --- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [uv]CREATE.FILE syntax for remote directories
Dear Glenn, Thank you very much for theses details. One question : Where can we found detailed documentation about OS level universe's commands ? I found nothing in the whole UV docs I have. With kind regards. Manu Fernandes - Original Message - From: Glenn Herbert [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, June 15, 2005 6:19 PM Subject: [U2] [uv]CREATE.FILE syntax for remote directories Apparently, my post on all the intricacies and details of using mkdbfile got lost and all anyone saw was my signature. I too received just an empty message and tried all manner of ways to view the text I actually sent; I have learned that printing out the bapparentlyb empty message and holding a candle behind the page does in fact not only NOT reveal any words, it actually causes the page to be consumed rather rapidly in flames!! Ok. So now that I got past the humorous part J, here is the re-created reply which I sent: You can create a dynamic file using mkdbfile as follows: mkdbfile filename 30 minmod grpsiz hash merge split largerec -u uid bg gid bm mode where minmod is the MINIMUM.MODULUS value grpsiz is either 4 or 8 (for GROUP.SIZE 1 or 2 respectively) hash is either 20 (GENERAL) or 21 (SEQ.NUM) merge is the MERGE.LOAD value as a percentage split is the SPLIT.LOAD value as a percentage largerec is the LARGE.REC value as a percentage or decimal -u uid is an optional value specifying ownership (must be root to change from current user) -g gid is an optional value specifying group ownership (must be root to change from current group) -m mode is an option decimal value specifying file permissions For example: mkdbfile MYFILE 30 10 4 20 50 80 1638 bm 438 would create a dynamic file named MYFILE with a minimum modulus value of 10, with a group separation of 4 (mapping to GROUP.SIZE 1), using an internal hashing of GENERAL, where merging is performed once the file falls below 50%, where splitting occurs once the file is over 80% full, and large records (kept in the OVER.30 file) consist of 1638 character or more. Additionally, the bm 438 option is used to set file permissions to brw-rw-rw- (octal 666 converted from decimal 438). And yes, I am now in the employ of IBM, which acquired Ascential and DataStage. From:[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Key Ally [EMAIL PROTECTED] Sent: Wednesday, June 15, 2005 11:08 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [uv]CREATE.FILE syntax for remote directories Charles, No rumor. IBM bought Ascential. - Chuck Another Chuck Barouch Stevenson, Charles wrote: One might think there was no useful info in the attached post, but then one notices that the From address tells us that Glenn Herbert now has an IBM address. If one assumes Glenn still has some association with DataStage, one may deduce that there may have been some truth to the rumour that DataStage now has some association with IBM. And it looks like things have progressed beyond the idea stage. --- 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] [uv]CREATE.FILE syntax for remote directories
yep. my typing is fine. something within notes is discombobulating things. oh for the days of eudora. _ I reject your reality and substitute my own - Adam Savage Glenn M. Herbert - Connectivity Development Engineer Information Integration Solutions, IBM Software Group 50 Washington Street Westboro, MA 01581 508-599-7281 direct [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/15/2005 12:29 PM Please respond to u2-users To u2-users@listserver.u2ug.org cc Subject RE: [U2] [uv]CREATE.FILE syntax for remote directories I think something's got Glenn's tongue (or fingers in this case...) :-) Colin Alfke Calgary, AB -Original Message- From: Glenn Herbert --- --- 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] [uv]CREATE.FILE syntax for remote directories
450 Lynx formatting failed: open3: exec of lynx --stdin --dump --force_html --hiddenlinks=ignore --localhost --image_links --nolist --noredir --noreferer --realm failed at /etc/smrsh/demime line 1519 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [uv]CREATE.FILE syntax for remote directories
I was wondering what happened with that merger. - Original Message - From: Glenn Herbert [EMAIL PROTECTED] And yes, I am now in the employ of IBM, which acquired Ascential and DataStage. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [uv]CREATE.FILE syntax for remote directories
CREATE.FILE, no. CREATE TABLE, yes. CREATE TABLE tablename DATA pathname DICT pathname ( column_definition_list and constraints ); --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [uv]CREATE.FILE syntax for remote directories
Susan, just an FYI, UniVerse does have a mkdbfile binary in the $uvhome/bin directory. I execute this to create sub-files from within my basic programs. I created a VOC entry for the binary: @ID = MKDBFILE @RECORD = V:@FM:mkdbfile:@FM:E:@FM:VF:@FM:@FM:PICK.FORMAT then From my BASIC program I can EXECUTE MKDBFILE /mp/MPLIVE/SY.WEBWORK/:@USERNO: 3 1301 4 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Tuesday, June 14, 2005 7:20 AM To: u2-users@listserver.u2ug.org Subject: [U2] [uv]CREATE.FILE syntax for remote directories You can do a full-path CREATE.FILE with Unidata, but not with Universe. I have been hoping that might make it to the compatibility list. I didn't know you could do a UNIX command and get a uv-typed (perhaps hashed) file -- as Martin's suggestion. What I do is create it locally by EXECUTING CREATE.FILE, then EXECUTE a UNIX 'mv' to push it to the correct location and then write down the Fpointer. Susan Joslyn SJ+ Systems Associates, Inc. -- Date: Mon, 13 Jun 2005 10:41:58 +0200 From: Manu Fernandes [EMAIL PROTECTED] Subject: [U2] [uv]CREATE.FILE syntax for remote directories Hi all, Question : Is there a way to specify a full path+filename instead a filename in the CREATE.FILE command ? To have files created into other directory like the current. Thanks for any suggestions. Manu Fernandes Infodata S.`r.l. -- Date: Mon, 13 Jun 2005 10:51:51 +0100 From: Martin Phillips [EMAIL PROTECTED] Subject: Re: [U2] [uv]CREATE.FILE syntax for remote directories Question : Is there a way to specify a full path+filename instead a filename in the CREATE.FILE command ? No but the underlying operating system level program that does the CREATE.FILE can do this. /usr/uv/bin/mkdbfile pathname type modulo separation (with the appropriate path on the mkdbfile program) It is relatively easy to wrap a bit of Basic around this and build your own CREATE.PATH verb. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- 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] [uv]CREATE.FILE syntax for remote directories
Question : Is there a way to specify a full path+filename instead a filename in the CREATE.FILE command ? No but the underlying operating system level program that does the CREATE.FILE can do this. /usr/uv/bin/mkdbfile pathname type modulo separation (with the appropriate path on the mkdbfile program) It is relatively easy to wrap a bit of Basic around this and build your own CREATE.PATH verb. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/