Re: [U2] UniQuery Output to File

2011-06-03 Thread bradley . schrag
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 alfke...@hotmail.com To: u2-users@listserver.u2ug.org Date: 06/02/2011 10:42 PM Subject:Re: [U2] UniQuery Output to

Re: [U2] UniQuery Output to File

2011-06-03 Thread Wally Terhune
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:

[U2] Unidata file behavior

2011-06-03 Thread Jeff Butera
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_

Re: [U2] File Item Count Limit?

2011-06-03 Thread John Thompson
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.

Re: [U2] Unidata file behavior

2011-06-03 Thread Wally Terhune
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

Re: [U2] File Item Count Limit?

2011-06-03 Thread George Gallen
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

Re: [U2] File Item Count Limit?

2011-06-03 Thread John Thompson
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

Re: [U2] File Item Count Limit?

2011-06-03 Thread Dan Fitzgerald
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

Re: [U2] File Item Count Limit?

2011-06-03 Thread John Thompson
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 dangf...@hotmail.comwrote: 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

Re: [U2] Unidata file behavior

2011-06-03 Thread Jeff Butera
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

Re: [U2] File Item Count Limit?

2011-06-03 Thread George Gallen
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:

Re: [U2] File Item Count Limit?

2011-06-03 Thread George Gallen
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

Re: [U2] UniQuery Output to File

2011-06-03 Thread Bill Haskett
Many thanks Matthew Wally! :-) Bill - Original Message - *From:* wterh...@rocketsoftware.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 6/2/2011 7:05 PM *Subject:* Re: [U2] UniQuery Output to File

Re: [U2] UniQuery Output to File

2011-06-03 Thread Bill Haskett
And, as always, Colin. :-) - Original Message - *From:* wphask...@advantos.net *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 6/3/2011 9:14 AM *Subject:* Re: [U2] UniQuery Output to File Many thanks

[U2] Coversion Code for Date

2011-06-03 Thread Nathan Dube
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

Re: [U2] Coversion Code for Date

2011-06-03 Thread George Gallen
OCONV(NIDATA49,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

Re: [U2] Coversion Code for Date

2011-06-03 Thread Bill Brutzman
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

Re: [U2] Coversion Code for Date

2011-06-03 Thread Nathan Dube
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:

Re: [U2] Coversion Code for Date

2011-06-03 Thread Nathan Dube
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,

Re: [U2] Coversion Code for Date

2011-06-03 Thread Rex Gozar
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

2011-06-03 Thread Rex Gozar
Forgot to mention on Windows, Universe 10.3.7, Pick flavor: On Fri, Jun 3, 2011 at 5:04 PM, Rex Gozar rgo...@gmail.com 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

Re: [U2] Coversion Code for Date

2011-06-03 Thread George Gallen
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-

Re: [U2] Coversion Code for Date

2011-06-03 Thread precisonline
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

Re: [U2] Coversion Code for Date

2011-06-03 Thread Perry Taylor
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 u2-users@listserver.u2ug.org Subject: Re: [U2] Coversion Code for Date Consider something like... Today

Re: [U2] Coversion Code for Date

2011-06-03 Thread Robert Porter
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

Re: [U2] Coversion Code for Date

2011-06-03 Thread Curt Stewart
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