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
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:
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_
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.
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
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
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
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
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
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
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:
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
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
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
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
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
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
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:
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,
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
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
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-
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
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
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
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
26 matches
Mail list logo