Does anyone have the magic bullet? We have a UniVerse account that was backed
up using uvbackup on an AIX platform. We restored the account on to a Windows
platform and the sky fell in.
Firstly there was the 13 (14?) character naming boundary. File names record
names that were longer than
Jeff,
The indices may still be failing because they are still too long.
Were the long names broken in the Unix system during backup or were they
broken in the Windows system upon restore?
Have you set LONGNAMES ON in the Pick-flavor account? eg:
WHO
5232 uvnt.spooler From W2KAPPSERVER\UV
Hi,
I'm wondering if someone can show me a more elegant way to do a SQL
subquery.
I have a saved select list with a list of values which I want to
test
for in a SQL select IN clause.
Eg.
SELECT @ID FROM EINVOICES WHERE
iInvoiceRef IN (SELECT EVAL
'TRANS('SAVEDLISTS,INV.REF.LIST,-1,)'
FROM VOC
Try the SET.INDEX verb.
Eg
SET.INDEX SOME.LONG.FILE INFORM
Indices for file SOMEL.ONG.FILE reside in
D:\DATA\ACCOUNT\I_SOME.LONGFI\LE
SET.INDEX SOME.LONG.FILE TO D:\DATA\ACCOUNT\I_SOME.LONGFILE
-Original Message-
We restored the account on to a Windows
[snip]
Now the indices on files