Hi Doug,
I think it is very well my job to help staff using my software to be
more productive.
That's what I at least get paid for!
But then I work for an end user and not a software vendor.
BTW I hardly ever use ED to edit programs, Brian's mv-developer is so
much better.
It would be great
Come on George,
if GUI is putting on lipstick on green screen then browser enabled is
putting eye shadow and mascara on GUI.
90% of an application consists of code running behind the interface,
like validations, calculations and file/table updates aka business logic.
There are no tools out
One universe contains billions of galaxies.
What you are looking for is the multiverse.
On 27/04/2011 21:31, Garry Smith wrote:
It would be called Galaxy - multiple universes.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On
-users@listserver.u2ug.org
Subject: Re: [U2] Databasic conversion
From: Mecki Foerthmann
AFAIK UD can be run in case insensitive mode as well.
I always turned case-insensitivity off in D3 because I think
it's a real pain in the neck.
Sounded great to start with but when you see the first
Tony,
I don't mind case in-sensitivity in Basic, it actually can make code
more readable, but case-insensitive data can be a real pain.
On 08/04/2011 00:58, Tony Gravagno wrote:
From: Mecki Foerthmann
AFAIK UD can be run in case insensitive mode as well.
I always turned case-insensitivity off
Why?
Are you one of the recruiters trying to poach Joe's client?:-)
On 07/04/2011 12:32, Address wrote:
Can someone close this thread ?
--- On Thu, 4/7/11, Joseph Chelston j...@bsgstaffing.com wrote:
From: Joseph Chelston j...@bsgstaffing.com
Subject: [U2] update: PICK Systems Administrator
Cowboy hats?
On 07/04/2011 21:54, Joseph Chelston wrote:
Has anyone ever heard of this guy? Any reference points would be
appreciated.
Regards,
Joe Chelston
Executive Recruiter
BSG Staffing Group LLC
PO Box 8651
Turnersville, NJ 08012
Phone: 856.218.1000
Fax: 856.228.8585
Forget it Tony.
I know Joe, he is genuine and actually got me a job once.
Mecki
On 07/04/2011 22:05, Tony Gravagno wrote:
From:Joseph Chelston
I'm just trying to limit competition from other recruiters by
not
disclosing too much information on this forum.
I apologize if this is a problem
Ed, Unidata has always supported A-types and still does, so no
conversion to I-types is necessary.
I am pretty sure S-types also work - it has been a while, though :-) .
AFAIK UD can be run in case insensitive mode as well.
I always turned case-insensitivity off in D3 because I think it's a real
You forgot the [AD] in the subject line g.
Sound like an Epicor sales pitch to me.
On 06/04/2011 19:34, John Carter wrote:
I don't usually contribute much to this forum - but I appreciate the chance
to stay connected via the great posts here. In this case however, I do have
some specific
me for interrupting.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann
Sent: Wednesday, April 06, 2011 1:01 PM
To: U2 Users List
Subject: Re: [U2] Epicor and Eclipse Was Re: PICKSystems
Symeon,
It depends on how old the software is.
As long as you run UD in Pick flavour and you have the source code Basic
code shouldn't be much of a problem.
If it compiles it will most likely work the same.
And if the dictionaries use A and F correlatives they should be fine too.
Procs usually
You are so right about mediocre programmers, Symeon.
But you have to keep in mind that it was most likely one of them who
wrote that hard to follow code in the first place.
Just because you may be able to remember hundreds of variables with
absolutely meaningless names or understand reverse
What absolute and utter rubbish!
You never had to write IF (test) ELSE ... in Pick.
READ did have a THEN clause as far back as I can remember (mid-80s) -
only LOCKED came later.
You just don't use it that often because you usually only want to do
something if your READ fails.
Typically READ rec
Come on - if something can be in two or more places at the same time it
is digital?
On 04/03/2011 10:54, Wols Lists wrote:
On 03/03/11 06:04, Allen E. Elwood wrote:
I dunno, just makes me laugh every time I think about the fact that at the
lowest level there is really no such thing as digital
OPEN and WRITE come to mind.
But that is still no reason to use IF condition ELSE.
On 04/03/2011 20:50, Ron Hutchings wrote:
Now that you have backed me in a corner, I remember that the READ supported
THEN and ELSE. There were a couple of constructs that only had ELSE that had
THEN added.
You can use more than 1 REMOVE in a loop, you know?
On 02/03/2011 22:35, Steve Romanow wrote:
I tried to drink the KoolAid and use REMOVE on some projects, but
found a show stopper on UDT6.1. I cannot remember the specifics.
Oh, I remember, In cases where you are addressing aligned mv's with
If it works, why bother?
It IS an ugly piece of code, though.
On 02/03/2011 16:43, Dave Laansma wrote:
This is some old code that I didn't write, so please don't use it for
anything profitable ...
The proposal to the group is: Due to the repeated references deep into
the PARMS tables, if
Hi
I finally got the chance to try to upgrade of the company's old
UD/Solaris 5.2 system to 7.2.
I got a separate machine with a later version of Solaris to play with.
We installed UD7.2.5 and copied all the Avante directories from the old
system to the new.
Initially everything went quite
...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann
Sent: Tuesday, February 22, 2011 8:56 AM
To: U2 Users List
Subject: [U2] Catalog copy error
Hi
I finally got the chance to try to upgrade of the company's old
UD/Solaris 5.2 system to 7.2.
I got a separate machine with a later version
You could for instance store the different messages in different
attributes of your ERRMSG file (i.e English in attribute 1, German
attribute 2 and French in attribute 3) and then read the message
according to the language specified in the user profile.
Or you could use different files for each
Isn't END BLOCK just a label?
So what is the difference to calling your label END.BLOCK and use GO
END.BLOCK instead of EXIT?
Or you could use a combination of CASE and IF...THEN...ELSE.
No need for yet another useless statement IMHO.
On 07/02/2011 22:08, George Gallen wrote:
That should
I tried but couldn't get it to work - UD 5.2/Solaris
On 02/02/2011 04:16, Shawn Hayes wrote:
Has anyone ever gotten Talend to connect to a U2 DB?
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
George,
why do you so vehemently reject the TRIM or TRIMB solutions?
I think it is the cleanest offered so far and requires the least coding.
just my 2 pence
Mecki
On 31/01/2011 16:33, George Gallen wrote:
The only problem will be if there are multivalued data elements
by eliminating the
AFAIK the result of an A-correlative has always been an integer.
That's why I don't store numbers with decimal points.
Ever heard of input conversions (i.e. MD2) ?
That allows your users to enter decimal points but stores the data
internally as integers.
In your case 399 * 3 = 1197 which with an
I was under the impression that when a relational table is being
indexed the DBMS creates and maintains a sorted copy of the original
table for every indexed field.
That means for clustered indices tables sorted by every conceivable
combination need to be maintained, having a huge impact on space
...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann
Sent: Friday, December 24, 2010 5:56 AM
To: U2 Users List
Subject: Re: [U2] Migration
I was under the impression that when a relational table is being indexed
the DBMS creates and maintains a sorted copy of the original table for every
indexed field
I haven't tried this on UD but BY-EXP XEM.PERSON = usernumber may work
in Pick flavour.
This should only return records and data for that user number.
On 23/12/2010 03:06, Jeffrey Butera wrote:
I need insight from the U2 faithful. This is Unidata 7, if that
affects the answer...
I have a
Even though you are right that there can be distinct advantages MV vs.
Relational.
But you surely wouldn't want a Product Category file that holds all the
product information in multi-valued fields.
Or Order and invoice data as multivalued fields in the customer file.
There is obviously a little
Kevin,
I would split the data into hierarchically organized files on the U2 end
if need be.
In my experience anything past the multi-value level becomes awkward in
any Pick system if you want to use the data for reporting.
Sub values are still reasonably well handled with Basic but after that
it
that's what EV is for (unless you use another editor for data than AE) ;-)
On 10/12/2010 18:06, fft2...@aol.com wrote:
In a message dated 12/10/2010 6:56:38 AM Pacific Standard Time,
slestak...@gmail.com writes:
That is why I was thinking a real name-value store might be in order. As
MV
AFAIK SSELECT BY.EXP returns a select list with the record ID and the
position in the multivalued attribute.
At least on ADDS Mentor it did.
I didn't use it for decades because I haven't had any need for such a
list, and I haven't tried it on UD yet.
So I don't think anything short of a Basic
Bill,
By default CATALOG will catalog programs globally.
To catalog a program locally you have to use the LOCAL option.
This will generate a VOC entry for the program name without the file name.
So CATALOG BP CODE LOCAL will generate a VOC entry named CODE.
To run the program you only need to
programfile programname UPDATE
Hth
Colin Alfke
Calgary, Canada
-Original Message-
From: Mecki Foerthmann
Hi,
Today I tried for the first time to create a trigger on Unidata
(Version
5.2 on Solaris) and get this error.
I have to add we are using SB+ and Avante 9.2 which includes
Hi,
Today I tried for the first time to create a trigger on Unidata (Version
5.2 on Solaris) and get this error.
I have to add we are using SB+ and Avante 9.2 which includes PRC 3.9.
First time I tried this I actually got an SB+ error (line 200 something)
- and when I run it from true ECL I just
CREATE.TRIGGER programfile programname UPDATE
Hth
Colin Alfke
Calgary, Canada
-Original Message-
From: Mecki Foerthmann
Hi,
Today I tried for the first time to create a trigger on Unidata (Version
5.2 on Solaris) and get this error.
I have to add we are using SB+ and Avante 9.2
LOL
No, I guess there are other companies as well that are a bit paranoid in
that regard.
I was told it has something to do with the auditors insisting on that
policy.
Supposedly if you use sudo it gets logged but if you log in as root you
can screw the system and nobody is any the wiser.
But
think SB+ is
getting in your way either.
I can look at it with you, if you want - contact me directly.
Regards,
Susan Joslyn
sjos...@sjplus.com
PRCR Real IT Governance for U2.
Date: Mon, 18 Oct 2010 17:07:17 +0100
From: Mecki Foerthmann mec...@gmx.net
To: U2 Users
More information would be helpful.
On 17/09/2010 06:10, ggayathri wrote:
I have a data file that is sent from my application(on UniVerse) to an
interfacing application.
In the huge amount of data, an erroneous character has been introduced.
Can someone suggest a way to remove that
Hi Stuart,
you are talking about READU not READL.
Of course it is dangerous to allow a user to read a record without
locking it if that user can then write that record back.
But READL will not allow any user to WRITE, not even the holder of the
lock unless all locks have been released.
OTOH it
Bill,
I thought doing something similar myself when I was a Junior programmer
because some people tend to lock records and go for lunch etc..
But what happens if you read the record into the variable R.This do some
processing, then the phone rings and you talk for 10 minutes, while
somebody else
...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann
Sent: Wednesday, September 01, 2010 1:00 PM
To: U2 Users List
Subject: Re: [U2] [UV] Shared Record Locks
Bill,
I thought doing something similar myself when I was a Junior programmer
because some people
oversimplified overview]
-Original Message-
From: u2-users-boun...@listserver.u2ug.org On Behalf Of Mecki
Foerthmann
Sent: Thursday, 2 September 2010 5:00 a.m.
To: U2 Users List
Subject: Re: [U2] [UV] Shared Record Locks
Bill,
I thought doing something similar myself when I
Bill,
SQL doesn't understand multi-values, so you have to un-nest (normalize)
them first.
UniSQL contains the NEST and UNNEST keywords, so your SQL sentences have
to be executed on the U2 server itself.
There are actually commands in U2 that will do most of the work for you
(convert files into
Why not use SSIS if you want to transfer data into SQL Server?
Norman, David (Health) wrote:
In the dying months of our major application, we are looking at sending small
amounts of data from UniVerse 10.0.16 HP-UX 11 to an SQLServer database every
few minutes from a phantom. I assume ODBC
You guys have colonies?
And which one is that supposed to be?
Symeon Breen wrote:
Only in one of our colonies
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Marc Harbeson
Sent: 03 July 2010 04:46
To: 'U2
Well, I always thought this was an inconsistency.
After all unlike SQL in Pick Null is a valid value.
I've never used -1 to suppress the writing of null values into
multi-valued fields because I hoped they would eventually fix that bug.
And for populating attributes I wouldn't use it anyway.
If I
You will need to write sequentially (OPENSEQ, WRITESEQ) to make the DIR
file not only visible but also usable to the OS, though.
Unless you use CR:LF at the end of every line instead of attributes of
course.
I just changed a program today that was using the proprietary SB+
interface to write text
Sorry Karl,
but Haydon is a real person, I saw him at U2U in Liverpool last year.
I actually thought about asking him if he let everybody know then too,
but I never talked to him.
At that time I was out of the office too, but I didn't think it was
important enough to let everybody in the group
I use an Excel template with a VBA macro to do the formatting - fonts,
colours, totals and so on.
I start the template within the Basic program after the csv-file has
been written to the user's temp directory on the c: drive.
The macro automatically loads the csv-file, formats it, then copies the
Stuart,
while you are right, that well designed OLAP cubes are way faster than a
MV-database queries.
I doubt your statement, that But it is also the fact that the DBMS
itself is highly optimised for the task of data analysis, though.
Mecki
Boydell, Stuart wrote:
While I completely agree that
Tony,
I think it is a lot simpler to just go into SQL Server and run the
Import Export Wizard than writing a Basic program for every export.
And BTW DTS and SSIS are integral part of SQL Server and don't cost a
penny extra.
So if you have the tools already, why not use them?
I transfer the data
DTS
César Riba Cervera wrote:
Hello
Which is the simplest way to export data from Unidata to SQLServer?
Thanks.
César Riba
Spain
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
understand all the buzz-words you throw around.
Mecki
Tony Gravagno wrote:
From: Mecki Foerthmann
Thanks Tony and Peter,
but I don't think yet another piece of software is
what I need. Your product might be useful for some of
your clients, but I don't think it will help solve my
problem
Hi
I am trying to use SSIS to load UniData tables to SQL Server 2008.
I already have been using DTS with SQL Server 2000 successfully for a
while and I set up everything (System DSN and UCI Editor) the same on
the 2008 server.
The connection test works fine, but when I try to go further I get
be an easier alternative.
--Bill
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki
Foerthmann
Sent: Wednesday, January 13, 2010 7:39 AM
To: U2 Users List
Subject: [U2] Error connecting to UD 5.2 from SQL Server
Thanks Tony and Peter,
but I don't think yet another piece of software is what I need.
Your product might be useful for some of your clients, but I don't think
it will help solve my problem.
I don't want to update any MV files, just load some data into a
relational database every night,
Funny you ask that, since in the manual they use a D-type as an example.
Wally Terhune wrote:
Is dict item F01 actually a compiled I type dict item?
Wally Terhune
U2 Support Architect
Rocket Software
Tel: (720) 475-8055
Mobile: (303) 807-6222
wterh...@rocketsoftware.com
The documentation states to assign a value to variable @RECORD first
otherwise the code will fail.
So instead of read REC from CONF,KEY then try read @RECORD from
CONF,KEY then
Karl Pearson wrote:
I have a client who would like to use the uniVerse ITYPE function but
the HELP (HELP BASIC ITYPE)
Hi
Firstly READU will not execute the ELSE clause when the item is locked.
It will just sit there and wait for the lock to be released.
Regardless if it is a bug or not, your piece of code just doesn't make
sense.
What do you actually try to achieve?
You try to read a record and when it doesn't
is request that from her and we will make it work.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann
Sent: Wednesday, October 07, 2009 12:05 PM
To: U2 Users List
Subject: Re: [U2] How to check
And if you are using UniData 6 or older all those fancy tools supposedly
don't work anyway.
Unfortunately we don't all have the luxury to always work with the
latest release like Doug obviously does.
Edward Brown wrote:
Veering a little off-topic here!
I've not used the unidata dev environment
and up.
Regards,
Doug
www.u2logic.com
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann
Sent: Wednesday, October 07, 2009 10:38 AM
To: U2 Users List
Subject: Re: [U2] How to check data dictionary
And who is supposed to do your other job in the meantime?
Anf who is supposed to test this thing in a couple of years time?
I would tell him to shovel it and find myself a real job.
Brutzman, Bill wrote:
Ken:
Thanks for writing. I neglected to mention that there is only one
programmer here...
What about triggers, Tony?
If you really want that type of RI, you could do it that way in Mv as well.
Tony Gravagno wrote:
Not responding to any particular comment, just the theme of this
part of the thread:
Yes, design and implementation are two different things. Poor
implementation can be
So all you are saying is, 'you can't compare pomegranates and
pineapples, because pomegranates are better anyway'?
I've eaten both, and I like pineapples better.
So who is right?
Bessel, Karen wrote:
I'm with you there, Harold.
I don't agree that U2 is a match for any real RDBMS like SQL. It
the chance to score the winning
goal against Man U at Wembley, that's the magic of cup competitions. The
key is to get into the first team for whoever you play for, if you don't do
that you don't get to play at all.
George
On 19/09/2009 15:41, Mecki Foerthmann mec...@gmx.net wrote:
I don't like
than it was at the start of the week
George
On 16/09/2009 21:41, Mecki Foerthmann mec...@gmx.net wrote:
I hope you are right.
But what if they are not even interested in selling new seats and are
quite happy to collect licence and support fees without doing any new
development?
After all
From the Rocket website:
Legacy Product Support
In addition to new OEM software ventures, Rocket engages in maintenance
and support contracts for existing products to assure long term support
for key legacy markets. Legacy product support can often represent a
distraction to OEM players that
this reminds me of a guy I used to work with years ago.
He tried to do everything in PROC, and it usually even worked, but
everybody hated to work on his accounts.
Nothing against paragraphs, but why not use the right tool for the job?
After what do we have Basic for?
Just think of the poor
I hope you are right.
But what if they are not even interested in selling new seats and are
quite happy to collect licence and support fees without doing any new
development?
After all this is corporate America and acquisitions are not necessarily
made to drive a product forward.
IBM can show
If the price of Datastage wouldn't be so prohibitive...
So I (have to) use SQL-Server DTS through ODBC and except for one file
which has some records with tens of thousands of multi-values I had no
problems so far.
I am not sure, maybe the ODBC part of Avante is even SB+ standard, but I
guess
Thanks Dawn,
There was no pricing for Datastage for U2 on the IBM website, and when I
saw that they charge nearly 90.000 Pounds for Datastage for Oracle, I
guessed that the U2 version would be a couple of ten thousand at least -
knowing IBM prices.
I also know that Cognos is rather expensive
John, there is another MV-world out there - not just U2, and in that
world a subroutine is a subroutine and ends with a RETURN and a program
is a program and ends with a STOP and/or END statement.
This is not only true for jbase this applies to D3 and other
MV-databases as well. If you run a
Well, if it makes you feel better, my test crashed out with a similar
error message as well.
The size shown was about half of what you had, otherwise the same message.
UD 5.2 on Solaris 5.2 (I think).
I know it's old, but that's all they give me.
Symeon Breen wrote:
Ok I am very jealous now of
With other words nothing I really need like manipulating a U2 database.
Does it make cups of tea too?
Well, I don't like cups of tea, so why should I change?
Steve Romanow wrote:
Mecki Foerthmann wrote:
It really boils down to this.
What can you do with Python in a U2 database that I can't do
It really boils down to this.
What can you do with Python in a U2 database that I can't do with Pick
Basic?
And do I really need to be able to do that to do my job improving and
maintaining commercial software in an SB+ Unidata environment any better?
Do I get paid more if I write code in
You can only create such records with a Basic program.
WRITE doesn't check the ID, it takes whatever the program provides, and if
that is null or contains non-printable characters including attribute-,
value- or subvalue marks, it just assumes the programmer knows what he or
she is
...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann
Sent: Wednesday, April 22, 2009 5:54 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UV to SAP migration disaster
jpb-u2ug wrote:
snip
Oh and one of these days you are going to be sitting in the same seat
talking about the good old days too
jpb-u2ug wrote:
snip
Oh and one of these days you are going to be sitting in the same seat
talking about the good old days too, and someone is going to be telling you
that you're a dinosaur. It's not easy trying to keep up with the technology
and if your company isn't using it you tend to
I second that.
And don't forget those people who have been in the same company and the
same office for over 20 years and still reminisce about the 'good old
mainframe days'.
The first thing a new guy hears is, 'We don't like change here!'
Upgrading? Don't fix it if it ain't broke!
If you get
Hi Mark,
Doing selects in a loop is never a good idea especially on large files
and definitely not a sorted one like you are trying to do.
But if you really have no other option, then you should at least create
an index on ItmID on TABLE2.
I don't know about Universe, but don't you have to do
Mark,
READNEXT works on any multi-attributed array not just on active select
lists.
Look up the FROM option or the SELECT command in the Unibasic manual.
And of course instead of reading from the SAVEDLISTS file you might
rather want to execute 'get-list listname'
I gathered that the
that works everywhere, like
loop
readnext id else exit
...
repeat
/Scott Ballinger
Pareto Corporation
Edmonds WA USA
206 713 6006
On Mon, Mar 30, 2009 at 12:01 AM, Mecki Foerthmann mec...@gmx.net wrote:
have you tried LOOP WHILE READNEXT ID DO ?
MAJ Programming wrote:
LOOP WHILE READNEXT
have you tried LOOP WHILE READNEXT ID DO ?
MAJ Programming wrote:
LOOP WHILE READNEXT does not work on D3.
Mark Johnson
- Original Message -
From: Keith Johnson [DATACOM] kei...@datacom.co.nz
To: u2-users@listserver.u2ug.org
Sent: Monday, March 02, 2009 7:38 PM
Subject: Re: [U2]
And the disadvantage is that you still have an active select list when
you set EOF to TRUE.
David Beaty wrote:
I tend to use:
SELECT FILENAME
EOF = @FALSE
LOOP
READNEXT ID ELSE EOF = @TRUE
UNTIL EOF DO
CODE
CODE
CODE with GOSUB
CODE
CODE
REPEAT
The advantage here is that it allows you to
Do the users have to type in all 300 customer numbers every time they
want to run a report?
Certainly not?
So there must be a file containing these numbers with some sort of ID.
In that case there should be then a routine (be it a Basic program, a
Proc or Paragraph) that merges that data into
]
[mailto:[EMAIL PROTECTED] On Behalf Of Mecki Foerthmann
Sent: Monday, November 17, 2008 11:21 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Speeding up processing through large dynamic table
READNEXT could be an option
SELECT IN.TAB
LOOP WHILE READNEXT IN.LINE DO
CUST.NUM=IN.LINE1,1
READNEXT could be an option
SELECT IN.TAB
LOOP WHILE READNEXT IN.LINE DO
CUST.NUM=IN.LINE1,1
CUST.DESC=IN.LINE1,2
REPEAT
this should be lightning-fast regardless how big IN.TAB is.
David Laansma wrote:
Is there a way to speed up spinning through a very large dynamic table? Here is
a
I would actually have expected that behaviour.
What is this piece of code actually try to achieve?
Is READNEXT only used to test if the SELECT statement returned any items?
In that case the CAPTURING clause with the EXECUTE statement would be a
better tool to test that.
Or you could execute
Why not write a new dictionary item?
This can set a flag if FIELD is neither SF456 nor SH456.
Let's call it VALID.FIELD
I would use the following A-correlative
A;IF N(FIELD) = SF456 THEN ELSE IF N(FIELD) = SH456 THEN ELSE 1
That would work at least in UniData - not sure if UV supports
Mecki Foerthmann
**
This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e
, which mv-to-sql bridges are
worthwhile using.
This setting up schemas and sql-tables in UniData (we're still on 5.2)
seems to be way over my head, and I don't seem to be getting anywhere
that way.
many thanks in advance
Mecki Foerthmann
---
u2-users mailing list
u2-users@listserver.u2ug.org
OCONV(OCONV(var,'MCN'),'MR2') should do the trick.
Doug Farmer wrote:
Good Day All!
Does anyone know of a UniData function or ICONV option to convert
scientific notation to a decimal number.
We are receiving some numbers in an XML packet from a 3rd party where
sometimes Scientific Notation
Hi,
it doesm't seem to work without a password!
You will either have to set up a password for yourself or create another
user on your PC with a password.
Then you can log on through telnet or a terminal emulator.
Mecki
CC)sar Riba Cervera wrote:
Hello
Thanks for your answers.
Paul Parkinson wrote:
Hi
I have a problem with what I think is a SBClient 5.0.4 installation. The
problem is the intuitive help key (F3) seems to have stopped functioning, What
happens is the process behind the F3 is called but the resulting select list
is not displayed on screen. This is only
Why not use the Proverb Guide for UniVerse?
AKAIK is the syntax the same.
Regards Mecki
John Jenkins schrieb:
I've used PROC happily and consistently on UniData for ages - despite gibes
from some colleagues - ;-'
All the great toys :
Buffer subscripts, Select buffers, file buffers, etc
(and
Now I want to be really pedantic :-P and therefore here it is, the
probably ultimate piece of code:
IF AR(13) NE DATE() THEN
INS (P(2)-AR(12)) LE 28 BEFORE AR(14)1,1
DEL AR(14)1,9
CC=CC+AR(14)1,1
END
Mecki
Gary Gowans wrote:
Hi Caleb wrote...
The general consensus of replies
Sorry, sent this too early
Should be:.
IF AR(13) NE DATE() THEN
INS (P(2)-AR(12)) GT 28 BEFORE AR(14)1,1
DEL AR(14)1,9
CC+= (P(2)-AR(12)) LE 28
END
Mecki Foerthmann wrote:
Now I want to be really pedantic :-P and therefore here it is, the
probably ultimate piece of code:
IF AR(13) NE
Hi Peter,
Thank you for your email.
I would be interested, but I guess that only remote working would be
possible, since I am a German citizen and don't have a US work permit.
Nevertheless I attach my CV and you can phone me anytime on +49-431-7305966
Regards
Gerd (Mecki) Foerthmann
Peter
101 - 200 of 201 matches
Mail list logo
