ward 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.COUNT<1,A> EQ 1 THEN OUT.LINE<1,B> = REC ELSE OUT.LINE<1,B> =
REC
To
IF MV.COUNT<1,B> EQ 1 THEN OUT.LINE&
u2-users-boun...@listserver.u2ug.org] On Behalf 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,30377
sers-boun...@listserver.u2ug.org] On Behalf 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,303776885
es, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D,7,R,6
Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D,7,R,6
Thanks & Regards,
Dattatraya Walgude
-----Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org
Sent: 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 c
d St.,Arvada,CO,80276,3037768854,V4341,9611,D,7,R,6
Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D,7,R,6
Thanks & Regards,
Dattatraya Walgude
-Original Message-----
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
essage-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown
Sent: Friday, October 16, 2009 12:39 PM
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
Yes, and I've just spotted the first
[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
WRITESEQ OUT.LINE ...
NEXT A
*
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[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 un
Hope this helps - I've not compiled it so it might need a bit of
tweaking to get it working.
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
Sub
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@listser
inal 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:
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
un...@listserver.u2ug.org] On Behalf 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 out
@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
: ',':ID
Thanks& Regards,
Dattatraya 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] Uni
-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 @ID column in
D
Thanks & Regards,
Dattatraya 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: Sam
nd he
became a devout convert to multi-value systems...)
Susan Lynch
- Original Message -
From: "Jeff Powell"
To:
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 up spending senseless days re
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
-)
Susan Lynch
- Original Message -
From: "Israel, John R."
To: "U2 Users List"
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:
> ye
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 cli
In message <02fb01ca4c38$ab3ad6c0$01b084...@com>, Symeon Breen
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
specifications
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 to
-
From: "Israel, John R."
To: "U2 Users List"
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 works: no
-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 12:00 PM
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
As a programmer who has
usan Lynch
- Original Message -
From: "jpb-u2ug"
To: "'U2 Users List'"
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...@l
al Message-
From: 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
: 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 ju
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 d
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
g
Sent: 13 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
t: Tuesday, 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 yo
.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bney...@hcmg.net
Sent: Monday, 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
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 Tab
stserver.u2ug.org] On Behalf Of bney...@hcmg.net
Sent: Monday, 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
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bney...@hcmg.net
Sent: Monday, October 12, 2009 1:47 PM
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
Doesn't matter
e respond to
U2 Users List
To
"'U2 Users List'"
cc
Subject
Re: [U2] Unibasic: Sample program - to extract data from Table
> And you are from outsource product develop company in India that has
been
> tasked to work on this U2 system.
http://www.rsystems.com/
> 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 ma
...@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
ber 12, 2009 6: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 things is we can not get out of DATE column is date format.
So please g
ya Walgude
Sent: 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.
Jones
-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 exam
riginal 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:58
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table
Output is not readable:-
"1433
ýý9757","13942ýSUSýFailed ValidationýýýWITH SIXTYD.ABOVE.AMT.OVRD GE
10.00 ý
Thanks & Regards,
Dattatraya Walgude
-----Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya Walgude
Sent: Monday,
ject: 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
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
une,
( : +91-20-22909212
-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 4:28 PM
To: 'U2 Users List'
Subject: Re: [U2] Unibasic: Sample program - to extract data from Tab
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
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 S
50 matches
Mail list logo
