RE: [U2] [UV] Editing Paired Value Marks - Victory
BTW, if you're using AE, you could also invoke the Editing Values capability by typing EV on the line with the multivalues you wish to edit. 1: Sales.Order.ID_1^253^253Sales.Order.ID_2^253Sales.Order.ID_3 EV return - This turns on the editing of values P return- displays multivalues as if they were attributes 1: Sales.Order.ID_1 2: - extra value 3: Sales.Order.ID_2 4: Sales.Order.ID_3 2 return- Select the second value to edit / delete 2: D return- Delete the extra multivalue, 3rd moves up to 2nd 2: Sales.Order.ID_2 FI return - File the changes to the multivalues Result - 1: Sales.Order.ID_1^253Sales.Order.ID_2^253Sales.Order.ID_3 This is something the UniData people have been able to do for a while. To make things even more interesting, EVS invokes the editing of subvalues. Mark Olarte Northwest Information Systems -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Wednesday, August 13, 2008 11:05 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UV] Editing Paired Value Marks - Victory Thanks to those who responded. Using AE I was able to do a... 1: C/Sales.Order.ID^253/Sales.Order.ID --Bill --- 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] uniobjects
What version of UniObjects are you using for .NET versus the VB6 client? There is should only be one version and one instance of UniRPCD on the server. IN theory you could have multiple versions - but that would be a really *bad* idea. You also have to be using the correct client for that version. Otherwise, you may not connect or not reliably at least. You manually start UniRPCD from UNIX: (amend for your path to your UV home directory): nohup /usr/ibm/unishared/unirpc/unirpcd Best not to run it on the commnad line and redirect standard input/output/error to a file. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of doug chanco Sent: Thursday, 14 August 2008 3:08 AM To: u2-users@listserver.u2ug.org Subject: [U2] uniobjects does anyone know if its possible to run the uvrpc deamon (uniobjects) from the command line? It appears that since we cannot find the problem we are going to rewrite our order entry program in .net from vb6, apparently from some initial testing that the .net version fo the program works whereas the vb6 version is still having problems. Also is anyone aware of any ways to see what a deamon (in particular uvrpc) is doing? We have talked to IBM and apparently the best suggestion we got from them was that the issue was being caused by the network card in the systems (which have been the same for years) so I am not even sure where that idea came from. is anyone aware of any differences that would cause code written in .net to work versus code written in vb6 (I assume they are using different dll's anything on the server side)? Also does the uvrpc have different daemons for .net and non .net? thanks everyone dougc --- 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] can anyone shed any light on parts of this core file?
Sorry Doug no light to shed on the core, the problem with a core is that it also dumps the constant lists of the code which is why you seem to get every error under the sun in there. However just to say I have had experience of strange errors in uniobjects in the past on heavily used systems, this was because the network card was set to 100/full duplex, and the switch port to auto negotiate, so they negotiated to half duplex, we set the switch to full duplex and of course it was faster, but we also lost the errors - may be something to investigate. Rgds Symeon. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of doug chanco Sent: 13 August 2008 23:17 To: u2-users@listserver.u2ug.org Subject: [U2] can anyone shed any light on parts of this core file? well i finally got a core file but had no luck trying to read it with dbx (so I just vi'ed the file and below is what I was able to read) I am praying that one of you universe/aix/uniobjects guru's can see if anything below is useful in finding our problem. thanks! dougc -I/r-b/r-y/r. /r.,/r.=/r.P/r.e/r.^@/r.^U/r.$/r.@/r.V/r.}/r/^W/r/*/r/Muv_=/usr/ib m/uv/bin/uvLANG=CLOGIN=carrmaPATH=/usr/bin:/usr/lbin:/usr/bin:/etc:/usr/sbin :/us r/ucb:/usr/bin/X11:/sbin:/usr/java14/jre/bin:/usr/java14/bin:/usr/local/samb a/sb in:/usr/ibm/uv/bin:/usr/opt/uv/bin:.LC__FASTMSG=trueCGI_DIRECTORY=/var/docse arch /cgi-binLOGNAME=carrmaLOCPATH=/usr/lib/nls/locUVPATH=/usr/ibm/uv/binDOCUMENT _SER VER_MACHINE_NAME=localhostUSER=carrmaAUTHSTATE=compatSHELL=/usr/bin/kshODMDI R=/e tc/objreposDOCUMENT_SERVER_PORT=49213HOME=/home/everybodyTERM=viewpointITECO NFIG SRV=/etc/IMNSearchPWD=/usr2/zircon/INSTDOCUMENT_DIRECTORY=/usr/docsearch/htm lTZ= EST5EDT,M3.2.0,M11.1.0UVHOME=/usr/ibm/uvITECONFIGCL=/etc/IMNSearch/clientsIT E_DO C_SEARCH_INSTANCE=searchNLSP^-o/r+@ ^Eth^A/r,D/r,L^-o^-o^-o^-o^-o^-o^-o^ -o^-o^-o^-o^-o^-o^-o^-o^-o^-o^-o^-o^-o^-o^-o ^AD^P^E^-o^P^Ax ^KR H/r/x@(#)61 1.13 src/bos/usr/ccs/lib/libc/__threads_init.c, libcthrd, bos43 N 3/25/99 13:50:27 ^Eth ^EP^P-UVTLSVC-TLTIMEOUT %cUVLICENSECHECK%dUVL ICENSECHECKUVLICENSECHECKselect is over. about to select. received %d, %s, %s, %u received %s, %s, %s, %s write failed, errno is %d. @(#)UniVerse Version 10.1.7%c%cA%cR%cD%cT%c%c%c%c%c%c%cioctl TCGETA failed, errn o %d Now get client identification about to write escape sequence. ioctl TCSETAW failed, errno %d. FD NOT SET on readfds, errno %d. select returned 0; timeout, errno %d. Debugging UNIX telnet server with timeout as 60. Copyright ) IBM Corporation 2001, 2005. All rights reserved.%Z%UniVerse Platfor m: International Business Machines (IBM) RS6000/AIX/r,0w%s-S%s%c%s VOC^A^A^BYesIdealON.EXIT10.1.7CVIEW ^H ^E8ON.ABORT^G ^E^X^H ^EPUV.LOGINphantom^E ^E^P^D ^E ^F ^E mkaccountALTER.IC updaccountMAXTRANSBUFUV_USERNO=LONGNAMES ON/b in/mkaccount/bin/updaccountBUILD.INDEX PHANTOMLONGNAMES ON NEWACCUPDATE.INDEX PH ANTOMRUN APP.PROGS UV.UPGRADESET.INDEX UV.TRANS INFORMBUILD.INDEX UV.TRANS FILER UN APP.PROGS PACKAGE.INSCREATE.INDEX UV.TRANS FILESPECIAL.EDITOR.SELECT.DATA@(#) UniVerse Version 10.1.7Copyright ) IBM Corporation 2001, 2005. All rights reser ved.%Z%UniVerse Platform: International Business Machines (IBM) RS6000/[EMAIL PROTECTED] ^K ^TCS5 -dWHORUNIAMTIMETERMRAIDQUITLOCKJOBSHUSHDATECORECHAPCASEBELLusrsUMASKT.REWT .FWDT.EODT.BCKSLEEPPTIMELOGTOLOGONLIMITCHDIRBREAKABORTTEMPBELLTERM%s=%iT.WE OFT. READSETPTRNOTIFYLOGOUTASSIGNT.WTLBLT.RDLBLSP.TAPERELEASEQSELECTPHANTOMNSELEC TDIS PLAYCATALOGLOGNAMEWARNINGSUVPROMPTUNASSIGNT.UNLOADGET.LIST^E ^H4^A ^G^FSAVE.LIST LIST.DIFFGET.STACKFORM.LISTCLEARDATAUV_USERNOSET.TELNETSAVE.STACKMERGE.LISTL IST. UNIONLIST.LOCKSLIST.INTERDIVERT.OUTAUTOLOGOUT/bin/usrsRELEASE.XMLPREPARE.XML LOGT O.ABORTGET.SQLNULLENVIRONMENTDELETE.LISTDATE.FORMATCLEARSELECTCLEARCOMMONCLE AR.L OCKSABORT.LOGINPAGE.MESSAGECLEARPROMPTS/tmp/utmp.%d5SET.REMOTE.IDSET.TERM.EU ROGE T.TERM.EUROCENTURY.PIVOTSETPTR.DEFAULTSET.SYSTEM.EUROGET.SYSTEM.EUROSET.CONV ERT. TERM.EUROGET.CONVERT.TERM.EURO \'~}|,^GDICTSAVEDLISTSSTACKWRITERELLEVELLOGI NDEVICEPDICTONONOFFOFFTapeProcVerbMenuQueryPerformExecuteParagraphTransact ionR AID debuggerClient programExternal programCommand LanguageBASIC run machinewrarw a r+w+a+r+w+a+ ^LLfeofsemopfgetcfreadfputcftellfseekuvnetDBreadferrorfilenofflus hfclosefwriteDBfinfoDBwblokDBrbloksselectDBwriteDBprobeDBclrflDBcloseDBstatu sDBs electDBdeleteDBscnat25DBreleaseDBReadLocknetgetstatsnetgetinfo30DBrecordlock edmi smatch: offset = %ld, outoff = %ld ^ATCP^A^Atcpuvrpc0x%8x 0x%8x ^A,ARG DATA TIMESTAMP 0x%8x MESSAGE Key 0x%8d 0x%8x 0x%8x In rpc_init() In uvrpc_call In uvrpc_call MESSAGE LENGTH 0x%4x 0x%4x NW RETURN CODE In send packet In read packet In build packet In write packet In read message before the recv In unpack packet 0x%2x 0x%2x 0x%2x message_length=%d message_length=%d message_length=%d before the select 0x%4x %x %d (%.*s) thissize set to %d
RE: [U2] TCL literal select
Try: LIST PARTS F1 WITH EVAL COUNT(F1, CHAR(034)) NE 0 Thanks, David A. Green www.dagconsulting.com (480) 813-1725 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway Sent: Tuesday, August 12, 2008 1:00 PM To: u2-users@listserver.u2ug.org Subject: [U2] TCL literal select Hi, I work with a Unidata/Dataflo system on HPUX. I am having trouble selecting records in my PARTS file. I want to select all parts that have a in the description field (F1). People have been using instead of INCH. This causes problems for me during processing some reports and exports. I have tried quite a few select statements with no success. LIST PARTS WITH F1 = [//] LIST PARTS WITH F1 = // LIST PARTS WITH F1 = /''/ LIST PARTS WITH F1 = [''] LIST PARTS WITH F1 = '' LIST PARTS WITH F1 = /''/ LIST PARTS WITH F1 = \[]\ LIST PARTS WITH F1 = [\\] LIST PARTS WITH F1 = '' Wildcards on my system are brackets, [ leading and ] following Any ideas on what would work? Somebody showed me once, so I know it can be done. I lost my notes though. Thanks, Bruce Ordway Viking Engineering Development Inc. 5750 Main St. N.E. Fridley, MN 55432 Visit us at www.Vikingeng.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. --- 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] [UV] Editing Paired Value Marks - Yet Another Victory
Clif: Yes... I was using the standard UV ED editor. Mark Olarte's post to use AE in EV mode is a big help. Thanks Mark! --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Clifton Oliver Sent: Thursday, August 14, 2008 1:14 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] Editing Paired Value Marks Bill, The assumption is that you are using the standard UniVerse ED editor. What editor are you using? Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On Aug 13, 2008, at 5:13 PM, Brutzman, Bill wrote: Ray: Thanks for writing but the double-carat technique did not work on what I have here. --Bill -Original Message- [mailto:[EMAIL PROTECTED] Behalf Of Ray Wurlod C/^^253^^253/^^253/ --- 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] TCL literal select
I think Bruce must in ECLTYPE P if he is using the [] wild cards, so he will have to convert to ECLTYPE U to use the EVAL keyword (i.e. lIST or list ...) to test your suggestion. From: David A. Green [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject: RE: [U2] TCL literal select Date: Thu, 14 Aug 2008 05:55:46 -0700 Try: LIST PARTS F1 WITH EVAL COUNT(F1, CHAR(034)) NE 0 Thanks, David A. Green www.dagconsulting.com (480) 813-1725 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway Sent: Tuesday, August 12, 2008 1:00 PM To: u2-users@listserver.u2ug.org Subject: [U2] TCL literal select Hi, I work with a Unidata/Dataflo system on HPUX. I am having trouble selecting records in my PARTS file. I want to select all parts that have a in the description field (F1). People have been using instead of INCH. This causes problems for me during processing some reports and exports. I have tried quite a few select statements with no success. LIST PARTS WITH F1 = [//] LIST PARTS WITH F1 = // LIST PARTS WITH F1 = /''/ LIST PARTS WITH F1 = [''] LIST PARTS WITH F1 = '' LIST PARTS WITH F1 = /''/ LIST PARTS WITH F1 = \[]\ LIST PARTS WITH F1 = [\\] LIST PARTS WITH F1 = '' Wildcards on my system are brackets, [ leading and ] following Any ideas on what would work? Somebody showed me once, so I know it can be done. I lost my notes though. Thanks, Bruce Ordway Viking Engineering Development Inc. 5750 Main St. N.E. Fridley, MN 55432 Visit us at www.Vikingeng.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. --- 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] TCL literal select
Or simply use a lower case LIST (i.e. list) to force it to ECLTYPE U for that one statement. This works for list ..., select ..., etc. This is a VERY useful way to use U flavored syntax in a P environment. There is a similar command for compiling basic programs. Make the first line of your code (even a subroutine): $BASICTYPE P or $BASICTYPE U to force it to compile in the desired mode. John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kebbon Irwin Sent: Thursday, August 14, 2008 10:48 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] TCL literal select I think Bruce must in ECLTYPE P if he is using the [] wild cards, so he will have to convert to ECLTYPE U to use the EVAL keyword (i.e. lIST or list ...) to test your suggestion. From: David A. Green [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject: RE: [U2] TCL literal select Date: Thu, 14 Aug 2008 05:55:46 -0700 Try: LIST PARTS F1 WITH EVAL COUNT(F1, CHAR(034)) NE 0 Thanks, David A. Green www.dagconsulting.com (480) 813-1725 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway Sent: Tuesday, August 12, 2008 1:00 PM To: u2-users@listserver.u2ug.org Subject: [U2] TCL literal select Hi, I work with a Unidata/Dataflo system on HPUX. I am having trouble selecting records in my PARTS file. I want to select all parts that have a in the description field (F1). People have been using instead of INCH. This causes problems for me during processing some reports and exports. I have tried quite a few select statements with no success. LIST PARTS WITH F1 = [//] LIST PARTS WITH F1 = // LIST PARTS WITH F1 = /''/ LIST PARTS WITH F1 = [''] LIST PARTS WITH F1 = '' LIST PARTS WITH F1 = /''/ LIST PARTS WITH F1 = \[]\ LIST PARTS WITH F1 = [\\] LIST PARTS WITH F1 = '' Wildcards on my system are brackets, [ leading and ] following Any ideas on what would work? Somebody showed me once, so I know it can be done. I lost my notes though. Thanks, Bruce Ordway Viking Engineering Development Inc. 5750 Main St. N.E. Fridley, MN 55432 Visit us at www.Vikingeng.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] tape backups
Our new machine has a DLT tape carousel system. Since it should just be backing up aix data files, so long as we don't access the files during the backup, there shouldn't be any issues with that type of tape, right? thanks Roger --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2.NET v IBM.NET v UNIOBJECTS.NET
Hi Susan UniObjects.net is the .Net version of UniObjects (sic) - that exposes a the native MultiValue features all nicely wrapped into classes. For details, take a look at my primer 'Writing your First UniVerse Application' on the U2UG site. That walks you through UniObjects.Net and VB.Net Express. The other main option is the IBM ADO.NET provider, which exposes a mainstream relational view of UniVerse, but with better handling for stored procedures (AKA Basic subroutines) than some previous APIs. For details, take a look at my article in a recent Spectrum (can't remember which one). If I'm right in my nomenclature, U2.NET is a version of Blufinity's mv.Net provider that has been bought by IBM, and that's a totally different kettle of fish.. It's the work of one David Cooper who previously wrote the TransVerse APIs for cross-database operations and is a chap who knows his onions. I'll be reviewing the latest version of that later on in the year... Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: 13 August 2008 22:03 To: u2-users@listserver.u2ug.org Subject: [U2] U2.NET v IBM.NET v UNIOBJECTS.NET Greetings, I'm studying the U2 University Agenda to see what mischief I can get into. Anyone know what is the difference between IBM.NET, U2.NET and UNIOBJECTS.NET? There are three distinct sessions at U2U on these. TIA, Susan --- 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] Universe conversion migration
Sorry if I'm stating the obvious, but UniVerse has been stopped (i.e. completely shut down) when you took that tar? Remember that type 30 files keep their header information in shared memory until UniVerse is closed down, so any tar whilst UniVerse has the file open (even if quiescent) may be unreliable. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 14 August 2008 17:28 To: u2-users@listserver.u2ug.org Subject: [U2] Universe conversion migration We're moving from one machine running AIX 4.3 and Universe 9.5 to a new machine running AIX 5.3 and Universe 10.2.4. Using tar. The majority of the move goes fine. Usual hassles. Recataloging, Reindexing. But two critical large files repeatedly are a problem. Both are type 30s. And appear fine on the original machine. Once moved, we can't even count them without the following message. WARNING: Internal file corruption detected during file open! File must be repaired, possible truncation. hsize: 2048 bsize: 2048 fsize: 1073741312 WARNING: Internal file corruption detected during file open! File must be repaired, possible truncation. hsize: 2048 bsize: 2048 fsize: 1073741312 Unable to open GL.DETAILS file. And uvfilefix just curls up its toes and dies. Production machine shows 1,048,576 -rw-rw-rw- root sys 1,073,741,312 (same as the fsize). The other file PAYABLES shows 1,048,576 -rw-rw-rw- root sys 1,073,741,312 ---was there some change in type 30 formating between 9.5 and 10+? that we didn't know about. I've only been with this company for 7 months, but we so far haven't had to repair any files. These are the only two files with problems and we can break them into smaller non-30 files for the move and then recombine them.But if anybody knows of a type 30 issue, then I'd appreciate any heads up. thanks Roger Glenfield --- 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] TCL literal select
David: That will work on my UD system, in PICK mode (using the UD parser). Bill -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of David A. Green Sent: Thursday, August 14, 2008 5:56 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] TCL literal select Try: LIST PARTS F1 WITH EVAL COUNT(F1, CHAR(034)) NE 0 Thanks, David A. Green www.dagconsulting.com (480) 813-1725 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway Sent: Tuesday, August 12, 2008 1:00 PM To: u2-users@listserver.u2ug.org Subject: [U2] TCL literal select Hi, I work with a Unidata/Dataflo system on HPUX. I am having trouble selecting records in my PARTS file. I want to select all parts that have a in the description field (F1). People have been using instead of INCH. This causes problems for me during processing some reports and exports. I have tried quite a few select statements with no success. LIST PARTS WITH F1 = [//] LIST PARTS WITH F1 = // LIST PARTS WITH F1 = /''/ LIST PARTS WITH F1 = [''] LIST PARTS WITH F1 = '' LIST PARTS WITH F1 = /''/ LIST PARTS WITH F1 = \[]\ LIST PARTS WITH F1 = [\\] LIST PARTS WITH F1 = '' Wildcards on my system are brackets, [ leading and ] following Any ideas on what would work? Somebody showed me once, so I know it can be done. I lost my notes though. Thanks, Bruce Ordway Viking Engineering Development Inc. 5750 Main St. N.E. Fridley, MN 55432 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] tape backups
There's a dbpause / dbresume command on unidata that looks like it would make backups safer: dbpause is a UniData system-level command that blocks most updates to the database made in a UniData session. Any updates made from the operating system level are not blocked. You can use this feature to perform some tasks that normally require UniData to be stopped, such as backing up your data. When the dbpause command is issued, all current writes and transactions complete before UniData pauses. Updates are blocked until the system administrator executes the dbresume command. Edward -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 14 August 2008 17:33 To: u2-users@listserver.u2ug.org Subject: [U2] tape backups Our new machine has a DLT tape carousel system. Since it should just be backing up aix data files, so long as we don't access the files during the backup, there shouldn't be any issues with that type of tape, right? thanks Roger --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- Please remember to recycle wherever possible. Reduce, reuse, recycle, think do you need to print this e-mail? --- This e-mail and any attachment(s), is confidential and may be legally privileged. It is intended solely for the addressee. If you are not the addressee, dissemination, copying or use of this e-mail or any of its content is prohibited and may be unlawful. If you are not the intended recipient please inform the sender immediately and destroy the e-mail, any attachment(s) and any copies. All liability for viruses is excluded to the fullest extent permitted by law. It is your responsibility to scan or otherwise check this email and any attachment(s). Unless otherwise stated (i) views expressed in this message are those of the individual sender (ii) no contract may be construed by this e-mail. Emails may be monitored and you are taken to consent to this monitoring. Civica Services Limited, Company No. 02374268; Civica UK Limited, Company No. 01628868 Both companies are registered in England and Wales and each has its registered office at 2 Burston Road, Putney, London, SW15 6AR. --- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] can anyone shed any light on parts of this core file?
However just to say I have had experience of strange errors in uniobjects in the past on heavily used systems, this was because the network card was set to 100/full duplex, and the switch port to auto negotiate, so they negotiated to half duplex, we set the switch to full duplex and of course it was faster, but we also lost the errors - may be something to investigate. Thanks for the suggestion, one question though did you notice any kind of network errors that pointed you in that direction? dougc --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Universe conversion migration
We're moving from one machine running AIX 4.3 and Universe 9.5 to a new machine running AIX 5.3 and Universe 10.2.4. Using tar. The majority of the move goes fine. Usual hassles.Recataloging, Reindexing. But two critical large files repeatedly are a problem. Both are type 30s. And appear fine on the original machine. Once moved, we can't even count them without the following message. WARNING: Internal file corruption detected during file open! File must be repaired, possible truncation. hsize: 2048 bsize: 2048 fsize: 1073741312 WARNING: Internal file corruption detected during file open! File must be repaired, possible truncation. hsize: 2048 bsize: 2048 fsize: 1073741312 Unable to open GL.DETAILS file. And uvfilefix just curls up its toes and dies. Production machine shows 1,048,576 -rw-rw-rw- root sys 1,073,741,312 (same as the fsize). The other file PAYABLES shows 1,048,576 -rw-rw-rw- root sys 1,073,741,312 ---was there some change in type 30 formating between 9.5 and 10+? that we didn't know about. I've only been with this company for 7 months, but we so far haven't had to repair any files. These are the only two files with problems and we can break them into smaller non-30 files for the move and then recombine them.But if anybody knows of a type 30 issue, then I'd appreciate any heads up. thanks Roger Glenfield --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe conversion migration
Roger: Have a look at ulimit. The ulimit settings are in /etc/security/limits. Take a look at the ulimit command(in 'list of commands' link) that is documented at the following link: http://publibfi.boulder.ibm.com/doc_link/en_US/a_doc_lib/cmds/aixcmds5/toc.h tm hth Colin Alfke Calgary Canada -Original Message- From: Roger Glenfield We're moving from one machine running AIX 4.3 and Universe 9.5 to a new machine running AIX 5.3 and Universe 10.2.4. Using tar. The majority of the move goes fine. Usual hassles.Recataloging, Reindexing. But two critical large files repeatedly are a problem. Both are type 30s. And appear fine on the original machine. Once moved, we can't even count them without the following message. WARNING: Internal file corruption detected during file open! File must be repaired, possible truncation. hsize: 2048 bsize: 2048 fsize: 1073741312 WARNING: Internal file corruption detected during file open! File must be repaired, possible truncation. hsize: 2048 bsize: 2048 fsize: 1073741312 Unable to open GL.DETAILS file. And uvfilefix just curls up its toes and dies. Production machine shows 1,048,576 -rw-rw-rw- root sys 1,073,741,312 (same as the fsize). The other file PAYABLES shows 1,048,576 -rw-rw-rw- root sys 1,073,741,312 ---was there some change in type 30 formating between 9.5 and 10+? that we didn't know about. I've only been with this company for 7 months, but we so far haven't had to repair any files. These are the only two files with problems and we can break them into smaller non-30 files for the move and then recombine them.But if anybody knows of a type 30 issue, then I'd appreciate any heads up. thanks Roger Glenfield --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] tape backups
We used these for years. No problems - except the tape loader itself... They work well especially if you have a fast disk sub-system. It's more the software that you are using and how it handles open files and locking them. It's been too long since I've set one of these up on Aix but in Windows some software won't backup open files (which the database may hold open even if no one is actively using them). The other problem is the backup software locks the file at the OS level so the database can't read the file and the program aborts. Hth Colin Alfke Calgary Canada -Original Message- From: Roger Our new machine has a DLT tape carousel system. Since it should just be backing up aix data files, so long as we don't access the files during the backup, there shouldn't be any issues with that type of tape, right? thanks Roger --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe conversion migration
Roger, It is very suspicious that the file size 1,073,741,312 is 512 bytes less than 1 GB (1,073,741,824). I would look at ulimit on the new machine - perhaps ulimit is set to 1 GB or some other size limiting factor caused the file to be truncated during the move. Hope this helps! Jeff Fitzgerald Fitzgerald Long, Inc. www.fitzlong.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, August 14, 2008 10:28 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe conversion migration We're moving from one machine running AIX 4.3 and Universe 9.5 to a new machine running AIX 5.3 and Universe 10.2.4. Using tar. The majority of the move goes fine. Usual hassles.Recataloging, Reindexing. But two critical large files repeatedly are a problem. Both are type 30s. And appear fine on the original machine. Once moved, we can't even count them without the following message. WARNING: Internal file corruption detected during file open! File must be repaired, possible truncation. hsize: 2048 bsize: 2048 fsize: 1073741312 WARNING: Internal file corruption detected during file open! File must be repaired, possible truncation. hsize: 2048 bsize: 2048 fsize: 1073741312 Unable to open GL.DETAILS file. And uvfilefix just curls up its toes and dies. Production machine shows 1,048,576 -rw-rw-rw- root sys 1,073,741,312 (same as the fsize). The other file PAYABLES shows 1,048,576 -rw-rw-rw- root sys 1,073,741,312 ---was there some change in type 30 formating between 9.5 and 10+? that we didn't know about. I've only been with this company for 7 months, but we so far haven't had to repair any files. These are the only two files with problems and we can break them into smaller non-30 files for the move and then recombine them.But if anybody knows of a type 30 issue, then I'd appreciate any heads up. thanks Roger Glenfield --- 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] tape backups
quote who='Edward Brown' date='Thursday 14 August 2008' There's a dbpause / dbresume command on unidata that looks like it would make backups safer. If your system supports filesystem snapshots, a really effective means is to: 1) dbpause the database 2) take file system snapshot of database 3) dsresume the database 4) perform tape backup from snapshot 5) release the snapshot once backup completes This typically results in very little downtime (as long as it takes to pefrom a snapshot of the filesystem) often 5-10 seconds or less. Yes, you should wait a few seconds after dbpause to allow any pending writes to complete. dbpause is a UniData system-level command that blocks most updates to the database made in a UniData session. Any updates made from the operating system level are not blocked. You can use this feature to perform some tasks that normally require UniData to be stopped, such as backing up your data. When the dbpause command is issued, all current writes and transactions complete before UniData pauses. Updates are blocked until the system administrator executes the dbresume command. Edward -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Email gives the illusion of progress even when nothing is happening. unknown --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe conversion migration
Roger, First of all, that doesn't look like a type 30 file to me. 1,048,576 -rw-rw-rw- root sys 1,073,741,312 (same as the fsize). That's a file - at version 10 a type 30 file is a directory at the OS level, so I would expect to see something like drwxrwxrwx for the permissions, and inside the directory there should be a DATA.30 and an OVER.30 file. Next, if uvfixfile won't touch it, what is the output from fixtool? HTH. On Thu, Aug 14, 2008 at 12:27 PM, [EMAIL PROTECTED] wrote: We're moving from one machine running AIX 4.3 and Universe 9.5 to a new machine running AIX 5.3 and Universe 10.2.4. Using tar. The majority of the move goes fine. Usual hassles.Recataloging, Reindexing. But two critical large files repeatedly are a problem. Both are type 30s. And appear fine on the original machine. Once moved, we can't even count them without the following message. WARNING: Internal file corruption detected during file open! File must be repaired, possible truncation. hsize: 2048 bsize: 2048 fsize: 1073741312 WARNING: Internal file corruption detected during file open! File must be repaired, possible truncation. hsize: 2048 bsize: 2048 fsize: 1073741312 Unable to open GL.DETAILS file. And uvfilefix just curls up its toes and dies. Production machine shows 1,048,576 -rw-rw-rw- root sys 1,073,741,312 (same as the fsize). The other file PAYABLES shows 1,048,576 -rw-rw-rw- root sys 1,073,741,312 ---was there some change in type 30 formating between 9.5 and 10+? that we didn't know about. I've only been with this company for 7 months, but we so far haven't had to repair any files. These are the only two files with problems and we can break them into smaller non-30 files for the move and then recombine them.But if anybody knows of a type 30 issue, then I'd appreciate any heads up. thanks Roger Glenfield --- 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] U2.NET v IBM.NET v UNIOBJECTS.NET
Thanks for asking the question Susan, I learned a lot also. Tom Dodds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Wednesday, August 13, 2008 4:03 PM To: u2-users@listserver.u2ug.org Subject: [U2] U2.NET v IBM.NET v UNIOBJECTS.NET Greetings, I'm studying the U2 University Agenda to see what mischief I can get into. Anyone know what is the difference between IBM.NET, U2.NET and UNIOBJECTS.NET? There are three distinct sessions at U2U on these. TIA, Susan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ Information from ESET NOD32 Antivirus, version of virus signature database 3353 (20080813) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] U2.NET v IBM.NET v UNIOBJECTS.NET
International Spectrum magazine, March/April 2008, page 26. Available at: http://intl-spectrum.com/mag/MARAPR.2008/default.aspx also via http://tinyurl.com/63guo7 Regards, Clif On Aug 14, 2008, at 9:58 AM, Brian Leach wrote: The other main option is the IBM ADO.NET provider, which exposes a mainstream relational view of UniVerse, but with better handling for stored procedures (AKA Basic subroutines) than some previous APIs. For details, take a look at my article in a recent Spectrum (can't remember which one). --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Editing Subsequent Value Marks
In message [EMAIL PROTECTED], Brutzman, Bill [EMAIL PROTECTED] writes I have what looks like ^253^253 that needs to be just ^253. Are you sure they're value marks, and not } or whatever they display as in your editor? Without luck I have tried... 1: C/^253^253/^253 and 1: C\^253^253\^253 Suggestions would be appreciated. Try ^ to put ED into display control character mode and check that they really are value marks... --Bill Cheers, Wol -- Anthony W. Youngman [EMAIL PROTECTED] 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] can anyone shed any light on parts of this core file?
Not on the network as I did not monitor that (boxes are colo in a hosting centre and we use their switches etc), but on the linux box a 'netstat -an' showed lots of sockets with about 250 bytes in the queue. I asked the hosting centre network staff to check the switch ports for our machine and they reported they were in half duplex. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of doug chanco Sent: 14 August 2008 18:34 To: u2-users@listserver.u2ug.org Subject: Re: [U2] can anyone shed any light on parts of this core file? However just to say I have had experience of strange errors in uniobjects in the past on heavily used systems, this was because the network card was set to 100/full duplex, and the switch port to auto negotiate, so they negotiated to half duplex, we set the switch to full duplex and of course it was faster, but we also lost the errors - may be something to investigate. Thanks for the suggestion, one question though did you notice any kind of network errors that pointed you in that direction? dougc --- 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 - http://www.avg.com Version: 8.0.138 / Virus Database: 270.6.3/1611 - Release Date: 14/08/2008 06:20 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Editing Subsequent Value Marks - A Third Victory
Wol: This technique is new to me. It works well. Thanks! --Bill -Original Message- [mailto:[EMAIL PROTECTED] Behalf Of Anthony W. Youngman Try ^ to put ED into display control character mode and check that they really are value marks... Cheers, Wol -- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Unidata to Universe port
Hello: Does any one have any experiences they would be willing to share regarding the effort required to port applications from UniData to Universe? We're currently on Unidata 7.1 We developed our application in an early version of SB+ and UniBasic and have kept current on SB+, so we're now at version 5.4. We've also made use of various connectivity technolgies over time, such as ODBC, OLEDB, and UniObjects. We haven't used the web services or ADO provider yet, but probably will eventually. We are currently running on Windows but a Unix flavor is not out of the question if there is a compelling reason. At this point, I'm just trying to figure out a way to gauge the relative effort, and if there were any surprises, such as better/worse performance, costs, development effort, etc and of course, any gotchas. Also, is it feasible to to code the application in a way that it would work on either platform from the same code base? The reason we're even considering this is because of IBM's decision not to implement NLS in UniData, at least not right away. Of course, we've had conversations with IBM about converting, but would appreciate hearing from any one who has actually done this. thanks in advance. Eugene --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unidata to Universe port
Eugene, I'm sure others will have a longer list, but for starters: 1.The structure of dictionary items is completely different. 2.You lose the ability to expand the print job numbers beyond before they restart numbering print jobs at 1 in UniVerse. Best wishes, Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com - Original Message - From: Eugene St. Clair [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, August 14, 2008 6:41 PM Subject: [U2] Unidata to Universe port Hello: Does any one have any experiences they would be willing to share regarding the effort required to port applications from UniData to Universe? snip --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/