Re: [U2] XML Issue
Maybe it is just the way you have cut and pasted but the new xml does not have the closing /VEHICLE and /VEHICLEPOSITIONS tags. On 1/26/06, Nancy Fisher [EMAIL PROTECTED] wrote: I've got a new URL to download some XML data and although the xml data is supposed to be nearly identical to what I was getting previously I am getting errorred out. This is what I get from the old URL: ?xml version=1.0 encoding=UTF-8? VEHICLEPOSITIONS ticket=a_x VEHICLE ID=555 LON-122.65788/LON LAT45.504333/LAT DATE2006-01-26 20:58:25.0/DATE SPEED0/SPEED DIRECTION1/DIRECTION NAME333/NAME SPEEDLIMIT99/SPEEDLIMIT STREETNAMESE 8th Ave/STREETNAME STREETNUM2575/STREETNUM CITYPortland/CITY STATEOR/STATE SITENAME PORTLAND DIRECT TILE amp; MARBLE/SITENAME REASONi/REASON ODOMETER4113367/ODOMETER TRAVELTIME462849/TRAVELTIME /VEHICLE This is what I get from the new URL: ?xml version=1.0 encoding=ISO-8859-1 standalone=yes? VEHICLEPOSITIONS ticket=a_x VEHICLE ID=222 LON-122.70442/LON LAT45.545563/LAT DATE2006-01-26 15:34:59.0/DATE SPEED0/SPEED DIRECTION36/DIRECTION NAME1100/NAME SPEEDLIMIT99/SPEEDLIMIT STREETNAMENW 26th Ave/STREETNAME STREETNUM3280/STREETNUM CITYPortland/CITY STATEOR/STATE SITENAMEPortland Terminal/SITENAME REASONi/REASON DRIVERSTATUSLogout/DRIVERSTATUS DRIVER555 SMITH, DAVID L./DRIVER ODOMETER7997907/ODOMETER TRAVELTIME702207/TRAVELTIME /VEHICLE VEHICLE ID=42699 LON-122.70442/LON Error with XDOMOpen(). ERR STATUS -1 I was using the same mapping - just adding for the 2 new fields of info at the new url. I notice the 'encoding' is different (but I don't know what that means). I don't know if it's a problem at the vendors website or a problem with mapping...(this is new programming on their part). When I use the URL to access it directly (not through UniVerse) I can see it as a regular XML document so everything appears to be as it should on their end. We are using the latest version of UniVerse... Thanks, Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 [EMAIL PROTECTED] --- 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] [UD] Objectcall product lifecycle
I can't help but wonder what the future is going to be like for Objectcall being included in future releases of Unidata. I understand that IBM will no longer support this API (at least the last I heard which was about 2-3 years ago now) and just couldn't help but wonder if IBM ever plans to pull this API functionality from Unidata in any future release. Does anybody know? I understand, particularly for Datastage, that Intercall is the new supported API which replaced Objectcall. Is this an easy task to migrate from the Objectcall to Intercall--in particular, referencing the Datastage Unidata stage plug-ins. We're running Unidata 6.1.10 at present; soon Unidata 7.1.0 and also Datastage 7.5.1A. Thanks for any input, Andy Pflueger -- The Linux philosophy is 'Laugh in the face of danger'. Oops. Wrong One. 'Do it yourself'. Yes, that's it. Linus Torvalds --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Ploblem with sessions
Hi, I will be in training for the morning of 1/27/06. I will have very limited access to e-mail or voice mail during this time. If a you need an immediate response to your e-mail please e-mail [EMAIL PROTECTED] Thanks and have a great day! Josh --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Moving Data between input buffers
It does. -Original Message- From: Brian Leach [mailto:[EMAIL PROTECTED] Sent: Friday, January 20, 2006 5:01 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Moving Data between input buffers Doug Does UniData PROC support file buffers (n.m format)? I've never used PROC on UniData, but that is traditionally the place to stuff things 'for future reference', e.g. MV 1.0 %1 Only if the PROC implementation supports PQN format though. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Chanco Sent: 19 January 2006 23:42 To: u2-users@listserver.u2ug.org Subject: [U2] Moving Data between input buffers is it possible to move data from the primary buffer to the secondary buffer in unidata? I have a proc that calls a BP, which writes to the Primary buffer. If I set to secondary buffer before running the BP, the BP writes to the primary. I need that info moved to a secondary buffer for future reference. --- 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] Knowledgebase access
At 10:08 AM 1/26/2006, you wrote: So get with your VAR's and request access and they should be able to get you going. If they do not know how, tell them to contact IBM as this is available now. I suspect IBM should have some type of announcement in their Information Management Software Today newsletter sometime soon. Ah, I thought I saw this but could not find it. It was in the latest edition of the above. Support and Services Access to IBM Support Knowledgebase Extended to Tiered Partners and VAR End Users IBM U2 OEM Partners and Master Distributors can grant access to the entitled IBM Support Knowledgebase for their associated End Users and/or Tiered Partners. The IBM U2 Support Knowledgebase is the main repository of Technical Support how-to's, hints and tips and other articles invaluable for supporting your U2 products and solutions. Access is available with the express consent of the Partner or Distributor. Full details of how Partners or Distributors request access is provided in the U2 Partners QuickPlace. If you currently hold a valid U2 OEM, Passport Advantage Express or Distributor Agreement and do not have access to this site please email [EMAIL PROTECTED] for access. The document in the U2 Partner QuickPlace is called Accessing the Knowledgebase: for Tiered Partners or VAR Endusers. http://www.ibm.com/isource/cgi-bin/goto?on=IMNL125J03 Doug Miller [EMAIL PROTECTED] Manager of Technical Services Strategy 7Dallas TX --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: XML Issue
Maybe it is just the way you have cut and pasted but the new xml does not have the closing /VEHICLE and /VEHICLEPOSITIONS tags. Yes. It was just a cut and paste... This resp header works: ?xml version=1.0 encoding=UTF-8? The resp header from this URL doesn't work: ?xml version=1.0 encoding=ISO-8859-1 standalone=yes? I tried to look up what standalone means - but didn't really get it. I wondered if it meant it wasn't using mapping? Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: XML Issue
This resp header works: ?xml version=1.0 encoding=UTF-8? The resp header from this URL doesn't work: ?xml version=1.0 encoding=ISO-8859-1 standalone=yes? Could the problem be the difference of the type of encoding used in the first resp header versus the second? Does your system which UniVerse is running on support ISO-8859-1 character set? Just a thought... --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] Best practices
I've been converting dictionaries from a D3 dbms and am wondering what is considered best practices in virtual attribute design. Does one build standard Direct fields first then use these fields to build virtual attributes (I-Descriptors) or should one use the direct field references, EXTRACT() or n,n,n, in virtual attributes? DEPOSITED 001 D The date of the deposit. 002 2 VOID 001 D Is this a voided receipt? 002 12 DEPDATE 001 I The displayed deposit date (if not voided). 002 IF VOID = THEN DEPOSITED ELSE *Voided* or DEPDATE 001 I The displayed deposit date (if not voided). 002 EXTRACT( @RECORD, 2, 0, 0 ) ; EXTRACT( @RECORD, 12, 0, 0 ) ; IF @2 = THEN @1 ELSE *Voided* The obvious concern is if a direct field definition is renamed, then all references to the old field name need to be changed. I rarely rename a field, until I started exposing the data to other data sources and was forced to clean up the field names. So, hopefully, this won't be an issue in the future. Any thoughts. Bill Haskett --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Creating a Folder
With HP-Ux and UniVerse, I need to create a folder (account?) NEW.BP for UniBasic code... Now we have /u2/METAL/ DATA1 DATA2 /u2/SOFTWARE/... AP.BP/ APP.1 APP.2 PUR.BP/ APP.98 APP.99 NEW.BP Without luck, I tried it brute-force in Unix; UV did not recognize it. I tried CREATE.FILE; I need a folder, not a file. Suggestions would be appreciated. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2][DOWNLOAD] Paragraph sentence too long
I have a user who is hitting a limit a paragraph using the DOWNLOAD command and wonder if anyone can help. The DOWNLOAD command is building a text file in the hold directory that contains 185 fields. The problem she is having is with the LITERAL option. She is using LITERAL to create headings for each field in the text file and receives the Paragraph sentence too long error message at the 182 LITERAL statement. Any idea why this is happening? The DOWNLOAD HELP MAX returns the following: DOWNLOAD version 7.11 The following limits are defined for DOWNLOAD: Input data files referenced directly..10 Dictionary fields referenced directly300 EVAL expressions.100 SUBR expressions.200 Subroutine arguments per subroutine...10 Output record types (detail lines)10 Break fields..25 I have not used or researched download much and would appreciate any insight provided. Thanks, Manuel -- ** Manuel Owens Benefactor/UniData AdministratorBenefactor 5.1 University of California, Berkeley Envision 4.7.1 Berkeley, CA 94720-4200 UniData 6.1.11 [EMAIL PROTECTED] AIX 5.2 (510) 643-1495 (510) 643-2154 FAX ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Creating a Folder
You'll need to use CREATE.FILE in Universe, but create either a type 1 or type 19 file - that will make it a folder. -Dianne Brutzman, Bill wrote: With HP-Ux and UniVerse, I need to create a folder (account?) NEW.BP for UniBasic code... Now we have /u2/METAL/ DATA1 DATA2 /u2/SOFTWARE/... AP.BP/ APP.1 APP.2 PUR.BP/ APP.98 APP.99 NEW.BP Without luck, I tried it brute-force in Unix; UV did not recognize it. I tried CREATE.FILE; I need a folder, not a file. Suggestions would be appreciated. --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] Creating a Folder
Bill, After you did the mkdir in Unix, did you put an F-pointer in the VOC of the account from which you want to access the new folder/program source code directory? 0001 F 0002 /u2/SOFTWARE/NEW.BP 0003 make a new one with CREATE.FILE DICT NEW.BP -or- use the same one as AP.BP? When you first try to compile a program in NEW.BP UV will create the .O file to hold the object code. --Ron P. -Original Message- /u2/SOFTWARE/... AP.BP/ APP.1 APP.2 PUR.BP/ APP.98 APP.99 NEW.BP Without luck, I tried it brute-force in Unix; UV did not recognize it. I tried CREATE.FILE; I need a folder, not a file. Suggestions would be appreciated. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV] LIST.READU device 0 Inode 0
What does device 0 Inode 0 mean?Notice the last line: LIST.READU USER 137 EVERY Active Group Locks:Record Group Group Group Device Inode Netnode Userno Lmode G-Address. Locks ...RD ...SH ...EX 1075970056 244260137 109 IN 27800 1 0 0 0 1075970056 80410137 241 IN 4C40B800 1 0 0 0 Active Record Locks: Device Inode Netnode Userno LmodePid Login Id Item-ID. 1075970056 244260137 109 RU 1441 mholl 3001980 1075970056 80410137 241 RU 1441 mholl 3001980 0 00137 341 RU 1441 mholl 584343 Is this perhaps something that disappeared in the middle of list.readu's attempt to examine it? It seems like I have been seeing a rash of these lately. UV 10.0.16, HPUX 11i. Thanks, Chuck Stevenson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UD] Best practices
Personally, I've never used either methods. Here is how I would do the I-descriptor: 001 I 002 IF @RECORD12 = THEN OCONV(@RECORD2,D4-) ELSE *VOIDED* Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 [EMAIL PROTECTED] wrote on 01/27/2006 03:24:47 PM: I've been converting dictionaries from a D3 dbms and am wondering what is considered best practices in virtual attribute design. Does one build standard Direct fields first then use these fields to build virtual attributes (I-Descriptors) or should one use the direct field references, EXTRACT() or n,n,n, in virtual attributes? DEPOSITED 001 D The date of the deposit. 002 2 VOID 001 D Is this a voided receipt? 002 12 DEPDATE 001 I The displayed deposit date (if not voided). 002 IF VOID = THEN DEPOSITED ELSE *Voided* or DEPDATE 001 I The displayed deposit date (if not voided). 002 EXTRACT( @RECORD, 2, 0, 0 ) ; EXTRACT( @RECORD, 12, 0, 0 ) ; IF @2 = THEN @1 ELSE *Voided* The obvious concern is if a direct field definition is renamed, then all references to the old field name need to be changed. I rarely rename a field, until I started exposing the data to other data sources and was forced to clean up the field names. So, hopefully, this won't be an issue in the future. Any thoughts. Bill Haskett --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Creating a Folder
On Fri, 27 Jan 2006 15:58:04 -0500, you wrote: With HP-Ux and UniVerse, I need to create a folder (account?) NEW.BP for UniBasic code... snip CREATE.FILE 1 or perhaps CREATE.FILE 19 Type 1 19 are directories. -- Allen Egerton [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Creating a Folder
Brutzman, Bill wrote: With HP-Ux and UniVerse, I need to create a folder (account?) NEW.BP for UniBasic code... You need to specify type 19 for the data portion of the file with CREATE.FILE. This will create an OS level directory rather than a hashed file. -John -- John Hester System Network Administrator Momentum Group Inc. (949) 833-8886 x623 http://memosamples.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Creating a Folder
CREATE.FILE DIR NEW.BP You need the Keyword DIR (For directory/folder) in the CREATE.FILE command. It basically creates the DIRECTORY NEW.BP and the DICTIONARY D_NEW.BP (As a file at the same level as the directory, not IN the directory) The VOC entry should look something like: 1] DIR 2] NEW.BP 3] D_NEW.BP With your brute force method you also need to copy an EMPTY DICT (Except for @ID). I've done this before: 1] DIR 2] NEW.BP 3] D_VOC Just for a temporary look at a directory. However, it's very dangerous using D_VOC, because if you delete.file NEW.BP, there goes your VOC (MD). I've done that before too..heh. Hope this helps, -- * Please NOTE NEW ADDRESS AND TELELPHONE Numbers * -- Donald Verhagen Application Development Manager [EMAIL PROTECTED] Tandem Staffing Solutions, Inc. 5901 Broken Sound Parkway NW, Suite 450 Boca Raton, FL 33487 USA Voice Phone: 561.226.8261 Fax Phone: 561.226.8115 On 1/27/2006 at 3:58 pm, in message [EMAIL PROTECTED], [EMAIL PROTECTED] wrote: With HP-Ux and UniVerse, I need to create a folder (account?) NEW.BP for UniBasic code... Now we have /u2/METAL/ DATA1 DATA2 /u2/SOFTWARE/... AP.BP/ APP.1 APP.2 PUR.BP/ APP.98 APP.99 NEW.BP Without luck, I tried it brute-force in Unix; UV did not recognize it. I tried CREATE.FILE; I need a folder, not a file. Suggestions would be appreciated. --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] Creating a Folder
Bill, In UV, a type 1 or type 19 file becomes a folder. Type 19 allows for the use of longer record names than allowed in a type 1 file. Once you've created your NEW.BP file using CREATE-FILE, you can RESIZE NEW.BP setting type = 19 and you'll have a folder called NEW.BP. hth, Dave Dave Taylor President Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (C) 310-561-5200 (P) 800-339-1497 (F) 310-377-3550 Your Source for Integrated EDI Translation and DataSync Integration www.sysmarkinfo.com - Original Message - From: Brutzman, Bill [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, January 27, 2006 12:58 PM Subject: [U2] Creating a Folder With HP-Ux and UniVerse, I need to create a folder (account?) NEW.BP for UniBasic code... Now we have /u2/METAL/ DATA1 DATA2 /u2/SOFTWARE/... AP.BP/ APP.1 APP.2 PUR.BP/ APP.98 APP.99 NEW.BP Without luck, I tried it brute-force in Unix; UV did not recognize it. I tried CREATE.FILE; I need a folder, not a file. Suggestions would be appreciated. --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/
[U2] [UD] T-LOAD
I'm able to take a T-DUMP from D3 (T-DUMP FileName (AHI) and move the file to UD server (via XCOPY only!) then: SETTAPE 9... T.LOAD FileName MU 09 PICK and it works fine. Now the problem is when I create a new T-DUMP from D3 for multiple files by doing: T-DUMP FileA (AHI T-DUMP FileB (AHI . . then move it to UniData and try: SETTAPE 9... T.LOAD FileA MU 09 OVERWRITING PICK T.LOAD FileB MU 09 OVERWRITING PICK the tape seems to rewind after each T.LOAD and only FileA's T-DUMP data is continually T.LOAD'd into each file on UniData. I was checking out the SETTAPE with the no_rewind_driver option but that doesn't seem to be what I'm looking for. Can anyone tell me how to T.LOAD multiple files on UniData, or is there some issue with D3 T-DUMPs that is causing the problem? Thanks, Bill Haskett --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Creating a Folder
No, I did not, shame on me. But wait, there is even more shame... What do I do first? What is step one? Where is first base? Please advise, --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pingilley, Ron Sent: Friday, January 27, 2006 4:33 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Creating a Folder Bill, After you did the mkdir in Unix, did you put an F-pointer in the VOC of the account from which you want to access the new folder/program source code directory? 0001 F 0002 /u2/SOFTWARE/NEW.BP 0003 make a new one with CREATE.FILE DICT NEW.BP -or- use the same one as AP.BP? When you first try to compile a program in NEW.BP UV will create the .O file to hold the object code. --Ron P. -Original Message- /u2/SOFTWARE/... AP.BP/ APP.1 APP.2 PUR.BP/ APP.98 APP.99 NEW.BP Without luck, I tried it brute-force in Unix; UV did not recognize it. I tried CREATE.FILE; I need a folder, not a file. Suggestions would be appreciated. --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] Creating a Folder
Bill, In UV you would indeed use CREATE.FILE. Just tell it that it's a type 1 file, which is a directory. HTH, Gordon Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 [EMAIL PROTECTED] wrote on 01/27/2006 03:58:04 PM: With HP-Ux and UniVerse, I need to create a folder (account?) NEW.BP for UniBasic code... Now we have /u2/METAL/ DATA1 DATA2 /u2/SOFTWARE/... AP.BP/ APP.1 APP.2 PUR.BP/ APP.98 APP.99 NEW.BP Without luck, I tried it brute-force in Unix; UV did not recognize it. I tried CREATE.FILE; I need a folder, not a file. Suggestions would be appreciated. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UD] Best practices
To me, this is an issue of readability and maintainability. If I read 'IF VOID = THEN DEPOSITED ELSE *Voided*', I can make a reasonable guess at what it is trying to do, without knowing anyghing about the file structure. If you use numeric references to fields, you will probably have to do some research to figure out what the heck the dictionary is tring to accomplish. Do your fellow developers (not to mention future developers and even yourself in 2 years when you've forgotten what the heck this file was for to begin with) a favor, and use the D-type field references in your I-type dictionaries. A corollary to this would be, make sure you choose good names. Bill Haskett wrote: I've been converting dictionaries from a D3 dbms and am wondering what is considered best practices in virtual attribute design. Does one build standard Direct fields first then use these fields to build virtual attributes (I-Descriptors) or should one use the direct field references, EXTRACT() or n,n,n, in virtual attributes? DEPOSITED 001 D The date of the deposit. 002 2 VOID 001 D Is this a voided receipt? 002 12 DEPDATE 001 I The displayed deposit date (if not voided). 002 IF VOID = THEN DEPOSITED ELSE *Voided* or DEPDATE 001 I The displayed deposit date (if not voided). 002 EXTRACT( @RECORD, 2, 0, 0 ) ; EXTRACT( @RECORD, 12, 0, 0 ) ; IF @2 = THEN @1 ELSE *Voided* The obvious concern is if a direct field definition is renamed, then all references to the old field name need to be changed. I rarely rename a field, until I started exposing the data to other data sources and was forced to clean up the field names. So, hopefully, this won't be an issue in the future. Any thoughts. Bill Haskett --- 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] Active Select List wit UniXML
Does any one know of a way to use a select list with the UniXML class in UniObjects .Net? We have been using UniObjects.Net to retrieve data from UniData 7.1 using the UniXML class. A typical query would be something like... UniXML xml = Session.CreateUniXML(); xml.GenerateXML(list FileName with selection_criteria fieldName fieldName TOXML); Overall this has been working out very well. What I would like to be able to figure out is how to use this list command with an active select list. Has any one done this? (Am I missing something obvious?) thanks Victor St. Clair Jenkon Vancouver, WA 360.256.4400 [EMAIL PROTECTED] www.jenkon.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UD] T-LOAD
Bill, We developed a program, TAPE.DUMP, to T-DUMP any list of, or all of the files and/or MD items in an account to tape, including the file characteristics of each file (in the label of the dump). We developed a companion program, TAPE.LOAD, to create each file that did not exist and then T-LOAD the dumped files to another database. We have used it successfully for moving all the files in an accounts from A/P, R91 and mvBase to Universe in two steps and have not run into the rewind problems that you described on Unidata. It almost feels like Universe is finding only one file dumped on the tape from D3 and is rewinding because it found and EOT marker. One of the associate consultants that works with us is a Unidata guy and I'll be glad to ask him if he has run into this on Unidata. The other observation I'd like to make is that several knowledgeable Unidata people have suggested to me that Unidata is decidedly not a Pick-like database, and that converting software from D3 to Unidata will be a long and expensive process, and will leave you with two versions of your software that will be distinctly different from each. We also looked at Unidata several years ago and we chose to convert our software to Universe instead of Unidata partly because Universe offers the Pick flavor that allows us to run essentially the same code on all generic Pick platforms, with occasional platform-specific flags that can be searched on and reset as we move the software from one platform to the other. Also, because Universe does not support the generic Pick spooler commands (:STARTSPOOLER, STARTPTR, SP-ASSIGN, LISTPTR, LISTPEQS, etc.), and because we didn't want to rewrite all the print program in our software to SETPTR commands, we developed a generic Pick spooler for Universe, called UvSpoolerPlus. Using these two tools, you could migrate your software from D3 to Universe with a minimal amount of modification compared with the major effort you are facing migrating D3 code to Unidata. If you'd like to explore this further, please give me a call. Rgds, Dave Dave Taylor President Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (C) 310-561-5200 (P) 800-339-1497 (F) 310-377-3550 Your Source for Integrated EDI Translation and DataSync Integration www.sysmarkinfo.com - Original Message - From: Bill Haskett [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, January 27, 2006 2:21 PM Subject: [U2] [UD] T-LOAD I'm able to take a T-DUMP from D3 (T-DUMP FileName (AHI) and move the file to UD server (via XCOPY only!) then: SETTAPE 9... T.LOAD FileName MU 09 PICK and it works fine. Now the problem is when I create a new T-DUMP from D3 for multiple files by doing: T-DUMP FileA (AHI T-DUMP FileB (AHI . . then move it to UniData and try: SETTAPE 9... T.LOAD FileA MU 09 OVERWRITING PICK T.LOAD FileB MU 09 OVERWRITING PICK the tape seems to rewind after each T.LOAD and only FileA's T-DUMP data is continually T.LOAD'd into each file on UniData. I was checking out the SETTAPE with the no_rewind_driver option but that doesn't seem to be what I'm looking for. Can anyone tell me how to T.LOAD multiple files on UniData, or is there some issue with D3 T-DUMPs that is causing the problem? Thanks, Bill Haskett --- 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] [UD] T-LOAD
Dave: Thanks for your insights. I'd like to hear any info from your UniData guys that might help with the T.LOADS. It's not critical as I can transfer one file at a time and this will only take me about 4-8 hours in total. I've actually found UniData more compatible to R83 (D3) in a number of important respects. The issues I'm having to mostly cope with are: 1) Dictionary conversions and 2) Data transport A few other items pop up, from time to time, but the application I'm helping convert is pretty straightforward, has its own list of custom verbs (VOC entries) so they're easy to identify, use straight BASIC (no PROCS or Paragraphs), and have files that hold the O/S commands for that kind of stuff (table-driven stuff). The biggest problem I have, otherwise, is the paleozic user interface. I'm at least 5 to 10 times more productive with a screen editor (I'm into tons of stuff like programs, VOC entries, dictionaries, and data and have difficulty managing a different editor for each type of item I'm working on) than I am with AE (or ED on UV). This means that I'm probably spending 20 days doing about 2-4 days of work. So far, with about 50 man days invested, we're about 90% complete, and like I've said before, most of the work is simply unnecessary (rarely is the issue U2 does it one way while other MVs do it another). All the unnecessary work is futzing with conversion issues that should have been published by IBM, futzing with data transport issues that should have been published by IBM, and futzing with dictionary conversions that should have been done by utilitites published by IBM. :-) Anyway, we're testing right now as the menus work, they can enter most data, and display reports/data to the screen. Their application does print stuff and uses a couple of programs (I think they're about 3-4 programs) that do the spooler stuff and I know U2 does it different. If you have some tools to help with spooler conversion to U2 I'd be interest in hearing about if off-line. Thanks again for all your help. :-) Bill Haskett Advantos Systems, Inc. www.advantos.net (760)944-5570 (CA) (360)923-4838 (WA) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Taylor Sent: Friday, January 27, 2006 3:55 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UD] T-LOAD Bill, We developed a program, TAPE.DUMP, to T-DUMP any list of, or all of the files and/or MD items in an account to tape, including the file characteristics of each file (in the label of the dump). We developed a companion program, TAPE.LOAD, to create each file that did not exist and then T-LOAD the dumped files to another database. We have used it successfully for moving all the files in an accounts from A/P, R91 and mvBase to Universe in two steps and have not run into the rewind problems that you described on Unidata. It almost feels like Universe is finding only one file dumped on the tape from D3 and is rewinding because it found and EOT marker. One of the associate consultants that works with us is a Unidata guy and I'll be glad to ask him if he has run into this on Unidata. The other observation I'd like to make is that several knowledgeable Unidata people have suggested to me that Unidata is decidedly not a Pick-like database, and that converting software from D3 to Unidata will be a long and expensive process, and will leave you with two versions of your software that will be distinctly different from each. We also looked at Unidata several years ago and we chose to convert our software to Universe instead of Unidata partly because Universe offers the Pick flavor that allows us to run essentially the same code on all generic Pick platforms, with occasional platform-specific flags that can be searched on and reset as we move the software from one platform to the other. Also, because Universe does not support the generic Pick spooler commands (:STARTSPOOLER, STARTPTR, SP-ASSIGN, LISTPTR, LISTPEQS, etc.), and because we didn't want to rewrite all the print program in our software to SETPTR commands, we developed a generic Pick spooler for Universe, called UvSpoolerPlus. Using these two tools, you could migrate your software from D3 to Universe with a minimal amount of modification compared with the major effort you are facing migrating D3 code to Unidata. If you'd like to explore this further, please give me a call. Rgds, Dave Dave Taylor President Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (C) 310-561-5200 (P) 800-339-1497 (F) 310-377-3550 Your Source for Integrated EDI Translation and DataSync Integration www.sysmarkinfo.com - Original Message - From: Bill Haskett [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, January 27, 2006 2:21 PM Subject: [U2] [UD]
RE: [U2] [UD] T-LOAD
Goo'day, Bill, You probably don't want to hear this about now, but... At 17:25 27/01/06 -0800, you wrote: The biggest problem I have, otherwise, is the paleozic user interface. I'm at least 5 to 10 times more productive with a screen editor (I'm into tons of stuff like programs, VOC entries, dictionaries, and data and have difficulty managing a different editor for each type of item I'm working on) than I am with AE (or ED on UV). This means that I'm probably spending 20 days doing about 2-4 days of work. There are at least 2 freebie screen editors for UD that I'm aware of... UniDebugger from the UD client CD and UniEditor from Martin Scholl www.martinscholl.com We found UniEditor to be excellent... HTH -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.1.375 / Virus Database: 267.14.23/243 - Release Date: 27/01/06 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.375 / Virus Database: 267.14.23/243 - Release Date: 27/01/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
