[U2] Job Posting

2008-11-03 Thread David Tod Sigafoos
   I was asked to pass this on to the group.  As a personal note I will say
   that is it is a very good company to work for.  Work environment is very
   nice and the leadership in IT are very responsive to ideas.   DSig

   Job Posting

   Date:November 3, 2008

   Job Title:  Senior PICK D3 Programmer

   Department: I.T.

   Reports To:  Kib Reed, Lead Developer

   Salary: DOE

   Start Date: ASAP

   Hours:Full Time

   Location:  Preston WA

   2 Full Time Positions available

   Overview

   Seeking a senior level programmer / analyst with strong Pick/D3 background.
   Must work independently and with our existing group of developers.  A strong
   entrepreneurial background is required.  Must like working with teams,
   groups and end users to develop applications  solutions for our growing
   business.   Must  be able to multi-task and respond to a high level of
   requests.

   Job Duties

   Job Duties will vary in the first year of employment:

   * Learn about our System Architecture, SDLC Process and File structures

   * Write documentation on existing programs

   * Assist in testing new applications that are being developed.

   * Write ad-hoc reports on an as needed basis.

   * Communicate and work directly with Quality Assurance staff to document and
   validate code changes.

   Qualifications:

   * Proven skills in database interface and transaction system programming.

   *  Expert  knowledge of sound database design/integrity principles and
   database administration.

   * Associates Degree in Computer Science, or IS. 4-year Degree is preferred.

   * Knowledge of Unix  Linux environments.

   * Distribution/Manufacturing/Warehouse Environment experience.

   * Ability to look at an application and quickly drill down to determine
   existing functionality andprocess.

   * Must be a team player.

   * Must be a good communicator

   * A high level of energy.

   * Must have a positive attitude and like working with people/end users.

   * Must have a minimum of 4 years PICK / D3 Experience. (Other Multi-Value
   experience considered).

   * Must have reliable transportation.

   * Long Term Commitment expected.

   * Some evening and weekend work required for launches.

   Interested candidates should submit their resume to [EMAIL PROTECTED]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] Universe, 32bit and file size

2008-10-24 Thread David Tod Sigafoos
   Tony,

   Running D3 on a 64bit version of Linux does not allow reading.  This is not
   because of the OS.  The blame is where it belongs ..

   Does it really matter why i need the data?  If we need to bring the data
   into the system then THAT IS what needs to be done.  Of course I could
   always contract with someone to write a wrapper that could then be called
   from D3.  Or i could just write it in c myself.

   You have never lost your back side from my posts unless you start selling
   your services instead of offering information.  I know plenty of consultants
   .. during a small wind they fall out of the trees G

   If 'tiger logic' has a good solution then i hope to hear it.  About a month
   ago we ran into a similar issue and in fact it caused a core dump .. imagine
   not protecting your code G.  One of the contacts at the company asked
   about it and even sent the code .. never heard anything back.  SO hope you
   fare better.

   Thanks

   Thursday, October 23, 2008, 3:17:13 PM, you wrote:

   TG As I mentioned in CDP, this has nothing to do with D3 but it's

   TG always fun to blame D3 for whatever ails ya.  David is using the

   TG %functions from BASIC which are wrappers around raw C functions.

   TG The limitations of these functions are that of the OS, not the

   TG DBMS wrappers.  A quick Google for fopen 2gb will show tons of

   TG postings on this topic from non-MV developers.  My posting to CDP

   TG also asked about the main reason for taking this technical

   TG approach so that someone can provide a better approach to solving

   TG the problem, but the last time I asked why here I lost a bit of

   TG my backside.  I've also posted a note on David's behalf to the

   TG TigerLogic D3 Linux forum to ask if the %functions allow for a

   TG complete passthru to the OS.  If so then he may be able to make

   TG use of 64bit (or Long) functions that are available to C

   TG developers but not in the current D3 documentation.

   TG Tony Gravagno

   TG Nebula Research and Development

   TG TG@ remove.pleaseNebula-RnD.com

From: Martin Phillips

I'm not quite sure why I would want to read/write a

sequential file over 2Gb but, given that this

originated as a D3 comment and has found its way on to

the U2 site, let me just add that QM can handle

sequential files over 2Gb.

The argument used by UV is that because integer values

are stored as 32 bit numbers internally, file

addresses over 2Gb cause a problem. A 64 bit version

of UV still stores integer values as 32 bits because

to do otherwise would potentially impact some

applications (think about bitwise operations, for

example).

Also remember that at the operating system level, 64

bit file addressing does not require a 64 bit

architecture, just use of long long int variables or,

in some cases, a pair of 32 bit variables.

   TG ---

   TG u2-users mailing list

   TG u2-users@listserver.u2ug.org

   TG To unsubscribe please visit http://listserver.u2ug.org/

   TG __ Information from ESET NOD32 Antivirus, version of

   TG virus signature database 3550 (20081023) __

   TG The message was checked by ESET NOD32 Antivirus.

   TG http://www.eset.com

   --

   DSig `

   David Tod Sigafoos  ( O O )

___oOOo__( )__oOOo___

   Academic  chairs  are  many,  but  wise  and  noble teachers are few;
   lecture-rooms are numerous and large, but the number of young people who
   genuinely thirst after truth and justice is small. -- Albert Einstein.
   1879-1955
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] Universe, 32bit and file size

2008-10-24 Thread David Tod Sigafoos
   Robert,

   ding ding ding ding ... great answer Robert.  Thanks

   Thursday, October 23, 2008, 11:46:41 AM, you wrote:

   RP Look at uconfig (but note the ONLY valid on 64-bit capable platforms
   comment)

   RP # 64BIT_FILES - This sets the default mode used to

   RP #   create static hashed and dynamic files.

   RP #   A value of 0 results in the creation of 32-bit

   RP #   files. 32-bit files have a maximum file size of

   RP #   2 gigabytes. A value of 1 results in the creation

   RP #   of 64-bit files (ONLY valid on 64-bit capable platforms).

   RP #   The maximum file size for 64-bit

   RP #   files is system dependent. The default behavior

   RP #   may be overridden by keywords on certain commands.

   RP 64BIT_FILES 1

   --

   DSig `

   David Tod Sigafoos  ( O O )

___oOOo__( )__oOOo___

   A democracy will continue to exist up until the time that voters discover
   they  can vote themselves generous gifts from the public treasury. --
   Alexander Tyler
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] Universe, 32bit and file size

2008-10-24 Thread David Tod Sigafoos
   Yes .. trying to read in a os level file that is gt 2 gig.  and yes %fopen
   fails

   Thursday, October 23, 2008, 12:10:56 PM, you wrote:

   SB I am not sure what you mean when you say ...D3 can only access files
   2gig

   SB and smaller?

   SB Certainly, there is no 2gb limit on D3 files themselves (I have many

   SB instances of D3 files with modulos in excess of 1 million). Are you
   saying

   SB that you can't read native OS files from inside D3 when those file(s)
   are

   SB greater than 2gb?  I would not suggest trying to read an entire large
   file

   SB into D3 this way. Have you tried the %open, %read functions to read and

   SB process the file in reasonably sized chunks, say 10K at a time?  You can
   use

   SB %write to build large files this way as well.

   --

   DSig `

   David Tod Sigafoos  ( O O )

___oOOo__( )__oOOo___

   When buying  selling are controlled by legislation, the first thing to be
   bought  sold are the legislators - P.J. O'Rourke
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] Universe, 32bit and file size

2008-10-24 Thread David Tod Sigafoos
   MP I'm not quite sure why I would want to read/write a sequential file over
   2Gb

   MP but, given that this originated as a D3 comment and has found its way on
   to

   MP the U2 site, let me just add that QM can handle sequential files over
   2Gb.

   I guess the reason is that I need the data from the file.  It is good to
   hear that QM can handle a file of this size.

   MP Also remember that at the operating system level, 64 bit file addressing

   MP  does not require a 64 bit architecture, just use of long long int
   variables

   MP or, in some cases, a pair of 32 bit variables.

   Working from the D3 environment I was just trying to use what tools they
   have.  I am surprised that they don't have and are not talking about a 64bit
   version but that's cool if that is the direction they are taking.

   The reason to ask here is that I was wondering if IBM had an alternate path.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Universe, 32bit and file size

2008-10-23 Thread David Tod Sigafoos
   We have just run into a problem with D3.  It is 32bit and can only access
   files 2gig and smaller.

   Now I understand that this is a very large file BUT ... sometimes you have
   to do what you have to do.

   In looking at the Universe site it looks as if it too is only 32bit.

   1)  is there a 64bit version of universe .. am i just missing it?  the
   platform would be be linux 64big

   2) if there isn't a 64bit version of universe is it possible for universe to
   stream through files greater than 64bit?

   Thanks

   --

   DSig  `

   David Tod Sigafoos  ( O O )

___oOOo__( )__oOOo___

   For the traitor appears no traitor -- he speaks in the accents familiar to
   his victims and he wears their face and their garments and he appeals to the
   baseness that lies deep in the hearts of all men. He rots the soul of a
   nation, he works secretly and unknown in the night to undermine the pillars
   of a city. He infects the body politic so that it can no longer resist --
   Marcus Tullius Cicero 743
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] access to mvBase VTF files

2008-09-18 Thread David Tod Sigafoos
Tony, Funny thing about consultants .. first thing

they want to do is write a program instead of finding

a pre-existing solution.

   TG Dave, anything I suggest is (usually) well considered before I

   TG hit the reply button.  Having done this thing for (I believe)

   TG almost as long as you have, I'm familiar with most of the

   TG pre-existing solutions out there.  All suggestions and solutions

   TG I offer are based on the premise that alternatives are deficient,

   TG time consuming, expensive, or simply non-existent - the nature of

   TG my business is to come up with (hopefully) better solutions based

   TG on an understanding of what's already out there.  Sure, it was

   TG good for you to check here before you started writing code.  If

   TG it wasn't implied properly I'll be explicit - I don't believe

   TG there is a pre-existing solution to read an mvBase VTF into

   TG Unidata.  Therefore I suggested writing (trivial) code for

   TG synchronous or asynchronous exchanges, or to just get a (free)

   TG mvBase environment setup so that you can restore the VTF and

   TG export the data in an easy to migrate format.

   No biggs .. on re-read it did sound like that was directed to you and it
   really wasn't.  It just surprises me that someone like uv/ud wouldn't have
   same since they are trying to be replacements/covers for all flavors.  And i
   would think that anyone running from 'Tiger Logic' (just another group of
   sales people selling something they don't make?) would have found on or
   created one and make it available.

   If we decide to go the 'create one' way we will make it available.

   Thanks again ..

   Just a cranky old guy

   DSig

   --

   DSig `

   David Tod Sigafoos  ( O O )

___oOOo__( )__oOOo___

   Should any political party attempt to abolish social security, unemployment
   insurance, and eliminate labor laws and farm programs, you would not hear of
   that party again in our political history. There is a tiny splinter group,
   of course, that believes you can do these things.  Among them are a few
   Texas oil millionaires, and an occasional politician or business man from
   other areas. Their number is negligible and they are stupid.  --President
   Dwight  D.  Eisenhower, 1954 (source:  Eisenhower Presidential Papers,
   Document #1147; November 8, 1954 The Papers of Dwight David Eisenhower,
   Volume XV - The Presidency: The Middle Way Part VI: Crises Abroad, Party
   Problems at Home; September 1954 to December 1954,) Chapter 13: A new phase
   of political experience
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] access to mvBase VTF files

2008-09-18 Thread David Tod Sigafoos
   TG Dave wrote:

And i would think that anyone running from 'Tiger

Logic' (just another group of sales people selling

something they don't make?)

   TG Tiger Logic is simply a name change from Raining Data (IMO

   TG only one of two good business decisions they've made in recent

   TG years).  They acquired mvBase from GA about 8 years ago and have

   TG been (arguably) maintaining it since.  To my knowledge TL does

   TG not pass-through any products for which they don't have/maintain

   TG source.

would have found on or created one and make it available.

   TG And why would any company write and/or publish a tool that allows

   TG a backup tape to be read by another DBMS?  Again, this is a tool

   TG for daily local backups.  It's not a data transport medium.

   TG There are other ways to do that.

   I'ts okay .. you still aren't hearing what i'm typing

   TG For the cost of our time we'll convert your entire database, any

   TG platform, any OS, into an ADO.NET dataset or SQL Server database,

   TG which can then be read by any product that supports modern

   TG interfaces.  Or we'll create interfaces for live access via any

   TG application that supports a .NET DataSource.  Now _that_ is a

   TG transport medium.

   But at least i gave you a change to pitch your consultancy again G

   --

   DSig `

   David Tod Sigafoos  ( O O )

___oOOo__( )__oOOo___

   It is my ambition to say in ten sentences what others say in a whole book.
   -- Friedrich Nietzsche
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] access to mvBase VTF files

2008-09-16 Thread David Tod Sigafoos
   then there's unidata ... talk about grotesque G

   You are right .. moving data is moving data.  A simple save/restore solves a
   lot of problems, if there is one.

   Of course I can follow the norm and just write something and charge the
   client a lot of something that should be there G

   Thanks

   Saturday, September 13, 2008, 6:54:47 PM, you wrote:

   BH G-man:

   BH Let me try to answer a couple of your questions...

   BH Moving data can be a goal.  Whether you or I can foresee the need is

   BH irrelevant.  I've moved quite a few accounts from D3 to UV and UD and I

   BH suspect Dave has an equally justifiable need (not that he should need to

   BH justify anything).

   BH There used to be a common backup to an older format that all platforms

   BH did.  I can remember upgrading several different platforms to D3 and

   BH upgrading several D3 platforms to U2.  They all had that familiar

   BH account-save (a type of thing.

   BH Many of the vendors had (have) utilities to bring in accounts from other

   BH systems.  Flat-file BS is grotesque!  Then there's UniData.  :-)

   BH Bill

   BH -Original Message-

   BH From: [EMAIL PROTECTED]

   BH [mailto:[EMAIL PROTECTED] On Behalf Of Tony G

   BH Sent: Saturday, September 13, 2008 5:07 PM

   BH To: u2-users@listserver.u2ug.org

   BH Subject: RE: [U2] access to mvBase VTF files

From: David Tod Sigafoos

My higher goal is to move data from mvBase to

uniVerse. Account save / account restore

What I want is information on if this can be done simply.

I can, as ray suggested, read the tape OR i can simply

stream in the file and try to restore on my own.

   BH [flame jacket in hand]

   BH Moving data isn't a goal, it's a tactical effort to satisfy some

   BH more strategic business function.  I'm still curious as to why

   BH you need to move data using platform-specific media.  I find that

   BH the real answer to problems we see presented here is frequently

   BH that the wrong question is being asked.  And while I know there

   BH can be some resentment when I question why someone is asking for

   BH a specific solution, that line of inquiry frequently leads to

   BH saving a lot of time and money in accomplishing the real

   BH strategic goal.  Seriously, I deal with this all the time.

   BH The only valid case I can think of for your inquiry is that you

   BH have an old VTF and the source system no longer exists - maybe a

   BH crash-n-burn where the user wants to move to U2 rather than to

   BH pay for a new mvBASE license.  Fair enough.  If that's the case

   BH then my suggestion is to move the data into a live mvBASE system

   BH somewhere (which you can get for free from any mvBASE dealer)

   BH and then to extract it out using more conventional means.

   BH The tape mechanisms in all of these platforms was never intended

   BH to be cross-platform.  They're intended to backup and restore

   BH data to a specific platform.  And while we expect to be able to

   BH move data from one shop to another, across operating systems, and

   BH across DBMS releases, many of us have found there are occasional

   BH issues here.  Extract data from these proprietary formats is a

   BH sure way to win geek points, but it's a pointless business effort

   BH considering there are better ways to accomplish the goals.

   BH So I would back up a moment (pun intended I guess) and ask why

   BH you're not writing flat files that can be transported and then

   BH read from the file system?  If the systems are local then you can

   BH simply write to a file in BASIC that's simultaneously accessed by

   BH Universe.  I do that for development all the time with a bunch of

   BH DBMS's.

   BH If the mvBASE system is still up and you want to do this on a

   BH regular basis, I'm guessing the environments are remote and you

   BH want to duplicate one or more accounts from one platform and just

   BH read it somewhere else.  All the File-Save process does is to

   BH select the SYSTEM file, loop through all MD files, loop through

   BH all DICT files, and the copy all the DATA file items in a

   BH proprietary tape buffer format.  I know you could swing that in a

   BH few minutes, using the same type of recursive loop to create

   BH directories and write items as files.  ( I actually have code

   BH like that around here somewhere from an effort where I needed to

   BH extract an entire R83 system over a network via AccuTerm. )

   BH Anyway, I hope you accomplish your goals.

   BH Best,

   BH T

   --

   DSig `

   David Tod Sigafoos  ( O O )

___oOOo__( )__oOOo___

   Nothing  in  the  world  is more dangerous than sincere ignorance and
   conscientious stupidity. -- Martin Luther King, Jr. (1929-1968)
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe

Re[2]: [U2] access to mvBase VTF files

2008-09-16 Thread David Tod Sigafoos
   Tony,

   Funny thing about consultants .. first thing they want to do is write a
   program instead of finding a pre-existing solution.

   IF there were a way to move data from one environment to another without
   charging the client more money just to show off my brilliance that would be
   the best thing for the client (saving money and getting good results) and
   myself (why re invent the wheel .. i know i am smart i don't need to prove
   it to myself again).

   If there is no such thing then the simple answer would be .. nope .. there
   is no such thing.  No one has ever done it .. set up a 300 baud line and
   just serialize the data from one box to the next G

   Thanks

   Saturday, September 13, 2008, 5:06:37 PM, you wrote:

From: David Tod Sigafoos

My higher goal is to move data from mvBase to

uniVerse. Account save / account restore

What I want is information on if this can be done simply.

I can, as ray suggested, read the tape OR i can simply

stream in the file and try to restore on my own.

   TG [flame jacket in hand]

   TG Moving data isn't a goal, it's a tactical effort to satisfy some

   TG more strategic business function.  I'm still curious as to why

   TG you need to move data using platform-specific media.  I find that

   TG the real answer to problems we see presented here is frequently

   TG that the wrong question is being asked.  And while I know there

   TG can be some resentment when I question why someone is asking for

   TG a specific solution, that line of inquiry frequently leads to

   TG saving a lot of time and money in accomplishing the real

   TG strategic goal.  Seriously, I deal with this all the time.

   TG The only valid case I can think of for your inquiry is that you

   TG have an old VTF and the source system no longer exists - maybe a

   TG crash-n-burn where the user wants to move to U2 rather than to

   TG pay for a new mvBASE license.  Fair enough.  If that's the case

   TG then my suggestion is to move the data into a live mvBASE system

   TG somewhere (which you can get for free from any mvBASE dealer)

   TG and then to extract it out using more conventional means.

   TG The tape mechanisms in all of these platforms was never intended

   TG to be cross-platform.  They're intended to backup and restore

   TG data to a specific platform.  And while we expect to be able to

   TG move data from one shop to another, across operating systems, and

   TG across DBMS releases, many of us have found there are occasional

   TG issues here.  Extract data from these proprietary formats is a

   TG sure way to win geek points, but it's a pointless business effort

   TG considering there are better ways to accomplish the goals.

   TG So I would back up a moment (pun intended I guess) and ask why

   TG you're not writing flat files that can be transported and then

   TG read from the file system?  If the systems are local then you can

   TG simply write to a file in BASIC that's simultaneously accessed by

   TG Universe.  I do that for development all the time with a bunch of

   TG DBMS's.

   TG If the mvBASE system is still up and you want to do this on a

   TG regular basis, I'm guessing the environments are remote and you

   TG want to duplicate one or more accounts from one platform and just

   TG read it somewhere else.  All the File-Save process does is to

   TG select the SYSTEM file, loop through all MD files, loop through

   TG all DICT files, and the copy all the DATA file items in a

   TG proprietary tape buffer format.  I know you could swing that in a

   TG few minutes, using the same type of recursive loop to create

   TG directories and write items as files.  ( I actually have code

   TG like that around here somewhere from an effort where I needed to

   TG extract an entire R83 system over a network via AccuTerm. )

   TG Anyway, I hope you accomplish your goals.

   TG Best,

   TG T

   TG Tony Gravagno

   TG Nebula Research and Development

   TG TG@ remove.pleaseNebula-RnD.com

   TG ---

   TG u2-users mailing list

   TG u2-users@listserver.u2ug.org

   TG To unsubscribe please visit http://listserver.u2ug.org/

   TG __ Information from ESET NOD32 Antivirus, version of

   TG virus signature database 3440 (20080913) __

   TG The message was checked by ESET NOD32 Antivirus.

   TG http://www.eset.com

   --

   DSig `

   David Tod Sigafoos  ( O O )

___oOOo__( )__oOOo___

   Nearly  all  men can stand adversity, but if you want to test a man's
   character, give him power. -- Abraham Lincoln(1809-1865)
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] I need a correlative, just like the correlative...

2008-09-16 Thread David Tod Sigafoos
   Jeff,

   Why not just call a simple DICT program?

   Tuesday, September 16, 2008, 10:46:01 AM, you wrote:

   JS My Pick Pocket Guide fails me.

   JS I can't use an I descriptor (that would be way too easy) and I need to

   JS create a correlative that presents the data in a multivalued field as a

   JS single valued comma delimited list.

   JS The equivalent of this:

   JS 0001: I

   JS 0002: CONVERT(@VM,',',PO.NUMBER)

   JS 0003:

   JS 0004: PO NUMBER

   JS 0005: 30T

   JS 0006: S

   JS Thanks

   --

   DSig `

   David Tod Sigafoos  ( O O )

___oOOo__( )__oOOo___

   I'm frankly sick and tired of the political preachers across this country
   telling me as a citizen that if I want to be a moral person, I must believe
   in A, B, C, and D. Just who do they think they are? And from where do they
   presume to claim the right to dictate their moral beliefs to me?  --  Barry
   Goldwater.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] access to mvBase VTF files

2008-09-13 Thread David Tod Sigafoos
   Tony,

   My higher goal is to move data from mvBase to uniVerse.  Account save /
   account restore

   What I want is information on if this can be done simply.

   I can, as ray suggested, read the tape OR i can simply stream in the file
   and try to restore on my own.

   Thanks

   Wednesday, September 10, 2008, 11:39:03 PM, you wrote:

Can uniVerse read and optionally create a VTF accessible

to/from mvBase.  The big bit is to read in ..

   TG David - I can't tell what your higher goal is from your question.

   TG If you want to exchange data synchronously or asynchronously

   TG between Universe and mvBASE (or any other MV environment), have a

   TG look at this blog entry:

   TG removepleaseNebula-RnD.com/blog/tech/mv/2008/02/cross-mv01.html

   TG That doesn't provide all the details, but in short, you can

   TG read/write between any local or remote environments with normal

   TG BASIC OPEN/READ/WRITE and some networking setup to move the data

   TG around.

   TG As usual, if you want a solution, just ask.  Do I give away

   TG complex solutions?  No, I write code for a living just like

   TG anyone else here.  So yes, consider this an AD.  Sigh.

   TG Regards,

   --

   DSig `

   David Tod Sigafoos  ( O O )

___oOOo__( )__oOOo___

   'Politics is like driving. To go backward, put it in R. To go forward, put
   it in D' unknown
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] access to mvBase VTF files

2008-09-10 Thread David Tod Sigafoos
   Can uniVerse read and optionally create a VTF accessible to/from mvBase.

   The big bit is to read in ..

   Thanks

   --

   DSig `

   David Tod Sigafoos  ( O O )

___oOOo__( )__oOOo___

   If by Liberal they mean someone who looks ahead and not behind, someone
   who welcomes new ideas without rigid reactions, someone who cares about the
   welfare of the people -- their health, their housing, their schools, their
   jobs, their civil rights, and their civil liberties -- someone who believes
   we  can break through the stalemate and suspicions that grip us in our
   policies abroad, if that is what they mean by a Liberal, then I'm proud to
   say I'm a Liberal.  - John Fitzgerald Kennedy
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] ouch

2008-07-09 Thread David Tod Sigafoos
Roger,

Nothing to fix this specific problem.

For the future, I have implemented triggers on source tables which
archive out data and creates a header record for date/time info.
This allow reporting on changes and be able to retrieve source that
has gone missing.

On development tables you do need to clean out the archives as they
grow.  But comes in handy.

Tuesday, July 8, 2008, 12:35:17 PM, you wrote:

ron We just had something chew up two source programs today.   We
ron have restored from yesterday, but that still means 4-5 lost
ron hours.   And the programmer is one of those young guys that works
ron directly to/from the screen rather then pencil scribling like this old 
timer.

ron He still has the latest version of object.  Is there a
ron quick/free way to look at his object code and remind him of the program 
structure?




-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

...our behavior matters more than the beliefs that we  profess. Elizabeth 
Deutsch Earle
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] testing

2007-12-29 Thread David Tod Sigafoos
Bill,

g probably depends on what 'lose me' means g

Friday, December 28, 2007, 2:32:14 PM, you wrote:

BH Doug:

BH A direct quote from Wol; My preference is for email, which is why I'm 
here, not
there! (and if this became a forum, you'd probably lose me.)

BH My apologies if I've misunderstood his meaning.

BH Bill

-Original Message-
From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED] On Behalf Of doug chanco
Sent: Friday, December 28, 2007 2:06 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] testing

I for one did not notice any if you don't playing our way go home in 
his email.  All he said is that if you prefer using  a forum why are you 
subscribed to email when a forum is available on u2ug (at least that how 
I read his email)

BH [snipped]

Bill Haskett wrote:
 Wol:

 I just don't get this attitude.  Why is it necessary to pick up our toys 
 and go
BH home?
 To say, if you don't do things my way I'm quitting the team?  There are 
 too many
 postings that forswear any solution that doesn't result in a complicated 
 mess of
 things.


-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

Freedom is never more than one generation away from extinction. We didn't pass 
it to our children in the bloodstream. It must be fought for, protected, and 
handed on for them to do the same, or one day we will spend our sunset years 
telling our children and our children's children what it was once like in the 
United States where men were free. ~ Ronald Reagan ~
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] testing

2007-12-27 Thread David Tod Sigafoos
MAJ,

Of course a simpler method would to be for users to use a email client
that can perform threading .. even may web based ones can do that

Of course if people don't read first nothing can help

DSig

Monday, December 24, 2007, 10:28:42 AM, you wrote:

MP Perhaps this is why this forum may like a single thread  method (like
MP Raining Data's D3, Mvbase etc).

MP 5 of the responses were identical to the Phantom on Universe question and
MP PH answer.

MP Had the first reply said PH, the other four would have already seen PH
MP and not bothered. This ain't a quiz and with everyone complainig about
MP bandwidth, cycles and extraneous email clutter, this would be a great step
MP in the reduction of all

MP Have a Merry Christmas.

MP My 1 cent
MP Mark Johnson
MP - Original Message -
MP From: Perry Taylor [EMAIL PROTECTED]
MP To: u2-users@listserver.u2ug.org
MP Sent: Monday, December 24, 2007 12:56 PM
MP Subject: Re: [U2] testing


 Output is saved to the PH file. Include the SQUAWK keyword in your
MP PHANTOM
 command to get the specific item I'd

 Perry

 - Original Message -
 From: [EMAIL PROTECTED]
MP [EMAIL PROTECTED]
 To: u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org
 Sent: Mon Dec 24 11:39:00 2007
 Subject: RE: [U2] testing

 A wonderous and happy holidays to all!

 If anyone happens to be reading this list , I do have one universe
 phantom question

 Is there anyway to see what a phantom did?  At my last job there was a
 way to see phantom output (it wrote to a phantom log file, if you
 started the phantom with logging)

 Hopefully there is something similar in universe (10.1)

 Thanks,

 Dougc

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of gerry-u2ug
 Sent: Monday, December 24, 2007 10:34 AM
 To: u2-users@listserver.u2ug.org
 Subject: [U2] testing

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

 --
 This message has been scanned for viruses and
 dangerous content by SecureMail, and is
 believed to be clean.
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 To unsubscribe please visit http://listserver.u2ug.org/

 CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is
MP for
 the sole use of the intended recipient(s) and may contain confidential and
 privileged information.  Any unauthorized review, use, disclosure or
 distribution is prohibited. ZirMed, Inc. has strict policies regarding the
 content of e-mail communications, specifically Protected Health
MP Information,
 any communications containing such material will be returned to the
 originating party with such advisement noted. If you are not the intended
 recipient, please contact the sender by reply e-mail and destroy all
MP copies of
 the original message.
 ---



-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

Nearly all men can stand adversity, but if you want to test a man's character, 
give him power. -- Abraham Lincoln(1809-1865)
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] Over-coming EDitor shortcomings

2007-10-15 Thread David Tod Sigafoos
MAJ,

Does Accuterm work under WINE (though not sure why anyone would want
to use Accuterm G)

Monday, October 15, 2007, 6:07:04 AM, you wrote:

SNIP
MP I don't argue the stability or anything supporting the use of unix as a
MP desktop OS. But in this case, it loses if it cannot use Accuterm.



-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

Our greatest duty in this life is to help others. And please, if you
can't help them, could you at least not hurt them? - H.H. the Dalai
Lama
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] Linux Intercall library

2006-10-12 Thread David Tod Sigafoos
 Is there a Intercall library for Linux?

 If so .. where can i find it

 If not how is the same functionality achieved?

SB Yes

SB I seem to remember the Intercall manual tells you how.

hmmm .. i don't recall it there but will look again today.

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


[U2] Linux Intercall library

2006-10-11 Thread David Tod Sigafoos
Is there a Intercall library for Linux?

If so .. where can i find it

If not how is the same functionality achieved?

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


Re: [U2] Unidata logging of BASIC Runtime errors

2006-05-10 Thread David Tod Sigafoos
Bill,

of course the flip side is .. why request something that you know you
aren't going to get.

Ah .. Unidata .. the ugly stepchild G

Wednesday, May 10, 2006, 3:07:05 PM, you wrote:

BH Dave:

BH UniData does not have logging for BASIC runtime errors (IBM got back with me
BH on this).  There aren't enough requests for this feature to include it in
BH UniData.  :-(



-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

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.  Theodore Roosevelt
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] Basic statement

2006-03-22 Thread David Tod Sigafoos
Ross,

only a victim if you want to be or believe yourself to be 'victim'

(i knew the new listserver rules were a conspiracy to get me) rotfl

dsig

Tuesday, March 21, 2006, 3:34:08 PM, you wrote:

RF Another victim of the new list and not doing a reply all :-(

RF Ross Ferris
RF Stamina Software
Visage  Better by Design!

-Original Message-
From: [EMAIL PROTECTED] [mailto:owner-u2-
[EMAIL PROTECTED] On Behalf Of Barry Rogen
Sent: Wednesday, 22 March 2006 4:34 AM
To: Stevenson, Charles
Cc: u2-users@listserver.u2ug.org
Subject: RE: [U2] Basic statement

   Buy  that man a drink - that is exactly what it was.
There was an $Include that contained an equate statement
that equated  CALL.TRANS.WRITE.SUB TO 'CALL subroutine'

Excellent job Charles  and much thanks 


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: Stevenson, Charles [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 21, 2006 11:48 AM
To: Barry Rogen
Subject: RE: [U2] Basic statement

ten chances out of nine  there is an $INCLUDE that has an EQUATE buried
in it:

   EQUATE CALL.TRANS.WRITE.SUB LIT CALL *TRANS.WRITE.SUB( FILE.VAR,
RF ID,
REC )

If this is universe, compile with -L option  look at the listing.
and do a VLIST to see what this actually compiles to.

cds

 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of Barry Rogen
 Sent: Tuesday, March 21, 2006 7:55 AM
 To: u2-users@listserver.u2ug.org
 Subject: [U2] Basic statement

To all,

  We have 'new' programs from a package I need now
 support. There is a Basic statement that I have never seen in
 my 20+ years.  Hopefully, one can shed a little light for me...

 CALL.TRANS.WRITE.SUB   (that's a dot tween  CALL and TRANS
 not a space)

 I search everywhere for it being a custom entity and found so
 such clue.
 This
 led me to assume that it had to be a Pick Basic command
 format that I am just
 unfamiliar with.   Any thoughts are, as always, very appreciated.


 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
 




 NOT INTENDED AS A SUBSTITUTE FOR A WRITING

 NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY
 BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A
 BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR
 ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS,
 NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC
 TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE
 OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT.  THIS EMAIL
 MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO
 REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A
 CONTRACT.  NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF
 WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL
 ALTER THIS DISCLAIMER.

 This e-mail message from PNY Technologies, Inc. is for the
 sole use of the intended recipient(s) and may contain
 confidential and privileged information.
 Any unauthorized review, use, disclosure or distribution is
 prohibited. If you are not the intended recipient, please
 contact the sender by reply e-mail and destroy all copies of
 the original message.
 ---
 u2-users mailing list
 u2-users@listserver.u2ug.org
 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/
RF ---
RF u2-users mailing list
RF u2-users@listserver.u2ug.org
RF To unsubscribe please visit http://listserver.u2ug.org/


RF __ NOD32 1.1454 (20060321) Information __

RF This message was checked by NOD32 antivirus system.
RF http://www.eset.com




-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

a pirate walks into a bar with a steering wheel hanging out of his zipper. The 
bartender says doesn't that hurt?'arrr.. it's drivin' me nuts!' -Subweird
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] connection within UniVerse and Oracle

2006-03-01 Thread David Tod Sigafoos
I think i would only use vb.net IF there was something specific that
the uv odbc connection does not provide.

I have found that for most applications the ODBC connection is not too
slow and for most MV guys it is much easier and faster to learn the
vb.net.

And the price is right ..

Tuesday, February 28, 2006, 5:52:52 PM, you wrote:

MR Depending on what you are trying to do,  ODBC (slow and awkward IMO) or a
MR VB/VB.Net program that can easily access both databases would be a
MR very easy
MR way to go about it.  You would need uniobjects or Redback to connect to
MR Universe.  

MR Again, depending on your goals, there are some tools out there like the
MR stuff from ON Corp.   

MR HTH

MR Mike R.

MR -Original Message-
MR From: [EMAIL PROTECTED]
MR [mailto:[EMAIL PROTECTED] On Behalf Of
MR [EMAIL PROTECTED]
MR Sent: Monday, February 27, 2006 11:21 PM
MR To: u2-users@listserver.u2ug.org
MR Subject: [U2] connection within UniVerse and Oracle

MR I am trying to establish a connection between UniVerse 10.1 ( aix unix )
MR and Oracle (Window 2003), has anyone done this before? I was told to 
MR either use socket connection or ODBC. It seems that it is not that easy to
MR use socket connection talking to Oracle, so I am thinking of using ODBC?
MR Any ideas. Thanks.


-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

Jazz isn't dead, it just smells funny - Frank Zappa
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2][UV] Universe and SQL Server

2006-02-03 Thread David Tod Sigafoos
Nick,

Thursday, February 2, 2006, 1:41:23 PM, you wrote:

NC Hello all,

NC We are currently looking into ways to share our data between
NC universe and SQL Server, and I am trying to get some suggestions
NC on the best way to do this.  We are currently generating text
NC files in UV and ftp'ing those files to a designated location.  We
NC have a task scheduler that picks up the files when they arrive and
NC inserts them into SQL server.  I know there are ways to
NC communicate directly between SQL server and Universe and I am
NC looking for the best way to do this.  It doesn't matter if
NC Universe reaches out to SQL Server or vice versa.  Thanks.

I think you will find the BCI client of Universe to be very good at
the communication to SqlServer.  Last year I worked with a client who
needed the same type of communication.  We developed a couple of
routines they could use to 'read/write' SqlServer with minimal
interference with the Universe developers.

It turned out faily well .. quick and error free.

There really is no need to go to any 'external middleware' answer when
all the tools are right there. It lowers maintenance as your
developers don't need to learn anything new (although that IS always
fun).

Give it a try .. ask questions here.

-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

'Politics is like driving. To go backward, put it in R. To go forward, put it 
in D' unknown
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UD] Best practices

2006-01-28 Thread David Tod Sigafoos
Bill,

Friday, January 27, 2006, 12:24:47 PM, you wrote:

BH I've been converting dictionaries from a D3 dbms and am wondering what is
BH considered best practices in virtual attribute design.

BH Does one build standard Direct fields first then use these fields to build
BH virtual attributes (I-Descriptors) or should one use the direct field
BH references, EXTRACT() or n,n,n, in virtual attributes?

BH DEPOSITED
BH 001 D The date of the deposit.
BH 002 2

BH VOID
BH 001 D Is this a voided receipt?
BH 002 12

BH DEPDATE
BH 001 I The displayed deposit date (if not voided).
BH 002 IF VOID =  THEN DEPOSITED ELSE *Voided*

BH or

BH DEPDATE
BH 001 I The displayed deposit date (if not voided).
BH 002 EXTRACT( @RECORD, 2, 0, 0 ) ; EXTRACT( @RECORD, 12, 0, 0 ) ;
BH IF @2 =  THEN @1 ELSE *Voided*

BH The obvious concern is if a direct field definition is renamed, then all
BH references to the old field name need to be changed.  I rarely rename a
BH field, until I started exposing the data to other data sources and was
BH forced to clean up the field names.  So, hopefully, this won't be an issue
BH in the future.

I would go with using the dict names .. that is the beauty of the
dictionary . that you don't have to hardcode a position in.

And if some idiot deletes 'VOID' then they get what they deserve.  It
is better documented using name and should be a 'required' practice in
a shop. AND if for some reason you want to restructure the table then
there are no worries ..

always with the right opinion .. your buddy

-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] Converting Jbase Code into Universe

2006-01-26 Thread David Tod Sigafoos
Perry,

Thursday, January 26, 2006, 7:05:20 AM, you wrote:

PT John,

PT We converted from jBASE about 6 months ago and had to deal with this.
PT Here's a user-defined function which performs just like the jBASE
PT GETENV() function.

snip

thanks .. that's a keeper

-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

Cannot open file C:\DOCUMENTS AND SETTINGS\DAVID TOD SIGAFOOS\APPLICATION 
DATA\BATMAIL\COOKIES.TXT
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] [OT] Travels with Mark: A Hitchhiker's Guide to the UniVerse, Part 1: Profiling the UniVerse

2005-12-28 Thread David Tod Sigafoos
another alternative is to join the lines and go to the url

Wednesday, December 28, 2005, 2:57:09 AM, you wrote:

AP snip

 http://www-128.ibm.com/developerworks/edu/dm-dw-dm-0512baldridge-
 i.html?S_TACT=105AGX11S_CMP=FP


AP A little tip for posting long URLs. As some mail clients may wrap this
AP URL making it unclickable, surrounding the entire hyperlink in  and
 should helplike this:

AP 
http://www-128.ibm.com/developerworks/edu/dm-dw-dm-0512baldridge-i.html?S_TACT=105AGX11S_CMP=FP

AP Another alternative would be use www.notlong.com and convert the long
AP URL to a short one such as myshorturl.notlong.com.




-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

Should any political party attempt to abolish social security, unemployment 
insurance, and eliminate labor laws and farm programs, you would not hear of 
that party again in our political history. There is a tiny splinter group, of 
course, that believes you can do these things.  Among them are a few Texas oil 
millionaires, and an occasional politician or business man from other areas. 
Their number is negligible and they are stupid.  --President Dwight D. 
Eisenhower, 1954 (source:  Eisenhower Presidential Papers, Document #1147; 
November 8, 1954 The Papers of Dwight David Eisenhower, Volume XV - The 
Presidency: The Middle Way Part VI: Crises Abroad, Party Problems at Home; 
September 1954 to December 1954,) Chapter 13: A new phase of political 
experience
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] UD: Named common

2005-12-28 Thread David Tod Sigafoos
Bill,

real programmers don't compile in PICK mode .. or use PICK .. they
just scale back the expectations G

Tuesday, December 27, 2005, 8:19:42 AM, you wrote:

BH Of course, programs won't compile in PICK mode if the label exceeds 7
BH characters.  :-)

 -Original Message-
 From: [EMAIL PROTECTED] 
 [mailto:[EMAIL PROTECTED] On Behalf Of 
 David Wolverton
 Sent: Tuesday, December 27, 2005 4:58 AM
 To: u2-users@listserver.u2ug.org
 Subject: RE: [U2] UD: Named common
 
 I probably should have been more clear -- that's why we 
 rearranged and put our 'most unique' details at the front of 
 the Named Common block -- but ulimately, we truncated all at 
 7 characters.
 
 DW 
 
 -Original Message-
 
 In terms of readability/maintainability, the named common 
 label can be 
 more
 than 7 characters, however - the first 7 must be unique in 
 your application (or much confusion can reign... :-(  )
 


-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

...our behavior matters more than the beliefs that we  profess. Elizabeth 
Deutsch Earle
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] UD: Named common

2005-12-28 Thread David Tod Sigafoos
Keith,

Wednesday, December 28, 2005, 7:24:34 AM, you wrote:

 And if you're using an include to bring in the named common, what's
 the big deal anyway?  Okay, so the named common name can't be larger
 than 7 characters.  Frankly, the 7 is a little weird (3 bits?) but
 considering we have so few limitations anyway and this one is so
 easily worked around for most apps, I just don't see anything of real
 concern. 
 

KWR Pooh!  A stupid (and antediluvian) restriction is still stupid (and
KWR antediluvian) even if it can be worked around. :)


 bravo ..

 our customers expect a certain level of professionalism from use ..
 not bad if we expect the same from out vendors

-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

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. Theodore Roosevelt
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] UD: Named common

2005-12-27 Thread David Tod Sigafoos
David,

you are of course right.  I am not sure what Bill is thinking.  I am
still wondering why we are staying with file names 8.3.  Come on folks
how many characters do you need.

Most MV devs know that vars only need a couple of characters .. I, II,
III etc.

there is way too much typing going on here


Monday, December 26, 2005, 7:21:03 PM, you wrote:

DW At this moment and time, that would be true... But how many unique
DW combinations of 7 characters can be created? 26 to the 7th power? (if we
DW exclude numerics, anyway!)  So far, 8 billion+ choices has been enough
DW leeway for us to work within - But it is a hard limit -- we just truncated
DW our Common Group labels to meet the requirement, and moved the 'unique'
DW attributes to the FRONT of the common block labels.

DW DW

DW -Original Message-
DW From: [EMAIL PROTECTED]
DW [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett
DW Sent: Monday, December 26, 2005 9:05 PM
DW To: u2-users@listserver.u2ug.org
DW Subject: [U2] UD: Named common

DW Is it true UniData named common cannot have a label longer than 7
DW characters?  Is this a paleozoic joke or is it a PICK basic type thing?
DW Onward  Upward.  :-)

DW Thanks.  


-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

Should any political party attempt to abolish social security, unemployment 
insurance, and eliminate labor laws and farm programs, you would not hear of 
that party again in our political history. There is a tiny splinter group, of 
course, that believes you can do these things.  Among them are a few Texas oil 
millionaires, and an occasional politician or business man from other areas. 
Their number is negligible and they are stupid.  --President Dwight D. 
Eisenhower, 1954 (source:  Eisenhower Presidential Papers, Document #1147; 
November 8, 1954 The Papers of Dwight David Eisenhower, Volume XV - The 
Presidency: The Middle Way Part VI: Crises Abroad, Party Problems at Home; 
September 1954 to December 1954,) Chapter 13: A new phase of political 
experience
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] T-DUMP

2005-12-26 Thread David Tod Sigafoos
Bill,

did you ever get your question answered ??

if not drop me an email with environment information (i don't have
your original email) and will look it up

DSig

Sunday, December 25, 2005, 7:51:13 PM, you wrote:

BH Kate:

 -Original Message-
 From: [EMAIL PROTECTED] 
 [mailto:[EMAIL PROTECTED] On Behalf Of Kate Stanton
 Sent: Saturday, December 24, 2005 6:50 PM
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] T-DUMP
 
 Is there any reason why you can't make a DOS (UV type 19) 
 file out, move it around however you like, and read it back into UD?Kate:

BH Some data can be copied this way.  However, when record keys are moved to a
BH type 19 DOS file they're changed from, for example, 192*16 to 192%A16; which
BH is a real pain.  Most of our software is upgraded from within the mvDbms
BH environment, as we do this simply by building all changes into a single file
BH with a key of [DICT*]FileName*ItemID; old standard PICK stuff.

BH But without T-DUMP/T-LOADs, this process needs to be reengineered and all
BH kinds of issues arise.  Most of our customers no longer have either tape
BH drives or floppies and do backups to other drives and C/Ds and DVDs.  What
BH used to be simple is now becoming a convoluted mess.  Oh well, that's what
BH it's like working with 1980 technology.  :-(

BH So, now I have to copy some stuff via DOS files and some via wIntegrate.
BH Anyway, thanks for the ideas.





-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

...our behavior matters more than the beliefs that we  profess. Elizabeth 
Deutsch Earle
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] sql server universe {Unclassified}

2005-11-23 Thread David Tod Sigafoos
Mike

hmm .. if i had been having a problem this might work.  But i find it
best to have the dictionaries actually define the data.  So if/when we
find something like this we simply run a routine against the data
which lets us note and redefine as necessary.

DSig

Tuesday, November 22, 2005, 8:17:44 PM, you wrote:

HMM David, 

 -Original Message-
 From: [EMAIL PROTECTED] On Behalf Of David Tod
HMM Sigafoos
 Sent: Wednesday, 23 November 2005 16:06
 To: Daniel Perttula
 Subject: Re: [U2] sql server  universe
 
 Daniel,
 
 SQL is pretty insistent on data being what it is defined as 
 (a feature for some .. a drawback for others)
 
 Your best bet is to make your dictionaries match the data.  
 Not sure I would actually make the fields lenght 999 but 
 instead write a routine to examine the data and let you know 
 the best size to make it.  

HMM Doesn't HS.SCRUB do this for you?  Then you can describe the data
HMM correctly in Attribute 10.

HMM Or

HMM Leave that attribute blank [except for fields which need correct
HMM description like DATE, or DECIMAL 12,2] and describe everything else on
HMM the SQL side as VARCHAR(255)

HMM HTH

HMM Mike


 If 13 char is the longest(in this case) then smudge to 14 if you 
 think the data will change to that.
 
 Tuesday, November 22, 2005, 3:40:56 PM, you wrote:
 
 DP Hello all - quick question for the SQL gurus out there, we have a 
 DP customer using SQL Server 2000 making queries to a UV 10.1.11 
 DP server. We've noted that SQL Server errors out if the data in any 
 DP field matches or exceeds the field length specified in the field 
 DP dictionary. For example if we have a
 DP dictionary:
 
 DP WIDGET.PRICE
 DP 1 A
 DP 2 100
 DP 3 WIDGET PRICE
 DP 4
 DP 5
 DP 6
 DP 7 MD2
 DP 8
 DP 9 R
 DP 10 12
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] sql server universe

2005-11-22 Thread David Tod Sigafoos
Daniel,

SQL is pretty insistent on data being what it is defined as (a feature
for some .. a drawback for others)

Your best bet is to make your dictionaries match the data.  Not sure I
would actually make the fields lenght 999 but instead write a routine
to examine the data and let you know the best size to make it.  If 13
char is the longest(in this case) then smudge to 14 if you think the
data will change to that.

Tuesday, November 22, 2005, 3:40:56 PM, you wrote:

DP Hello all - quick question for the SQL gurus out there, we have a customer
DP using SQL Server 2000 making queries to a UV 10.1.11 server. We've noted
DP that SQL Server errors out if the data in any field matches or exceeds the
DP field length specified in the field dictionary. For example if we have a
DP dictionary:

DP WIDGET.PRICE
DP 1 A
DP 2 100
DP 3 WIDGET PRICE
DP 4
DP 5
DP 6
DP 7 MD2
DP 8
DP 9 R
DP 10 12

DP and the length of the data is 12 or higher (like if the widget price was
DP 9.99), this will cause the SQL Server query to fail with a data
DP value overflowed the data type used by the provider error. We are
DP considering bumping the field lengths for all of our ODBC field dictionaries
DP up to 999 or higher just to avoid these errors. Are there any negatives to
DP doing this, specifically could it cause problems for SQL Server? Or is there
DP another way to handle this (like a query option or switch or ??)

DP Any help or suggestions would be appreciated!
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UV] SQL Server Data Access

2005-10-28 Thread David Tod Sigafoos
Sunny,

SM I know this may have discussed before but has anyone developed a VB
SM interface between SQL Server and UV.

what kind of 'interface' are you looking for?  UV has a connection
that works well with SqlServer so possibly before we get a lot of code
generated you describe better what exactly you are looking to do

-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2][UV] UPS rate calculator

2005-10-27 Thread David Tod Sigafoos
JH Has anyone directly integrated UPS's online shipping rate calculator
JH service and/or address verification with UV?

Not the rate calculator but the USPS 'shipping label' process.  It was
pretty simple once we got on line and talked through our understanding
of their documentation G.


-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2][UV] UPS rate calculator

2005-10-27 Thread David Tod Sigafoos
Peter,

thanks .. but as i noted we did the labeling bit (in universe).
Worked well ..


Thursday, October 27, 2005, 8:19:43 AM, you wrote:

PG I actually wrote the entire UPS host manifest system in Unidata. It is
PG integrated with our custom programs. We get a UPS label, Summary label,
PG tracking details, summary reports and a file to send to UPS for billing.
PG The only feature that we don't use is international service codes.  We
PG create over 1,000 labels a day. It has been working for over 4 years. Let
PG me know if you need any assistance.

PG At 07:38 AM 10/27/2005 -0700, you wrote:
JH Has anyone directly integrated UPS's online shipping rate calculator
JH service and/or address verification with UV?

Not the rate calculator but the USPS 'shipping label' process.  It was
pretty simple once we got on line and talked through our understanding
of their documentation G.



-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

Cannot open file C:\DOCUMENTS AND SETTINGS\DAVID TOD SIGAFOOS\APPLICATION 
DATA\BATMAIL\COOKIES.TXT
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [SPAM] RE: [U2] Bad news from Microsoft

2005-10-24 Thread David Tod Sigafoos
and a 256 user pack brings costs to approx $26/connection


dsig

Monday, October 24, 2005, 10:52:04 AM, you wrote:

R George,
R  If we are looking at lower deploy costs, OpenInsight can deploy 
R single users for free off of a developers license and still be 100% legal.

R - Chuck Legal Barouch

R George Smith wrote:

Don,
I am not only now seeing this as a threat the question is when and if
IBM, Raining Data and jBase will help developers meet the threat? Below
is a posting on jBase's list server and I might add that jBase per port
cost is lower than IBM's (I am not advocating jBase just pointing that
he cost is
higher).
grs
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] the 4 letter word

2005-10-04 Thread David Tod Sigafoos
Mark,

Monday, October 3, 2005, 8:08:26 PM, you wrote:

MJ Being one of the most (four letter word) supporters (probably because I
MJ understand how to use it properly), notice I didn't bring it up.

they always think 'they' know how to use it G


-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

When i'm good, i'm good.  When i'm bad i'm even better Mae West
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: AW: [U2] Good Programming Practice Question.........

2005-09-29 Thread David Tod Sigafoos
Serguei,

Thursday, September 29, 2005, 8:04:07 AM, you wrote:

S There is no reason to lock details if the header is locked (you would not
S want two users to modify the same invoice). So the correct procedure is not
S to lock details at all.

'... So the correct procedure ...' G

What problem does this cause?  IF the locks are placed and removed
correctly there is no problem.  I would agree that it is easier to
simply lock the header but only if you can guarantee that this will
IN ALL SITUATIONS handle the entire set.  Should be .. could be ..
maybe ..

Sometimes, as a consultant, I might do this (belt and suspenders)
because of the state of the code and programming style that the
'employees' (monkeys) have exibited in the system does not give me any
confidence that they will correctly respect lock 'sets' that way.

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


[U2] Lower case in Unidata basic

2005-09-27 Thread David Tod Sigafoos
u2-users,

I have looked for archives at u2ug.org but not found them .. (must be
blind)

I have downloaded pdfs from IBM but i keep getting Universe ..

so I will just ask and take the deserved harassment G

is there a udt.option that allows you to use lower case in unidata
programs?

thanks .. and if anyone has a pointer to the unidata pdfs i would like
it ..


  

-- 
DSig
David Tod Sigafoos

'Politics is like driving. To go backward, put it in R. To go forward,
put it in D' unknown
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Lower case in Unidata basic

2005-09-27 Thread David Tod Sigafoos
David,

just for the info ..

BASIC FILE ITEM -I

is how to compile a program containing lower case.


Tuesday, September 27, 2005, 12:19:21 PM, you wrote:

DTS u2-users,

DTS I have looked for archives at u2ug.org but not found them .. (must be
DTS blind)

DTS I have downloaded pdfs from IBM but i keep getting Universe ..

DTS so I will just ask and take the deserved harassment G

DTS is there a udt.option that allows you to use lower case in unidata
DTS programs?

DTS thanks .. and if anyone has a pointer to the unidata pdfs i would like
DTS it ..


DTS   




-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

'Politics is like driving. To go backward, put it in R. To go forward, put it 
in D' unknown
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] Lower case in Unidata basic

2005-09-27 Thread David Tod Sigafoos
Clifton,

i posted in a different reply .. i found in the new docs (thanks to
the links i was given) (at same time as my good buddy Dan Fitzgerald
emailed me)

BASIC file item -I

of course this does you no good with FIB from the editor .. but hey
part of a solution is good enough for me G

No very sophisticated .. but 'green screen' 'pickies' wouldn't know
what to do if they counldn't shout at their monitors all day G

Tuesday, September 27, 2005, 3:02:30 PM, you wrote:

CO And what is the short answer? Can you or can you not use lower case  
CO keywords in Unidata BASIC these days?

CO Thx.





-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

'Politics is like driving. To go backward, put it in R. To go forward, put it 
in D' unknown
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] Good Programming Practice Question.........

2005-09-27 Thread David Tod Sigafoos
 visit http://listserver.u2ug.org/
BL ---
BL u2-users mailing list
BL u2-users@listserver.u2ug.org
BL To unsubscribe please visit http://listserver.u2ug.org/


BL __ NOD32 1.1234 (20050927) Information __

BL This message was checked by NOD32 antivirus system.
BL http://www.eset.com




-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

...our behavior matters more than the beliefs that we  profess. Elizabeth 
Deutsch Earle
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] Good Programming Practice Question.........

2005-09-27 Thread David Tod Sigafoos
Jerry,

Tuesday, September 27, 2005, 3:09:02 PM, you wrote:

JB Ugh! My personal preference. The only reason I use mixed case is for 
JB comments. With Universe differentiating between case (OrderRec is not 
JB orderrec or ORDERREC) you have to remember the way you mixed the case.

you should be able to remember what vars you used .. it becomes habit
.. just like THIS BECOMES A HABIT.

JB Also, it makes it easier to recognize the comment lines in the
JB code.

a good editor with syntax highlighting makes recongizing comments even
easier

JB When modifying code if you can't re-write the program always use the same
JB standard used in the existing program otherwise it gets confusing to the
JB next programmer that picks up the program.

true .. when you are making changes .. but new stuff can start a new
trend.  we used to use punch cards .. but I moved on .. and if I can
move on then anybody can G

-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [OT]RE: Re[2]: [U2] Good Programming Practice Question.........

2005-09-27 Thread David Tod Sigafoos
Dan,

Tuesday, September 27, 2005, 3:39:21 PM, you wrote:

true .. when you are making changes .. but new stuff can start a new
trend.  we used to use punch cards .. but I moved on .. and if I can
move on then anybody can G


DF You don't use punch cards? How do you make your programs run?


i send them to my guru buddies and let them make them run ..


-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

...our behavior matters more than the beliefs that we  profess. Elizabeth 
Deutsch Earle
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] Lower case in Unidata basic

2005-09-27 Thread David Tod Sigafoos
Laura,

what .. Lee is still around .. who would've guessed G

Tuesday, September 27, 2005, 5:22:05 PM, you wrote:

LH David, and U2-Users:

LH There is now a link on the u2ug.org home page to the IBM documentation page.
LH It's in the column at the left. In addition, you'll also now find a direct
LH link to the searchable archives (BTW, thanks to Lee Leitner and Infocus for
LH providing this service). We really want to make the u2ug.org site work for
LH the group, so any other ideas, suggestions, or contributions would be great!
LH And so that we don't clutter up this group, either post your
LH ideas/suggestions in the u2ug Web site design forum, or email me directly.

LH Thanks!
LH Laura Hirsh
LH U2UG Board Member

LH -Original Message-
LH From: [EMAIL PROTECTED]
LH [mailto:[EMAIL PROTECTED] On Behalf Of David Tod Sigafoos
LH Sent: Tuesday, September 27, 2005 3:19 PM
LH To: u2-users@listserver.u2ug.org
LH Subject: [U2] Lower case in Unidata basic

LH u2-users,

LH I have looked for archives at u2ug.org but not found them .. (must be
LH blind)

LH I have downloaded pdfs from IBM but i keep getting Universe ..




-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

...our behavior matters more than the beliefs that we  profess. Elizabeth 
Deutsch Earle
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] Looking for CheckIn CheckOut

2005-09-13 Thread David Tod Sigafoos
Tony,

Monday, September 12, 2005, 12:40:36 PM, you wrote:

TG Hi Dave.  Of course said simple but if it's too simple it may not achieve
TG goals your client has in mind.  You may want to verify their goals and
TG budget, and exactly what simple really means.

I deleted several different replies which all caused me to hear what
Thumpers father would say .. so let me just say

thank you for the reply




-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

...our behavior matters more than the beliefs that we  profess. Elizabeth 
Deutsch Earle
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Looking for CheckIn CheckOut

2005-09-12 Thread David Tod Sigafoos
u2-users,

  my client has asked for a simple CheckIn/CheckOut.  The one I have
  is written specifically for another environment (bad choice but i
  was young) and so i wanted to check here to see if anyone had one
  that they would share before I go to the expense of writing one.  I
  know the client would be much happier G

  TIA

-- 
DSig
David Tod Sigafoos

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. Theodore Roosevelt
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] Looking for CheckIn CheckOut

2005-09-12 Thread David Tod Sigafoos
Allen,

Thanks .. i was looking for something more 'U2' directed.

thanks again

Monday, September 12, 2005, 10:48:38 AM, you wrote:

AEE Hi David,

AEE Just a quick search for 'version control software' yielded 134,000,000 
hits.
AEE This one looked interesting'free' version control software, and there's
AEE a bunch of them.

AEE http://www.thefreecountry.com/programming/versioncontrol.shtml

AEE hth,

AEE Allen


AEE -Original Message-
AEE From: [EMAIL PROTECTED]
AEE [mailto:[EMAIL PROTECTED] Behalf Of David Tod
AEE Sigafoos
AEE Sent: Monday, September 12, 2005 08:06
AEE To: u2-users@listserver.u2ug.org
AEE Subject: [U2] Looking for CheckIn CheckOut


AEE u2-users,

AEE   my client has asked for a simple CheckIn/CheckOut.  The one I have
AEE   is written specifically for another environment (bad choice but i
AEE   was young) and so i wanted to check here to see if anyone had one
AEE   that they would share before I go to the expense of writing one.  I
AEE   know the client would be much happier G

AEE   TIA

AEE --
AEE DSig
AEE David Tod Sigafoos

AEE Far better it is to dare mighty things, to win glorious triumphs even
AEE though checkered by failure, than to rank with those poor spirits who
AEE neither enjoy nor suffer much because they live in the gray twilight
AEE that knows neither victory nor defeat. Theodore Roosevelt
AEE ---
AEE u2-users mailing list
AEE u2-users@listserver.u2ug.org
AEE To unsubscribe please visit http://listserver.u2ug.org/
AEE ---
AEE u2-users mailing list
AEE u2-users@listserver.u2ug.org
AEE To unsubscribe please visit http://listserver.u2ug.org/


AEE __ NOD32 1.1213 (20050909) Information __

AEE This message was checked by NOD32 antivirus system.
AEE http://www.eset.com




-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

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.  Theodore Roosevelt
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: FW: Re[2]: [U2] Connection Problems with Ud6 and UV10

2005-08-16 Thread David Tod Sigafoos
Anthony,

thanks for the reply ..

Tuesday, August 16, 2005, 2:58:24 AM, you wrote:

AY I'm following this well out of date so somebody may have given you the
AY answer ...

nope .. no one has won the silver ring yet g

AY Does the path to where the admin programs are stored contain a space?
AY For example, in Program Files? If so, REINSTALL SOMEWHERE ELSE.

AY I made the mistake of changing the default ( C:\IBM\...) and
AY admin, etc,
AY was promptly screwed up. Everything appeared to work, but it just
AY didn't
AY :-(

g I think i ran into this a long time ago when I first started to
play with Universe at home.  Sadly I am just using the install
defaults.

But you were the first to suggest this ..

thanks

AY -Original Message-
AY From: [EMAIL PROTECTED]
AY [mailto:[EMAIL PROTECTED] On Behalf Of David Tod
AY Sigafoos
AY Sent: 11 August 2005 00:02
AY To: Ron White
AY Subject: Re[2]: [U2] Connection Problems with Ud6 and UV10

AY Ron,

AY Wednesday, August 10, 2005, 1:01:03 PM, you wrote:

RW Launch UniAdmin and select Telnet under the Network services
RW header.  When
RW the screen appears, the first thing on the screen is the desired
RW telnet 
RW port number.
RW After entering your port number, click the stop button to stop the
AY UV 
RW services
RW and then click start to restart them.  If you are accessing UV with
AY a 
RW terminal
RW emulator you will have to change your telnet port setting in the 
RW emulator as well.

AY I start UniAdmin and Local Host shows on the left.
AY The menu items are File, View, COnnect, Admin, Window, Logging and
AY Help

AY Under Admin is Network Services.  Problem is that ALL items under
AY Admin are grayed out.

AY I find that if i use uniadmin on another server those items don't
AY become available until a connection has been made.

AY So is this one of those chicken and egg things G






-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

'Politics is like driving. To go backward, put it in R. To go forward, put it 
in D' unknown
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[8]: [U2] Connection Problems with Ud6 and UV10

2005-08-15 Thread David Tod Sigafoos
Mike,

thanks .. this is on my list to work on this week.  The issue wasn't
resolved but hope putting all the suggestions together will get
something working.

Thanks
Monday, August 15, 2005, 12:19:04 PM, you wrote:

MD David,
MD I have been on vacation so I am not sure if you have resolved
MD this issue.
MD Below is a little snippet from one of our internal docs concerning RPC
MD issues and UniAdmin.  Also, we have found the Windows firewall
MD can cause
MD problems.

MD When trying to log into UniAdmin for UniVerse 10.1 on a Windows
MD 2003 server.
MD This resulted in the ODBC connection getting an invalid user id or
MD password error when trying to connect
MD If RRAS is running it can automatically turn on the firewall and
MD block the
MD port that the RPC service listens on, which is port 31438.
MD UniVerse RPC Service is not tied in with Windows RPC service.
MD So, UniVerse RPC can fail and Windows RPC will still be
MD running.
MD If Windows 2003 is running IIS v6.0 it can interfere with the 
MD RPC port.  To correct it, open IIS and right click on Web
MD Sites.  Click on the Service tab and check the box that says
MD Run WWW service in IIS 5.0 isolation mode.  Then reboot the
MD server.




-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

...our behavior matters more than the beliefs that we  profess. Elizabeth 
Deutsch Earle
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[6]: [U2] Connection Problems with Ud6

2005-08-12 Thread David Tod Sigafoos
colin,

Friday, August 12, 2005, 5:43:48 AM, you wrote:

catc No arguments there. I just thought (like Robert's reply) that you need
catc to see where the problem actually lies. If it's something with the
catc windows firewall preventing the connection or it's XP media
catc edition not
catc letting the DB server work.

catc Can you load another O/S on the laptop (maybe inside of VMWare)? HP is
catc usually pretty good at having recovery CD's so you can get the laptop
catc back to 'how you got it.'

snip

I will probably try that when I get back to the office next week.  It
is just such a PITA sigh .. but then if it was all simple we would
be out of jobs G

thanks

-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] Connection Problems with Ud6 and UV10

2005-08-12 Thread David Tod Sigafoos
Robert,

Friday, August 12, 2005, 1:07:04 AM, you wrote:

RP What problem are we trying to fix at the moment?

snip

This has become 'a' problem.  So many tries .. no hits and who knows
who is on base

So, when i get back to the office on monday I will re-install windows
on the laptop and attempt installation with fresh install.

As for the problems (and they persist)

1) I can not connect through the Intercall api as it returns with RPC not
running.

2) I can not connect through telnet (even after changing ports)  The
Telnet screen comes up and blinking cursor  BUT if I hit return the
cursor drops a line and blinks there.

3) UniAdmin would not connect.  RPC problem again

4) I could connect through 'Dynamic Connect' i think it was called.
It went to the DEMO system so I know the DB is working fine


So there you are .. the basic symptoms .. original and persistent.

Thanks

-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

...our behavior matters more than the beliefs that we  profess. Elizabeth 
Deutsch Earle
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[4]: [U2] Connection Problems with Ud6 and UV10

2005-08-11 Thread David Tod Sigafoos
Bill_H,

Wednesday, August 10, 2005, 4:57:21 PM, you wrote:

B Dave:

B I'm just guessing here but I wonder if there is a registry setting
B inke in
HLM  Software  Informix (or is it IBM)  Universe (or UniData) that sets
B the port for telnet.

I have modified the setting and I know the setting took root as trying
to start the link got message back that it couldn't connect

But when telnet 127.0.0.1 7005 it reacts the same.

This is just so weird .. it only happens on U2 databases.  I have
SqlServer, MySql and others and they work just fine.

Guess i will just need to move to another environment G



-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

Our greatest duty in this life is to help others. And please, if you can't 
help them, could you at least not hurt them? - H.H. the Dalai Lama
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] Connection Problems with Ud6 and UV10 - unmentioned

2005-08-11 Thread David Tod Sigafoos
Chuck,

Thanks for the try .. I have removed UV and UD, then installed UD
only.  Still no connection.

I have turned off as many services as I could and that didn't help.

I can only conclude that there is SOMETHING running on this box that
keeps UV RPC from working.

DSig

Wednesday, August 10, 2005, 10:15:44 PM, you wrote:

KA Sig,
KA  Have you checked for IP port conflicts? I had a similar
KA problem when I had UniVision and UniVerse on the same box. I movedsome IP 
Port assignments and voila!

KA  - Chuck

KA -- Original Message -
KA Subject: Re: [U2] Connection Problems with Ud6 and UV10 - unmentioned
KA   info
KA From: David Tod Sigafoos [EMAIL PROTECTED]

KA From UniAdmin and Intercall client i get 'No RPC Connection Active'
KA (or server from Intercall).  This means that the Intercall client has
KA found the server (127.0.0.1) but that it did not find the RPC service
KA running ..
KA If i try the telnet i just get the blinking cursor.  If i hit enter it
KA moves down a line but blinks ..



-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

When i'm good, i'm good.  When i'm bad i'm even better Mae West
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] Connection Problems with Ud6 and UV10

2005-08-11 Thread David Tod Sigafoos
Ron,

sorry to hear it is empty G  ms telnet is disabled

Thursday, August 11, 2005, 12:42:03 PM, you wrote:

RW David Tod Sigafoos wrote:

Bill_H,

Wednesday, August 10, 2005, 4:57:21 PM, you wrote:

B Dave:

B I'm just guessing here but I wonder if there is a registry setting
B inke in
HLM  Software  Informix (or is it IBM)  Universe (or UniData) that sets
B the port for telnet.

I have modified the setting and I know the setting took root as trying
to start the link got message back that it couldn't connect

But when telnet 127.0.0.1 7005 it reacts the same.

This is just so weird .. it only happens on U2 databases.  I have
SqlServer, MySql and others and they work just fine.

Guess i will just need to move to another environment G



  

RW On my development machine I have the M$ telnet service disabled.  If 
RW yours is
RW still running it will intercept your telnet request before UV
RW sees it.  
RW That is the last
RW idea in my head.  The (head) room is now completely empty. :-)

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


RW __ NOD32 1.1192 (20050811) Information __

RW This message was checked by NOD32 antivirus system.
RW http://www.eset.com




-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

Our greatest duty in this life is to help others. And please, if you can't 
help them, could you at least not hurt them? - H.H. the Dalai Lama
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] Connection Problems with Ud6 and UV10

2005-08-11 Thread David Tod Sigafoos
Ron,

Thursday, August 11, 2005, 12:37:27 PM, you wrote:


RW I don't have any other advise.  I just tried the command telnet 
RW 127.0.0.1 7005 on my
RW development machine and the login prompt appeared immediately.  I
RW don't 
RW have a copy
RW of the personal edition to test with.

I don't know either.  I know that it works well on my desktop back in
Oregon .. maybe it is the california weather ..

The desktop I have it running on is even XP home .. G ..

There just has to be something with HP laptops (2 now) or the XP media
edition ..

THanks for trying

-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

Our greatest duty in this life is to help others. And please, if you can't 
help them, could you at least not hurt them? - H.H. the Dalai Lama
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[4]: [U2] Connection Problems with Ud6 and UV10 - unmentioned

2005-08-11 Thread David Tod Sigafoos
colin,

Thursday, August 11, 2005, 1:01:24 PM, you wrote:

catc With just UniData installed can you use UDT to connect - that
catc will take
catc telnet out of the equation.

true .. but the problem is that connectivity with u6 other requires
telnet and even more importantly RPC ..

Neither of which 'work' though the services say they are running

-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

'Politics is like driving. To go backward, put it in R. To go forward, put it 
in D' unknown
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[6]: [U2] Connection Problems with Ud6 and UV10

2005-08-11 Thread David Tod Sigafoos
Dan,

.. i have even removed my laptop from the network .. rebooted .. no
network ..

still no joy in mudville

Dsig

Thursday, August 11, 2005, 1:02:10 PM, you wrote:

DF Shot in the dark... is there a nat (Network Address Translator)
DF on this 
DF network?



DF Our greatest duty in this life is to help others. And please, if
DF you can't 
DF help them, could you at least not hurt them? - H.H. the Dalai Lama
DF When buying  selling are controlled by legislation, the first
DF thing to be 
DF bought  sold are the legislators - P.J. O'Rourke
DF Dan Fitzgerald




From: David Tod Sigafoos [EMAIL PROTECTED]
Reply-To: u2-users@listserver.u2ug.org
To: Bill_H u2-users@listserver.u2ug.org
Subject: Re[4]: [U2] Connection Problems with Ud6 and UV10
Date: Thu, 11 Aug 2005 11:54:56 -0700

Bill_H,

Wednesday, August 10, 2005, 4:57:21 PM, you wrote:

B Dave:

B I'm just guessing here but I wonder if there is a registry setting
B inke in
HLM  Software  Informix (or is it IBM)  Universe (or UniData) that sets
B the port for telnet.

I have modified the setting and I know the setting took root as trying
to start the link got message back that it couldn't connect

But when telnet 127.0.0.1 7005 it reacts the same.

This is just so weird .. it only happens on U2 databases.  I have
SqlServer, MySql and others and they work just fine.

Guess i will just need to move to another environment G



--
DSig `
David Tod Sigafoos  ( O O )
  ___oOOo__( )__oOOo___

Our greatest duty in this life is to help others. And please, if you can't 
help them, could you at least not hurt them? - H.H. the Dalai Lama
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
DF ---
DF u2-users mailing list
DF u2-users@listserver.u2ug.org
DF To unsubscribe please visit http://listserver.u2ug.org/


DF __ NOD32 1.1192 (20050811) Information __

DF This message was checked by NOD32 antivirus system.
DF http://www.eset.com




-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

When i'm good, i'm good.  When i'm bad i'm even better Mae West
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[4]: [U2] Connection Problems with Ud6 and UV10 - unmentioned

2005-08-11 Thread David Tod Sigafoos
Ken,

Thursday, August 11, 2005, 4:56:18 PM, you wrote:

 I have turned off as many services as I could and that didn't help.
 
 I can only conclude that there is SOMETHING running on this box that
 keeps UV RPC from working.

KW Windows Firewall?

Yes .. BUT if you bring up the security screen it says Firewall on.
Drill down to the setting and it says it is off ..

I am not getting the ' your computer is not protected ' from windows
with makes me think SOMETHING is still working to block actual work ..



-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

Should any political party attempt to abolish social security, unemployment 
insurance, and eliminate labor laws and farm programs, you would not hear of 
that party again in our political history. There is a tiny splinter group, of 
course, that believes you can do these things.  Among them are a few Texas oil 
millionaires, and an occasional politician or business man from other areas. 
Their number is negligible and they are stupid.  --President Dwight D. 
Eisenhower, 1954 (source:  Eisenhower Presidential Papers, Document #1147; 
November 8, 1954 The Papers of Dwight David Eisenhower, Volume XV - The 
Presidency: The Middle Way Part VI: Crises Abroad, Party Problems at Home; 
September 1954 to December 1954,) Chapter 13: A new phase of political 
experience
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Connection Problems with Ud6 and UV10

2005-08-10 Thread David Tod Sigafoos
I posted this questions last year, got some responses and tried
everything but without resolve.

I got a new laptop in February of this year and am not experiencing
the same problems.  Below is a 'basic' system information

Problem.  After installing (without any problems) either Universe 10
PE or Unidata 6 PE I am unable to connect to the serves locally.

I can connect to clients UD and UV servers but there is no TELNET or
InterCall access available on localhost.

This IS (for me) a big problem, and I hope that there is some brainiac
(http://theages.superman.ws/Encyclopaedia/brainiac.php) out there who
can help me figure this out.

I can only GUESS that there is a windows service running that in
clobberin' (The Thing's favorite phrase is It's Clobberin time)

Are there any known tools which would help find out what might be
clobberin' telnet?


System Basics (some extras in case it helps):
HP Pavilion zd8065
Windows XP Professional 5.1 build 2600 Service Pack 2
Current date/time: 8/10/2005  8:34 AM
Total physical memory = 522732 Kbytes
Physical memory available = 101352 Kbytes
Total virtual memory = 2097024 Kbytes
Virtual memory available = 2026904 Kbytes
Country code: 1
Language: English
Code-page: 1252

Internet Explorer
C:\Program Files\Internet Explorer\IEXPLORE.EXE
ver: 6.0.2900.2180  8/9/2004  7:00 PM
ver in registry: 6.0.2900.2180

Microsoft Installer
C:\WINDOWS\system32\msiexec.exe
ver: 3.1.4000.1823  3/21/2005  3:00 PM

Folder Options: Using System Settings
Classic Style:  0
DblClk in Web:  1
IconUnderline:  3
Browser ULine:  yes

RichEdit 1.0ver: 5.1.2600.0 8/9/2004  7:00 PM
RichEdit 2.0ver: 5.30.23.1221   8/9/2004  7:00 PM

System desktop theme installer:
  Installer name:rundll32.exe
  Installer version: 5.1.2600.2180
  Theme base folder: C:\WINDOWS\system32\Themes\
 
Default mail client location info...
  Mail client name from 'HKLM\SOFTWARE\Clients\Mail' is:
'The Bat!'
  Default mail client specifies MAPI DLL as:
  C:\Program Files\The Bat!\tbmapi.dll
... and this file exists.

shell32.dll ver: 6.0.2900.2620  2/28/2005  4:11 PM
comdlg32.dllver: 6.0.2900.2180  8/9/2004  7:00 PM
comctl32.dllver: 6.0.2900.2180  8/9/2004  7:00 PM


Thanks

-- 
DSig
David Tod Sigafoos

'Politics is like driving. To go backward, put it in R. To go forward, put it 
in D' unknown
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Connection Problems with Ud6 and UV10 - unmentioned info

2005-08-10 Thread David Tod Sigafoos
In my original post I forgot to mention that I have tried this with
all spyware protection, virus protection firewalls etc turned off.  I
have even tried this after rebooting into safe mode (and making sure
the services were running)

I installed this as the administrator and as a user that is
administrator privileges.
From UniAdmin and Intercall client i get 'No RPC Connection Active'
(or server from Intercall).  This means that the Intercall client has
found the server (127.0.0.1) but that it did not find the RPC service
running ..

If i try the telnet i just get the blinking cursor.  If i hit enter it
moves down a line but blinks ..

Dynamic Connect gives me [Connecting to 127.0.0.1...]  then just hangs
XMLDB simply hangs

I have check that the Uni services are running (the following from
the services list .. all started)

Uni RPC Service
Unidata Database Service 6.1
Undiata ObjectCall Server 6.1
Unidata Telnet Service 6.1
Unidata Terminal Server 6.1


thanks ..


Wednesday, August 10, 2005, 8:44:15 AM, you wrote:

snip


-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] Connection Problems with Ud6 and UV10

2005-08-10 Thread David Tod Sigafoos
Ron,

Wednesday, August 10, 2005, 11:15:49 AM, you wrote:

RW David Tod Sigafoos wrote:

snipped for brevity
Problem.  After installing (without any problems) either Universe 10
PE or Unidata 6 PE I am unable to connect to the serves locally.

I can connect to clients UD and UV servers but there is no TELNET or
InterCall access available on localhost.

/snip

RW Since I see no other responses I will give this a go.  I run UV-Nt and
RW have for years.  I discovered when I first installed UV that the UV
RW telnet server conflicted with the Windows telnet server running
RW on port
RW 23.  I changed my UV telnet to use port 7005 and my problem went
RW away.

Any short instructions on how to change the UV telnet port?

Thanks

-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

When buying  selling are controlled by legislation, the first thing to be 
bought  sold are the legislators - P.J. O'Rourke
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Can we use WIN.PCWRITE to copy binary files??

2005-08-10 Thread David Tod Sigafoos
Frank,

Wednesday, August 10, 2005, 11:55:37 AM, you wrote:

BF To All:

BF We are trying to copy files from our AIX system using the Unidata
BF WIN.PCWRITE script.  The script comes with Wintegrate 4.2.1. 
BF Problem we
BF are having is that we cannot copy binary files from the AIX side
BF to the
BF PC using this script.

if you have it available .. it would be much easier to FTP

-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

When buying  selling are controlled by legislation, the first thing
to be bought  sold are the legislators - P.J. O'Rourke
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] Can we use WIN.PCWRITE to copy binary files??

2005-08-10 Thread David Tod Sigafoos
Frank,

Wednesday, August 10, 2005, 12:36:00 PM, you wrote:

BF Hi David,

BF Sorry for the post to the listserve.  Wouldn't ftp involve
BF passwording??
BF I am trying to get around this!

it does depend on your setup.

for example on the SunOS box i am currently working on, since i have
rights to the data already i have FTP access.  Since I am not the
administrator I don't know how they set that up but I am *sure* that
they don't set up the FTP for each user.

have you tried to FTP to the box?


-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

When i'm good, i'm good.  When i'm bad i'm even better Mae West
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] Connection Problems with Ud6 and UV10

2005-08-10 Thread David Tod Sigafoos
Bill_H,

Wednesday, August 10, 2005, 3:47:26 PM, you wrote:

B Dave:

B I'm thinking of two choices: 1) shutdown the Windows telnet
B service (which I
B always do anyway),

it is set to disabled

B or 2) change the port# for the UV telnet
B services.  I
B believe you can do this via UniAdmin; at least that's how I did it
B so UV and
B D3 would both run on the same machine.  :-)

You are the second one to suggest this .. but as mentioned in another
post .. uniAdmin does not enable the items under admin until you can
access the server G

I think it is not just a telnet issue but also a RPc (does rpc use
telnet?)


-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

...our behavior matters more than the beliefs that we profess.
Elizabeth Deutsch Earle
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] Connection Problems with Ud6 and UV10

2005-08-10 Thread David Tod Sigafoos
Ron,

Wednesday, August 10, 2005, 1:01:03 PM, you wrote:

RW Launch UniAdmin and select Telnet under the Network services
RW header.  When
RW the screen appears, the first thing on the screen is the desired
RW telnet 
RW port number.
RW After entering your port number, click the stop button to stop the UV 
RW services
RW and then click start to restart them.  If you are accessing UV with a 
RW terminal
RW emulator you will have to change your telnet port setting in the 
RW emulator as well.

I start UniAdmin and Local Host shows on the left.
The menu items are File, View, COnnect, Admin, Window, Logging and
Help

Under Admin is Network Services.  Problem is that ALL items under
Admin are grayed out.

I find that if i use uniadmin on another server those items don't
become available until a connection has been made.

So is this one of those chicken and egg things G



-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

Should any political party attempt to abolish social security, unemployment 
insurance, and eliminate labor laws and farm programs, you would not hear of 
that party again in our political history. There is a tiny splinter group, of 
course, that believes you can do these things.  Among them are a few Texas oil 
millionaires, and an occasional politician or business man from other areas. 
Their number is negligible and they are stupid.  --President Dwight D. 
Eisenhower, 1954 (source:  Eisenhower Presidential Papers, Document #1147; 
November 8, 1954 The Papers of Dwight David Eisenhower, Volume XV - The 
Presidency: The Middle Way Part VI: Crises Abroad, Party Problems at Home; 
September 1954 to December 1954,) Chapter 13: A new phase of political 
experience
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] Connection Problems with Ud6 and UV10

2005-08-10 Thread David Tod Sigafoos
Craig,

Wednesday, August 10, 2005, 4:35:11 PM, you wrote:

CB David,

CB are you connecting to localhost or 127.0.0.1.

I have tried both

CB I have had problems in the past where a DNS server returned a
CB value for localhost which was not 127.0.0.1.

there should not be a 'dns' server involved .. in fact I have just
disconnected from the network and tried .. still no good. (thought
windows probably has a 'mini' dns under the covers)

CB It could explain why you had problems on both machines.

man .. don't i wish

THe problem with this line of thinking is that MySql, which is another
database I use, and apache etc use local host and resolve to
127.0.0.1.

I really wonder about some contention with telnet and/or rpc



CB You might also have a look at your hosts file in \WINDOWS\SYSTEM32
CB and see where it maps localhost to.

hosts file found

CB What do you see if you:

CB nslookup localhost


Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\David Tod Sigafoosnslookup localhost
*** Default servers are not available
Server:  UnKnown
Address:  127.0.0.1

*** UnKnown can't find localhost: No response from server

C:\Documents and Settings\David Tod Sigafoos

CB and

CB ping localhost

ping is cool ..

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\David Tod Sigafoosping localhost

Pinging DSigsHpLaptop [127.0.0.1] with 32 bytes of data:

Reply from 127.0.0.1: bytes=32 time1ms TTL=128
Reply from 127.0.0.1: bytes=32 time1ms TTL=128
Reply from 127.0.0.1: bytes=32 time1ms TTL=128
Reply from 127.0.0.1: bytes=32 time1ms TTL=128

Ping statistics for 127.0.0.1:
Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms

C:\Documents and Settings\David Tod Sigafoos


-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

Our greatest duty in this life is to help others. And please, if you can't 
help them, could you at least not hurt them? - H.H. the Dalai Lama
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[4]: [U2] Connection Problems with Ud6 and UV10

2005-08-10 Thread David Tod Sigafoos
Bill_H,

Wednesday, August 10, 2005, 4:57:21 PM, you wrote:

B Dave:

B I'm just guessing here but I wonder if there is a registry setting
B inke in
HLM  Software  Informix (or is it IBM)  Universe (or UniData) that sets
B the port for telnet.

u ... regedit ...
put on beanie (looking for cecil)
IBM/UNIDATA/G.1/UDTELNET/TELNET_SOCKET value = 0X0017(23)

oh my .. this is going to take a second .. will let you now how it
works ...




-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

Our greatest duty in this life is to help others. And please, if you can't 
help them, could you at least not hurt them? - H.H. the Dalai Lama
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Intercall - ic_opensession

2005-08-02 Thread David Tod Sigafoos
The intercall definition ic_opensession is defined for opening a
session for a connection to U2 .. there is also a ic_unidata_session
and a ic_universe_session.

The only difference I can see between the 3 is that ic_unidata_session
has a 7th parameter 'Unidata_Server'.  Otherwise they all appear to
work the same.

As we are moving a process from Universe to Unidata i wanted to check
that I am not missing anything *important*.  The process appears to
work correctly but ..

Thanks


-- 
DSig
David Tod Sigafoos

When I'm good I'm very good, but when I'm bad I'm better. Mae West
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] Intercall - ic_opensession

2005-08-02 Thread David Tod Sigafoos
jbutera,

yes, we have been using that for years in universe.  My question was
more about the Unidata extension and what it brings?

thanks

Tuesday, August 2, 2005, 11:30:26 AM, you wrote:

 The intercall definition ic_opensession is defined for opening a
 session for a connection to U2 .. there is also a ic_unidata_session
 and a ic_universe_session.

 The only difference I can see between the 3 is that ic_unidata_session
 has a 7th parameter 'Unidata_Server'.  Otherwise they all appear to
 work the same.

 As we are moving a process from Universe to Unidata i wanted to check
 that I am not missing anything *important*.  The process appears to
 work correctly but ..

jhe I've been using this on Unidata for 3+ years without a hitch:

jhe session_id=ic_opensession(server,username,password,account,code,NULL);




-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

Our greatest duty in this life is to help others. And please, if you can't 
help them, could you at least not hurt them? - H.H. the Dalai Lama
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Index and Print servers

2005-07-27 Thread David Tod Sigafoos
A friend asked me recently about the need or Print and Index servers
on Unidata.  As I don't work with Unidata that much, or at least not
to the infrastructure level, I thought I would pass this on to the
knowledge trust here.

They are running 'current' unidata on Sun OS box.  They have around
600 users with fairly active entry and reporting going on.  They have
noticed a lot of different bog downs and we have been able to find
some.

SO .. their question is .. should they be using Index/Print servers.
If so using Unix for these processes they shouldn't need 'state of the
art' boxes .. Yes


thanks

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


Re[2]: [U2] Index and Print servers

2005-07-27 Thread David Tod Sigafoos
Ken,

thanks for the info .. your 'little idea what you mean by .. ' tells
me a lot.

I believe it is 6.x but they are looking to make sure.  My friend just got
there and found a company with no 'support' for these system, no
knowledge of what is or was there.  So she is digging through
everything to find out what is what.

'.. application in that environment without input from someone who
knows UniData could end up with a system that doesn't run as smoothly
as it could'

which is right where we are.  There are a lot if file size issues we
know we have to work through.

I had not heard of index servers on unidata (or universe for that
matter which is where i am from) but it was asked at the company and
thought I would pass it along ..

Thanks again

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


Re: [U2] U2 group archives

2005-07-21 Thread David Tod Sigafoos
Ralph,

try www.indexinfocus.com (noted on the u2ug.org Main Menu/Email List
page

Thursday, July 21, 2005, 11:30:38 AM, you wrote:

RB How do I find the message archives?

RB  

RB Thanks,

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



-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

'Politics is like driving. To go backward, put it in R. To go forward, put it 
in D' unknown
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] Include Vs Call - Software Maintenance

2005-05-19 Thread David Tod Sigafoos
Jeffrey,

Thursday, May 19, 2005, 8:23:40 AM, you wrote:

JB On Thursday 19 May 2005 09:58, Mark Johnson wrote:

 So are functions a kept secret in MV programming or has no-one had any
 issues with them? I'd like to know so I could either get better with them
 or ignore them and continue with subs.

JB Functionally speaking, why would I use a function which can return a single
JB argument when I can use a subroutine which can return 1 or more?

2 reasons off the top of my head ..

1) allows boolean operation against so you could

if myfucn( .. ) then

I find this much cleaner than


mysub(...)
if ... then

2) the original constructs of subroutines and functions (not mv but in
the real programming world :) was that subroutines were passed data in
parameters .. but you couldn't change the parameters .. Functions
allowed for a routine to pass back information.

Now .. true .. like so many other things .. these are not rules in MV
.. but i use this structure (an ask our programmers to do the same) as
I feel it is much easier to *see* what has been changed.

IF i need to modify/passback multiple items either i put them in an
static or dynamic array .. depending.

Some people think it is more work than is necessary .. but that is
fine.

We are always thinking of maintenance and support ..
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] Questions about addRequestParameter

2005-05-18 Thread David Tod Sigafoos
Mike,

Wednesday, May 18, 2005, 5:22:15 AM, you wrote:

If you are accessing a web service, callHTTP is for HTTP requests, similar
to an HTML form post. It does not send XML. If you are not, ignore the rest
of this!

MD Just to throw in my 2 cents, you can use callHTTP to send XML.  We are
MD running 16 different interfaces using callHTTP POST to send and receive XML.
MD Also, the response files contain embedded pdf's, html, or can be used with
MD XSL stylesheets.
MD That is not to say, however, that the SOAP functionality may not be better
MD suited for your purposes.

you are, of course correct .. you don't need SOAP etc to do this as my
original post mentioned ..

Simple callHttp passing the XML works great


-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

Cannot open file C:\DOCUMENTS AND SETTINGS\DAVID TOD SIGAFOOS\APPLICATION 
DATA\BATMAIL\COOKIES.TXT
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] Questions about addRequestParameter

2005-05-18 Thread David Tod Sigafoos
Bruce,

Tuesday, May 17, 2005, 10:34:19 PM, you wrote:

BL Thanks, David.

BL I did finally get it to work, after changing the url address.

BL I was geeting a 0 response to my requests but it wasn't giving me what I was
BL asking for. It turns out that something along the way was changing the url
BL from ws. to www. and that put me in the wrong camp, but the right service.

BL Everything is working great, now.

Great .. you have to poke around as the 'documentation' is not quite
explicit and there does not seem to be any real examples ..

but when all is said and done .. it works quite well
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Questions about addRequestParameter

2005-05-17 Thread David Tod Sigafoos
Bruce,

i recently used callHttp to generate 'Customs Form' through the USPS.
 You are basically right in your understanding.

 It is very quick as long as you have a good connection .. we were
 getting forms back in PDF format (6 pages) in approx 2-4 seconds after
 submit.  For your address you should be able to get response quicker.

 so ..

 rtn = createRequest(.) will return 0 if there was no error.  This
 builds the handle that all the other requests use.  Not sure what you
 want to 'see' with the handle.

 give it a try .. think you will like the results.

 DTsig
 

Monday, May 16, 2005, 3:19:20 PM, you wrote:

BL Hi All Esteemed Ones,

BL I have been investigating using callhttp to send addresses to the web for
BL address verification and the documentation is leaving me a little 
BL unfulfilled.

BL If I am understanding things correctly, I first do:
BL createRequest(URL, http_method, request_handle)
BL Then, I would add the address fields one by one to this by issuing:
BL addRequestParameter(request_handle, parameter_name, parameter_value,
BL content_handling)
BL for as many fields as I have to validate.
BL Finally, I would do:
BL submitRequest(request_handle, time_out, post_data, response_headers,
BL response_data, http_status). The response_headers and response_data vars
BL would have my reply. In this case it is XML.


BL I am assuming that the request_handle is used by all three processes but I
BL cannot see what is being done with it. I don't know whether it is correct or
BL not.

BL And finally, can anyone tell me if this is even worth pursuing? Is it fast
BL enough to use with data-entry? Or should I be looking into another method?

BL Thanks,

BL R. Bruce Lunt

BL HP/UX v. 11
BL Unidata v. 6.0
BL ---
BL u2-users mailing list
BL u2-users@listserver.u2ug.org
BL To unsubscribe please visit http://listserver.u2ug.org/


BL __ NOD32 1.1099 (20050516) Information __

BL This message was checked by NOD32 antivirus system.
BL http://www.nod32.com




-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

Cannot open file C:\DOCUMENTS AND SETTINGS\DAVID TOD SIGAFOOS\APPLICATION 
DATA\BATMAIL\COOKIES.TXT
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[4]: [U2] Printing PDF from uv {Unclassified}

2005-04-26 Thread David Tod Sigafoos
Thanks all .. it was the DOS command that i was missing

Tuesday, April 26, 2005, 12:17:40 AM, you wrote:

RW Don't forget that UniVerse BASIC has three quote characters,
RW the backslash being the third.  And PERFORM is more efficient than
RW EXECUTE (depending on flavor and/or $OPTIONS) since it doesn't set
RW up an extra execution level.  F'r instance:

RW Cmd =  \DOS /C AcroRd32 /p /t 123.pdf\
RW PERFORM Cmd
RW ---
RW u2-users mailing list
RW u2-users@listserver.u2ug.org
RW To unsubscribe please visit http://listserver.u2ug.org/


RW __ NOD32 1.1079 (20050426) Information __

RW This message was checked by NOD32 antivirus system.
RW http://www.nod32.com




-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

Cannot open file C:\DOCUMENTS AND SETTINGS\DAVID TOD SIGAFOOS\APPLICATION 
DATA\BATMAIL\COOKIES.TXT
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Printing PDF from uv

2005-04-25 Thread David Tod Sigafoos
I must say this has been a very interesting project .. learned lots of
great stuff (some from this group) and had to come up with many work
arounds .. i can feel the brain cells firing.

Now .. how to print a PDF to a specific printer ..

is there a way to do this from universe?  10.0.1 on windows

Primarily the client has a shipping package running under windows
which uses ODBC to update the uniVerse table with shipping info.
There is a trigger on this table which we will enhance to generate the
PDFs (postal forms etc) and then once generated (by the trigger
process) we want UV to 'print' the PDF form to a specific printer.

I am looking for ideas, directions etc to get this working ..
everything is cool except the printing bits ..

Thanks again
  

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


Re[2]: [U2] Printing PDF from uv

2005-04-25 Thread David Tod Sigafoos
Tony,

thanks .. but the question is not use of Acrobat or ghost(?) or .. but
how to have uniVerse perform a 'cmd' on a windows system.  I probably
wasn't very explicit in my original post.

The ENCODE is a pretty sweet command, now that I know it is there G,
but once the file is written out is there a way to get universe to
send off the printing to Acrobat on the server?

thanks again

Monday, April 25, 2005, 2:41:39 PM, you wrote:

TG I did a little googling on the topic and found the typical assortment of
TG PDF tools in the market.  They range in cost from free to about $1500, with
TG very little relation between cost and quality - a perfect example of how
TG the mystery of the medium allows some people to command whatever the market
TG will bear.  PlanetPDF.com and PDFStore.com have a good assortment of tools.

TG Try using this string to search in Google:
TG print pdf command line
TG Only you can decide about what's good value from what's outrageous.

TG One interesting hit was this one:
TG http://www.stat.rice.edu/~helpdesk/compguide/node13.html
TG It offers a couple brief but helpful tips.

TG HTH



-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[4]: [U2] Printing PDF from uv

2005-04-25 Thread David Tod Sigafoos
Bob,

that's the info i was looking for ..

dsig

Monday, April 25, 2005, 4:07:35 PM, you wrote:

BW To issue a command from within a basic program in Universe, use
BW something like this:

BW CMD = DOS /c 'dir c:\*.dat'
BW EXECUTE CMD CAPTURING DAT.LIST

BW I'm pretty sure the /c is case sensitive but I've never really tested
BW that.  Watch the single and double quote marks, not so much of the order
BW as is pairing them up where you want them.




-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

Cannot open file C:\DOCUMENTS AND SETTINGS\DAVID TOD SIGAFOOS\APPLICATION 
DATA\BATMAIL\COOKIES.TXT
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[4]: [U2] Printing PDF from uv {Unclassified}

2005-04-25 Thread David Tod Sigafoos
Mike

thanks man .. that is the kind of info i was looking for

dsig

Monday, April 25, 2005, 4:46:42 PM, you wrote:
HMM In UniVerse Basic you can do it directly by

HMM Cmd = DOS /c '
HMM Cmd :=  DOS Command
HMM Cmd := '
HMM EXECUTE Cmd

HMM e.g. 
HMM Cmd = DOS /c '
HMM Cmd :=  AcroRd32 /p /t 123.pdf
HMM Cmd := '
HMM EXECUTE Cmd

HMM Or

HMM If it's more complicated than that, you could create a .BAT file on the
HMM fly and then execute that by the method shown above.


HMM HTh



-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

Cannot open file C:\DOCUMENTS AND SETTINGS\DAVID TOD SIGAFOOS\APPLICATION 
DATA\BATMAIL\COOKIES.TXT
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] URL Encoding

2005-04-21 Thread David Tod Sigafoos
trying to connect and send a string through createRequest and then
submitRequest ..

urlString = 'http://sandbox.dowap.org/tools/httprequest/?API=CustomsCN22XM
L=CustomsCP72V2Request USERID=91919191919 PASSWORD=1919191919191Option/From
FirstNameJohn/FromFirstNameFromLastNameSmith/FromLastNameFromFirmXYZ Co
rporation/FromFirmFromAddress1Suite A/FromAddress1FromAddress21234 Etail
er Dr./FromAddress2FromUrbanization/FromCityLos Angeles/FromCityFromSta
teCA/FromStateFromZip590052/FromZip5 ... /CustomsCP72V2Request

The problem is that it appears from the manual that POST will cause
the URL to be encoded .. but that does not appear to be happening.

So, is it possible (or better yet *correct*) to do it this way or is
there another way to pass this on?  We are not allowed to use the
XML or DOM so forget that G

Also .. what is AddRequestParameter() used for?  Since the parameters
are in the URL.

Thanks


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


[U2] Decoding 64Base string

2005-04-18 Thread David Tod Sigafoos
I am looking for information on decoding a base64 string.  We will be
receiving this back with an xml stream from a client.  The base64
string is a image which we must decode and write out.

Anyone having done this?  Would love to talk to you about it or
possibly get snippets to get us on our way.

I have searched the u2ug site but found nothing

thanks ..
  

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


Re: [U2] Re: Decoding Base64 String

2005-04-18 Thread David Tod Sigafoos
Jeff,

Monday, April 18, 2005, 11:59:00 AM, you wrote:

JS Go here:  http://www.fourmilab.ch/webtools/base64/

JS Freeware command line base64 encoder/decoder

oh man .. thanks .. i think G .. c .. uuu

JS Quoting David Tod Sigafoos [EMAIL PROTECTED]:

 I am looking for information on decoding a base64 string.  We will be
 receiving this back with an xml stream from a client.  The base64
 string is a image which we must decode and write out.



-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] BCI and Dates to SqlServer

2005-03-28 Thread David Tod Sigafoos
Ray,

if you get a chance could you please look at the sample code I sent.
I can not find any errors in it and yet the dates do not work.

According to the manual ..

If you use SQL.B.INTDATE, the SQL Client Interface assumes the program
variable holds a date in UniVerse internal date format and uses the
DATEFORM conversion string to convert the internal date to an external
format as required by the data source.

As you can see from the sample code I sent last week I am using
SQL.B.INTDATE with SQL.DATE which should force the internal date to
the correct format.  My test code sets 'date = 13598' which should be
converted to 24Mar05.

I have tried to mix and match this .. but still have no success.

Any help will be appreciated.

thanks

Thursday, March 24, 2005, 1:52:39 PM, you wrote:

RW BCI mimics the ODBC API, so dates are expected to be in ODBC format 
(-MM-DD).

RW Using the constant SQL.B.DATE in SQLBindParameter() or
RW SQLBindColumn() causes an implicit conversion to occur, so that
RW you get internal format out of a SELECT, and must supply internal
RW format in bound variables to an INSERT or UPDATE.



-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] BCI and Dates to SqlServer

2005-03-28 Thread David Tod Sigafoos
Ray,

sorry to do this again but i forgot to mention ..

if i change the 'prepare' section as noted here .. it does work well.
 Now I can modify the read, write shells to force the conversion ..
 but now am really interested in why i am not getting it right to
 begin with g


*if (SQLBindParameter(sqlStmtEnv, 2, SQL.B.INTDATE, SQL.DATE, 30, 0, date)  
SQL.SUCCESS) then stop 'date'
if (SQLBindParameter(sqlStmtEnv, 2, SQL.B.BASIC, SQL.DATE, 30, 0, date)  
SQL.SUCCESS) then stop 'date'

nbr = 1
tdate = 13598
tdate = oconv(tdate,'D4-')
date = field(tdate,'-',3) :'-': field(tdate,'-',1) :'-': field(tdate,'-',2)
sqlStatement = 'insert into testDate values (' : nbr : ',' : squote(date) : ')'

*sqlStatement = 'insert into testDate values (?,?)'

IF (SQLPrepare(sqlStmtEnv, sqlStatement)  SQL.SUCCESS) then stop 'prepare'

*nbr = 1
*tdate = 13598
*tdate = oconv(tdate,'D4-')
*date = field(tdate,'-',3) :'-': field(tdate,'-',1) :'-': field(tdate,'-',2)


Thanks again ..

 

Thursday, March 24, 2005, 1:52:39 PM, you wrote:

RW BCI mimics the ODBC API, so dates are expected to be in ODBC format 
(-MM-DD).

RW Using the constant SQL.B.DATE in SQLBindParameter() or
RW SQLBindColumn() causes an implicit conversion to occur, so that
RW you get internal format out of a SELECT, and must supply internal
RW format in bound variables to an INSERT or UPDATE.



-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] BCI and Dates to SqlServer

2005-03-24 Thread David Tod Sigafoos
Ray,

Thursday, March 24, 2005, 1:52:39 PM, you wrote:

RW BCI mimics the ODBC API, so dates are expected to be in ODBC format 
(-MM-DD).

yes ..

RW Using the constant SQL.B.DATE in SQLBindParameter() or
RW SQLBindColumn() causes an implicit conversion to occur, so that
RW you get internal format out of a SELECT, and must supply internal
RW format in bound variables to an INSERT or UPDATE.

I do use the SQL.B.INTDATE and SQL.DATE.  MsSql creates as datetime
(using Enterprise Manager) ..

As soon as i try to write to this column i get the error.  If i change
the column to 'char' in all places then it writes out correctly.

It is only DATE that i have any problems with (haven't tried time).
INTs chars varchars (which map also to text columns) etc work well.

It is only date .. it must be something on my end as I would find it
odd that there is some ambiguity in the uv - odbc interface



-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

Cannot open file C:\DOCUMENTS AND SETTINGS\DAVID TOD SIGAFOOS\APPLICATION 
DATA\BATMAIL\COOKIES.TXT
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re[2]: [U2] BCI and Dates to SqlServer

2005-03-24 Thread David Tod Sigafoos
Ray,

Thursday, March 24, 2005, 1:52:39 PM, you wrote:
snip

as   further follow up here is a sample routine and info.  Note that
that the only problem shows up after the sqlExecute .. and it is
caused by the write ..

RUN DAVES.BP DATE_TEST.MV

Program: DATE_TEST  
Status for sqlExecute call is: -1   
SQLSTATE,NATCOD are:S1C00  0
Error text is   
[IBM][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver]Optional feature n
ot implemented  
Program DATE_TEST.MV: Line 69, Cannot resolve ERRMSG item EXITING CKSTMTENV.
 

sql definition:
tableName = testDate
columns
nbr int
testDatedatetime
---


program = 'DATE_TEST'
include UNIVERSE.INCLUDE ODBC.H

equ TRUE$ to 1
equ FALSE$ to 0
equ NULL$ to ''

if (SQLAllocEnv(comBaseEnv)  SQL.SUCCESS)  SQL.SUCCESS then stop 'allocEnv'
if (SQLAllocConnect(comBaseEnv, comConnEnv)  SQL.SUCCESS) then stop 
'allocConnect'
if (SQLConnect(comConnEnv, 'Universe','Universe','universe')  SQL.SUCCESS) 
then stop 'Connect'
if (SQLAllocStmt(comConnEnv, sqlStmtEnv)  SQL.SUCCESS)  SQL.SUCCESS then stop 
'allocStmt'

nbr = NULL$
date = NULL$

if (SQLBindParameter(sqlStmtEnv, 1, SQL.B.BASIC, SQL.INTEGER, 4, 0, nbr)  
SQL.SUCCESS) then stop 'BP nbr'
if (SQLBindParameter(sqlStmtEnv, 2, SQL.B.INTDATE, SQL.DATE, 30, 0, date)  
SQL.SUCCESS) then stop 'date'

sqlStatement = 'insert into testDate values (?,?)'

IF (SQLPrepare(sqlStmtEnv, sqlStatement)  SQL.SUCCESS) then stop 'prepare'

nbr = 1
date = 13598

status = sqlExecute(sqlStmtEnv)
if status  SQL.SUCCESS then
sqlRoutine = 'sqlExecute'
gosub CKSTMTENV
end

STOP

CKSTMTENV:
STATUS = status
Fn = sqlRoutine
Expect = ''
IF STATUS EQ -2 THEN 
status = SQLFreeStmt(sqlStmtEnv, SQL.DROP)

STOP INVALID STATEMENT HANDLE
end

IF STATUS EQ 100 THEN RETURN
IF STATUS NE 0
THEN
301*
  ST = SQLERROR(-1,-1,sqlStmtEnv,STATE,NATCODE,ERRTXT)
  IF ST  SQL.NO.DATA.FOUND
  THEN
PRINT 
COUNT = 1
IF Expect NE 0 AND STATE = Expect AND ST  SQL.NO.DATA.FOUND
THEN 
PRINT Allowed error of :STATE: returned for func :Fn
GOTO 399
END
ELSE
  PRINT 'Program: ': program
  PRINT Status for :Fn: call is: :STATUS
  PRINT SQLSTATE,NATCOD are: : STATE:  :NATCODE
  PRINT Error text is 
  PRINT  : ERRTXT
END
IF ST = 0 THEN GOTO 301
  END
IF STATUS = -1 AND COUNT = 1 THEN 
status = SQLFreeStmt(sqlStmtEnv, SQL.DROP)
STOP EXITING CKSTMTENV
end
END
399*
  IF STATUS  0 THEN PRINT 
  RETURN





-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Basic program editor for Windows

2005-02-13 Thread David Tod Sigafoos
MBTPublish,

Sunday, February 13, 2005, 10:39:00 AM, you wrote:

Mac When I'm teaching my Basic programming courses, I am frequently asked about
Mac any Windows editors which might be used to edit the source programs which 
are
Mac held in DIRECTORY / DIR type files.  Can anyone suggest any suitable
Mac software which I might recommend?
 
Mac It would be nice if the software had facilities for highlighting keywords,
Mac labels, variables and so on, and if it could indent the source code.

Textpad at textpad.com   You can define hightlight syntax and even
create a list oc commands and options.

There is a syntax file available from their site for PICK. I have one
for uniVerse and one for OpenInsight that I use daily for many years

Give it a try .. it's free to test (with a nag screen only)

-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

Cannot open file C:\DOCUMENTS AND SETTINGS\DAVID TOD SIGAFOOS\APPLICATION 
DATA\BATMAIL\COOKIES.TXT
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Running a stored procedure from Excel

2005-02-04 Thread David Tod Sigafoos
To start with be sure they have a good working odbc connection to uniVerse
(just checking ..)

Next .. the 'Basic Sql Client Interface Guide' has some great info on
running a procedure .. 

Where is it not working?


DSig
David Tod Sigafoos


-Original Message-
From: Richard Taylor [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Date: Fri, 4 Feb 2005 14:38:42 -0500
Subject: [U2] Running a stored procedure from Excel

 I have a co-worker that is trying to get a stored procedure to run from
 Excel via an ODBC connection.  What he is trying to do is have a
 routine
 that will regenerate some data whenever this query is run or the
 refresh
 button is clicked.  This is a straight ODBC connection run against
 UniData
 
  
 
 Any help would be appreciated.
 
  
 
 Rich Taylor | Senior Programmer/Analyst| VERTIS
 
 250 W. Pratt Street | Baltimore, MD 21201
 
 P 410.361.8688 | F 410.528.0319 
 
 [EMAIL PROTECTED] | http://www.vertisinc.com
 
  
 
 Vertis is the premier provider of targeted advertising, media, and
 marketing services that drive consumers to marketers more effectively.
 
  
 
 The more they complicate the plumbing
 
   the easier it is to stop up the drain
 
  
 
 - Montgomery Scott NCC-1701
 ---
 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[2]: [U2] Edit / Remove a record with no ID

2005-01-18 Thread David Tod Sigafoos
Iain,

Tuesday, January 18, 2005, 2:36:41 PM, you wrote:

HI Simon,

HI Have you tried to do a SSELECT (Ok, I only know Unidata, but UV is similar),
HI and then Edit that list. 
HI Anything that has a NULL ID in the file will float to the top and then just
HI delete that record.

You might also try

equ TRUE$ to 1
equ FALSE$ to 0
equ NULL$ to ''

OPEN '','tablename' to hndTable then
eof = TRUE$
select hndTable

loop
readnext idTable else eof = FALSE$
until eof do
if trim( idTable ) = NULL$ then
delete hndTable, idTable else null
end
repeat
end


of course you might want to write the offending records to temp ids
before deleting .. might be some good bits there
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: =?iso-8859-1?Q?Re:_[U2]_Where_Will_the_=2ENET_Apps_Live_??=

2004-12-27 Thread David Tod Sigafoos
brian,

Monday, December 27, 2004, 3:44:01 AM, you wrote:

snip
bbcu But you are absolutely right that it all begins and ends with the server
bbcu logic. Get that right, and the choice of front end become pretty much
bbcu irrelevant. I always tell my clients to build the server first: it is
bbcu so much easier to verify and QA before the front end is assembled.
bbcu Unfortunately too many sites still seem to approach it from the other
bbcu end and end up with garbage and high QA costs.

Have to disagree a bit with this.  Although the backend is very
important so is the front end.  Knowing your market .. the way users
actually do their work for the specific market and tying the two
together.  That is the challenge.  The choice of front ends is just a
critical for this portion of the environment.

Although Delphi is a brilliant product, OpenInsight is much better for
any MV environment.  With a native bond to U2 it is just about the
perfect tool for MV front end development.

Front end does matter.  Although you can set a screw with a hammer a
screw driver would be the preferred tool g

-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___

Whenever you are in doubt...apply the first test. Recall 
the face of the poorest and the weakest man whom you may have seen, 
and ask yourself if the step you contemplate is going to be 
any use to him...True development puts first those that society 
puts last.-Mahatma Gandhi
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] PDF docs

2004-07-22 Thread David Tod Sigafoos
It used to be that the pdfs were available for download.

It appears now that all pdfs are for ONLINE only reading.  Have I just
not found the 'download' section?

Thanks

  

-- 
DSig
David Tod Sigafoos

If patriotism has to precipitate us into dishonour, 
if there is no precipice of inhumanity over which 
nations and men will not throw themselves, then, 
why in fact do we go to so much trouble to become,
or to remain, human? Jean-Paul Sartre
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] problems with XP and PE

2004-07-01 Thread David Tod Sigafoos
Nick,  thanks for the reply.

1) Uni-XPPro on network.  Network works valid NO firewall. I can PING from 
secondary machine.

2) Netstat shows the following
Proto  Local Address  Foreign AddressState
  TCPDSigsHpLaptop:telnet   asi1043.asi.com:1400   CLOSE_WAIT
  TCPDSigsHpLaptop:3029 207.46.156.60:http CLOSE_WAIT
  TCPDSigsHpLaptop:3030 207.46.134.30:http CLOSE_WAIT
  TCPDSigsHpLaptop:telnet   localhost:3037 CLOSE_WAIT
  TCPDSigsHpLaptop:telnet   localhost:3038 CLOSE_WAIT
  TCPDSigsHpLaptop:telnet   localhost:3039 ESTABLISHED
 
Disconnecting the local hyperterminal and 3039 goes to CLOSE_WAIT
 
After turning off Uni Telnet all :telnet go away
 
3) PE version 10(?) just downloaded yesterday

DSig
David Tod Sigafoos


-Original Message-
From: Nick Southwell [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Thu, 1 Jul 2004 01:07:13 +0100
Subject: RE: [U2] problems with XP and PE

 Have you got XP firewall switched on?
 Are you connected to a LAN with a valid functioning NIC?
 
 Does a netstat show a listening against port 23? (with and without
 Unidata
 Telnet service running?)
 
 What version of PE?
 
 Cheers
 
 Nick 
 
 -Original Message-
 From: David Tod Sigafoos [mailto:[EMAIL PROTECTED] 
 Sent: 01 July 2004 00:25
 To: [EMAIL PROTECTED]
 Subject: [U2] problems with XP and PE
 
 I have just installed PE onto an XP pro machine.  I am unable to
 connect
 through telnet.  Service shows started but no joy in Mudville
 
 if I use hyperterminal (have used before) i get no response but the
 clock shows it is connected.
 
 I have not seen this before so am wondering if anyone knows what is
 going on.
 
 thanks
 
 DSig
 David Tod Sigafoos
 ---
 u2-users mailing list
 [EMAIL PROTECTED]
 To unsubscribe please visit http://listserver.u2ug.org/
 
 This correspondence is confidential and is solely for the intended
 recipient(s). If you are not the intended recipient, you must not use,
 disclose, copy, distribute or retain this message or any part of it. If
 you
 are not the intended recipient please delete this correspondence from
 your
 system and notify the sender immediately. 
 
 No warranty is given that this correspondence is free from any virus. 
 In
 keeping with good computer practice, you should ensure that it is
 actually
 virus free. E-mail messages may be subject to delays, non-delivery and
 unauthorised alterations therefore, information expressed in this
 message is
 not given or endorsed by Open and Direct Group Limited unless otherwise
 notified by our duly authorised representative independent of this
 message.
 
 Open and Direct Group Limited is a limited company registered in United
 Kingdom under number 4390810 whose registered office is at 10 Norwich 
 Street, London, EC4A 1BD
 ---
 u2-users mailing list
 [EMAIL PROTECTED]
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


[U2] problems with XP and PE

2004-06-30 Thread David Tod Sigafoos
I have just installed PE onto an XP pro machine.  I am unable to connect 
through telnet.  Service shows started but no joy in Mudville

if I use hyperterminal (have used before) i get no response but the clock 
shows it is connected.

I have not seen this before so am wondering if anyone knows what is going 
on.

thanks

DSig
David Tod Sigafoos
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


[U2] PE10

2004-05-26 Thread David Tod Sigafoos
u2-users,

  I have just installed the personal edition and can not find what the
  initial login/password is.  I have searched the docs but must have
  missed it

  

-- 
DSig
David Tod Sigafoos

If patriotism has to precipitate us into dishonour, 
if there is no precipice of inhumanity over which 
nations and men will not throw themselves, then, 
why in fact do we go to so much trouble to become,
or to remain, human? Jean-Paul Sartre
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users


Re: [U2] PE10

2004-05-26 Thread David Tod Sigafoos
David,

Wednesday, May 26, 2004, 5:41:34 PM, you wrote:

DTS u2-users,

DTS   I have just installed the personal edition and can not find what the
DTS   initial login/password is.  I have searched the docs but must have
DTS   missed it

DOH! after posting I remembered Windows User/Password.

I love helping myself G




-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___


If patriotism has to precipitate us into dishonour, 
if there is no precipice of inhumanity over which 
nations and men will not throw themselves, then, 
why in fact do we go to so much trouble to become,
or to remain, human? Jean-Paul Sartre
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users


Re: [U2] OT - Visual Basic 6.0

2004-05-10 Thread David Tod Sigafoos
kmbodine,

try a quick search on Google ..

visual basic user groups

Monday, May 10, 2004, 8:08:40 AM, you wrote:

k Can anyone tell me where is find a Visual Basic User group? I looking
k for some help 

 

k Thank you
k ---
k u2-users mailing list
k [EMAIL PROTECTED]
k http://www.u2ug.org/listinfo/u2-users



-- 
DSig `
David Tod Sigafoos  ( O O )
 ___oOOo__( )__oOOo___


If patriotism has to precipitate us into dishonour, 
if there is no precipice of inhumanity over which 
nations and men will not throw themselves, then, 
why in fact do we go to so much trouble to become,
or to remain, human? Jean-Paul Sartre
---
u2-users mailing list
[EMAIL PROTECTED]
http://www.u2ug.org/listinfo/u2-users