RE: [U2] Who is activly selling Universe, Unidata and other mv dbs?

2006-03-07 Thread David Jordan
The new IBM director for Databases is very keen on U2 doing well.  IBM U2 is
one of the best performing divisions in the database section, so IBM will be
pushing U2 and you should expect some exciting things starting to come out
of IBM in the next 6 months relating to U2.  All IBM sales people are being
told about IBM U2 in their Sales training, so it is not being forgotten.  

What is becoming pertinent to CEOs to have software that performs, not what
looks good on paper, and this is where mv is coming into its own again.
What you could say others talk, but mv is the silent achiever.

Regards

David Jordan
Managing Consultant
 
[EMAIL PROTECTED]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] PCL extra page

2006-03-07 Thread Sirulnick, Steve
Does anyone know why I could be getting an extra page that spits out at the
beginning of a print job?  This only happens when I format  the print job
with PCL first.  It's almost like a banner page with nothing on it.

 

Regards,

 

Steve Sirulnick

 

Costa Fruit  Produce

18 Bunker Hill Industrial Park

Boston, MA 02129

Office: 617.912.8045

Fax: 617.912.8145

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


[U2] Universe Server vs Enterprise Editions

2006-03-07 Thread Sirulnick, Steve
I was thinking about moving from UV Server to UV Enterprise in order to take
advantage of device licensing. Has anyone ever done this?  We have roughly
100 concurrent users at any given time, but they generally have more than 2
sessions opened (definitely needed here).  Since UV Server doesn't take
advantage of device licensing, my license bills are going through the roof!

 

If there's any flaw in my logic, please let me know. :-)

 

Regards,

 

Steve Sirulnick

 

Costa Fruit  Produce

18 Bunker Hill Industrial Park

Boston, MA 02129

Office: 617.912.8045

Fax: 617.912.8145

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


Re: [U2] To DIM a passed Matrix or not ?

2006-03-07 Thread TPellitieri
Jacques G. [EMAIL PROTECTED] wrote on Mon, 6 Mar 2006 07:51:51 -0800
(PST):

 In Universe, it isn't necessary to DIM a matrix that
 has been passed in a subroutine.  So my question is,
 are there MV flavors where it is neccessary to do so ?

We use UniData with Pick flavor (under SB+).  I tried this test program:

SUBROUTINE MAT.TEST(MAT PARM)
FOR I = 1 TO 100
   PRINT PARM(I):, :
   IF NOT(MOD(I,10)) THEN PRINT
NEXT I
PRINT Done!
RETURN

When I tried to compile it, I got these errors:

Compiling Unibasic: BP/MAT.TEST in mode 'p'.
warning: PARM may be one dimension matrix.
redefined variable PARM near line 3
matrix PARM undefined.
compilation failed

I had to add the DIM PARM(100) statement to get this to compile.

Please note that the CALLING program determines the size of the array, not
the subroutine.  With the example above corrected, I tried the following
program:

DIM CHK(50)
FOR I = 1 TO 50
   CHK(I) = I * I
NEXT I
CALL MAT.TEST(MAT CHK)
STOP

When I ran the program, it bombed out when I=51, since CHK was only
dimensioned to 50.

Suggestion with this syntax:  include the size of the array as a parameter.
My corrected versions of these programs follow:

DIM CHK(50)
FOR I = 1 TO 50
   CHK(I) = I * I
NEXT I
CALL MAT.TEST(MAT CHK,50)
STOP

SUBROUTINE MAT.TEST(MAT PARM, SIZE)
DIM PARM(SIZE)
FOR I = 1 TO SIZE
   PRINT PARM(I):, :
   IF NOT(MOD(I,10)) THEN PRINT
NEXT I
PRINT Done!
RETURN

--Tom Pellitieri
  Century Equipment
  Toledo, Ohio

BE KIND!  DON'T OVERQUOTE!!
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] PCL extra page

2006-03-07 Thread George Gallen
Depends on how you are formatting it.

If you are formatting it by sending a prefix string of characters 
  from one file, then sending your job, that would cause any ESC E
  to shoot out a new page. 

Also, by any chance does your job have any print @(-1) that are sent
  to the printer. If your terminal type uses char(12) to clear the
  screen, which is also a FF on most printers.

How are you formatting the job?

George

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] Behalf Of 
 Sirulnick, Steve
 Sent: Tuesday, March 07, 2006 7:47 AM
 To: 'u2-users@listserver.u2ug.org'
 Subject: [U2] PCL extra page
 
 
 Does anyone know why I could be getting an extra page that 
 spits out at the
 beginning of a print job?  This only happens when I format  
 the print job
 with PCL first.  It's almost like a banner page with nothing on it.
 
  
 
 Regards,
 
  
 
 Steve Sirulnick
 
  
 
 Costa Fruit  Produce
 
 18 Bunker Hill Industrial Park
 
 Boston, MA 02129
 
 Office: 617.912.8045
 
 Fax: 617.912.8145
 
 http://www.freshideas.com/
 ---
 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] To DIM a passed Matrix or not ?

2006-03-07 Thread Jacques G.
In Universe, it isn't necessary to DIM a matrix that
has been passed in a subroutine. 

Just to clarify what I meant here.  The DIM or COM is
still done but it is done in the calling program.  It
isn't neccessary to dim it in the SUBROUTINE in
Universe.




__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] PCL extra page

2006-03-07 Thread Bill Haskett
Steve:

This is almost always limited to HP printers.

What normally happens is that a print job always begins with a form feed.
When PCL  preceeds this print job you get a string that looks like:

Pcl commands : FF : Print job

Then, when this string is sent to the printer, HP interprets Pcl commands
as text, so doesn't suppress the leading form feed...other printers often
do.

In D3, I was able to start a printer and suppress the leading form feed.
However, D3 interpreted Pcl commands as text so when the Print job was
sent it got preceeded by a FF anyway.

The only way I was able to resolve this was to remove all form feeds from
the print job (you can turn this off in D3), use footings in all reports (we
already did anyway), and append a FF to the end of the footing (our
footing text resides in a file).  I don't yet know what solution exists for
U2 but I'll soon find out.  :-(

Bill
 

 -Original Message-
 From: [EMAIL PROTECTED] 
 [mailto:[EMAIL PROTECTED] On Behalf Of 
 Sirulnick, Steve
 Sent: Tuesday, March 07, 2006 4:47 AM
 To: 'u2-users@listserver.u2ug.org'
 Subject: [U2] PCL extra page
 
 Does anyone know why I could be getting an extra page that 
 spits out at the
 beginning of a print job?  This only happens when I format  
 the print job
 with PCL first.  It's almost like a banner page with nothing on it.
 
 Regards,
 
 Steve Sirulnick
 Costa Fruit  Produce
 18 Bunker Hill Industrial Park
 Boston, MA 02129
 Office: 617.912.8045
 Fax: 617.912.8145
 http://www.freshideas.com/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Who is activly selling Universe, Unidata and other mv dbs?

2006-03-07 Thread Dawn Wolthuis
On 3/6/06, will [EMAIL PROTECTED] wrote:
  Thanks for the excellent answer, Dawn.  I think that we all need to be
 proactive in promoting the technology in which we have so many years
 invested.  It's effective, intuitive and ... just won't be buried in the
 onslaught of alphabet soup contenders.  I was hoping that IBM would give us
 a heads up on their plans.

IBM U2 Marketing does provide some information to the U2UG board
regularly.  You can send any questions you have for IBM to
[EMAIL PROTECTED] (IIRC)

 Are they looking for salespeople to market MV?

They do have some excellent sales people related to U2, but I suspect
there might still be IBM sales reps who don't seem to have heard of
it.  The issue is that U2 is sold to VARs.  One of the questions the
U2UG board has asked IBM is about their plans for getting new VARs. 
If there is no obvious external marketing outside of the VAR or
broader MV space, how do you attract new VARs?  While the board has no
specific answer to the question, we do have reason to be optimistic
that this a question that IBM as already (before we asked) been
addressing.

 I think we have some good ones on this list!

This list, u2-community, cdp (comp.databases.pick) plus jBASE, OpenQM,
and Revelation lists.  There might be other discussion lists related
to MV/Pick too.  Cheers!  --dawn
--
Dawn M. Wolthuis
Tincat Group, Inc.
www.tincat-group.com

Take and give some delight today!
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Who is activly selling Universe, Unidata and other mv dbs?

2006-03-07 Thread will
   Thanks  David.   Do  you  have  any statistics on the doing well and
   best performing? Is this just true in Oz?
   We  have  implemented some significant breakthroughs using ajax type
   technology  for  Browser Based implementations of Sales and AR via the
   Internet  using  the  MV  Databases  U2  and D3, and leaving all other
   portions  of  the  MV ERP System untouched.  I am sure that others are
   doing  the  same,  as  well as other solutions, and I expect to see MV
   Systems  thriving  in  this  new environment which will put to bed the
   moans   and   groans   about  text  based  screens  or  screen  scrape
   simulations.
   Will
   David Jordan wrote:

The new IBM director for Databases is very keen on U2 doing well.  IBM U2 is
one of the best performing divisions in the database section, so IBM will be
pushing U2 and you should expect some exciting things starting to come out
of IBM in the next 6 months relating to U2.  All IBM sales people are being
told about IBM U2 in their Sales training, so it is not being forgotten.

What is becoming pertinent to CEOs to have software that performs, not what
looks good on paper, and this is where mv is coming into its own again.
What you could say others talk, but mv is the silent achiever.

Regards

David Jordan
Managing Consultant

[EMAIL PROTECTED]
---
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] Who is activly selling Universe, Unidata and other mv dbs?

2006-03-07 Thread Doug Miller

If interested in IBM plans of U2 in the future, you should read the following.

ftp://ftp.software.ibm.com/software/data/u2/Ambuj-letter.pdf

Written in Nov 05, by the new General Manager of IBM's Information 
Management Software.




At 09:16 AM 3/7/2006, Dawn Wolthuis wrote:

On 3/6/06, will [EMAIL PROTECTED] wrote:
  Thanks for the excellent answer, Dawn.  I think that we all need to be
 proactive in promoting the technology in which we have so many years
 invested.  It's effective, intuitive and ... just won't be buried in the
 onslaught of alphabet soup contenders.  I was hoping that IBM would give us
 a heads up on their plans.



Doug Miller   [EMAIL PROTECTED]
Manager of Technical Services
Strategy 7Dallas TX 
---

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


Re: [U2] PCL extra page

2006-03-07 Thread Dave Taylor
Bill,

I may be reading too much between the lines here, but the following
statement:

---
Then, when this string is sent to the printer, HP interprets Pcl commands
as text, so doesn't suppress the leading form feed...other printers often
do.
--

suggests to me that the printer was installed using the manufacturer's
printer driver for that printer and that the printer driver is performing
its usual tasks and, in addition, is not passing the ESC sequences thru to
the printer:

I didn't notice what platform you're running on, but on a Windows platform,
we always install all Windows printers to be used by Universe using the
Generic/Text driver found in the Generic Manufacturer's list of printer
drivers.

The Generic/Text driver performs no functions whatsoever, but passes thru to
the printer all characters received by it, including ESC sequences which the
printer interprets and reacts to correctly.

I may be able to find a generic/text printer driver for Windows to send you
if you don't have one.

hth,

Dave

Dave Taylor
President
Sysmark Information Systems, Inc.
49 Aspen Way
Rolling Hills Estates, CA 90274
800-SYSMARK (800-797-6275)
(O) 310-544-1974
(C) 310-561-5200
(P) 800-339-1497
(F) 310-377-3550
Your Source for Integrated EDI Translation and DataSync Integration
www.sysmarkinfo.com

- Original Message - 
From: Bill Haskett [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Tuesday, March 07, 2006 7:00 AM
Subject: RE: [U2] PCL extra page


 Steve:

 This is almost always limited to HP printers.

 What normally happens is that a print job always begins with a form feed.
 When PCL  preceeds this print job you get a string that looks like:

 Pcl commands : FF : Print job

 Then, when this string is sent to the printer, HP interprets Pcl
commands
 as text, so doesn't suppress the leading form feed...other printers often
 do.
snip
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] PCL extra page

2006-03-07 Thread Bill Haskett
Dave:

Now I may be reading too much between the lines.  :-)

Our clients use printers from multiple applications; there are no MV only
printers.  So all printers have the appropriate Windows drivers installed.
I've not seen where a print stream sent from an MV application gets altered
by these Windows print drivers.

What I was talking about was the reaction of the printer to this MV
generated print stream.  I've sent the same stream of text (a simple A/R
customer report wrapped in PCL) to both HP, Canon, and Kyocera printers (all
printers were PCL5 compatible).  The string looked like:

peqs  '1' size = 7372
01 [EMAIL PROTECTED] ENTER LANGUAGE =
   PCL..[E[l1ol1e41F[a3l105M[(s0p13h0s3b4099T...T/R  4.2.1
   CUSTOMER NAME  INFORMATION FOR LAKEWOOD VIEW TWNHOME ASSN (450) THRU 30
   Jan 05  PAGE1
02
.
.
44
45 (C) Copyright 09:59:59 07 Mar 2006, Advantos Systems, Inc.  All Rights
   Reserved.
46 .T/R  4.2.1   CUSTOMER NAME  INFORMATION FOR LAKEWOOD VIEW
TWNHOME
   ASSN (605) THRU 30 Nov 04  PAGE2
47
.
.
70 .
71 (C) Copyright 09:59:59 07 Mar 2006, Advantos Systems, Inc.  All Rights
   Reserved.
72 .[E[%-12345X

...where '[' equals escape and the 1st '.' before each MV generated heading
is a form feed generated by the MV AQL HEADING statement.

What appears to happen is the Canon and Kyocera recognize the print buffer
is empty (ignores the PCL code) and ignores this 1st form feed; which makes
sense.  The HP, on the other hand, simply kicks a page when it finds the 1st
form feed.  The [Esc]E doesn't kick the page on either the HP, Canon, or
Kyocera.

In order for us to solve this problem, we had to move the form feed from the
1st character of each mvDbms created heading to the end of each ...All
Rights Reserved. part of the string.  To do this, we were able to turn off
the D3 created form feed completely (via TERM setting of formfeed delays to
0) and add a form feed to the end of the copyright text.

Hopefully, I haven't missed the point completely.  :-)

Bill Haskett
Advantos Systems, Inc.
www.advantos.net 
(760)944-5570 (CA)
(360)923-4838 (WA)
 

 -Original Message-
 From: Dave Taylor [mailto:[EMAIL PROTECTED] 
 Sent: Tuesday, March 07, 2006 9:21 AM
 To: Bill Haskett; u2-users@listserver.u2ug.org
 Subject: Re: [U2] PCL extra page
 
 Bill,
 
 I may be reading too much between the lines here, but the following
 statement:
 
 ---
 Then, when this string is sent to the printer, HP interprets 
 Pcl commands
 as text, so doesn't suppress the leading form feed...other 
 printers often
 do.
 --
 
 suggests to me that the printer was installed using the manufacturer's
 printer driver for that printer and that the printer driver 
 is performing
 its usual tasks and, in addition, is not passing the ESC 
 sequences thru to
 the printer:
 
 I didn't notice what platform you're running on, but on a 
 Windows platform,
 we always install all Windows printers to be used by Universe 
 using the
 Generic/Text driver found in the Generic Manufacturer's list 
 of printer
 drivers.
 
 The Generic/Text driver performs no functions whatsoever, but 
 passes thru to
 the printer all characters received by it, including ESC 
 sequences which the
 printer interprets and reacts to correctly.
 
 I may be able to find a generic/text printer driver for 
 Windows to send you
 if you don't have one.
 
 hth,
 
 Dave
[snipped]
 
 - Original Message - 
 From: Bill Haskett [EMAIL PROTECTED]
 To: u2-users@listserver.u2ug.org
 Sent: Tuesday, March 07, 2006 7:00 AM
 Subject: RE: [U2] PCL extra page
 
 
  Steve:
 
  This is almost always limited to HP printers.
 
  What normally happens is that a print job always begins 
 with a form feed.
  When PCL  preceeds this print job you get a string that looks like:
 
  Pcl commands : FF : Print job
 
  Then, when this string is sent to the printer, HP interprets Pcl
 commands
  as text, so doesn't suppress the leading form feed...other 
 printers often
  do.
 snip
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2][UV] UCI and Windows DNS {unclassified}

2006-03-07 Thread ATLAS SA
Hi all.

We are running UV 10.0.15 on a Windows 2K3 server, which is part of a
Native 2003 domain. We also have a large number of web applications,
located on several separate servers, that attach to the DB via
UniObjects and several critical ODBC connections. I'm revising our
Disaster Recovery plan and in the event of a production server failure,
I would like to redirect all the UniObject and ODBC calls to our DR
server by changing the DNS entry for the production server name to point
to the DR server IP address.

The ODBC entries have been setup using server names so I would assume
that an ODBC connection (and other UCI type calls) would resolve that
name by way of DNS, just like everything else. But I have been asked to
confirm this as there is no such thing as too much paranoia when it come
to DR planning.

Can anyone help confirm that this plan is good? And any pointers to
where this may be documented would also be much appreciated.

Thanks

Andrew Mack
Deputy Systems Administrator
Atlas Systems
New Zealand Defence Force

0064 4 237 1914


The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or
distribute this message or the information in it.

If you have received this message in error, please Email or telephone
the sender immediately.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] UniObjects Select Error

2006-03-07 Thread Dave Tabor
Hi,

I've got an application that is written in VB.NET which uses UniObjects to 
connect to Unidata 6.0 on an AIX server.

It's been working fine for months, and today seems to have 'broken'.  I've 
stepped through the lines in VB.NET, and come up with what I think might be the 
offending error message.

The error is error code 39207, which I have no reference as to it's meaning.

I'm getting the error right after executing this two line code:

Session.command.text = SSELECT FSD BY DEL_DATE BY SORT_SEQ BY.DSND @ID WITH 
SELECT_DATE GE   SelectDateStr   AND WITH @ID # moved AND WITH NO 
PRM_DATE = PDt AND WITH NO CUST_NAME = 

Session.command.exec()

Notes:
1) My session is open, and has no error status.
2) The actual Select Statement created here is:  SSELECT FSD BY DEL_DATE BY 
SORT_SEQ BY.DSND @ID WITH SELECT_DATE GE 03/1/06 AND WITH DISPLAYED # Y AND 
WITH @ID # moved AND WITH NO PRM_DATE = PDt AND WITH NO CUST_NAME = 
3) The Session.command.text statement works correctly, as I can cut/paste it 
from the watch window to an ECL prompt and it works fine.

I'm the only IT person working with this server and VB.NET code, and as I 
mentioned, I haven't changed anything in a months, so I'm not sure where to 
start.

Any guess what the error code means, and/or what I could try to do to resolve 
this issue?

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


Re: [U2] PCL extra page

2006-03-07 Thread Bruce Nichol

Goo'day, Dave and Bill,

A further option you might like to consider (in a Windows printer 
environment) is the use of the printer's Page Separator (for each of the 
separate and several printers you create) to set a document's properties to 
whatever you requirelandscape/portrait, font, size, etc, etc, without 
burying those instructions in your document


Using PCL-style instructions...

At 12:20 07/03/06 -0800, Dave Taylor wrote:

snip

--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.1.375 / Virus Database: 268.2.0/276 - Release Date: 07/03/06


Regards,

Bruce Nichol
Talon Computer Services
ALBURYNSW 2640
Australia

http://www.taloncs.com.au

Tel: +61 (0)411149636
Fax: +61 (0)260232119

If it ain't broke, fix it till it is! 



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.1.375 / Virus Database: 268.2.0/276 - Release Date: 07/03/06
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] PCL extra page

2006-03-07 Thread Buss, Troy \(Logitek Systems\)
In our case...

The users rightfully complained about those blank pages at the beginning
of print jobs, so years ago we put a wrapper around all of our printing.
Essentially, everything goes to a hold file first.

The leading form feed is stripped from the beginning of the job if
present.

The file is then:
* output to the printer
* or processed via PCL2PDF (from visual software)
* and/or optionally emailed to the user

It (the wrapper) not only solves the leading blank page eject problem
but it provides an easy way to implement a variety of other tasks with
the output.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] UniObjects Select Error

2006-03-07 Thread robwills_u2list
The error code is partially explained by this line; however I don't know 
what caused it  :-

Const UVE_SR_SLAVE_READ_FAIL = 39207' Failed to read from the slave 
correctly

HTH

Regards,

Rob Wills
(rob dot wills at tigerinfotech dot com)

Dave Tabor [EMAIL PROTECTED] wrote on 07/03/2006 21:09:59:

 
 Any guess what the error code means, and/or what I could try to do 
 to resolve this issue?
 
 Thanks,
 Dave
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UniObjects Select Error

2006-03-07 Thread Piers Angliss
Dave,

I hit this with a Linux server last year and I'm hoping it's the same
problem. Pete @ Epicor UK did some research and advised that Error 39207
refers to an incorrect LANG setting on a Unix server. LANG should be set to
'C' , if it isn't you'll hit this.

My problem was that the base system LANG setting was not C, but all my
logins used a .profile script to set it to 'C' so ECL worked fine.

Unfortunately, UniObjects doesn't execute .profiles, LOGIN paras or anything
so it reverts to the base LANG (so in order for my theory to hold in your
case, somebody must have changed something in AIX)

Hth

Piers

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Dave Tabor
Sent: 07 March 2006 21:10
To: u2-users@listserver.u2ug.org
Subject: [U2] UniObjects Select Error


Hi,

I've got an application that is written in VB.NET which uses UniObjects to
connect to Unidata 6.0 on an AIX server.

It's been working fine for months, and today seems to have 'broken'.  I've
stepped through the lines in VB.NET, and come up with what I think might be
the offending error message.

The error is error code 39207, which I have no reference as to it's meaning.

I'm getting the error right after executing this two line code:

Session.command.text = SSELECT FSD BY DEL_DATE BY SORT_SEQ BY.DSND @ID WITH
SELECT_DATE GE   SelectDateStr   AND WITH @ID # moved AND WITH
NO PRM_DATE = PDt AND WITH NO CUST_NAME = 

Session.command.exec()

Notes:
1) My session is open, and has no error status.
2) The actual Select Statement created here is:  SSELECT FSD BY DEL_DATE BY
SORT_SEQ BY.DSND @ID WITH SELECT_DATE GE 03/1/06 AND WITH DISPLAYED # Y
AND WITH @ID # moved AND WITH NO PRM_DATE = PDt AND WITH NO CUST_NAME =

3) The Session.command.text statement works correctly, as I can cut/paste it
from the watch window to an ECL prompt and it works fine.

I'm the only IT person working with this server and VB.NET code, and as I
mentioned, I haven't changed anything in a months, so I'm not sure where to
start.

Any guess what the error code means, and/or what I could try to do to
resolve this issue?

Thanks,
Dave
---
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] PCL within a form

2006-03-07 Thread Scott Ballinger
The way I have done this is to use the PCL macro function; upload the
logo to the printer and store it as a macro. Then when you print the
form, turn on the macro in overlay mode. You can turn the macro on and
off as necessary to handle 2nd pages, etc; when done you delete the
macro. You may want to get a PCL book (that's what I ended up doing).

Here is some generic BASIC PCL MACRO handling stuff:

0001 SUBROUTINE PC.LASER.MACRO.CONTROL(CODE,RESULT)
0002 * subroutine to control macros on a laserjet
0003 * 06-21-93 asb
0004 *
0005 * CODE: 0 = start macro definition (for last ID specified)
0006 *   1 = stop macro definition
0007 *   2 = execute macro (for last ID specified)
0008 * uses current print environment and leaves it changed
0009 *   3 = call macro
0010 * uses current print environment then restores original
0011 * print environment when through
0012 *   4 = enable overlay mode (for last ID specified)
0013 * uses overlay print environment then restores original
0014 * print environment when through
0015 *   5 = disable overlay mode
0016 *   6 = delete all macros
0017 *   7 = delete all temporary macros
0018 *   8 = delete macro (for last ID specified)
0019 *   9 = make macro temporary (for last ID specified)
0020 *  10 = make macro permanent (for last ID specified)
0021 *
0022 EQU ESC TO CHAR(27)
0023 *
0024 RESULT = ESC:f:CODE:X
0025 *
0026 RETURN

0001 SUBROUTINE PC.LASER.MACRO.ID(ID,RESULT)
0002 * subroutine to specify a macro id on a laserjet
0003 * 06-21-93 asb
0004 *
0005 EQU ESC TO CHAR(27)
0006 *
0007 RESULT = ESC:f:ID:Y
0008 *
0009 RETURN
0010 END


HTH,

/Scott Ballinger
Pareto Corporation
Edmonds WA USA
206 713 6006

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Friday, March 03, 2006 3:44 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] PCL within a form

What are the other syntaxes? This didn't work correctly.

Karl

quote who=Ron White
 ESC*p0y0X

 set vertical position to zero esc*p0Y set horizontal position to 
 zero esc*p0X

 The code changes depending on whether you are using number of rows, 
 number of dots (which is what I am showing) or number of decipoints

 Ron White


 [EMAIL PROTECTED] wrote:
 quote who=George Gallen

 also try looking for:

 ESCl0H or ESCl0h  (That's ESC--ell-zero) eject page ESCa0G

 or ESCa0g  (That's ESC--a-zero) advance to next side


 The first l0H was the key for not form feeding. Now I need to figure

 out how to 'embed' the image and set the print head at 0x0y, which I 
 think is
 this:  ESC:a0r0C

 If not, does someone know for sure?

 Thanks,

 Karl


 George


 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] Behalf Of 
 [EMAIL PROTECTED]
 Sent: Friday, March 03, 2006 2:28 PM
 To: u2-users@listserver.u2ug.org
 Subject: [U2] PCL within a form


 We have a PCL logo that we'd like to include in an invoice, but 
 when we try sending it, we get a separate page with the logo on it.

 Here's what we've tried:

 scanning the logo and then placing it on the 'page' where we want 
 it, then printing it to a PCL file. That is the file we cat to the 
 invoice.

 It seems that when printing to a PCL file, the top of form and page

 end are set for us and embedded in the PCL output file. We've seen 
 the ESC:'E'
 character at both the top and bottom of the PCL file, but removing 
 them doesn't help.

 Any ideas?

 TIA

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








--
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] PCL extra page

2006-03-07 Thread Paul Tykodi
Dear Steve,

I have seen a number of really good ideas posted to the list to help you
with this issue. Here is another option I haven't seen mentioned yet.

HP PCL includes a command called eject page, which will cause a form feed to
occur if printable data is currently stored in the printer's buffer. It
causes nothing to happen when there is no printable data currently stored in
the printer's buffer.

What is sometimes possible in database printing applications is to create a
new form feed character, to be used by the system when printing certain
reports (i.e. those that get directed to HP PCL compliant laser printers),
and to then define that the new form feed character is equal to the 5 byte
PCL sequence ESCl0H (1B 26 6C 30 48 in ASCII hex). 

HTH

Best Regards,

/Paul
--
Paul Tykodi
Principal Consultant
TCS - Tykodi Consulting Services LLC

Tel/Fax: 603-343-1820
Mobile:  603-866-0712
E-mail:  [EMAIL PROTECTED]
WWW: http://www.tykodi.com

Date: Tue, 7 Mar 2006 07:47:04 -0500
From: Sirulnick, Steve [EMAIL PROTECTED]
Subject: [U2] PCL extra page

Does anyone know why I could be getting an extra page that spits out at the
beginning of a print job?  This only happens when I format the print job
with PCL first.  It's almost like a banner page with nothing on it.


Regards,


Steve Sirulnick

Costa Fruit  Produce
18 Bunker Hill Industrial Park
Boston, MA 02129
Office: 617.912.8045
Fax: 617.912.8145
http://www.freshideas.com/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Universe Server vs Enterprise Editions

2006-03-07 Thread Jeff Powell
Steve,

We did this for the same reasons. We did have some issues and needed to
open a TAC through our ERP vendor to UniData. With their advise we moved
to SB+ 5.3.8 to make it work. Device licensing is working for us.

We are on UniData / AIX.

Jeff


On Tue, 2006-03-07 at 07:53 -0500, Sirulnick, Steve wrote:
 I was thinking about moving from UV Server to UV Enterprise in order to take
 advantage of device licensing. Has anyone ever done this?  We have roughly
 100 concurrent users at any given time, but they generally have more than 2
 sessions opened (definitely needed here).  Since UV Server doesn't take
 advantage of device licensing, my license bills are going through the roof!
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/