[U2] Auto-faxing a print job - RICOH Aficio 2035e/2045e [UD]
We have a RICOH Aficio 2035e/2045e printer and it supports faxing and all kinds of good stuff. Has anyone figured out how to send a SINGLE print job packet to a printer like this, such that the printer says, ok, instead of printing you, I am going to fax you to 123-456-7890. I'm hoping that I can put a header on the print job that contained the fax number and some indicator that the printer would understand, and act accordingly. We are on Unidata 6.1 and AIX 4.3.3 Thanks. Ed Burwell 973-361-5400 ext. 1512 [EMAIL PROTECTED] __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] A Generous Offer
I'm interested in the NJ meeting. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of u2ug Sent: Tuesday, June 27, 2006 12:09 PM To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED] Subject: [U2] A Generous Offer All, We need your feedback. I just received this very generous offer from Nathan Rector (International Spectrum). We need to know who can attend, sooner the better. For the NJ event, I can commit to chairing the meeting. We are looking for a board member (past or present) to host the Ohio event. Both of these events are conditional on our having attendees. We don't want to waste Nathan's offer on a no-show event. The best way to respond is to reply to this announcement. [AD] From Nathan: International Spectrum would like to invite the U2 User Group to host a User Group meeting in Cincinnati, OH on Sept 25th and in New Jersey, Nov 14th. International Spectrum would like to support the U2 User group by providing a venue and dinner for your meeting. This meeting will be on the 1st night of the International Spectrum Regional Conferences in each of these cities. The fee for your members will be $35 for the dinner if they are not already attending the International Spectrum Conference. If they have registered and are attending the Conference, then their dinner will be included in their registration price. Nathan Rector, President International Spectrum, Inc [EMAIL PROTECTED] http://www.intl-spectrum.com https://207.156.243.15/exchweb/bin/redir.asp?URL=http://www.intl-spectrum.c om [/AD] - Charles Barouch, Moderator U2-Users U2-Community RBSolutions SBSolutions Visit http://listserver.u2ug.org, enter your e-mail address, and 'browse all' lists to maintain your access. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Knowing where you have come from in a Unibasic subroutin e
Here is my version: FUNCTION GET.CALLING.STACK(SPECIFIC,F2) *- * UCONV.BP GET.CALLING.STACK * RETURNS PROGRAM AND ALL CALLERS (CALLING STACK) * ED BURWELL * 4/1/2005 *- * PARAMETERS: * SPECIFIC - specific item you want from stack * - {null} = Return entire stack * - M = 'M'yself: just return the 1st item in the stack * - C = 'C'aller: just return the calling program * - I = 'I'nitiator: the program that initiated this stack * - * F2 - FUTURE USE * * RETURNED TO CALLER: * STACK- FILE NAME AND PGM NAMES OF CALLING STACK * - THE CURRENT PROGRAM IS ON TOP *- STACK= THIS.PGM = GET.CALLING.STACK * * S49=SYSTEM(49) ; * CALLING STACK MAX=DCOUNT(S49,@AM) * STRIP OFF NULLS * FOR I=MAX TO 1 STEP -1 THING=TRIM(S49I) IF LEN(THING)=0 THEN S49=DELETE(S49,I) NEXT I * GO BACKWARDS THROUGH THE LIST * MAX=DCOUNT(S49,@AM) ; * MAX SHOULD BE AT LEAST = 2 * FIRST ONE IT FINDS SHOULD BE *THIS* PROGRAM * CTR=0 ; * 1=GET.CALLING.STACK ; * 2=Current runing program ; * 3=routine that 'called' current running program * FOR I=MAX TO 1 STEP -1 CTR+=1 THING=S49I,2 THING=CONVERT(/,@VM,THING) ; MAX=DCOUNT(THING,@VM) PGM=THING1,MAX IF PGM[1,1]=_ THEN PGM=PGM[2,999] FILE=THING1,MAX-1 ACCT=THING1,MAX-2 * * IF PGM=THIS.PGM THEN * NO NEED TO PUT THIS ON THE STACK END ELSE IF LEN(SPECIFIC) THEN BEGIN CASE CASE SPECIFIC=M AND CTR=2 ; OK=1 CASE SPECIFIC=C AND CTR=3 ; OK=1 CASE SPECIFIC=I AND I=1 ; OK=1 CASE 1 ; OK=0 END CASE END ELSE OK=1 END * * IF OK THEN STACK-1=FILE: :PGM IF LEN(SPECIFIC) THEN EXIT END END NEXT I * * RETURN STACK END -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Martin Hutchinson Sent: Tuesday, May 30, 2006 6:32 AM To: u2-users@listserver.u2ug.org Subject: [U2] Knowing where you have come from in a Unibasic subroutine I am looking for a command or method to determine where a Unibasic subroutine has been called from. Something similar to when you execute a debug statement and type '?'. Unidata obviously knows where it is when executing a called subroutine but can I get my hands on it at runtime? Any comments or ideas gratefully received. regards Martin Hutchinson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] XML Extraction
I am on UniData 6.1 (AIX) and I have an XML doc that I would like to extract data from and it looks like this: ?xml version=1.0? CasioESSXML Transactions Transaction ID=A22C6C5A-A2C3-0FB4-6E68F346CC6EDE91 type=REPAIR_REQ RepairRequestID12345/RepairRequestID ModelNumberEX-50/ModelNumber PurchaseDate12/14/2004/PurchaseDate /Transaction Transaction ID=A22C6C66-F4E4-E317-06F1360B8616476B type=REPAIR_ESTIMATE_RESPONSE WorkOrderIDESS123456/WorkOrderID ResponseApproved/Response /Transaction Transaction ID=A22C6C7A-B94B-13DF-68DEA7E14A438157 type=PAYMENTRECEIVED WorkOrderIDESS1234/WorkOrderID PaymentAmount90.50/PaymentAmount PaymentMethodCredit Card/PaymentMethod /Transaction Transaction ID=A22C6C8E-F3A2-A33D-632DB2DC71B7D2B3 type=MESSAGESENT WorkOrderIDESS1345/WorkOrderID Code/Code /Transaction /Transactions /CasioESSXML --- My .EXT file looks like this: (so far) ?xml version = 1.0? U2xml_extraction xmlns:U2xml=http://www.ibm.com/U2-xml; U2xml:extraction start=/CasioESSXML/Transactions/[EMAIL PROTECTED]'REPAIR_REQ'] dictionary=ESS.REPAIR.REQ null=EMPTY / U2xml:field_extraction field=@ID path=RepairRequestID/text() / field_extraction field=ESS.ID path=RepairRequestID/text() / U2xml:field_extraction field=MODEL path=ModelNumber/text() / /U2xml_extraction - I can run: PREPARE.XML _XML_/FROM_ESS junk_xml and it runs ok. I can also run: RELEASE.XML junk_xml and it runs ok. - But when I run: list XMLDATA junk_xml _XML_/TEST.EXT ESS.ID I get: Open XML data file failed. XMLParser error message: U2XMAP/U2XML_extraction: Illegal U2XMAP file, missing t he U2XMAP. Open file error. Any help would be GREATLY appreciated Thanks in advance Ed Burwell 973-361-5400 ext. 1512 [EMAIL PROTECTED] __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UD Terminal Emulator using UniObjects
Has anyone seen or attempted to create a UD terminal emulator with vb6 and UniObjects? What control would you use as the emulator? TextBox? PictureBox? WebBrowser control? How do you handle the terminal definition? Do you actually scrape the screen, then display the results (perhaps in a picturebox), then capture keystrokes and display them? Any info would be greatly appreciated. Thanks in advance. Ed Burwell 973-361-5400 ext. 1512 [EMAIL PROTECTED] __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] LPTR / SETPTR / print from a specific tray
Thanks!!! -Original Message- From: Bruce Nichol [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 20, 2005 7:11 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] LPTR / SETPTR / print from a specific tray Goo'day, At 18:22 20/09/05 -0400, you wrote: Hey Paul, Do you (or anyone else) know how to tell a LaserJet to draw paper from a specific tray? We've been using: 0040: LOWER.TRAY = ESC:'l5H' 0041: UPPER.TRAY = ESC:'l1H' 0042: * (that's a lower-case L in there) HTH, in some way. -Original Message- From: Paul Trebbien [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 20, 2005 5:34 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] LPTR / SETPTR / landscape orientation example Hi Andy, Looks like several posts, did you resolve this? I saw a couple of suggestions in the emails, here's my 2 cents for a program that will set the setting for an HP Laserjet. Note, we have a printer definitions files where you enter the 'hex' codes for the escape sequences to setup the printer and a hex escape sequence to return the printer to the default settings. This is very nice as the user logs on he has a default printer, he can change the printer (from a menu), or a process can be defined to use only the specified printer. Anyway, when user prints the 'software' know which printer is to be used and sends the 'setup' escape sequence and when the print job is complete the 'software' sends the 'reset' escape sequence to the printer. Here is an example program for this and at the end a list of hex commands for a few HP Laserjet and Epson LQ printers - these are old lists and hopefully contain the correct codes. ** PROGRAM : SETUP.HP.LASERJET ** PURPOSE : Send Escape Codes to HP LaserJet ** INPUT ANS ** GOT.CODE=0 BEGIN CASE CASE ANS=L ; CODE=1B266C314F ; GOT.CODE=1 ;* Set Landscape mode CASE ANS=P ; CODE=1B266C304F ; GOT.CODE=1 ;* Set Portrait mode CASE ANS=R ; CODE=1B45 ; GOT.CODE=1 ;* Reset to Default CASE 1 END CASE IF GOT.CODE THEN PRINT ICONV(CODE,'MX'): END * END HP LASERJET HEX COMMAND: DESCRIPTION: 1B45Reset 1B266C314F Landscape 1B266C304F Portrait 1B283855 HP Roman8 1B28733070 Fixed Spacing 31302E30306810.00 Characters per Inch 31322E3076 12.0 Point Size 3073Upright Style 3062Normal Stroke Weight 3354Courier Typeface 1B266C3644 6 Lines per Inch 1B266C3145 1 line Top Margin 1B266C34394649 lines Text Length 1B266C36344664 lines Text Length EPSON LQ and compatible printers HEX COMMAND: DESCRIPTION: Here is a breakdown of what each of these codes mean: 1B40 RESET/INITIALIZE PRINTER 1B50 SELECT PICA PRINT (10 CPI) 1B0F SELECT COMPRESSED PRINT (17 CPI) 1B7830 == SELECT DRAFT FONT 1B7831 == SELECT NLQ (NEAR-LETTER-QUALITY) FONT 1B4315 == SET 21 LINES/PAGE (WHERE 15 HEX = 21 DEC) 1B4316 == SET 22 LINES/PAGE (WHERE 16 HEX = 22 DEC) 1B4321 == SET 33 LINES/PAGE (WHERE 21 HEX = 33 DEC) 1B432A == SET 42 LINES/PAGE (WHERE 2A HEX = 42 DEC) 1B4333 == SET 51 LINES/PAGE (WHERE 33 HEX = 51 DEC) 1B433C == SET 60 LINES/PAGE (WHERE 3C HEX = 60 DEC) 1B4342 == SET 66 LINES/PAGE (WHERE 42 HEX = 66 DEC) 1B4F DISABLE SKIP OVER PERFORATION MODE 0D == CARRIAGE RETURN (FLUSH BUFFER, PROCESS COMMAND) An example of a program to set an HP Laserjet printer to Landscape and then to Reset printer back: Paul Trebbien Kore Technologies, Senior Support Tech. Solutions that work. People who care. V 858.678.0030 F 858.300.2600 W koretech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Andy Pflueger Sent: Monday, September 19, 2005 5:26 AM To: U2 User Group Mailing List Subject: [U2] LPTR / SETPTR / landscape orientation example Hi gang, I'm in the process of tweaking one of our reports which use a LIST ... LPTR command line to spool the output to the default printer. However, the results are too wide for portrait orientation and was wanting to find a way to set the orientation with SETPTR prior to the execution of the LIST statement. I tried to use the following statement but that doesn't seem to change the default orientation of the printer: UDTEXECUTE 'SETPTR 0,1,,Orientation=LANDSCAPE' CAPTURING ASPMSG More code pasted below: 095: * 096: *-- SELECTION 097: * 098: PRINT @(0,21):@(-4):Sort/Select in progress... 099: START.DATE=OCONV(START.DATE,'D2/') 100: END.DATE=OCONV(END.DATE,'D2/') 101: INIT.CMD='SELECT JOB.MATL WITH' 102: IF START.PERIOD # END.PERIOD THEN 103: INIT.CMD := ' CONO_WPER GE ':CONO:START.PERIOD:' AND WITH CONO_WPER LE ':CONO:END.PERIOD:'' 104: END ELSE 105: INIT.CMD := ' CONO_WPER EQ ':CONO:START.PERIOD:'' 106: END 107: UDTEXECUTE INIT.CMD CAPTURING ASPMSG 108: * 109: UDTEXECUTE 'SETPTR 0,1,,Orientation=LANDSCAPE' CAPTURING ASPMSG 110: CMD = 'LIST JOB.MATL BY
[U2] LPTR / SETPTR / print from a specific tray
Hey Paul, Do you (or anyone else) know how to tell a LaserJet to draw paper from a specific tray? -Original Message- From: Paul Trebbien [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 20, 2005 5:34 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] LPTR / SETPTR / landscape orientation example Hi Andy, Looks like several posts, did you resolve this? I saw a couple of suggestions in the emails, here's my 2 cents for a program that will set the setting for an HP Laserjet. Note, we have a printer definitions files where you enter the 'hex' codes for the escape sequences to setup the printer and a hex escape sequence to return the printer to the default settings. This is very nice as the user logs on he has a default printer, he can change the printer (from a menu), or a process can be defined to use only the specified printer. Anyway, when user prints the 'software' know which printer is to be used and sends the 'setup' escape sequence and when the print job is complete the 'software' sends the 'reset' escape sequence to the printer. Here is an example program for this and at the end a list of hex commands for a few HP Laserjet and Epson LQ printers - these are old lists and hopefully contain the correct codes. ** PROGRAM : SETUP.HP.LASERJET ** PURPOSE : Send Escape Codes to HP LaserJet ** INPUT ANS ** GOT.CODE=0 BEGIN CASE CASE ANS=L ; CODE=1B266C314F ; GOT.CODE=1 ;* Set Landscape mode CASE ANS=P ; CODE=1B266C304F ; GOT.CODE=1 ;* Set Portrait mode CASE ANS=R ; CODE=1B45 ; GOT.CODE=1 ;* Reset to Default CASE 1 END CASE IF GOT.CODE THEN PRINT ICONV(CODE,'MX'): END * END HP LASERJET HEX COMMAND: DESCRIPTION: 1B45Reset 1B266C314F Landscape 1B266C304F Portrait 1B283855 HP Roman8 1B28733070 Fixed Spacing 31302E30306810.00 Characters per Inch 31322E3076 12.0 Point Size 3073Upright Style 3062Normal Stroke Weight 3354Courier Typeface 1B266C3644 6 Lines per Inch 1B266C3145 1 line Top Margin 1B266C34394649 lines Text Length 1B266C36344664 lines Text Length EPSON LQ and compatible printers HEX COMMAND: DESCRIPTION: Here is a breakdown of what each of these codes mean: 1B40 RESET/INITIALIZE PRINTER 1B50 SELECT PICA PRINT (10 CPI) 1B0F SELECT COMPRESSED PRINT (17 CPI) 1B7830 == SELECT DRAFT FONT 1B7831 == SELECT NLQ (NEAR-LETTER-QUALITY) FONT 1B4315 == SET 21 LINES/PAGE (WHERE 15 HEX = 21 DEC) 1B4316 == SET 22 LINES/PAGE (WHERE 16 HEX = 22 DEC) 1B4321 == SET 33 LINES/PAGE (WHERE 21 HEX = 33 DEC) 1B432A == SET 42 LINES/PAGE (WHERE 2A HEX = 42 DEC) 1B4333 == SET 51 LINES/PAGE (WHERE 33 HEX = 51 DEC) 1B433C == SET 60 LINES/PAGE (WHERE 3C HEX = 60 DEC) 1B4342 == SET 66 LINES/PAGE (WHERE 42 HEX = 66 DEC) 1B4F DISABLE SKIP OVER PERFORATION MODE 0D == CARRIAGE RETURN (FLUSH BUFFER, PROCESS COMMAND) An example of a program to set an HP Laserjet printer to Landscape and then to Reset printer back: Paul Trebbien Kore Technologies, Senior Support Tech. Solutions that work. People who care. V 858.678.0030 F 858.300.2600 W koretech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Andy Pflueger Sent: Monday, September 19, 2005 5:26 AM To: U2 User Group Mailing List Subject: [U2] LPTR / SETPTR / landscape orientation example Hi gang, I'm in the process of tweaking one of our reports which use a LIST ... LPTR command line to spool the output to the default printer. However, the results are too wide for portrait orientation and was wanting to find a way to set the orientation with SETPTR prior to the execution of the LIST statement. I tried to use the following statement but that doesn't seem to change the default orientation of the printer: UDTEXECUTE 'SETPTR 0,1,,Orientation=LANDSCAPE' CAPTURING ASPMSG More code pasted below: 095: * 096: *-- SELECTION 097: * 098: PRINT @(0,21):@(-4):Sort/Select in progress... 099: START.DATE=OCONV(START.DATE,'D2/') 100: END.DATE=OCONV(END.DATE,'D2/') 101: INIT.CMD='SELECT JOB.MATL WITH' 102: IF START.PERIOD # END.PERIOD THEN 103: INIT.CMD := ' CONO_WPER GE ':CONO:START.PERIOD:' AND WITH CONO_WPER LE ':CONO:END.PERIOD:'' 104: END ELSE 105: INIT.CMD := ' CONO_WPER EQ ':CONO:START.PERIOD:'' 106: END 107: UDTEXECUTE INIT.CMD CAPTURING ASPMSG 108: * 109: UDTEXECUTE 'SETPTR 0,1,,Orientation=LANDSCAPE' CAPTURING ASPMSG 110: CMD = 'LIST JOB.MATL BY CTR BY JOB BY PERIOD BY DATE BY TRANS WITH' 111: IF DEPT.IN http://DEPT.IN # 'ALL' THEN 112: CMD:=' JMT.DEPT = ':DEPT.IN:'' 113: IF DEPT.IN http://DEPT.IN = '23' THEN 114: CMD:=' AND WITH GJOB.CHECK # ' 115: CMD:=' AND WITH P.QTY 0' 116: END 117: END 118: IF START.DATE NE END.DATE THEN 119: CMD:=' AND WITH DATE GE ':START.DATE:' AND WITH DATE LE ':END.DATE: '' 120: END ELSE 121: CMD:=' AND WITH DATE EQ ':START.DATE:'' 122: END
RE: [U2] BY-EXP criteria in ecltype 'u'
Thanks. And thanks for pointing out that FMT does not need a particular ECLTYPE. I tried it and it worked, however, I could not get CNV to work under ECLTYPE=P. -Original Message- From: Keith W. Roberts [mailto:[EMAIL PROTECTED] Sent: Thursday, September 15, 2005 5:59 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] BY-EXP criteria in ecltype 'u' I haven't played with this in UniData yet, but in UniVerse I would use both WITH (to limit the selection) and WHEN (to limit the values shown): SORT ORDER.FILE WITH MODEL = ABC XYZ BY-EXP MODEL WHEN MODEL = ABC XYZ BREAK-ON MODEL TOTAL QTY According to UniData HELP, FMT and CNV don't require any particular ECLTYPE, but WHEN requires ECLTYPE=U. -Keith -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward Sent: Wednesday, September 14, 2005 6:02 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] BY-EXP criteria in ecltype 'u' We are on UniData 6.1 and our ecltype is 'p'. I'm sure we are all familiar with a query like this: SORT ORDER.FILE BY-EXP MODEL BREAK-ON MODEL TOTAL QTY PRICE TOTAL EXT If I want to run the above query for a specific model or models, I can do something like this: SORT ORDER.FILE BY-EXP MODEL ABC XYZ BREAK-ON MODEL TOTAL QTY This will not only explode the MODEL attribute, it will return only values where the MODEL is equal to ABC or XYZ. This works (I think) because we are running ecltype 'p' (pick). When we need to do a query that takes advantage of nice UniData stuff like COL.HDG, FMT, CNV, etc, we write it so our SORT or LIST is in lower case. Like this: sort ORDER.FILE BY.EXP MODEL BREAK.ON MODEL TOTAL QTY * However * If I want to run the lower case sort with the BY.EXP criteria, it doesn't work for me. I've tried: sort ORDER.FILE BY.EXP MODEL XYZ BREAK.ON MODEL TOTAL QTY No records listed. The following record ids do not exist: XYZ (EOF)Enter h for help, CR for next page and I've tried: sort ORDER.FILE BY.EXP MODEL = XYZ BREAK.ON MODEL TOTAL QTY ^ syntax error Has anyone run into this? Do I need to play with WHEN and ASSOCIATED? Thanks in advance. Ed Burwell 973-361-5400 ext. 1512 [EMAIL PROTECTED] __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- 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/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] BY-EXP criteria in ecltype 'u'
We are on UniData 6.1 and our ecltype is 'p'. I'm sure we are all familiar with a query like this: SORT ORDER.FILE BY-EXP MODEL BREAK-ON MODEL TOTAL QTY PRICE TOTAL EXT If I want to run the above query for a specific model or models, I can do something like this: SORT ORDER.FILE BY-EXP MODEL ABC XYZ BREAK-ON MODEL TOTAL QTY This will not only explode the MODEL attribute, it will return only values where the MODEL is equal to ABC or XYZ. This works (I think) because we are running ecltype 'p' (pick). When we need to do a query that takes advantage of nice UniData stuff like COL.HDG, FMT, CNV, etc, we write it so our SORT or LIST is in lower case. Like this: sort ORDER.FILE BY.EXP MODEL BREAK.ON MODEL TOTAL QTY * However * If I want to run the lower case sort with the BY.EXP criteria, it doesn't work for me. I've tried: sort ORDER.FILE BY.EXP MODEL XYZ BREAK.ON MODEL TOTAL QTY No records listed. The following record ids do not exist: XYZ (EOF)Enter h for help, CR for next page and I've tried: sort ORDER.FILE BY.EXP MODEL = XYZ BREAK.ON MODEL TOTAL QTY ^ syntax error Has anyone run into this? Do I need to play with WHEN and ASSOCIATED? Thanks in advance. Ed Burwell 973-361-5400 ext. 1512 [EMAIL PROTECTED] __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] delimiter with LIST command?
If you are like us, running UniData with ECLTYPE 'p' then make sure your LIST command is in lower case: list FILE.NAME ADDRESS CITY STATE ZIP TO DELIM , /unix_path/unix_file -Original Message- From: Jeff Powell [mailto:[EMAIL PROTECTED] Sent: Thursday, July 07, 2005 4:29 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] delimiter with LIST command? I get an Illegal attribute name: TO The real problem here is that I need to handle the multivalued attributes. Using BY.EXP does not seem to work in this application either. Thanks, On Thu, 2005-07-07 at 12:29 -0700, Kent Walker wrote: That would be the LIST TO DELIM syntax. Using a single (non-printable) tab character between the quotes will generate a tab-delimited file which is very easy to pull into a spreadsheet. At 11:24 AM 7/7/2005, Jeff Powell wrote: I am executing a list command via uniojbects and I need to parse the resulting screen output into columns. Is there a way to print a character between each attribute? Thanks. --- Kent Walker - Datatel Analyst Information Technology - U.C. Hastings College of the Law 415-565-4635 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ Jeffrey Powell IT Manager Industrial Piping Specialists 606 North 145th Street East Tulsa, OK 74116 (918) 270-6311 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Custom Functions
Here is a sample: MYFUNC looks like: 001 FUNCTION MYFUNC(ARG) 002 RETURN (ARG=Y) 003 END MYFUNC is globally cataloged DICT FILE TEST looks like: 001 V 002 SUBR(MYFUNC,Y) 003 004 005 1R 006 S when I LIST FILE TEST, I get a Segmentation fault(coredump) and it dumps me into Unix. -Original Message- From: Ray Wurlod [mailto:[EMAIL PROTECTED] Sent: Thursday, June 23, 2005 1:22 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions Try using the SUBR() function, as I mentioned in another post. - Original Message - From: Burwell, Edward [EMAIL PROTECTED] To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions Date: Wed, 22 Jun 2005 19:49:44 -0400 I've tried calling functions from UniData Virtual Attribute and they blow up. Bummer. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Custom Functions
I've never seen this asterisk thing on the front of a cataloged program. I've never had to do that in UniData. I can call a SUBROUTINE fine from a Virtual attribute no problem - and not asterisk. Could it have something to do with the fact that we run BASICTYPE 'p' and ECLTYPE 'p'? -Original Message- From: gerry-u2ug [mailto:[EMAIL PROTECTED] Sent: Thursday, June 23, 2005 1:41 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions globally catalogued as in CATALOG SUB.BP *MYFUNC ? so you should be using : SUBR(*MYFUNC,Y) we do this all the time in universe since at least v7 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Burwell, Edward Sent: Thursday, June 23, 2005 10:46 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions Here is a sample: MYFUNC looks like: 001 FUNCTION MYFUNC(ARG) 002 RETURN (ARG=Y) 003 END MYFUNC is globally cataloged DICT FILE TEST looks like: 001 V 002 SUBR(MYFUNC,Y) 003 004 005 1R 006 S when I LIST FILE TEST, I get a Segmentation fault(coredump) and it dumps me into Unix. -Original Message- From: Ray Wurlod [mailto:[EMAIL PROTECTED] Sent: Thursday, June 23, 2005 1:22 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions Try using the SUBR() function, as I mentioned in another post. - Original Message - From: Burwell, Edward [EMAIL PROTECTED] To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions Date: Wed, 22 Jun 2005 19:49:44 -0400 I've tried calling functions from UniData Virtual Attribute and they blow up. Bummer. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- 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/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Custom Functions
Interesting. But you NEED that extra parameter? I tried DEFFUNing a SUBROUTINE that has only 1 parameters and could not get it to work. If your FUNCTION sets any of the parameters, you can CALL It from UniBasic -- and you don't have to DEFFUN it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, June 23, 2005 5:52 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions I think it's a universe/unidata difference. I get the segmentation fault running unidata in ecl type U as well. Here's some interesting info and an ugly hack--in unidata. Apparently, the keywords SUBROUTINE and FUNCTION are interchangable as far as BASIC is concerned, so create a subroutine SUBROUTINE MYHACK(A,B) A=B*2 ;* note that we both assign the result to a parameter AND return the result RETURN A Then you can call it as a function with PROGRAM HACKTEST DEFFUN MYHACK(A,B) CRT MYHACK('',2);* --- there's the hack. You need that placeholder parameter Or use it as a subroutine: PROGRAM HACK2 CALL MYHACK(A,2) CRT A Or from a virtual attribute: I SUBR('MYHACK',EXTRACT(@RECORD,1,0,0)) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward Sent: Thursday, June 23, 2005 4:09 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Custom Functions I've never seen this asterisk thing on the front of a cataloged program. I've never had to do that in UniData. I can call a SUBROUTINE fine from a Virtual attribute no problem - and not asterisk. Could it have something to do with the fact that we run BASICTYPE 'p' and ECLTYPE 'p'? -Original Message- From: gerry-u2ug [mailto:[EMAIL PROTECTED] Sent: Thursday, June 23, 2005 1:41 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions globally catalogued as in CATALOG SUB.BP *MYFUNC ? so you should be using : SUBR(*MYFUNC,Y) we do this all the time in universe since at least v7 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Burwell, Edward Sent: Thursday, June 23, 2005 10:46 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions Here is a sample: MYFUNC looks like: 001 FUNCTION MYFUNC(ARG) 002 RETURN (ARG=Y) 003 END MYFUNC is globally cataloged DICT FILE TEST looks like: 001 V 002 SUBR(MYFUNC,Y) 003 004 005 1R 006 S when I LIST FILE TEST, I get a Segmentation fault(coredump) and it dumps me into Unix. -Original Message- From: Ray Wurlod [mailto:[EMAIL PROTECTED] Sent: Thursday, June 23, 2005 1:22 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions Try using the SUBR() function, as I mentioned in another post. - Original Message - From: Burwell, Edward [EMAIL PROTECTED] To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions Date: Wed, 22 Jun 2005 19:49:44 -0400 I've tried calling functions from UniData Virtual Attribute and they blow up. Bummer. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- 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/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- 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/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Barcode Label print software
Hello, We are doing some research on label print software. I would love to hear some real-life testimonies from real users. I've seen TL Ashford's product, but it has to live on an as/400. I'm looking for something that will live either on our rs/6000 or a windows server. I am envisioning a print-engine that will live out on our network (or on our Unix box), that we can send a message to (CSV, XML, whatever), and it will take our message, map out the fields to the appropriate label format and print the label or labels to the appropriate printer (DATAMAX, Zebra, Printronix, etc). Some Requirements: 1. Generates an RFID encoded tag 2. Provides Vendor-Compliant label formats for major customers (Wal-Mart, Target, etc) 3. WYSIWYG label design 4. Supports UPS Maxicode Nice to have: 1. Web interface Would love to hear your experiences. Thanks. Ed Burwell 973-361-5400 ext. 1512 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Custom Functions
I've tried calling functions from UniData Virtual Attribute and they blow up. Bummer. -Original Message- From: Ray Wurlod [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 22, 2005 7:00 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Custom Functions Previous posters have pretty much covered the ground. UniVerse (and, I suspect but can't be certain about, UniData) functions are implemented as subroutines, with the first argument position on the stack reserved for the return value which is a DATUM. It can even be a file variable or subroutine variable! It follows that, while a subroutine can have 255 arguments, a function is only allowed 254. Don't go there! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Run a program in Silent mode
Hello, Is there a simple UniBasic command (kinda like ECHO OFF) that would cause all PRINT @(x,y) statements to be suppressed? I have a program that prints to the screen that I want to run in an automatic mode and I want it to not print to the screen. We are on UniData 6 - aix. Thanks. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Run a program in Silent mode
Sweet! Thanks!!! :-) -Original Message- From: Pingilley, Ron [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 1:41 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Run a program in Silent mode Ed, Try HUSH. Here's the help for it: HUSH statement _ SYNTAX HUSH {ON | OFF | expression} [SETTING status] DESCRIPTION Use the HUSH statement to suppress the display of all output normally sent to a terminal during processing. HUSH also suppresses output to a COMO file or TANDEM display. SETTING status sets the value of a variable to the value of the HUSH state before the HUSH statement was executed. It can be used instead of the STATUS function to save the state so that it can be restored later. STATUS has a value of 1 if the previous state was HUSH ON or a value of 0 if the previous state was HUSH OFF. --Ron P. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward Sent: Wednesday, April 27, 2005 12:22 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Run a program in Silent mode Hello, Is there a simple UniBasic command (kinda like ECHO OFF) that would cause all PRINT @(x,y) statements to be suppressed? snip --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Run a program in Silent mode
HUSH did the trick! Thanks to you all! -Original Message- From: Ed Clark [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 27, 2005 2:09 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Run a program in Silent mode You could use HUSH ON and HUSH OFF within the program, or you could execute the program from another BASIC program using the EXECUTE statement's CAPTURING clause. You could also run the program from unix using output redirection, i.e: udt progname /dev/null -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Burwell, Edward Sent: Wednesday, April 27, 2005 12:22 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Run a program in Silent mode Hello, Is there a simple UniBasic command (kinda like ECHO OFF) that would cause all PRINT @(x,y) statements to be suppressed? I have a program that prints to the screen that I want to run in an automatic mode and I want it to not print to the screen. We are on UniData 6 - aix. Thanks. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 --- 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/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] PICK Assembler Language
Maybe Dave Miller from NJ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, November 05, 2004 10:09 AM To: [EMAIL PROTECTED] Subject: [U2] PICK Assembler Language Don't laugh at this, but could anybody use a contractor who knows PICK Assembler language? Larry Okeson VP Software Search Atlanta 800-949-5423 [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] UniObjects and Time zones
Ken, Thanks for your reply. Here is what we ended up doing - We changed our environment TZ variable from EST5EDT1:00,M4.1.0/2:00:00,M10.4.0/2:00:00 to EST0EDT1:00,M4.1.0/2:00:00,M10.4.0/2:00:00(changed the offset from 5 to 0) And changed the hardware clock to the local time (EST). Now Unix, UniData and UniObjects see the same time and date. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -Original Message- From: Ken Wallis [mailto:[EMAIL PROTECTED] Sent: Saturday, October 30, 2004 7:40 PM To: [EMAIL PROTECTED] Subject: RE: [U2] [UD] UniObjects and Time zones Ed, I believe that on AIX TZ is set from /etc/environment during the login process. The unirpcd which serves all your UniObjects connections doesn't go through this process so it likely doesn't have a setting for TZ and defaults to GMT. Have a look at the options for unirpcd and see if you can give it an environment file at startup. Otherwise you may have to write a wrapper script called unirpcd which simply sets the environment and execs the real unirpcd. Cheers, Ken Burwell, Edward wrote: When we boot our AIX system, it shows the current date and time as GMT (UTC?) and our time zone is EST, therefore when I do a date at the Unix prompt, I get: Thu Oct 28 16:25:44 EST 2004 And when I do a DATE at our UniData prompt, I get: Thu Oct 28 16:26:00 EST 2004 These are giving me the correct time and date. When I do echo $TZ at a Unix prompt, I get: EST5EDT1:00,M4.1.0/2:00:00,M10.4.0/2:00:00 Therefore, our time zone is correct as far as Unix and UniData goes. However, when I run the command: LIST WORK.ORDER DT TM SAMPLE 10 through a UniObjects program (see below), It gives me the raw date and time - with no time zone offset applied. So my question is, where does UniObjects get the time zone when a dictionary containing @TIME, TIME(), @DATE or DATE() is run? btw, I don't see anything in my .profile that has anything to do with time zone. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] UniObjects and Time zones
Yes, I am on Unix (AIX) and it would seem to be a time zone issue. Any dictionary containing @DATE, DATE(), @TIME or TIME(), that is run by UniObjects is giving me GMT. How can I tell UniObjects to apply our time zone? Thanks Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -Original Message- From: Mark Eastwood [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 11:40 AM To: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Where does UniObjects get @DATE and @TIME from? Assuming you're on Unix - there is an environmental setting tz for timezone. Try man on tz or timezone. -Original Message- From: Burwell, Edward [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 10:06 AM To: [EMAIL PROTECTED] Subject: Spam:RE: [U2] [UD] Where does UniObjects get @DATE and @TIME from? Regardless, the @DATE and @TIME are different by about 5 hours. Is there a setting in UniObjects that determines or sets the time zone that I'm in? -Original Message- From: Bob Witney [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 6:52 AM To: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Where does UniObject get @DATE and @TIME from? Yes @TIME on Universe is the proces start time as an intiger (regardless of what the book says) and TIME() is the actual time with decimals i.e 42716 42716.8421 42716 42717.8422 42716 42718.8424 Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brian Leach Sent: 27 October 2004 11:15 To: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Where does UniObject get @DATE and @TIME from? @DATE and @TIME are not necessarily the current date and time, they are the date and time the current command/program started. I've seen this as differences in a program between @TIME and TIME(), which always returns the current time. I'm away from my server at the moment and can't verify this, but I suspect that @TIME might be the time that your UniObjects session began. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward Sent: 27 October 2004 01:49 To: '[EMAIL PROTECTED]' Subject: [U2] [UD] Where does UniObject get @DATE and @TIME from? Hello all, I have a file with 2 dictionaries. One called DT and the other TM: DT 001 V 002 @DATE I also tried DATE() and got the same thing 003 004 005 5R 006 S TM 001 V 002 @TIME I also tried TIME() and got the same thing 003 004 005 6R 006 S When I run a simple UniQuery statement, I get exactly what you'd expect LIST WORK.ORDER DT TM SAMPLE 5 WORK ORDER. DT... TM 584367 13449 74797 59 13449 74797 628402 13449 74797 663471 13449 74797 698540 13449 74797 5 records listed HOWEVER... When I run this through UniOjects, I get: LIST WORK.ORDER DT TM SAMPLE 5 01:48:20 Oct 27 2004 1 WORK ORDER. DT... TM 584367 13450 6500 59 13450 6500 628402 13450 6500 663471 13450 6500 698540 13450 6500 5 records listed I am running UniData 5.2 on AIX 4.3.2. It's around 20:48 on 10/26/2004 as I write this. The time and date is right on our Unix box and it's correct on my XP PC. My control panel, regional and date and time setting are correct also. I am on the East Coast of the US. (and it seems to be off by 5 hours, hmmm) Where does UniObjects get the @DATE and @TIME variables? Thanks. Ed Burwell --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology
RE: [U2] [UD] UniObjects and Time zones
When we boot our AIX system, it shows the current date and time as GMT (UTC?) and our time zone is EST, therefore when I do a date at the Unix prompt, I get: Thu Oct 28 16:25:44 EST 2004 And when I do a DATE at our UniData prompt, I get: Thu Oct 28 16:26:00 EST 2004 These are giving me the correct time and date. When I do echo $TZ at a Unix prompt, I get: EST5EDT1:00,M4.1.0/2:00:00,M10.4.0/2:00:00 Therefore, our time zone is correct as far as Unix and UniData goes. However, when I run the command: LIST WORK.ORDER DT TM SAMPLE 10 through a UniObjects program (see below), It gives me the raw date and time - with no time zone offset applied. So my question is, where does UniObjects get the time zone when a dictionary containing @TIME, TIME(), @DATE or DATE() is run? btw, I don't see anything in my .profile that has anything to do with time zone. Thanks. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -Original Message- From: Adrian Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, October 28, 2004 2:35 PM To: [EMAIL PROTECTED] Subject: RE: [U2] [UD] UniObjects and Time zones You haven't got something in your account login that is setting timezone stuff perhaps? Uniobjects bypasses the login. Also are you running the uo session under the same user as the telnet session that is giving you the correct date? Might be set in profile. From: [EMAIL PROTECTED] on behalf of Burwell, Edward Sent: Thu 28/10/2004 15:08 To: '[EMAIL PROTECTED]' Subject: [U2] [UD] UniObjects and Time zones Yes, I am on Unix (AIX) and it would seem to be a time zone issue. Any dictionary containing @DATE, DATE(), @TIME or TIME(), that is run by UniObjects is giving me GMT. How can I tell UniObjects to apply our time zone? Thanks Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -Original Message- From: Mark Eastwood [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 11:40 AM To: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Where does UniObjects get @DATE and @TIME from? Assuming you're on Unix - there is an environmental setting tz for timezone. Try man on tz or timezone. -Original Message- From: Burwell, Edward [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 10:06 AM To: [EMAIL PROTECTED] Subject: Spam:RE: [U2] [UD] Where does UniObjects get @DATE and @TIME from? Regardless, the @DATE and @TIME are different by about 5 hours. Is there a setting in UniObjects that determines or sets the time zone that I'm in? -Original Message- From: Bob Witney [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 6:52 AM To: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Where does UniObject get @DATE and @TIME from? Yes @TIME on Universe is the proces start time as an intiger (regardless of what the book says) and TIME() is the actual time with decimals i.e 42716 42716.8421 42716 42717.8422 42716 42718.8424 Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brian Leach Sent: 27 October 2004 11:15 To: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Where does UniObject get @DATE and @TIME from? @DATE and @TIME are not necessarily the current date and time, they are the date and time the current command/program started. I've seen this as differences in a program between @TIME and TIME(), which always returns the current time. I'm away from my server at the moment and can't verify this, but I suspect that @TIME might be the time that your UniObjects session began. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward Sent: 27 October 2004 01:49 To: '[EMAIL PROTECTED]' Subject: [U2] [UD] Where does UniObject get @DATE and @TIME from? Hello all, I have a file with 2 dictionaries. One called DT and the other TM: DT 001 V 002 @DATE I also tried DATE() and got the same thing 003 004 005 5R 006 S TM 001 V 002 @TIME I also tried TIME() and got the same thing 003 004 005 6R 006 S When I run a simple UniQuery statement, I get exactly what you'd expect LIST WORK.ORDER DT TM SAMPLE 5 WORK ORDER. DT... TM 584367 13449 74797 59 13449 74797 628402 13449 74797 663471 13449 74797 698540 13449 74797 5 records listed HOWEVER... When I run this through UniOjects, I get: LIST WORK.ORDER DT TM SAMPLE 5 01:48:20 Oct 27 2004 1 WORK ORDER. DT... TM 584367 13450 6500 59 13450 6500 628402 13450 6500 663471 13450 6500 698540 13450 6500 5 records listed I am running UniData 5.2 on AIX 4.3.2. It's around 20:48 on 10/26/2004 as I write this. The time and date is right on our Unix box and it's correct on my XP PC. My control panel, regional and date and time setting are correct also. I am on the East Coast of the US. (and it seems to be off by 5 hours, hmmm) Where does UniObjects get the @DATE and @TIME variables? Thanks. Ed Burwell --- u2-users mailing list [EMAIL PROTECTED
RE: [U2] [UD] Where does UniObjects get @DATE and @TIME from?
Regardless, the @DATE and @TIME are different by about 5 hours. Is there a setting in UniObjects that determines or sets the time zone that I'm in? -Original Message- From: Bob Witney [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 6:52 AM To: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Where does UniObject get @DATE and @TIME from? Yes @TIME on Universe is the proces start time as an intiger (regardless of what the book says) and TIME() is the actual time with decimals i.e 42716 42716.8421 42716 42717.8422 42716 42718.8424 Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brian Leach Sent: 27 October 2004 11:15 To: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Where does UniObject get @DATE and @TIME from? @DATE and @TIME are not necessarily the current date and time, they are the date and time the current command/program started. I've seen this as differences in a program between @TIME and TIME(), which always returns the current time. I'm away from my server at the moment and can't verify this, but I suspect that @TIME might be the time that your UniObjects session began. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward Sent: 27 October 2004 01:49 To: '[EMAIL PROTECTED]' Subject: [U2] [UD] Where does UniObject get @DATE and @TIME from? Hello all, I have a file with 2 dictionaries. One called DT and the other TM: DT 001 V 002 @DATE I also tried DATE() and got the same thing 003 004 005 5R 006 S TM 001 V 002 @TIME I also tried TIME() and got the same thing 003 004 005 6R 006 S When I run a simple UniQuery statement, I get exactly what you'd expect LIST WORK.ORDER DT TM SAMPLE 5 WORK ORDER. DT... TM 584367 13449 74797 59 13449 74797 628402 13449 74797 663471 13449 74797 698540 13449 74797 5 records listed HOWEVER... When I run this through UniOjects, I get: LIST WORK.ORDER DT TM SAMPLE 5 01:48:20 Oct 27 2004 1 WORK ORDER. DT... TM 584367 13450 6500 59 13450 6500 628402 13450 6500 663471 13450 6500 698540 13450 6500 5 records listed I am running UniData 5.2 on AIX 4.3.2. It's around 20:48 on 10/26/2004 as I write this. The time and date is right on our Unix box and it's correct on my XP PC. My control panel, regional and date and time setting are correct also. I am on the East Coast of the US. (and it seems to be off by 5 hours, hmmm) Where does UniObjects get the @DATE and @TIME variables? Thanks. Ed Burwell --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] Where does UniObject get @DATE and @TIME from?
Hello all, I have a file with 2 dictionaries. One called DT and the other TM: DT 001 V 002 @DATE I also tried DATE() and got the same thing 003 004 005 5R 006 S TM 001 V 002 @TIME I also tried TIME() and got the same thing 003 004 005 6R 006 S When I run a simple UniQuery statement, I get exactly what you'd expect LIST WORK.ORDER DT TM SAMPLE 5 WORK ORDER. DT... TM 584367 13449 74797 59 13449 74797 628402 13449 74797 663471 13449 74797 698540 13449 74797 5 records listed HOWEVER... When I run this through UniOjects, I get: LIST WORK.ORDER DT TM SAMPLE 5 01:48:20 Oct 27 2004 1 WORK ORDER. DT... TM 584367 13450 6500 59 13450 6500 628402 13450 6500 663471 13450 6500 698540 13450 6500 5 records listed I am running UniData 5.2 on AIX 4.3.2. It's around 20:48 on 10/26/2004 as I write this. The time and date is right on our Unix box and it's correct on my XP PC. My control panel, regional and date and time setting are correct also. I am on the East Coast of the US. (and it seems to be off by 5 hours, hmmm) Where does UniObjects get the @DATE and @TIME variables? Thanks. Ed Burwell --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] running a subroutine
001:PROMPT 002: 10 PRINT STR(-,79) 003:PRINT 'O'conv or 'I'conv :;INPUT OI 004:IF OI= THEN STOP 005:IF OI#O AND OI#I THEN GO 10 006:IF OI=O THEN ELB=OCONV 007:IF OI=I THEN ELB=ICONV 008: 20 PRINT STR(-,79) 009:PRINT enter conversion :;INPUT CONV 010:IF CONV= THEN GO 10 011: 30 PRINT STR(-,79) 012:PRINT enter data to test :;INPUT X 013:IF X= THEN GO 20 014:PRINT ELB:'(':X:',':CONV:') -- ': 015:IF OI=O THEN 016: PRINT OCONV(X,CONV) 017:END ELSE 018: PRINT ICONV(X,CONV) 019:END 020:GO 30 021: END -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 22, 2004 1:45 PM To: [EMAIL PROTECTED] Subject: Re: [U2] [UD] running a subroutine Date: Fri, 22 Oct 2004 09:12:12 -0400 From: Mark Johnson [EMAIL PROTECTED] I still maintain my opinion of most of these stupid' test programs because many of them look like this: 001 PROMPT ' 002 INPUT ANS 003 PRINT OCONV(ANS,MD2,$Z) 004 END and another one looks like this 001 PROMPT 002 INPUT ANS 003 PRINT OCONV(ANS,DMA) 004 END So...create more intelligent test programs -- Data driven software is a wonderful thing! I wrote this one (OCONV.TEST) to do just the sort of things you've noted above: 001 PROMPT 002 LOOP 003PRINT Test Format: : 004INPUT TEST.FORMAT 005 WHILE TEST.FORMAT # DO 006LOOP 007 PRINT Input Value: : 008 INPUT TEST.VAL 009WHILE TEST.VAL # DO 010 PRINT Converted: *:OCONV(TEST.VAL,TEST.FORMAT):* 011REPEAT 012 REPEAT 013 END I agree with others who have suggested setting up a separate file for testing...I often wish I had done so :- Someday, in my copious free time, I'll clean up my old program file... --Tom Pellitieri Century Equipment Toledo, Ohio --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [ud] UniObjects Dynamic Array Type Mismatch only in .exe
Thanks Martin. Do you know if Native Code runs slower/faster/the same as P-Code? -Original Message- From: Martin Scholl [mailto:[EMAIL PROTECTED] Sent: Friday, August 27, 2004 11:24 AM To: [EMAIL PROTECTED] Subject: RE: [U2] [ud] UniObjects Dynamic Array Type Mismatch only in .exe On VB6 there is an issue with the 'Compile to Native Code' option and UniObjects. Code that beautifully works in design mode, crashes in the exe. You have to 'Compile to P-Code' and your code will work. BTW, I also append .stringvalue after each reference to an attribute, a value or a subvalue. I am curious to check out UniObjects.NET. Martin Scholl President Martin Scholl Consulting, Inc. http://www.hipaasuite.com/ mailto:[EMAIL PROTECTED] 18910 New Hampshire Ave Brinklow, MD 20862 301-924-5537 Phone 301-570-0139 Fax 301-613-9572 Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Burwell, Edward Sent: Monday, August 23, 2004 12:18 PM To: '[EMAIL PROTECTED]' Subject: [U2] [ud] UniObjects Dynamic Array Type Mismatch only in .exe Please give me your advice. For example: - Dim iNumber as Integer Dim dArray As UniDynArray Set dArray = New UniDynArray 10: dArray.Value(1,1) = Some String 40: dArray.Value(2,1) = 50 70: dArray.Value(2,1) = dArray.Value(2,1) + 25 90: iNumber = dArray.Value(2,1) -- This is a silly example, but it illustrates the problem that I am experiencing. Then I run this in the design environment, it runs fine. When I create an .exe and run it, it bombs on line 90 with an Type Mismatch error (error 13). What am I doing wrong? Has anyone else experienced this? UniData 5.2 UniObjects 5.2 VB 6.0 SP5 uniobjects.dll (236KB) is version 3.1.3.1084 (product version 3.1.2) and is dated 12/11/2001 Thanks in advance. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [ud] UniObjects Dynamic Array Type Mismatch only in .ex e
Jef, Thanks! That worked, however, the size of the .exe went from 28K to 16K when I compiled to P-Code. Does this mean the app will run slower? Faster? The Same? Thanks Ed -Original Message- From: Jef Lee [mailto:[EMAIL PROTECTED] Sent: Monday, August 23, 2004 9:30 PM To: [EMAIL PROTECTED] Subject: RE: [U2] [ud] UniObjects Dynamic Array Type Mismatch only in .exe You may be experiencing a problem we had with VB6 in the executable. Try setting your project compilation to P-code. It makes a difference to the way the values are assigned to the dynamic arrays. Jef... IT Vision Level 3 Kirin Centre, 15 Ogilvie Road, APPLECROSS, WA 6153 Tel: (08) 9315 7000 Fax: (08) 9315 7088 P O Box 881, Canning Bridge, WA 6153 A.C.N. 068 914 867 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward Sent: Tuesday, August 24, 2004 2:32 AM To: '[EMAIL PROTECTED]' Subject: RE: [U2] [ud] UniObjects Dynamic Array Type Mismatch only in .exe The issue is why does it work fine in design mode and blow up when it's an executable? It looks like the + sign is acting like a plus sign in design mode, but acting like an ampersand ( string-concatenation) when run as an .exe. -Original Message- From: Adrian Matthews [mailto:[EMAIL PROTECTED] Sent: Monday, August 23, 2004 1:23 PM To: [EMAIL PROTECTED] Subject: RE: [U2] [ud] UniObjects Dynamic Array Type Mismatch only in .exe Have you tried a CInt around the dArray.Value(2,1). I'm guessing that the dynamic array object stores everything as strings or variants. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward Sent: 23 August 2004 17:18 To: '[EMAIL PROTECTED]' Subject: [U2] [ud] UniObjects Dynamic Array Type Mismatch only in .exe Please give me your advice. For example: - Dim iNumber as Integer Dim dArray As UniDynArray Set dArray = New UniDynArray 10: dArray.Value(1,1) = Some String 40: dArray.Value(2,1) = 50 70: dArray.Value(2,1) = dArray.Value(2,1) + 25 90: iNumber = dArray.Value(2,1) -- This is a silly example, but it illustrates the problem that I am experiencing. Then I run this in the design environment, it runs fine. When I create an .exe and run it, it bombs on line 90 with an Type Mismatch error (error 13). What am I doing wrong? Has anyone else experienced this? UniData 5.2 UniObjects 5.2 VB 6.0 SP5 uniobjects.dll (236KB) is version 3.1.3.1084 (product version 3.1.2) and is dated 12/11/2001 Thanks in advance. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] [ud] UniObjects Dynamic Array Type Mismatch only in .exe
Please give me your advice. For example: - Dim iNumber as Integer Dim dArray As UniDynArray Set dArray = New UniDynArray 10: dArray.Value(1,1) = Some String 40: dArray.Value(2,1) = 50 70: dArray.Value(2,1) = dArray.Value(2,1) + 25 90: iNumber = dArray.Value(2,1) -- This is a silly example, but it illustrates the problem that I am experiencing. Then I run this in the design environment, it runs fine. When I create an .exe and run it, it bombs on line 90 with an Type Mismatch error (error 13). What am I doing wrong? Has anyone else experienced this? UniData 5.2 UniObjects 5.2 VB 6.0 SP5 uniobjects.dll (236KB) is version 3.1.3.1084 (product version 3.1.2) and is dated 12/11/2001 Thanks in advance. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] AE error
Thanks Wally, I've been wondering about this for YEARS! -Original Message- From: Wally Terhune [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 11:40 AM To: [EMAIL PROTECTED] Subject: {Virus?} Re: [U2] AE error Warning: This message has had one or more attachments removed Warning: (graycol.gif, pic07209.gif, ecblank.gif). Warning: Please read the VirusWarning.txt attachment(s) for more information. Check your VOC pointers and the physical directory or file they resolve to for AE_COMS and AE_SCRATCH. IIRC, AE_COMS is the culprit for this particular message. Wally Terhune Manager - U2 Advanced Technical Services IBM DB2 Information Management Software Tel: 303.294.4866 Fax: 303.294.4832 [EMAIL PROTECTED] www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online! Don't miss out on the IBM DB2 Information Management Technical Conference September 19-24, 2004 - Las Vegas, NV Less, Mirwaan (MIRW) [EMAIL PROTECTED] To aco.com [EMAIL PROTECTED] Sent by: cc [EMAIL PROTECTED] stserver.u2ug.org Subject [U2] AE error 05/04/2004 07:09 AM Please respond to u2-users Hi Does anyone know what the following error is and how it can be fixed: In /usr/ud/sys/CTLG/a/AE at line 1181 File is readonly, permission denied In /usr/ud/sys/CTLG/a/AE at line 1181 Fatal error: WRITE error We upgraded from AIX 4.3.2 to AIX 4.3.3 and Unidata 4.1.24 to Unidata 5.2.21 and after that I'm expierencing the above error. I can still edit programs as per normal, just the message that I don't like. We cannot find AE_DOC anywhere on the system. Regards, Mirwaan --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users This is a message from the MailScanner E-Mail Virus Protection Service -- The original e-mail attachment graycol.gif is on the list of unacceptable attachments for this site and has been replaced by this warning message. If you wish to receive a copy of the original attachment, please e-mail helpdesk and include the whole of this message in your request. Alternatively, you can call them, with the contents of this message to hand when you call. At Tue May 4 08:58:30 2004 the virus scanner said: (graycol.gif) Note to Help Desk: Look on the MailScanner in /var/spool/MailScanner/quarantine/20040504 (message i44FwPP23219). -- Postmaster This is a message from the MailScanner E-Mail Virus Protection Service -- The original e-mail attachment pic07209.gif is on the list of unacceptable attachments for this site and has been replaced by this warning message. If you wish to receive a copy of the original attachment, please e-mail helpdesk and include the whole of this message in your request. Alternatively, you can call them, with the contents of this message to hand when you call. At Tue May 4 08:58:31 2004 the virus scanner said: (pic07209.gif) Note to Help Desk: Look on the MailScanner in /var/spool/MailScanner/quarantine/20040504 (message i44FwPP23219). -- Postmaster This is a message from the MailScanner E-Mail Virus Protection Service -- The original e-mail attachment ecblank.gif is on the list of unacceptable attachments for this site and has been replaced by this warning message. If you wish to receive a copy of the original attachment, please e-mail helpdesk and include the whole of this message in your request. Alternatively, you can call them, with the contents of this message to hand when you call. At Tue May 4 08:58:31 2004 the virus scanner said: (ecblank.gif) Note to Help Desk: Look on the MailScanner in /var/spool/MailScanner/quarantine/20040504 (message i44FwPP23219). -- Postmaster --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
[U2] RE: [UD] Union Query
Unidata's MERGE.LIST is only half of the solution. the sql prompt looks like the other half. Is there a way to pass an active list to thesql statement? Thanks. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -Original Message-From: Wally Terhune [mailto:[EMAIL PROTECTED]Sent: Monday, May 03, 2004 9:40 AMTo: [EMAIL PROTECTED]Subject: {Virus?} Re: [U2] RE: Memo: RE: [UD] Union Query Warning: This message has had one or more attachments removed (graycol.gif, ecblank.gif, pic00981.gif). Please read the "VirusWarning.txt" attachment(s) for more information. I didn't follow this email thread, but (if it applies) wanted to point out that UniData does have a MERGE.LIST command that allows you to manipulate two active select lists into a third list with different options.Wally TerhuneManager - U2 Advanced Technical ServicesIBM DB2 Information Management SoftwareTel: 303.294.4866 Fax: 303.294.4832 [EMAIL PROTECTED] www.ibm.com/software/data/u2/support - Open, Query, Update, Search - Online!Don't miss out on the IBM DB2 Information Management Technical ConferenceSeptember 19-24, 2004 - Las Vegas, NV[EMAIL PROTECTED] [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/03/2004 06:48 AM Please respond tou2-users To [EMAIL PROTECTED] cc Subject [U2] RE: Memo: RE: [UD] Union Query No, UniData doesn't allow you to combine lists like this. One of the few things I miss from D3. -- Colin Alfke Calgary, Alberta Canada "Just because something isn't broken doesn't mean that you can't fix it" Stu Pickles -Original Message- From: Mark Johnson [mailto:[EMAIL PROTECTED]] Sent: Friday, April 30, 2004 9:37 PM To: U2 Users Discussion List Subject: Re: Memo: RE: [UD] Union Query My 2 cents on this topic and maybe it'll trigger a UD/UV response. D3 allows you to GET-LIST A-LIST B-LIST and you get them combined for your next process.