RE: [U2] UniVerse Data in SQL Tables

2004-06-10 Thread djordan
Hi Trevor

With UniVerse the ODBC, OLEDB  UniObjects come free with the database.  If
you have an older version of UniVerse and did not get these with the product
then get hold of your supplier and they should be able to organise if free
of charge.

Writing a front end for universe can be done in Minutes and cheaper than can
be done frontending SQL Server.  I have set up Web Services and Clients for
UniVerse in .Net very quickly and cheaply.  You can take advantage of
current UV Basic Subroutines and the business logic already done in UniVerse
and pass them to the client where all you have to do the GUI interface.

There is a variety of ways achieving this according to whether you want to
take the SQL approach or the direct interface.  UniObjects runs a lot
quicker than the SQL approach. 

You can contact me direct if you wish some further advice of approach.


Regards
David Jordan
Managing Consultant
[EMAIL PROTECTED]

Dacono Holdings Pty Ltd
Business  Technology Consulting
PO Box 909
Lane Cove 
NSW 2066
Australia
Ph 61 2 9418 8329
Fax 61 2 9427 2371
www.dacono.com.au 



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Trevor McNamara
Sent: Thursday, 10 June 2004 1:16 PM
To: [EMAIL PROTECTED]
Subject: RE: [U2] UniVerse Data in SQL Tables


It is for an asset register frontend. Will need it to read data from the 
database aswell as write back.

I know its expensive to write a frontend to UniVerse as you need o purchase 
third party software like Pick .NET DP. So i thought i could be able to get 
the data to the SQL server and then use the SQL for the backend to the 
frontend (which will be written in VB .NET)

I have done an SQL frontend before and i would assume its easier than a 
UniVerse frontend.

Thanks
Hi Trevor

There are a variety of ways to do this.  The question is what do you 
want
to
do exactly with the replicated Database, defines the best approach or even
away to avoid the replication.

Regards
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] [UV] SELECTINDEX inside a user conversion subroutine iscorruptin g the record count

2004-06-10 Thread Ray Wurlod
I expect that @SELECTED and @SYSTEM.RETURN.CODE are affected in the caller (UV query 
engine) rather than in the called subroutine.

@SYSTEM.RETURN.CODE is writable (despite documentation to the contrary).  Why not try 
intercepting it on entry to your subroutine and resetting it before exit?


- Original Message -
From: [EMAIL PROTECTED]
Date: Thu, 10 Jun 2004 09:49:20 +0800
To: [EMAIL PROTECTED]
Subject: [U2] [UV] SELECTINDEX inside a user conversion subroutine iscorruptin g the 
record count

 We have a user conversion code (named UOPNN) which we use in the conversion
 field of dictionaries to convert an operator number into an operator name.
 
 Our operators (ie. users) control file is keyed on name with an AK on
 number. The UOPNN routine uses SELECTINDEX on the operator file using the
 number to obtain the name.
 
 The SELECTINDEX statement is selecting to list 8, therefore not affecting
 the default list (0).
 
 If I list a file with the SAMPLE keyword, displaying a field which uses the
 conversion code - then 10 records will be listed, BUT the final line
 displayed is Sample of 1 records listed. instead of Sample of 10 records
 listed.
 
 The number displayed (ie. 1) is dependant on the number of records that the
 final SELECTINDEX returns, which, to me, indicates that SELECTINDEX is
 overwriting some internal counter variable.
 
 I added a CRT of @SELECTED and @SYSTEM.RETURN.CODE to the conversion routine
 and neither of these are altered by the SELECTINDEX.
 
 This looks like it may be a bug in Universe as I'm pretty sure we didn't
 have this problem under PI/Open.
 
 Does anyone have any suggestions of a way around this problem?
 
 (We're on UV 10.0.19)
 --
 Adrian Womack
 RAC Group of WA
 Perth WA
 Australia
 
 
 
 
 Disclaimer.  This e-mail is private and confidential. If you are not the
 intended recipient, please advise us by return e-mail immediately, and
 delete the e-mail and any attachments without using or disclosing the
 contents in any way. The views expressed in this e-mail are those of the
 author, and do not represent those of this company unless this is clearly
 indicated. You should scan this e-mail and any attachments for viruses. This
 company accepts no liability for any direct or indirect damage or loss
 resulting from the use of any attachments to this e-mail.
 ---
 u2-users mailing list
 [EMAIL PROTECTED]
 To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] FW: Identify UniVerse files at unix level

2004-06-10 Thread LeRoi Keiller
Thanks to everyone.  This one looks like the ticket (re UVfile) (but it
seems to run quite slow compared to the 'file' command used with an updated
'magic' file - even though they appear to do the same task).

-Original Message-
From: Ray Wurlod [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 9 June 2004 16:19
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [U2] FW: Identify UniVerse files at unix level
Importance: Low


There's a UVfile executable in the bin directory for UniVerse.  This will
perform what you need.

On UNIX, use find:  for example (provided the UniVerse bin directory is in
PATH):  find . -exec UVfile {}\;
Possibly you can filter the output with grep and/or awk.

On Windows, use the uvwalk.exe utility, and its -uvfile option

- Original Message -
From: LeRoi Keiller [EMAIL PROTECTED]
Date: Wed, 9 Jun 2004 14:46:32 +1000 
To: [EMAIL PROTECTED]
Subject: [U2] FW: Identify UniVerse files at unix level

  Can anyone tell me how I might list ONLY UniVerse data and dictionary
  files quickly and efficiently at the unix level?  ...grep for a
signature
  string in the file, perhaps?
  
  LeRoi Keiller
  Technical Support Consultant
   
  Ultradata - Vision to Reality
  +61 3 9291 1700
  www.ultradata.com.au
  
  
  
 Disclaimer Notice
 This message contains privileged and confidential information intended
only
 for the use of the addressee named above. If you are not the intended
 recipient of this message you are hereby notified that you must not
 disseminate, copy or take any action or place any reliance on it. If you
 have received this message in error please notify Ultradata immediately on
 +61 3 9291 1600. Any views expressed in this message are those of the
 individual sender, except where the sender specifically states them to be
 the views of Ultradata Australia Pty. Ltd.
 
  To unsubscribe from receiving commercial electronic messages from
Ultradata
 Australia please email [EMAIL PROTECTED] with the subject
heading
 Unsubscribe.
 ---
 u2-users mailing list
 [EMAIL PROTECTED]
 To unsubscribe please visit http://listserver.u2ug.org/


Disclaimer Notice
This message contains privileged and confidential information intended only
for the use of the addressee named above. If you are not the intended
recipient of this message you are hereby notified that you must not
disseminate, copy or take any action or place any reliance on it. If you
have received this message in error please notify Ultradata immediately on
+61 3 9291 1600. Any views expressed in this message are those of the
individual sender, except where the sender specifically states them to be
the views of Ultradata Australia Pty. Ltd.

 To unsubscribe from receiving commercial electronic messages from Ultradata
Australia please email [EMAIL PROTECTED] with the subject heading
Unsubscribe.
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


Re: Unclassified RE: [U2] [UV/Windows] Authentication / encryption is sues

2004-06-10 Thread Leroy Dreyfuss
Mike,

Sorry for the delay in responding. Dynamic Connect is not planned to
support SSL at this time as it is free telnet client based on the
wIntegrate engine.

A quick Internet shows various third-party options for secure telnet. SSH
is quite common, but since U2 databases have traditionally been
telnet-based, and due to our device licensing methodology, we opted to go
with secure telnet over secure shell.

Regards,

LeRoy F. Dreyfuss
Advanced Technical Services - U2 Technology Analyst
IBM U2 Data Management Solutions
Tel: 303-672-1254  Fax: 303-294-4832
Mobile: 720-341-4317
External email:  [EMAIL PROTECTED]
WWW:  http://www.ibm.com/software/data/u2/support

www.ibm.com/software/data/u2/support - Open, Query, Update, Search -
Online!

Don't miss out on the IBM DB2 Information Management Technical Conference
September 19-24, 2004 - Las Vegas, NV



 HENDERSON MICHAEL
 MR
 MICHAEL.HENDERSO  To
 [EMAIL PROTECTED]'[EMAIL PROTECTED]'
 Sent by:  [EMAIL PROTECTED]
 [EMAIL PROTECTED]  cc
 stserver.u2ug.org
   Subject
   Unclassified RE: [U2] [UV/Windows]
 06/08/2004 09:43  Authentication / encryption  is
 PMsues


 Please respond to
 u2-users






LeRoy,

The implementation of SSL with the UV telnet server certainly sounds
interesting to me, too.
Is it limited to wIntegrate only, or can Dynamic Connect use it too?

I don't suppose there are any other SSL-enabled terminal emulators out
there, I thought SSH seemed to be the common way of doing it.  But maybe
I'm
wrong?


The original poster also mentioned the UV/Net password vulnerability.
Does IBM have any plans to address this?


Thanks


Mike



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Leroy Dreyfuss
Sent: Tuesday, 8 June 2004 07:45
To: [EMAIL PROTECTED]
Subject: RE: [U2] [UV/Windows] Authentication / encryption issues

Bill,

[snip]

You then tell wIntegrate (version 5.1 or later) where that file is

[snip]

Regards,

LeRoy F. Dreyfuss
Advanced Technical Services - U2 Technology Analyst IBM U2 Data Management
Solutions
Tel: 303-672-1254  Fax: 303-294-4832
Mobile: 720-341-4317
External email:  [EMAIL PROTECTED]

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

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

[demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif]

[demime 1.01d removed an attachment of type image/gif which had a name of pic04562.gif]

[demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif]
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] SELECTINDEX inside a user conversion subroutine is corrupting the record count

2004-06-10 Thread Janke, Mark
Perhaps you could modify your routine to use BSCAN instead of SELECTINDEX,
something along the lines of:

BSCAN found.key, record.keys FROM operators.file.var,
operator.number.to.find USING 'index.name'  BY 'A' THEN
   IF STATUS() = 1 THEN  ;* Desired operator number actually found
  FORMLIST record.keys TO 8
   ELSE
 * Operator number not found.
   END
ELSE
   * Operator number not found
END

If you don't really need to put the record.keys into a SELECT list, then you
could just do a LOOP REMOVE to get each key from the record.keys variable.

Hopefully this would avoid the problem you're running into.

Mark

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 10, 2004 3:04 AM
To: [EMAIL PROTECTED]
Subject: RE: [U2] [UV] SELECTINDEX inside a user conversion subroutine
is corrupting the record count


Ray,

Thanks for the suggestion - but no luck. 

Setting @SYSTEM.RETURN.CODE makes no difference. I checked again and
@SELECTED does get set by the SELECTINDEX. I tried storing and resetting
@SELECTED (which does seem to be writable), and again no difference.

The only way around the problem seems to be creating a new file keyed on
operator number - just so I can do a direct read instead of a SELECTINDEX.

AdrianW

-Original Message-
From: Ray Wurlod [mailto:[EMAIL PROTECTED]
Sent: Thursday, 10 June 2004 15:18
To: [EMAIL PROTECTED]
Subject: Re: [U2] [UV] SELECTINDEX inside a user conversion subroutine
iscorruptin g the record count


I expect that @SELECTED and @SYSTEM.RETURN.CODE are affected in the caller
(UV query engine) rather than in the called subroutine.

@SYSTEM.RETURN.CODE is writable (despite documentation to the contrary).
Why not try intercepting it on entry to your subroutine and resetting it
before exit?


- Original Message -
From: [EMAIL PROTECTED]
Date: Thu, 10 Jun 2004 09:49:20 +0800
To: [EMAIL PROTECTED]
Subject: [U2] [UV] SELECTINDEX inside a user conversion subroutine
iscorruptin g the record count

 We have a user conversion code (named UOPNN) which we use in the
conversion
 field of dictionaries to convert an operator number into an operator name.
 
 Our operators (ie. users) control file is keyed on name with an AK on
 number. The UOPNN routine uses SELECTINDEX on the operator file using the
 number to obtain the name.
 
 The SELECTINDEX statement is selecting to list 8, therefore not affecting
 the default list (0).
 
 If I list a file with the SAMPLE keyword, displaying a field which uses
the
 conversion code - then 10 records will be listed, BUT the final line
 displayed is Sample of 1 records listed. instead of Sample of 10
records
 listed.
 
 The number displayed (ie. 1) is dependant on the number of records that
the
 final SELECTINDEX returns, which, to me, indicates that SELECTINDEX is
 overwriting some internal counter variable.
 
 I added a CRT of @SELECTED and @SYSTEM.RETURN.CODE to the conversion
routine
 and neither of these are altered by the SELECTINDEX.
 
 This looks like it may be a bug in Universe as I'm pretty sure we didn't
 have this problem under PI/Open.
 
 Does anyone have any suggestions of a way around this problem?
 
 (We're on UV 10.0.19)
 --
 Adrian Womack
 RAC Group of WA
 Perth WA
 Australia
Disclaimer.  This e-mail is private and confidential. If you are not the
intended recipient, please advise us by return e-mail immediately, and
delete the e-mail and any attachments without using or disclosing the
contents in any way. The views expressed in this e-mail are those of the
author, and do not represent those of this company unless this is clearly
indicated. You should scan this e-mail and any attachments for viruses. This
company accepts no liability for any direct or indirect damage or loss
resulting from the use of any attachments to this e-mail.
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] [UV] SELECTINDEX inside a user conversion subroutine is corrupting the record count

2004-06-10 Thread Glenn Herbert
I believe that what is happening does so because, even though there can be 
multiple SELECT lists, there is only a single internal variable within the 
query processor for handling record count.  This has been like this as 
long as I can recall (mid-80s?) and basically its the last 
select/list/count/etc done that gets output.

At 04:04 AM 6/10/2004, you wrote:
Ray,
Thanks for the suggestion - but no luck.
Setting @SYSTEM.RETURN.CODE makes no difference. I checked again and
@SELECTED does get set by the SELECTINDEX. I tried storing and resetting
@SELECTED (which does seem to be writable), and again no difference.
The only way around the problem seems to be creating a new file keyed on
operator number - just so I can do a direct read instead of a SELECTINDEX.
AdrianW
-Original Message-
From: Ray Wurlod [mailto:[EMAIL PROTECTED]
Sent: Thursday, 10 June 2004 15:18
To: [EMAIL PROTECTED]
Subject: Re: [U2] [UV] SELECTINDEX inside a user conversion subroutine
iscorruptin g the record count
I expect that @SELECTED and @SYSTEM.RETURN.CODE are affected in the caller
(UV query engine) rather than in the called subroutine.
@SYSTEM.RETURN.CODE is writable (despite documentation to the contrary).
Why not try intercepting it on entry to your subroutine and resetting it
before exit?
- Original Message -
From: [EMAIL PROTECTED]
Date: Thu, 10 Jun 2004 09:49:20 +0800
To: [EMAIL PROTECTED]
Subject: [U2] [UV] SELECTINDEX inside a user conversion subroutine
iscorruptin g the record count
 We have a user conversion code (named UOPNN) which we use in the
conversion
 field of dictionaries to convert an operator number into an operator name.

 Our operators (ie. users) control file is keyed on name with an AK on
 number. The UOPNN routine uses SELECTINDEX on the operator file using the
 number to obtain the name.

 The SELECTINDEX statement is selecting to list 8, therefore not affecting
 the default list (0).

 If I list a file with the SAMPLE keyword, displaying a field which uses
the
 conversion code - then 10 records will be listed, BUT the final line
 displayed is Sample of 1 records listed. instead of Sample of 10
records
 listed.

 The number displayed (ie. 1) is dependant on the number of records that
the
 final SELECTINDEX returns, which, to me, indicates that SELECTINDEX is
 overwriting some internal counter variable.

 I added a CRT of @SELECTED and @SYSTEM.RETURN.CODE to the conversion
routine
 and neither of these are altered by the SELECTINDEX.

 This looks like it may be a bug in Universe as I'm pretty sure we didn't
 have this problem under PI/Open.

 Does anyone have any suggestions of a way around this problem?

 (We're on UV 10.0.19)
 --
 Adrian Womack
 RAC Group of WA
 Perth WA
 Australia
Disclaimer.  This e-mail is private and confidential. If you are not the
intended recipient, please advise us by return e-mail immediately, and
delete the e-mail and any attachments without using or disclosing the
contents in any way. The views expressed in this e-mail are those of the
author, and do not represent those of this company unless this is clearly
indicated. You should scan this e-mail and any attachments for viruses. This
company accepts no liability for any direct or indirect damage or loss
resulting from the use of any attachments to this e-mail.
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Date Conversion Format

2004-06-10 Thread Kevin King
Could you double-convert?  Convert via D2/ or D4/ to start, then MCN
to remove the symbols. 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dave S
Sent: Thursday, June 10, 2004 8:21 AM
To: U2 USERS
Subject: [U2] Date Conversion Format

I am using looking for a date format conversion to use. We are using
the format DDMMY which formats the date to  02 10 1970.
 
We are creating an MVQUERY extract and the customer would prefer to
eliminate the spaces in the date. 
 
Is there another date format conversion that we can use or we do we
have to create another dictionary to remove these blanks ?


-
Do you Yahoo!?
Friends.  Fun. Try the all-new Yahoo! Messenger
---
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/


RE: [U2] Date Conversion Format

2004-06-10 Thread Karjala Koponen
To be explicit, I think you'll have to create a dictionary item.  I don't know
how to do a date conversion with spaces removed using a single date conversion
function/format.  Something on my wish list...

(UniData) - of course the second conversion could be in attribute 3.

001: V
002: DATE;OCONV(@,'D4MDY');OCONV(@,'MCN')
003:
004: Date
005: 8R
006: S

Karjala


 [EMAIL PROTECTED] 06/10/2004 11:27:27 AM 
Could you double-convert?  Convert via D2/ or D4/ to start, then MCN
to remove the symbols.

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dave S
Sent: Thursday, June 10, 2004 8:21 AM
To: U2 USERS
Subject: [U2] Date Conversion Format

I am using looking for a date format conversion to use. We are using
the format DDMMY which formats the date to  02 10 1970.

We are creating an MVQUERY extract and the customer would prefer to
eliminate the spaces in the date.

Is there another date format conversion that we can use or we do we
have to create another dictionary to remove these blanks ?


-
Do you Yahoo!?
Friends.  Fun. Try the all-new Yahoo! Messenger
---
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-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


[U2] [AD] Bounced - Reposting

2004-06-10 Thread Moderator
=
This ad was posted to the group, bounced, and is being reposted as a consideration to 
the poster. No endorsement implied.
=
One of my clients, a leading software development company based in
Boston, has several the following permanent openings, all require
knowledge and experiences with PICK/UniVerse:
PROGRAM MANAGER -  Sr. Product Marketing or Sr. Product
Management experiences required
SALES ENGINEER - Approx. 50% travel required; Pre-Sales and
Post-Sales experiences required
SYSTEMS ARCHITECT - internal systems software
experiences in the PICK/UniVerse environment.  Experiences
with low level C/C++ would also be helpful..
The company is an established and  profitable software product
development company.  They are in the process of establishing a
PICK environment and are looking for senior professionals to help
them in the process.  

All of these position require PICK experiences working in the
UniVerse environment.  

BS Degree required from a top technical university
U.S. Citizen or Permanent Residency required
Very competitive salary packages plus  bonus plus full benefits.
Please EMAIL your resume as a WORD attachment to:
[EMAIL PROTECTED]
Your resume will remain strictly confidential, and will not be
disclosed to anyone without your prior approval.
   
  Ben Oifer
  Technical Futures, Inc.
  18 Washington Street, #205
  Canton, MA  02021
  Phone: (781) 793-9292
  Email: [EMAIL PROTECTED]
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] Date Conversion Format

2004-06-10 Thread Karjala Koponen
Ed,

Wonderful!  Another technique I had no idea existed.

Karjala


 [EMAIL PROTECTED] 06/10/2004 11:17:14 AM 
D4A {value-mark} MCN

Ed Weissman

- Original Message -
From: Dave S [EMAIL PROTECTED]
To: U2 USERS [EMAIL PROTECTED]
Sent: Thursday, June 10, 2004 10:20 AM
Subject: [U2] Date Conversion Format


 I am using looking for a date format conversion to use. We are using the
 format DDMMY which formats the date to  02 10 1970.

 We are creating an MVQUERY extract and the customer would prefer to
eliminate
 the spaces in the date.

 Is there another date format conversion that we can use or
 we do we have to create another dictionary to remove these blanks ?


 -
 Do you Yahoo!?
 Friends.  Fun. Try the all-new Yahoo! Messenger
 ---
 u2-users mailing list
 [EMAIL PROTECTED]
 To unsubscribe please visit http://listserver.u2ug.org/


 This e-mail was scanned for viruses using BitDefender.
---
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] How keep '\' in unix/uniVerse filenames?

2004-06-10 Thread LeRoi Keiller
A number of our uniVerse files have the \ symbol in the file names.  Problem
is, at unix level, these \ fellows are usually treated as 'escape'
characters and ignored or removed when you try to reference them.  Eg: echo
hello\there displays hellothere.

Does anyone know how to ensure that the unix shell treats these as literal
text?  Note that {}, quotes, and double-quotes don't seem to work.

To elaborate (you can ignore this if you like)...

Cutdown example of what I'm trying to do (ksh):

$ ls TRAN*
TRAN.EXT-14320S1??\4-DF
TRAN.EXT-14320S1??\5-DF
 (note the '\' in the file names)
$ find TRAN* -print | while read file
do
   ls -l $file
done
TRAN.EXT-14320S1??4-DF not found

Note: The 'find' produces the correct names, but subsequent unix commands
missinterpret the meaning.  Because the '\' is stripped, the ls command
tries to list D_TRAN.EXT-14320S1??4-DF instead of TRAN.EXT-14320S1??\4-DF,
and of course the file is not found.

Any ideas?

Thanks,
LeRoi

LeRoi Keiller
Technical Support Consultant
 
Ultradata - Vision to Reality
+61 3 9291 1700
www.ultradata.com.au



Disclaimer Notice
This message contains privileged and confidential information intended only
for the use of the addressee named above. If you are not the intended
recipient of this message you are hereby notified that you must not
disseminate, copy or take any action or place any reliance on it. If you
have received this message in error please notify Ultradata immediately on
+61 3 9291 1600. Any views expressed in this message are those of the
individual sender, except where the sender specifically states them to be
the views of Ultradata Australia Pty. Ltd.

 To unsubscribe from receiving commercial electronic messages from Ultradata
Australia please email [EMAIL PROTECTED] with the subject heading
Unsubscribe.
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] Date Conversion Format

2004-06-10 Thread Dave S
Thanks, we'll see if Mvquery lets me do that.
--- Dana Baron [EMAIL PROTECTED] wrote:
 Or CONVERT   TO  IN DATE.VAR
 
 (The first set of quotes has a blank, the second
 does not).
 
 Dana Baron
 System Manager
 Smugglers' Notch Resort
 
 
 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] Behalf
 Of Kevin King
 Sent: Thursday, June 10, 2004 11:27 AM
 To: [EMAIL PROTECTED]
 Subject: RE: [U2] Date Conversion Format
 
 Could you double-convert?  Convert via D2/ or D4/ to
 start, then MCN
 to remove the symbols.
 
 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On
 Behalf Of Dave S
 Sent: Thursday, June 10, 2004 8:21 AM
 To: U2 USERS
 Subject: [U2] Date Conversion Format
 
 I am using looking for a date format conversion to
 use. We are using
 the format DDMMY which formats the date to  02 10
 1970.
 
 We are creating an MVQUERY extract and the customer
 would prefer to
 eliminate the spaces in the date.
 
 Is there another date format conversion that we can
 use or we do we
 have to create another dictionary to remove these
 blanks ?
 
 
 -
 Do you Yahoo!?
 Friends.  Fun. Try the all-new Yahoo! Messenger
 ---
 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-users mailing list
 [EMAIL PROTECTED]
 To unsubscribe please visit
http://listserver.u2ug.org/





__
Do you Yahoo!?
Friends.  Fun.  Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/ 
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] How keep '\' in unix/uniVerse filenames?

2004-06-10 Thread Ken Wallis
LeRoi Keiller wrote:

 A number of our uniVerse files have the \ symbol in the file
 names.  Problem is, at unix level, these \ fellows are usually treated as
'escape'
 characters

Problem is there are a number of characters which have significant meaning
to pretty much every shell program
that you might use on UNIX and '\' is one of them.  You really want to try
avoiding these special characters if you need to interact with the files via
a shell.

 $ ls TRAN*
 TRAN.EXT-14320S1??\4-DF
 TRAN.EXT-14320S1??\5-DF
  (note the '\' in the file names)
 $ find TRAN* -print | while read file
 do
ls -l $file
 done
 TRAN.EXT-14320S1??4-DF not found

If you just want to delete the files then rm -i TRAN* will probably work.
Otherwise you may be better off setting up a VOC pointer to the appropriate
directory so you can see it as a Type 19 file and process the contents in
BASIC.

Cheers,

Ken
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/