Re: [U2] Unibasic: Sample program - to extract data from Table

[Dattatraya Walgude]

Thousand thanks to you ED,

Now output is:-

Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,04/24/94,D,7,6
Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,04/24/94,C,7,6
Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,04/24/94,R,7,6
Frobisher, Kamal,P.O. Box 9845,Denver,CO,80209-,3037780880,,,K,33,204
Frobisher, Kamal,,Denver,CO,80209-,3037780880,,,O,33,204
Steven Spender,1212 W. 44th,Denver,CO,80401,30344578783,90
Jamieson, Dale,999 Independence Way,Seattle,WI,98733,,V6670,04/24/94,,8,12
Chase, Carl,12 W. Main,Kenosha,WI,53142,414666,V8481,04/20/94,,11,9
Chase, Carl,Suite 1414,Kenosha,WI,53142,414666,V1254,04/20/94,,11,9
Chase, Carl,,Kenosha,WI,53142,414666,V4951,04/21/94,,11,9
Wagner, Pat,403 S. Pennsylvania,Denver,CO,80209,3037222680,,,R,4,201
Wagner, Pat,First Floor,Denver,CO,80209,3037222680,,,S,4,201
Wagner, Pat,Deliveries to rear door,Denver,CO,80209,3037222680,,,H,4,201
Wagner, Esther,1455 30th Avenue,Kenosha,WI,53140,4145527433,,,M,5,210
Wagner, Esther,Woodcreek Condos,Kenosha,WI,53140,4145527433,,,T,5,210
Wagner, Esther,,Kenosha,WI,53140,4145527433,,,P,5,210
Wagner, Esther,,Kenosha,WI,53140,4145527433,,,K,5,210
Wagner, Esther,,Kenosha,WI,53140,4145527433,,,B,5,210

Thanks & Regards,
Dattatraya Walgude
DBA Team 
Rsystems International Ltd, 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 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<1,B> = REC ELSE OUT.LINE<1,B> = 
REC

-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 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. 23rdSt.,Arvada,CO,80276,3037768854,V4341,04/24/94,D,7,R,6
,Jones, Bob,123 E. 23rdSt.,Arvada,CO,80276,3037768854,V4341,04/24/94,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 Edward Brown
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 code below - for example, I can't see 
why the date conversion is failing or why (despite the uninit var) the C and R 
are missing.

Really at this point you are in the best position to debug the program as you 
have the source data, which I'm having to guess the format of.

Debugging - there's a proper debugger built into unidata but for quick and 
dirty checking, use

CRT variable

to display the contents of a variable to screen, and

INPUT X,1

to have the program wait until you press a key - useful if you're displaying a 
lot of values and want to add a pause - for example after each record has been 
processed.

Ed



OPEN 'CUSTOMER' TO FIL ELSE STOP 201 'CUSTOMER'
OPENSEQ 'OUTPUT.CSV' TO CSVFIL ELSE NULL
WEOFSEQ CSVFIL
SELECT FIL
LOOP WHILE READNEXT ID DO
 READ REC FROM FIL,ID THEN
* Count how many multivalues are in each attribute MV.COUNT = ""
NUM.ATTRS = DCOUNT(REC,@AM)
MV.COUNT = ""
FOR A = 1 TO NUM.ATTRS
  MV.COUNT<1,A> = DCOUNT(REC,@VM)
NEXT A
* And find the highest number
MAX.MVS = MAXIMUM(MV.COUNT)
* Convert specific attributes to date format.
* Note the OCONVS handles multivalued data - it converts each value separately.
REC<9> = OCONVS(REC<9>,"D2/")
* Now output a line for each multivalue
FOR A = 1 TO MAX.MVS
  OUT.LINE = ""
  FOR B = 1 TO NUM.ATTRS
IF MV.COUNT<1,A> EQ 1 THEN OUT.LINE<1,B> = REC ELSE OUT.LINE<1,B> = 
REC
  NEXT B
* Turn multivalues in the output line to commas
  *OUT.LINE = CHANGE(OUT.LINE,@VM,",")
OUT.LINE = '' : CHANGE(CHANGE(OUT.LINE,@AM,','),@VM,',') : ',':ID
* And write the line to the output file
 WRITESEQ OUT.LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE'
 * WRITESEQ OUT.LINE ...
NEXT A
END
REPEAT
==End code


:BASIC BP outfile

Compiling Unibasic: BP/outfile in mode 'u'.
compilation finished
:RUN BP outfile
In BP/_outfile at line 10 WARNING: UNINITIALIZED VARIABLE USED! Zero ssumed!
:

And output is :- ( Missing C,R in multi

Re: [U2] Unibasic: Sample program - to extract data from Table

[Dattatraya Walgude]

Thanks Ed,

It comes correct (only two records), missing another rows:- 

Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,04/24/94,D,7,6
Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,04/24/94,C,7,6

Thanks & Regards,
Dattatraya Walgude
DBA Team 
Rsystems International Ltd, 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 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<1,B> = REC ELSE OUT.LINE<1,B> = 
REC

-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 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. 23rdSt.,Arvada,CO,80276,3037768854,V4341,04/24/94,D,7,R,6
,Jones, Bob,123 E. 23rdSt.,Arvada,CO,80276,3037768854,V4341,04/24/94,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 Edward Brown
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 code below - for example, I can't see 
why the date conversion is failing or why (despite the uninit var) the C and R 
are missing.

Really at this point you are in the best position to debug the program as you 
have the source data, which I'm having to guess the format of.

Debugging - there's a proper debugger built into unidata but for quick and 
dirty checking, use

CRT variable

to display the contents of a variable to screen, and

INPUT X,1

to have the program wait until you press a key - useful if you're displaying a 
lot of values and want to add a pause - for example after each record has been 
processed.

Ed



OPEN 'CUSTOMER' TO FIL ELSE STOP 201 'CUSTOMER'
OPENSEQ 'OUTPUT.CSV' TO CSVFIL ELSE NULL
WEOFSEQ CSVFIL
SELECT FIL
LOOP WHILE READNEXT ID DO
 READ REC FROM FIL,ID THEN
* Count how many multivalues are in each attribute MV.COUNT = ""
NUM.ATTRS = DCOUNT(REC,@AM)
MV.COUNT = ""
FOR A = 1 TO NUM.ATTRS
  MV.COUNT<1,A> = DCOUNT(REC,@VM)
NEXT A
* And find the highest number
MAX.MVS = MAXIMUM(MV.COUNT)
* Convert specific attributes to date format.
* Note the OCONVS handles multivalued data - it converts each value separately.
REC<9> = OCONVS(REC<9>,"D2/")
* Now output a line for each multivalue
FOR A = 1 TO MAX.MVS
  OUT.LINE = ""
  FOR B = 1 TO NUM.ATTRS
IF MV.COUNT<1,A> EQ 1 THEN OUT.LINE<1,B> = REC ELSE OUT.LINE<1,B> = 
REC
  NEXT B
* Turn multivalues in the output line to commas
  *OUT.LINE = CHANGE(OUT.LINE,@VM,",")
OUT.LINE = '' : CHANGE(CHANGE(OUT.LINE,@AM,','),@VM,',') : ',':ID
* And write the line to the output file
 WRITESEQ OUT.LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE'
 * WRITESEQ OUT.LINE ...
NEXT A
END
REPEAT
==End code


:BASIC BP outfile

Compiling Unibasic: BP/outfile in mode 'u'.
compilation finished
:RUN BP outfile
In BP/_outfile at line 10 WARNING: UNINITIALIZED VARIABLE USED! Zero ssumed!
:

And output is :- ( Missing C,R in multivalve, date also not converted)

Jones, 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
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 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 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
  MV.COUNT<1,A> = DCOUNT(REC,@VM)
NEXT A
* And find the highest number
MAX.MVS = MAXIMUM(MV.COUNT)
* Convert specific attributes to date format.
* Note the OCONVS handles multivalued data - it converts each val

Re: [U2] Unibasic: Sample program - to extract data from Table

[Edward Brown]

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<1,B> = REC ELSE OUT.LINE<1,B> = 
REC

-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 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. 23rdSt.,Arvada,CO,80276,3037768854,V4341,04/24/94,D,7,R,6
,Jones, Bob,123 E. 23rdSt.,Arvada,CO,80276,3037768854,V4341,04/24/94,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 Edward Brown
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 code below - for example, I can't see 
why the date conversion is failing or why (despite the uninit var) the C and R 
are missing.

Really at this point you are in the best position to debug the program as you 
have the source data, which I'm having to guess the format of.

Debugging - there's a proper debugger built into unidata but for quick and 
dirty checking, use

CRT variable

to display the contents of a variable to screen, and

INPUT X,1

to have the program wait until you press a key - useful if you're displaying a 
lot of values and want to add a pause - for example after each record has been 
processed.

Ed



OPEN 'CUSTOMER' TO FIL ELSE STOP 201 'CUSTOMER'
OPENSEQ 'OUTPUT.CSV' TO CSVFIL ELSE NULL
WEOFSEQ CSVFIL
SELECT FIL
LOOP WHILE READNEXT ID DO
 READ REC FROM FIL,ID THEN
* Count how many multivalues are in each attribute MV.COUNT = ""
NUM.ATTRS = DCOUNT(REC,@AM)
MV.COUNT = ""
FOR A = 1 TO NUM.ATTRS
  MV.COUNT<1,A> = DCOUNT(REC,@VM)
NEXT A
* And find the highest number
MAX.MVS = MAXIMUM(MV.COUNT)
* Convert specific attributes to date format.
* Note the OCONVS handles multivalued data - it converts each value separately.
REC<9> = OCONVS(REC<9>,"D2/")
* Now output a line for each multivalue
FOR A = 1 TO MAX.MVS
  OUT.LINE = ""
  FOR B = 1 TO NUM.ATTRS
IF MV.COUNT<1,A> EQ 1 THEN OUT.LINE<1,B> = REC ELSE OUT.LINE<1,B> = 
REC
  NEXT B
* Turn multivalues in the output line to commas
  *OUT.LINE = CHANGE(OUT.LINE,@VM,",")
OUT.LINE = '' : CHANGE(CHANGE(OUT.LINE,@AM,','),@VM,',') : ',':ID
* And write the line to the output file
 WRITESEQ OUT.LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE'
 * WRITESEQ OUT.LINE ...
NEXT A
END
REPEAT
==End code


:BASIC BP outfile

Compiling Unibasic: BP/outfile in mode 'u'.
compilation finished
:RUN BP outfile
In BP/_outfile at line 10 WARNING: UNINITIALIZED VARIABLE USED! Zero ssumed!
:

And output is :- ( Missing C,R in multivalve, date also not converted)

Jones, 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
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 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 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
  MV.COUNT<1,A> = DCOUNT(REC,@VM)
NEXT A
* And find the highest number
MAX.MVS = MAXIMUM(MV.COUNT)
* Convert specific attributes to date format.
* Note the OCONVS handles multivalued data - it converts each value
separately.
REC<9> = OCONVS(REC<9>,"D2/")
* Now output a line for each multivalue
FOR A = 1 TO MAX.MVS
  OUT.LINE = ""
  FOR B = 1 TO NUM.ATTRS
IF MV.COUNT<1,A> EQ 1 THEN OUT.LINE<1,B> = REC ELSE OUT.LINE<1,B>
= REC  
  NEXT B
* Turn multivalues in the output line to commas
  OUT.LINE = CHANGE(OUT.LINE,@VM,",")
* And write the line to the output file
  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:

Re: [U2] Unibasic: Sample program - to extract data from Table

[Dattatraya Walgude]

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. 23rdSt.,Arvada,CO,80276,3037768854,V4341,04/24/94,D,7,R,6
,Jones, Bob,123 E. 23rdSt.,Arvada,CO,80276,3037768854,V4341,04/24/94,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 Edward Brown
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 code below - for example, I can't see 
why the date conversion is failing or why (despite the uninit var) the C and R 
are missing.

Really at this point you are in the best position to debug the program as you 
have the source data, which I'm having to guess the format of.

Debugging - there's a proper debugger built into unidata but for quick and 
dirty checking, use

CRT variable

to display the contents of a variable to screen, and

INPUT X,1

to have the program wait until you press a key - useful if you're displaying a 
lot of values and want to add a pause - for example after each record has been 
processed.

Ed



OPEN 'CUSTOMER' TO FIL ELSE STOP 201 'CUSTOMER'
OPENSEQ 'OUTPUT.CSV' TO CSVFIL ELSE NULL
WEOFSEQ CSVFIL
SELECT FIL
LOOP WHILE READNEXT ID DO
 READ REC FROM FIL,ID THEN
* Count how many multivalues are in each attribute MV.COUNT = ""
NUM.ATTRS = DCOUNT(REC,@AM)
MV.COUNT = ""
FOR A = 1 TO NUM.ATTRS
  MV.COUNT<1,A> = DCOUNT(REC,@VM)
NEXT A
* And find the highest number
MAX.MVS = MAXIMUM(MV.COUNT)
* Convert specific attributes to date format.
* Note the OCONVS handles multivalued data - it converts each value separately.
REC<9> = OCONVS(REC<9>,"D2/")
* Now output a line for each multivalue
FOR A = 1 TO MAX.MVS
  OUT.LINE = ""
  FOR B = 1 TO NUM.ATTRS
IF MV.COUNT<1,A> EQ 1 THEN OUT.LINE<1,B> = REC ELSE OUT.LINE<1,B> = 
REC
  NEXT B
* Turn multivalues in the output line to commas
  *OUT.LINE = CHANGE(OUT.LINE,@VM,",")
OUT.LINE = '' : CHANGE(CHANGE(OUT.LINE,@AM,','),@VM,',') : ',':ID
* And write the line to the output file
 WRITESEQ OUT.LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE'
 * WRITESEQ OUT.LINE ...
NEXT A
END
REPEAT
==End code


:BASIC BP outfile

Compiling Unibasic: BP/outfile in mode 'u'.
compilation finished
:RUN BP outfile
In BP/_outfile at line 10 WARNING: UNINITIALIZED VARIABLE USED! Zero ssumed!
:

And output is :- ( Missing C,R in multivalve, date also not converted)

Jones, 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
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 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 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
  MV.COUNT<1,A> = DCOUNT(REC,@VM)
NEXT A
* And find the highest number
MAX.MVS = MAXIMUM(MV.COUNT)
* Convert specific attributes to date format.
* Note the OCONVS handles multivalued data - it converts each value
separately.
REC<9> = OCONVS(REC<9>,"D2/")
* Now output a line for each multivalue
FOR A = 1 TO MAX.MVS
  OUT.LINE = ""
  FOR B = 1 TO NUM.ATTRS
IF MV.COUNT<1,A> EQ 1 THEN OUT.LINE<1,B> = REC ELSE OUT.LINE<1,B>
= REC  
  NEXT B
* Turn multivalues in the output line to commas
  OUT.LINE = CHANGE(OUT.LINE,@VM,",")
* And write the line to the output file
  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 unibasic almost any string handling task is possible!

Hmm - funny how the original topic of this thread and the subsequent
discussion of specifications, or lack of, seems to have come full
circle.


Starting with REC - as read from disk.

Presume REC has one or more multivalued fields. REC is to be written to
the output file multiple times, sub

Re: [U2] Unibasic: Sample program - to extract data from Table

[Dattatraya Walgude]

Thanks Ed,

Will debug code, as you asked.

Thanks & Regards,
Dattatraya Walgude
DBA Team 
Rsystems International Ltd, 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 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 - for example, I can't see 
why the date conversion is failing or why (despite the uninit var) the C and R 
are missing.

Really at this point you are in the best position to debug the program as you 
have the source data, which I'm having to guess the format of.

Debugging - there's a proper debugger built into unidata but for quick and 
dirty checking, use

CRT variable

to display the contents of a variable to screen, and

INPUT X,1

to have the program wait until you press a key - useful if you're displaying a 
lot of values and want to add a pause - for example after each record has been 
processed.

Ed



OPEN 'CUSTOMER' TO FIL ELSE STOP 201 'CUSTOMER'
OPENSEQ 'OUTPUT.CSV' TO CSVFIL ELSE NULL
WEOFSEQ CSVFIL
SELECT FIL
LOOP WHILE READNEXT ID DO
 READ REC FROM FIL,ID THEN
* Count how many multivalues are in each attribute MV.COUNT = ""
NUM.ATTRS = DCOUNT(REC,@AM)
MV.COUNT = ""
FOR A = 1 TO NUM.ATTRS
  MV.COUNT<1,A> = DCOUNT(REC,@VM)
NEXT A
* And find the highest number
MAX.MVS = MAXIMUM(MV.COUNT)
* Convert specific attributes to date format.
* Note the OCONVS handles multivalued data - it converts each value separately.
REC<9> = OCONVS(REC<9>,"D2/")
* Now output a line for each multivalue
FOR A = 1 TO MAX.MVS
  OUT.LINE = ""
  FOR B = 1 TO NUM.ATTRS
IF MV.COUNT<1,A> EQ 1 THEN OUT.LINE<1,B> = REC ELSE OUT.LINE<1,B> = 
REC
  NEXT B
* Turn multivalues in the output line to commas
  *OUT.LINE = CHANGE(OUT.LINE,@VM,",")
OUT.LINE = '' : CHANGE(CHANGE(OUT.LINE,@AM,','),@VM,',') : ',':ID
* And write the line to the output file
 WRITESEQ OUT.LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE'
 * WRITESEQ OUT.LINE ...
NEXT A
END
REPEAT
==End code


:BASIC BP outfile

Compiling Unibasic: BP/outfile in mode 'u'.
compilation finished
:RUN BP outfile
In BP/_outfile at line 10 WARNING: UNINITIALIZED VARIABLE USED! Zero ssumed!
:

And output is :- ( Missing C,R in multivalve, date also not converted)

Jones, 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
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 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 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
  MV.COUNT<1,A> = DCOUNT(REC,@VM)
NEXT A
* And find the highest number
MAX.MVS = MAXIMUM(MV.COUNT)
* Convert specific attributes to date format.
* Note the OCONVS handles multivalued data - it converts each value
separately.
REC<9> = OCONVS(REC<9>,"D2/")
* Now output a line for each multivalue
FOR A = 1 TO MAX.MVS
  OUT.LINE = ""
  FOR B = 1 TO NUM.ATTRS
IF MV.COUNT<1,A> EQ 1 THEN OUT.LINE<1,B> = REC ELSE OUT.LINE<1,B>
= REC  
  NEXT B
* Turn multivalues in the output line to commas
  OUT.LINE = CHANGE(OUT.LINE,@VM,",")
* And write the line to the output file
  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 unibasic almost any string handling task is possible!

Hmm - funny how the original topic of this thread and the subsequent
discussion of specifications, or lack of, seems to have come full
circle.


Starting with REC - as read from disk.

Presume REC has one or more multivalued fields. REC is to be written to
the output file multiple times, subsequent lines taking the 1st, 2nd etc
multivalue where the attribute is multivalued and taking the entire
attribute otherwise.

* Count how many multivalues are in each attribute
MV.CO

Re: [U2] Unibasic: Sample program - to extract data from Table

[Edward Brown]

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 - for example, I can't see 
why the date conversion is failing or why (despite the uninit var) the C and R 
are missing.

Really at this point you are in the best position to debug the program as you 
have the source data, which I'm having to guess the format of.

Debugging - there's a proper debugger built into unidata but for quick and 
dirty checking, use

CRT variable

to display the contents of a variable to screen, and

INPUT X,1

to have the program wait until you press a key - useful if you're displaying a 
lot of values and want to add a pause - for example after each record has been 
processed.

Ed



OPEN 'CUSTOMER' TO FIL ELSE STOP 201 'CUSTOMER'
OPENSEQ 'OUTPUT.CSV' TO CSVFIL ELSE NULL
WEOFSEQ CSVFIL
SELECT FIL
LOOP WHILE READNEXT ID DO
 READ REC FROM FIL,ID THEN
* Count how many multivalues are in each attribute MV.COUNT = ""
NUM.ATTRS = DCOUNT(REC,@AM)
MV.COUNT = ""
FOR A = 1 TO NUM.ATTRS
  MV.COUNT<1,A> = DCOUNT(REC,@VM)
NEXT A
* And find the highest number
MAX.MVS = MAXIMUM(MV.COUNT)
* Convert specific attributes to date format.
* Note the OCONVS handles multivalued data - it converts each value separately.
REC<9> = OCONVS(REC<9>,"D2/")
* Now output a line for each multivalue
FOR A = 1 TO MAX.MVS
  OUT.LINE = ""
  FOR B = 1 TO NUM.ATTRS
IF MV.COUNT<1,A> EQ 1 THEN OUT.LINE<1,B> = REC ELSE OUT.LINE<1,B> = 
REC
  NEXT B
* Turn multivalues in the output line to commas
  *OUT.LINE = CHANGE(OUT.LINE,@VM,",")
OUT.LINE = '' : CHANGE(CHANGE(OUT.LINE,@AM,','),@VM,',') : ',':ID
* And write the line to the output file
 WRITESEQ OUT.LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE'
 * WRITESEQ OUT.LINE ...
NEXT A
END
REPEAT
==End code


:BASIC BP outfile

Compiling Unibasic: BP/outfile in mode 'u'.
compilation finished
:RUN BP outfile
In BP/_outfile at line 10 WARNING: UNINITIALIZED VARIABLE USED! Zero ssumed!
:

And output is :- ( Missing C,R in multivalve, date also not converted)

Jones, 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
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 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 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
  MV.COUNT<1,A> = DCOUNT(REC,@VM)
NEXT A
* And find the highest number
MAX.MVS = MAXIMUM(MV.COUNT)
* Convert specific attributes to date format.
* Note the OCONVS handles multivalued data - it converts each value
separately.
REC<9> = OCONVS(REC<9>,"D2/")
* Now output a line for each multivalue
FOR A = 1 TO MAX.MVS
  OUT.LINE = ""
  FOR B = 1 TO NUM.ATTRS
IF MV.COUNT<1,A> EQ 1 THEN OUT.LINE<1,B> = REC ELSE OUT.LINE<1,B>
= REC  
  NEXT B
* Turn multivalues in the output line to commas
  OUT.LINE = CHANGE(OUT.LINE,@VM,",")
* And write the line to the output file
  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 unibasic almost any string handling task is possible!

Hmm - funny how the original topic of this thread and the subsequent
discussion of specifications, or lack of, seems to have come full
circle.


Starting with REC - as read from disk.

Presume REC has one or more multivalued fields. REC is to be written to
the output file multiple times, subsequent lines taking the 1st, 2nd etc
multivalue where the attribute is multivalued and taking the entire
attribute otherwise.

* Count how many multivalues are in each attribute
MV.COUNT = ""
NUM.ATTRS = DCOUNT(REC,@AM)
FOR A = 1 TO NUM.ATTRS
  MV.COUNT<1,A> = DCOUNT(REC,@VM)
NEXT A
* And find the highest number
MAX.MVS = MAXIMUM(MV.COUNT)
* Convert specific attributes to date format.
* Note the OCONVS handles multivalued data - it converts each value
separately.
REC<9> = OCONVS(REC<9>,"D2/")
* Now output a line for each multivalue
FOR A = 1 TO MAX.MVS
  OUT.LINE = "

Re: [U2] Unibasic: Sample program - to extract data from Table

[Dattatraya Walgude]

Many Thanks all of you

Now final code is:

==start code
OPEN 'CUSTOMER' TO FIL ELSE STOP 201 'CUSTOMER'
OPENSEQ 'OUTPUT.CSV' TO CSVFIL ELSE NULL
WEOFSEQ CSVFIL
SELECT FIL
LOOP WHILE READNEXT ID DO
 READ REC FROM FIL,ID THEN
* Count how many multivalues are in each attribute MV.COUNT = ""
NUM.ATTRS = DCOUNT(REC,@AM)
FOR A = 1 TO NUM.ATTRS
  MV.COUNT<1,A> = DCOUNT(REC,@VM)
NEXT A
* And find the highest number
MAX.MVS = MAXIMUM(MV.COUNT)
* Convert specific attributes to date format.
* Note the OCONVS handles multivalued data - it converts each value separately.
REC<9> = OCONVS(REC<9>,"D2/")
* Now output a line for each multivalue
FOR A = 1 TO MAX.MVS
  OUT.LINE = ""
  FOR B = 1 TO NUM.ATTRS
IF MV.COUNT<1,A> EQ 1 THEN OUT.LINE<1,B> = REC ELSE OUT.LINE<1,B> = 
REC
  NEXT B
* Turn multivalues in the output line to commas
  *OUT.LINE = CHANGE(OUT.LINE,@VM,",")
OUT.LINE = '' : CHANGE(CHANGE(OUT.LINE,@AM,','),@VM,',') : ',':ID
* And write the line to the output file
 WRITESEQ OUT.LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE'
 * WRITESEQ OUT.LINE ...
NEXT A
END
REPEAT
==End code


:BASIC BP outfile

Compiling Unibasic: BP/outfile in mode 'u'.
compilation finished
:RUN BP outfile
In BP/_outfile at line 10 WARNING: UNINITIALIZED VARIABLE USED! Zero ssumed!
:

And output is :- ( Missing C,R in multivalve, date also not converted)

Jones, 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
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 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 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
  MV.COUNT<1,A> = DCOUNT(REC,@VM)
NEXT A
* And find the highest number
MAX.MVS = MAXIMUM(MV.COUNT)
* Convert specific attributes to date format.
* Note the OCONVS handles multivalued data - it converts each value
separately.
REC<9> = OCONVS(REC<9>,"D2/")
* Now output a line for each multivalue
FOR A = 1 TO MAX.MVS
  OUT.LINE = ""
  FOR B = 1 TO NUM.ATTRS
IF MV.COUNT<1,A> EQ 1 THEN OUT.LINE<1,B> = REC ELSE OUT.LINE<1,B>
= REC  
  NEXT B
* Turn multivalues in the output line to commas
  OUT.LINE = CHANGE(OUT.LINE,@VM,",")
* And write the line to the output file
  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 unibasic almost any string handling task is possible!

Hmm - funny how the original topic of this thread and the subsequent
discussion of specifications, or lack of, seems to have come full
circle.


Starting with REC - as read from disk.

Presume REC has one or more multivalued fields. REC is to be written to
the output file multiple times, subsequent lines taking the 1st, 2nd etc
multivalue where the attribute is multivalued and taking the entire
attribute otherwise.

* Count how many multivalues are in each attribute
MV.COUNT = ""
NUM.ATTRS = DCOUNT(REC,@AM)
FOR A = 1 TO NUM.ATTRS
  MV.COUNT<1,A> = DCOUNT(REC,@VM)
NEXT A
* And find the highest number
MAX.MVS = MAXIMUM(MV.COUNT)
* Convert specific attributes to date format.
* Note the OCONVS handles multivalued data - it converts each value
separately.
REC<9> = OCONVS(REC<9>,"D2/")
* Now output a line for each multivalue
FOR A = 1 TO MAX.MVS
  OUT.LINE = ""
  FOR B = 1 TO NUM.ATTRS
IF MV.COUNT<1,A> EQ 1 THEN OUT.LINE<1,B> = REC ELSE OUT.LINE<1,B>
= REC  
  NEXT B
  WRITESEQ OUT.LINE ...
NEXT A
OUT.LINE = CHANGE(OUT.LINE,@VM,",")
*

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
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,80276,3037768854,V4341,9611,D
C
R,7,6
Frobisher, Kamal,P.O. Box 9845
,Denver,CO,80

Re: [U2] Unibasic: Sample program - to extract data from Table

[Symeon Breen]

Dattatraya  if you are a programmer you should be able to do this - i would
use the same technique in .net, java or databasic. The only difference is
the way you get the information out of the arrays in the first place.



-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 output is giving following way 

Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D
C
R,7,6
Frobisher, Kamal,P.O. Box 9845
,Denver,CO,80209-,3037780880,,,K
O,33,204


But I want following way ( D,C,R are multivalue ) , date output also
showing 9611 which is (04/24/94) is it possible?

Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D,7,6
Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,C,7,6
Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,R,7,6

Thanks & Regards,
Dattatraya Walgude


-Original 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 = '' : CHANGE(CHANGE(REC,@AM,','),@VM,CHAR(10)) : ',':ID

I think that the LF character might give you want you want

George

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@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 output.csv in following way, now I want
> multivalue columns in new lines with all columns (now its comes in one
> row/line)
>
> LINE = '' :  CHANGE(CHANGE(REC,@AM,','),@VM,',') :  ',':ID
>
>
> Thanks & Regards,
> Dattatraya Walgude
> DBA Team
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users



  Disclaimer *
 

 

This mail, including any attachments contains confidential and privileged
information for the sole use of the addressee(s). If you are not the
intended recipient, 

please notify the sender by e-mail and delete the original message.  Any
unauthorized review, use, disclosure, dissemination, forwarding, printing or
copying of

 this email or any action taken in reliance on this e-mail is strictly
prohibited and are unlawful. This e-mail may contain viruses. R Systems
International Limited  has 

taken every reasonable precaution to minimize this risk.  R Systems
International Limited is not liable for any damage you may sustain as a
result of any virus in this e-mail. 

Before opening the e-mail or attachment, You should carry out your own virus
checks. R Systems International Limited reserves the right to record,
monitor, and inspect

 all email communications through its internal and external networks.  R
Systems International Ltd prohibits its information systems from being used
to view, store or forward 

offensive or discriminatory material.

 

 End of Disclaimer 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample program - to extract data from Table

[Edward Brown]

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
  MV.COUNT<1,A> = DCOUNT(REC,@VM)
NEXT A
* And find the highest number
MAX.MVS = MAXIMUM(MV.COUNT)
* Convert specific attributes to date format.
* Note the OCONVS handles multivalued data - it converts each value
separately.
REC<9> = OCONVS(REC<9>,"D2/")
* Now output a line for each multivalue
FOR A = 1 TO MAX.MVS
  OUT.LINE = ""
  FOR B = 1 TO NUM.ATTRS
IF MV.COUNT<1,A> EQ 1 THEN OUT.LINE<1,B> = REC ELSE OUT.LINE<1,B>
= REC  
  NEXT B
* Turn multivalues in the output line to commas
  OUT.LINE = CHANGE(OUT.LINE,@VM,",")
* And write the line to the output file
  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 unibasic almost any string handling task is possible!

Hmm - funny how the original topic of this thread and the subsequent
discussion of specifications, or lack of, seems to have come full
circle.


Starting with REC - as read from disk.

Presume REC has one or more multivalued fields. REC is to be written to
the output file multiple times, subsequent lines taking the 1st, 2nd etc
multivalue where the attribute is multivalued and taking the entire
attribute otherwise.

* Count how many multivalues are in each attribute
MV.COUNT = ""
NUM.ATTRS = DCOUNT(REC,@AM)
FOR A = 1 TO NUM.ATTRS
  MV.COUNT<1,A> = DCOUNT(REC,@VM)
NEXT A
* And find the highest number
MAX.MVS = MAXIMUM(MV.COUNT)
* Convert specific attributes to date format.
* Note the OCONVS handles multivalued data - it converts each value
separately.
REC<9> = OCONVS(REC<9>,"D2/")
* Now output a line for each multivalue
FOR A = 1 TO MAX.MVS
  OUT.LINE = ""
  FOR B = 1 TO NUM.ATTRS
IF MV.COUNT<1,A> EQ 1 THEN OUT.LINE<1,B> = REC ELSE OUT.LINE<1,B>
= REC  
  NEXT B
  WRITESEQ OUT.LINE ...
NEXT A
OUT.LINE = CHANGE(OUT.LINE,@VM,",")
*

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
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,80276,3037768854,V4341,9611,D
C
R,7,6
Frobisher, Kamal,P.O. Box 9845
,Denver,CO,80209-,3037780880,,,K
O,33,204


But I want following way ( D,C,R are multivalue ) , date output also
showing 9611 which is (04/24/94) is it possible?

Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D,7,6
Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,C,7,6
Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,R,7,6

Thanks & Regards,
Dattatraya Walgude


-Original 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 = '' : CHANGE(CHANGE(REC,@AM,','),@VM,CHAR(10)) : ',':ID

I think that the LF character might give you want you want

George

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@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 output.csv in following way, now I want
> multivalue columns in new lines with all columns (now its comes in one
> row/line)
>
> LINE = '' :  CHANGE(CHANGE(REC,@AM,','),@VM,',') :  ',':ID
>
>
> Thanks & Regards,
> Dattatraya Walgude
> DBA Team
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users



  Disclaimer *
 

 

This mail, including any attachments contains confidential and
privileged information for the sole use of the addressee(s). If you are
not the intended recipient, 

please notify the sender by e-mail and delete the original message.  Any
unauthorized review, use, discl

Re: [U2] Unibasic: Sample program - to extract data from Table

[Edward Brown]

Dattatraya - in unibasic almost any string handling task is possible!

Hmm - funny how the original topic of this thread and the subsequent
discussion of specifications, or lack of, seems to have come full
circle.


Starting with REC - as read from disk.

Presume REC has one or more multivalued fields. REC is to be written to
the output file multiple times, subsequent lines taking the 1st, 2nd etc
multivalue where the attribute is multivalued and taking the entire
attribute otherwise.

* Count how many multivalues are in each attribute
MV.COUNT = ""
NUM.ATTRS = DCOUNT(REC,@AM)
FOR A = 1 TO NUM.ATTRS
  MV.COUNT<1,A> = DCOUNT(REC,@VM)
NEXT A
* And find the highest number
MAX.MVS = MAXIMUM(MV.COUNT)
* Convert specific attributes to date format.
* Note the OCONVS handles multivalued data - it converts each value
separately.
REC<9> = OCONVS(REC<9>,"D2/")
* Now output a line for each multivalue
FOR A = 1 TO MAX.MVS
  OUT.LINE = ""
  FOR B = 1 TO NUM.ATTRS
IF MV.COUNT<1,A> EQ 1 THEN OUT.LINE<1,B> = REC ELSE OUT.LINE<1,B>
= REC
  NEXT B
  WRITESEQ OUT.LINE ...
NEXT A
OUT.LINE = CHANGE(OUT.LINE,@VM,",")
*

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
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,80276,3037768854,V4341,9611,D
C
R,7,6
Frobisher, Kamal,P.O. Box 9845
,Denver,CO,80209-,3037780880,,,K
O,33,204


But I want following way ( D,C,R are multivalue ) , date output also
showing 9611 which is (04/24/94) is it possible?

Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D,7,6
Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,C,7,6
Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,R,7,6

Thanks & Regards,
Dattatraya Walgude


-Original 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 = '' : CHANGE(CHANGE(REC,@AM,','),@VM,CHAR(10)) : ',':ID

I think that the LF character might give you want you want

George

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@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 output.csv in following way, now I want
> multivalue columns in new lines with all columns (now its comes in one
> row/line)
>
> LINE = '' :  CHANGE(CHANGE(REC,@AM,','),@VM,',') :  ',':ID
>
>
> Thanks & Regards,
> Dattatraya Walgude
> DBA Team
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users



  Disclaimer *
 

 

This mail, including any attachments contains confidential and
privileged information for the sole use of the addressee(s). If you are
not the intended recipient, 

please notify the sender by e-mail and delete the original message.  Any
unauthorized review, use, disclosure, dissemination, forwarding,
printing or copying of

 this email or any action taken in reliance on this e-mail is strictly
prohibited and are unlawful. This e-mail may contain viruses. R Systems
International Limited  has 

taken every reasonable precaution to minimize this risk.  R Systems
International Limited is not liable for any damage you may sustain as a
result of any virus in this e-mail. 

Before opening the e-mail or attachment, You should carry out your own
virus checks. R Systems International Limited reserves the right to
record, monitor, and inspect

 all email communications through its internal and external networks.  R
Systems International Ltd prohibits its information systems from being
used to view, store or forward 

offensive or discriminatory material.

 

 End of Disclaimer 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

---
Please remember to recycle wherever possible. 
Reduce, reuse, recycle, think do you need to print t

Re: [U2] Unibasic: Sample program - to extract data from Table

[Results]

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@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample program - to extract data from Table

[Dattatraya Walgude]

Many Thanks George

Now output is giving following way 

Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D
C
R,7,6
Frobisher, Kamal,P.O. Box 9845
,Denver,CO,80209-,3037780880,,,K
O,33,204


But I want following way ( D,C,R are multivalue ) , date output also
showing 9611 which is (04/24/94) is it possible?

Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,D,7,6
Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,C,7,6
Jones, Bob,123 E. 23rd St.,Arvada,CO,80276,3037768854,V4341,9611,R,7,6

Thanks & Regards,
Dattatraya Walgude


-Original 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 = '' : CHANGE(CHANGE(REC,@AM,','),@VM,CHAR(10)) : ',':ID

I think that the LF character might give you want you want

George

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@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 output.csv in following way, now I want
> multivalue columns in new lines with all columns (now its comes in one
> row/line)
>
> LINE = '' :  CHANGE(CHANGE(REC,@AM,','),@VM,',') :  ',':ID
>
>
> Thanks & Regards,
> Dattatraya Walgude
> DBA Team
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users



  Disclaimer *
 

 

This mail, including any attachments contains confidential and privileged 
information for the sole use of the addressee(s). If you are not the intended 
recipient, 

please notify the sender by e-mail and delete the original message.  Any 
unauthorized review, use, disclosure, dissemination, forwarding, printing or 
copying of

 this email or any action taken in reliance on this e-mail is strictly 
prohibited and are unlawful. This e-mail may contain viruses. R Systems 
International Limited  has 

taken every reasonable precaution to minimize this risk.  R Systems 
International Limited is not liable for any damage you may sustain as a result 
of any virus in this e-mail. 

Before opening the e-mail or attachment, You should carry out your own virus 
checks. R Systems International Limited reserves the right to record, monitor, 
and inspect

 all email communications through its internal and external networks.  R 
Systems International Ltd prohibits its information systems from being used to 
view, store or forward 

offensive or discriminatory material.

 

 End of Disclaimer 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample Program

[broadriver]

Agile? 

The thing about Agile is mimics the real world. It supposed to allows 
flexibility in the design process and attach a business value to what's going 
on. That's what really what happens in practicality. I think it all depends on 
what being developed, as well. 

Creating an ERP System from the ground up requires a different kind of skill 
sets and environment than writing reports to meet end-user-requirements. 

The more I read on it the more it seems to be getting codified and stricter, 
which in itself is a paradox, because, as I understand it, Agile is supposed to 
be what its name means: agile or flexible. 

Rather than being a strict methodology, Agile should me more of a philosophy. 
It's the way most U2 shops work, that I've been in. However, it is becoming, 
itself, more strict from what I read. Ironic! 

Agile is a reaction to the top-down-hierarchical approach to IT, where the 
programmers are simply supposed to be "cogs in a wheel", rather than integral 
to the design and development process. The extreme top-down-hierarchical 
approach failed in the 70's at XEROX... a famous business case... 











- Original Message - 
From: "Susan Lynch"  
To: "U2 Users List"  
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 change, if anyone from the 
original team will a) be there, and b) remember all the intricacies of the 
design decisions made, and c) be part of the new team to modify the original 
stuff. Of course, the 'agile' concept does have a 'design' phase, which to 
me would mean developing the spec from the user's requests, which I write 
and save so that 3 years later, when I get called back and asked how to 
change something, I can hit the ground running rather than reading all the 
code again. 

I look 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"  
To: "U2 Users List"  
Sent: 10/14/2009 3:28 PM 
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 Response Team 
> Market America, Inc. 
> Greensboro, NC 
> 
> 
>> -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 and will 
> never 
>> become ill or incapable of working... Eventually, if the company does 
>> not 
>> go out of business, or their business needs change so much that all 
>> your 
>> code is obsolete, somebody else will have to figure out how the system 
>> works. 
>> 
>> A good spec turns into good documentation, which (properly maintained 
>> through all the ensuing changes to the system for the changing needs 
> of 
>> the 
>> users, of course) is a blessing to the person who follows you. 
>> 
>> Sounds like we have at least 2 of Highlander's Immortals on the list! 
>> ;-) 
>> 
>> Susan Lynch 
>> - Original Message - 
>> From: "Brutzman, Bill"  
>> To: "U2 Users List"  
>> 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 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 
>> > 
>> > ___ 
>> > U2-Users mailing list 
>> > U2-Users@listserver.u2ug.org 
>> > http://listserver.u2ug.org/mailman/listinfo/u2-users 
>> > 
>> > 
>> 
>> ___ 
>> U2-Users mailing list 
>> U2-Users@listserver.u2ug.org 
>> http://listserver.u2ug.org/mailman/listinfo/u2-users 
> ___ 
> U2-Users mailing list 
> U2-Users@listserver.u2ug.org 
> http://listserver.u2ug.org/mailman/listinfo/u2-users 
> 
> 

___ 
U2-Users mailing list 
U2-Users@listserver.u2ug.org 
http://listserver.u2ug.org/mailman/listinfo/u2-users 
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample program - to extract data from Table

[Charles_Shaffer]

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 there."

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample program - to extract data from Table

[George Gallen]

Try first starting with:

LINE = '' : CHANGE(CHANGE(REC,@AM,','),@VM,CHAR(10)) : ',':ID

I think that the LF character might give you want you want

George

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@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 output.csv in following way, now I want
> multivalue columns in new lines with all columns (now its comes in one
> row/line)
>
> LINE = '' :  CHANGE(CHANGE(REC,@AM,','),@VM,',') :  ',':ID
>
>
> Thanks & Regards,
> Dattatraya Walgude
> DBA Team
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample program - to extract data from Table

[Dattatraya Walgude]

Thanks Jeff

Sure, but right now preparing some basics concepts.

Regards,

Dattatraya Walgude


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Powell
Sent: Thursday, October 15, 2009 5:42 PM
To: u2-users@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 you'll get some 
recommendations.

Jeff


On 10/15/2009 12:59 AM, Dattatraya Walgude wrote:
> 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 with all columns (now its comes in one row/line)
>
> LINE = '' :  CHANGE(CHANGE(REC,@AM,','),@VM,',') :  ',':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] Unibasic: Sample program - to extract data from Table
>
> 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 the competition?...
> So...They are probably only charging 10 to 20 per hour...
> So...We are charging a lot more per hour which is why we are not doing the
> work...
>
> A discussion for a different time, so maybe my next blog.
>
> Regards,
> Doug
> www.u2logic.com
>
>
> -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 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 things is we can not get out of DATE column is date format.
> So please give your suggestions.
>
> Jones  Bob123 E. 23rd St. Arvada  CO  80276   3037768854
> V4341 9611D   C   R   7   
> Frobisher  Kamal  P.O. Box 9845   Denver  CO  80209-
> 3037780880K   O   33  
> Steven Spender1212 W. 44thDenver  CO  80401   3034457878
> 3 
> Jamieson   Dale   999 Independence WaySeattle WI  98733
> V6670 96118   
>
>
> One more query
> @ID column is missing in output.csv, please suggest how to get that @ID
> column in output.csv.
>
>
> 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: 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 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 23-02-09ýýAýý70410","15030ýITAýýAýý70410"
> "13973ýITAýýAýý38781","13973ýCHAý CHA to Risk Rate:  MASS_Aýýý38781"
> "15142ýITOý0ýAýý40128","15142ýMEMý1ýPayment Responsibility ChangedýýFrom
> To Y On 15-06-09ýýAýý40129"
> "14369ýITOý0ýAýý64849","15263ýWKLýDC 040ýQueue 888Aýý47136"
> "13910ýWKLýDC 040ýQueue 6AEAýý2898","13910ýSAPý13910ý6RE1ý1ý60+DAY EA
> ROUTE 1ýQ6AEýAýý7858","13910ýSUSýFailed ValidationýýýWITH
> SIXTYD.ABOVE.AMT.OVRD GE 10.00 ý6RE1ýAýý14692","13911ýAOWýFrom BF01G013ýTo
> BF01G162ý6EQ.01ýQUEUE-SPLITTERýýAýý15360","13911ýWKLýDC 040ýQueue
> 6EQ.03ýýQUEUE-SPLITTERýýAýý15360","13942ý
> WKLýDC 040ýQueue 6AEAýý5421","13942ýSAPý13942ý6RE1ý1ý60+DAY EA ROUTE
> 1ýQ6AEýAýý9757","13942ýSUSýFailed ValidationýýýWITH SIXTYD

Re: [U2] Unibasic: Sample program - to extract data from Table

[Jeff Powell]

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 you'll get some 
recommendations.


Jeff


On 10/15/2009 12:59 AM, Dattatraya Walgude wrote:

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 with all columns (now its comes in one row/line)

LINE = '' :  CHANGE(CHANGE(REC,@AM,','),@VM,',') :  ',':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] Unibasic: Sample program - to extract data from Table

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 the competition?...
So...They are probably only charging 10 to 20 per hour...
So...We are charging a lot more per hour which is why we are not doing the
work...

A discussion for a different time, so maybe my next blog.

Regards,
Doug
www.u2logic.com


-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 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 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   
FrobisherKamal  P.O. Box 9845   Denver  CO  80209-
3037780880  K   O   33  
Steven Spender  1212 W. 44thDenver  CO  80401   3034457878
3   
Jamieson Dale   999 Independence WaySeattle WI  98733
V6670   96118   


One more query
@ID column is missing in output.csv, please suggest how to get that @ID
column in output.csv.


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: 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 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 23-02-09ýýAýý70410","15030ýITAýýAýý70410"
"13973ýITAýýAýý38781","13973ýCHAý CHA to Risk Rate:  MASS_Aýýý38781"
"15142ýITOý0ýAýý40128","15142ýMEMý1ýPayment Responsibility ChangedýýFrom
To Y On 15-06-09ýýAýý40129"
"14369ýITOý0ýAýý64849","15263ýWKLýDC 040ýQueue 888Aýý47136"
"13910ýWKLýDC 040ýQueue 6AEAýý2898","13910ýSAPý13910ý6RE1ý1ý60+DAY EA
ROUTE 1ýQ6AEýAýý7858","13910ýSUSýFailed ValidationýýýWITH
SIXTYD.ABOVE.AMT.OVRD GE 10.00 ý6RE1ýAýý14692","13911ýAOWýFrom BF01G013ýTo
BF01G162ý6EQ.01ýQUEUE-SPLITTERýýAýý15360","13911ýWKLýDC 040ýQueue
6EQ.03ýýQUEUE-SPLITTERýýAýý15360","13942ý
WKLýDC 040ýQueue 6AEAýý5421","13942ýSAPý13942ý6RE1ý1ý60+DAY EA ROUTE
1ýQ6AEýAýý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, 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...@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: 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-u

Re: [U2] Unibasic: Sample Program

[Results]

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
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample Program

[Symeon Breen]

RUP, and others are also iterative and iterative is very important -
especially if we are talking multi million dollar projects. Also important
for such deals is definition of scope at the very start, 10% scope creep
comes in at around a million dollars - i haven't got that in my back
pocket...   Agile does allow such definition but it is harder as teams often
think it means they can just forget about a certain aspect till the time
comes and this is not what it is all about 

As with anything you can have the best widget in the world, but if you do
not use it properly it is flawed.

-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 the
system does not get documented. It just means a more iterative process with
decisions being made later in the cycle. "Welcoming the change request" does
not mean that the change doesn't get documented. It means the documents
change with the times. If maintained properly, the docs should be more
likely to be correct. For many of us, we have external forces such as
accrediting agencies that require us to maintain such documentation.
 
BTW, if you haven't seen it before there's a product called OnTime from
http://www.axosoft.com/ that works well in an agile shop.  Check out the
Scrum in 10 minutes video ...
 
Robert
 
 
Robert F. Porter, MCSE, CCNA, ZCE
Lead Sr. Programmer / Analyst
Laboratory Information Services
Ochsner Health System
 
 
 
This transmission (including any attachments) may contain confidential
information, privileged material (including material protected by the
solicitor-client or other applicable privileges), or constitute non-public
information. Any use of this information by anyone other than the intended
recipient is prohibited. If you have received this transmission in error,
please immediately reply to the sender and delete this information from your
system. Use, dissemination, distribution, or reproduction of this
transmission by unintended recipients is not authorized and may be unlawful.


>>> "Susan Lynch"  10/14/2009 4:34 PM >>>
Brenda, I did check it out, and it is interesting, but I still wonder if 3 
years later, when the business requirements change, if anyone from the 
original team will a) be there, and b) remember all the intricacies of the 
design decisions made, and c) be part of the new team to modify the original

stuff.  Of course, the 'agile' concept does have a 'design' phase, which  to

me would mean developing the spec from the user's requests, which I write 
and save so that 3 years later, when I get called back and asked how to 
change something, I can hit the ground running rather than reading all the 
code again.

I look 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" 
To: "U2 Users List" 
Sent: 10/14/2009 3:28 PM
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 Response Team
> Market America, Inc.
> Greensboro, NC
>
>
>> -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 and will
> never
>> become ill or incapable of working...  Eventually, if the company does
>> not
>> go out of business, or their business needs change so much that all
>> your
>> code is obsolete, somebody else will have to figure out how the system
>> works.
>>
>> A good spec turns into good documentation, which (properly maintained
>> through all the ensuing changes to the system for the changing needs
> of
>> the
>> users, of course) is a blessing to the person who follows you.
>>
>> Sounds like we have at least 2 of Highlander's Immortals on the list!
>> ;-)
>>
>> Susan Lynch
>> - Original Message -
>> From: "Brutzman, Bill" 
>> To: "U2 Users List" 
>> 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 th

Re: [U2] Unibasic: Sample program - to extract data from Table

[Symeon Breen]

I don’t know what your background is - i presume you are a programmer - so
just think of the MV fields as arrays - so you need to get the number of
values in the arrays - see what the biggest one is - loop that many times
and repeat the line for each MV just placing that MV's value in there 

To get the number of values in an array use COUNT  or perhaps DCOUNT
To extract just a single value from an array use
REC  e.g. REC<4,5> to get value 5 from
attribute 4

To loop use
 FOR i = 1 TO max
 NEXT i



You should be able to do this now.


-Original Message-
From: 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 @ID column in output.csv in following way, now I want multivalue
columns in new lines with all columns (now its comes in one row/line)

LINE = '' :  CHANGE(CHANGE(REC,@AM,','),@VM,',') :  ',':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] Unibasic: Sample program - to extract data from Table

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 the competition?...
So...They are probably only charging 10 to 20 per hour...
So...We are charging a lot more per hour which is why we are not doing the
work...

A discussion for a different time, so maybe my next blog.

Regards,
Doug
www.u2logic.com


-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 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 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   
FrobisherKamal  P.O. Box 9845   Denver  CO  80209-
3037780880  K   O   33  
Steven Spender  1212 W. 44thDenver  CO  80401   3034457878
3   
Jamieson Dale   999 Independence WaySeattle WI  98733
V6670   96118   


One more query
@ID column is missing in output.csv, please suggest how to get that @ID
column in output.csv.


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: 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 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 23-02-09ýýAýý70410","15030ýITAýýAýý70410"
"13973ýITAýýAýý38781","13973ýCHAý CHA to Risk Rate:  MASS_Aýýý38781"
"15142ýITOý0ýAýý40128","15142ýMEMý1ýPayment Responsibility ChangedýýFrom
To Y On 15-06-09ýýAýý40129"
"14369ýITOý0ýAýý64849","15263ýWKLýDC 040ýQueue 888Aýý47136"
"13910ýWKLýDC 040ýQueue 6AEAýý2898","13910ýSAPý13910ý6RE1ý1ý60+DAY EA
ROUTE 1ýQ6AEýAýý7858","13910ýSUSýFailed ValidationýýýWITH
SIXTYD.ABOVE.AMT.OVRD GE 10.00 ý6RE1ýAýý14692","13911ýAOWýFrom BF01G013ýTo
BF01G162ý6EQ.01ýQUEUE-SPLITTERýýAýý15360","13911ýWKLýDC 040ýQueue
6EQ.03ýýQUEUE-SPLITTERýýAýý15360","13942ý
WKLýDC 040ýQueue 6AEAýý5421","13942ýSAPý13942ý6RE1ý1ý60+DAY EA ROUTE
1ýQ6AEýAýý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, October 12, 2009 5:02 PM
To: U2 Users List
Subject: Re: [U2] Unibasic: Sample program - to extract data from Table

Many Many Thank

Re: [U2] Unibasic: Sample program - to extract data from Table

[Dattatraya Walgude]

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 with all columns (now its comes in one row/line)

LINE = '' :  CHANGE(CHANGE(REC,@AM,','),@VM,',') :  ',':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] Unibasic: Sample program - to extract data from Table

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 the competition?...
So...They are probably only charging 10 to 20 per hour...
So...We are charging a lot more per hour which is why we are not doing the
work...

A discussion for a different time, so maybe my next blog.

Regards,
Doug
www.u2logic.com


-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 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 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   
FrobisherKamal  P.O. Box 9845   Denver  CO  80209-
3037780880  K   O   33  
Steven Spender  1212 W. 44thDenver  CO  80401   3034457878
3   
Jamieson Dale   999 Independence WaySeattle WI  98733
V6670   96118   


One more query
@ID column is missing in output.csv, please suggest how to get that @ID
column in output.csv.


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: 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 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 23-02-09ýýAýý70410","15030ýITAýýAýý70410"
"13973ýITAýýAýý38781","13973ýCHAý CHA to Risk Rate:  MASS_Aýýý38781"
"15142ýITOý0ýAýý40128","15142ýMEMý1ýPayment Responsibility ChangedýýFrom
To Y On 15-06-09ýýAýý40129"
"14369ýITOý0ýAýý64849","15263ýWKLýDC 040ýQueue 888Aýý47136"
"13910ýWKLýDC 040ýQueue 6AEAýý2898","13910ýSAPý13910ý6RE1ý1ý60+DAY EA
ROUTE 1ýQ6AEýAýý7858","13910ýSUSýFailed ValidationýýýWITH
SIXTYD.ABOVE.AMT.OVRD GE 10.00 ý6RE1ýAýý14692","13911ýAOWýFrom BF01G013ýTo
BF01G162ý6EQ.01ýQUEUE-SPLITTERýýAýý15360","13911ýWKLýDC 040ýQueue
6EQ.03ýýQUEUE-SPLITTERýýAýý15360","13942ý
WKLýDC 040ýQueue 6AEAýý5421","13942ýSAPý13942ý6RE1ý1ý60+DAY EA ROUTE
1ýQ6AEýAýý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, 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...@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: 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: 12 October 2009 12:22
To: U2 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 Facin

Re: [U2] Unibasic: Sample Program

[phil walker]

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 think it also depends on a lot on the toolset you are using. This
> approach, if you are writing code in pure pick basic, with minimal
> dictionaries for the files you are using could be suicidal, yet with
> the
> right tools and mindset, this can be a VERY productive way of working.
> In this regard, I firmly agree with what Phil said in relation to his
> BI
> implementations - often it is far quicker to "just do it" than to
> describe what "it" is
> 
> We have dubbed our implementation of agile, iterative development
> vRapid, and we have found it works very well in practice. Sit down
with
> the customer, discover the data that needs to be (or is already being)
> kept and design some files and dictionaries around that. Document the
> inter-relationships as part of the Dictionary, and mock up some
screens
> with these data definitions.
> 
> These screens get fattened out & appropriate business logic engaged
> during the iterative process, and in little more than the time it
would
> take to develop a traditional spec you can have a fully functional
> application  and the client has been engaged 100% during the whole
> process, so there are no surprises, and they are VERY HAPPY (and
> because
> they have seen how easy it is to accommodate change, the application
IS
> likely to keep on growing organically, but this is "controlled feature
> creep" that you get paid for!)
> 
> With the right framework in place, this approach can be a real winner,
> and deliverables can start to flow & be deployed long before the
entire
> project is complete, so it can become a win/win situation
> 
> Ross Ferris
> Stamina Software
> Visage > Better by Design!
> 
> 
> >-Original Message-
> >From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> >boun...@listserver.u2ug.org] On Behalf Of phil walker
> >Sent: Thursday, 15 October 2009 6:56 AM
> >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.
> >
> >This methodology requires a commitment of time and effort by all
> >parties, most importantly a dedicated person from the business tied
to
> >the project who has a stake in the project, not just a BA or someone
> who
> >cannot directly or quickly make decisions about what direction or
> >priorities the project should take. This person, is responsible for
> >seeing that the project delivers what the business requires quickly
> and
> >iteratively...therefore lessoning any chance that is does not deliver
> >what and when.
> >
> >If this happens then the project will deliver what the business
> requires
> >when it is completed. (at least that phase). This in contrast to a
lot
> >off waterfall style projects where the business does not often know
> what
> >they need, at least in detail and so a spec is just a best guess. If
> not
> >then it will take a very long time to get it 99% accurate with no
> >payback for the business, (it will never be 100% unless the project
is
> >very simple). Consequently, there will always change control issues,
> >debate about who should pay for the change etc...very
> unproductive...as
> >well as a BA who is acting as a translator between IT and the
> business.
> >
> >While a spec, might be technical documentation, it requires a lot of
> >effort on the part of everyone to write it but more importantly to
> >maintain it going forward...as I find when the going gets tough and
> time
> >and money is short...documentation is the first to go, a decision
made
> >by who is paying the bills not anyone elses...This is where agile and
> >scrum come to the fore...however it does require a culture change
> within
> >the entire organization to that of a shared partnership between all
> >parties striving for the betterment of the business rather than a
> >confrontational approach which a formal spec signoff/ contract
> >represents...
> >
> >My 2 cents.
> >
> >
> >> -Original Message-
> >> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> >> boun...@listserver.u2ug.org] On Behalf Of Brenda Price
> >> Sent: Thursday, 15 Oct

Re: [U2] Unibasic: Sample Program

[Ross Ferris]

I think it also depends on a lot on the toolset you are using. This
approach, if you are writing code in pure pick basic, with minimal
dictionaries for the files you are using could be suicidal, yet with the
right tools and mindset, this can be a VERY productive way of working.
In this regard, I firmly agree with what Phil said in relation to his BI
implementations - often it is far quicker to "just do it" than to
describe what "it" is

We have dubbed our implementation of agile, iterative development
vRapid, and we have found it works very well in practice. Sit down with
the customer, discover the data that needs to be (or is already being)
kept and design some files and dictionaries around that. Document the
inter-relationships as part of the Dictionary, and mock up some screens
with these data definitions.

These screens get fattened out & appropriate business logic engaged
during the iterative process, and in little more than the time it would
take to develop a traditional spec you can have a fully functional
application  and the client has been engaged 100% during the whole
process, so there are no surprises, and they are VERY HAPPY (and because
they have seen how easy it is to accommodate change, the application IS
likely to keep on growing organically, but this is "controlled feature
creep" that you get paid for!)

With the right framework in place, this approach can be a real winner,
and deliverables can start to flow & be deployed long before the entire
project is complete, so it can become a win/win situation

Ross Ferris
Stamina Software
Visage > Better by Design!


>-Original Message-
>From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
>boun...@listserver.u2ug.org] On Behalf Of phil walker
>Sent: Thursday, 15 October 2009 6:56 AM
>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.
>
>This methodology requires a commitment of time and effort by all
>parties, most importantly a dedicated person from the business tied to
>the project who has a stake in the project, not just a BA or someone
who
>cannot directly or quickly make decisions about what direction or
>priorities the project should take. This person, is responsible for
>seeing that the project delivers what the business requires quickly and
>iteratively...therefore lessoning any chance that is does not deliver
>what and when.
>
>If this happens then the project will deliver what the business
requires
>when it is completed. (at least that phase). This in contrast to a lot
>off waterfall style projects where the business does not often know
what
>they need, at least in detail and so a spec is just a best guess. If
not
>then it will take a very long time to get it 99% accurate with no
>payback for the business, (it will never be 100% unless the project is
>very simple). Consequently, there will always change control issues,
>debate about who should pay for the change etc...very unproductive...as
>well as a BA who is acting as a translator between IT and the business.
>
>While a spec, might be technical documentation, it requires a lot of
>effort on the part of everyone to write it but more importantly to
>maintain it going forward...as I find when the going gets tough and
time
>and money is short...documentation is the first to go, a decision made
>by who is paying the bills not anyone elses...This is where agile and
>scrum come to the fore...however it does require a culture change
within
>the entire organization to that of a shared partnership between all
>parties striving for the betterment of the business rather than a
>confrontational approach which a formal spec signoff/ contract
>represents...
>
>My 2 cents.
>
>
>> -Original Message-
>> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
>> boun...@listserver.u2ug.org] On Behalf Of Brenda Price
>> Sent: Thursday, 15 October 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 Response Team
>> Market America, Inc.
>> Greensboro, NC
>>
>>
>> > -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
>> > Subje

Re: [U2] Unibasic: Sample Program

[Susan Lynch]

Robert, there you have my favorite phrase "If maintained properly" - no 
matter what development practices, the key is to maintain the documentation 
so that the next change request can be reviewed against an accurate 
understanding of the system (particularly in light of the diverse tools now 
being used to access the systems - web products, SQL, and a whole host of 
query tools that make it more complex than ever to identify all the ripple 
effects from what one might think is a "simple change").


Susan Lynch
- Original Message - 
From: "Robert Porter" 

To: "U2 Users List" 
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. "Welcoming the change 
request" does not mean that the change doesn't get documented. It means 
the documents change with the times. If maintained properly, the docs 
should be more likely to be correct. For many of us, we have external 
forces such as accrediting agencies that require us to maintain such 
documentation.


BTW, if you haven't seen it before there's a product called OnTime from 
http://www.axosoft.com/ that works well in an agile shop.  Check out the 
Scrum in 10 minutes video ...


Robert


Robert F. Porter, MCSE, CCNA, ZCE
Lead Sr. Programmer / Analyst
Laboratory Information Services
Ochsner Health System


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample Program

[Robert Porter]

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. "Welcoming the change request" does not mean 
that the change doesn't get documented. It means the documents change with the 
times. If maintained properly, the docs should be more likely to be correct. 
For many of us, we have external forces such as accrediting agencies that 
require us to maintain such documentation.
 
BTW, if you haven't seen it before there's a product called OnTime from 
http://www.axosoft.com/ that works well in an agile shop.  Check out the Scrum 
in 10 minutes video ...
 
Robert
 
 
Robert F. Porter, MCSE, CCNA, ZCE
Lead Sr. Programmer / Analyst
Laboratory Information Services
Ochsner Health System
 
 
 
This transmission (including any attachments) may contain confidential 
information, privileged material (including material protected by the 
solicitor-client or other applicable privileges), or constitute non-public 
information. Any use of this information by anyone other than the intended 
recipient is prohibited. If you have received this transmission in error, 
please immediately reply to the sender and delete this information from your 
system. Use, dissemination, distribution, or reproduction of this transmission 
by unintended recipients is not authorized and may be unlawful.


>>> "Susan Lynch"  10/14/2009 4:34 PM >>>
Brenda, I did check it out, and it is interesting, but I still wonder if 3 
years later, when the business requirements change, if anyone from the 
original team will a) be there, and b) remember all the intricacies of the 
design decisions made, and c) be part of the new team to modify the original 
stuff.  Of course, the 'agile' concept does have a 'design' phase, which  to 
me would mean developing the spec from the user's requests, which I write 
and save so that 3 years later, when I get called back and asked how to 
change something, I can hit the ground running rather than reading all the 
code again.

I look 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" 
To: "U2 Users List" 
Sent: 10/14/2009 3:28 PM
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 Response Team
> Market America, Inc.
> Greensboro, NC
>
>
>> -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 and will
> never
>> become ill or incapable of working...  Eventually, if the company does
>> not
>> go out of business, or their business needs change so much that all
>> your
>> code is obsolete, somebody else will have to figure out how the system
>> works.
>>
>> A good spec turns into good documentation, which (properly maintained
>> through all the ensuing changes to the system for the changing needs
> of
>> the
>> users, of course) is a blessing to the person who follows you.
>>
>> Sounds like we have at least 2 of Highlander's Immortals on the list!
>> ;-)
>>
>> Susan Lynch
>> - Original Message -
>> From: "Brutzman, Bill" 
>> To: "U2 Users List" 
>> 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 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
>> >
>> > ___
>> > U2-Users mailing list
>> > U2-Users@listserver.u2ug.org 
>> > http://listserver.u2ug.org/mailman/listinfo/u2-users 
>> >
>> >
>>
>> ___
>> U2-Users mailing list
>> U2-Users@listserver.u2ug.org 
>> http://listserver.u2ug.org/mailman/listinfo/u2-users 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org 
> http://listserver.u2ug.org/mailman/listinfo/u2-users 
>
> 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org 
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample Program

[Susan Lynch]

Brenda, I did check it out, and it is interesting, but I still wonder if 3 
years later, when the business requirements change, if anyone from the 
original team will a) be there, and b) remember all the intricacies of the 
design decisions made, and c) be part of the new team to modify the original 
stuff.  Of course, the 'agile' concept does have a 'design' phase, which  to 
me would mean developing the spec from the user's requests, which I write 
and save so that 3 years later, when I get called back and asked how to 
change something, I can hit the ground running rather than reading all the 
code again.


I look 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" 

To: "U2 Users List" 
Sent: 10/14/2009 3:28 PM
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 Response Team
Market America, Inc.
Greensboro, NC



-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 and will

never

become ill or incapable of working...  Eventually, if the company does
not
go out of business, or their business needs change so much that all
your
code is obsolete, somebody else will have to figure out how the system
works.

A good spec turns into good documentation, which (properly maintained
through all the ensuing changes to the system for the changing needs

of

the
users, of course) is a blessing to the person who follows you.

Sounds like we have at least 2 of Highlander's Immortals on the list!
;-)

Susan Lynch
- Original Message -
From: "Brutzman, Bill" 
To: "U2 Users List" 
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 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
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
>

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users




___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample Program - Scrum/Agile methodology

[phil walker]

Possibly, and while it probably works better with internal teams, I
think it goes back to what I was saying about it being a partnership
approach. Most vendor/customer relationships are not partner at all,
they may say it is a partnership, but the nature of the beast dictates
otherwise. So if a vendor/customer can have a true partnership and it
then I think it can work, it is just a matter of people defining what
the project is, committing resources and producing results. Both sides
have to buy in though and this is the big culture change for most if not
all organisations...

I do quite a lot of work in the BI field these days, and with the right
tools we are usually able to deliver solutions quickly in a few days
which gives the business user and idea of what they can achieve. To sit
down and spec this with them would take a lot of time and effort and
will will guarantee 100% there will be changes due to crappy data,
missed business logic, or just not understanding what indeed they wanted
or what they could achieve. Showing them by doing and pictures...what is
it a picture is better than 1000 words...works far better in my
experience.

Again though  the business user has to commit to the process as well and
be available and focused in delivering a solution.



> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
> Sent: Thursday, 15 October 2009 9:30 a.m.
> To: 'U2 Users List'
> 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
> that such modifications are ring fenced, costed and planned before the
> project even starts. i.e. part of the sales discussions. As hinted
many
> see
> agile as somewhat open ended so great care is needed. It probably
works
> better for internal projects as opposed to a vendor doing enhancements
> for a
> customer.
> 
> -Original Message-
> From: u2-users-boun...@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.
> 
> This methodology requires a commitment of time and effort by all
> parties, most importantly a dedicated person from the business tied to
> the project who has a stake in the project, not just a BA or someone
> who
> cannot directly or quickly make decisions about what direction or
> priorities the project should take. This person, is responsible for
> seeing that the project delivers what the business requires quickly
and
> iteratively...therefore lessoning any chance that is does not deliver
> what and when.
> 
> If this happens then the project will deliver what the business
> requires
> when it is completed. (at least that phase). This in contrast to a lot
> off waterfall style projects where the business does not often know
> what
> they need, at least in detail and so a spec is just a best guess. If
> not
> then it will take a very long time to get it 99% accurate with no
> payback for the business, (it will never be 100% unless the project is
> very simple). Consequently, there will always change control issues,
> debate about who should pay for the change etc...very
unproductive...as
> well as a BA who is acting as a translator between IT and the
business.
> 
> While a spec, might be technical documentation, it requires a lot of
> effort on the part of everyone to write it but more importantly to
> maintain it going forward...as I find when the going gets tough and
> time
> and money is short...documentation is the first to go, a decision made
> by who is paying the bills not anyone elses...This is where agile and
> scrum come to the fore...however it does require a culture change
> within
> the entire organization to that of a shared partnership between all
> parties striving for the betterment of the business rather than a
> confrontational approach which a formal spec signoff/ contract
> represents...
> 
> My 2 cents.
> 
> 
> > -----Original Message-----
> > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> > boun...@listserver.u2ug.org] On Behalf Of Brenda Price
> > Sent: Thursday, 15 October 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

Re: [U2] Unibasic Sample Program

[Brutzman, Bill]

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 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 that such modifications are ring fenced, costed and
planned before the project even starts. i.e. part of the sales
discussions. As hinted many see agile as somewhat open ended so great
care is needed. It probably works better for internal projects as
opposed to a vendor doing enhancements for a customer.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample Program

[Symeon Breen]

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
that such modifications are ring fenced, costed and planned before the
project even starts. i.e. part of the sales discussions. As hinted many see
agile as somewhat open ended so great care is needed. It probably works
better for internal projects as opposed to a vendor doing enhancements for a
customer.

-Original Message-
From: u2-users-boun...@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.

This methodology requires a commitment of time and effort by all
parties, most importantly a dedicated person from the business tied to
the project who has a stake in the project, not just a BA or someone who
cannot directly or quickly make decisions about what direction or
priorities the project should take. This person, is responsible for
seeing that the project delivers what the business requires quickly and
iteratively...therefore lessoning any chance that is does not deliver
what and when.

If this happens then the project will deliver what the business requires
when it is completed. (at least that phase). This in contrast to a lot
off waterfall style projects where the business does not often know what
they need, at least in detail and so a spec is just a best guess. If not
then it will take a very long time to get it 99% accurate with no
payback for the business, (it will never be 100% unless the project is
very simple). Consequently, there will always change control issues,
debate about who should pay for the change etc...very unproductive...as
well as a BA who is acting as a translator between IT and the business.

While a spec, might be technical documentation, it requires a lot of
effort on the part of everyone to write it but more importantly to
maintain it going forward...as I find when the going gets tough and time
and money is short...documentation is the first to go, a decision made
by who is paying the bills not anyone elses...This is where agile and
scrum come to the fore...however it does require a culture change within
the entire organization to that of a shared partnership between all
parties striving for the betterment of the business rather than a
confrontational approach which a formal spec signoff/ contract
represents...

My 2 cents.


> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Brenda Price
> Sent: Thursday, 15 October 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 Response Team
> Market America, Inc.
> Greensboro, NC
> 
> 
> > -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 and will
> never
> > become ill or incapable of working...  Eventually, if the company
> does
> > not
> > go out of business, or their business needs change so much that all
> > your
> > code is obsolete, somebody else will have to figure out how the
> system
> > works.
> >
> > A good spec turns into good documentation, which (properly
maintained
> > through all the ensuing changes to the system for the changing needs
> of
> > the
> > users, of course) is a blessing to the person who follows you.
> >
> > Sounds like we have at least 2 of Highlander's Immortals on the
list!
> > ;-)
> >
> > Susan Lynch
> > - Original Message -
> > From: "Brutzman, Bill" 
> > To: "U2 Users List" 
> > 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 the specs, I stopped writing to myself.
> > At
> > > the risk of no longer being a professional dinosaur, I learned
that
> > some
> > > people call it 

Re: [U2] Unibasic: Sample program - to extract data from Table

[Susan Lynch]

Mine did too - he came from the Cobol world and didn't think much of 
multivalue systems until he asked me to do a project, signed off on my spec, 
and 2 days later had a completed, documentated, ready to fly system up and 
running.  He was stunned - he thought it was a 6 month project (and 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-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 ability to program on the fly.


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users




___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample Program

[phil walker]

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 the business tied to
the project who has a stake in the project, not just a BA or someone who
cannot directly or quickly make decisions about what direction or
priorities the project should take. This person, is responsible for
seeing that the project delivers what the business requires quickly and
iteratively...therefore lessoning any chance that is does not deliver
what and when.

If this happens then the project will deliver what the business requires
when it is completed. (at least that phase). This in contrast to a lot
off waterfall style projects where the business does not often know what
they need, at least in detail and so a spec is just a best guess. If not
then it will take a very long time to get it 99% accurate with no
payback for the business, (it will never be 100% unless the project is
very simple). Consequently, there will always change control issues,
debate about who should pay for the change etc...very unproductive...as
well as a BA who is acting as a translator between IT and the business.

While a spec, might be technical documentation, it requires a lot of
effort on the part of everyone to write it but more importantly to
maintain it going forward...as I find when the going gets tough and time
and money is short...documentation is the first to go, a decision made
by who is paying the bills not anyone elses...This is where agile and
scrum come to the fore...however it does require a culture change within
the entire organization to that of a shared partnership between all
parties striving for the betterment of the business rather than a
confrontational approach which a formal spec signoff/ contract
represents...

My 2 cents.


> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Brenda Price
> Sent: Thursday, 15 October 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 Response Team
> Market America, Inc.
> Greensboro, NC
> 
> 
> > -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 and will
> never
> > become ill or incapable of working...  Eventually, if the company
> does
> > not
> > go out of business, or their business needs change so much that all
> > your
> > code is obsolete, somebody else will have to figure out how the
> system
> > works.
> >
> > A good spec turns into good documentation, which (properly
maintained
> > through all the ensuing changes to the system for the changing needs
> of
> > the
> > users, of course) is a blessing to the person who follows you.
> >
> > Sounds like we have at least 2 of Highlander's Immortals on the
list!
> > ;-)
> >
> > Susan Lynch
> > - Original Message -
> > From: "Brutzman, Bill" 
> > To: "U2 Users List" 
> > 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 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
> > >
> > > ___
> > > U2-Users mailing list
> > > U2-Users@listserver.u2ug.org
> > > http://listserver.u2ug.org/mailman/listinfo/u2-users
> > >
> > >
> >
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
> 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample program - to extract data from Table

[Jeff Powell]

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 ability to program on the fly.


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample Program

[Brenda Price]

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 Response Team
Market America, Inc.
Greensboro, NC


> -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 and will
never
> become ill or incapable of working...  Eventually, if the company does
> not
> go out of business, or their business needs change so much that all
> your
> code is obsolete, somebody else will have to figure out how the system
> works.
> 
> A good spec turns into good documentation, which (properly maintained
> through all the ensuing changes to the system for the changing needs
of
> the
> users, of course) is a blessing to the person who follows you.
> 
> Sounds like we have at least 2 of Highlander's Immortals on the list!
> ;-)
> 
> Susan Lynch
> - Original Message -
> From: "Brutzman, Bill" 
> To: "U2 Users List" 
> 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 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
> >
> > ___
> > U2-Users mailing list
> > U2-Users@listserver.u2ug.org
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> >
> >
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample Program

[Susan Lynch]

Ah, it must be lovely to know that you will live forever and will never 
become ill or incapable of working...  Eventually, if the company does not 
go out of business, or their business needs change so much that all your 
code is obsolete, somebody else will have to figure out how the system 
works.


A good spec turns into good documentation, which (properly maintained 
through all the ensuing changes to the system for the changing needs of the 
users, of course) is a blessing to the person who follows you.


Sounds like we have at least 2 of Highlander's Immortals on the list!  ;-)

Susan Lynch
- Original Message - 
From: "Brutzman, Bill" 

To: "U2 Users List" 
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 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

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users




___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample Program

[Brenda Price]

Yes, some people also call it "scrum". 

Brenda L Price
UniVerse Programmer
Rapid Response Team
Market America, Inc.
Greensboro, NC

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill
> Sent: Wednesday, 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 that
> some
> people call it "agile".
> 
> Check out... Eckhart Tolle's book "The Power of Now".
> 
> --B
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample Program

[Brutzman, Bill]

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
 
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample program - to extract data from Table

[jpb-u2ug]

Documenting the program or application is always a good idea, it also helps
if changes to the programs are documented, but having to write the specs to
the smallest minutia is overkill. Unless, you are writing the specs for
someone else that doesn't know your business or the next person in line
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 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 review 
the spec, add their 'second thoughts' (and the "wow, this is really cool - 
could it also do this?" ideas before the files are designed and the code 
written, and really does not take a lot of time.  It ensures that the coding

team all understand all the aspects of the project the same way.  So even 
with super users, I always waited for a sign-off on the detailed spec before

laying out the files and writing the code.  I had clients that I worked with

for years, and knew their business very well, but taking the time to write a

detailed spec was never a waste of my time.

I am glad for you that your system works well, but I hope I never have to 
come in after you all retire!  ;-)

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: 
> yes.  Knowledge of how a specific company works: no.  That only comes with

> time working at that site.
>
> A key to our success is having super-users that really know how the 
> business works, how the software works, and the ability to clearly 
> describe how they want things enhanced.  The other half of this coin is 
> having programmer/analysts that understand what the user wants, where the 
> data is stored (or will need to be stored), who ask the right questions, 
> and can work with those super-users.  Our users are very happy with what 
> we produce.  We have a small U2 team, but a well seasoned team.
>
> I rarely have specs and never very detailed.  It is all screen shots with 
> hand written notes that come from a meeting or two with the super-users. 
> Requests from non-super-users must go through the super-users.  It is my 
> job to understand what they want (which is usually, but not always what 
> they ask for).
>
> However, not every business will have these conditions.  Contractors have 
> it even tougher since they may have little knowledge of the business they 
> are trying to help.
>
> Just my experience...
>
>
>
> John Israel
>
>
> -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 had to maintain and enhance systems that were
> written apparently based on a one-page spec that "everyone on the team"
> understood, when the team members are no longer there, and the 
> documentation
> was all between their ears (and left with them), I am a big believer in
> detailed written specs that get turned into test plans and then into
> documentation.
>
> Eventually the lack of specs turns around and bites the organization that
> allowed it to happen (unless the application was a one-time 
> quick-and-dirty
> project that will never have to be resurrected).
>
> Susan 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...@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 data from Table
>>
>> Exactly - i still stick to the belief that a small team of highly skilled
>> programmers will code quicker from a single page spec than a thousand low
>> quality coders using a high detail spec. Many an institution disagrees, 
>> or
>> rather has been stung by smaller teams giving promises th

Re: [U2] Unibasic: Sample program - to extract data from Table

[Tony Gravagno]

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 client later to ask "why
isn't 'this' in there", or "why did you do 'that'?"  A spec helps
to eliminate the questions, to make sure things aren't forgotten,
and to prevent rifts between client expectations and contractor
delivery.

It's certainly true that people can take specs to extremes, with
four hours spent on specs and one on code.  But there have been
times when some number of hours spent on a spec revealed that
there wasn't enough information to begin coding, or that the
project was much more extensive than imagined, so no programming
was done at all.  Compare this to situations where weeks or
months of coding is done and then trashed because someone down
the line realized the code wasn't necessary, or that it all
needed to be re-written because it didn't agree with existing
policies.

Getting the job done isn't just about creating functional code,
it's should include making sure that the next person in line
understands both what the code does and why it does it.  Creating
a proper balance between spec time and coding time is yet another
skill that people should develop over time - and this is what
helps to separate professionals from amateurs.  

Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com
NEW: Follow TonyGravagno on Twitter
remove.pleaseNebula-RnD.com/blog
Visit PickWiki.com! Contribute!

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample program - to extract data from Table

[Anthony W. Youngman]

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 and become the actual classes in the code (there is even
software to build such skeleton code), with each method and property
defined, again this is then used by the test plan to test each
class/method/property etc. The coder kind of just fills in the gaps.  In my
previous employment we had whole teams of BA's, DBA's, System Architects, UI
Designers, UX analysts etc, Then a bunch of people in the Philipines to do
exactly as was written down in front of them.   This kind of scenario
happens a lot in larger projects.


Which is probably why so many larger projects are either a disaster from 
the start, or rapidly turn into legacy (often before they're deployed) 
as the business needs change.


Cheers,
Wol
--
Anthony W. Youngman 
'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the
thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man
lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998
Visit the MaVerick web-site -  Open Source Pick
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample program - to extract data from Table

[Israel, John R.]

Susan,

As a contractor, I agree completely about getting a sign off on specs.  I have 
been in that boat too.  The same is true if you have super-users who may not 
really be that super.

In my current position (on-staff code-monkey), the level of trust is very high 
between the U2 team and the super-users.  It is my job to ask the right 
questions, present the options/risks/etc, and propose additional benefits at 
that time.  I never make any changes of note w/o bashing out the situation with 
the super-users first.

It is also my job to bring up any unforeseen issues that occurs as the coding 
takes shape.

I will never retire!  I will die with one hand on the keyboard and a Dt. Dew in 
the other.


John Israel
Senior Programmer/Analyst
Dayton Superior Corporation

-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: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 review 
the spec, add their 'second thoughts' (and the "wow, this is really cool - 
could it also do this?" ideas before the files are designed and the code 
written, and really does not take a lot of time.  It ensures that the coding 
team all understand all the aspects of the project the same way.  So even 
with super users, I always waited for a sign-off on the detailed spec before 
laying out the files and writing the code.  I had clients that I worked with 
for years, and knew their business very well, but taking the time to write a 
detailed spec was never a waste of my time.

I am glad for you that your system works well, but I hope I never have to 
come in after you all retire!  ;-)

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: 
> yes.  Knowledge of how a specific company works: no.  That only comes with 
> time working at that site.
>
> A key to our success is having super-users that really know how the 
> business works, how the software works, and the ability to clearly 
> describe how they want things enhanced.  The other half of this coin is 
> having programmer/analysts that understand what the user wants, where the 
> data is stored (or will need to be stored), who ask the right questions, 
> and can work with those super-users.  Our users are very happy with what 
> we produce.  We have a small U2 team, but a well seasoned team.
>
> I rarely have specs and never very detailed.  It is all screen shots with 
> hand written notes that come from a meeting or two with the super-users. 
> Requests from non-super-users must go through the super-users.  It is my 
> job to understand what they want (which is usually, but not always what 
> they ask for).
>
> However, not every business will have these conditions.  Contractors have 
> it even tougher since they may have little knowledge of the business they 
> are trying to help.
>
> Just my experience...
>
>
>
> John Israel
>
>
> -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 had to maintain and enhance systems that were
> written apparently based on a one-page spec that "everyone on the team"
> understood, when the team members are no longer there, and the 
> documentation
> was all between their ears (and left with them), I am a big believer in
> detailed written specs that get turned into test plans and then into
> documentation.
>
> Eventually the lack of specs turns around and bites the organization that
> allowed it to happen (unless the application was a one-time 
> quick-and-dirty
> project that will never have to be resurrected).
>
> Susan 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...@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'

Re: [U2] Unibasic: Sample program - to extract data from Table

[Susan Lynch]

John, I agree that listening to the super users is critical.  However, 
writing a detailed spec will give those super users the ability to review 
the spec, add their 'second thoughts' (and the "wow, this is really cool - 
could it also do this?" ideas before the files are designed and the code 
written, and really does not take a lot of time.  It ensures that the coding 
team all understand all the aspects of the project the same way.  So even 
with super users, I always waited for a sign-off on the detailed spec before 
laying out the files and writing the code.  I had clients that I worked with 
for years, and knew their business very well, but taking the time to write a 
detailed spec was never a waste of my time.


I am glad for you that your system works well, but I hope I never have to 
come in after you all retire!  ;-)


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: 
yes.  Knowledge of how a specific company works: no.  That only comes with 
time working at that site.


A key to our success is having super-users that really know how the 
business works, how the software works, and the ability to clearly 
describe how they want things enhanced.  The other half of this coin is 
having programmer/analysts that understand what the user wants, where the 
data is stored (or will need to be stored), who ask the right questions, 
and can work with those super-users.  Our users are very happy with what 
we produce.  We have a small U2 team, but a well seasoned team.


I rarely have specs and never very detailed.  It is all screen shots with 
hand written notes that come from a meeting or two with the super-users. 
Requests from non-super-users must go through the super-users.  It is my 
job to understand what they want (which is usually, but not always what 
they ask for).


However, not every business will have these conditions.  Contractors have 
it even tougher since they may have little knowledge of the business they 
are trying to help.


Just my experience...



John Israel


-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 had to maintain and enhance systems that were
written apparently based on a one-page spec that "everyone on the team"
understood, when the team members are no longer there, and the 
documentation

was all between their ears (and left with them), I am a big believer in
detailed written specs that get turned into test plans and then into
documentation.

Eventually the lack of specs turns around and bites the organization that
allowed it to happen (unless the application was a one-time 
quick-and-dirty

project that will never have to be resurrected).

Susan 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...@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 data from Table

Exactly - i still stick to the belief that a small team of highly skilled
programmers will code quicker from a single page spec than a thousand low
quality coders using a high detail spec. Many an institution disagrees, 
or

rather has been stung by smaller teams giving promises that they can then
not deliver, I suppose this is what bureaucracy is all about, something
simple runs perfectly until someone slips up, then all hell breaks loose
and
15 procedures are put into place and before you know it you have a team 
of

20 doing what one guy did all on his own.



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users




___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample program - to extract data from Table

[Israel, John R.]

You cannot buy knowledge of a business.  Experience with a technology: yes.  
Knowledge of how a specific company works: no.  That only comes with time 
working at that site.

A key to our success is having super-users that really know how the business 
works, how the software works, and the ability to clearly describe how they 
want things enhanced.  The other half of this coin is having 
programmer/analysts that understand what the user wants, where the data is 
stored (or will need to be stored), who ask the right questions, and can work 
with those super-users.  Our users are very happy with what we produce.  We 
have a small U2 team, but a well seasoned team.

I rarely have specs and never very detailed.  It is all screen shots with hand 
written notes that come from a meeting or two with the super-users.  Requests 
from non-super-users must go through the super-users.  It is my job to 
understand what they want (which is usually, but not always what they ask for).

However, not every business will have these conditions.  Contractors have it 
even tougher since they may have little knowledge of the business they are 
trying to help.

Just my experience...



John Israel


-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 had to maintain and enhance systems that were 
written apparently based on a one-page spec that "everyone on the team" 
understood, when the team members are no longer there, and the documentation 
was all between their ears (and left with them), I am a big believer in 
detailed written specs that get turned into test plans and then into 
documentation.

Eventually the lack of specs turns around and bites the organization that 
allowed it to happen (unless the application was a one-time quick-and-dirty 
project that will never have to be resurrected).

Susan 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...@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 data from Table
>
> Exactly - i still stick to the belief that a small team of highly skilled
> programmers will code quicker from a single page spec than a thousand low
> quality coders using a high detail spec. Many an institution disagrees, or
> rather has been stung by smaller teams giving promises that they can then
> not deliver, I suppose this is what bureaucracy is all about, something
> simple runs perfectly until someone slips up, then all hell breaks loose 
> and
> 15 procedures are put into place and before you know it you have a team of
> 20 doing what one guy did all on his own.
>

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample program - to extract data from Table

[Susan Lynch]

As a programmer who has had to maintain and enhance systems that were 
written apparently based on a one-page spec that "everyone on the team" 
understood, when the team members are no longer there, and the documentation 
was all between their ears (and left with them), I am a big believer in 
detailed written specs that get turned into test plans and then into 
documentation.


Eventually the lack of specs turns around and bites the organization that 
allowed it to happen (unless the application was a one-time quick-and-dirty 
project that will never have to be resurrected).


Susan 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...@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 data from Table

Exactly - i still stick to the belief that a small team of highly skilled
programmers will code quicker from a single page spec than a thousand low
quality coders using a high detail spec. Many an institution disagrees, or
rather has been stung by smaller teams giving promises that they can then
not deliver, I suppose this is what bureaucracy is all about, something
simple runs perfectly until someone slips up, then all hell breaks loose 
and

15 procedures are put into place and before you know it you have a team of
20 doing what one guy did all on his own.



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample Program

[Brutzman, Bill]

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, 2009 6:00 AM

Exactly - i still stick to the belief that a small team of highly
skilled programmers will code quicker from a single page spec than a
thousand low quality coders using a high detail spec. Many an
institution disagrees, or rather has been stung by smaller teams giving
promises that they can then not deliver, I suppose this is what
bureaucracy is all about, something simple runs perfectly until someone
slips up, then all hell breaks loose and
15 procedures are put into place and before you know it you have a team
of 20 doing what one guy did all on his own.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample program - to extract data from Table

[jpb-u2ug]

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 data from Table

Exactly - i still stick to the belief that a small team of highly skilled
programmers will code quicker from a single page spec than a thousand low
quality coders using a high detail spec. Many an institution disagrees, or
rather has been stung by smaller teams giving promises that they can then
not deliver, I suppose this is what bureaucracy is all about, something
simple runs perfectly until someone slips up, then all hell breaks loose and
15 procedures are put into place and before you know it you have a team of
20 doing what one guy did all on his own.

-Original 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 minutia then why not just type it
in and get done with it?

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Tuesday, October 13, 2009 2:09 PM
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 to the architectural
specifications and become the actual classes in the code (there is even
software to build such skeleton code), with each method and property
defined, again this is then used by the test plan to test each
class/method/property etc. The coder kind of just fills in the gaps.  In my
previous employment we had whole teams of BA's, DBA's, System Architects, UI
Designers, UX analysts etc, Then a bunch of people in the Philipines to do
exactly as was written down in front of them.   This kind of scenario
happens a lot in larger projects.

 
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug
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 that types it in several times over and over again. We just
make copies of it. Programming takes skill, intelligence, and imagination.
It is not a massed produced product like linen or towels where they have to
have a body to recreate the product over and over.

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: 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 you get large pools of programmers of various skill levels, and so
need more management time than it would take to program it in the first
place. But then this is in theory more scalable.

I live in the north west of England, just outside Manchester, the Industrial
revolution started here, It was once very big in the textile industry-
However no textiles are made here anymore, the old Victorian buildings that
used to produce these are now trendy apartments, or business parks. There
are a few specialist providers, I can kind of see software going the same
way. Much of software is grinding out work, that can be done very cheaply in
India/China/and Africa soon. All we in the western world will be doing is
niche specialist 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 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 free help from mailing lists, newsgroups, etc, because they don't
understand the technology.  Indian firm loses contract or is not renewed.

We've got persona

Re: [U2] Unibasic: Sample program - to extract data from Table

[Symeon Breen]

Exactly - i still stick to the belief that a small team of highly skilled
programmers will code quicker from a single page spec than a thousand low
quality coders using a high detail spec. Many an institution disagrees, or
rather has been stung by smaller teams giving promises that they can then
not deliver, I suppose this is what bureaucracy is all about, something
simple runs perfectly until someone slips up, then all hell breaks loose and
15 procedures are put into place and before you know it you have a team of
20 doing what one guy did all on his own.

-Original 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 minutia then why not just type it
in and get done with it?

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Tuesday, October 13, 2009 2:09 PM
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 to the architectural
specifications and become the actual classes in the code (there is even
software to build such skeleton code), with each method and property
defined, again this is then used by the test plan to test each
class/method/property etc. The coder kind of just fills in the gaps.  In my
previous employment we had whole teams of BA's, DBA's, System Architects, UI
Designers, UX analysts etc, Then a bunch of people in the Philipines to do
exactly as was written down in front of them.   This kind of scenario
happens a lot in larger projects.

 
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug
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 that types it in several times over and over again. We just
make copies of it. Programming takes skill, intelligence, and imagination.
It is not a massed produced product like linen or towels where they have to
have a body to recreate the product over and over.

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: 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 you get large pools of programmers of various skill levels, and so
need more management time than it would take to program it in the first
place. But then this is in theory more scalable.

I live in the north west of England, just outside Manchester, the Industrial
revolution started here, It was once very big in the textile industry-
However no textiles are made here anymore, the old Victorian buildings that
used to produce these are now trendy apartments, or business parks. There
are a few specialist providers, I can kind of see software going the same
way. Much of software is grinding out work, that can be done very cheaply in
India/China/and Africa soon. All we in the western world will be doing is
niche specialist 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 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 free help from mailing lists, newsgroups, etc, because they don't
understand the technology.  Indian firm loses contract or is not renewed.

We've got personal experience in taking development contracts away from this
type of firm.

Larry Hiscock
Western Computer Services



-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

[jpb-u2ug]

If you are going to go that far with the minutia then why not just type it
in and get done with it?

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Tuesday, October 13, 2009 2:09 PM
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 to the architectural
specifications and become the actual classes in the code (there is even
software to build such skeleton code), with each method and property
defined, again this is then used by the test plan to test each
class/method/property etc. The coder kind of just fills in the gaps.  In my
previous employment we had whole teams of BA's, DBA's, System Architects, UI
Designers, UX analysts etc, Then a bunch of people in the Philipines to do
exactly as was written down in front of them.   This kind of scenario
happens a lot in larger projects.

 
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug
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 that types it in several times over and over again. We just
make copies of it. Programming takes skill, intelligence, and imagination.
It is not a massed produced product like linen or towels where they have to
have a body to recreate the product over and over.

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: 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 you get large pools of programmers of various skill levels, and so
need more management time than it would take to program it in the first
place. But then this is in theory more scalable.

I live in the north west of England, just outside Manchester, the Industrial
revolution started here, It was once very big in the textile industry-
However no textiles are made here anymore, the old Victorian buildings that
used to produce these are now trendy apartments, or business parks. There
are a few specialist providers, I can kind of see software going the same
way. Much of software is grinding out work, that can be done very cheaply in
India/China/and Africa soon. All we in the western world will be doing is
niche specialist 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 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 free help from mailing lists, newsgroups, etc, because they don't
understand the technology.  Indian firm loses contract or is not renewed.

We've got personal experience in taking development contracts away from this
type of firm.

Larry Hiscock
Western Computer Services



-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 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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listser

Re: [U2] Unibasic: Sample program - to extract data from Table

[David Jordan]

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 functions 
that don't require smarts but are responsible for a volume of the work in these 
languages.

Ironically as in manufacturing, automation is replacing the manual repetitive 
work.  The next release of .Net is reducing a lot of this unnecessary work.  If 
you can structure coding to be like a production line catering for less skilled 
people, then you can automate it and that is what .Net is doing.  Hence 
automation is going to kill the lucrative outsourcing business in the end.

The key to survival is being resourceful, adaptive and innovative.  The days of 
coding drones is becoming numbered.  What businesses need are people who come 
up with innovative and clever ways of doing things that improves the bottom 
line.

David Jordan
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample program - to extract data from Table

[Symeon Breen]

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 and become the actual classes in the code (there is even
software to build such skeleton code), with each method and property
defined, again this is then used by the test plan to test each
class/method/property etc. The coder kind of just fills in the gaps.  In my
previous employment we had whole teams of BA's, DBA's, System Architects, UI
Designers, UX analysts etc, Then a bunch of people in the Philipines to do
exactly as was written down in front of them.   This kind of scenario
happens a lot in larger projects.

 
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug
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 that types it in several times over and over again. We just
make copies of it. Programming takes skill, intelligence, and imagination.
It is not a massed produced product like linen or towels where they have to
have a body to recreate the product over and over.

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: 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 you get large pools of programmers of various skill levels, and so
need more management time than it would take to program it in the first
place. But then this is in theory more scalable.

I live in the north west of England, just outside Manchester, the Industrial
revolution started here, It was once very big in the textile industry-
However no textiles are made here anymore, the old Victorian buildings that
used to produce these are now trendy apartments, or business parks. There
are a few specialist providers, I can kind of see software going the same
way. Much of software is grinding out work, that can be done very cheaply in
India/China/and Africa soon. All we in the western world will be doing is
niche specialist 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 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 free help from mailing lists, newsgroups, etc, because they don't
understand the technology.  Indian firm loses contract or is not renewed.

We've got personal experience in taking development contracts away from this
type of firm.

Larry Hiscock
Western Computer Services



-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 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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample program

[George Gallen]

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: Sample program
>
>
> The two main ingredients in any good software are.. [1] Guts and [2]
> Brains.
>
> --B
>
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample program

[Brutzman, Bill]

The two main ingredients in any good software are.. [1] Guts and [2]
Brains.

--B 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug
Sent: Tuesday, October 13, 2009 12:53 PM
To: 'U2 Users List'
Subject: Re: [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

Re: [U2] Unibasic: Sample program - to extract data from Table

[jpb-u2ug]

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 over and over again. We just
make copies of it. Programming takes skill, intelligence, and imagination.
It is not a massed produced product like linen or towels where they have to
have a body to recreate the product over and over.

Jerry Banker


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: 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 you get large pools of programmers of various skill levels, and so
need more management time than it would take to program it in the first
place. But then this is in theory more scalable.

I live in the north west of England, just outside Manchester, the Industrial
revolution started here, It was once very big in the textile industry-
However no textiles are made here anymore, the old Victorian buildings that
used to produce these are now trendy apartments, or business parks. There
are a few specialist providers, I can kind of see software going the same
way. Much of software is grinding out work, that can be done very cheaply in
India/China/and Africa soon. All we in the western world will be doing is
niche specialist 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 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 free help from mailing lists, newsgroups, etc, because they don't
understand the technology.  Indian firm loses contract or is not renewed.

We've got personal experience in taking development contracts away from this
type of firm.

Larry Hiscock
Western Computer Services



-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 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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample program - to extract data from Table

[jpb-u2ug]

I don't think anyone was questioning Jay's intelligence. He is probably a
very intelligent person or he would not have been hired. What is in question
is the intelligence of the individuals that hired the firm he works for and
the intelligence of the people that gave him the work to do without 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 - to extract data from Table

Excellent points.  In my personal experience, I've had terrible dealings
with overseas firms.  On the flip side, the sharpest person I've ever worked
with was from New Delhi.
 
Getting back to the point at hand, I believe that Pick Systems had some
development work done in Russia, during the early 90's.  I remember their
work as being very good and remarkably bug-free. (Of course, I also drank a
lot during those days, so my memory may not be that good.)  Now,all of a
sudden, at the same time that Rocket Software picks up U2, we start getting
questions from rsystems in India.  Naturally, I wondered if Rocket Software
was the company that hired them.  Probably not, but I'm still curious.

>>> "Larry Hiscock"  10/12/2009 5:09 PM >>>
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 free help from mailing lists, newsgroups, etc, because they don't
understand the technology.  Indian firm loses contract or is not renewed.

We've got personal experience in taking development contracts away from this
type of firm.

Larry Hiscock
Western Computer Services



-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 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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample program - to extract data from Table

[Symeon Breen]

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 of programmers of various skill levels, and so
need more management time than it would take to program it in the first
place. But then this is in theory more scalable.

I live in the north west of England, just outside Manchester, the Industrial
revolution started here, It was once very big in the textile industry-
However no textiles are made here anymore, the old Victorian buildings that
used to produce these are now trendy apartments, or business parks. There
are a few specialist providers, I can kind of see software going the same
way. Much of software is grinding out work, that can be done very cheaply in
India/China/and Africa soon. All we in the western world will be doing is
niche specialist 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 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 free help from mailing lists, newsgroups, etc, because they don't
understand the technology.  Indian firm loses contract or is not renewed.

We've got personal experience in taking development contracts away from this
type of firm.

Larry Hiscock
Western Computer Services



-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 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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample program - to extract data from Table

[Charlie Rubeor]

Excellent points.  In my personal experience, I've had terrible dealings with 
overseas firms.  On the flip side, the sharpest person I've ever worked with 
was from New Delhi.
 
Getting back to the point at hand, I believe that Pick Systems had some 
development work done in Russia, during the early 90's.  I remember their work 
as being very good and remarkably bug-free. (Of course, I also drank a lot 
during those days, so my memory may not be that good.)  Now,all of a sudden, at 
the same time that Rocket Software picks up U2, we start getting questions from 
rsystems in India.  Naturally, I wondered if Rocket Software was the company 
that hired them.  Probably not, but I'm still curious.

>>> "Larry Hiscock"  10/12/2009 5:09 PM >>>
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 free help from mailing lists, newsgroups, etc, because they don't
understand the technology.  Indian firm loses contract or is not renewed.

We've got personal experience in taking development contracts away from this
type of firm.

Larry Hiscock
Western Computer Services



-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 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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample program - to extract data from Table

[Larry Hiscock]

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 free help from mailing lists, newsgroups, etc, because they don't
understand the technology.  Indian firm loses contract or is not renewed.

We've got personal experience in taking development contracts away from this
type of firm.

Larry Hiscock
Western Computer Services



-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 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
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample program - to extract data from Table

[BNeylon]

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"  
Sent by: u2-users-boun...@listserver.u2ug.org
10/12/2009 04:10 PM
Please 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/
 
It is a question that needs to be asked.  Was this firm contracted for 
support or for development?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample program - to extract data from Table

[Charlie Rubeor]

> 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 mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample program - to extract data from Table

[Doug]

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 the competition?...
So...They are probably only charging 10 to 20 per hour...
So...We are charging a lot more per hour which is why we are not doing the
work...

A discussion for a different time, so maybe my next blog.

Regards,
Doug
www.u2logic.com


-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 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 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   
FrobisherKamal  P.O. Box 9845   Denver  CO  80209-
3037780880  K   O   33  
Steven Spender  1212 W. 44thDenver  CO  80401   3034457878
3   
Jamieson Dale   999 Independence WaySeattle WI  98733
V6670   96118   


One more query
@ID column is missing in output.csv, please suggest how to get that @ID
column in output.csv.


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: 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 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 23-02-09ýýAýý70410","15030ýITAýýAýý70410"
"13973ýITAýýAýý38781","13973ýCHAý CHA to Risk Rate:  MASS_Aýýý38781"
"15142ýITOý0ýAýý40128","15142ýMEMý1ýPayment Responsibility ChangedýýFrom
To Y On 15-06-09ýýAýý40129"
"14369ýITOý0ýAýý64849","15263ýWKLýDC 040ýQueue 888Aýý47136"
"13910ýWKLýDC 040ýQueue 6AEAýý2898","13910ýSAPý13910ý6RE1ý1ý60+DAY EA
ROUTE 1ýQ6AEýAýý7858","13910ýSUSýFailed ValidationýýýWITH
SIXTYD.ABOVE.AMT.OVRD GE 10.00 ý6RE1ýAýý14692","13911ýAOWýFrom BF01G013ýTo
BF01G162ý6EQ.01ýQUEUE-SPLITTERýýAýý15360","13911ýWKLýDC 040ýQueue
6EQ.03ýýQUEUE-SPLITTERýýAýý15360","13942ý
WKLýDC 040ýQueue 6AEAýý5421","13942ýSAPý13942ý6RE1ý1ý60+DAY EA ROUTE
1ýQ6AEýAýý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, 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...@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: 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: 12 October 2009 12:22
To: U2 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 FIL

LOOP WHILE READNEXT ID DO

 READ REC FROM FIL,ID THEN

 LINE = '"' : CHANGE(CHANGE(REC,@AM,'","'),@SVM,',') : '"'

 WRITESEQ LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE'

END

REPEAT

 

 

Facing compilation error

 

:BASIC BP outfile

 

Compiling Unibasic: BP/outfile in mode 'u'.

main program: syntax error at or before

 OPENSEQ 'OUTPUT.CSV' TO CSVFIL

  

Re: [U2] Unibasic: Sample program - to extract data from Table

[Mark Eastwood]

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: 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-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample program - to extract data from Table

[Edward Brown]

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 ID in the example program holds the 
same value as @ID.

Formatting a value as a date - see the OCONV function in the documentation.

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 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. 23rd St. Arvada  CO  80276   3037768854  V4341   
9611D   C   R   7   
FrobisherKamal  P.O. Box 9845   Denver  CO  80209-  
3037780880  K   O   33  
Steven Spender  1212 W. 44thDenver  CO  80401   3034457878  
3   
Jamieson Dale   999 Independence WaySeattle WI  98733   
V6670   96118   


One more query
@ID column is missing in output.csv, please suggest how to get that @ID column 
in output.csv.


Regards
Dattatraya Walgude


-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 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 to be comma delimited lists, again you will need to ensure there are
no commas in the data - or you may want to normalise and produce a row in
the csv per multi value, or perhaps if the multivalues are not an array of
associated data but individual pieces of data you could split them to
multiple columns, This very much depends on the structure of the data and
what you are trying to achieve with it.

To fix the below "funny characters" replace @SVM with @VM

If you do have sub values in your data you may need to do some further
conversions etc

Rgds
Symeon







-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: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 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 23-02-09ýýAýý70410","15030ýITAýýAýý70410"
"13973ýITAýýAýý38781","13973ýCHAý CHA to Risk Rate:  MASS_Aýýý38781"
"15142ýITOý0ýAýý40128","15142ýMEMý1ýPayment Responsibility ChangedýýFrom
To Y On 15-06-09ýýAýý40129"
"14369ýITOý0ýAýý64849","15263ýWKLýDC 040ýQueue 888Aýý47136"
"13910ýWKLýDC 040ýQueue 6AEAýý2898","13910ýSAPý13910ý6RE1ý1ý60+DAY EA
ROUTE 1ýQ6AEýAýý7858","13910ýSUSýFailed ValidationýýýWITH
SIXTYD.ABOVE.AMT.OVRD GE
10.00 ý6RE1ýAýý14692","13911ýAOWýFrom BF01G013ýTo
BF01G162ý6EQ.01ýQUEUE-SPLITTERýýAýý15360","13911ýWKLýDC 040ýQueue
6EQ.03ýýQUEUE-SPLITTERýýAýý15360","13942ý
WKLýDC 040ýQueue 6AEAýý5421","13942ýSAPý13942ý6RE1ý1ý60+DAY EA ROUTE
1ýQ6AEýAýý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, 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...@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: Re: [U2] Unibasic: Sample program - to ex

Re: [U2] Unibasic: Sample program - to extract data from Table

[Dattatraya Walgude]

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   
FrobisherKamal  P.O. Box 9845   Denver  CO  80209-  
3037780880  K   O   33  
Steven Spender  1212 W. 44thDenver  CO  80401   3034457878  
3   
Jamieson Dale   999 Independence WaySeattle WI  98733   
V6670   96118   


One more query
@ID column is missing in output.csv, please suggest how to get that @ID column 
in output.csv.


Regards
Dattatraya Walgude


-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 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 to be comma delimited lists, again you will need to ensure there are
no commas in the data - or you may want to normalise and produce a row in
the csv per multi value, or perhaps if the multivalues are not an array of
associated data but individual pieces of data you could split them to
multiple columns, This very much depends on the structure of the data and
what you are trying to achieve with it.

To fix the below "funny characters" replace @SVM with @VM

If you do have sub values in your data you may need to do some further
conversions etc

Rgds
Symeon







-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: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 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 23-02-09ýýAýý70410","15030ýITAýýAýý70410"
"13973ýITAýýAýý38781","13973ýCHAý CHA to Risk Rate:  MASS_Aýýý38781"
"15142ýITOý0ýAýý40128","15142ýMEMý1ýPayment Responsibility ChangedýýFrom
To Y On 15-06-09ýýAýý40129"
"14369ýITOý0ýAýý64849","15263ýWKLýDC 040ýQueue 888Aýý47136"
"13910ýWKLýDC 040ýQueue 6AEAýý2898","13910ýSAPý13910ý6RE1ý1ý60+DAY EA
ROUTE 1ýQ6AEýAýý7858","13910ýSUSýFailed ValidationýýýWITH
SIXTYD.ABOVE.AMT.OVRD GE
10.00 ý6RE1ýAýý14692","13911ýAOWýFrom BF01G013ýTo
BF01G162ý6EQ.01ýQUEUE-SPLITTERýýAýý15360","13911ýWKLýDC 040ýQueue
6EQ.03ýýQUEUE-SPLITTERýýAýý15360","13942ý
WKLýDC 040ýQueue 6AEAýý5421","13942ýSAPý13942ý6RE1ý1ý60+DAY EA ROUTE
1ýQ6AEýAýý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, 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...@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: 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: 12 October 2009 12:22
To: U2 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 FIL

LOOP WHILE READNEXT ID DO

 READ REC FROM FIL,ID THEN

 LINE = '"&#

Re: [U2] Unibasic: Sample program - to extract data from Table

[Symeon Breen]

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 to be comma delimited lists, again you will need to ensure there are
no commas in the data - or you may want to normalise and produce a row in
the csv per multi value, or perhaps if the multivalues are not an array of
associated data but individual pieces of data you could split them to
multiple columns, This very much depends on the structure of the data and
what you are trying to achieve with it.

To fix the below "funny characters" replace @SVM with @VM

If you do have sub values in your data you may need to do some further
conversions etc

Rgds
Symeon







-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: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 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 23-02-09ýýAýý70410","15030ýITAýýAýý70410"
"13973ýITAýýAýý38781","13973ýCHAý CHA to Risk Rate:  MASS_Aýýý38781"
"15142ýITOý0ýAýý40128","15142ýMEMý1ýPayment Responsibility ChangedýýFrom
To Y On 15-06-09ýýAýý40129"
"14369ýITOý0ýAýý64849","15263ýWKLýDC 040ýQueue 888Aýý47136"
"13910ýWKLýDC 040ýQueue 6AEAýý2898","13910ýSAPý13910ý6RE1ý1ý60+DAY EA
ROUTE 1ýQ6AEýAýý7858","13910ýSUSýFailed ValidationýýýWITH
SIXTYD.ABOVE.AMT.OVRD GE
10.00 ý6RE1ýAýý14692","13911ýAOWýFrom BF01G013ýTo
BF01G162ý6EQ.01ýQUEUE-SPLITTERýýAýý15360","13911ýWKLýDC 040ýQueue
6EQ.03ýýQUEUE-SPLITTERýýAýý15360","13942ý
WKLýDC 040ýQueue 6AEAýý5421","13942ýSAPý13942ý6RE1ý1ý60+DAY EA ROUTE
1ýQ6AEýAýý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, 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...@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: 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: 12 October 2009 12:22
To: U2 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 FIL

LOOP WHILE READNEXT ID DO

 READ REC FROM FIL,ID THEN

 LINE = '"' : CHANGE(CHANGE(REC,@AM,'","'),@SVM,',') : '"'

 WRITESEQ LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE'

END

REPEAT

 

 

Facing compilation error

 

:BASIC BP outfile

 

Compiling Unibasic: BP/outfile in mode 'u'.

main program: syntax error at or before

 OPENSEQ 'OUTPUT.CSV' TO CSVFIL

 --^

Expecting: ELSE

 

compilation failed

 

 

 

Thanks & Regards,

Dattatraya Walgude

DBA Team 

Rsystems International Ltd, Pune,

( : +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 Table

 

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 

Re: [U2] Unibasic: Sample program - to extract data from Table

[Dattatraya Walgude]

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 23-02-09ýýAýý70410","15030ýITAýýAýý70410"
"13973ýITAýýAýý38781","13973ýCHAý CHA to Risk Rate:  MASS_Aýýý38781"
"15142ýITOý0ýAýý40128","15142ýMEMý1ýPayment Responsibility ChangedýýFrom  
To Y On 15-06-09ýýAýý40129"
"14369ýITOý0ýAýý64849","15263ýWKLýDC 040ýQueue 888Aýý47136"
"13910ýWKLýDC 040ýQueue 6AEAýý2898","13910ýSAPý13910ý6RE1ý1ý60+DAY EA ROUTE 
1ýQ6AEýAýý7858","13910ýSUSýFailed ValidationýýýWITH SIXTYD.ABOVE.AMT.OVRD GE
10.00 ý6RE1ýAýý14692","13911ýAOWýFrom BF01G013ýTo 
BF01G162ý6EQ.01ýQUEUE-SPLITTERýýAýý15360","13911ýWKLýDC 040ýQueue 
6EQ.03ýýQUEUE-SPLITTERýýAýý15360","13942ý
WKLýDC 040ýQueue 6AEAýý5421","13942ýSAPý13942ý6RE1ý1ý60+DAY EA ROUTE 
1ýQ6AEýAýý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, 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...@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: 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: 12 October 2009 12:22
To: U2 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 FIL

LOOP WHILE READNEXT ID DO

 READ REC FROM FIL,ID THEN

 LINE = '"' : CHANGE(CHANGE(REC,@AM,'","'),@SVM,',') : '"'

 WRITESEQ LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE'

END

REPEAT

 

 

Facing compilation error

 

:BASIC BP outfile

 

Compiling Unibasic: BP/outfile in mode 'u'.

main program: syntax error at or before

 OPENSEQ 'OUTPUT.CSV' TO CSVFIL

 --^

Expecting: ELSE

 

compilation failed

 

 

 

Thanks & Regards,

Dattatraya Walgude

DBA Team 

Rsystems International Ltd, Pune,

( : +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 Table

 

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 WHILE READNEXT ID DO

 READ REC FROM FIL,ID THEN

 LINE = '"' : CHANGE(CHANGE(REC,@AM,'","'),@SVM,',') : '"'

 WRITESEQ LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE'

END

REPEAT

 

 

 

 

Rgds

Symeon.

 

 

-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 06:14

To: u2-users@listserver.u2ug.org

Subject: [U2] Unibasic: Sample program - to extract data from Table

 

Dear All

 

 

 

I am new in Unidata/Unibasic, I want a sample program to extract data

from one of our big history table.

 

 

 

Kindly give me any link/ suggestion.

 

Thanks & Regards,

Dattatraya Walgude

 

 

 

 

 

 

  Disclaimer *

 

 

 

 

This mail, including any attachments contains confidential and
privileged

information for the sole use of the addressee(s). If you are not the

intended recipient, 

 

please notify the sender by e-mail and delete the orig

Re: [U2] Unibasic: Sample program - to extract data from Table

[Dattatraya Walgude]

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: 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: 12 October 2009 12:22
To: U2 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 FIL

LOOP WHILE READNEXT ID DO

 READ REC FROM FIL,ID THEN

 LINE = '"' : CHANGE(CHANGE(REC,@AM,'","'),@SVM,',') : '"'

 WRITESEQ LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE'

END

REPEAT

 

 

Facing compilation error

 

:BASIC BP outfile

 

Compiling Unibasic: BP/outfile in mode 'u'.

main program: syntax error at or before

 OPENSEQ 'OUTPUT.CSV' TO CSVFIL

 --^

Expecting: ELSE

 

compilation failed

 

 

 

Thanks & Regards,

Dattatraya Walgude

DBA Team 

Rsystems International Ltd, Pune,

( : +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 Table

 

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 WHILE READNEXT ID DO

 READ REC FROM FIL,ID THEN

 LINE = '"' : CHANGE(CHANGE(REC,@AM,'","'),@SVM,',') : '"'

 WRITESEQ LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE'

END

REPEAT

 

 

 

 

Rgds

Symeon.

 

 

-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 06:14

To: u2-users@listserver.u2ug.org

Subject: [U2] Unibasic: Sample program - to extract data from Table

 

Dear All

 

 

 

I am new in Unidata/Unibasic, I want a sample program to extract data

from one of our big history table.

 

 

 

Kindly give me any link/ suggestion.

 

Thanks & Regards,

Dattatraya Walgude

 

 

 

 

 

 

  Disclaimer *

 

 

 

 

This mail, including any attachments contains confidential and
privileged

information for the sole use of the addressee(s). If you are not the

intended recipient, 

 

please notify the sender by e-mail and delete the original message.  Any

unauthorized review, use, disclosure, dissemination, forwarding,
printing or

copying of

 

 this email or any action taken in reliance on this e-mail is strictly

prohibited and are unlawful. This e-mail may contain viruses. R Systems

International Limited  has 

 

taken every reasonable precaution to minimize this risk.  R Systems

International Limited is not liable for any damage you may sustain as a

result of any virus in this e-mail. 

 

Before opening the e-mail or attachment, You should carry out your own
virus

checks. R Systems International Limited reserves the right to record,

monitor, and inspect

 

 all email communications through its internal and external networks.  R

Systems International Ltd prohibits its information systems from being
used

to view, store or forward 

 

offensive or discriminatory material.

 

 

 

 End of Disclaimer 

 

___

U2-Users mailing list

U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users

 

___

U2-Users mailing list

U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users

 

 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

---
Please remember to recycle wherever possible. 
Reduce, reuse, recycle, think do you need to print this e-mail?
---

Re: [U2] Unibasic: Sample program - to extract data from Table

[Edward Brown]

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 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 FIL

LOOP WHILE READNEXT ID DO

 READ REC FROM FIL,ID THEN

 LINE = '"' : CHANGE(CHANGE(REC,@AM,'","'),@SVM,',') : '"'

 WRITESEQ LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE'

END

REPEAT

 

 

Facing compilation error

 

:BASIC BP outfile

 

Compiling Unibasic: BP/outfile in mode 'u'.

main program: syntax error at or before

 OPENSEQ 'OUTPUT.CSV' TO CSVFIL

 --^

Expecting: ELSE

 

compilation failed

 

 

 

Thanks & Regards,

Dattatraya Walgude

DBA Team 

Rsystems International Ltd, Pune,

( : +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 Table

 

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 WHILE READNEXT ID DO

 READ REC FROM FIL,ID THEN

 LINE = '"' : CHANGE(CHANGE(REC,@AM,'","'),@SVM,',') : '"'

 WRITESEQ LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE'

END

REPEAT

 

 

 

 

Rgds

Symeon.

 

 

-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 06:14

To: u2-users@listserver.u2ug.org

Subject: [U2] Unibasic: Sample program - to extract data from Table

 

Dear All

 

 

 

I am new in Unidata/Unibasic, I want a sample program to extract data

from one of our big history table.

 

 

 

Kindly give me any link/ suggestion.

 

Thanks & Regards,

Dattatraya Walgude

 

 

 

 

 

 

  Disclaimer *

 

 

 

 

This mail, including any attachments contains confidential and
privileged

information for the sole use of the addressee(s). If you are not the

intended recipient, 

 

please notify the sender by e-mail and delete the original message.  Any

unauthorized review, use, disclosure, dissemination, forwarding,
printing or

copying of

 

 this email or any action taken in reliance on this e-mail is strictly

prohibited and are unlawful. This e-mail may contain viruses. R Systems

International Limited  has 

 

taken every reasonable precaution to minimize this risk.  R Systems

International Limited is not liable for any damage you may sustain as a

result of any virus in this e-mail. 

 

Before opening the e-mail or attachment, You should carry out your own
virus

checks. R Systems International Limited reserves the right to record,

monitor, and inspect

 

 all email communications through its internal and external networks.  R

Systems International Ltd prohibits its information systems from being
used

to view, store or forward 

 

offensive or discriminatory material.

 

 

 

 End of Disclaimer 

 

___

U2-Users mailing list

U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users

 

___

U2-Users mailing list

U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users

 

 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

---
Please remember to recycle wherever possible. 
Reduce, reuse, recycle, think do you need to print this e-mail?
---
This e-mail and any attachment(s), is confidential and may be legally 
privileged. It is intended solely for the addressee. If you are not the 
addressee, dissemination, copying or use of this e-mail or any of its content 
is prohibited and may be unlawful. If you are not the intended 

Re: [U2] Unibasic: Sample program - to extract data from Table

[Dattatraya Walgude]

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 = '"' : CHANGE(CHANGE(REC,@AM,'","'),@SVM,',') : '"'

 WRITESEQ LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE'

END

REPEAT

 

 

Facing compilation error

 

:BASIC BP outfile

 

Compiling Unibasic: BP/outfile in mode 'u'.

main program: syntax error at or before

 OPENSEQ 'OUTPUT.CSV' TO CSVFIL

 --^

Expecting: ELSE

 

compilation failed

 

 

 

Thanks & Regards,

Dattatraya Walgude

DBA Team 

Rsystems International Ltd, Pune,

( : +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 Table

 

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 WHILE READNEXT ID DO

 READ REC FROM FIL,ID THEN

 LINE = '"' : CHANGE(CHANGE(REC,@AM,'","'),@SVM,',') : '"'

 WRITESEQ LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE'

END

REPEAT

 

 

 

 

Rgds

Symeon.

 

 

-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 06:14

To: u2-users@listserver.u2ug.org

Subject: [U2] Unibasic: Sample program - to extract data from Table

 

Dear All

 

 

 

I am new in Unidata/Unibasic, I want a sample program to extract data

from one of our big history table.

 

 

 

Kindly give me any link/ suggestion.

 

Thanks & Regards,

Dattatraya Walgude

 

 

 

 

 

 

  Disclaimer *

 

 

 

 

This mail, including any attachments contains confidential and
privileged

information for the sole use of the addressee(s). If you are not the

intended recipient, 

 

please notify the sender by e-mail and delete the original message.  Any

unauthorized review, use, disclosure, dissemination, forwarding,
printing or

copying of

 

 this email or any action taken in reliance on this e-mail is strictly

prohibited and are unlawful. This e-mail may contain viruses. R Systems

International Limited  has 

 

taken every reasonable precaution to minimize this risk.  R Systems

International Limited is not liable for any damage you may sustain as a

result of any virus in this e-mail. 

 

Before opening the e-mail or attachment, You should carry out your own
virus

checks. R Systems International Limited reserves the right to record,

monitor, and inspect

 

 all email communications through its internal and external networks.  R

Systems International Ltd prohibits its information systems from being
used

to view, store or forward 

 

offensive or discriminatory material.

 

 

 

 End of Disclaimer 

 

___

U2-Users mailing list

U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users

 

___

U2-Users mailing list

U2-Users@listserver.u2ug.org

http://listserver.u2ug.org/mailman/listinfo/u2-users

 

 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample program - to extract data from Table

[Symeon Breen]

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 WHILE READNEXT ID DO
 READ REC FROM FIL,ID THEN
 LINE = '"' : CHANGE(CHANGE(REC,@AM,'","'),@SVM,',') : '"'
 WRITESEQ LINE ON CSVFIL ELSE CRT 'CAN NOT EWRITE TO CSV FILE'
END
REPEAT




Rgds
Symeon.


-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 06:14
To: u2-users@listserver.u2ug.org
Subject: [U2] Unibasic: Sample program - to extract data from Table

Dear All

 

I am new in Unidata/Unibasic, I want a sample program to extract data
from one of our big history table.

 

Kindly give me any link/ suggestion.

Thanks & Regards,
Dattatraya Walgude



 


  Disclaimer *
 

 

This mail, including any attachments contains confidential and privileged
information for the sole use of the addressee(s). If you are not the
intended recipient, 

please notify the sender by e-mail and delete the original message.  Any
unauthorized review, use, disclosure, dissemination, forwarding, printing or
copying of

 this email or any action taken in reliance on this e-mail is strictly
prohibited and are unlawful. This e-mail may contain viruses. R Systems
International Limited  has 

taken every reasonable precaution to minimize this risk.  R Systems
International Limited is not liable for any damage you may sustain as a
result of any virus in this e-mail. 

Before opening the e-mail or attachment, You should carry out your own virus
checks. R Systems International Limited reserves the right to record,
monitor, and inspect

 all email communications through its internal and external networks.  R
Systems International Ltd prohibits its information systems from being used
to view, store or forward 

offensive or discriminatory material.

 

 End of Disclaimer 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Unibasic: Sample program - to extract data from Table

[Ross Ferris]

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 Software
Visage > Better by Design!


>-Original Message-
>From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
>boun...@listserver.u2ug.org] On Behalf Of Dattatraya Walgude
>Sent: Monday, 12 October 2009 4:14 PM
>To: u2-users@listserver.u2ug.org
>Subject: [U2] Unibasic: Sample program - to extract data from Table
>
>Dear All
>
>
>
>I am new in Unidata/Unibasic, I want a sample program to extract data
>from one of our big history table.
>
>
>
>Kindly give me any link/ suggestion.
>
>Thanks & Regards,
>Dattatraya Walgude
>
>
>
>
>
>
>  Disclaimer *
>
>
>
>
>This mail, including any attachments contains confidential and
>privileged information for the sole use of the addressee(s). If you are
>not the intended recipient,
>
>please notify the sender by e-mail and delete the original message.
Any
>unauthorized review, use, disclosure, dissemination, forwarding,
>printing or copying of
>
> this email or any action taken in reliance on this e-mail is strictly
>prohibited and are unlawful. This e-mail may contain viruses. R Systems
>International Limited  has
>
>taken every reasonable precaution to minimize this risk.  R Systems
>International Limited is not liable for any damage you may sustain as a
>result of any virus in this e-mail.
>
>Before opening the e-mail or attachment, You should carry out your own
>virus checks. R Systems International Limited reserves the right to
>record, monitor, and inspect
>
> all email communications through its internal and external networks.
R
>Systems International Ltd prohibits its information systems from being
>used to view, store or forward
>
>offensive or discriminatory material.
>
>
>
> End of Disclaimer 
>
>___
>U2-Users mailing list
>U2-Users@listserver.u2ug.org
>http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users