Re: [U2] svn with U2

2010-03-24 Thread Boydell, Stuart
Gidday & Thanks - I'd appreciate that.
Maybe it could go up on the U2UG site.
S 


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Leroy Dreyfuss
Sent: Thursday, 25 March 2010 10:30
To: U2 Users List
Cc: U2 Users List
Subject: Re: [U2] svn with U2

Hi Stuart,

Long time no speak. I will put something together on how they are used
for you.

Cheers,

LeRoy

Sent from my iPhone 3Gs

On 25 Mar 2010, at 12:23 AM, "Boydell, Stuart"  wrote:

> Hi Leroy,
> Just had a quick look. I didn't even know those commands existed (or
> maybe I did and forgot). Loadfile sounds interesting.
> Just parsing UVread...
>
> $UVread
> usage: UVread [-q] [-f] [-s] file item ...
>
> $UVread -q VOC WHO
> 'V'
> 'WHO'
> 'I'
> 'G'
>
> $UVread -f /pathToOtherAccount/VOC WHO
> WHO V
>WHO
>I
>G
>
> $UVread -s VOC WHO
>
> I get the -f (formatted?) & -q (quoted?) options -s ? Is there any
> documentation on these OS calls anywhere? Could someone provide it?
> Pick Pocket Guide update maybe ;)
>
> Cheers,
> Stuart Boydell
>
> -Original Message-
> You can accomplish a complete solution using the tools UV comes
> with, i.e. the tools that are used to install & configure it, such
> as loadfile, UVread, UVwrite and so forth. Just determine how the .u
> files are structure, but take note that they are harder to user if
> you need to format one with records that are sub-valued. UV doesn't
> come with an example of how to do it.
>
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users

To read FRSTIA's disclaimer for the e-mail go to http://www.frstia.co.za/
___
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] Writeseq - getting to the EOF

2010-03-24 Thread Don Robinson
George,

Have you tried the SEEK statement, ie,
SEEK filehandle, 0 , 2

The 0 (zero) is the offset and the 2 is "relative to the end of the file".

Caution, untested code!
 
Good luck,
Don Robinson






From: George Gallen 
To: U2 Users List 
Sent: Wed, March 24, 2010 5:25:31 PM
Subject: [U2] Writeseq - getting to the EOF

ok. UV 10.0.2

Is there a quick way to get to the end of a file to start appending after an 
OPENSEQ
Otherthan, a loop to READSEQ until it hits the EOF.

Right now, that is not a problem, but this file could grow to some considerable 
size, and
  that loop might take a little bit to cycle through.

I didn't see any options for the OPENSEQ to start at the EOF, and didn't find 
any commands
  that would set the eof (other than WEOFSEQ which doesn't seem likely to help).

Thanks


George Gallen
Senior Programmer/Analyst
Accounting/Data Division, EDI Administrator
ggal...@wyanokegroup.com
ph:856.848.9005 Ext 220
The Wyanoke Group
http://www.wyanokegroup.com



___
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] svn with U2

2010-03-24 Thread Leroy Dreyfuss
Hi Stuart,

Long time no speak. I will put something together on how they are used
for you.

Cheers,

LeRoy

Sent from my iPhone 3Gs

On 25 Mar 2010, at 12:23 AM, "Boydell, Stuart"  wrote:

> Hi Leroy,
> Just had a quick look. I didn't even know those commands existed (or
> maybe I did and forgot). Loadfile sounds interesting.
> Just parsing UVread...
>
> $UVread
> usage: UVread [-q] [-f] [-s] file item ...
>
> $UVread -q VOC WHO
> 'V'
> 'WHO'
> 'I'
> 'G'
>
> $UVread -f /pathToOtherAccount/VOC WHO
> WHO V
>WHO
>I
>G
>
> $UVread -s VOC WHO
>
> I get the -f (formatted?) & -q (quoted?) options -s ? Is there any
> documentation on these OS calls anywhere? Could someone provide it?
> Pick Pocket Guide update maybe ;)
>
> Cheers,
> Stuart Boydell
>
> -Original Message-
> You can accomplish a complete solution using the tools UV comes
> with, i.e. the tools that are used to install & configure it, such
> as loadfile, UVread, UVwrite and so forth. Just determine how the .u
> files are structure, but take note that they are harder to user if
> you need to format one with records that are sub-valued. UV doesn't
> come with an example of how to do it.
>
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users

To read FRSTIA's disclaimer for the e-mail go to http://www.frstia.co.za/
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] JDBC - con.close - Victory

2010-03-24 Thread Brutzman, Bill
Jeff:

It works... and answers a few of the minor mysteries.  Thanks for
following-up.

Much obliged.

--Bill

 import java.sql.Connection;
 import java.sql.DriverManager;
 import java.sql.ResultSet;
 import java.sql.SQLException;
 import java.sql.Statement;

 public class JDBC_1003 {

  public static void main(String[] args) {
  
  Connection con = null;

  try {

  try {
Class.forName("com.ibm.u2.jdbc.UniJDBCDriver");
  }
  catch(Exception x){
System.out.println( "Here " + x );
  }
String url =
"jdbc:ibm-u2://192.168.0.102/SHIPPING";
String  userid =
"ups";
String passWord  =
"brown";

  con = DriverManager.getConnection(url, userid, passWord);

  Statement stmt = con.createStatement();

   String sql = "select @ID, NAME, CITY,
STATE from PACKSLIPS.X";
  ResultSet rs = stmt.executeQuery(sql);

  int i = 1;
  while (rs.next()&&  i<  6)
  {
  System.out.println("\nRecord "+ i +" :");
  System.out.println("\...@id : \t" + rs.getString(1));
  System.out.println("\tNAME :\t" + rs.getString(2));
  System.out.println("\tCITY :\t" + rs.getString(3));
  System.out.println("\tSTATE :\t" + rs.getString(4));
  i++;
  }

  rs.close();
  stmt.close() ;
  System.out.println("\n\t*--- QUERY test is done
successful ---*\n");

  }
  catch (SQLException e ) {
  System.out.println(e);
  }
  finally{
try{

   if(con != null)
  con.close();
  }
catch(Exception ignored){}
  }
  }
 }
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Powell
Sent: Wednesday, March 24, 2010 6:49 PM
To: U2 Users List
Subject: Re: [U2] JDBC - Finally - Hitch

This text was supposed to be strikethrough to indicate that it needs to
be removed since it's declared outside the outer try scope.


On 03/24/2010 05:40 PM, Jeff Powell wrote:
> *Connection*  con = DriverManager ...
Should read
>   con = DriverManager ...

___
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] JDBC - Finally - Hitch

2010-03-24 Thread Jeff Powell
This text was supposed to be strikethrough to indicate that it needs to 
be removed since it's declared outside the outer try scope.



On 03/24/2010 05:40 PM, Jeff Powell wrote:

*Connection*  con = DriverManager ...

Should read

  con = DriverManager ...


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


Re: [U2] JDBC - Finally - Hitch

2010-03-24 Thread Jeff Powell

Bill,

You're trying to reference the connection out of it's scope.

Try moving the declaration like the example below.


On 03/24/2010 10:49 AM, Brutzman, Bill wrote:

Ben:

1. I am glad to find out about the "finally" command.  I was not aware
of this feature in Java.
2. The new code below yields an IDE error...  con cannot be resolved
3. Connection con was already defined... it gives an error when I do a
con = null;
4. IDE does not accept  con.close;
5. While I am happy to look into this and figure it out... right now I
do not know the fix.

Regards,

--Bill

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class JDBC_1001 {

 public static void main(String[] args) {
 


Connection con=null;


 try {

 try {
Class.forName("com.ibm.u2.jdbc.UniJDBCDriver");
 }
 catch(Exception x){
System.out.println( "Here " + x );
 }
   String url
= "jdbc:ibm-u2://192.168.0.102/SHIPPING";
   String  userid
= "ups";
   String
passWord  = "brown";

 *Connection*  con = DriverManager.getConnection(url, userid,
passWord);

 Statement stmt = con.createStatement();

   String sql = "select @ID, NAME,
CITY, STATE from PACKSLIPS.X";
 ResultSet rs = stmt.executeQuery(sql);

 int i = 1;
 while (rs.next()&&  i<  6)
 {
 System.out.println("\nRecord "+ i +" :");
 System.out.println("\...@id : \t" + rs.getString(1));
 System.out.println("\tNAME :\t" + rs.getString(2));
 System.out.println("\tCITY :\t" + rs.getString(3));
 System.out.println("\tSTATE :\t" + rs.getString(4));
 i++;
 }

 rs.close();
 stmt.close() ;
 System.out.println("\n\t*--- QUERY test is done successful
---*\n");

 }
 catch (SQLException e ) {
 System.out.println(e);
 }
 finally{
try{
   

*   if(con != null)*
 con.close();

 }
catch(Exception ignored){}
 }
 }

}

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ben Souther
Sent: Tuesday, March 23, 2010 5:34 PM
To: U2 Users List
Subject: Re: [U2] JDBC - ClassPath - Victory

Glad it's working.

Tip:  You should always put the con.close() statement in a finally
block.
The close method itself can throw an exception so it needs to be in a
nested try/catch.

Putting in in a finally block insures that come Hello or high water the
connection gets closed.
One of the most common causes for memory leaks in JDBC applications is
the build up of unclosed database connections.


Connection con = null;
try{
// establish connection and do stuff
}catch(Exception e){
// deal with any problems
}finally{
try{
con.close();
 }catch(Exception ignored){}
}







On Mar 23, 2010, at 3:33 PM, Brutzman, Bill wrote:

   

The following code works ok...

Thanks to all those who responded especially John, Jeff, Bruce,
Charles, Ben, and Mike.

--Bill

import java.sql.*;

public class Uni_101 {

public static void main(String[] args) {
try {

try {
Class.forName("com.ibm.u2.jdbc.UniJDBCDriver");
}
catch(Exception x){
System.out.println( "Here " + x );
}
  String url =
"jdbc:ibm-u2://192.168.0.102/SHIPPING";
  String  userid
= "ups";
  String passWord  =
"brown";

Connection con = DriverManager.getConnection(url, userid,
passWord);

Statement stmt = con.createStatement();

  String sql = "select @ID, NAME,
CITY, STATE from PACKSLIPS.X";
ResultSet rs = stmt.executeQuery(sql);

int i = 1;
while (rs.next()&&  i<  6)
{
System.out.println("\nRecord "+ i +" :");
System.out.println("\...@id : \t" + rs.getString(1));
System.out.println("\tNAME :\t" + rs.getString(2));
System.out.println("\tCITY :\t" + rs.getString(3));
System.out.println("\tSTATE :\t" + rs.getString(4));
i++;
}

rs.close();
stmt.close() ;
System.out.println("\n\t*--- QUERY test is done successful
---*\n");

}
catch (SQLException e ) {
  

Re: [U2] svn with U2

2010-03-24 Thread Boydell, Stuart
Hi Leroy,
Just had a quick look. I didn't even know those commands existed (or maybe I 
did and forgot). Loadfile sounds interesting.
Just parsing UVread...

$UVread
usage: UVread [-q] [-f] [-s] file item ...

$UVread -q VOC WHO
'V'
'WHO'
'I'
'G'

$UVread -f /pathToOtherAccount/VOC WHO
WHO V
WHO
I
G

$UVread -s VOC WHO

I get the -f (formatted?) & -q (quoted?) options -s ? Is there any 
documentation on these OS calls anywhere? Could someone provide it? Pick Pocket 
Guide update maybe ;)

Cheers,
Stuart Boydell

-Original Message-
You can accomplish a complete solution using the tools UV comes with, i.e. the 
tools that are used to install & configure it, such as loadfile, UVread, 
UVwrite and so forth. Just determine how the .u files are structure, but take 
note that they are harder to user if you need to format one with records that 
are sub-valued. UV doesn't come with an example of how to do it.


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


Re: [U2] Trouble sending reply emails

2010-03-24 Thread Bill Haskett

Do you use Thunderbird?

Bill


Dianne Ackerman said the following on 3/24/2010 12:30 PM:
Does anyone have any idea why I would be getting the following error 
message bounced to me when I reply to a message on the list?  To send 
a message to the list, I have to initiate the message, I can't seem to 
reply.  Thanks.

-Dianne


The message's content type was not explicitly allowed



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


Re: [U2] Writeseq - getting to the EOF

2010-03-24 Thread David A. Green
How about WRITESEQ DATA APPEND ON S.FILE...

David A. Green
(480) 813-1725
DAG Consulting


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Wednesday, March 24, 2010 2:26 PM
To: U2 Users List
Subject: [U2] Writeseq - getting to the EOF

ok. UV 10.0.2

Is there a quick way to get to the end of a file to start appending after an
OPENSEQ
Otherthan, a loop to READSEQ until it hits the EOF.

Right now, that is not a problem, but this file could grow to some
considerable size, and
  that loop might take a little bit to cycle through.

I didn't see any options for the OPENSEQ to start at the EOF, and didn't
find any commands
   that would set the eof (other than WEOFSEQ which doesn't seem likely to
help).

Thanks


George Gallen
Senior Programmer/Analyst
Accounting/Data Division, EDI Administrator
ggal...@wyanokegroup.com
ph:856.848.9005 Ext 220
The Wyanoke Group
http://www.wyanokegroup.com



___
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] Writeseq - getting to the EOF

2010-03-24 Thread George Gallen
thanksworked.

SEEK filehandle,0,2

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of David Ward
> Sent: Wednesday, March 24, 2010 5:30 PM
> To: 'U2 Users List'
> Subject: Re: [U2] Writeseq - getting to the EOF
> 
> Try "SEEK"
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George
> Gallen
> Sent: Wednesday, March 24, 2010 4:26 PM
> To: U2 Users List
> Subject: [U2] Writeseq - getting to the EOF
> 
> 
> ok. UV 10.0.2
> 
> Is there a quick way to get to the end of a file to start appending
> after an
> OPENSEQ Otherthan, a loop to READSEQ until it hits the EOF.
> 
> Right now, that is not a problem, but this file could grow to some
> considerable size, and
>   that loop might take a little bit to cycle through.
> 
> I didn't see any options for the OPENSEQ to start at the EOF, and
> didn't
> find any commands
>that would set the eof (other than WEOFSEQ which doesn't seem likely
> to
> help).
> 
> Thanks
> 
> 
> George Gallen
> Senior Programmer/Analyst
> Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com
> ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com
> 
> 
> 
> ___
> 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] Writeseq - getting to the EOF

2010-03-24 Thread David Ward
Try "SEEK"

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Wednesday, March 24, 2010 4:26 PM
To: U2 Users List
Subject: [U2] Writeseq - getting to the EOF


ok. UV 10.0.2

Is there a quick way to get to the end of a file to start appending after an
OPENSEQ Otherthan, a loop to READSEQ until it hits the EOF.

Right now, that is not a problem, but this file could grow to some
considerable size, and
  that loop might take a little bit to cycle through.

I didn't see any options for the OPENSEQ to start at the EOF, and didn't
find any commands
   that would set the eof (other than WEOFSEQ which doesn't seem likely to
help).

Thanks


George Gallen
Senior Programmer/Analyst
Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com
ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com



___
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] Writeseq - getting to the EOF

2010-03-24 Thread George Gallen
ok. UV 10.0.2

Is there a quick way to get to the end of a file to start appending after an 
OPENSEQ
Otherthan, a loop to READSEQ until it hits the EOF.

Right now, that is not a problem, but this file could grow to some considerable 
size, and
  that loop might take a little bit to cycle through.

I didn't see any options for the OPENSEQ to start at the EOF, and didn't find 
any commands
   that would set the eof (other than WEOFSEQ which doesn't seem likely to 
help).

Thanks


George Gallen
Senior Programmer/Analyst
Accounting/Data Division, EDI Administrator
ggal...@wyanokegroup.com
ph:856.848.9005 Ext 220
The Wyanoke Group
http://www.wyanokegroup.com



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


Re: [U2] svn with U2

2010-03-24 Thread Leroy Dreyfuss
You can accomplish a complete solution using the tools UV comes with, i.e. the 
tools that are used to install & configure it, such as loadfile, UVread, 
UVwrite and so forth. Just determine how the .u files are structure, but take 
note that they are harder to user if you need to format one with records that 
are sub-valued. UV doesn't come with an example of how to do it.

Wally Terhune may have some ideas about UniData.

From: u2-users-boun...@listserver.u2ug.org 
[u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen 
[syme...@gmail.com]
Sent: Wednesday, March 24, 2010 9:59 PM
To: 'U2 Users List'
Subject: Re: [U2] svn with U2

Only if they are held in type 1 files



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow
Sent: 24 March 2010 19:07
To: u2-users@listserver.u2ug.org
Subject: [U2] svn with U2

Hi Symeon,

Have you a way of versioning SB+ objects and dict items?  I would really
like to devise a way to version reports, screens and FD's.

TIA,

Steve
___
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

To read FRSTIA's disclaimer for the e-mail go to http://www.frstia.co.za/
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] Cold Fusion Connection - Victory

2010-03-24 Thread Brutzman, Bill
I am pleased to report I was able to connect ok from Adobe ColdFusion 9
(running on our Windows Server) to UniVerse 10.1 running on HP-Ux.

A bunch of people on the Adobe forum reported similar trouble.  The
recent U2-JDBC posts on this list were key to solving this problem.  I
expect that when the other Adobe forum users apply this new result, they
will be especially appreciative. 

Thanks again to those who responded to this JDBC thing.

--Bill


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


Re: [U2] Trouble sending reply emails

2010-03-24 Thread Karl Pearson
Try sending in plain text?


On Wed, March 24, 2010 1:30 pm, Dianne Ackerman wrote:
> Does anyone have any idea why I would be getting the following error
> message bounced to me when I reply to a message on the list?  To send a
> message to the list, I have to initiate the message, I can't seem to
> reply.  Thanks.
> -Dianne
>
>> The message's content type was not explicitly allowed
>
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>


---
Karl Pearson
ka...@ourldsfamily.com
Owner/Administrator of the sites at
http://ourldsfamily.com
---
"To mess up your Linux PC, you have to really work at it;
 to mess up a microsoft PC you just have to work on it."
---
 Democracy is two wolves and a lamb voting on what to have
 for lunch. Liberty is a well-armed lamb contesting the vote.
 --Benjamin Franklin
---
 Children seldom misquote you. In fact, they usually
 repeat word for word what you shouldn't have said.
---

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


Re: [U2] svn with U2

2010-03-24 Thread Symeon Breen
Only if they are held in type 1 files



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow
Sent: 24 March 2010 19:07
To: u2-users@listserver.u2ug.org
Subject: [U2] svn with U2

Hi Symeon,

Have you a way of versioning SB+ objects and dict items?  I would really 
like to devise a way to version reports, screens and FD's.

TIA,

Steve
___
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] Pick Pocket Guide

2010-03-24 Thread Jeff Schasny
Because its not SQL. To many big differences between the purpose, 
theory, and operation of the two


fft2...@aol.com wrote:

I'd like to also suggest nSQL and mvSQL
Why not say SQL ?  And then add n for nested or mv for  multi-value
And we can just say "this is our BRAND of SQL" it's SQL with added  
features.
 
 
 
In a message dated 3/24/2010 7:30:47 A.M. Pacific Daylight Time,  
ron_hutchi...@hotmail.com writes:



As  much as we can't seem to get away from referring to TCL, how about 
MVTCL or  mvTCL!


  

Date: Wed, 24 Mar 2010 03:16:06 -0400
From:  jcan...@optonline.net
To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] Pick Pocket Guide

My bad on the mid-cap  drop; sorry.

For TCL/ECL, maybe mvCommand or  mvControl?

I didn't say it will be easy or even worthwhile  for the experts; but, I
think it must help in some way to be known as  the gurus in this market
(better billable rates, makes you more  desirable as a consultant, etc.). 


 If
  
there are five authors (for  five platforms) and they each write 20% of 


the
  

book and that book has  the potential of selling 5 times more (for five
platforms instead of  one), essentially, you are producing a book for 1/5 


of
  

the cost.   I know we can really work these numbers so in the end it will
cost  nothing to write [like the days we work in a year].  I know it's  


still
  

a tough sell, but, maybe even include some ad-supported areas  within the
book (as long as it doesn't compromise objectivity  concerning the
platforms).  I think the major platform vendors  should also contribute to
get this done as it directly benefits them  the most.

Recently, I have moved away from the MultiValue  market [not by choice].  


I
  

must say that I'd have a difficult  time in getting any 'buy-in' though on
what I still consider an  incredibly powerful database due to almost a
complete lack of  visibility.  How do you promote a technology that hasn't
had a  book based on it in quite a long time?  If the platform vendors,  


tool
  
and integration companies, etc. still believe that they have a  good 


story to
  

tell, it's time to ante up and place your bets  already.

Regards,

Jim

  



-Original Message-
From:  u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Clifton  


Oliver
  

Sent: Wednesday, March 24, 2010 1:19 AM
To: U2 Users  List
Subject: Re: [U2] Pick Pocket Guide

Well, the  terminology issue is something we (Spectrum magazine in
particular)  can promote since we are already committed to promoting the 


term
  
 MultiValue (note the mid-cap casing) and the MultiValue Logo. We just  


add
  

such terms to our Style and Usage Guide and use them in the  magazine.

Side note: Is there any interest in us having our  Style and Usage Guide
available online?


 
I'm interested in hearing what folks would find an acceptable term  for

TCL/ECL/etc.

As to the idea of of a generic book,  groups of experts, etc., that sounds
like a fame and glory no profit  Open Source kind of thing. A lot of the
experts you might want to  attract are dudes and dudettes trying to make a
living. That goes back  to some of Tony's comments. How could that be made
worthwhile for said  experts to forgo revenue producing time to produce a
non-profit  book?

Considering some other Open Source documentation  efforts, I'm not saying 


it
  
can't be done. I'm just challenging  everyone to present detailed ideas 


for
  

how it could be made to  work.


Regards,

Clif
 



On Mar 23, 2010, at 6:09 PM, James Canale, Jr.  wrote:



I think it would be great do something like  this.

Multivalue Query [mvQuery]
 Multivalue Basic [mvBasic]
Multivalue PROC  [mvPROC]
  
 > 


I also think it would be great if someone could write a  piece of a book
  

that


is very generic (keep it at a 20,000  foot view) which covers each major
topic area.  Once  complete, a group of experts-at-large in the various
flavors add  platform specific details.  When complete, one or more of 
  

the
  

 > know-it-alls [like some of the gurus on this list] combine the  common
parts,


while leaving the unique areas in  place.  Basically, a wiki to book
transformation.  Many  of the books sold today have two, three, and even
  

more

 authors (especially the technically oriented books).  Something like  
  

this
  

could reduce the work required (just doing a piece of the  whole) and
increase the potential market (supports most  platforms) for sales.  I 
  

see
  

a

lot of talent on this  list that can pull something like this off, it 
  

just
  

needs a great  leader (and I see many of them here too).

 Regards,

Jim


  
 > 


-Original Message-
From:  u2-users-boun...@listserver.u2ug.org
 [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Clifton  
  

Oliver
  

Sent: Tuesday, March 23, 2010 6:39 PM

Re: [U2] Pick Pocket Guide

2010-03-24 Thread Jeff Schasny
Brilliant! I have had a terrible time explaining to users why the term 
"TCL" exists, at least since the last time I was using an ADDS Viewpoint 
as my I/O device.


Dan McGrath wrote:

Hi Clif,

I'd be interesting in reading. I write the occasional piece and probably
should use more encompassing terms to enhance future search-ability and
to promote the database style.

Regarding ECL/TCL/etc, since I'm normally in Unix/Linux land, I normally
think of them as shells, which brings MultiValue Shell (MVSH) to mind.
  


--

Jeff Schasny - Denver, Co, USA
jschasny at gmail dot com

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


Re: [U2] Pick Pocket Guide

2010-03-24 Thread Baker Hughes
At the risk of stating the obvious, I think the following is the best 
'centrist' approach for the common query commands:

MVQL - Multi Value Query Language.

As for the database resource - it's almost a non-issue any more who the 
provider is since most have 'flavors' that mimic the major variants.  This 
generic primer would be the documentation that most interests the potential 
reader. System internals would come later and that would be something that we 
all obtain from the vendor.

Free code is an excellent way to get others to embrace MV. We frequently 
borough code from PHP or other code sharing sites and cobble it into our basic 
routine if we're doing something new.  If we could get more of this going, and 
offer the 'pocket guides' there, we'd garner more respect and affection.  I 
know we have a couple wiki's out there - lets improve these and get a generic 
MV code foundry up.

I must express my debt of gratitude to Jon also. He graciously allowed me to 
republish parts of his work when I taught a Programmers class for clients of 
Pick Professionals in St Louis.

Fascinating thread.  I've only read thru 1/2 of it so forgive me if any of my 
suggestions are redundant.

-Baker


This communication, its contents and any file attachments transmitted with it 
are intended solely for the addressee(s) and may contain confidential 
proprietary information.
Access by any other party without the express written permission of the sender 
is STRICTLY PROHIBITED.
If you have received this communication in error you may not copy, distribute 
or use the contents, attachments or information in any way.  Please destroy it 
and contact the sender.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] U2 on Windows wierdness

2010-03-24 Thread Ivan Micklin
That is correct.  It worked fine for me.  Since it only worked for the
current session, I had it in a paragraph with a couple of settings for my
use.  I ran the paragraph as soon as I logged in.

Ivan


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Wednesday, March 24, 2010 3:21 PM
To: U2 Users List
Subject: Re: [U2] U2 on Windows wierdness

Just to make sure.this would only affect my login?
Wouldn't want the rest of the folks on the system think their caps locks key
is broken :O

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Ivan Micklin
> Sent: Wednesday, March 24, 2010 3:19 PM
> To: 'U2 Users List'
> Subject: Re: [U2] U2 on Windows wierdness
> 
> Try PTERM CASE NOINVERT
> 
> Ivan
> 
> 
___
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] Trouble sending reply emails

2010-03-24 Thread Dianne Ackerman
Does anyone have any idea why I would be getting the following error 
message bounced to me when I reply to a message on the list?  To send a 
message to the list, I have to initiate the message, I can't seem to 
reply.  Thanks.

-Dianne


The message's content type was not explicitly allowed


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


Re: [U2] U2 on Windows wierdness

2010-03-24 Thread George Gallen
Just to make sure.this would only affect my login?
Wouldn't want the rest of the folks on the system think their caps locks key is 
broken :O

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Ivan Micklin
> Sent: Wednesday, March 24, 2010 3:19 PM
> To: 'U2 Users List'
> Subject: Re: [U2] U2 on Windows wierdness
> 
> Try PTERM CASE NOINVERT
> 
> Ivan
> 
> 
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] U2 on Windows wierdness

2010-03-24 Thread Ivan Micklin
Try PTERM CASE NOINVERT

Ivan


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Wednesday, March 24, 2010 3:00 PM
To: U2 Users List
Subject: Re: [U2] U2 on Windows wierdness

HMMM. Maybe you have somethingI just HELPd on PTERM.
I'll have to check into that next time I'm on that machineThanks

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman
> Sent: Wednesday, March 24, 2010 2:55 PM
> To: U2 Users List
> Subject: Re: [U2] U2 on Windows wierdness
> 
> I've had very similar weird things happen with uv on windows.  Possibly
> stemming from the PTERM CASE setting?
> -Dianne
> 
___
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] svn with U2

2010-03-24 Thread Leroy Dreyfuss
Outside of using PRC, you will have to script things. You can use executables 
like UVread loadfile, UVwrite, etc. Take a look in the sample director under 
the uv directory to get the format of the .u files you will need to build.


Regards,

LeRoy

From: u2-users-boun...@listserver.u2ug.org 
[u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow 
[slestak...@gmail.com]
Sent: Wednesday, March 24, 2010 9:07 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] svn with U2

Hi Symeon,

Have you a way of versioning SB+ objects and dict items?  I would really
like to devise a way to version reports, screens and FD's.

TIA,

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

To read FRSTIA's disclaimer for the e-mail go to http://www.frstia.co.za/
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Pick Pocket Guide

2010-03-24 Thread FFT2001
I'd like to also suggest nSQL and mvSQL
Why not say SQL ?  And then add n for nested or mv for  multi-value
And we can just say "this is our BRAND of SQL" it's SQL with added  
features.
 
 
 
In a message dated 3/24/2010 7:30:47 A.M. Pacific Daylight Time,  
ron_hutchi...@hotmail.com writes:


As  much as we can't seem to get away from referring to TCL, how about 
MVTCL or  mvTCL!

> Date: Wed, 24 Mar 2010 03:16:06 -0400
> From:  jcan...@optonline.net
> To: u2-users@listserver.u2ug.org
>  Subject: Re: [U2] Pick Pocket Guide
> 
> My bad on the mid-cap  drop; sorry.
> 
> For TCL/ECL, maybe mvCommand or  mvControl?
> 
> I didn't say it will be easy or even worthwhile  for the experts; but, I
> think it must help in some way to be known as  the gurus in this market
> (better billable rates, makes you more  desirable as a consultant, etc.). 
 If
> there are five authors (for  five platforms) and they each write 20% of 
the
> book and that book has  the potential of selling 5 times more (for five
> platforms instead of  one), essentially, you are producing a book for 1/5 
of
> the cost.   I know we can really work these numbers so in the end it will
> cost  nothing to write [like the days we work in a year].  I know it's  
still
> a tough sell, but, maybe even include some ad-supported areas  within the
> book (as long as it doesn't compromise objectivity  concerning the
> platforms).  I think the major platform vendors  should also contribute to
> get this done as it directly benefits them  the most.
> 
> Recently, I have moved away from the MultiValue  market [not by choice].  
I
> must say that I'd have a difficult  time in getting any 'buy-in' though on
> what I still consider an  incredibly powerful database due to almost a
> complete lack of  visibility.  How do you promote a technology that hasn't
> had a  book based on it in quite a long time?  If the platform vendors,  
tool
> and integration companies, etc. still believe that they have a  good 
story to
> tell, it's time to ante up and place your bets  already.
> 
> Regards,
> 
> Jim
> 
>   
> 
> 
> -Original Message-
> From:  u2-users-boun...@listserver.u2ug.org
>  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Clifton  
Oliver
> Sent: Wednesday, March 24, 2010 1:19 AM
> To: U2 Users  List
> Subject: Re: [U2] Pick Pocket Guide
> 
> Well, the  terminology issue is something we (Spectrum magazine in
> particular)  can promote since we are already committed to promoting the 
term
>  MultiValue (note the mid-cap casing) and the MultiValue Logo. We just  
add
> such terms to our Style and Usage Guide and use them in the  magazine.
> 
> Side note: Is there any interest in us having our  Style and Usage Guide
> available online?
> 
> 
>  
> I'm interested in hearing what folks would find an acceptable term  for
> TCL/ECL/etc.
> 
> As to the idea of of a generic book,  groups of experts, etc., that sounds
> like a fame and glory no profit  Open Source kind of thing. A lot of the
> experts you might want to  attract are dudes and dudettes trying to make a
> living. That goes back  to some of Tony's comments. How could that be made
> worthwhile for said  experts to forgo revenue producing time to produce a
> non-profit  book?
> 
> Considering some other Open Source documentation  efforts, I'm not saying 
it
> can't be done. I'm just challenging  everyone to present detailed ideas 
for
> how it could be made to  work.
> 
> 
> Regards,
> 
> Clif
>  
> 
> 
> On Mar 23, 2010, at 6:09 PM, James Canale, Jr.  wrote:
> 
> > I think it would be great do something like  this.
> > 
> > Multivalue Query [mvQuery]
> >  Multivalue Basic [mvBasic]
> > Multivalue PROC  [mvPROC]
>  > 
> > I also think it would be great if someone could write a  piece of a book
> that
> > is very generic (keep it at a 20,000  foot view) which covers each major
> > topic area.  Once  complete, a group of experts-at-large in the various
> > flavors add  platform specific details.  When complete, one or more of 
the
>  > know-it-alls [like some of the gurus on this list] combine the  common
> parts,
> > while leaving the unique areas in  place.  Basically, a wiki to book
> > transformation.  Many  of the books sold today have two, three, and even
> more
> >  authors (especially the technically oriented books).  Something like  
this
> > could reduce the work required (just doing a piece of the  whole) and
> > increase the potential market (supports most  platforms) for sales.  I 
see
> a
> > lot of talent on this  list that can pull something like this off, it 
just
> > needs a great  leader (and I see many of them here too).
> > 
> >  Regards,
> > 
> > Jim
> > 
> > 
>  > 
> > -Original Message-
> > From:  u2-users-boun...@listserver.u2ug.org
> >  [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Clifton  
Oliver
> > Sent: Tuesday, March 23, 2010 6:39 PM
> > To: U2  Users List
> > Subject: Re: [U2] Pick Pocket Guide
> >  
> > In Spectrum magazine, we use the te

[U2] svn with U2

2010-03-24 Thread Steve Romanow

Hi Symeon,

Have you a way of versioning SB+ objects and dict items?  I would really 
like to devise a way to version reports, screens and FD's.


TIA,

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


Re: [U2] U2 on Windows wierdness

2010-03-24 Thread George Gallen
HMMM. Maybe you have somethingI just HELPd on PTERM.
I'll have to check into that next time I'm on that machineThanks

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman
> Sent: Wednesday, March 24, 2010 2:55 PM
> To: U2 Users List
> Subject: Re: [U2] U2 on Windows wierdness
> 
> I've had very similar weird things happen with uv on windows.  Possibly
> stemming from the PTERM CASE setting?
> -Dianne
> 
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] U2 on Windows wierdness

2010-03-24 Thread George Gallen
Why would that matter (not saying it doesn't)? I'm not typeing the file in UV, 
I'm copying it into a File
  UV has access to.

George

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman
> Sent: Wednesday, March 24, 2010 2:55 PM
> To: U2 Users List
> Subject: Re: [U2] U2 on Windows wierdness
> 
> I've had very similar weird things happen with uv on windows.  Possibly
> stemming from the PTERM CASE setting?
> -Dianne
> 
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] U2 on Windows wierdness

2010-03-24 Thread Dianne Ackerman
I've had very similar weird things happen with uv on windows.  Possibly 
stemming from the PTERM CASE setting?

-Dianne

George Gallen wrote:

OK. Here's a strange one.

If I type up a program in the text editor, and save it.
Then I copy that file to windows folder, which Universe has access to

If I then copy that file from this folder to SOURCE (from within Universe), 
it's all in lower case

What's the deal? How can fix this.

UV is in Reality mode, on a Windows platform.


George Gallen
Senior Programmer/Analyst
Accounting/Data Division, EDI Administrator
ggal...@wyanokegroup.com
ph:856.848.9005 Ext 220
The Wyanoke Group
http://www.wyanokegroup.com



___
  


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


Re: [U2] JDBC - BrainTeaser

2010-03-24 Thread Brutzman, Bill
Thanks to Ben and Ross but...

Of course the Class.forName connection string has to be invoked first.
My brain hurts.

--Bill

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ben Souther
Sent: Wednesday, March 24, 2010 1:24 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] JDBC - Finally - Hitch

In Java, variables are local to the block in which they were declared.

So, in order to reach your 'con' variable from outside the 'try' block
it needs to be declared outside of that block.


Connection con = null;  // declare con outside of try block.
try{
con = DriverManager...
// do stuff with the connection
}catch(Exception e){
// handle any exceptions
}finally{
try{
   con.close(); 
}catch(Exception ignored){
}
}










On Wed, 2010-03-24 at 11:49 -0400, Brutzman, Bill wrote:
> Ben:
> 
> 1. I am glad to find out about the "finally" command.  I was not aware

> of this feature in Java.
> 2. The new code below yields an IDE error...  con cannot be resolved 
> 3. Connection con was already defined... it gives an error when I do a

> con = null; 4. IDE does not accept  con.close; 5. While I am happy to 
> look into this and figure it out... right now I do not know the fix.
> 
> Regards,
> 
> --Bill
> 
> import java.sql.Connection;
> import java.sql.DriverManager;
> import java.sql.ResultSet;
> import java.sql.SQLException;
> import java.sql.Statement;
> 
> public class JDBC_1001 {
> 
> public static void main(String[] args) {
> try {
> 
> try {
>   Class.forName("com.ibm.u2.jdbc.UniJDBCDriver"); 
> }
> catch(Exception x){
>   System.out.println( "Here " + x );
> } 
>   String url = 
> "jdbc:ibm-u2://192.168.0.102/SHIPPING";
>   String  userid
> = "ups";
>   String passWord  = 
> "brown";
> 
> Connection con = DriverManager.getConnection(url, userid, 
> passWord);
>  
> Statement stmt = con.createStatement();
> 
>   String sql = "select @ID, NAME, 
> CITY, STATE from PACKSLIPS.X";
> ResultSet rs = stmt.executeQuery(sql);
> 
> int i = 1;
> while (rs.next() && i < 6)
> {
> System.out.println("\nRecord "+ i +" :");
> System.out.println("\...@id : \t" + rs.getString(1));
> System.out.println("\tNAME :\t" + rs.getString(2));
> System.out.println("\tCITY :\t" + rs.getString(3));
> System.out.println("\tSTATE :\t" + rs.getString(4));
> i++;
> }
> 
> rs.close();
> stmt.close() ;
> System.out.println("\n\t*--- QUERY test is done successful
> ---*\n");
> 
> }
> catch (SQLException e ) {
> System.out.println(e);
> }
> finally{
>   try{
>   con.close();
> }
>   catch(Exception ignored){}
> }
> }
> 
> }
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ben Souther
> Sent: Tuesday, March 23, 2010 5:34 PM
> To: U2 Users List
> Subject: Re: [U2] JDBC - ClassPath - Victory
> 
> Glad it's working.
> 
> Tip:  You should always put the con.close() statement in a finally 
> block.
> The close method itself can throw an exception so it needs to be in a 
> nested try/catch.
> 
> Putting in in a finally block insures that come Hello or high water 
> the connection gets closed.
> One of the most common causes for memory leaks in JDBC applications is

> the build up of unclosed database connections.
> 
> 
> Connection con = null;
> try{
>   // establish connection and do stuff
> }catch(Exception e){
>   // deal with any problems
> }finally{
>   try{
>   con.close();
> }catch(Exception ignored){}
> }
> 
> 
> 
> 
> 
> 
> 
> On Mar 23, 2010, at 3:33 PM, Brutzman, Bill wrote:
> 
> > The following code works ok...
> > 
> > Thanks to all those who responded especially John, Jeff, Bruce, 
> > Charles, Ben, and Mike.
> > 
> > --Bill
> > 
> > import java.sql.*;
> > 
> > public class Uni_101 {
> > 
> >public static void main(String[] args) {
> >try {
> > 
> >try {
> > Class.forName("com.ibm.u2.jdbc.UniJDBCDriver"); 
> >}
> >catch(Exception x){
> > System.out.println( "Here " + x );
> >} 
> >  String url = 
> > "jdbc:ibm-u2://192.168.0.102/SHIPPING";
> >  String  userid
> > = "ups";
> > 

Re: [U2] U2 on Windows wierdness

2010-03-24 Thread George Gallen
I don't mean the filename is lowercase, I mean the contents of the file.

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
> Sent: Wednesday, March 24, 2010 2:44 PM
> To: U2 Users List
> Subject: Re: [U2] U2 on Windows wierdness
> 
> I've seen things like this when using a mapped drive from Windows to
> UNIX.  I create something in upper case yet it is in lower case on the
> UNIX box.  If I build it on the UNIX box first (even just an empty
> file), the file name is in the upper/lower as I wanted.  It appears to
> only be an issue when I first create it using Windows.
> 
> I hope that helps.
> 
> 
> John Israel
> Senior Programmer/Analyst
> Dayton Superior Corporation
> 721 Richard St.
> Miamisburg, OH  45342
> 937-866-0711 x44380
> 
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of George Gallen
> Sent: Wednesday, March 24, 2010 2:41 PM
> To: U2 Users List
> Subject: [U2] U2 on Windows wierdness
> 
> OK. Here's a strange one.
> 
> If I type up a program in the text editor, and save it.
> Then I copy that file to windows folder, which Universe has access to
> 
> If I then copy that file from this folder to SOURCE (from within
> Universe), it's all in lower case
> 
> What's the deal? How can fix this.
> 
> UV is in Reality mode, on a Windows platform.
> 
> 
> George Gallen
> Senior Programmer/Analyst
> Accounting/Data Division, EDI Administrator
> ggal...@wyanokegroup.com
> ph:856.848.9005 Ext 220
> The Wyanoke Group
> http://www.wyanokegroup.com
> 
> 
> 
> ___
> 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] U2 on Windows wierdness

2010-03-24 Thread George Gallen
The original file was created on a windows machine,
Then transferred to another windows machine using remotePC website
This machine has a mapped drive which is on an NT server
The UV server is on the NT machine

No unix (maybe that's the problem :) )

> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of Israel, John R.
> Sent: Wednesday, March 24, 2010 2:44 PM
> To: U2 Users List
> Subject: Re: [U2] U2 on Windows wierdness
> 
> I've seen things like this when using a mapped drive from Windows to
> UNIX.  I create something in upper case yet it is in lower case on the
> UNIX box.  If I build it on the UNIX box first (even just an empty
> file), the file name is in the upper/lower as I wanted.  It appears to
> only be an issue when I first create it using Windows.
> 
> I hope that helps.
> 
> 
> John Israel
> Senior Programmer/Analyst
> Dayton Superior Corporation
> 721 Richard St.
> Miamisburg, OH  45342
> 937-866-0711 x44380
> 
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
> boun...@listserver.u2ug.org] On Behalf Of George Gallen
> Sent: Wednesday, March 24, 2010 2:41 PM
> To: U2 Users List
> Subject: [U2] U2 on Windows wierdness
> 
> OK. Here's a strange one.
> 
> If I type up a program in the text editor, and save it.
> Then I copy that file to windows folder, which Universe has access to
> 
> If I then copy that file from this folder to SOURCE (from within
> Universe), it's all in lower case
> 
> What's the deal? How can fix this.
> 
> UV is in Reality mode, on a Windows platform.
> 
> 
> George Gallen
> Senior Programmer/Analyst
> Accounting/Data Division, EDI Administrator
> ggal...@wyanokegroup.com
> ph:856.848.9005 Ext 220
> The Wyanoke Group
> http://www.wyanokegroup.com
> 
> 
> 
> ___
> 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] U2 on Windows wierdness

2010-03-24 Thread Israel, John R.
I've seen things like this when using a mapped drive from Windows to UNIX.  I 
create something in upper case yet it is in lower case on the UNIX box.  If I 
build it on the UNIX box first (even just an empty file), the file name is in 
the upper/lower as I wanted.  It appears to only be an issue when I first 
create it using Windows.

I hope that helps.


John Israel
Senior Programmer/Analyst
Dayton Superior Corporation
721 Richard St.
Miamisburg, OH  45342
937-866-0711 x44380


-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Wednesday, March 24, 2010 2:41 PM
To: U2 Users List
Subject: [U2] U2 on Windows wierdness

OK. Here's a strange one.

If I type up a program in the text editor, and save it.
Then I copy that file to windows folder, which Universe has access to

If I then copy that file from this folder to SOURCE (from within Universe), 
it's all in lower case

What's the deal? How can fix this.

UV is in Reality mode, on a Windows platform.


George Gallen
Senior Programmer/Analyst
Accounting/Data Division, EDI Administrator
ggal...@wyanokegroup.com
ph:856.848.9005 Ext 220
The Wyanoke Group
http://www.wyanokegroup.com



___
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] U2 on Windows wierdness

2010-03-24 Thread George Gallen
OK. Here's a strange one.

If I type up a program in the text editor, and save it.
Then I copy that file to windows folder, which Universe has access to

If I then copy that file from this folder to SOURCE (from within Universe), 
it's all in lower case

What's the deal? How can fix this.

UV is in Reality mode, on a Windows platform.


George Gallen
Senior Programmer/Analyst
Accounting/Data Division, EDI Administrator
ggal...@wyanokegroup.com
ph:856.848.9005 Ext 220
The Wyanoke Group
http://www.wyanokegroup.com



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


[U2] wIntegrate Launch Label Program - Problem

2010-03-24 Thread Brutzman, Bill
Sometimes when launching SeaGull Scientific's BarTender program via
wIntegrate, the computer appears to stall.

A band-aid is to Alt-Tab and then choose the BarTender program... and
then the label prints.

Is there a wIntegrate setting to do something like a "Set Focus" such
that BT is on top when invoked from a UniBasic program ?

Suggestions would be appreciated.

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


Re: [U2] Pick Pocket Guide [not-secure]

2010-03-24 Thread Hennessey, Mark F.
Heh - name it "Genius" and you invite a lawsuit from Apple...  

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David A.
Green
Sent: Tuesday, March 23, 2010 4:26 PM
To: 'U2 Users List'
Subject: Re: [U2] Pick Pocket Guide

I say we name it "Genius" so we can all feel smarter when we go to work!

GeniusDB
GeniusQuery
GeniusCode (Not GeniusBasic that's an oxymoron)
Etc.

Hey! We've all just been elevated to Genius Programmers!

David A. Green
(480) 813-1725
DAG Consulting


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
fft2...@aol.com
Sent: Tuesday, March 23, 2010 12:42 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Pick Pocket Guide

In a message dated 3/23/2010 4:14:07 AM Pacific Daylight Time, 
br...@brianleach.co.uk writes:


> So suggestions welcomed.>>

I'm opining that we need a name that is NOT an existing word or acronym
of 
anything else.  Something brand new and fresh and unique so no more
false 
positives.

Will
___
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] JDBC - Finally - Hitch

2010-03-24 Thread Ben Souther
In Java, variables are local to the block in which they were declared.

So, in order to reach your 'con' variable from outside the 'try' block
it needs to be declared outside of that block.


Connection con = null;  // declare con outside of try block.
try{
con = DriverManager...
// do stuff with the connection
}catch(Exception e){
// handle any exceptions
}finally{
try{
   con.close(); 
}catch(Exception ignored){
}
}










On Wed, 2010-03-24 at 11:49 -0400, Brutzman, Bill wrote:
> Ben:
> 
> 1. I am glad to find out about the "finally" command.  I was not aware
> of this feature in Java.
> 2. The new code below yields an IDE error...  con cannot be resolved
> 3. Connection con was already defined... it gives an error when I do a
> con = null;
> 4. IDE does not accept  con.close;
> 5. While I am happy to look into this and figure it out... right now I
> do not know the fix.
> 
> Regards,
> 
> --Bill
> 
> import java.sql.Connection;
> import java.sql.DriverManager;
> import java.sql.ResultSet;
> import java.sql.SQLException;
> import java.sql.Statement;
> 
> public class JDBC_1001 {
> 
> public static void main(String[] args) {
> try {
> 
> try {
>   Class.forName("com.ibm.u2.jdbc.UniJDBCDriver"); 
> }
> catch(Exception x){
>   System.out.println( "Here " + x );
> } 
>   String url
> = "jdbc:ibm-u2://192.168.0.102/SHIPPING";
>   String  userid
> = "ups";
>   String
> passWord  = "brown";
> 
> Connection con = DriverManager.getConnection(url, userid,
> passWord);
>  
> Statement stmt = con.createStatement();
> 
>   String sql = "select @ID, NAME,
> CITY, STATE from PACKSLIPS.X";
> ResultSet rs = stmt.executeQuery(sql);
> 
> int i = 1;
> while (rs.next() && i < 6)
> {
> System.out.println("\nRecord "+ i +" :");
> System.out.println("\...@id : \t" + rs.getString(1));
> System.out.println("\tNAME :\t" + rs.getString(2));
> System.out.println("\tCITY :\t" + rs.getString(3));
> System.out.println("\tSTATE :\t" + rs.getString(4));
> i++;
> }
> 
> rs.close();
> stmt.close() ;
> System.out.println("\n\t*--- QUERY test is done successful
> ---*\n");
> 
> }
> catch (SQLException e ) {
> System.out.println(e);
> }
> finally{
>   try{
>   con.close();
> }
>   catch(Exception ignored){}
> }
> }
> 
> }
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ben Souther
> Sent: Tuesday, March 23, 2010 5:34 PM
> To: U2 Users List
> Subject: Re: [U2] JDBC - ClassPath - Victory
> 
> Glad it's working.
> 
> Tip:  You should always put the con.close() statement in a finally
> block.
> The close method itself can throw an exception so it needs to be in a
> nested try/catch.
> 
> Putting in in a finally block insures that come Hello or high water the
> connection gets closed.
> One of the most common causes for memory leaks in JDBC applications is
> the build up of unclosed database connections.
> 
> 
> Connection con = null;
> try{
>   // establish connection and do stuff
> }catch(Exception e){
>   // deal with any problems
> }finally{
>   try{
>   con.close();
> }catch(Exception ignored){}
> }
> 
> 
> 
> 
> 
> 
> 
> On Mar 23, 2010, at 3:33 PM, Brutzman, Bill wrote:
> 
> > The following code works ok...
> > 
> > Thanks to all those who responded especially John, Jeff, Bruce, 
> > Charles, Ben, and Mike.
> > 
> > --Bill
> > 
> > import java.sql.*;
> > 
> > public class Uni_101 {
> > 
> >public static void main(String[] args) {
> >try {
> > 
> >try {
> > Class.forName("com.ibm.u2.jdbc.UniJDBCDriver"); 
> >}
> >catch(Exception x){
> > System.out.println( "Here " + x );
> >} 
> >  String url = 
> > "jdbc:ibm-u2://192.168.0.102/SHIPPING";
> >  String  userid
> > = "ups";
> >  String passWord  = 
> > "brown";
> > 
> >Connection con = DriverManager.getConnection(url, userid, 
> > passWord);
> > 
> >Statement stmt = con.createStatement();
> > 
> >  String sql = "select @ID, NAME, 
> > CITY, STATE from PACKSLIPS.X";
> >ResultSet rs = stmt.executeQuery(sql);
> > 
> >   

Re: [U2] visual source safe plug-in with basic developer toolkit

2010-03-24 Thread Doug
BDT, Rocket's Eclipse based U2 editor, does not manage any source control
either program, procs or dictionaries.

Using the other Eclipse based editor manages all of the above and even data
for the those code files.  This other Eclipse based editor can use
Subversion, CVS, Perforce, or GIT as you source control.

Regards,
Doug
www.u2logic.com/tools.html
"The other Eclipse based U2 Editor for $49.00"  

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach
Sent: Wednesday, March 24, 2010 4:36 AM
To: 'U2 Users List'
Subject: Re: [U2] visual source safe plugin with basic developer toolkit

Ditto. I've found it the easiest to use with tortoise SVN for the desktop.
But then, I don't use Eclipse or BDT.

Tip - you also need to version manage other assets such as dictionaries.
I've found the easiest way is to build my tables using definition scripts
(similar to a create table statement in SQL) and to then version those
scripts as part of the source code.

Brian 


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


Re: [U2] JDBC - Finally - Hitch

2010-03-24 Thread Brutzman, Bill
Ben:

1. I am glad to find out about the "finally" command.  I was not aware
of this feature in Java.
2. The new code below yields an IDE error...  con cannot be resolved
3. Connection con was already defined... it gives an error when I do a
con = null;
4. IDE does not accept  con.close;
5. While I am happy to look into this and figure it out... right now I
do not know the fix.

Regards,

--Bill

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class JDBC_1001 {

public static void main(String[] args) {
try {

try {
Class.forName("com.ibm.u2.jdbc.UniJDBCDriver"); 
}
catch(Exception x){
System.out.println( "Here " + x );
} 
  String url
= "jdbc:ibm-u2://192.168.0.102/SHIPPING";
  String  userid
= "ups";
  String
passWord  = "brown";

Connection con = DriverManager.getConnection(url, userid,
passWord);
 
Statement stmt = con.createStatement();

  String sql = "select @ID, NAME,
CITY, STATE from PACKSLIPS.X";
ResultSet rs = stmt.executeQuery(sql);

int i = 1;
while (rs.next() && i < 6)
{
System.out.println("\nRecord "+ i +" :");
System.out.println("\...@id : \t" + rs.getString(1));
System.out.println("\tNAME :\t" + rs.getString(2));
System.out.println("\tCITY :\t" + rs.getString(3));
System.out.println("\tSTATE :\t" + rs.getString(4));
i++;
}

rs.close();
stmt.close() ;
System.out.println("\n\t*--- QUERY test is done successful
---*\n");

}
catch (SQLException e ) {
System.out.println(e);
}
finally{
try{
con.close();
}
catch(Exception ignored){}
}
}

}

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ben Souther
Sent: Tuesday, March 23, 2010 5:34 PM
To: U2 Users List
Subject: Re: [U2] JDBC - ClassPath - Victory

Glad it's working.

Tip:  You should always put the con.close() statement in a finally
block.
The close method itself can throw an exception so it needs to be in a
nested try/catch.

Putting in in a finally block insures that come Hello or high water the
connection gets closed.
One of the most common causes for memory leaks in JDBC applications is
the build up of unclosed database connections.


Connection con = null;
try{
// establish connection and do stuff
}catch(Exception e){
// deal with any problems
}finally{
try{
con.close();
}catch(Exception ignored){}
}







On Mar 23, 2010, at 3:33 PM, Brutzman, Bill wrote:

> The following code works ok...
> 
> Thanks to all those who responded especially John, Jeff, Bruce, 
> Charles, Ben, and Mike.
> 
> --Bill
> 
> import java.sql.*;
> 
> public class Uni_101 {
> 
>public static void main(String[] args) {
>try {
> 
>try {
>   Class.forName("com.ibm.u2.jdbc.UniJDBCDriver"); 
>}
>catch(Exception x){
>   System.out.println( "Here " + x );
>} 
>  String url = 
> "jdbc:ibm-u2://192.168.0.102/SHIPPING";
>  String  userid
> = "ups";
>  String passWord  = 
> "brown";
> 
>Connection con = DriverManager.getConnection(url, userid, 
> passWord);
> 
>Statement stmt = con.createStatement();
> 
>  String sql = "select @ID, NAME, 
> CITY, STATE from PACKSLIPS.X";
>ResultSet rs = stmt.executeQuery(sql);
> 
>int i = 1;
>while (rs.next() && i < 6)
>{
>System.out.println("\nRecord "+ i +" :");
>System.out.println("\...@id : \t" + rs.getString(1));
>System.out.println("\tNAME :\t" + rs.getString(2));
>System.out.println("\tCITY :\t" + rs.getString(3));
>System.out.println("\tSTATE :\t" + rs.getString(4));
>i++;
>}
> 
>rs.close();
>stmt.close() ;
>System.out.println("\n\t*--- QUERY test is done successful
> ---*\n");
> 
>}
>catch (SQLException e ) {
>System.out.println(e);
>}
>}
> 
> }
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> 

Re: [U2] JDBC - ClassPath - Victory

2010-03-24 Thread Brutzman, Bill
Ben:

Thanks for the follow-up.  I appreciate it.

--Bill

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ben Souther
Sent: Tuesday, March 23, 2010 5:34 PM
To: U2 Users List
Subject: Re: [U2] JDBC - ClassPath - Victory

Glad it's working.

Tip:  You should always put the con.close() statement in a finally
block.
The close method itself can throw an exception so it needs to be in a
nested try/catch.

Putting in in a finally block insures that come Hello or high water the
connection gets closed.
One of the most common causes for memory leaks in JDBC applications is
the build up of unclosed database connections.


Connection con = null;
try{
// establish connection and do stuff
}catch(Exception e){
// deal with any problems
}finally{
try{
con.close();
}catch(Exception ignored){}
}







On Mar 23, 2010, at 3:33 PM, Brutzman, Bill wrote:

> The following code works ok...
> 
> Thanks to all those who responded especially John, Jeff, Bruce, 
> Charles, Ben, and Mike.
> 
> --Bill
> 
> import java.sql.*;
> 
> public class Uni_101 {
> 
>public static void main(String[] args) {
>try {
> 
>try {
>   Class.forName("com.ibm.u2.jdbc.UniJDBCDriver"); 
>}
>catch(Exception x){
>   System.out.println( "Here " + x );
>} 
>  String url = 
> "jdbc:ibm-u2://192.168.0.102/SHIPPING";
>  String  userid
> = "ups";
>  String passWord  = 
> "brown";
> 
>Connection con = DriverManager.getConnection(url, userid, 
> passWord);
> 
>Statement stmt = con.createStatement();
> 
>  String sql = "select @ID, NAME, 
> CITY, STATE from PACKSLIPS.X";
>ResultSet rs = stmt.executeQuery(sql);
> 
>int i = 1;
>while (rs.next() && i < 6)
>{
>System.out.println("\nRecord "+ i +" :");
>System.out.println("\...@id : \t" + rs.getString(1));
>System.out.println("\tNAME :\t" + rs.getString(2));
>System.out.println("\tCITY :\t" + rs.getString(3));
>System.out.println("\tSTATE :\t" + rs.getString(4));
>i++;
>}
> 
>rs.close();
>stmt.close() ;
>System.out.println("\n\t*--- QUERY test is done successful
> ---*\n");
> 
>}
>catch (SQLException e ) {
>System.out.println(e);
>}
>}
> 
> }
> ___
> 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] Pick Pocket Guide

2010-03-24 Thread Horn, John
From: Tony Gravagno

> The world would be a terrible place if software companies "figured
out" that they could
> provide poor documentation and then make even more money as the unique
source of for-fee
> books that explain their products.

Game software companies figured that out a long time ago, I'm afraid.
Even before a game hits the stores, you'll find strategy guides, hint
guides, walkthroughs, you name it...

John M. Horn | Solutions Engineer, Advisor Sr. | HealthLink |
314-925-6050 | jh...@healthlink.com 


CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for 
the sole use of the intended recipient(s) and may contain confidential and 
privileged information or otherwise protected by law. Any unauthorized review, 
use, disclosure or distribution is prohibited. If you are not the intended 
recipient, please contact the sender by reply e-mail and destroy all copies of 
the original message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Pick Pocket Guide

2010-03-24 Thread Ron Hutchings

As much as we can't seem to get away from referring to TCL, how about MVTCL or 
mvTCL!

> Date: Wed, 24 Mar 2010 03:16:06 -0400
> From: jcan...@optonline.net
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] Pick Pocket Guide
> 
> My bad on the mid-cap drop; sorry.
> 
> For TCL/ECL, maybe mvCommand or mvControl?
> 
> I didn't say it will be easy or even worthwhile for the experts; but, I
> think it must help in some way to be known as the gurus in this market
> (better billable rates, makes you more desirable as a consultant, etc.).  If
> there are five authors (for five platforms) and they each write 20% of the
> book and that book has the potential of selling 5 times more (for five
> platforms instead of one), essentially, you are producing a book for 1/5 of
> the cost.  I know we can really work these numbers so in the end it will
> cost nothing to write [like the days we work in a year].  I know it's still
> a tough sell, but, maybe even include some ad-supported areas within the
> book (as long as it doesn't compromise objectivity concerning the
> platforms).  I think the major platform vendors should also contribute to
> get this done as it directly benefits them the most.
> 
> Recently, I have moved away from the MultiValue market [not by choice].  I
> must say that I'd have a difficult time in getting any 'buy-in' though on
> what I still consider an incredibly powerful database due to almost a
> complete lack of visibility.  How do you promote a technology that hasn't
> had a book based on it in quite a long time?  If the platform vendors, tool
> and integration companies, etc. still believe that they have a good story to
> tell, it's time to ante up and place your bets already.
> 
> Regards,
> 
> Jim
> 
>  
> 
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Clifton Oliver
> Sent: Wednesday, March 24, 2010 1:19 AM
> To: U2 Users List
> Subject: Re: [U2] Pick Pocket Guide
> 
> Well, the terminology issue is something we (Spectrum magazine in
> particular) can promote since we are already committed to promoting the term
> MultiValue (note the mid-cap casing) and the MultiValue Logo. We just add
> such terms to our Style and Usage Guide and use them in the magazine.
> 
> Side note: Is there any interest in us having our Style and Usage Guide
> available online?
> 
> 
> 
> I'm interested in hearing what folks would find an acceptable term for
> TCL/ECL/etc.
> 
> As to the idea of of a generic book, groups of experts, etc., that sounds
> like a fame and glory no profit Open Source kind of thing. A lot of the
> experts you might want to attract are dudes and dudettes trying to make a
> living. That goes back to some of Tony's comments. How could that be made
> worthwhile for said experts to forgo revenue producing time to produce a
> non-profit book?
> 
> Considering some other Open Source documentation efforts, I'm not saying it
> can't be done. I'm just challenging everyone to present detailed ideas for
> how it could be made to work.
> 
> 
> Regards,
> 
> Clif
> 
> 
> 
> On Mar 23, 2010, at 6:09 PM, James Canale, Jr. wrote:
> 
> > I think it would be great do something like this.
> > 
> > Multivalue Query [mvQuery]
> > Multivalue Basic [mvBasic]
> > Multivalue PROC  [mvPROC]
> > 
> > I also think it would be great if someone could write a piece of a book
> that
> > is very generic (keep it at a 20,000 foot view) which covers each major
> > topic area.  Once complete, a group of experts-at-large in the various
> > flavors add platform specific details.  When complete, one or more of the
> > know-it-alls [like some of the gurus on this list] combine the common
> parts,
> > while leaving the unique areas in place.  Basically, a wiki to book
> > transformation.  Many of the books sold today have two, three, and even
> more
> > authors (especially the technically oriented books).  Something like this
> > could reduce the work required (just doing a piece of the whole) and
> > increase the potential market (supports most platforms) for sales.  I see
> a
> > lot of talent on this list that can pull something like this off, it just
> > needs a great leader (and I see many of them here too).
> > 
> > Regards,
> > 
> > Jim
> > 
> > 
> > 
> > -Original Message-
> > From: u2-users-boun...@listserver.u2ug.org
> > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Clifton Oliver
> > Sent: Tuesday, March 23, 2010 6:39 PM
> > To: U2 Users List
> > Subject: Re: [U2] Pick Pocket Guide
> > 
> > In Spectrum magazine, we use the term MultiValue Basic to talk about the
> > programming language in articles that are not platform specific. I put it
> in
> > the style and usage guide for just the reasons being brought up here. I
> > don't see any reason not to add other MultiValue generic terms. MultiValue
> > Query comes to mind. I'm open to suggestions about that and other terms.
> > Post them here, or if you'd ra

[U2] MV MVP

2010-03-24 Thread Brutzman, Bill
I have been meaning to write to Suzie to ask Rocket to consider a MVP
program.  Microsoft, Sun, and other companies have this.  Of course,
MVP's are usually authors of books.

--Bill

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


Re: [U2] Using UNIVERSE Triggers for MYSQL?

2010-03-24 Thread Barry Rutherford
I have used triggers to write the data I want to transfer to a queue
file where I have another process that transfers the data in the queue
to the remote database (Microsoft SQL).  I designed the trigger that way
because if for whatever reason the remote database becomes unavailable
(and that does happen), it only impacts the process that is doing the
transfer rather than causing my trigger to fail.  Obviously the process
that does the transfer has error handling to deal with failed transfers.
Having a separate process to do the transfer allows the trigger to
remain very small and fast with no noticeable impact to the end-user -
and most important, no reason for the trigger to fail.

We never use CLEARFILE on our main database files - so that is not an
issue for us.

Barry

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of ARAMAIES
BAGHDASRAIAN
Sent: Tuesday, March 23, 2010 6:23 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Using UNIVERSE Triggers for MYSQL?

Good day,

I would like to learn on Universe Triggers for MYSQL. using Universe
10.3 .

I have read the materials and there were issues on speed, dailiung to
update
if trigger fails, or Clearfile where the trigger does not get activated.

Please let me know if you have used the Universe triggers in production
environment to update MYSQL tables?

Best regards,

Ara

___
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] Pick Pocket Guide

2010-03-24 Thread Brian Leach
> When Microsoft first released Silverlight -  the first books were from
Microsoft themselves, the others quickly followed.

You have just highlighted the essential difference between books and
software.. 

Software is a single sale: you buy that product from the manufacturer and
don't buy a rival product to do the same thing. 

That's not true with books - to take the Silverlight example, I have half a
dozen different books on Silverlight on my shelves, each offering a
different perspective and level of detail. Personally I've always found the
microsoft press books rushed and full of errors, but I still buy them for
the few useful nuggets they will hold, generally before the better written
ones come out :) 

But all these things go hand in hand:

We need new blood if we are going to support authors - since the hairy old
MV developers won't be the ones buying books even though they can help bring
their skills up to date with the new features in the products or up to date
techniques. (It's the old 'this technology is easy so I shouldn't have to
pay out for what I can work out by myself' argument - even though it's
cheaper in the long run to get the advice rather than sacrifice paid time to
do it yourself. See also: 'Not invented here syndrome').

But to attract that new blood, we need the publications and educational
materials in place to tell them about the technology in the first place. 

Which is why the incubator project at the U2UG is such an important piece in
this discussion. And why I will inevitably keep banging on about it for the
next 12 months - you have been warned .

Brian



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


Re: [U2] visual source safe plugin with basic developer toolkit

2010-03-24 Thread Brian Leach
Ditto. I've found it the easiest to use with tortoise SVN for the desktop.
But then, I don't use Eclipse or BDT.

Tip - you also need to version manage other assets such as dictionaries.
I've found the easiest way is to build my tables using definition scripts
(similar to a create table statement in SQL) and to then version those
scripts as part of the source code.

Brian 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: 24 March 2010 10:05 AM
To: 'U2 Users List'
Subject: Re: [U2] visual source safe plugin with basic developer toolkit

I use subversion for both my .net and unibasic code.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of djordan
Sent: 24 March 2010 07:39
To: 'U2 Users List'
Subject: Re: [U2] visual source safe plugin with basic developer toolkit

Has anyone tried the Microsoft visual source safe plugin for eclipse with
the basic developer toolkit.
I was trying to see if I could use a common source control mechanism for the
.Net and unibasic code.
http://sourceforge.net/projects/vssplugin/ 

Regards

David Jordan

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


Re: [U2] visual source safe plugin with basic developer toolkit

2010-03-24 Thread Symeon Breen
I use subversion for both my .net and unibasic code.

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of djordan
Sent: 24 March 2010 07:39
To: 'U2 Users List'
Subject: Re: [U2] visual source safe plugin with basic developer toolkit

Has anyone tried the Microsoft visual source safe plugin for eclipse with
the basic developer toolkit.
I was trying to see if I could use a common source control mechanism for the
.Net and unibasic code.
http://sourceforge.net/projects/vssplugin/ 

Regards

David Jordan



___
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] Pick Pocket Guide

2010-03-24 Thread Symeon Breen
Ahh we could discuss this at length. Firstly i agree "Books are not uniquely
sourced by product providers, and they shouldn't be"   - I think the
difference is that there is a marketplace for books from these technologies
hence why O'Reilly et al are there. When Microsoft first released
Silverlight -  the first books were from Microsoft themselves, the others
quickly followed. I have had a similar experience with the Amazon web
services, their own book by their product manager was an excellent overview,
but i then had to wait for a bigger book to come out from one of the
mainstream publishers.

With MV, there is little marketplace, the big publishers are not going to
get involved. I say rocket are ideally placed because they have a team of
respected consultants, who (i may be wrong here) may not be 100% utilised
and could be funded to produce literature as a project maybe in conjunction
with some outside resources. How many MV vars, or consultants have teams of
consultants ? - if Brian or John were to write a book at 2 days a week for 6
months thats 20% or their fee earning time for the year gone, I doubt they
would recoup that. If rocket do the same it's a much smaller percentage, and
in the long run may indeed help licence sales.



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: 23 March 2010 04:51
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Pick Pocket Guide

> From: Tony Gravagno ...
> just like Linux, SQL Server, PHP, Java, C#, Excel, and hundreds
> of other technical topics

> From: Symeon Breen
> If you look at the other technologies you mention- the 
> actual providers of these technologies are leaders in 
> also providing books the providers are the best 
> suited to producing such literature, and in my opinion 
> should be taking the lead in this...

My respected colleague, I must disagree.  My extemporaneous
sampling above mentions three Microsoft products and three
non-Microsoft products about which Microsoft Press (I believe)
does not have any publications.  Many books are indeed published
by Microsoft Press but take a look at your local store
bookshelves and you'll find dozens of other publishers including
Wrox, Apress, Manning, McGraw-Hill, IDG, O'Reilly, SAMS, and
Addison-Wesley.  "Books" are not uniquely sourced by product
providers, and they shouldn't be.   Who is the "provider" charged
with writing books for open source software?  We need books
specifically because software authors are generally poor writers,
and software providers generally don't invest in quality
documentation.  Put it back in their hands because they are "best
suited"?  The world would be a terrible place if software
companies "figured out" that they could provide poor
documentation and then make even more money as the unique source
of for-fee books that explain their products.

I also disagree that the DBMS software providers specifically are
the best suited to producing product literature.  I want
"documentation" from my software vendors, but then I want them to
continue working on the software, not books.  The process for
creating books is different than for product docs, and you'll get
commentary about products from an independent author that you
won't get from the software provider.

One of the reasons why I said initially that this community is
"anti-book" is that I've heard the same sort of commentary from
other MV colleagues, that the DBMS vendors should be providing
books, where you rarely get this sort of comment about any other
product.  Look at your local bookstore shelves and see how many
books are written by the software provider - precious few.  No,
pushing the publication of books onto the DBMS providers simply
goes nowhere.  Don't bother.  It's been tried before.  DBMS
vendors don't want to write books and they simply don't.  They
won't even accept help for their docs - both Clif and I have
offered to help the DBMS vendors with their docs and after giving
the concept some lip service these initiatives never go anywhere.
Even if one indignantly maintains that they still "should" write
books, it's a moot point - they won't.  So we need to pick up
from there and move forward.

Best,
T

___
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] U2UG news (was Pick Pocket Guide)

2010-03-24 Thread Brian Leach
All, 

1. The good news is that the U2UG board has agreed to push ahead with our
incubator project this year. This will combine learning materials and sample
applications aimed at bringing the platform in front of genuinely new
developers who have not encountered any flavour of multivalue before. The
aim will be to make it as easy as possible to get people up and running to
the point where they can seriously evaluate the technology, and to showcase
the best that it can offer.

No doubt we will be seeking volunteers along the road.

We will be discussing exactly what we need to include, and how we will be
developing these at the next board meeting (in two weeks' time). We already
have a number of ideas taking shape, but in the mean time, suggestions are
welcomed: just send them to me offlist and I'll keep everyone posted. Once
we have a good batch, I'll add a new forum to the website dedicated to
discussing and furthering this topic, since it is such an important piece
for us as an industry.

NOW - since we're going to be giving up a lot of time for this - we want
something in return! Listen up!

2. One of the major problems has always been visibility. With the loss of
the IBM name, that visibility has taken another dive. The best way to get
that visibility and credibility back, is to be able to tell prospective
customers and developers just how widespread this technology is.

Which means, being able to tell them who is using it.

I know we have top companies in every industry sector using U2. Half of them
don't even know that there are other people in the same industry using it.
And it makes them feel isolated and worried about the platform.

We need a way to tell the world 'We Use U2'.

So we are going to be launching an initiative for people to tell us that. No
more than that - they don't need to tell us anything secret, how they are
using it, what they are doing with it, nothing that points to a competitive
advantage. Just that they are amongst the thousands of organizations that
use it.

So watch this space and think about how you can add your organizations names
to this list. You might be surprised how many others are out there.



Regards

Brian

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


Re: [U2] visual source safe plugin with basic developer toolkit

2010-03-24 Thread djordan
Has anyone tried the Microsoft visual source safe plugin for eclipse with
the basic developer toolkit.
I was trying to see if I could use a common source control mechanism for the
.Net and unibasic code.
http://sourceforge.net/projects/vssplugin/ 

Regards

David Jordan



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


Re: [U2] Pick Pocket Guide

2010-03-24 Thread James Canale, Jr.
My bad on the mid-cap drop; sorry.

For TCL/ECL, maybe mvCommand or mvControl?

I didn't say it will be easy or even worthwhile for the experts; but, I
think it must help in some way to be known as the gurus in this market
(better billable rates, makes you more desirable as a consultant, etc.).  If
there are five authors (for five platforms) and they each write 20% of the
book and that book has the potential of selling 5 times more (for five
platforms instead of one), essentially, you are producing a book for 1/5 of
the cost.  I know we can really work these numbers so in the end it will
cost nothing to write [like the days we work in a year].  I know it's still
a tough sell, but, maybe even include some ad-supported areas within the
book (as long as it doesn't compromise objectivity concerning the
platforms).  I think the major platform vendors should also contribute to
get this done as it directly benefits them the most.

Recently, I have moved away from the MultiValue market [not by choice].  I
must say that I'd have a difficult time in getting any 'buy-in' though on
what I still consider an incredibly powerful database due to almost a
complete lack of visibility.  How do you promote a technology that hasn't
had a book based on it in quite a long time?  If the platform vendors, tool
and integration companies, etc. still believe that they have a good story to
tell, it's time to ante up and place your bets already.

Regards,

Jim

 


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Clifton Oliver
Sent: Wednesday, March 24, 2010 1:19 AM
To: U2 Users List
Subject: Re: [U2] Pick Pocket Guide

Well, the terminology issue is something we (Spectrum magazine in
particular) can promote since we are already committed to promoting the term
MultiValue (note the mid-cap casing) and the MultiValue Logo. We just add
such terms to our Style and Usage Guide and use them in the magazine.

Side note: Is there any interest in us having our Style and Usage Guide
available online?



I'm interested in hearing what folks would find an acceptable term for
TCL/ECL/etc.

As to the idea of of a generic book, groups of experts, etc., that sounds
like a fame and glory no profit Open Source kind of thing. A lot of the
experts you might want to attract are dudes and dudettes trying to make a
living. That goes back to some of Tony's comments. How could that be made
worthwhile for said experts to forgo revenue producing time to produce a
non-profit book?

Considering some other Open Source documentation efforts, I'm not saying it
can't be done. I'm just challenging everyone to present detailed ideas for
how it could be made to work.


Regards,

Clif



On Mar 23, 2010, at 6:09 PM, James Canale, Jr. wrote:

> I think it would be great do something like this.
> 
> Multivalue Query [mvQuery]
> Multivalue Basic [mvBasic]
> Multivalue PROC  [mvPROC]
> 
> I also think it would be great if someone could write a piece of a book
that
> is very generic (keep it at a 20,000 foot view) which covers each major
> topic area.  Once complete, a group of experts-at-large in the various
> flavors add platform specific details.  When complete, one or more of the
> know-it-alls [like some of the gurus on this list] combine the common
parts,
> while leaving the unique areas in place.  Basically, a wiki to book
> transformation.  Many of the books sold today have two, three, and even
more
> authors (especially the technically oriented books).  Something like this
> could reduce the work required (just doing a piece of the whole) and
> increase the potential market (supports most platforms) for sales.  I see
a
> lot of talent on this list that can pull something like this off, it just
> needs a great leader (and I see many of them here too).
> 
> Regards,
> 
> Jim
> 
> 
> 
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Clifton Oliver
> Sent: Tuesday, March 23, 2010 6:39 PM
> To: U2 Users List
> Subject: Re: [U2] Pick Pocket Guide
> 
> In Spectrum magazine, we use the term MultiValue Basic to talk about the
> programming language in articles that are not platform specific. I put it
in
> the style and usage guide for just the reasons being brought up here. I
> don't see any reason not to add other MultiValue generic terms. MultiValue
> Query comes to mind. I'm open to suggestions about that and other terms.
> Post them here, or if you'd rather not, just send them to me at
> edi...@intl-spectrum.com (or my regular e-mail address).
> 
> 
> Regards,
> 
> Clif
> 
> -- 
> Clifton Oliver, Managing Editor
> International Spectrum Magazine
> Spectrum Tel: +1 720 259 1356
> Clif's Direct Tel: +1 619 460 5678
> 
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users

___