On 26/10/11 00:23, Steve Romanow wrote:
I reread my post and meant no disrespect Wols. I shouldnt post replies
without considering twice.
No worries Steve. I shoot from the hip sometimes too - it can be
embarrassing :-)
Cheers,
Wol
___
U2-Users
-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma
Sent: Tuesday, October 25, 2011 4:59 PM
To: U2 Users List
Subject: Re: [U2] UniBasic Question
Unless you know the keys to the records you're selecting, even the
EXECUTE SELECT ... is going to have
Can anyone help explain this behavior or offer a workaround that saves me
from handling it with line counters and printing my own
headings?Cheers,Kebbon
___
Perry's approach is the correct one. If you want to
And... when you prematurely quit from an execution level which *had* been
processing a select list your select list is not thrown away.
Which is annoying.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
grabs both the key and record, due to the construct of the
database.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Tuesday, October 25, 2011 4:08 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2
Dave
The next-to-last one may depend on Unidata vs. Universe. I understand
that Unidata only 'fetches' the key in the READNEXT while I believe
Universe grabs both the key and record, due to the construct of the
database.
I believe that is the case in Unidata. A SELECT returns a list of
, October 25, 2011 4:53 PM
To: U2 Users List
Subject: Re: [U2] UniBasic Question
Dave
The next-to-last one may depend on Unidata vs. Universe. I
understand that Unidata only 'fetches' the key in the READNEXT while
I believe Universe grabs both the key and record, due to the
construct
Unless you know the keys to the records you're selecting, even the
EXECUTE SELECT ... is going to have to read each record, how else
would it know which records to throw out?
SELECT is definitely faster than EXECUTE SELECT... and I try and use it
first.
Charles Shaffer
Senior Analyst
I don't know if I agree that SELECT is faster. If you are using
indexed fields, SELECT is definitely not the good choice.
On Tue, Oct 25, 2011 at 5:14 PM, charles_shaf...@ntn-bower.com wrote:
Unless you know the keys to the records you're selecting, even the
EXECUTE SELECT ... is going to
I don't know if I agree that SELECT is faster. If you are using
indexed fields, SELECT is definitely not the good choice.
Are you saying that when there is an index, the system does not need to
read the record at all? It just gets the SELECT list from the index? Is
this only true in
with only a slight difference.
BobW
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
charles_shaf...@ntn-bower.com
Sent: Tuesday, October 25, 2011 2:14 PM
To: U2 Users List
Subject: Re: [U2] UniBasic Question
Unless you know
True on UV, too.
Compare output of these using EXPLAIN keyword:
LIST FILE WITH indexed_field = soemthing EXPLAIN
LIST FILE WITH indexed_field = soemthing EXPLAIN NO.INDEX
Or forget EXPLAIN, but do it with a large file and notice the speed
differnce.
On 10/25/2011 4:29 PM,
Add a second selection criteria and the benefit of the index is washed
out.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles
Stevenson
Sent: Tuesday, October 25, 2011 2:39 PM
To: U2 Users List
Subject: Re: [U2
criteria and the benefit of the index is washed
out.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles
Stevenson
Sent: Tuesday, October 25, 2011 2:39 PM
To: U2 Users List
Subject: Re: [U2] UniBasic
Yes yes and no.
If you execute a SSELECT on an indexed field, and don't specify NO.INDEX and do
NOT refer at all to any other fields in the file, then index does NOT read the
record to see if it even actually exists. It just retrieves the list of keys
from the index.
If you specific a
Of Charles
Stevenson
Sent: Tuesday, October 25, 2011 2:39 PM
To: U2 Users List
Subject: Re: [U2] UniBasic Question
True on UV, too.
Compare output of these using EXPLAIN keyword:
LIST FILE WITH indexed_field = soemthing EXPLAIN
LIST FILE WITH indexed_field = soemthing EXPLAIN NO.INDEX
Or forget
But you are potentially reducing your input set for the 2nd criteria
by a large margin correct?
I've never considered alt key + non-indexed usage to create disk thrash.
When you select on an alternate key index, you are reading the file,
but (in Udt at least) an X_myfile binary file. So you are
of the index is washed
out.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles
Stevenson
Sent: Tuesday, October 25, 2011 2:39 PM
To: U2 Users List
Subject: Re: [U2] UniBasic Question
True on UV, too.
Compare output
like the way the records are layed on the disk.
That causes thrashing.
-Original Message-
From: Steve Romanow slestak...@gmail.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Tue, Oct 25, 2011 3:07 pm
Subject: Re: [U2] UniBasic Question
But you are potentially reducing your
@listserver.u2ug.org
Sent: Tue, Oct 25, 2011 3:08 pm
Subject: Re: [U2] UniBasic Question
RetrieVe will use an index if it can, regardless of the order of the
election criteria ( if not select list is already active).
etrieVe will now do intersections of index reults if 2 indexed
election criteria
On 25/10/11 22:22, Steve Romanow wrote:
I don't know if I agree that SELECT is faster. If you are using
indexed fields, SELECT is definitely not the good choice.
SELECT *is* faster. Because it does far less work!
EXECUTE SELECT needs to read the entire file to create a select list.
SELECT
Consider a sparse file. I have seen where a execute select is faster so I
counter your AlwaysFaster claim. Like the previous poster said, it will
always be fastest to start, but not always first to complete.
On Oct 25, 2011 7:00 PM, Wols Lists antli...@youngman.org.uk wrote:
On 25/10/11
I reread my post and meant no disrespect Wols. I shouldnt post replies
without considering twice.
On Oct 25, 2011 7:00 PM, Wols Lists antli...@youngman.org.uk wrote:
On 25/10/11 22:22, Steve Romanow wrote:
I don't know if I agree that SELECT is faster. If you are using
indexed fields,
Is this unibasic doing an execute and the 'report' done using a List command
?
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kebbon Irwin
Sent: 24 October 2011 16:13
To: u2-users@listserver.u2ug.org
Subject:
the behavior?
From: syme...@gmail.com
To: u2-users@listserver.u2ug.org
Date: Mon, 24 Oct 2011 16:20:10 +0100
Subject: Re: [U2] UniBasic Question
Is this unibasic doing an execute and the 'report' done using a List command
?
-Original Message-
From: u2-users-boun
.
Perry
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kebbon Irwin
Sent: Monday, October 24, 2011 9:29 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UniBasic Question
The subroutine does an execute 'Select
Kebbon:
I've converted our application from D3 to UniData. There were a number
of issues with the Heading statement and, if I remember correctly,
wouldn't allow me to do what you're trying. Fortunately, we already had
a scrolling program to pass output into so this didn't cause problems.
for the help. I appreciate it.
Regards,
--Bill
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Keith Johnson
[DATACOM]
Sent: Sunday, July 31, 2011 5:02 PM
To: 'u2-users@listserver.u2ug.org'
Subject: Re: [U2
-users@listserver.u2ug.org'
Subject: Re: [U2] UniBasic SELECT
The problem may be in the use of program variables in the executed code.
Using Universe, if I have code:
VERB = 'SELECT VOC LIKE A...'
EXECUTE VERB
CRT @SELECTED
CLEARSELECT
I get the result
237 record(s) selected to SELECT list
The problem may be in the use of program variables in the executed code.
Using Universe, if I have code:
VERB = 'SELECT VOC LIKE A...'
EXECUTE VERB
CRT @SELECTED
CLEARSELECT
I get the result
237 record(s) selected to SELECT list #0.
237
If I change the filename to something that doesn't exit,
#1 - Why would you want to change a Basic SELECT to EXECUTE a SELECT?
#2 - If you still want to do this, change this:
Execute SELECT F.ICC to LIST.2
To this:
Execute SELECT F.ICC to :LIST.2
Larry Hiscock
Western Computer Services
-Original Message-
From:
On 29/07/11 23:14, Bill Brutzman wrote:
In an inherited legacy app, I have a few commands like
LIST.1 = 1
LIST.2 = 2
LIST.3 = 3
LIST.4 = 4
SELECT F.ICC to LIST.2
SELECT F.ICC to LIST.3
SELECT F.ICC to LIST.4
And then LIST.2
, July 29, 2011 6:37 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UniBasic SELECT
On 29/07/11 23:14, Bill Brutzman wrote:
In an inherited legacy app, I have a few commands like
LIST.1 = 1
LIST.2 = 2
LIST.3 = 3
LIST.4 = 4
SELECT F.ICC to LIST.2
LIST.2 is a variable inside your databasic code. EXECUTE runs some TCL code
and is not privy to your databsic variables.
I presume you want to concatenate LIST.2 to the end of the execute command
and not include it in the string
-Original Message-
From:
On 29/07/11 23:53, Bill Brutzman wrote:
Thanks to Larry and Wol for writing.
Both ways work to get rid of the red warnings but both ways I still get the
pesky SQL+ prompt at the end.
That sounds weird. I was wondering why the EXECUTE made the SQL+ prompt
appear, but there's no way a BASIC
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: Friday, July 29, 2011 3:53 PM
To: U2 Users List
Subject: Re: [U2] UniBasic SELECT
Thanks to Larry and Wol for writing.
Both ways work to get rid of the red warnings but both ways I still get the
pesky SQL+ prompt at the end
.
Ed
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya
Walgude
Sent: 16 October 2009 05:20
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
Many Thanks George
Now
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown
Sent: 16 October 2009 08:06
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
Dattatraya - in unibasic almost any string handling task is possible!
Hmm - funny how the original topic
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya
Walgude
Sent: 16 October 2009 05:20
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
Many Thanks George
Now output is giving following way
Jones, Bob,123 E. 23rd St.,Arvada,CO
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
Yes, and I've just spotted the first mistake - the last line should have been a
couple of lines higher...
* Count how many multivalues are in each attribute
MV.COUNT =
NUM.ATTRS = DCOUNT(REC,@AM)
FOR A = 1 TO NUM.ATTRS
: Friday, October 16, 2009 3:29 PM
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
Dattatraya,
(Possible) correction added.
You really need to take the time to understand the example code we're giving
you. There will still be problems in the code below
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: Friday, October 16, 2009 3:29 PM
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data
Of Dattatraya Walgude
Sent: 16 October 2009 12:17
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
Now Date is converted, but multivalue ( C , R ) still missing.
,Jones, Bob,123 E. 23rdst.,Arvada,CO,80276,3037768854,V4341,04/24/94,D,7,R,6
,Jones, Bob,123 E
, Pune,
( : +91-20-22909212
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown
Sent: Friday, October 16, 2009 4:49 PM
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from
Brown
Sent: Friday, October 16, 2009 4:49 PM
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
Try changing
IF MV.COUNT1,A EQ 1 THEN OUT.LINE1,B = RECB ELSE OUT.LINE1,B =
RECB,A
To
IF MV.COUNT1,B EQ 1 THEN OUT.LINE1,B = RECB ELSE OUT.LINE1,B =
RECB
DBA Team
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug
Sent: Tuesday, October 13, 2009 1:12 AM
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
This data
: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya
Walgude
Sent: 15 October 2009 06:59
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
Sorry Symeon and all for asking such silly question.
I manage
.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Porter
Sent: 14 October 2009 23:05
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample Program
Agile and Scrum (basically agile 30 days sprint cycles) doesn't mean
All,
Clif Oliver has said that he'd love a good article on Agile and how
it applies to MV for an upcoming Spectrum issue. I think the title he
had floated past us was MV: Agile for 30 Years
- Chuck
___
U2-Users mailing list
Walgude
DBA Team
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug
Sent: Tuesday, October 13, 2009 1:12 AM
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
This data
@listserver.u2ug.org
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
Dattatraya,
Are you interested in getting training in UniData and SBClient? If so
there are people (not me) on this list who have online training courses.
If you are interested please let us know and I'm sure
Of Dattatraya Walgude
Sent: Thursday, October 15, 2009 1:59 AM
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
Sorry Symeon and all for asking such silly question.
I manage @ID column in output.csv in following way, now I want
multivalue columns in new lines
Hi. I am getting in on this discussion late. Although the programming on
the fly approach is unavoidable to some degree, I am a firm believer in
defining specs as much as possible up front.
Yogi Berra says:
Be careful if you don't know where you're going. You might not know it
when you get
...@fwdco.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Wednesday, October 14, 2009 5:34:31 PM GMT -05:00 US/Canada Eastern
Subject: Re: [U2] Unibasic: Sample Program
Brenda, I did check it out, and it is interesting, but I still wonder if 3
years later, when the business requirements
Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Thursday, October 15, 2009 6:54 PM
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
Try first starting with:
LINE
Dattatraya,
oconv(9611,'d2/')
will get you your date.
Dattatraya Walgude wrote:
But I want following way ( D,C,R are multivalue ) , date output also
showing 9611 which is (04/24/94) is it possible?
___
U2-Users mailing list
: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug
Sent: 13 October 2009 22:54
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
If you are going to go that far with the minutia then why not just type
Alleluia! Brother!
Jerry Banker
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Wednesday, October 14, 2009 5:00 AM
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract
Should those thousand low quality coders quit their jobs and line up
at the local soup kitchen?
If it is true that the world needs more computer programs... it follows
that the world needs more programmers,
not less.
-Original Message-
From: Symeon Breen
Sent: Wednesday, October 14,
- Original Message -
From: jpb-u2ug jpb-u...@hotmail.com
To: 'U2 Users List' u2-users@listserver.u2ug.org
Sent: 10/14/2009 8:18 AM
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
Alleluia! Brother!
Jerry Banker
-Original Message-
From: u2-users-boun
, John R. johnisr...@daytonsuperior.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: 10/14/2009 12:14 PM
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
You cannot buy knowledge of a business. Experience with a technology:
yes. Knowledge of how a specific company
] On Behalf Of Susan Lynch
Sent: Wednesday, October 14, 2009 12:35 PM
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
John, I agree that listening to the super users is critical. However,
writing a detailed spec will give those super users the ability
In message 02fb01ca4c38$ab3ad6c0$01b084...@com, Symeon Breen
syme...@gmail.com writes
Actually for many it is mass produced. Specification is being done to the
absolute minutia, for example in the Unified Rational process, when
generating use cases these get transmitted down to the architectural
I'm with Susan on this. My job as a consultant is to help
clients define what they want so that anyone can code it. My job
as a programmer is to implement the spec that was defined. These
are two separate skills. Without specs the programmer codes what
he/she thinks is required, leaving the
shouldn't be in the position to start with.
Jerry Banker
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Susan Lynch
Sent: Wednesday, October 14, 2009 11:35 AM
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample
John's world is similar to my world here. When I realized that I would
be the only person reading the specs, I stopped writing to myself. At
the risk of no longer being a professional dinosaur, I learned that some
people call it agile.
Check out... Eckhart Tolle's book The Power of Now.
--B
, October 14, 2009 3:21 PM
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample Program
John's world is similar to my world here. When I realized that I
would
be the only person reading the specs, I stopped writing to myself. At
the risk of no longer being a professional dinosaur, I learned
Lynch
- Original Message -
From: Brutzman, Bill bi...@hkmetalcraft.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: 10/14/2009 3:20 PM
Subject: Re: [U2] Unibasic: Sample Program
John's world is similar to my world here. When I realized that I would
be the only person reading
: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Susan Lynch
Sent: Wednesday, October 14, 2009 3:26 PM
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample Program
Ah, it must be lovely to know that you will live forever and will
never
become
On the other hand some of us end up spending senseless days
re-engineering a product every time management changes it's mind what
the product should do. It's a good thing I get paid for doing what the
boss says rather than getting paid by completed projects.
My boss actually brags about our
2009 8:31 a.m.
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample Program
Well, when our company gets this fully implemented. You can count
over
250 Highlander's Immortals on the list!
Seriously, check out agile and scrum, it is interesting.
Brenda L Price
UniVerse Programmer
Rapid
became a devout convert to multi-value systems...)
Susan Lynch
- Original Message -
From: Jeff Powell j...@powellclan.com
To: u2-users@listserver.u2ug.org
Sent: 10/14/2009 4:00 PM
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
On the other hand some of us end
...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of phil walker
Sent: 14 October 2009 20:56
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample Program
I agree, agile and scrum are the way to go
However, this is not just a term for no specifications and an open ended
project
Two keys to making agile safe are [1] OSGI config management and [2]
software test. Of course, customers want everything done yesterday.
--Bill
-Original Message-
From: Symeon Breen
Sent: Wednesday, October 14, 2009 4:27 PM
My experience in this is as a software vendor - it can be
'
Subject: Re: [U2] Unibasic: Sample Program
My experience in this is as a software vendor - it can be very
dangerous to
engage with a customer in an agile development - As a vendor we supply
our
packaged product with a certain amount of modification. It is very
important
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Susan Lynch
Sent: Wednesday, October 14, 2009 3:26 PM
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample Program
Ah, it must be lovely to know that you will live forever
forward to hearing back from you in a few years on how well this
works in the real world!
Susan Lynch
- Original Message -
From: Brenda Price bren...@marketamerica.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: 10/14/2009 3:28 PM
Subject: Re: [U2] Unibasic: Sample Program
Well
List u2-users@listserver.u2ug.org
Sent: 10/14/2009 6:04 PM
Subject: Re: [U2] Unibasic: Sample Program
Agile and Scrum (basically agile 30 days sprint cycles) doesn't mean the
system does not get documented. It just means a more iterative process
with decisions being made later in the cycle
Subject: Re: [U2] Unibasic: Sample Program
I agree, agile and scrum are the way to go
However, this is not just a term for no specifications and an open
ended
project.
This methodology requires a commitment of time and effort by all
parties, most importantly a dedicated person from
I could not put it more eloquently Ross.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Ross Ferris
Sent: Thursday, 15 October 2009 1:00 p.m.
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample Program
I
, October 12, 2009 1:47 PM
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
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
development.
Perhaps
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock
Sent: 12 October 2009 22:09
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
Indian
first of
having him trained on it.
Jerry Banker
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Rubeor
Sent: Tuesday, October 13, 2009 8:26 AM
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program
, October 13, 2009 9:43 AM
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
Indian development firms are pretty much the same as any other - if you get
a small highly focused team of experts they will achieve a lot. The problem
is when you get large pools
: [U2] Unibasic: Sample program -
I don't think anyone was questioning
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
with a couple goto's spinkled in for good measure?? ;)
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill
Sent: Tuesday, October 13, 2009 1:45 PM
To: U2 Users List
Subject: Re: [U2] Unibasic
October 2009 18:00
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
I don't see where you are coming from here. Every program I ever produce is
for a specific purpose. We don't create one program and then have an
assembly line that types it in several times
With a number of the modern languages, there is a lot of code that is mind
numbing boring and tedious. What is a couple of lines in unibasic is hundreds
of lines in .Net, Java, etc. What is being outsourced is all the tedious
unclever stuff such as defining variables and validations and other
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
Actually for many it is mass produced. Specification is being done to the
absolute minutia, for example in the Unified Rational process, when
generating use cases these get transmitted down
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
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
...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Monday, October 12, 2009 4:28 PM
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
The big question is extract to what ? csv ? xml ? another data table ?
Here is a very quick simple extract to a csv
Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
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
: Re: [U2] Unibasic: Sample program - to extract data from Table
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: Monday, October 12, 2009 5:02 PM
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
Many Many Thanks Edward and Symeon
Its work...
Thanks Regards,
Dattatraya Walgude
-Original Message-
From: u2-users-boun
: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya
Walgude
Sent: 12 October 2009 12:58
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
Output is not readable:-
14334ýITOý0ýAýý16811,14334ýCHAý CHA
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Monday, October 12, 2009 6:13 PM
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
The code is just an example to get
: 12 October 2009 14:24
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
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
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
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.
___
U2
...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya
Walgude
Sent: Monday, October 12, 2009 7:24 AM
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
Thanks for your support.
We get output of multivalve columns.
Only
1 - 100 of 176 matches
Mail list logo