I would think you are better off getting an example from your VAR, or
the people that supplied/wrote your application, who will be better
equipped to discuss what data you wish to extract from which files
(tables), and where you are looking at putting/using the extracted data
Ross Ferris
Stamina
I have added the errlog to the UV home directory and got the following results
as I expected.
The cause of the issue is a COMMON size mismatch.
But it does not tell me why it works in VB6 and Java and not .NET UniObjects.
Mon Oct 12 19:05:00 -3949 ITVISION.COM.AU\adrian.halid COMMON size
The big question is extract to what ? csv ? xml ? another data table ?
Here is a very quick simple extract to a csv - this is just off the top of
my head so i have not compiled it or tested it.
OPEN 'FILE' TO FIL ESLE STOP 201,'FILE'
OPENSEQ 'OUTPUT.CSV' TO CSVFIL
WEOFSEQ CSVFIL
SELECT FIL
LOOP
Thanks Symeon
I have created one program file (outfile ) with followinf contents
Facing compilation error
OPEN 'CUSTOMER' TO FIL ELSE STOP 201 'CUSTOMER'
OPENSEQ 'OUTPUT.CSV' TO CSVFIL
WEOFSEQ CSVFIL
SELECT FIL
LOOP WHILE READNEXT ID DO
READ REC FROM FIL,ID THEN
LINE = '' :
ELSE NULL
Will work.
Syntax for all these commands is in BASR.PDF, downloadable from web for
free...
Edward
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya
Walgude
Sent: 12 October 2009 12:22
To: U2
Many Many Thanks Edward and Symeon
Its work...
Thanks Regards,
Dattatraya Walgude
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown
Sent: Monday, October 12, 2009 4:55 PM
To: U2 Users List
Subject:
Output is not readable:-
14334ýITOý0ýAýý16811,14334ýCHAý CHA to Risk Rate: Mass_Aýýý16811
14369ýITOý0ýAýý61491,14369ýCHAý CHA to Risk Rate: Ten7_Aýýý61491
13977ýITAýýAýý60625
15030ýITOý0ýAýý70410,15030ýMEMý1ýPayment Responsibility ChangedýýFrom
To N On
If you goal is to simply count the number of records that match a
criteria, consider the COUNT statement.
David Laansma
IT Manager
Hubbard Supply Co.
Direct: 810-342-7143
Office: 810-234-8681
Fax: 810-234-6142
www.hubbardsupply.com
Delivering Products, Services and Innovative Solutions
The code is just an example to get you started - i suggest you read the
manual or get on a course etc to understand better the data model and
language. There are numerous things you can do to extend this program, you
will need to ensure there are no in the data, the example is changing sub
values
Thanks for your support.
We get output of multivalve columns.
Only things is we can not get out of DATE column is date format.
So please give your suggestions.
JonesBob123 E. 23rd St. Arvada CO 80276 3037768854 V4341
9611D C R 7
Dattatraya
Not wanting to be unhelpful here, but really even if you've never used the
unidata version of Basic before there's enough information in the sample to see
how to concatenate the ID of each record to the start of each line in the
output file.
Hint - It's the : operator. The variable
Dates are typically stored in internal format - so use something like
OCONV(DATE.VAR,D4/) to format it.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya
Walgude
Sent: Monday, October 12, 2009 6:24 AM
To:
You shouldn't have any problem with TMP files exceeding 2gb with BUILD.INDEX at
UniData 7.2 - assuming your TMP filesystem supports large files. I presume this
was the problem Brad encountered.
Prior to 7.2, you may have an issue if you PHANTOM the BUILD.INDEX command, or
if you start a udt
Wally,
That's what I'm talking about!! Thanks for the update...
Here's another one: temp files are very important in SQL. Another example of an
improvement would be to get the SQL temp files to work outside of the old AE
style SQL editor, in BASIC especially. Then, we could use one of most
Thank you Stuart, with a little tweaking I got it to work.
On Fri, Oct 9, 2009 at 9:37 AM, Lloyd Cottrell lbc7...@gmail.com wrote:
I have a need to take out the transaction logging flag inside of some
files. Can someone give me some info on how to write to the file header.
These files that
Bill Haskett said the following on 11:59 AM:
Brad:
This sounds like something you should submit to the BB area of the U2
User Group website.
Bill
broadri...@comcast.net said the following on 10/12/2009 8:16 AM:
Yes, I also like U2. It has interesting historical associations, for those of
us of a certain age. It was a U2 spy-plane that was shot down by a rocket
over the USSR in 1960 that led to quite a frosty first meeting between
Khruschev and Kennedy in Geneva that year.
Which leads me to ask if
This data is obviously from an company that deals with a Colorado data or is
based in Colorado.
And you are from outsource product develop company in India that has been
tasked to work on this U2 system.
So...We have some programmers that know U2 that need more work...
So...Why are we teaching
Friends and those who could be...
I've had more than a few years to think about the double-edged value
proposition that extended relational database systems offer.
Few of us actively immersed in developing and /or using extended relational
databases can complain of their efficacy, reliability
And you are from outsource product develop company in India that has been
tasked to work on this U2 system.
http://www.rsystems.com/
It is a question that needs to be asked. Was this firm contracted for support
or for development?
___
U2-Users
Love the U2-rocket story, Dominic. I don't know if there is any U2 in
Russia or related countries, but I understand that some PICK or
PICK-a-like system was used to track Russian spies in the US, perhaps
all the way to the end of the cold war. If anyone has details on that,
such as which MV flavor
Doesn't matter which. We are the next group that will be asked to work
for reduced pay or our work will go to India.
Bruce M Neylon
Health Care Management Group
Phone: (301) 608-8633
Charlie Rubeor crub...@1199nefunds.org
Sent by: u2-users-boun...@listserver.u2ug.org
10/12/2009 04:10 PM
Prime Information
Jerry Banker
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dawn Wolthuis
Sent: Monday, October 12, 2009 3:32 PM
To: U2 Users List
Subject: Re: [U2] U2 is now Rocket U2
Love the U2-rocket story,
Indian development firms aren't all they're cracked up to be, especially in
anything other than Microsoft technologies. I've seen exactly this
progression in other language lists to which I belong. Indian firm gets
contract based on price and claim to know the language. Indian firm tries
to get
What you say is correct Lee. However those days are gone with GFC for many
large operations. U2 sales are OEM, people buy the package not the database.
Even Oracle, is doing a major push to attract OEM as their sales future and so
is Microsoft. Most boards, managers and companies do not
Pick Systems actually had RD over in Russia 10 years ago, not sure if that
is still the case
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Thanks for the replies,
@David Hona
Thanks for that. There shouldn't be an issue with the execution layer of
EXECUTE in regards to select lists as the following processes correctly:
Giving a FILE, X with 3 records: AA, AB and BB
EXECUTE 'SELECT X with @ID = A]'
EXECUTE 'SELECT X with @ID = [B'
You can just use the CLEARSELECT function in your basic code on UV, instead of
using execute or perform.
Tom
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath
Sent: Monday, October 12, 2009 5:56 PM
To:
Indeed, the same is true in UD and that has what we have told all the
programmers moving forward. When we have over 3000 UD programs as part
of the live system, the maintenance work to fix all those already
affected (read: Paper work and approval...), is the real pain.
-Original Message-
Didn't Ultimate have a development center around Moscow?
Steve
-- Sent from my Palm Pre
jpb-u2ug wrote:
Prime Information
Jerry Banker
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dawn Wolthuis
Sent:
Dan:
I'm running v7.2 here in my development environment and v7.1 elsewhere
in several production environments. This program runs the same on both
environments:
2 Dev (0)- BPTEST EXECUTE \SELECT TEMP\ CAPTURING OUTPUT ; NoOfItems =
SYSTEM(11) ; CRT NoOfItems : ' selected...' ; CLEARSELECT
Thanks Bill,
The Dev was pulling his hair out for a while working out why some code
was apparently processing 8 records, but only actually did it on 4. The
joys of working with legacy code (or any code, I guess.) :)
I think the code we are running was ported from Pick to UD 5.x
originally, so
What about overloading the CLEARSELECT voc item so that it runs a program
that does a UDTEXECUTE CLEARSELECT.
You wouldn't have to update your programs, plus when you upgraded to a
version without this issue, you could easily remove the workaround.
Note: I didn't test it to see how well/if it
Nope.
I renamed CLEARSELECT to OLD.CLEARSELECT and did UDTEXECUTE
OLD.CLEARSELECT so as to not have a recursion issue, but had no luck
I tested it as follows:
PROGRAM CLEARSELECT:
1 UDTEXECUTE OLD.CLEARSELECT
Compiled and successfully tested on the command line:
:SELECT TEST
3 records
34 matches
Mail list logo