Re: [U2] A Generous Offer

2006-06-27 Thread Mats Carlid 

Oh no - not again -  no meeting in Sundbyberg, Sweden !   ;^)

-- mats



Results wrote:


George:
Full(er) details at http://www.Intl-Spectrum.com. Here's the list:

Cincinnati, OH
Sept. 25 - 26
Kings Island Resort
Sponsor: Ashwood Computer Services 

Seattle, WA
Oct. 11 - 12
Holiday InnSeattle SeaTac Airport
Sponsor: Seattle Pick Users Group 

Sydney, AUS
Nov. 1 - 2
Star City Hotel & Casino

New Jersey
Nov. 14 - 15
Sheraton at Woodbridge Place



George Gallen wrote:

 


besides, NJ doesn't smell anymoreat least not that much :)
I didn't follow the link, but where in NJ is the spectrum being held at?
   


---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2][AD] PDF Document

2006-06-27 Thread Craig Bennett 

Andy,

its not the exact solution you describe but it may be simpler to use 
from BASIC. We sell a native PDF generator for U2 (no shells, or 
external programs just BASIC subroutines to call).

Have a look at www.cross.net.au/pdf.asp if you are interested.

regards,


Craig Bennett
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] BCI Connect

2006-06-27 Thread graham.forbes 
Does anyone know if I can call a SQL stored procedure using the
SQLExecDirect command?

Thanks

Graham


Graham Forbes| Trading Systems | BT Global Services | Tel:+44 (0)20 
7176| Mob:+44 (0)77407 38550 | Fax:+44 (0)20  7177 | E:
[EMAIL PROTECTED] | www.bt.com/globalservices

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod
Sent: Sunday, January 02, 2005 11:01 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] BCI Connect

A couple of small things.

You didn't need SQLNumResultCols, because you already knew - from your
SELECT statement - that there would be three columns in the result set.

And you didn't need to unbind variables; this will happen anyway when
you use SQLFreeStmt with SQL.DROP as the second argument.

I would have liked to have seen your CHECK.STATUS subroutine; this is
usually the critical part.  Similarly, your main (fetch) loop does not
exit on error - you really want it to do so.

ErrCode = SQLFetch(hStmt)
LOOP
WHILE ErrCode <> SQL.NO.DATA.FOUND AND ErrCODE <> SQL.ERROR
   CRT SQLDATA(1) : " " : SQLDATA(2) : " " : SQLDATA(3)
   ErrCode = SQLFetch(hStmt)
REPEAT
IF ErrCode = SQL.ERROR THEN GOSUB CHECK.STATUS

Hope this helps; I've deliberately top-posted so that you can compare
what I've suggested with your admittedly working code.

- Original Message -
From: [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] BCI Connect
Date: Fri, 31 Dec 2004 07:55:00 -

> 
> Ray & Richard
> 
> Thanks for you reply. Here is my code which works, but would
appreciate if
> you could cast a quick eye over it.
> 
> 
> 029: * use Unidata Connect to get data from Siebel
> 030: $INCLUDE DEMOINCLUDE ODBC.H
> 031:
> 032: * setup connect parameters
> 033: datasource="SIEBELTEST"
> 034: username="SIEBEL_READ_ONLY"
> 035: passwd="PASSWORD"
> 036: STATUS = SQLAllocEnv(database.env)
> 037: *
> 038: MODULE = "ESTABLISH.BCI"
> 039: ENVTYPE = "Database"
> 040: Fn = "SQLAllocEnv"
> 041: GOSUB CHECK.STATUS
> 042: *
> 043: * Step 2 - Allocate Connection Environment
> 044: *
> 045: *
> 046: STATUS = SQLAllocConnect(database.env,connection.env)
> 047: *
> 048: ENVTYPE = "Connection"
> 049: fn = "SQLAllocConnect"
> 050: GOSUB CHECK.STATUS
> 051: *
> 052: *
> 053: *

> 054:
> 055: * Step 3 - Connecting to Database
> 056: *
> 057: *
> 058: STATUS = SQLConnect(connection.env, datasource, username, passwd)
> 059: *
> 060: ENVTYPE = "Connection"
> 061: GOSUB CHECK.STATUS
> 062: *
> 063: ALLOC.STATEMENT.ENV:
> 064: *
> 065: * ---
> 066:
> 067: * Step 4 - Allocate Statement Environment
> 068: * The Statement Environment is used when executing SQL
> 069: * statement functions
> 070: *
> 071: *
> 072: STATUS = SQLAllocStmt(connection.env,statement.env)
> 073: *
> 074: MODULE = "ALLOC.statement.env"
> 075: Fn = "SQLAllocStmt"
> 076: ENVTYPE = "Connection"
> 077: GOSUB CHECK.STATUS
> 078:
> 079: SQLSTATEMENT="SELECT  ROW_ID AS ACCNT_ROW_ID, NAME AS
ACCOUNT_NAME, LOC
> AS
>   ACCOUNT_LOC FROM SIEBEL.S_ORG_EXT WHERE X_BTS_BUSINESS_UNIT =
'Financial
> Servic
> es' AND X_BTS_SECTOR = 'Trading Systems'"
> 080:
> 081: STATUS = SQLExecDirect(statement.env, SQLSTATEMENT)
> 082:
> 083: STATUS = SQLNumResultCols (statement.env, cols)
> 084:
> 085: DIM SQLDATA(cols)
> 086: FOR NUMCOL=1 TO cols
> 087:   SQL.STATUS = SQLBindCol(statement.env,NUMCOL,SQL.B.DEFAULT,
> SQLDATA(NUMCO
> L))
> 088: NEXT NUMCOL
> 089:
> 090: STATUS = 0
> 091: Fn = "SQLFetch"
> 092: ENVTYPE = "Statement"
> 093:
> 094: LOOP
> *--: P
> 095: WHILE STATUS <> SQL.NO.DATA.FOUND DO
> 096: *
> 097: *
> 098:   STATUS = SQLFetch(statement.env)
> 099: *
> 100:   GOSUB CHECK.STATUS
> 101:   IF STATUS <> SQL.NO.DATA.FOUND THEN
> 102: FOR NUMCOL=1 TO cols
> 103:   CRT SQLDATA(NUMCOL):" ":
> 104: NEXT NUMCOL
> 105: CRT
> 106:   END
> 107: REPEAT
> 108: *
> 109: ENVTYPE = "Statement"
> 110: GOSUB CHECK.STATUS
> 111:
> 112:
> 113: * that it, discount from the server
> 114: STATUS = SQLFreeStmt(statement.env, SQL.UNBIND)
> 115: STATUS = SQLFreeStmt(statement.env, SQL.DROP)
> 116: STATUS = SQLDisconnect(connection.env)
> 117: STATUS = SQLFreeConnect(connection.env)
> 118: STATUS = SQLFreeEnv(database.env)
> 119: CRT "Finished"
> 120: STOP
> *--:
> 
> 
> 
> Graham Forbes
> Trading Systems
> BT Consulting & Systems Integration
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod
> Sent: 31 December 2004 06:02
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] BCI Connect
> 
> Source code for the CONNECT verb is supplied.  Track it down and take
a look
> at it.
> 
> The steps are as follows.  You should check for, and clear, errors at
every
> step.  Seriously.  ODBC simply does not function with "dirty handles".
> 
> 1.  Allocate ODBC environment (SQLAllocEnv)
> 2.  Allocate connection environment (SQLAllocCon

[U2] PDF Document

2006-06-27 Thread Andrew Lakeland 
Hi all,

 

Has anyone gone down the PDF route to print/email documents such as invoices
directly from U2.

I've seen lots of packages out there that allow dynamic pdf prints based on
data passed.
Some require a VB.net shell which reads the data file then builds the pdf
document.



As an example I would like to create an xml doc.send to
unix/windowsrun utility against the xml file which then merges the xml
data with a template and prints the pdf.

Just wondered if anyone had done this before, what utility they used and how
easy it was.

 

thanks
andy
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] MICR fonts with UniData

2006-06-27 Thread Bill Haskett 
Colin:

Wow, we've only worked with Troy chips, the template, and HP printers.  With
about 75 - 100 printers out in the field we've yet to have to go through the
process you described with the bank; and some of these printers have been
out in the field for about ten years.

When the bank receives checks they go through a MICR reader.  Those that
aren't read properly go into the reject pile.  An operator then puts a white
tape on the bottom of the check and manually enters the information that the
reader missed (check# and bank account#) then enters the clearing amount.
If there's a large number of rejections we hear about it immediately.
However, we've never heard about any rejections in excess of the normal
amount.

We do, however, always use HP printers, always use TROY DIMM chips, and make
it a point to purchase high-quality magnetic ink.  :-) 

Bill


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Tuesday, June 27, 2006 11:46 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] MICR fonts with UniData

John - it's critical. Normally, we do a run of 20 cheques that we give
to the bank which sends them to its testing centre. About a month later
we get them back with a report detailing anything that is incorrect.
They measure things like: MICR clear band, MICR character skew, MICR
line skew, horizontal character position, vertical character position,
character print quality, correct data, enough magnetic ink, etc.

When we bought the MICR dimm we got a template that shows where
everything needs to print.

Good luck

Colin Alfke
Calgary, Canada

>-Original Message-
>From: John Varney
>
>I was told that the placement of the routing and account 
>number is very important. Thanks Colin!
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Re-Comile I-Descriptors ?

2006-06-27 Thread Womack, Adrian 
Sounds like you've got "INTEGER" specified in field 8 (SQL Data) and
"MD1" specified in field 3 (Conversion) of the dictionary for the
problematic field. 

Just removing "INTEGER" will fix the problem - but if you're using SQL
on the file/table maybe you should replace "INTEGER" with the correct
field type.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill
Sent: Wednesday, 28 June 2006 8:05 AM
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] Re-Comile I-Descriptors ?

Several (working) legacy paragraph scripts yield errors on our new
UniVerse server.

The errors resemble... Conversion "MD1" is incompatible with an INTEGER
datatype.

Do I need to re-compile I-Descriptors ?

The legacy UniVerse is v 8.3.3; the new UV is v10.  Both machines are
HP-Ux.

Suggestions would be appreciated.

-Bill
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


DISCLAIMER:
Disclaimer.  This e-mail is private and confidential. If you are not the 
intended recipient, please advise us by return e-mail immediately, and delete 
the e-mail and any attachments without using or disclosing the contents in any 
way. The views expressed in this e-mail are those of the author, and do not 
represent those of this company unless this is clearly indicated. You should 
scan this e-mail and any attachments for viruses. This company accepts no 
liability for any direct or indirect damage or loss resulting from the use of 
any attachments to this e-mail.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Re-Comile I-Descriptors ?

2006-06-27 Thread Debster 
COMPILE-DICT

It doesn't hurt


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Brutzman, Bill
Sent: Tuesday, June 27, 2006 8:05 PM
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] Re-Comile I-Descriptors ?


Several (working) legacy paragraph scripts yield errors on our new UniVerse
server.

The errors resemble... Conversion "MD1" is incompatible with an INTEGER
datatype.

Do I need to re-compile I-Descriptors ?

The legacy UniVerse is v 8.3.3; the new UV is v10.  Both machines are HP-Ux.

Suggestions would be appreciated.

-Bill
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] Re-Comile I-Descriptors ?

2006-06-27 Thread Brutzman, Bill 
Several (working) legacy paragraph scripts yield errors on our new UniVerse
server.

The errors resemble... Conversion "MD1" is incompatible with an INTEGER
datatype.

Do I need to re-compile I-Descriptors ?

The legacy UniVerse is v 8.3.3; the new UV is v10.  Both machines are HP-Ux.

Suggestions would be appreciated.

-Bill
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] [uv] Help with SQL select

2006-06-27 Thread Stuart . Boydell 
Hi,
Ibm trying to get a unique list from a delimited field into an XML
document. If I use a SQL bDISTINCTb select it aborts half way through.

In ReVise it bwouldb be SORT FILE BY COL1 BREAK.ON COL1 COL2 COL3 COL4
DET.SUP ID.SUP except that I canbt use a TOXML clause with this statement.

In SQL itbs bSELECT DISTINCT COL1,COL2,COL3,COL4 FROM FILE ORDER BY COL1
TOXML;b. But Ibm finding when I run this from TCL that this stops halfway
through with an bAborting!b error.

All of the COLn fields are I-types which do a field() extract on a single
delimitated attribute. (eg FIELD(@RECORD<2>,'/',2)).
If I take out one of the columns or the DISTINCT clause in the SQL
statement then it selects to the end of the table. If I add columns it
aborts earlier. The ORDER.BY and the TOXML clauses donbt seem to make any
difference.

Is this a limitation on I-types in SQL selects? Has anyone come across this
problem before and is there a work around?
Alternatively, can someone suggest another way to do this using a single
ReVise statement?

This is on UV10.0.7/AIX, in an SB+ 5.0.4 account at real TCL.

Thanks,
Stuart Boydell

 
** 
  
This email message and any files transmitted with it are confidential and 
intended solely for the use of addressed recipient(s). If you have received 
this email in error please notify the Spotless IS Support Centre (+61 3 9269 
7555) immediately, who will advise further action. This footnote also confirms 
that this email message has been scanned for the presence of computer related 
viruses.
  
** 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] A Generous Offer

2006-06-27 Thread Tom Dodds 
I became clear, to me, when Heather explained that she knew of the U2 user
group meeting.

Thanks for the follow up.

Tom Dodds
[EMAIL PROTECTED]
513-563-2800 Cincinnati Office
708-234-9608 Chicago Office
630-235-2975 Anywhere Cell
 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Results
Sent: Tuesday, June 27, 2006 5:54 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] A Generous Offer

Tom,
It is hosted by Ashwood. I meant, someone to Host (chair) the U2UG 
dinner the night before the Spectrum show. I'm sorry if I wasn't clear.

- Chuck

Tom Dodds wrote:

>I believe that the Cincinnati OH event is already being hosted by Ashwood
>Computer Company, Rod Owens.  Contact would be
[EMAIL PROTECTED]
>Mailings have already be made as have other arrangements.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] A Generous Offer

2006-06-27 Thread Results 

Tom,
   It is hosted by Ashwood. I meant, someone to Host (chair) the U2UG 
dinner the night before the Spectrum show. I'm sorry if I wasn't clear.


   - Chuck

Tom Dodds wrote:


I believe that the Cincinnati OH event is already being hosted by Ashwood
Computer Company, Rod Owens.  Contact would be [EMAIL PROTECTED]
Mailings have already be made as have other arrangements.

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] MICR fonts with UniData

2006-06-27 Thread GarryS 
We have been doing laser checks from different platforms for a long time.
Don't forget a good quality secure check stock. We use a company ACOM.com
which used to be Secure-A-Check who create a nice check stock form to print
on, which has many security features so it is difficult to photocopy the
check. 


http://www.orderprintersupplies.com/product_catalog.aspx?category_guid=2742c
57f-6b40-4acb-8920-17f5f444cf6a

> -Original Message-
> From: John Varney [SMTP:[EMAIL PROTECTED]
> Sent: Monday, June 26, 2006 4:44 AM
> To:   u2-users@listserver.u2ug.org
> Subject:  [U2] MICR fonts with UniData
> 
> Has anyone used a MICR soft font with UniData? I have a project to print
> checks and am wondering how other people hander the MICR font for account
> / routine numbers. Thanks.
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] A Generous Offer

2006-06-27 Thread Tom Dodds 
I believe that the Cincinnati OH event is already being hosted by Ashwood
Computer Company, Rod Owens.  Contact would be [EMAIL PROTECTED]
Mailings have already be made as have other arrangements.

Tom Dodds
[EMAIL PROTECTED]
513-563-2800 Cincinnati Office
708-234-9608 Chicago Office
630-235-2975 Anywhere Cell
 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of u2ug
Sent: Tuesday, June 27, 2006 12:09 PM
To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED]
Subject: [U2] A Generous Offer

All,
 We need your feedback. I just received this very generous offer 
from Nathan Rector (International Spectrum). We need to know who can 
attend, sooner the better. For the NJ event, I can commit to chairing 
the meeting. We are looking for a board member (past or present) to host 
the Ohio event. Both of these events are conditional on our having 
attendees. We don't want to waste Nathan's offer on a no-show event. The 
best way to respond is to reply to this announcement.

[AD]
 From Nathan:
International Spectrum would like to invite the U2 User Group to 
host a User Group meeting in Cincinnati, OH on Sept 25th and in New 
Jersey, Nov 14th. International Spectrum would like to support the U2 
User group by providing a venue and dinner for your meeting.  This 
meeting will be on the 1st night of the International Spectrum Regional 
Conferences in each of these cities.
 The fee for your members will be $35 for the dinner if they are not 
already attending the International Spectrum Conference.  If they have 
registered
 and are attending the Conference, then their dinner will be included in 
their registration price.


Nathan Rector, President
International Spectrum, Inc
[EMAIL PROTECTED]
http://www.intl-spectrum.com 

[/AD]

- Charles Barouch, Moderator

U2-Users
U2-Community
RBSolutions
SBSolutions

Visit http://listserver.u2ug.org, enter your e-mail address, and 'browse 
all' lists to maintain your access.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] A Generous Offer

2006-06-27 Thread Dianne Ackerman 
At least one representative from Aptron Corporation will attend the NJ 
event.

-Dianne

u2ug wrote:


All,
We need your feedback. I just received this very generous offer 
from Nathan Rector (International Spectrum). We need to know who can 
attend, sooner the better. For the NJ event, I can commit to chairing 
the meeting. We are looking for a board member (past or present) to host 
the Ohio event. Both of these events are conditional on our having 
attendees. We don't want to waste Nathan's offer on a no-show event. The 
best way to respond is to reply to this announcement.


[AD]
From Nathan:
   International Spectrum would like to invite the U2 User Group to 
host a User Group meeting in Cincinnati, OH on Sept 25th and in New 
Jersey, Nov 14th. International Spectrum would like to support the U2 
User group by providing a venue and dinner for your meeting.  This 
meeting will be on the 1st night of the International Spectrum Regional 
Conferences in each of these cities.
The fee for your members will be $35 for the dinner if they are not 
already attending the International Spectrum Conference.  If they have 
registered
and are attending the Conference, then their dinner will be included in 
their registration price.



Nathan Rector, President
International Spectrum, Inc
[EMAIL PROTECTED]
http://www.intl-spectrum.com 


[/AD]

- Charles Barouch, Moderator

   U2-Users
   U2-Community
   RBSolutions
   SBSolutions

Visit http://listserver.u2ug.org, enter your e-mail address, and 'browse 
all' lists to maintain your access.

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

 



--


Dianne Ackerman
Director, Application Development & Support
Aptron Corporation
www.aptron.com
P: 973/822-0700, ext. 105
F: 973/822-3234
[EMAIL PROTECTED]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] MICR fonts with UniData

2006-06-27 Thread colin.alfke 
John - it's critical. Normally, we do a run of 20 cheques that we give
to the bank which sends them to its testing centre. About a month later
we get them back with a report detailing anything that is incorrect.
They measure things like: MICR clear band, MICR character skew, MICR
line skew, horizontal character position, vertical character position,
character print quality, correct data, enough magnetic ink, etc.

When we bought the MICR dimm we got a template that shows where
everything needs to print.

Good luck

Colin Alfke
Calgary, Canada

>-Original Message-
>From: John Varney
>
>I was told that the placement of the routing and account 
>number is very important. Thanks Colin!
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] A Generous Offer

2006-06-27 Thread George Gallen 
besides, NJ doesn't smell anymoreat least not that much :)

I didn't follow the link, but where in NJ is the spectrum being held at?

> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Barry Rogen
> Sent: Tuesday, June 27, 2006 2:22 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] A Generous Offer
> 
> 
>Bad idea,  in my humble opinion.  I like the idea of
> a dinner in the local areas. It does two things. First, it 
> brings people from the area together for some good networking. 
> Secondly, it may spawn a dynamic local group of users in the 
> area. Creating a local source of information, communication 
> and professional opportunities.
> 
> Barry  Rogen
> PNY Technologies, Inc.
> Senior  Programmer/Analyst
> (973)  515 - 9700  ext 5327
> [EMAIL PROTECTED]
> 
> -
> Far better it is to dare mighty things, to win 
> glorious triumphs even though checkered by
> failure, than to rank with those poor spirits who
> neither enjoy nor suffer much because they live
> in the gray twilight that knows neither victory
> nor defeat.t. roosevelt
> 
> 
> 
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of will
> Sent: Tuesday, June 27, 2006 1:17 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] A Generous Offer
> 
>Charles,
>I have a suggestion... have a users group meeting where people want
> to
>take a vacation! :-)
>There are beautiful places all over North Carolina from the beaches
> to
>the  mountains.   Who  wants  to go to New Jersey or Cincinnati in
> the
>summer?
>I  moved  away  from Cincinnati to be here in NC.  It is beautiful
> and
>there are lots of places to see.  If IS will have a User Group
> meeting
>in  Raleigh  or  Wilmington,  NC, I will donate my time to help put
> it
>together.  Swim, Fish, take part in a movie... etc.
>Kind regards,
>Patrick Williams
>919 567-0042
>u2ug wrote:
> 
> All,
>  We need your feedback. I just received this very generous offer
> from Nathan Rector (International Spectrum). We need to know who can
> attend, sooner the better. For the NJ event, I can commit to chairing
> the meeting. We are looking for a board member (past or 
> present) to host
> the Ohio event. Both of these events are conditional on our having
> attendees. We don't want to waste Nathan's offer on a no-show 
> event. The
> best way to respond is to reply to this announcement.
> 
> [AD]
>  From Nathan:
> International Spectrum would like to invite the U2 User Group to
> host a User Group meeting in Cincinnati, OH on Sept 25th and in New
> Jersey, Nov 14th. International Spectrum would like to support the U2
> User group by providing a venue and dinner for your meeting.  This
> meeting will be on the 1st night of the International 
> Spectrum Regional
> Conferences in each of these cities.
>  The fee for your members will be $35 for the dinner if 
> they are not
> already attending the International Spectrum Conference.  If they have
> registered
>  and are attending the Conference, then their dinner will be 
> included in
> their registration price.
> 
> Nathan Rector, President
> International Spectrum, Inc
> [EMAIL PROTECTED]
> http://www.intl-spectrum.com
> 
[/AD]

- Charles Barouch, Moderator

U2-Users
U2-Community
RBSolutions
SBSolutions

Visit http://listserver.u2ug.org, enter your e-mail address, and 'browse
all' lists to maintain your access.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] A Generous Offer

2006-06-27 Thread Glen Batchelor 
 I live and work in Wilmington, NC. I would be happy to help arrange a
conference here. :) Though, I have to admit that I'm not a pure U2 user. :/


---
Glen Batchelor
IT Director
All-Spec Industries
phone: (910) 332-0424
fax: (910) 763-5664
e-mail: [EMAIL PROTECTED]
---
www.allspec.com
---

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:owner-u2-
> [EMAIL PROTECTED] On Behalf Of will
> Sent: Tuesday, June 27, 2006 1:17 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] A Generous Offer
> 
>Charles,
>I have a suggestion... have a users group meeting where people want to
>take a vacation! :-)
>There are beautiful places all over North Carolina from the beaches to
>the  mountains.   Who  wants  to go to New Jersey or Cincinnati in the
>summer?
>I  moved  away  from Cincinnati to be here in NC.  It is beautiful and
>there are lots of places to see.  If IS will have a User Group meeting
>in  Raleigh  or  Wilmington,  NC, I will donate my time to help put it
>together.  Swim, Fish, take part in a movie... etc.
>Kind regards,
>Patrick Williams
>919 567-0042
>u2ug wrote:
> 
> All,
>  We need your feedback. I just received this very generous offer
> from Nathan Rector (International Spectrum). We need to know who can
> attend, sooner the better. For the NJ event, I can commit to chairing
> the meeting. We are looking for a board member (past or present) to host
> the Ohio event. Both of these events are conditional on our having
> attendees. We don't want to waste Nathan's offer on a no-show event. The
> best way to respond is to reply to this announcement.
> 
> [AD]
>  From Nathan:
> International Spectrum would like to invite the U2 User Group to
> host a User Group meeting in Cincinnati, OH on Sept 25th and in New
> Jersey, Nov 14th. International Spectrum would like to support the U2
> User group by providing a venue and dinner for your meeting.  This
> meeting will be on the 1st night of the International Spectrum Regional
> Conferences in each of these cities.
>  The fee for your members will be $35 for the dinner if they are not
> already attending the International Spectrum Conference.  If they have
> registered
>  and are attending the Conference, then their dinner will be included in
> their registration price.
> 
> Nathan Rector, President
> International Spectrum, Inc
> [EMAIL PROTECTED]
> http://www.intl-spectrum.com
>  spectrum.com>
> [/AD]
> 
> - Charles Barouch, Moderator
> 
> U2-Users
> U2-Community
> RBSolutions
> SBSolutions
> 
> Visit http://listserver.u2ug.org, enter your e-mail address, and 'browse
> all' lists to maintain your access.
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] A Generous Offer

2006-06-27 Thread Barry Rogen 
   Bad idea,  in my humble opinion.  I like the idea of
a dinner in the local areas. It does two things. First, it 
brings people from the area together for some good networking. 
Secondly, it may spawn a dynamic local group of users in the 
area. Creating a local source of information, communication 
and professional opportunities.

Barry  Rogen
PNY Technologies, Inc.
Senior  Programmer/Analyst
(973)  515 - 9700  ext 5327
[EMAIL PROTECTED]

-
Far better it is to dare mighty things, to win 
glorious triumphs even though checkered by
failure, than to rank with those poor spirits who
neither enjoy nor suffer much because they live
in the gray twilight that knows neither victory
nor defeat.t. roosevelt




-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of will
Sent: Tuesday, June 27, 2006 1:17 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] A Generous Offer

   Charles,
   I have a suggestion... have a users group meeting where people want
to
   take a vacation! :-)
   There are beautiful places all over North Carolina from the beaches
to
   the  mountains.   Who  wants  to go to New Jersey or Cincinnati in
the
   summer?
   I  moved  away  from Cincinnati to be here in NC.  It is beautiful
and
   there are lots of places to see.  If IS will have a User Group
meeting
   in  Raleigh  or  Wilmington,  NC, I will donate my time to help put
it
   together.  Swim, Fish, take part in a movie... etc.
   Kind regards,
   Patrick Williams
   919 567-0042
   u2ug wrote:

All,
 We need your feedback. I just received this very generous offer
from Nathan Rector (International Spectrum). We need to know who can
attend, sooner the better. For the NJ event, I can commit to chairing
the meeting. We are looking for a board member (past or present) to host
the Ohio event. Both of these events are conditional on our having
attendees. We don't want to waste Nathan's offer on a no-show event. The
best way to respond is to reply to this announcement.

[AD]
 From Nathan:
International Spectrum would like to invite the U2 User Group to
host a User Group meeting in Cincinnati, OH on Sept 25th and in New
Jersey, Nov 14th. International Spectrum would like to support the U2
User group by providing a venue and dinner for your meeting.  This
meeting will be on the 1st night of the International Spectrum Regional
Conferences in each of these cities.
 The fee for your members will be $35 for the dinner if they are not
already attending the International Spectrum Conference.  If they have
registered
 and are attending the Conference, then their dinner will be included in
their registration price.

Nathan Rector, President
International Spectrum, Inc
[EMAIL PROTECTED]
http://www.intl-spectrum.com

[/AD]

- Charles Barouch, Moderator

U2-Users
U2-Community
RBSolutions
SBSolutions

Visit http://listserver.u2ug.org, enter your e-mail address, and 'browse
all' lists to maintain your access.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] MICR fonts with UniData

2006-06-27 Thread John Varney 
I was told that the placement of the routing and account number is very
important. Thanks Colin!

-Original Message-
From: <[EMAIL PROTECTED]>
To: 
Date: Mon, 26 Jun 2006 14:05:27 -0700
Subject: RE: [U2] MICR fonts with UniData

> John;
> 
> As Bill says - it's a lot easier to get the chip. I think all of our
> clients work that way.
> 
> You also need to use the special MICR toner. Usually it's harder to
> move
> the toner to a different printer than the chip. Remember that the M in
> MICR is for magnetic. It's special toner.
> 
> The best part is that they usually come with a template you can use to
> line up the MICR line. It has to be in a specific location and format
> for the automatic readers.
> 
> Hth
> Colin Alfke
> Calgary Canada 
> 
> >-Original Message-
> >From: Bill Haskett
> >
> >John:
> >
> >Only if it's designed to do so.  For instance, you can use the 
> >same DIMM chip on a 4000 & 4050.  You need to contact them by 
> >going to www.troygroup.com.  Or use Google to search for TROY 
> >DIMM chips. 
> >
> >These chips are really very inexpensive.  Some of the toner, 
> >on the other hand, is rather expensive.  Depending on your 
> >output load, solutions are really inexpensive overall.
> >
> >Bill
> >
> >-Original Message-
> >From: John Varney
> >
> >I'm looking at that as one option. Do you know if those DIMMs 
> >can be used in more than one printer, for instance the laser 
> >printer with the DIMM goes down. Can I trnasplant the DIMM 
> >into another like printer (HP 8100, 9000, etc) to get checks 
> >out the door?
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] A Generous Offer

2006-06-27 Thread John Varney 
I can attend in NJ

-Original Message-
From: u2ug <[EMAIL PROTECTED]>
To: u2-users@listserver.u2ug.org, [EMAIL PROTECTED]
Date: Tue, 27 Jun 2006 12:08:35 -0400
Subject: [U2] A Generous Offer

> All,
>  We need your feedback. I just received this very generous offer 
> from Nathan Rector (International Spectrum). We need to know who can 
> attend, sooner the better. For the NJ event, I can commit to chairing 
> the meeting. We are looking for a board member (past or present) to
> host 
> the Ohio event. Both of these events are conditional on our having 
> attendees. We don't want to waste Nathan's offer on a no-show event.
> The 
> best way to respond is to reply to this announcement.
> 
> [AD]
>  From Nathan:
> International Spectrum would like to invite the U2 User Group to 
> host a User Group meeting in Cincinnati, OH on Sept 25th and in New 
> Jersey, Nov 14th. International Spectrum would like to support the U2 
> User group by providing a venue and dinner for your meeting.  This 
> meeting will be on the 1st night of the International Spectrum Regional
> Conferences in each of these cities.
>  The fee for your members will be $35 for the dinner if they are
> not 
> already attending the International Spectrum Conference.  If they have 
> registered
>  and are attending the Conference, then their dinner will be included
> in 
> their registration price.
> 
> 
> Nathan Rector, President
> International Spectrum, Inc
> [EMAIL PROTECTED]
> http://www.intl-spectrum.com 
>  rum.com>
> [/AD]
> 
> - Charles Barouch, Moderator
> 
> U2-Users
> U2-Community
> RBSolutions
> SBSolutions
> 
> Visit http://listserver.u2ug.org, enter your e-mail address, and
> 'browse 
> all' lists to maintain your access.
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] MICR fonts with UniData

2006-06-27 Thread John Varney 
Again, thanks Bill!

-Original Message-
From: "Bill Haskett" <[EMAIL PROTECTED]>
To: 
Date: Mon, 26 Jun 2006 13:25:34 -0700
Subject: RE: [U2] MICR fonts with UniData

> John:
> 
> Only if it's designed to do so.  For instance, you can use the same
> DIMM
> chip on a 4000 & 4050.  You need to contact them by going to
> www.troygroup.com.  Or use Google to search for TROY DIMM chips. 
> 
> These chips are really very inexpensive.  Some of the toner, on the
> other
> hand, is rather expensive.  Depending on your output load, solutions
> are
> really inexpensive overall.
> 
> Bill
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of John Varney
> Sent: Monday, June 26, 2006 11:47 AM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] MICR fonts with UniData
> 
> I'm looking at that as one option. Do you know if those DIMMs can be
> used
> in more than one printer, for instance the laser printer with the DIMM
> goes down. Can I trnasplant the DIMM into another like printer (HP
> 8100,
> 9000, etc) to get checks out the door?
> 
> -Original Message-
> From: "Bill Haskett" <[EMAIL PROTECTED]>
> To: 
> Date: Mon, 26 Jun 2006 10:51:46 -0700
> Subject: RE: [U2] MICR fonts with UniData
> 
> > John:
> > 
> > Make you life easier and use a MICR font DIMM chip.  They can be
> > purchased
> > from TROY and make programming much easier and are much more
> reliable. 
> > :-) 
> > 
> > Bill
> > 
> > -Original Message-
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On Behalf Of John Varney
> > Sent: Monday, June 26, 2006 4:44 AM
> > To: u2-users@listserver.u2ug.org
> > Subject: [U2] MICR fonts with UniData
> > 
> > Has anyone used a MICR soft font with UniData? I have a project to
> > print
> > checks and am wondering how other people hander the MICR font for
> > account
> > / routine numbers. Thanks.
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] MICR fonts with UniData

2006-06-27 Thread John Varney 
Thanks!

-Original Message-
From: "Bill Haskett" <[EMAIL PROTECTED]>
To: 
Date: Mon, 26 Jun 2006 12:55:38 -0700
Subject: RE: [U2] MICR fonts with UniData

> John:
> 
> If you install a MICR DIMM chip into the printer you can print the
> available
> fonts.  If it is not listed the normal TROY font is:
> 
>[esc](0Q[esc](s1p12v0s0b0T
> 
> Then simply reference this in your output stream, like:
> 
> "[esc]&a650h7725V" to loca the printer cursor, then
> 
> "[esc](0Q[esc](s1p12v0s0b0TC0012002524C A123456789A12 3456789
> 019C[esc]"
> 
> ...where:
> 
> 1) "C0012002524C" is the check ID used by the bank,
> 2) "A123456789" is the Federal Reserve and bank routing#, and
> 3) "12 3456789 019C" is the bank account#.
> 
> Now reset the character set (or change the font) like "[esc](8U".
> 
> Hope this helps.
> 
> Bill
> 
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of John Varney
> Sent: Monday, June 26, 2006 10:28 AM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [U2] MICR fonts with UniData
> 
> That's a good start. Thanks! How is the MICR loaded into flash memory?
> Is
> it part of a DIMM for the pritner or do you load it like a PCL soft
> font?
> 
> Thanks!
> 
> -Original Message-
> From: "Norman Morgan" <[EMAIL PROTECTED]>
> To: 
> Date: Mon, 26 Jun 2006 10:48:09 -0500
> Subject: RE: [U2] MICR fonts with UniData
> 
> > We do this.  Our check stock is regular check safety paper with both
> > top
> > and bottom stubs.  The center section has the security patterns,
> > microprinting, etc., along with a color logo.  Everything else added
> by
> > the laser printer when we do the check printing with a UniBasic
> > program.
> > The printer has a MICR font stored in flash memory, along with a form
> > overlay image and uses a MICR toner cartridge.  The program lays out
> > the
> > text for the check, shifting in and out of the MICR font as
> > appropriate,
> > then just before adding a form feed, it sends the escape sequences to
> > call the forms overlay which is stored as a PCL macro in the printers
> > flash memory.
> > 
> > Here are some code snips from the program:
> > 
> >  *** Define control info for laser printers
> >   ESC = CHAR(27); FORMFEED = CHAR(12)
> >   FORM.DEF  = ESC:"&f112Y"
> >   FORM.CALL = ESC:"&f3X"
> >   SET.FONT.COURIER = ESC:"(10U":ESC:"(s0p10h0s0b4099T"
> >   SET.FONT.MICR = ESC:"(10O":ESC:"(s0p8.00h11.0v0s0b70T"
> >   SET.FONT.LINE.PRT = ESC:"(10U":ESC:"(s0p16.67h8.5v0s0b0T"
> >   PRINTER.RESET = ESC:"E"
> >   SET.PRINTER.LANDSCAPE = ESC:"&l2a0o6d0S"
> >   SET.PRINTER.PORTRAIT = ESC:"(&l2a1o0S"
> >   PRINTER.FORM.SET = SET.PRINTER.LANDSCAPE : SET.FONT.COURIER
> >   PRINTER.FORM.SET := ESC:"&l1e64F":FORMFEED
> > 
> >   GOSUB PrintTopStub
> >   GOSUB PrintCheckBody
> >   GOSUB PrintBottomStub
> >   GOSUB PostGoodCheck
> >   PRINT FORM.DEF:
> >   PRINT FORM.CALL:
> >   PRINT FORMFEED:
> > 
> > PrintCheckBody:
> > *** Codes to position on form **
> >  PRINT ESC:"&a2585v5328H":
> >  PRINT CKNO"R%6"
> >  PRINT "  ":CKNO"R%6":"  ":OCONV(DATE(),"D2/")"R#8":"  ":VNO"L#7"
> >  PRINT
> >  PRINT
> >  PRINT
> >  NET = TOT(3)
> >  GOSUB BuildWordAmount
> >  PRINT SPACE(4):WORD "L#80"
> >  PRINT; PRINT
> >  IF NET+0 = 0 THEN NET = "000"
> >  PRINT SPACE(65):OCONV(NET,"MD2")"R2,*14"
> >  PRINT
> >  PRINT
> >  PRINT SPACE(11):VEND<1> "L#40"
> >  PRINT SPACE(11):VEND<2> "L#40"
> >  IF VEND<3> # "" THEN PRINT SPACE(11):VEND<3> "L#40"
> >  IF VEND<4> # "" THEN PRINT SPACE(11):VEND<4> "L#40"
> >  PRINT SPACE(11):VEND<5,1>:'  ':VEND<5,2>:'  ':VEND<5,3>
> > *** Select MICR font & Position MICR line to Check #
> >  PRINT SET.FONT.MICR:
> >  PRINT ESC:"&a4730v1020H":
> > *** Print Check Number
> >  PRINT CHAR(47):CKNO"R%6":CHAR(47):" ":
> > *** Print Routing Number
> >  PRINT CHAR(38):ROUTING.NUM:CHAR(38):" ":
> > *** Print Account Number
> >  PRINT ACCOUNT.NUM:CHAR(47):
> > *** Switch back to Courier Font
> >  PRINT SET.FONT.COURIER:
> >  RETURN
> > 
> > ===
> > Norman Morgan <> [EMAIL PROTECTED] <> http://www.brake.com
> > ===
> > Why does mineral water that has trickled through mountains
> > for centuries have a 'use by' date? 
> > ===
> > 
> >  
> > 
> > > -Original Message-
> > > From: [EMAIL PROTECTED] 
> > > [mailto:[EMAIL PROTECTED] On Behalf Of Jerry
> Banker
> > > Sent: Monday, June 26, 2006 9:39 AM
> > > To: u2-users@listserver.u2ug.org
> > > Subject: RE: [U2] MICR fonts with UniData
> > > 
> > > I thought you wanted it printed from Unidata?
> > > 
> > > -Original Message-
> > > From: John Varney [mailto:[EMAIL PROTECTED]
> > > Sent: Monday, June 26, 2006 9:2

Re: [U2] A Generous Offer

2006-06-27 Thread will 
   Charles,
   I have a suggestion... have a users group meeting where people want to
   take a vacation! :-)
   There are beautiful places all over North Carolina from the beaches to
   the  mountains.   Who  wants  to go to New Jersey or Cincinnati in the
   summer?
   I  moved  away  from Cincinnati to be here in NC.  It is beautiful and
   there are lots of places to see.  If IS will have a User Group meeting
   in  Raleigh  or  Wilmington,  NC, I will donate my time to help put it
   together.  Swim, Fish, take part in a movie... etc.
   Kind regards,
   Patrick Williams
   919 567-0042
   u2ug wrote:

All,
 We need your feedback. I just received this very generous offer
from Nathan Rector (International Spectrum). We need to know who can
attend, sooner the better. For the NJ event, I can commit to chairing
the meeting. We are looking for a board member (past or present) to host
the Ohio event. Both of these events are conditional on our having
attendees. We don't want to waste Nathan's offer on a no-show event. The
best way to respond is to reply to this announcement.

[AD]
 From Nathan:
International Spectrum would like to invite the U2 User Group to
host a User Group meeting in Cincinnati, OH on Sept 25th and in New
Jersey, Nov 14th. International Spectrum would like to support the U2
User group by providing a venue and dinner for your meeting.  This
meeting will be on the 1st night of the International Spectrum Regional
Conferences in each of these cities.
 The fee for your members will be $35 for the dinner if they are not
already attending the International Spectrum Conference.  If they have
registered
 and are attending the Conference, then their dinner will be included in
their registration price.

Nathan Rector, President
International Spectrum, Inc
[EMAIL PROTECTED]
http://www.intl-spectrum.com

[/AD]

- Charles Barouch, Moderator

U2-Users
U2-Community
RBSolutions
SBSolutions

Visit http://listserver.u2ug.org, enter your e-mail address, and 'browse
all' lists to maintain your access.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

[U2] A Generous Offer

2006-06-27 Thread u2ug 
All,
 We need your feedback. I just received this very generous offer 
from Nathan Rector (International Spectrum). We need to know who can 
attend, sooner the better. For the NJ event, I can commit to chairing 
the meeting. We are looking for a board member (past or present) to host 
the Ohio event. Both of these events are conditional on our having 
attendees. We don't want to waste Nathan's offer on a no-show event. The 
best way to respond is to reply to this announcement.

[AD]
 From Nathan:
International Spectrum would like to invite the U2 User Group to 
host a User Group meeting in Cincinnati, OH on Sept 25th and in New 
Jersey, Nov 14th. International Spectrum would like to support the U2 
User group by providing a venue and dinner for your meeting.  This 
meeting will be on the 1st night of the International Spectrum Regional 
Conferences in each of these cities.
 The fee for your members will be $35 for the dinner if they are not 
already attending the International Spectrum Conference.  If they have 
registered
 and are attending the Conference, then their dinner will be included in 
their registration price.


Nathan Rector, President
International Spectrum, Inc
[EMAIL PROTECTED]
http://www.intl-spectrum.com 

[/AD]

- Charles Barouch, Moderator

U2-Users
U2-Community
RBSolutions
SBSolutions

Visit http://listserver.u2ug.org, enter your e-mail address, and 'browse 
all' lists to maintain your access.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] SELECT stmts forbidden during Transaction in UODOTNET????

2006-06-27 Thread Stevenson, Charles 
I missed the original question triggering this thread, so I'm not sure
if the following is on target or tangential since it has nothing to do
with RPC or UO .NET.

IIRC, in UV, with Transaction Logging enabled, SQL SELECT is allowed,
but will implicitly do a BEGIN TRANSACTION and keep that transaction
open for the duration.  This, even if you merely extract data, not
update.  I do not know how to prevent this.

As log files fill, they will remain in a "NeedSynch" state until the SQL
SELECT is complete.  So, if you have log files that fill within minutes,
and SLECTs that run for 1 or 2 hours, you can get into trouble, filling
all available logs where they cannot be saved to tape, released, and
made available again.

I hit this on UV10.0 running on HPUX.

FWIW,
cds

> From: Peter Veenhof
> 
> I'm not sure what documentation you are reading, the BASIC 
> documentation says you CAN execute SQL statements from within 
> a transaction. See page
> 96 of the Basic.pdf in you documentation under the heading 
> Transaction Restrictions. It explicitly says you CAN EXECUTE 
> a SELECT. 
> 
> And I do know that my problem lies within Universe (or rather 
> the RPC call to universe, that's why I posted it here... It's 
> a bug in UO .NET I can do a transaction in a PICK account 
> using BASIC programming and have SELECT statements in it 
> without any problem, however doing the same from UO .NET 
> blows the program up.
> 
> I'm just looking for anyone how has played with UO .NET that 
> might know of a workaround? 
> 
> -Original Message-
> 
> It's nothing to do with .NET; it's a restriction within 
> UniVerse itself.
> You can read about what is and isn't allowed while a 
> transaction is active in the UniVerse BASIC manual; it's too 
> long to reproduce here.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] U2 Web Product

2006-06-27 Thread Jerry Banker 
That's the new name for Redback.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Tuesday, June 27, 2006 8:47 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] U2 Web Product

Apologies, but never heard of it. What is it?

Karl


> Hello List,
>
>
>
> I was curious if anyone was using IBM's U2 Web DE 4.3 product ?  If so
I
> wanted to know what you thought about the product.  I know I could
read
> about it on IBM's page, but I want to get someone's opinion who is
using
> it.
>
>
>
> Thx,
>
>
>
> Rudy
>
>
>
>
>
> Rudy Cooper
>
>
>
> Technical Project Lead
>
> Sage Publications
>
> Information Technology Development
> (805) 410-7724
>
> [EMAIL PROTECTED]
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
>


-- 
karl

 _/  _/  _/  _/_/_/      __o
_/ _/   _/  _/_/   _-\<._
   _/_/_/  _/_/_/ (_)/ (_)
  _/ _/   _/  _/   ..
 _/   _/ arl _/_/_/  _/ earson[EMAIL PROTECTED]

--

IT Director, ATS Industrial Supply, Inc.
http://www.atsindustrial.com
Toll-free: 800-789-9300 x29
Direct2Desk: 801-978-4429
Facsimile: 801-972-3888
--

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] U2 Web Product

2006-06-27 Thread Mike Randall 
It's part of the 'new' Redback.   Version 4.3 has been renamed.  Haven't
seen it yet though.

Mike

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Tuesday, June 27, 2006 9:47 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] U2 Web Product

Apologies, but never heard of it. What is it?

Karl


> Hello List,
>
>
>
> I was curious if anyone was using IBM's U2 Web DE 4.3 product ?  If so I
> wanted to know what you thought about the product.  I know I could read
> about it on IBM's page, but I want to get someone's opinion who is using
> it.
>
>
>
> Thx,
>
>
>
> Rudy
>
>
>
>
>
> Rudy Cooper
>
>
>
> Technical Project Lead
>
> Sage Publications
>
> Information Technology Development
> (805) 410-7724
>
> [EMAIL PROTECTED]
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
>


-- 
karl

 _/  _/  _/  _/_/_/      __o
_/ _/   _/  _/_/   _-\<._
   _/_/_/  _/_/_/ (_)/ (_)
  _/ _/   _/  _/   ..
 _/   _/ arl _/_/_/  _/ earson[EMAIL PROTECTED]

--
IT Director, ATS Industrial Supply, Inc.
http://www.atsindustrial.com
Toll-free: 800-789-9300 x29
Direct2Desk: 801-978-4429
Facsimile: 801-972-3888
--
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] U2 Web Product

2006-06-27 Thread James Cowell 
It's the new name for Redback, it has a few new bells and whistles


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: 27 June 2006 14:47
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] U2 Web Product


Apologies, but never heard of it. What is it?

Karl


> Hello List,
>
>
>
> I was curious if anyone was using IBM's U2 Web DE 4.3 product ?  If so I
> wanted to know what you thought about the product.  I know I could read
> about it on IBM's page, but I want to get someone's opinion who is using
> it.
>
>
>
> Thx,
>
>
>
> Rudy
>
>
>
>
>
> Rudy Cooper
>
>
>
> Technical Project Lead
>
> Sage Publications
>
> Information Technology Development
> (805) 410-7724
>
> [EMAIL PROTECTED]
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
>


-- 
karl

 _/  _/  _/  _/_/_/      __o
_/ _/   _/  _/_/   _-\<._
   _/_/_/  _/_/_/ (_)/ (_)
  _/ _/   _/  _/   ..
 _/   _/ arl _/_/_/  _/ earson[EMAIL PROTECTED]

--
IT Director, ATS Industrial Supply, Inc.
http://www.atsindustrial.com
Toll-free: 800-789-9300 x29
Direct2Desk: 801-978-4429
Facsimile: 801-972-3888
--
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

-
*
The contents of this e-mail are subject to contract in all cases
and William Hill PLC, its subsidiaries or affiliates make no
contractual commitment save where confirmed by hard copy.

The contents of this e-mail do not necessarily represent the views
of William Hill PLC, its subsidiaries or affiliates.  We accept no
liability, including liability
ent in this e-mail.

This e-mail and any files transmitted with it are confidential, may
be subject to legal privilege and intended solely for the use of
the individual or entity to which they are addressed.  If you are
not the intended recipient, you are hereby notified that any use or
dissemination of this communication is strictly prohibited.  If you
have received this e-mail in error, please notify us immediately,
then delete this e-mail.

Please note that William Hill can accept no responsibility for
viruses and it is your responsibility to scan any emails and their
attachments.

This message was from William Hill PLC whose registered office is
Greenside House, 50 Station Road, Wood Green, London N22 7TP.
Company Registration Number: 4212563 England.

---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

Re: [U2] U2 Web Product

2006-06-27 Thread karlp 
Apologies, but never heard of it. What is it?

Karl


> Hello List,
>
>
>
> I was curious if anyone was using IBM's U2 Web DE 4.3 product ?  If so I
> wanted to know what you thought about the product.  I know I could read
> about it on IBM's page, but I want to get someone's opinion who is using
> it.
>
>
>
> Thx,
>
>
>
> Rudy
>
>
>
>
>
> Rudy Cooper
>
>
>
> Technical Project Lead
>
> Sage Publications
>
> Information Technology Development
> (805) 410-7724
>
> [EMAIL PROTECTED]
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
>


-- 
karl

 _/  _/  _/  _/_/_/      __o
_/ _/   _/  _/_/   _-\<._
   _/_/_/  _/_/_/ (_)/ (_)
  _/ _/   _/  _/   ..
 _/   _/ arl _/_/_/  _/ earson[EMAIL PROTECTED]

--
IT Director, ATS Industrial Supply, Inc.
http://www.atsindustrial.com
Toll-free: 800-789-9300 x29
Direct2Desk: 801-978-4429
Facsimile: 801-972-3888
--
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] SELECT stmts forbidden during Transaction in UODOTNET????

2006-06-27 Thread Peter Veenhof 
I'm not sure what documentation you are reading, the BASIC documentation
says you CAN execute SQL statements from within a transaction. See page
96 of the Basic.pdf in you documentation under the heading Transaction
Restrictions. It explicitly says you CAN EXECUTE a SELECT. 

And I do know that my problem lies within Universe (or rather the RPC
call to universe, that's why I posted it here... It's a bug in UO
.NET I can do a transaction in a PICK account using BASIC
programming and have SELECT statements in it without any problem,
however doing the same from UO .NET blows the program up.

I'm just looking for anyone how has played with UO .NET that might know
of a workaround? 

-Original Message-

It's nothing to do with .NET; it's a restriction within UniVerse itself.
You can read about what is and isn't allowed while a transaction is
active in the UniVerse BASIC manual; it's too long to reproduce here.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] OLEDB connection string

2006-06-27 Thread Nick Cipollina 
Very helpful.  Thanks a lot Bill!

Thanks,
 
Nick Cipollina
 
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
Sent: Monday, June 26, 2006 6:04 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] OLEDB connection string

Nick:

I created a new datasource as follows:

Shared Data Source:
  Name--: UDOleDBReports
  Type--: OLE DB
  Connection string:
  Provider=IBM.UniOLEDB.1;Data Source=asidevud

Connection Properties (via the [Edit] button in above dialog):
  Data Source: OLE DB (OLE DB)
  OLE DB Provider: UniOLEDB Provider
  Enter a server or file name:
Server of file name: asidevud (in the uci.config item)
Location---: leave blank (this messed me up for awhile)
  Log on to the server:
Use a specific user name and password
  User name: valid Windows/UniData user
 (also in UniAdmin > Network Service > UDTelnet Server >
Users)
  Password-: valid Windows password for above user
  Allow saving password

The connection string looks like:

  Provider=IBM.UniOLEDB.1;Data Source=asidevud;Persist Security
Info=True;User ID=DataTrustNET

I used the UCI Configurator to create the OleDB section.  Although the
tool
seems to indicate this is only an ODBC tool the OleDB documentation,
without
mentioning it, assumed ODBC and OleDB sections are exactly the same.

Hope this helps.  :-)

Bill


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Nick Cipollina
Sent: Monday, June 26, 2006 12:04 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] OLEDB connection string

In the connection string, what is the Data Source?  Is that the server
that Universe resides on?  What is the Location?  Is that the account
name?  Is it the path to the account?  No matter what values I put in
these fields, I cannot get it to connect.

Thanks,
 
Nick Cipollina
 
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
Sent: Saturday, June 24, 2006 3:26 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] OLEDB connection string

Nick:

When I access UniOleDB from SQL Reporting Services my connection looks
like:

Provider=IBM.UniOLEDB.1;Data Source=asidevud

And my uci.config item, on my client machine, looks like:


DBMSTYPE = UNIDATA
NETWORK = TCP/IP
SERVICE = udserver
HOST = MyDevServer
ACCOUNT = E:\MyApps\Demo
USERNAME = MyUserNET 

Maybe this helps.  :-)

Bill


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Nick Cipollina
Sent: Friday, June 23, 2006 1:12 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] OLEDB connection string

Can anyone provide me with a sample unioledb connection string that I
could
use in my .NET code?

Thanks,

Nick Cipollina
 
Pick Programmer
ACS Heritage, Inc.
2810 North Parham Road, Suite 210
Richmond, VA 23294
(804)965-8294
---
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/