[U2] PIOPEN to Universe migration

2005-05-09 Thread John Kent
Can anyone point to a paper on this as ithe references i keep finding no
longer exist

Thanks in advance

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


RE: [U2] OLEDB Driver

2005-05-09 Thread Martin Canty
You could also use Raining Data's PDP product (for .NET), it has an
ADO.NET interface & full metadata management capabilities.

An added bonus is that the performance of the data transfer is, well,
like greased lightning!


Martin

 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Don Kibbey
Sent: Monday, May 09, 2005 10:38 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] OLEDB Driver

I gave up on OLEDB for UniVerse a couple of years ago for the same
reason.  I just could not make it work reliably.  Since your already
using VB, take a look at the UniObjects library.  I've found it works
much better than ODBC or OLEDB, but you'll have to put more effort into
it as it's not capable of producing ADO or ADO.NET objects by itself.

On 5/9/05, Martin. D. Waller <[EMAIL PROTECTED]> wrote:
> Hello,
> 
> I was wondering if anyone else has seen odd happenings with the OLEDB 
> driver. The best description I can come up with is that it randomly 
> generates errors ! In VB you can try to step over lines that access 
> ADO or ADOX objects and these sometimes generate an error. If you drag

> the cursor back and re run the line all is fine. I've not managed to 
> find the common denominator yet but it does seem to generate random
errors ?
> 
> Has anyone else seen this ?
> Does anyone else use the OLEDB driver at all ?
> 
> Many thanks...
> 
> Martin
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] New U2 Personal Editions posted

2005-05-09 Thread Jerry Banker
I've tested it and this one works with the administrator menu. Thanks, Jerry
- Original Message - 
From: "Leroy Dreyfuss" <[EMAIL PROTECTED]>
To: 
Sent: Monday, May 09, 2005 12:24 AM
Subject: [U2] New U2 Personal Editions posted


Folks,

UniVerse 10.1.11 PE has been posted to the Website, as well as UniData
6.1.9. Both are for Windows. UniData 6.1.10 PE for Linux (x86) has also
been posted. UniVerse 10.1 PE for Linux (x86) will be posted in a week or
two, when it's ready.

You will find them at http://www.ibm.com/software/u2/, where under the
Highlights section is a graphic that links to the U2 Trials and Betas site.


Regards,

LeRoy F. Dreyfuss
Product Manager
IBM UniVerse and UniData (U2) Extended Relational Databases
IBM Information Management Software
Tel: 303-672-1254  Fax: 303-294-4832
Mobile: 720-341-4317   Tie-line: 770-1254
External email:  [EMAIL PROTECTED]
WWW:  http://www.ibm.com/software/data/u2
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] OLEDB Driver

2005-05-09 Thread Don Kibbey
I gave up on OLEDB for UniVerse a couple of years ago for the same
reason.  I just could not make it work reliably.  Since your already
using VB, take a look at the UniObjects library.  I've found it works
much better than ODBC or OLEDB, but you'll have to put more effort
into it as it's not capable of producing ADO or ADO.NET objects by
itself.

On 5/9/05, Martin. D. Waller <[EMAIL PROTECTED]> wrote:
> Hello,
> 
> I was wondering if anyone else has seen odd happenings with the OLEDB
> driver. The best description I can come up with is that it randomly
> generates errors ! In VB you can try to step over lines that access ADO or
> ADOX objects and these sometimes generate an error. If you drag the cursor
> back and re run the line all is fine. I've not managed to find the common
> denominator yet but it does seem to generate random errors ?
> 
> Has anyone else seen this ?
> Does anyone else use the OLEDB driver at all ?
> 
> Many thanks...
> 
> Martin
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UniData Indexes

2005-05-09 Thread Baakkonen, Rodney
I forgot to add that it does have to do a LIST.INDEX to get the details
about each index after doing the INDICES. - Rod

-Original Message-
From: Baakkonen, Rodney 
Sent: Monday, May 09, 2005 12:24 PM
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] UniData Indexes


Here is the find command I use in a program to build a data base of our
indexes:

execute.var = "find / \( -name 'idx001' -o -name 'X_*' \) -print >
unidata.indexes.out"

I then loop through each entry in this file doing an INDICES to get the info
on each files. I write the data about indexes on a Unidata file with the
file name as the key. 

On Windows, I don't know what you do. - Rod
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] UniData Indexes

2005-05-09 Thread Marco Antonio Rojas Castro
You need this
SUBROUTINE ALL_INDICES.PRG
*--
$INCLUDE DMSKELCODE COMMON
$INCLUDE DMSKELCODE SBPLUS.EQU
*--
* Escrito por  .- Marco Rojas
* Descripcion  .- LIST ALL INDEX IN AN ACCONUT
*--
EXECUTE 'SETPTR ,3,BANNER INDICES,NFMT,BRIEF' CAPTURING OUT
PRINTER ON
EXECUTE 'SELECT VOC WITH F1 = "F"' CAPTURING OUT
READSELECT A.FILES ELSE A.FILES = ''
LOOP
  REMOVE FILE.NAME FROM A.FILES SETTING DM
  OPEN FILE.NAME TO F.HANDLE THEN
 A.IDX = INDICES(F.HANDLE)
 IF A.IDX<1> THEN
PRINT FILE.NAME
PRINT CHANGE(A.IDX, @AM, ', ')
 END
 PRINT
 CLOSE F.HANDLE
  END
UNTIL DM = 0 DO REPEAT
PRINTER OFF
PRINTER CLOSE
* THEN EDIT FILE _HOLD_ ITEM INDICES
RETURN
Original Message Follows
From: Andy Squires <[EMAIL PROTECTED]>
Reply-To: u2-users@listserver.u2ug.org
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UniData Indexes
Date: Mon, 9 May 2005 12:42:42 -0400 (EDT)
Yes, that's correct.  I want to see each index, not just whether or not 
there is an index.

Thanks,
Andy
On Mon, 9 May 2005 [EMAIL PROTECTED] wrote:
> That is only going to tell you which files are indexed and not show each 
index (which is probably what you were asking for).
>
> -- Original message --
>
> > In Universe I do...
> >
> > COMO ON SCOTT
> > SELECTF
> > SET.INDEX INFORM
> > COMO OFF
> >
> > Not sure if this works in UD though.
> >
> > -- Original message --
> >
> > > Hi all,
> > >
> > > Is there a way to get a list of all indexes on all files in a 
particular
> > > account? The only way I thought
> > > to do this was to loop through a list of all the files and do a 
LIST.INDEX
> > > command. Seems like there
> > > should be a better way.
> > >
> > > This is on UniData 6.0.
> > >
> > > Thanks,
> > >
> > > Andy
> > >
> > >
> > > | Andy Squires -- Systems Analyst |
> > > | Office of Information Technology -- American University |
> > > | (202) 885-2785 |
> > > ---
> > > u2-users mailing list
> > > u2-users@listserver.u2ug.org
> > > To unsubscribe please visit http://listserver.u2ug.org/
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
>

|   Andy Squires -- Systems Analyst  
 |
|   Office of Information Technology -- American University  
 |
|   (202) 885-2785   
 |
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UniData Indexes

2005-05-09 Thread Baakkonen, Rodney
Here is the find command I use in a program to build a data base of our
indexes:

execute.var = "find / \( -name 'idx001' -o -name 'X_*' \) -print >
unidata.indexes.out"

I then loop through each entry in this file doing an INDICES to get the info
on each files. I write the data about indexes on a Unidata file with the
file name as the key. 

On Windows, I don't know what you do. - Rod

-Original Message-
From: Jeffrey Butera [mailto:[EMAIL PROTECTED]
Sent: Monday, May 09, 2005 11:10 AM
To: u2-users@listserver.u2ug.org; Andy Squires
Subject: Re: [U2] UniData Indexes


On Monday 09 May 2005 10:34, Andy Squires wrote:
> Hi all,
>
> Is there a way to get a list of all indexes on all files in a particular
> account?  The only way I thought to do this was to loop through a list of
> all the files and do a LIST.INDEX command.  Seems like there should be a
> better way.
>
> This is on UniData 6.0.

Hi Andy

I have a good unix trick to do this, provide you have slocate installed. 
Unidata indices are stored as separate files at the OS level named 
'X_filename'.  Hence, if you have slocate, you could do this:

locate X_ | more

If you want to weed out by Datatel account, you could add grep and friends:

locate X_ | grep collive | more

and so on.  Not on Unix - too bad. :)

-- 
Jeff Butera, Ph.D.
Administrative Systems
Hampshire College
[EMAIL PROTECTED]
413-559-5556

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


Re: [U2] UniData Indexes

2005-05-09 Thread Marco Antonio Rojas Castro
Try this
SUBROUTINE VER.INDICES.PRG
*--
$INCLUDE DMSKELCODE COMMON
$INCLUDE DMSKELCODE SBPLUS.EQU
*--
* Escrito por  .- Marco Rojas
* Fecha Creada .- 13/06/02 12:15:50
* Descripcion  .- MUESTRA LOS INDICES DEL ARCHIVO
*--
ARCHIVO = PARAM
CALL SB.OPEN.FILE(ARCHIVO, F.ARCH, FLAG) ; IF FLAG THEN RETURN
A.IDX = INDICES(F.ARCH)
N.IDX = DCOUNT(A.IDX,@AM)
RES = 'Archivo ': ARCHIVO :' - ': N.IDX :' INDICES'
FOR I = 1 TO N.IDX
  R.IDX = INDICES(F.ARCH, A.IDX)
  RES := @VM: A.IDX :' ': R.IDX<1,1> :' ': R.IDX<6> :' / Regenerar 
':R.IDX<1,4>
  LIN = CHANGE(R.IDX<2>, ';', @AM)
  N.LIN = DCOUNT(LIN, @AM)
  FOR J = 1 TO N.LIN
 RES := @VM: ' ': TRIM(LIN)
  NEXT I
NEXT I
CALL SB.PROCESS('S:SELECT ':RES:' (B0,0')
RETURN


Original Message Follows
From: Andy Squires <[EMAIL PROTECTED]>
Reply-To: u2-users@listserver.u2ug.org
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] UniData Indexes
Date: Mon, 9 May 2005 12:42:42 -0400 (EDT)
Yes, that's correct.  I want to see each index, not just whether or not 
there is an index.

Thanks,
Andy
On Mon, 9 May 2005 [EMAIL PROTECTED] wrote:
That is only going to tell you which files are indexed and not show each 
index (which is probably what you were asking for).

-- Original message --
> In Universe I do...
>
> COMO ON SCOTT
> SELECTF
> SET.INDEX INFORM
> COMO OFF
>
> Not sure if this works in UD though.
>
> -- Original message --
>
> > Hi all,
> >
> > Is there a way to get a list of all indexes on all files in a 
particular
> > account? The only way I thought
> > to do this was to loop through a list of all the files and do a 
LIST.INDEX
> > command. Seems like there
> > should be a better way.
> >
> > This is on UniData 6.0.
> >
> > Thanks,
> >
> > Andy
> >
> >
> > | Andy Squires -- Systems Analyst |
> > | Office of Information Technology -- American University |
> > | (202) 885-2785 |
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

|   Andy Squires -- Systems Analyst  
 |
|   Office of Information Technology -- American University  
 |
|   (202) 885-2785   
 |
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UniData Indexes

2005-05-09 Thread Marco Antonio Rojas Castro
450 Lynx formatting failed: open3: exec of lynx --stdin --dump --force_html 
--hiddenlinks=ignore --localhost --image_links --nolist --noredir --noreferer 
--realm failed at /etc/smrsh/demime line 1519
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] UniData Indexes

2005-05-09 Thread Andy Squires
Yes, that's correct.  I want to see each index, not just whether or not there 
is an index.

Thanks,

Andy
On Mon, 9 May 2005 [EMAIL PROTECTED] wrote:

> That is only going to tell you which files are indexed and not show each 
> index (which is probably what you were asking for).
>
> -- Original message --
>
> > In Universe I do...
> >
> > COMO ON SCOTT
> > SELECTF
> > SET.INDEX INFORM
> > COMO OFF
> >
> > Not sure if this works in UD though.
> >
> > -- Original message --
> >
> > > Hi all,
> > >
> > > Is there a way to get a list of all indexes on all files in a particular
> > > account? The only way I thought
> > > to do this was to loop through a list of all the files and do a LIST.INDEX
> > > command. Seems like there
> > > should be a better way.
> > >
> > > This is on UniData 6.0.
> > >
> > > Thanks,
> > >
> > > Andy
> > >
> > >
> > > | Andy Squires -- Systems Analyst |
> > > | Office of Information Technology -- American University |
> > > | (202) 885-2785 |
> > > ---
> > > u2-users mailing list
> > > u2-users@listserver.u2ug.org
> > > To unsubscribe please visit http://listserver.u2ug.org/
> > ---
> > u2-users mailing list
> > u2-users@listserver.u2ug.org
> > To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> u2-users@listserver.u2ug.org
> To unsubscribe please visit http://listserver.u2ug.org/
>

|   Andy Squires -- Systems Analyst   |
|   Office of Information Technology -- American University   |
|   (202) 885-2785|
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] OLEDB Driver

2005-05-09 Thread Martin. D. Waller
Hello,

I was wondering if anyone else has seen odd happenings with the OLEDB
driver. The best description I can come up with is that it randomly
generates errors ! In VB you can try to step over lines that access ADO or
ADOX objects and these sometimes generate an error. If you drag the cursor
back and re run the line all is fine. I've not managed to find the common
denominator yet but it does seem to generate random errors ?

Has anyone else seen this ?
Does anyone else use the OLEDB driver at all ?

Many thanks...

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


RE: [U2] UniData Indexes

2005-05-09 Thread Alfke, Colin
You could do a x = FILEINFO(file.var,13) to see if there is an index -
or sort the directory looking for X_ files, but then you would have to
watch out for Dynamic files.

You can use the INDICES function to return the index arguments. It will
also tell you if an index is there or not.

You can do some testing to see which way works best/is faster.

Hth
Colin Alfke
Calgary, Canada

>-Original Message-
>From: Andy Squires
>
>Hi all,
>
>Is there a way to get a list of all indexes on all files in a 
>particular account?  The only way I thought to do this was to 
>loop through a list of all the files and do a LIST.INDEX 
>command.  Seems like there should be a better way.
>
>This is on UniData 6.0.
>
>Thanks,
>
>Andy
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] UniData Indexes

2005-05-09 Thread Jeffrey Butera
On Monday 09 May 2005 10:34, Andy Squires wrote:
> Hi all,
>
> Is there a way to get a list of all indexes on all files in a particular
> account?  The only way I thought to do this was to loop through a list of
> all the files and do a LIST.INDEX command.  Seems like there should be a
> better way.
>
> This is on UniData 6.0.

Hi Andy

I have a good unix trick to do this, provide you have slocate installed. 
Unidata indices are stored as separate files at the OS level named 
'X_filename'.  Hence, if you have slocate, you could do this:

locate X_ | more

If you want to weed out by Datatel account, you could add grep and friends:

locate X_ | grep collive | more

and so on.  Not on Unix - too bad. :)

-- 
Jeff Butera, Ph.D.
Administrative Systems
Hampshire College
[EMAIL PROTECTED]
413-559-5556

"...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: [U2] UniData Indexes

2005-05-09 Thread iggchamp
That is only going to tell you which files are indexed and not show each index 
(which is probably what you were asking for).

-- Original message -- 

> In Universe I do... 
> 
> COMO ON SCOTT 
> SELECTF 
> SET.INDEX INFORM 
> COMO OFF 
> 
> Not sure if this works in UD though. 
> 
> -- Original message -- 
> 
> > Hi all, 
> > 
> > Is there a way to get a list of all indexes on all files in a particular 
> > account? The only way I thought 
> > to do this was to loop through a list of all the files and do a LIST.INDEX 
> > command. Seems like there 
> > should be a better way. 
> > 
> > This is on UniData 6.0. 
> > 
> > Thanks, 
> > 
> > Andy 
> > 
> > 
> > | Andy Squires -- Systems Analyst | 
> > | Office of Information Technology -- American University | 
> > | (202) 885-2785 | 
> > --- 
> > u2-users mailing list 
> > u2-users@listserver.u2ug.org 
> > To unsubscribe please visit http://listserver.u2ug.org/ 
> --- 
> u2-users mailing list 
> u2-users@listserver.u2ug.org 
> To unsubscribe please visit http://listserver.u2ug.org/ 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UniData Indexes

2005-05-09 Thread Martin Canty
Hi Andy,

My usual trick is to look for OS level files befinning with "X_"  that
will cut the search sown to the files which have indexes...

N.B. X_ is a prefix a bit like D_ (for dictionary files)


Martin

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andy Squires
Sent: Monday, May 09, 2005 7:34 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] UniData Indexes

Hi all,

Is there a way to get a list of all indexes on all files in a particular
account?  The only way I thought to do this was to loop through a list
of all the files and do a LIST.INDEX command.  Seems like there should
be a better way.

This is on UniData 6.0.

Thanks,

Andy


|   Andy Squires -- Systems Analyst
|
|   Office of Information Technology -- American University
|
|   (202) 885-2785
|
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] New U2 Personal Editions posted

2005-05-09 Thread Shawn Waldie
Any special considerations for x86_64?

-Original Message-
From: Leroy Dreyfuss [mailto:[EMAIL PROTECTED] 
Sent: Sunday, May 08, 2005 11:24 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] New U2 Personal Editions posted


Folks,

UniVerse 10.1.11 PE has been posted to the Website, as well as UniData
6.1.9. Both are for Windows. UniData 6.1.10 PE for Linux (x86) has also
been posted. UniVerse 10.1 PE for Linux (x86) will be posted in a week
or two, when it's ready.

You will find them at http://www.ibm.com/software/u2/, where under the
Highlights section is a graphic that links to the U2 Trials and Betas
site.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


Re: [U2] UniData Indexes

2005-05-09 Thread iggchamp
In Universe I do...

COMO ON SCOTT
SELECTF
SET.INDEX INFORM
COMO OFF

Not sure if this works in UD though.

-- Original message -- 

> Hi all, 
> 
> Is there a way to get a list of all indexes on all files in a particular 
> account? The only way I thought 
> to do this was to loop through a list of all the files and do a LIST.INDEX 
> command. Seems like there 
> should be a better way. 
> 
> This is on UniData 6.0. 
> 
> Thanks, 
> 
> Andy 
> 
> 
> | Andy Squires -- Systems Analyst | 
> | Office of Information Technology -- American University | 
> | (202) 885-2785 | 
> --- 
> u2-users mailing list 
> u2-users@listserver.u2ug.org 
> To unsubscribe please visit http://listserver.u2ug.org/ 
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


RE: [U2] UniData Indexes

2005-05-09 Thread Kevin King
That's the only way I've seen it done. 

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andy Squires
Sent: Monday, May 09, 2005 8:34 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] UniData Indexes

Hi all,

Is there a way to get a list of all indexes on all files in a
particular account?  The only way I thought to do this was to loop
through a list of all the files and do a LIST.INDEX command.  Seems
like there should be a better way.

This is on UniData 6.0.

Thanks,

Andy


|   Andy Squires -- Systems Analyst
|
|   Office of Information Technology -- American University
|
|   (202) 885-2785
|
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/

--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.7 - Release Date: 5/9/2005
 

-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.7 - Release Date: 5/9/2005
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] Herve Balestrieri/France/IBM est absent ce jour 09/05/2005. In english : is out of office today Monday May 9th, 2005.

2005-05-09 Thread Herve Balestrieri
I will be out of the office starting  09/05/2005 and will not return until
10/05/2005.

Pour les clients accidant au Support Technique des produits IBM "U2",
veuillez renvoyer votre message sur : [EMAIL PROTECTED]
Merci

For non-french speaking customers : If your  IBM "U2" products Technical
Support centre is France, please re-send messages to : [EMAIL PROTECTED]
Otherwise, IBM "U2" products Technical Support in UK/EMEA email is :
[EMAIL PROTECTED]

Support Technique IBM - Produits "U2"
IBM Data Management Solutions
Tel.: N0 VERT International   00 800 2535 2535 (France et Belgique)
+44 208 844 3076 (autres pays/other countries)
Fax:  +33 (0) 49 31 45 58
Web: http://www.ibm.com/software/u2/

IBM
Centre de Support Technique IBM Produits "U2"
7630 - 04S03
Immeuble "Marne La Vallie 1"
1, Place Jean-Baptiste Climent
93881 Noisy-le-Grand Cedex
France

e-mail Support Technique IBM "U2" : [EMAIL PROTECTED]
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] wIntegrate Query Builder 3.x or 5.x & UniData 5.1.7

2005-05-09 Thread Hruby, Paul
Greetings,
Has anyone ran across a Query Builder issue with In-Line Prompting and the
date format?
I have the following:

Verb: SORT
File: FILENAME
Items:
Sort:
Output: RPTDATE DESC
Heading:
Footing:
Grand total:
Output to:
PC/Process:
PC Filename: C:\TEMP\TEMP.XLS
Application:Excel or Excel 97
Show as: Worksheet or Workbook
`   File Use:
Open Application or Create Only
Advanced:
Timeout 10; Retries 3; Mode: Capture
Before: SELECT FILENAME WITH RPTDATE BETWEEN "<>"
"<>"

When running the above, I get the normal window popup where you enter the
beginning and ending dates.  I enter:
01/01/2005
01/15/2005
The process fails with an error message in the import window that I can't
read (too fast) and the second error message states: Query Import to PC
failed; Nothing to import, No items selected.
If I change the dates to
01-01-2005
01-15-2005
then it runs fine.

When running the above to the screen, everything reports as it should.
I've poured over the scripts trying to see where a script could possible
choke on the '/' character, but I haven't found anything yet.
The Import window displays a /SELECT FILENAME WITH RPTDATE BETWEEN
01/01/2005 01/15/2005 /REPORT SORT FILENAME   RPTDATE DESC, which I think is
where the problem is, but how can I change the command delimter from a '/'
to something else that the system would understand?  And why would this work
to the screen and not to a PC process?

The problem occurs with either 3.x or 5.x versions.

Thanks in advance ( I receive the list via digest mode, so I might be
delayed in responding back)

Paul
Paul Hruby
Police Database Coordinator
Scottsdale Police Department
*** Information sent from & received by this email address may be considered
public information ***
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/


[U2] UniData Indexes

2005-05-09 Thread Andy Squires
Hi all,

Is there a way to get a list of all indexes on all files in a particular 
account?  The only way I thought
to do this was to loop through a list of all the files and do a LIST.INDEX 
command.  Seems like there
should be a better way.

This is on UniData 6.0.

Thanks,

Andy


|   Andy Squires -- Systems Analyst   |
|   Office of Information Technology -- American University   |
|   (202) 885-2785|
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/