Re: [U2] Coversion Code for Date
precisonl...@gmail.com wrote: >I think the difference might be Unidata vs. Universe. George, you're on UV, >right? Nathan is UD. I'd be interested to know, does D4-YMD work on UV? >___ >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] Conversion Code for Date
Tangentially,
ICONV( '20110603', 'D' ) = '15860'(15860 is internal date for
Jun 3, 2011.)
ICONV( '110603', 'D' ) = '15860'
OCONV('15860', 'DYMD[4,2,2]': @VM: 'MCN' ) = '20110603'
OCONV('15860', 'DYMD[2,2,2]': @VM: 'MCN' ) = '110603'
I went many years before discovering these ways of dealing with YYMMDD
&, MMDD.
I think I learned that on this list.
I'm ashamed to not recall whom I owe.
They are not reflexive so be careful if you use these as conversions in
a dictionary. As I-desc or correlative might be better.
By the way, that concatenation of the 2 vm-delimited conversion codes
happens at UV compile time, not run-time, because all 3 elements are
constants.
Chuck
On 6/3/2011 4:04 PM, Rex Gozar wrote:
FYI -
"DY4MD-" and "D4-YMD" will output -M-DD for single digit months.
"D4-YMD[4,2,2]" will properly output -MM-DD.
rex
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Coversion Code for Date
UV on HP-UX -- PI flavor : 0001: TODAY = DATE() : 0002: PRINT OCONV(TODAY,'D4-YMD') : 0003: END Bottom at line 3. : Q :RUN SRC RFPD4 2011-06-03 Robert F. Porter, MCSE, CCNA, ZCE, OCP-Java Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. >>> 6/3/2011 4:27 PM >>> I think the difference might be Unidata vs. Universe. George, you're on UV, right? Nathan is UD. I'd be interested to know, does D4-YMD work on UV? ___ 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] Coversion Code for Date
Another variation... OCONV(THE.DATE, 'DYMD-[4,2,2]') - Original Message - From: Bill Brutzman [mailto:bi...@hkmetalcraft.com] Sent: Friday, June 03, 2011 03:52 PM To: U2 Users List Subject: Re: [U2] Coversion Code for Date Consider something like... Today = date() This.Date = oconv(Today, 'DD') This.Month = oconv(Today, 'DM') This.Year = oconv(Today, 'DY') This.Long = This.Year : '-' : This.Month : '-' : This.Date --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Nathan Dube Sent: Friday, June 03, 2011 3:47 PM To: u2-users@listserver.u2ug.org Subject: [U2] Coversion Code for Date All This may be a noob question, but here it goes! Does anyone know what the conversion code is for a date field if I want to format the date as follows? -MM-DD Sincerely, Nathan Dube Network Administrator Jerry Pate Turf & Irrigation CONFIDENTIALITY NOTICE: This electronic mail transmission is intended only for use by the addressee(s) named herein and may contain information that is confidential, privileged, or proprietary. Distribution to anyone other than the addressee is prohibited. If you are not the intended recipient, you are not authorized to read, print, retain, copy or disseminate this message, any part of it, or any attachments. If you have received this message in error, please permanently delete this message and any attachments without reading the content and notify the sender immediately of the inadvertent transmission. ___ 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 CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Coversion Code for Date
I think the difference might be Unidata vs. Universe. George, you're on UV, right? Nathan is UD. I'd be interested to know, does D4-YMD work on UV? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Coversion Code for Date
Worked fine for me..Maybe that's a flavor issue.
I'm running in Information Flavor.
0001= PRINT OCONV(ICONV("01/01/2010","D"),"DY4MD-")
0002= STOP
0003= END
>RUN LIB TEST
2010-01-01
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Rex Gozar
> Sent: Friday, June 03, 2011 5:05 PM
> To: U2 Users List
> Subject: Re: [U2] Coversion Code for Date
>
> FYI -
>
> "DY4MD-" and "D4-YMD" will output -M-DD for single digit months.
> "D4-YMD[4,2,2]" will properly output -MM-DD.
>
> rex
> ___
> 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] Coversion Code for Date
Forgot to mention on Windows, Universe 10.3.7, Pick flavor: On Fri, Jun 3, 2011 at 5:04 PM, Rex Gozar wrote: > FYI - > > "DY4MD-" and "D4-YMD" will output -M-DD for single digit months. > "D4-YMD[4,2,2]" will properly output -MM-DD. > > rex > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Coversion Code for Date
FYI - "DY4MD-" and "D4-YMD" will output -M-DD for single digit months. "D4-YMD[4,2,2]" will properly output -MM-DD. rex ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Coversion Code for Date
Kevin King from Precision Solutions hooked me up btw. Sincerely, Nathan Dube Network Administrator Jerry Pate Turf & Irrigation -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Nathan Dube Sent: Friday, June 03, 2011 3:06 PM To: U2 Users List Subject: Re: [U2] Coversion Code for Date Looks like D4-YMD works. Thanks all! Sincerely, Nathan Dube Network Administrator Jerry Pate Turf & Irrigation -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Nathan Dube Sent: Friday, June 03, 2011 2:47 PM To: u2-users@listserver.u2ug.org Subject: [U2] Coversion Code for Date All This may be a noob question, but here it goes! Does anyone know what the conversion code is for a date field if I want to format the date as follows? -MM-DD Sincerely, Nathan Dube Network Administrator Jerry Pate Turf & Irrigation CONFIDENTIALITY NOTICE: This electronic mail transmission is intended only for use by the addressee(s) named herein and may contain information that is confidential, privileged, or proprietary. Distribution to anyone other than the addressee is prohibited. If you are not the intended recipient, you are not authorized to read, print, retain, copy or disseminate this message, any part of it, or any attachments. If you have received this message in error, please permanently delete this message and any attachments without reading the content and notify the sender immediately of the inadvertent transmission. ___ 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] Coversion Code for Date
Looks like D4-YMD works. Thanks all! Sincerely, Nathan Dube Network Administrator Jerry Pate Turf & Irrigation -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Nathan Dube Sent: Friday, June 03, 2011 2:47 PM To: u2-users@listserver.u2ug.org Subject: [U2] Coversion Code for Date All This may be a noob question, but here it goes! Does anyone know what the conversion code is for a date field if I want to format the date as follows? -MM-DD Sincerely, Nathan Dube Network Administrator Jerry Pate Turf & Irrigation CONFIDENTIALITY NOTICE: This electronic mail transmission is intended only for use by the addressee(s) named herein and may contain information that is confidential, privileged, or proprietary. Distribution to anyone other than the addressee is prohibited. If you are not the intended recipient, you are not authorized to read, print, retain, copy or disseminate this message, any part of it, or any attachments. If you have received this message in error, please permanently delete this message and any attachments without reading the content and notify the sender immediately of the inadvertent transmission. ___ 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] Coversion Code for Date
Consider something like... Today = date() This.Date = oconv(Today, 'DD') This.Month = oconv(Today, 'DM') This.Year = oconv(Today, 'DY') This.Long = This.Year : '-' : This.Month : '-' : This.Date --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Nathan Dube Sent: Friday, June 03, 2011 3:47 PM To: u2-users@listserver.u2ug.org Subject: [U2] Coversion Code for Date All This may be a noob question, but here it goes! Does anyone know what the conversion code is for a date field if I want to format the date as follows? -MM-DD Sincerely, Nathan Dube Network Administrator Jerry Pate Turf & Irrigation CONFIDENTIALITY NOTICE: This electronic mail transmission is intended only for use by the addressee(s) named herein and may contain information that is confidential, privileged, or proprietary. Distribution to anyone other than the addressee is prohibited. If you are not the intended recipient, you are not authorized to read, print, retain, copy or disseminate this message, any part of it, or any attachments. If you have received this message in error, please permanently delete this message and any attachments without reading the content and notify the sender immediately of the inadvertent transmission. ___ 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] Coversion Code for Date
OCONV(NIDATA<49,TAJ>,"DY4MD-") > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Nathan Dube > Sent: Friday, June 03, 2011 3:47 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] Coversion Code for Date > > All > > This may be a noob question, but here it goes! > > Does anyone know what the conversion code is for a date field if I want > to format the date as follows? > > -MM-DD > > Sincerely, > > Nathan Dube > Network Administrator > Jerry Pate Turf & Irrigation > > > > > CONFIDENTIALITY NOTICE: This electronic mail transmission is intended > only for use by the addressee(s) named herein and may contain > information that is confidential, privileged, or proprietary. > Distribution to anyone other than the addressee is prohibited. If you > are not the intended recipient, you are not authorized to read, print, > retain, copy or disseminate this message, any part of it, or any > attachments. If you have received this message in error, please > permanently delete this message and any attachments without reading the > content and notify the sender immediately of the inadvertent > transmission. > ___ > 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] Coversion Code for Date
All This may be a noob question, but here it goes! Does anyone know what the conversion code is for a date field if I want to format the date as follows? -MM-DD Sincerely, Nathan Dube Network Administrator Jerry Pate Turf & Irrigation CONFIDENTIALITY NOTICE: This electronic mail transmission is intended only for use by the addressee(s) named herein and may contain information that is confidential, privileged, or proprietary. Distribution to anyone other than the addressee is prohibited. If you are not the intended recipient, you are not authorized to read, print, retain, copy or disseminate this message, any part of it, or any attachments. If you have received this message in error, please permanently delete this message and any attachments without reading the content and notify the sender immediately of the inadvertent transmission. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniQuery Output to File
And, as always, Colin. :-) - Original Message - *From:* wphask...@advantos.net *To:* U2 Users List *Date:* 6/3/2011 9:14 AM *Subject:* Re: [U2] UniQuery Output to File Many thanks Matthew & Wally! :-) Bill - Original Message - *From:* wterh...@rocketsoftware.com *To:* U2 Users List *Date:* 6/2/2011 7:05 PM *Subject:* Re: [U2] UniQuery Output to File Plus UDT.OPTIONS 91 ON if you want output conversions applied to the data before writing to the text file. Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Matthew Strand Sent: Thursday, June 02, 2011 7:54 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniQuery Output to File > send UniQuery output to a file. Perhaps LIST TO DELIM? -- TO [DELIM "char"] text_file Lists records to a UNIX text file. If you use the DELIM keyword, UniData places char between each attribute in text_file. text_file cannot be strictly numeric. On 6/2/2011 9:43 PM, Bill Haskett wrote: I can't remember how to send UniQuery output to a file. I've looked all through "Using UniQuery" and the "UniQuery Commands Reference" with no luck. In D3, I could do whatever query I wanted and send it to a file as tab-delimeted, which would remove any headings, footings, breaks, subtotals, etc. I was sure UD could do something like this. When I tried to send output TOXML, wierd things happened to data that should have been on the same line as other data (it got separated from the line when I opened the file in Excel). This data was an I-Descriptor (Virtual Attribute) calling a BASIC subroutine. Any help would be appreciated. Thanks, Bill Haskett Advantos Systems, Inc. ___ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniQuery Output to File
Many thanks Matthew & Wally! :-) Bill - Original Message - *From:* wterh...@rocketsoftware.com *To:* U2 Users List *Date:* 6/2/2011 7:05 PM *Subject:* Re: [U2] UniQuery Output to File Plus UDT.OPTIONS 91 ON if you want output conversions applied to the data before writing to the text file. Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Matthew Strand Sent: Thursday, June 02, 2011 7:54 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniQuery Output to File > send UniQuery output to a file. Perhaps LIST TO DELIM? -- TO [DELIM "char"] text_file Lists records to a UNIX text file. If you use the DELIM keyword, UniData places char between each attribute in text_file. text_file cannot be strictly numeric. On 6/2/2011 9:43 PM, Bill Haskett wrote: I can't remember how to send UniQuery output to a file. I've looked all through "Using UniQuery" and the "UniQuery Commands Reference" with no luck. In D3, I could do whatever query I wanted and send it to a file as tab-delimeted, which would remove any headings, footings, breaks, subtotals, etc. I was sure UD could do something like this. When I tried to send output TOXML, wierd things happened to data that should have been on the same line as other data (it got separated from the line when I opened the file in Excel). This data was an I-Descriptor (Virtual Attribute) calling a BASIC subroutine. Any help would be appreciated. Thanks, Bill Haskett Advantos Systems, Inc. ___ 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] File Item Count Limit?
thanks for the info > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of John Thompson > Sent: Friday, June 03, 2011 10:18 AM > To: U2 Users List > Subject: Re: [U2] File Item Count Limit? > > You have the 64 bit option available if you are greater than Universe > version *9.5.1.1.C* > >*RESIZE* > > Use RESIZE to reorganize a file with a new file type, modulo, and > separation, or to change an existing nondynamic file to a dynamic file. > You > cannot use RESIZE to change the parameters of a dynamic file, or to > resize > an SQL table to a type 1, type 19, or type 25 file. > > *Syntax* > > *RESIZE *[ DICT] [ *filename*] [ *type*] [ *modulo*] [ *separation*][ > CONCURRENT > | INPLACE | USING *partition*] [ 64BIT | 32BIT] > > *RESIZE *[ DICT] [ *filename*] [ 30 | DYNAMIC] [ *parameter *[ > *value*]] ... [ > USING *partition*] [ 64BIT | 32BIT] > > > Not sure if that is readable... It took me some time to find this > command > documented when I was originally looking for it way back when... > Also on Rocket's documentation its under the User Reference Guide, page > 498 > in the PDF file. > I cut and pasted that from the 10.3 docs. I can't imagine that it has > changed much since version 9. > > Whatever you do, if you do decide to resize it or perhaps turn it into > a > dynamic file or something of the like, then DO NOT cancel the resize. > If > you kill a resize process, the file will no longer be usable because it > corrupts the file header. > > So if its a static hashed file and no one is accessing it, you can just > simply do a unix/windows copy on it and make a backup. > > If its already a dynamic file, then use your backup utility on it > before you > start. > Then you will have to use CONFIGURE.FILE to modify it, instead of > RESIZE I > believe. > CONFIGURE.FILE is on page 146 of the 10.3 docs. I doubt this has > changed > all that much either. > > Just remember, once you start the resize there is no going back until > you > finish it. So make sure no one is going to use the file and NEVER > CANCEL a > RESIZE. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] File Item Count Limit?
I don't think that will be a problem. maybe another day, I'll play with resizing to 64bit Thanks George > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Dan Fitzgerald > Sent: Friday, June 03, 2011 10:21 AM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] File Item Count Limit? > > ...so, when you see your file getting above, say, > 9,223,373,036,400,000,000, you may want to break it up into dynamic or > distributed files. > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata file behavior
On 06/03/2011 10:02 AM, Wally Terhune wrote: Sounds like you have been experimenting with UniData Data Replication? No - we have never played with it: Module Name Version Licensed UniData RDBMS 7.2 Yes Connection Pooling... 7.2 No Device License... 7.2 No NFA.. 7.2 No RFS.. 7.2 No EDA.. 7.2 No Are there any replication daemons present on this server? And shared memory segments associated with replication? ($UDTBIN/ipcstat -mb | grep rm) expect rm R7.2 (ctl) Here's what I see via showud: root 8459 0:01 /usr/ud72/bin/cleanupd -m 10 -t 20 root 8454 0:00 /usr/ud72/bin/sbcs -r root 8415 0:52 /usr/ud72/bin/smm -t 60 root 8430 0:06 /usr/unishared/unirpc/unirpcd Got an error with the -b flag to ipcstat but no output otherwise # /usr/ud72/bin/ipcstat -m | grep rm keyshmid owner perms bytes nattch status By default, replicated files on a subscribing system are 'read only' to protect the data. If you make a UNIX cp of that directory to a new name and create a new DIR pointer in the VOC for that new directory - does the behavior persist? No - the copy behaves properly. Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Butera Sent: Friday, June 03, 2011 6:47 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata file behavior Since upgrading from Unidata 7.2.5 to 7.2.9 (linux), I've had no issues - until this morning. I have a DIR named "_FD_" and am trying to do this: COPY FROM _FD_ "8101153.20110531143345423","8101153.20110531143345423.done" DELETING COPY FROM _FD_ "8101153.20110602140324102","8101153.20110602140324102.done" DELETING COPY FROM _FD_ "8101153.20110601140343637","8101153.20110601140343637.done" DELETING Here's what I'm getting which I've never seen before: _FD_(25231363,64768) is non-writeable subscribing file. 0 records copied _FD_(25231363,64768) is non-writeable subscribing file. 0 records copied _FD_(25231363,64768) is non-writeable subscribing file. 0 records copied If anyone has insights about a "subscribing file" I'd be appreciative - and I'm assuming this is a Unidata error and not OS. The _FD_ directory does have permissions allowing the user to rwx anything. -- Jeff Butera, PhD Manager of ERP Systems Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] File Item Count Limit?
I knew there was a good math person out there, that could figure that out :) Thanks. On Fri, Jun 3, 2011 at 10:21 AM, Dan Fitzgerald wrote: > > Actually, at 64b, the limit is slightly over 9 petabytes. I think that so > far this is theoretical; I'm guessing that nobody yet has put together a > disk array of 9 petabytes and created one large file... > > 2 raised to the (32-1) power is 2,147,483,648 > > 2 raised to the (64-1) power is 9,223,373,036,854,775,808. > > ...so, when you see your file getting above, say, > 9,223,373,036,400,000,000, you may want to break it up into dynamic or > distributed files. > > > Date: Fri, 3 Jun 2011 09:45:46 -0400 > > From: jthompson...@gmail.com > > To: u2-users@listserver.u2ug.org > > Subject: Re: [U2] File Item Count Limit? > > > > Also, If they are 64 bit files in Universe then they can grow quite large > on > > the disk. > > > > You can have a file that probably takes up to 64 GB of disk space. > > Depending on the record size, etc... who knows how many records that > could > > be. I don't have the formula's in front of me to figure that out. > > > > You can change whether a file is 32 or 64 bit in universe by using the > > RESIZE command. > > Its also a configurable paramater for newly created files in the uvconfig > > file. I think you can easily find it in UniAdmin somewhere. > > > > So even if that file you are referring to is a 32bit one and it exceeds 2 > GB > > on the disk, you can resize it (without users on the system), and turn it > > into a 64 GB file and let it keep growing. > > > > Of course, back it up first as always... > > > > So I think you will be ok, especially if the records don't have much data > in > > them as you say. > > > > On Thu, Jun 2, 2011 at 6:22 PM, Dan McGrath wrote: > > > > > Assuming you're talking about a hash file, I'd hazard a guess that it > > > would be only limited by: > > > 1) File size > > > 2) The ability of the tools to handle the file record list (such as > > > SELECT) > > > 2.1) I.e, memory limitations and > > > 2.2) The count variable (assuming it is a 32bit signed int, that gives > > > you a max 2^31 = 2147483648 records) > > > > > > -Original Message- > > > From: u2-users-boun...@listserver.u2ug.org > > > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George > Gallen > > > Sent: Friday, 3 June 2011 6:38 AM > > > To: U2 Users List > > > Subject: [U2] File Item Count Limit? > > > > > > I'm on UV/Linux > > > > > > Just curious, is there a limit to the number of items you can have in a > > > file? or just limited to overall file size? > > > We have one file that has about 15M items at present. Not much data in > > > each item, just a crap load of them. > > > > > > George > > > > > > > > > George Gallen > > > Senior Programmer/Analyst > > > Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com > > > ph:856.848.9005 Ext 220 > > > The Wyanoke Group > > > http://www.wyanokegroup.com > > > > > > > > > > > > ___ > > > U2-Users mailing list > > > U2-Users@listserver.u2ug.org > > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > __ > > > This email has been scanned by the MessageLabs Email Security System. > > > For more information please visit http://www.messagelabs.com/email > > > __ > > > > > > > ### > > > The information transmitted in this message and attachments (if any) is > > > intended only > > > for the person or entity to which it is addressed. The message may > contain > > > confidential > > > and/or privileged material. Any review, retransmission, dissemination > or > > > other use of > > > or taking of any action in reliance upon this information by persons or > > > entities other > > > than the intended recipient is prohibited. If you received this in > error, > > > please > > > contact the sender and delete the material from any computer. > > > > > > The intended recipient of this e-mail may only use, reproduce, disclose > or > > > distribute > > > the information contained in this e-mail and any attached files with > the > > > permission of IMB. > > > > > > > ### > > > ___ > > > U2-Users mailing list > > > U2-Users@listserver.u2ug.org > > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > > > > > > -- > > John Thompson > > ___ > > 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] File Item Count Limit?
Actually, at 64b, the limit is slightly over 9 petabytes. I think that so far this is theoretical; I'm guessing that nobody yet has put together a disk array of 9 petabytes and created one large file... 2 raised to the (32-1) power is 2,147,483,648 2 raised to the (64-1) power is 9,223,373,036,854,775,808. ...so, when you see your file getting above, say, 9,223,373,036,400,000,000, you may want to break it up into dynamic or distributed files. > Date: Fri, 3 Jun 2011 09:45:46 -0400 > From: jthompson...@gmail.com > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] File Item Count Limit? > > Also, If they are 64 bit files in Universe then they can grow quite large on > the disk. > > You can have a file that probably takes up to 64 GB of disk space. > Depending on the record size, etc... who knows how many records that could > be. I don't have the formula's in front of me to figure that out. > > You can change whether a file is 32 or 64 bit in universe by using the > RESIZE command. > Its also a configurable paramater for newly created files in the uvconfig > file. I think you can easily find it in UniAdmin somewhere. > > So even if that file you are referring to is a 32bit one and it exceeds 2 GB > on the disk, you can resize it (without users on the system), and turn it > into a 64 GB file and let it keep growing. > > Of course, back it up first as always... > > So I think you will be ok, especially if the records don't have much data in > them as you say. > > On Thu, Jun 2, 2011 at 6:22 PM, Dan McGrath wrote: > > > Assuming you're talking about a hash file, I'd hazard a guess that it > > would be only limited by: > > 1) File size > > 2) The ability of the tools to handle the file record list (such as > > SELECT) > > 2.1) I.e, memory limitations and > > 2.2) The count variable (assuming it is a 32bit signed int, that gives > > you a max 2^31 = 2147483648 records) > > > > -Original Message- > > From: u2-users-boun...@listserver.u2ug.org > > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen > > Sent: Friday, 3 June 2011 6:38 AM > > To: U2 Users List > > Subject: [U2] File Item Count Limit? > > > > I'm on UV/Linux > > > > Just curious, is there a limit to the number of items you can have in a > > file? or just limited to overall file size? > > We have one file that has about 15M items at present. Not much data in > > each item, just a crap load of them. > > > > George > > > > > > George Gallen > > Senior Programmer/Analyst > > Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com > > ph:856.848.9005 Ext 220 > > The Wyanoke Group > > http://www.wyanokegroup.com > > > > > > > > ___ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > __ > > This email has been scanned by the MessageLabs Email Security System. > > For more information please visit http://www.messagelabs.com/email > > __ > > > > ### > > The information transmitted in this message and attachments (if any) is > > intended only > > for the person or entity to which it is addressed. The message may contain > > confidential > > and/or privileged material. Any review, retransmission, dissemination or > > other use of > > or taking of any action in reliance upon this information by persons or > > entities other > > than the intended recipient is prohibited. If you received this in error, > > please > > contact the sender and delete the material from any computer. > > > > The intended recipient of this e-mail may only use, reproduce, disclose or > > distribute > > the information contained in this e-mail and any attached files with the > > permission of IMB. > > > > ### > > ___ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > -- > John Thompson > ___ > 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] File Item Count Limit?
You have the 64 bit option available if you are greater than Universe version *9.5.1.1.C* *RESIZE* Use RESIZE to reorganize a file with a new file type, modulo, and separation, or to change an existing nondynamic file to a dynamic file. You cannot use RESIZE to change the parameters of a dynamic file, or to resize an SQL table to a type 1, type 19, or type 25 file. *Syntax* *RESIZE *[ DICT] [ *filename*] [ *type*] [ *modulo*] [ *separation*][ CONCURRENT | INPLACE | USING *partition*] [ 64BIT | 32BIT] *RESIZE *[ DICT] [ *filename*] [ 30 | DYNAMIC] [ *parameter *[ *value*]] … [ USING *partition*] [ 64BIT | 32BIT] Not sure if that is readable... It took me some time to find this command documented when I was originally looking for it way back when... Also on Rocket's documentation its under the User Reference Guide, page 498 in the PDF file. I cut and pasted that from the 10.3 docs. I can't imagine that it has changed much since version 9. Whatever you do, if you do decide to resize it or perhaps turn it into a dynamic file or something of the like, then DO NOT cancel the resize. If you kill a resize process, the file will no longer be usable because it corrupts the file header. So if its a static hashed file and no one is accessing it, you can just simply do a unix/windows copy on it and make a backup. If its already a dynamic file, then use your backup utility on it before you start. Then you will have to use CONFIGURE.FILE to modify it, instead of RESIZE I believe. CONFIGURE.FILE is on page 146 of the 10.3 docs. I doubt this has changed all that much either. Just remember, once you start the resize there is no going back until you finish it. So make sure no one is going to use the file and NEVER CANCEL a RESIZE. On Fri, Jun 3, 2011 at 10:03 AM, George Gallen wrote: > Well, this process is still runningand it's up to just about 15M (1.3g) > so hopefully, it will be done very soon - I estimated this to take > about an hour or so, well, thats turning into almost 20 hours. > > I don't know if I have the 64bit option available, I could but something > tells me I don't - I'm on version 10.0.2 of UV > > But if it crashes the process because the file gets too big, I'll have to > pare down what gets written out - just less history, this is a file > that once it's created, it's exported and rarely used, so it's getting > the slow > part out of the way once, after that, it runs fast for updating. > > > -Original Message- > > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > > boun...@listserver.u2ug.org] On Behalf Of John Thompson > > Sent: Friday, June 03, 2011 9:46 AM > > To: U2 Users List > > Subject: Re: [U2] File Item Count Limit? > > > > Also, If they are 64 bit files in Universe then they can grow quite > > large on > > the disk. > > > > You can have a file that probably takes up to 64 GB of disk space. > > Depending on the record size, etc... who knows how many records that > > could > > be. I don't have the formula's in front of me to figure that out. > > > > You can change whether a file is 32 or 64 bit in universe by using the > > RESIZE command. > > Its also a configurable paramater for newly created files in the > > uvconfig > > file. I think you can easily find it in UniAdmin somewhere. > > > > So even if that file you are referring to is a 32bit one and it exceeds > > 2 GB > > on the disk, you can resize it (without users on the system), and turn > > it > > into a 64 GB file and let it keep growing. > > > > Of course, back it up first as always... > > > > So I think you will be ok, especially if the records don't have much > > data in > > them as you say. > > > > On Thu, Jun 2, 2011 at 6:22 PM, Dan McGrath wrote: > > > > > Assuming you're talking about a hash file, I'd hazard a guess that it > > > would be only limited by: > > > 1) File size > > > 2) The ability of the tools to handle the file record list (such as > > > SELECT) > > > 2.1) I.e, memory limitations and > > > 2.2) The count variable (assuming it is a 32bit signed int, that > > gives > > > you a max 2^31 = 2147483648 records) > > > > > > -Original Message- > > > From: u2-users-boun...@listserver.u2ug.org > > > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George > > Gallen > > > Sent: Friday, 3 June 2011 6:38 AM > > > To: U2 Users List > > > Subject: [U2] File Item Count Limit? > > > > > > I'm on UV/Linux > > > > > > Just curious, is there a limit to the number of items you can have in > > a > > > file? or just limited to overall file size? > > > We have one file that has about 15M items at present. Not much data > > in > > > each item, just a crap load of them. > > > > > > George > > > > > > > > > George Gallen > > > Senior Programmer/Analyst > > > Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com > > > ph:856.848.9005 Ext 220 > > > The Wyanoke Group > > > http://www.wyanokegroup.com > > > > > > > > > > > > _
Re: [U2] File Item Count Limit?
Well, this process is still runningand it's up to just about 15M (1.3g) so hopefully, it will be done very soon - I estimated this to take about an hour or so, well, thats turning into almost 20 hours. I don't know if I have the 64bit option available, I could but something tells me I don't - I'm on version 10.0.2 of UV But if it crashes the process because the file gets too big, I'll have to pare down what gets written out - just less history, this is a file that once it's created, it's exported and rarely used, so it's getting the slow part out of the way once, after that, it runs fast for updating. > -Original Message- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of John Thompson > Sent: Friday, June 03, 2011 9:46 AM > To: U2 Users List > Subject: Re: [U2] File Item Count Limit? > > Also, If they are 64 bit files in Universe then they can grow quite > large on > the disk. > > You can have a file that probably takes up to 64 GB of disk space. > Depending on the record size, etc... who knows how many records that > could > be. I don't have the formula's in front of me to figure that out. > > You can change whether a file is 32 or 64 bit in universe by using the > RESIZE command. > Its also a configurable paramater for newly created files in the > uvconfig > file. I think you can easily find it in UniAdmin somewhere. > > So even if that file you are referring to is a 32bit one and it exceeds > 2 GB > on the disk, you can resize it (without users on the system), and turn > it > into a 64 GB file and let it keep growing. > > Of course, back it up first as always... > > So I think you will be ok, especially if the records don't have much > data in > them as you say. > > On Thu, Jun 2, 2011 at 6:22 PM, Dan McGrath wrote: > > > Assuming you're talking about a hash file, I'd hazard a guess that it > > would be only limited by: > > 1) File size > > 2) The ability of the tools to handle the file record list (such as > > SELECT) > > 2.1) I.e, memory limitations and > > 2.2) The count variable (assuming it is a 32bit signed int, that > gives > > you a max 2^31 = 2147483648 records) > > > > -Original Message- > > From: u2-users-boun...@listserver.u2ug.org > > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George > Gallen > > Sent: Friday, 3 June 2011 6:38 AM > > To: U2 Users List > > Subject: [U2] File Item Count Limit? > > > > I'm on UV/Linux > > > > Just curious, is there a limit to the number of items you can have in > a > > file? or just limited to overall file size? > > We have one file that has about 15M items at present. Not much data > in > > each item, just a crap load of them. > > > > George > > > > > > George Gallen > > Senior Programmer/Analyst > > Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com > > ph:856.848.9005 Ext 220 > > The Wyanoke Group > > http://www.wyanokegroup.com > > > > > > > > ___ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > __ > > This email has been scanned by the MessageLabs Email Security System. > > For more information please visit http://www.messagelabs.com/email > > > __ > > > > > ### > > > The information transmitted in this message and attachments (if any) > is > > intended only > > for the person or entity to which it is addressed. The message may > contain > > confidential > > and/or privileged material. Any review, retransmission, > dissemination or > > other use of > > or taking of any action in reliance upon this information by persons > or > > entities other > > than the intended recipient is prohibited. If you received this in > error, > > please > > contact the sender and delete the material from any computer. > > > > The intended recipient of this e-mail may only use, reproduce, > disclose or > > distribute > > the information contained in this e-mail and any attached files with > the > > permission of IMB. > > > > > ### > > > ___ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > -- > John Thompson > ___ > 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] Unidata file behavior
Sounds like you have been experimenting with UniData Data Replication? Are there any replication daemons present on this server? And shared memory segments associated with replication? ($UDTBIN/ipcstat -mb | grep rm) expect rm R7.2 (ctl) By default, replicated files on a subscribing system are 'read only' to protect the data. If you make a UNIX cp of that directory to a new name and create a new DIR pointer in the VOC for that new directory - does the behavior persist? Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Butera Sent: Friday, June 03, 2011 6:47 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata file behavior Since upgrading from Unidata 7.2.5 to 7.2.9 (linux), I've had no issues - until this morning. I have a DIR named "_FD_" and am trying to do this: COPY FROM _FD_ "8101153.20110531143345423","8101153.20110531143345423.done" DELETING COPY FROM _FD_ "8101153.20110602140324102","8101153.20110602140324102.done" DELETING COPY FROM _FD_ "8101153.20110601140343637","8101153.20110601140343637.done" DELETING Here's what I'm getting which I've never seen before: _FD_(25231363,64768) is non-writeable subscribing file. 0 records copied _FD_(25231363,64768) is non-writeable subscribing file. 0 records copied _FD_(25231363,64768) is non-writeable subscribing file. 0 records copied If anyone has insights about a "subscribing file" I'd be appreciative - and I'm assuming this is a Unidata error and not OS. The _FD_ directory does have permissions allowing the user to rwx anything. -- Jeff Butera, PhD Manager of ERP Systems Hampshire College 413-559-5556 ___ 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] File Item Count Limit?
Also, If they are 64 bit files in Universe then they can grow quite large on the disk. You can have a file that probably takes up to 64 GB of disk space. Depending on the record size, etc... who knows how many records that could be. I don't have the formula's in front of me to figure that out. You can change whether a file is 32 or 64 bit in universe by using the RESIZE command. Its also a configurable paramater for newly created files in the uvconfig file. I think you can easily find it in UniAdmin somewhere. So even if that file you are referring to is a 32bit one and it exceeds 2 GB on the disk, you can resize it (without users on the system), and turn it into a 64 GB file and let it keep growing. Of course, back it up first as always... So I think you will be ok, especially if the records don't have much data in them as you say. On Thu, Jun 2, 2011 at 6:22 PM, Dan McGrath wrote: > Assuming you're talking about a hash file, I'd hazard a guess that it > would be only limited by: > 1) File size > 2) The ability of the tools to handle the file record list (such as > SELECT) > 2.1) I.e, memory limitations and > 2.2) The count variable (assuming it is a 32bit signed int, that gives > you a max 2^31 = 2147483648 records) > > -Original Message- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen > Sent: Friday, 3 June 2011 6:38 AM > To: U2 Users List > Subject: [U2] File Item Count Limit? > > I'm on UV/Linux > > Just curious, is there a limit to the number of items you can have in a > file? or just limited to overall file size? > We have one file that has about 15M items at present. Not much data in > each item, just a crap load of them. > > George > > > George Gallen > Senior Programmer/Analyst > Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com > ph:856.848.9005 Ext 220 > The Wyanoke Group > http://www.wyanokegroup.com > > > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > __ > This email has been scanned by the MessageLabs Email Security System. > For more information please visit http://www.messagelabs.com/email > __ > > ### > The information transmitted in this message and attachments (if any) is > intended only > for the person or entity to which it is addressed. The message may contain > confidential > and/or privileged material. Any review, retransmission, dissemination or > other use of > or taking of any action in reliance upon this information by persons or > entities other > than the intended recipient is prohibited. If you received this in error, > please > contact the sender and delete the material from any computer. > > The intended recipient of this e-mail may only use, reproduce, disclose or > distribute > the information contained in this e-mail and any attached files with the > permission of IMB. > > ### > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata file behavior
Since upgrading from Unidata 7.2.5 to 7.2.9 (linux), I've had no issues - until this morning. I have a DIR named "_FD_" and am trying to do this: COPY FROM _FD_ "8101153.20110531143345423","8101153.20110531143345423.done" DELETING COPY FROM _FD_ "8101153.20110602140324102","8101153.20110602140324102.done" DELETING COPY FROM _FD_ "8101153.20110601140343637","8101153.20110601140343637.done" DELETING Here's what I'm getting which I've never seen before: _FD_(25231363,64768) is non-writeable subscribing file. 0 records copied _FD_(25231363,64768) is non-writeable subscribing file. 0 records copied _FD_(25231363,64768) is non-writeable subscribing file. 0 records copied If anyone has insights about a "subscribing file" I'd be appreciative - and I'm assuming this is a Unidata error and not OS. The _FD_ directory does have permissions allowing the user to rwx anything. -- Jeff Butera, PhD Manager of ERP Systems Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniQuery Output to File
Even if you are in proc or in P mode, you can always use the lowercase version of the LIST verb to force U mode parsing of the query. Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com Sent: Friday, June 03, 2011 6:23 AM To: U2 Users List Subject: Re: [U2] UniQuery Output to File And I've found that I need to be in type U for LIST ... TO DELIM to work. Type P gives "syntax error" Maybe there's a UDT.OPTION for that? Brad From: Colin Alfke To: Date: 06/02/2011 10:42 PM Subject:Re: [U2] UniQuery Output to File Sent by:u2-users-boun...@listserver.u2ug.org I've been using the LIST TO DELIM a lot lately. It works reasonably well although I don't use it for any MV'd data. You can enter a as the delim and it will work. You can even put the full path for the text_file in the statement otherwise it's created in the current directory. As Wally says turn on UDT.OPTION 91 although I think dates are the only thing that really needs it. hth Colin Alfke Calgary Canada > From: mstrand > > > send UniQuery output to a file. > > Perhaps LIST TO DELIM? > > -- > TO [DELIM "char"] text_file > > Lists records to a UNIX text file. If you use the > DELIM keyword, UniData places char between each > attribute in text_file. text_file cannot be strictly > numeric. > > > > On 6/2/2011 9:43 PM, Bill Haskett wrote: > > I can't remember how to send UniQuery output to a file. I've looked all > > through "Using UniQuery" and the "UniQuery Commands Reference" with no > > luck. > > > > In D3, I could do whatever query I wanted and send it to a file as > > tab-delimeted, which would remove any headings, footings, breaks, > > subtotals, etc. I was sure UD could do something like this. When I tried > > to send output TOXML, wierd things happened to data that should have > > been on the same line as other data (it got separated from the line when > > I opened the file in Excel). This data was an I-Descriptor (Virtual > > Attribute) calling a BASIC subroutine. > > > > Any help would be appreciated. Thanks, > > > > Bill Haskett ___ 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] UniQuery Output to File
And I've found that I need to be in type U for LIST ... TO DELIM to work. Type P gives "syntax error" Maybe there's a UDT.OPTION for that? Brad From: Colin Alfke To: Date: 06/02/2011 10:42 PM Subject:Re: [U2] UniQuery Output to File Sent by:u2-users-boun...@listserver.u2ug.org I've been using the LIST TO DELIM a lot lately. It works reasonably well although I don't use it for any MV'd data. You can enter a as the delim and it will work. You can even put the full path for the text_file in the statement otherwise it's created in the current directory. As Wally says turn on UDT.OPTION 91 although I think dates are the only thing that really needs it. hth Colin Alfke Calgary Canada > From: mstrand > > > send UniQuery output to a file. > > Perhaps LIST TO DELIM? > > -- > TO [DELIM "char"] text_file > > Lists records to a UNIX text file. If you use the > DELIM keyword, UniData places char between each > attribute in text_file. text_file cannot be strictly > numeric. > > > > On 6/2/2011 9:43 PM, Bill Haskett wrote: > > I can't remember how to send UniQuery output to a file. I've looked all > > through "Using UniQuery" and the "UniQuery Commands Reference" with no > > luck. > > > > In D3, I could do whatever query I wanted and send it to a file as > > tab-delimeted, which would remove any headings, footings, breaks, > > subtotals, etc. I was sure UD could do something like this. When I tried > > to send output TOXML, wierd things happened to data that should have > > been on the same line as other data (it got separated from the line when > > I opened the file in Excel). This data was an I-Descriptor (Virtual > > Attribute) calling a BASIC subroutine. > > > > Any help would be appreciated. Thanks, > > > > Bill Haskett ___ 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
