RE: [U2] Wintegrate Query Builder
Here are 2 dicts I created for the CUSTOMER file in the DEMO account. I didn't try them with ODBC though. They both work with the CATEGORIES_LIKED field in 9 of the CUSTOMER file. :AE DICT CUSTOMER ALL_CATEGORIES CL_POS CATLINK This one puts everything in one blob with the MV lines now separated with spaces. 1 Top of ALL_CATEGORIES in DICT CUSTOMER, 6 lines, 61 characters.001: I002: EXTRACT(@RECORD,9,0,0);CONVERT(@VM, ,@1);TRIM(@2) 003:004:005: 40L006: SBottom.Parts 2 and 3 of this one may fall into the category of belt and suspenders but make me feel better when passing them through ODBC. This is how to create a line number for the MV lines. 2 Top of CL_POS in DICT CUSTOMER, 7 lines, 51 characters.001: I002: EXTRACT(@RECORD,9,0,0);@NV003:004: mv line005: 5R006: MV007: CATLINKBottom. 3 Top of CATLINK in DICT CUSTOMER, 2 lines, 26 characters.001: PH002: CATEGORIES_LIKED CL_POSBottom. hth Colin Alfke Calgary Canada From: Bruce Hi Colin, Your idea sounds like it would fix my problem. You can either create an associated I-desc that has the mv position Can you show me an example? I have built some simple I-desc's, but I'm pretty weak at it. or use a dict that combines all of the MV's into one block. This would be great, again, can you show me an example? Thank, BruceI have some notes that are stored in a MV field. My application, (Dataflo) keeps the lines in order. However, I use Wintegrate Query Builder to export them.I have found that the notes don't necessarily come out in the proper sequence.For example:I am going to The park today And then I Will go homeMight look like this:And then I I am going to Will go home The park todayIs there a way to keep a note in the right sequence? _ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD: Unidata Help Function
It works fine on my 7.1.6 and 7.2.0. Any error messages? VOC entries for HELP or HELP.FILE invalid? (HELP is globally catalogues and HELP.FILE is in the sys sub-directory). hth Colin Alfke Calgary, Canada From: David_Wademan In the past that we can used HELP at the colon prompt to get information about UniQuery or UniBASIC functions. Once we switch over from 6.x to 7.1.8 and now we lost the HELP function. Any ideas why this happen or this is something that Unidata is doing? David Wademan _ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] .net uniobjects error 39204
The slave referred to here is the process that needs to log in to do the work. When you connect via uvcs (which you do from UniObjects to UniVerse) the listener is unirpcd (or uvrpcd on older versions), listening on port #31438 (by default). A request to connect has unirpcd consult its services file (unirpcservices) for the name of the service that you have requested (that is, uvcs, the UniVerse common server), checks from the services file that your IP address is eligible to request that service and, if so, starts an instance of the associated executable, in this case uvapi_server. The uvapi_server is then your connection's agent process on the server, looking after such things as maintaining communications, monitoring the inactivity timeout interval, and so on. When some work needs to be done, such as executing a query, a child process uvapi_slave is logged in to do the actual work. Its stdout and stderr are redirected back to its parent (uvapi_server) so that the results may be returned to the client. It is this slave process that has failed to start correctly. Many reasons exist why this might be so. The most common, in my experience, is that there is no clean path to TCL - that is, the LOGIN process in the account puts unexpected text on stdout. All uvcs processes must be guaranteed a clean path to TCL. You can test @TTY = uvcs in the LOGIN paragraph in a similar way that you might test @TTY = phantom to bypass application startup for PHANTOM processes. (This might not be your actual problem, of course, and I'm not suggesting that it is, but it's something that's definitely worth investigating.) - Original Message - From: Clifton Oliver [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Subject: Re: [U2] .net uniobjects error 39204 Date: Thu, 18 Sep 2008 16:19:26 -0700 Here's the error. I got this from the UniDK/include/Uvoaif file. UVE_SR_SLAVE_EXEC_FAIL = 39204' The slave failed to start correctly Unfortunately, just as an out of context error message, I don't know what it means. Maybe someone else can pick it up from here. Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [ud] Unidata 7.1 and Crystal Reports 10
Hello, I wonder if anyone is using the above combination. We've found that since moving to unidata 7.1 from 6.1 that it's no longer possible to set up new reports or run (using the lightening bolt) existing reports within the Crystal Reports application - both fail with an unhandled exception in crw32.exe, although the underlying fault occurs in C:\WINDOWS\system32\udtodbc.dll at 0xC005 with an access exception. This is affecting all the machines we have set up this way. Accessing the same odbc data using excel works fine, so it does look like a crystal problem... Edward - -- Please remember to recycle wherever possible. Reduce, reuse, recycle, think do you need to print this e-mail? - -- This e-mail and any attachment(s), is confidential and may be legally privileged. It is intended solely for the addressee. If you are not the addressee, dissemination, copying or use of this e-mail or any of its content is prohibited and may be unlawful. If you are not the intended recipient please inform the sender immediately and destroy the e-mail, any attachment(s) and any copies. All liability for viruses is excluded to the fullest extent permitted by law. It is your responsibility to scan or otherwise check this email and any attachment(s). Unless otherwise stated (i) views expressed in this message are those of the individual sender (ii) no contract may be construed by this e-mail. Emails may be monitored and you are taken to consent to this monitoring. Civica Services Limited, Company No. 02374268; Civica UK Limited, Company No. 01628868 Both companies are registered in England and Wales and each has its registered office at 2 Burston Road, Putney, London, SW15 6AR. - -- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD: Unidata Help Function
These are my pointer in the VOC file: :AE VOC HELP.FILE Top of HELP.FILE in VOC, 3 lines, 49 characters. 001: F 002: @UDTHOME/sys/HELP.FILE 003: @UDTHOME/sys/D_HELP.FILE Bottom. :LIST HELP.FILE ID.SUP @ID FMT 40L LIST HELP.FILE ID.SUP @ID FMT 40L 09:03:57 Sep 19 2008 1 HELP.FILE... UNIBASIC*INPUTNULL UNIBASIC*INT UNIBASIC*READXBCK UNIBASIC*SUBSTRINGS UNIBASIC*XDOMGETNODENAME UNIBASIC*ADDCERTIFICATE UNIBASIC*BITAND UNIBASIC*CHARLEN UNIDATA*LO :AE VOC HELP Top of New HELP in VOC. Top of empty record. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Colin Alfke Sent: Friday, September 19, 2008 2:20 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD: Unidata Help Function It works fine on my 7.1.6 and 7.2.0. Any error messages? VOC entries for HELP or HELP.FILE invalid? (HELP is globally catalogues and HELP.FILE is in the sys sub-directory). hth Colin Alfke Calgary, Canada From: David_Wademan In the past that we can used HELP at the colon prompt to get information about UniQuery or UniBASIC functions. Once we switch over from 6.x to 7.1.8 and now we lost the HELP function. Any ideas why this happen or this is something that Unidata is doing? David Wademan _ --- 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] Wintegrate Query Builder
I also meant to add that you could have a dict per line: 002: EXTRACT(@RECORD,9,1,0) 002: EXTRACT(@RECORD,9,2,0) 002: EXTRACT(@RECORD,9,3,0) Etc Hth Colin Alfke Calgary, Canada -Original Message- From: Colin Alfke Here are 2 dicts I created for the CUSTOMER file in the DEMO account. I didn't try them with ODBC though. They both work with the CATEGORIES_LIKED field in 9 of the CUSTOMER file. :AE DICT CUSTOMER ALL_CATEGORIES CL_POS CATLINK This one puts everything in one blob with the MV lines now separated with spaces. 1 Top of ALL_CATEGORIES in DICT CUSTOMER, 6 lines, 61 characters.001: I002: EXTRACT(@RECORD,9,0,0);CONVERT(@VM, ,@1);TRIM(@2) 003:004:005: 40L006: SBottom.Parts 2 and 3 of this one may fall into the category of belt and suspenders but make me feel better when passing them through ODBC. This is how to create a line number for the MV lines. 2 Top of CL_POS in DICT CUSTOMER, 7 lines, 51 characters.001: I002: EXTRACT(@RECORD,9,0,0);@NV003:004: mv line005: 5R006: MV007: CATLINKBottom. 3 Top of CATLINK in DICT CUSTOMER, 2 lines, 26 characters.001: PH002: CATEGORIES_LIKED CL_POSBottom. hth Colin Alfke Calgary Canada From: Bruce Hi Colin, Your idea sounds like it would fix my problem. You can either create an associated I-desc that has the mv position Can you show me an example? I have built some simple I-desc's, but I'm pretty weak at it. or use a dict that combines all of the MV's into one block. This would be great, again, can you show me an example? Thank, Bruce I have some notes that are stored in a MV field. My application, (Dataflo) keeps the lines in order. However, I use Wintegrate Query Builder to export them.I have found that the notes don't necessarily come out in the proper sequence.For example:I am going to The park today And then I Will go homeMight look like this: And then I I am going to Will go home The park todayIs there a way to keep a note in the right sequence? _ --- 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] Crystal Reports and UniData
David, I think you have the emphasis on the wrong party here. IBM U2 is the database not the reporting tool. I don't think it is IBM's responsibility to try and comply with a tool, any tool, it is the other way around. Since CR is suppose to talk to a database and get the information from a database it is their responsibility to try and comply with it. If they don't want to, then they are not the tool you want to use. Find one that will. It is IBM U2's responsibility to comply with the operating systems that are available and to provide standardized access to the database. Do you think Microsoft tries to make SQL Server compliant with CR? Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Thursday, September 18, 2008 11:37 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Crystal Reports and UniData Yup - I received your email -- And I'm glad this is moving up the chain. The bigger question to the User Group -- Are there 3rd party products that we as vendors and users **need** IBM to ensure work at some base level? Are there 'natural use' products that IBM really does need to test and assure a base-level of compliance with?? Today, IBM certifies that UniData works on Windows, and several versions of Unix and Linux -- and that if U2 does not work with those products, it would be a 'tier one' issue to resolve. In a very short period of time, it appears any new client we get will be expecting that same 'Tier one' support for Crystal Reports, and we don't have a mechanism to ensure that support. Are there products like these that are 'add ons', but essentially 'core' or 'natural use' extensions that need to be tested in the same way the O/Ss are tested?? David W. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Peters Sent: Thursday, September 18, 2008 5:39 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: Re: [U2] [UD] Crystal Reports and UniData I wanted to send a note on this much earlier, but have been tied up until now. We can't certify that other solutions, such as C.R., will work with our products, but we really do want them to work. It sort of makes sense that we would, because if our customers can't succeed with their solutions, neither will we. --- 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: Unidata Help Function
That's the same as mine. Does HELP exist in @UDTHOME/sys/ctlg/h? What happens when you try to use HELP? Hth Colin Alfke Calgary, Canada -Original Message- From: DAVID WADEMAN These are my pointer in the VOC file: :AE VOC HELP.FILE Top of HELP.FILE in VOC, 3 lines, 49 characters. 001: F 002: @UDTHOME/sys/HELP.FILE 003: @UDTHOME/sys/D_HELP.FILE Bottom. [SNIP] :AE VOC HELP Top of New HELP in VOC. Top of empty record. -Original Message- From: Colin Alfke It works fine on my 7.1.6 and 7.2.0. Any error messages? VOC entries for HELP or HELP.FILE invalid? (HELP is globally catalogues and HELP.FILE is in the sys sub-directory). hth Colin Alfke Calgary, Canada From: David_Wademan In the past that we can used HELP at the colon prompt to get information about UniQuery or UniBASIC functions. Once we switch over from 6.x to 7.1.8 and now we lost the HELP function. Any ideas why this happen or this is something that Unidata is doing? David Wademan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Crystal Reports and UniData
There is, unfortunately, a question of market power here. If Access and SQL-Server talk to each other, even if they use a *broken* version of SQL to do so, the market place will expect other databases and clients to talk the same - BROKEN - dialect of SQL. It's all very well a vendor (like IBM, for example) saying we comply with the standard, but if the official and the de-facto standards don't agree, then the smaller vendors (and here I include U2) are likely to get trampled. Like it or not, IBM should treat any problems with a market-influential tool like CR as high priority, even if it is CR that's at fault. In an ideal world, if IBM said CR is broken, and here's how, it would result in CR getting fixed. In the world we live in, CR can probably get away with saying tough, on yer bike, mate. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jpb-u2ug Sent: 19 September 2008 14:50 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData David, I think you have the emphasis on the wrong party here. IBM U2 is the database not the reporting tool. I don't think it is IBM's responsibility to try and comply with a tool, any tool, it is the other way around. Since CR is suppose to talk to a database and get the information from a database it is their responsibility to try and comply with it. If they don't want to, then they are not the tool you want to use. Find one that will. It is IBM U2's responsibility to comply with the operating systems that are available and to provide standardized access to the database. Do you think Microsoft tries to make SQL Server compliant with CR? Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Thursday, September 18, 2008 11:37 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Crystal Reports and UniData Yup - I received your email -- And I'm glad this is moving up the chain. The bigger question to the User Group -- Are there 3rd party products that we as vendors and users **need** IBM to ensure work at some base level? Are there 'natural use' products that IBM really does need to test and assure a base-level of compliance with?? Today, IBM certifies that UniData works on Windows, and several versions of Unix and Linux -- and that if U2 does not work with those products, it would be a 'tier one' issue to resolve. In a very short period of time, it appears any new client we get will be expecting that same 'Tier one' support for Crystal Reports, and we don't have a mechanism to ensure that support. Are there products like these that are 'add ons', but essentially 'core' or 'natural use' extensions that need to be tested in the same way the O/Ss are tested?? David W. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Peters Sent: Thursday, September 18, 2008 5:39 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: Re: [U2] [UD] Crystal Reports and UniData I wanted to send a note on this much earlier, but have been tied up until now. We can't certify that other solutions, such as C.R., will work with our products, but we really do want them to work. It sort of makes sense that we would, because if our customers can't succeed with their solutions, neither will we. --- 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] SOAP over HTTPS
Thanks :-) The UD 6.1 docs don't contain any reference to SOAPCreateSecureRequest, but it does work. Larry Hiscock Western Computer Services -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Janet Cedervall Sent: Tuesday, September 16, 2008 8:08 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] SOAP over HTTPS Yes, there's a SOAPCreateSecureRequest that works. Or at least the person who wrote the code below claims it works. I can't help you with specifics, as someone else wrote it. This was written for UniVerse. (I started on these SOAP calls for some QualComm webservices last week, and haven't had much luck with my code yet!) URL = https://truck-pc.net/WebServices/v1.1.7/DriverTechService.asmx?/WSDL; SOAPAction = https://truck-pc.net/WebServices/v1.1.7/GetReport; * CREATE SECURITY CONTEXT RCODE = createSecurityContext(ctx, ) IF RCODE=0 THEN CRT 'createSecurityContext OK' END ELSE STOP 'ERROR - createSecurityContext - ':RCODE END * Add authentication rule RETURN = addAuthenticationRule(ctx, 2, VerificationStrength, generous) RETURN = addAuthenticationRule(ctx, 2, PeerName, truck-pc.net) * CREATE SOAP REQUEST HANDLE RCODE=SOAPCreateSecureRequest(URL,SOAPAction,SoapReq,ctx) IF RCODE=0 THEN CRT 'SOAPCreateSecureRequest OK' END ELSE STOP 'ERROR - SOAPCreateSecureRequest - ':RCODE END - Janet Mission Petroleum Carriers -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Hiscock Sent: Tuesday, September 16, 2008 2:14 PM To: u2-users@listserver.u2ug.org Subject: [U2] SOAP over HTTPS Has anyone implemented the UniData SOAP functions over an HTTPS URL? The CALLHTTP stuff, on which the SOAP stuff is built, has an option for creating a secure request, but the soapcreaterequest function doesn't seem to have the equivalent. Is there such a beast, or do I need to revert to the lower level callhttp protocols? FWIW, I'm on UniData 6.1, and writing a webservice CONSUMER ... TIA Larry Hiscock Western Computer Services --- 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] [UD] Crystal Reports and UniData
No, but they do conform to an SQL standard... Just like Oracle, mySQL, etc. IF IBM is going to publish an ODBC driver, it should be SQL compliant. (At least behave the same as any other ODBC driver would minus the VSG crap) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jpb-u2ug Sent: Friday, September 19, 2008 9:50 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData David, I think you have the emphasis on the wrong party here. IBM U2 is the database not the reporting tool. I don't think it is IBM's responsibility to try and comply with a tool, any tool, it is the other way around. Since CR is suppose to talk to a database and get the information from a database it is their responsibility to try and comply with it. If they don't want to, then they are not the tool you want to use. Find one that will. It is IBM U2's responsibility to comply with the operating systems that are available and to provide standardized access to the database. Do you think Microsoft tries to make SQL Server compliant with CR? Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Thursday, September 18, 2008 11:37 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Crystal Reports and UniData Yup - I received your email -- And I'm glad this is moving up the chain. The bigger question to the User Group -- Are there 3rd party products that we as vendors and users **need** IBM to ensure work at some base level? Are there 'natural use' products that IBM really does need to test and assure a base-level of compliance with?? Today, IBM certifies that UniData works on Windows, and several versions of Unix and Linux -- and that if U2 does not work with those products, it would be a 'tier one' issue to resolve. In a very short period of time, it appears any new client we get will be expecting that same 'Tier one' support for Crystal Reports, and we don't have a mechanism to ensure that support. Are there products like these that are 'add ons', but essentially 'core' or 'natural use' extensions that need to be tested in the same way the O/Ss are tested?? David W. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Peters Sent: Thursday, September 18, 2008 5:39 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: Re: [U2] [UD] Crystal Reports and UniData I wanted to send a note on this much earlier, but have been tied up until now. We can't certify that other solutions, such as C.R., will work with our products, but we really do want them to work. It sort of makes sense that we would, because if our customers can't succeed with their solutions, neither will we. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Dictionary Item Problem
Receiving a blink error when SSELECTing BY an I-descriptor that calls a subroutine, which uses COMMONed files that don't seem to be OPEN. Back in the olden days, if you had more errors than the system could process/display, it would result in a backward link or crossing frame limit error. Do you think this might be the same kind of thing? Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PER SON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PER SON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PER SON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PER SON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. File '/train/jud/cj/PERSONS/SEC': Computed blink of 0x3B9400 does not match expected blink of 0x3B9000! Detected within group starting at address 0x3B9000! Program CJ.READ.PERSON: Line 39, Internal data error. Line 31 is a read This is the dictionary item: 0001: I 0002: IF CASE.PERSON.ID # THEN SUBR(CJ.READ.PERSON,CASE.PERSON.ID,1,) E LSE 0003: S;*;*** No Defendant *** 0004: Defendant 0005: 30L 0006: S CASE.PERSON.ID is a regular attribute descriptor type dictionary item. Do you have any suggestions? Karen Bessel Software Developer Tyler Technologies, Inc. 6500 International Parkway, Suite 2000 Plano, TX 75093 Phone: 972.713.3770 ext:6227 Fax: 972.713.3777 Email: [EMAIL PROTECTED] Web: http://www.tylertech.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UD] Crystal Reports and UniData
Aye, matey, and since it is th' 13th annual International Talk Like a Pirate Day, http://www.talklikeapirate.com/we can say Shiver me timbers, and I'll stick wit' a LIST statem'nt! http://www.talklikeapirate.com/ On Fri, Sep 19, 2008 at 7:13 AM, Anthony Youngman [EMAIL PROTECTED]wrote: There is, unfortunately, a question of market power here. . In the world we live in, CR can probably get away with saying tough, on yer bike, mate. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] .net uniobjects error 39204
Now why couldn't the manuals have said that? laughing Great explanation, Ray. Thank you very much. Regards, Clif On Sep 19, 2008, at 12:57 AM, Ray Wurlod wrote: The slave referred to here is the process that needs to log in to do the work. When you connect via uvcs (which you do from UniObjects to UniVerse) the listener is unirpcd (or uvrpcd on older versions), listening on port #31438 (by default). A request to connect has unirpcd consult its services file (unirpcservices) for the name of the service that you have requested (that is, uvcs, the UniVerse common server), checks from the services file that your IP address is eligible to request that service and, if so, starts an instance of the associated executable, in this case uvapi_server. The uvapi_server is then your connection's agent process on the server, looking after such things as maintaining communications, monitoring the inactivity timeout interval, and so on. When some work needs to be done, such as executing a query, a child process uvapi_slave is logged in to do the actual work. Its stdout and stderr are redirected back to its parent (uvapi_server) so that the results may be returned to the client. It is this slave process that has failed to start correctly. Many reasons exist why this might be so. The most common, in my experience, is that there is no clean path to TCL - that is, the LOGIN process in the account puts unexpected text on stdout. All uvcs processes must be guaranteed a clean path to TCL. You can test @TTY = uvcs in the LOGIN paragraph in a similar way that you might test @TTY = phantom to bypass application startup for PHANTOM processes. (This might not be your actual problem, of course, and I'm not suggesting that it is, but it's something that's definitely worth investigating.) - Original Message - From: Clifton Oliver [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Subject: Re: [U2] .net uniobjects error 39204 Date: Thu, 18 Sep 2008 16:19:26 -0700 Here's the error. I got this from the UniDK/include/Uvoaif file. UVE_SR_SLAVE_EXEC_FAIL = 39204' The slave failed to start correctly Unfortunately, just as an out of context error message, I don't know what it means. Maybe someone else can pick it up from here. Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.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/
[U2] FW: Dictionary Item Problem
Some more info Along with the errors I sent in the earlier email, I'm occasionally seeing [EBADF] Bad file number The file that is being read on line 31 of this subroutine (where the read operation failure is being generated) is a q-pointer. The file is a multi-level/directory file with a few sections - it is a type 3, which I have never seen before. When I select or count this file in the account where the file lives, I get no errors, which leads me to believe that it is not a data issue. The file that is being selected when this error is produced is also a q-pointer to a file in the other (same) account. This is a plain hashed file. From: Bessel, Karen Sent: Friday, September 19, 2008 1:36 PM To: 'u2-users@listserver.u2ug.org' Subject: Dictionary Item Problem Receiving a blink error when SSELECTing BY an I-descriptor that calls a subroutine, which uses COMMONed files that don't seem to be OPEN. Back in the olden days, if you had more errors than the system could process/display, it would result in a backward link or crossing frame limit error. Do you think this might be the same kind of thing? Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PER SON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PER SON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PER SON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PER SON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. File '/train/jud/cj/PERSONS/SEC': Computed blink of 0x3B9400 does not match expected blink of 0x3B9000! Detected within group starting at address 0x3B9000! Program CJ.READ.PERSON: Line 39, Internal data error. Line 31 is a read This is the dictionary item: 0001: I 0002: IF CASE.PERSON.ID # THEN SUBR(CJ.READ.PERSON,CASE.PERSON.ID,1,) E LSE 0003: S;*;*** No Defendant *** 0004: Defendant 0005: 30L 0006: S CASE.PERSON.ID is a regular attribute descriptor type dictionary item. Do you have any suggestions? Karen Bessel Software Developer Tyler Technologies, Inc. 6500 International Parkway, Suite 2000 Plano, TX 75093 Phone: 972.713.3770 ext:6227 Fax: 972.713.3777 Email: [EMAIL PROTECTED] Web: http://www.tylertech.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Progress Counter for Universe SELECT
D3 allows you to use a (T option at the end of a SELECT statement. This will display a progress counter during the select. Is there a way to do this in Universe? See example below from D3. :SELECT DEBTOR (T Selected Processed Total Completed 6623 6623 7205580 0% We are converting from D3 to Universe and our users really like this D3 feature. -- View this message in context: http://www.nabble.com/Progress-Counter-for-Universe-SELECT-tp19576689p19576689.html Sent from the U2 - Users mailing list archive at Nabble.com. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Crystal Reports and UniData
Hu, IBM doesn't have market power? Maybe someone should tell them. On the Fortune 500 IBM is 15 and Microsoft is 44. Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Friday, September 19, 2008 9:14 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UD] Crystal Reports and UniData There is, unfortunately, a question of market power here. If Access and SQL-Server talk to each other, even if they use a *broken* version of SQL to do so, the market place will expect other databases and clients to talk the same - BROKEN - dialect of SQL. It's all very well a vendor (like IBM, for example) saying we comply with the standard, but if the official and the de-facto standards don't agree, then the smaller vendors (and here I include U2) are likely to get trampled. Like it or not, IBM should treat any problems with a market-influential tool like CR as high priority, even if it is CR that's at fault. In an ideal world, if IBM said CR is broken, and here's how, it would result in CR getting fixed. In the world we live in, CR can probably get away with saying tough, on yer bike, mate. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jpb-u2ug Sent: 19 September 2008 14:50 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData David, I think you have the emphasis on the wrong party here. IBM U2 is the database not the reporting tool. I don't think it is IBM's responsibility to try and comply with a tool, any tool, it is the other way around. Since CR is suppose to talk to a database and get the information from a database it is their responsibility to try and comply with it. If they don't want to, then they are not the tool you want to use. Find one that will. It is IBM U2's responsibility to comply with the operating systems that are available and to provide standardized access to the database. Do you think Microsoft tries to make SQL Server compliant with CR? Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Thursday, September 18, 2008 11:37 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Crystal Reports and UniData Yup - I received your email -- And I'm glad this is moving up the chain. The bigger question to the User Group -- Are there 3rd party products that we as vendors and users **need** IBM to ensure work at some base level? Are there 'natural use' products that IBM really does need to test and assure a base-level of compliance with?? Today, IBM certifies that UniData works on Windows, and several versions of Unix and Linux -- and that if U2 does not work with those products, it would be a 'tier one' issue to resolve. In a very short period of time, it appears any new client we get will be expecting that same 'Tier one' support for Crystal Reports, and we don't have a mechanism to ensure that support. Are there products like these that are 'add ons', but essentially 'core' or 'natural use' extensions that need to be tested in the same way the O/Ss are tested?? David W. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Peters Sent: Thursday, September 18, 2008 5:39 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: Re: [U2] [UD] Crystal Reports and UniData I wanted to send a note on this much earlier, but have been tied up until now. We can't certify that other solutions, such as C.R., will work with our products, but we really do want them to work. It sort of makes sense that we would, because if our customers can't succeed with their solutions, neither will we. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] FW: Dictionary Item Problem
If I list the file using this dictionary item, the data comes out fine. If I then do a SSELECT of the file BY that dictionary item, I get the errors...usually after a couple of minutes of thinking. After the SSELECT errors, if I repeat the LIST, I get the following. I replaced the defendant names with the word Name in the listing (name actually was displayed). Despite the errors, the program is reading the information from the file. I R confused. LIST DA.CASES DEFENDANT 04:04:07pm 19 Sep 2008 PAGE1 DA.CASES Defendant. Program CJ.READ.PERSON: Line 31, Read operation failure. [EBADF] Bad file num ber 115758 *** No Defendant *** 57879 *** No Defendant *** 173637 Name 115759 Name 57880 Name Program CJ.READ.PERSON: Line 31, Read operation failure. [EBADF] Bad file num ber 173638 *** No Defendant *** Program CJ.READ.PERSON: Line 31, Read operation failure. [EBADF] Bad file num ber 115760 *** No Defendant *** 57881 *** No Defendant *** 173639 Name From: Bessel, Karen Sent: Friday, September 19, 2008 2:27 PM To: 'u2-users@listserver.u2ug.org' Subject: FW: Dictionary Item Problem Some more info Along with the errors I sent in the earlier email, I'm occasionally seeing [EBADF] Bad file number The file that is being read on line 31 of this subroutine (where the read operation failure is being generated) is a q-pointer. The file is a multi-level/directory file with a few sections - it is a type 3, which I have never seen before. When I select or count this file in the account where the file lives, I get no errors, which leads me to believe that it is not a data issue. The file that is being selected when this error is produced is also a q-pointer to a file in the other (same) account. This is a plain hashed file. From: Bessel, Karen Sent: Friday, September 19, 2008 1:36 PM To: 'u2-users@listserver.u2ug.org' Subject: Dictionary Item Problem Receiving a blink error when SSELECTing BY an I-descriptor that calls a subroutine, which uses COMMONed files that don't seem to be OPEN. Back in the olden days, if you had more errors than the system could process/display, it would result in a backward link or crossing frame limit error. Do you think this might be the same kind of thing? Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PER SON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PER SON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PER SON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PER SON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. Program CJ.READ.PERSON: Line 31, Read operation failure. File '/train/jud/cj/PERSONS/SEC': Computed blink of 0x3B9400 does not match expected blink of 0x3B9000! Detected within group starting at address 0x3B9000! Program CJ.READ.PERSON: Line 39, Internal data error. Line 31 is a read This is the dictionary item: 0001: I 0002: IF CASE.PERSON.ID # THEN SUBR(CJ.READ.PERSON,CASE.PERSON.ID,1,) E LSE 0003: S;*;*** No Defendant *** 0004: Defendant 0005: 30L 0006: S CASE.PERSON.ID is a regular attribute descriptor type dictionary item. Do you have any suggestions? Karen Bessel Software Developer Tyler Technologies, Inc. 6500 International Parkway, Suite 2000 Plano, TX 75093 Phone: 972.713.3770 ext:6227 Fax: 972.713.3777 Email: [EMAIL PROTECTED] Web: http://www.tylertech.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Crystal Reports and UniData
LOL! I think he was speaking of the U2 Market Power vs Crystal Reports Market Power... If I pop my head into a random IT shop in the country and threw out both product names -- which one do you think they would immediately guess is a musical group as opposed to a software product?? g That's why I hope that the U2 group as the IBM U2 Group can either address the issue internally with a fix to OLE-DB provider, or push some of the IBM weight behind U2 and get Crystal Reports to make a change. Either works for me!! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jpb-u2ug Sent: Friday, September 19, 2008 4:16 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData Hu, IBM doesn't have market power? Maybe someone should tell them. On the Fortune 500 IBM is 15 and Microsoft is 44. Jerry Banker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Crystal Reports and UniData
From: Jerry Banker Hu, IBM doesn't have market power? Maybe someone should tell them. On the Fortune 500 IBM is 15 and Microsoft is 44. (Dead topic for this group?) Despite claims and efforts, U2 is not IBM, where DB2 is. IBM's honorable influence doesn't drive all vendors for every bit of software related to the company. If the U2 SQL server process doesn't process queries like a relational DBMS then who fixes the issue becomes a matter of sheer numbers and ROI, not a matter of we don't comply with IBM therefore we need to make a change. How many U2 sites purchase Crystal Reports and interface them to their U2 platforms? Unfortunately I'm sure there are very few. So CR as a company has no incentive to modify their well-established product to suit an obscure minority. If someone told CR that U2 users have other venues (for fee or low cost) to use their products, I'm sure they would find their cost of a code change is even more unjustified. IBM is only somewhat motivated to investigate the issue and make changes. Customer satisfaction would probably be the biggest drive here - not any mass of U2 users all seeking to use CR. If this were purely a CR issue it would probably be way low on the priority list. But it is in their interest to at least identify what it is in the CR queries that they can't process, and fixing that problem for CR should fix it for other client apps as well. T --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Progress Counter for Universe SELECT
It's not going to happen. UniVerse SELECT often doesn't select at all (particularly with Type 30 files, for which there is a count of active SELECTs kept in shared memory), but merely opens a cursor at the beginning of the file. It's the READNEXT that moves the cursor through the file (unless something intervenes that would require the SELECT to complete, such as an update of some kind to the file). --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] FW: Dictionary Item Problem
I think it's time to verify this file with fixtool or uvfixfile. Your LIST may have been lucky and not encountered the problem (corrupted?) group buffer. SSELECT, of course, must perforce attempt to process the entire file. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] I need a correlative, just like the correlative...
Just about every vendor that I've seen implement this has done it slightly different. This is how you do it in mvbase - from my How To folder: If you have the manual for your version, start looking through the section on Dictionary types! How to write basic subr DICT items in MvBase LASTVALUE 001 SUBROUTINE LASTVALUE 002 $INCLUDE BASICLIB ACCESS.COMMON 003 ANSWER = CURRENT$1,DCOUNT(CURRENT$,@VM) 004 RETURN ANSWER LAST.QTY 001 A 002 12 003 004 005 006 007 008 B:BP LASTVALUE 009 R 010 10 Dick Pick used to have a challenge for anyone to write a dictionary that would allow printing the last value of a MV field (as I did above with a SUBR). I figured a way to do it with A correlatives and wrote to him. He wrote back and said the challenge was to use F correlatives, and even though I had figured out a way, I didn't win the CIGAR. He also thanked me and told me he was going to tell everyone he knew that there was now a way. It took three dicts: one to do a boolean comparison to value mark (leaves a 1 for every value mark found) the second to do a summation of previous step + 1 the third to do a index of the previous step on the attr to arrive at the last value of the attr Now it's a piece of cake to do in just about any version with all the additions that have been done. But back in 1988 it was a *little* harder! hth, Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jeff Schasny Sent: Wednesday, September 17, 2008 07:01 To: u2-users@listserver.u2ug.org Subject: Re: [U2] I need a correlative, just like the correlative... I don't know how to do that in a correlative i.e. Pick/SMA style dictionary entry. Any help would be appreciated. Allen E. Elwood wrote: Which is why I always just use a subr. The real cost to the client is the cost creation and maintenance. Subr's are just *so* easy to understand. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Progress Counter for Universe SELECT
This is possible on D3 because the number of items in a file kept in the FCB. To my knowledge no such count is kept anywhere for a Universe file. Note that D3 also has the estimate-count verb (typically renamed ecount by me for easier use), which returns the number of items in a file instantly. FYI, I ran down the user exit in that verb and created my own subroutine ecount.sub(filename,count) so that I can get the number of items in a file from inside a basic program and thus allow a basic select filevar... readnext id loop to display progress. I agree with your users, It is a great D3 feature. /Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 On Fri, Sep 19, 2008 at 1:33 PM, JeffG [EMAIL PROTECTED] wrote: D3 allows you to use a (T option at the end of a SELECT statement. This will display a progress counter during the select. Is there a way to do this in Universe? See example below from D3. :SELECT DEBTOR (T Selected Processed Total Completed 6623 6623 7205580 0% We are converting from D3 to Universe and our users really like this D3 feature. -- View this message in context: http://www.nabble.com/Progress-Counter-for-Universe-SELECT-tp19576689p19576689.html Sent from the U2 - Users mailing list archive at Nabble.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/
Re: [U2] Progress Counter for Universe SELECT
Enhancement request? In the case where SELECT does not select (see my earlier mail) a message to this effect might be emitted. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
