Re: [U2] Using DICT items in basic program
Hi, Can you tell me how can we crate a dict item to sort a specific multivalue. For eg a file name is CLIENT. And I want to list the CLIENT keys with 2nd multivalue of 2st field. i.e CLIENT Vaishali 1 2 Pune char(253)mumbai and when I list the result should appear like : Vaishali mumbai. Your help will be appriciated. Thanks, ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Using DICT items in basic program
If you are using UniData you can create an I-type dictionary. For the location (attribute 2 in the dictionary) put either EXTRACT(@RECORD,2,2,0) or, alternatively, if you already have a D-Type dictionary for the 2nd field (let us call it ADDRESS for arguments sake), you could put EXTRACT(ADDRESS,1,2,0) Now, if we called the above dictionary item 'CITY', you can get your required listing (sorted by CITY, ascending) by: LIST CLIENT CITY BY CITY If you are using UniVerse, this should be fairly similar. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Vaishali Patil Sent: Monday, 16 May 2011 4:04 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Using DICT items in basic program Hi, Can you tell me how can we crate a dict item to sort a specific multivalue. For eg a file name is CLIENT. And I want to list the CLIENT keys with 2nd multivalue of 2st field. i.e CLIENT Vaishali 1 2 Pune char(253)mumbai and when I list the result should appear like : Vaishali mumbai. Your help will be appriciated. Thanks, ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UVSQL CALL with MSSQL Openquery against linked UV server.
Hi, Just wondering if anyone has used the SQL CALL statement from MSSQL against a linked UV server and got it working. I have a linked server set up in MSSQL using UniOLEDB which works for most SQL queries. I now find I need to call a basic program to do some work to setup the result set I need. I have built and tested the program which does some updating and sets @hstmt using SQLExecDirect(). Using a simple third party OLEDB client (ADO Query Tool http://www.gpoulose.com/), the CALL to the program returns the expected row set. However, if I try the same query from within SSMS it bombs out with an error. Using ADO QueryTool: Works: CALL ZSELECT_CUST(1) Using MSSQL Management Studio: Works: select * from openquery(UVServer,'SELECT * FROM CUST SLIST QQQ') Doesn't work:select * from openquery(UVServer,'CALL ZSELECT_CUST(1)') And returns the error: Cannot get the column information from OLE DB provider IBM.UniOLEDB for linked server UVServer. The other possibility might be running as a 4 part exec - which also isn't working for me. Exec UVServer...[ZSELECT_CUST(1)] Which returns Msg 7411, Level 16, State 1, Line 1 Server 'UVServer' is not configured for RPC. In the meanwhile I can work around the issue by SELECTING from an I type which runs the setup program... but that's not what I would like to do. Anyone have any experience with getting this type of thing going? Cheers, Stuart Boydell ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UVSQL CALL with MSSQL Openquery against linked UV server.
Hi Stuart, I've used SQLExecDirect with UV before, we always allocate and prepare for each of the required parameter markers. Then call UV BASIC subroutines via SQLExecDirect. I would hazard a guess that QueryTool is doing a SQLExec and Transact-SQL pass-through is doing a SQLExecDirect. The later which requires the parameters to be pre-declared using SQLPrepare in order for the query result set to be returned successfully. You could test this by calling DATE using both tools and see what happens. As it has no parameters - I suspect both queries should work. Whereas, anything requiring parameters is likely to fail where the tool is using SQLExecDirect. Finally, is your ZSELECT_CUST a BASIC subroutine? Is it globally catalogued? If not, try cataloguing it as *ZSELECT_CUST and then call it like CALL *ZSELECT_CUST(1), etc. Hope this helps... :) Regards, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: Monday, 16 May 2011 5:48 PM To: U2 Users List Subject: [U2] UVSQL CALL with MSSQL Openquery against linked UV server. Hi, Just wondering if anyone has used the SQL CALL statement from MSSQL against a linked UV server and got it working. I have a linked server set up in MSSQL using UniOLEDB which works for most SQL queries. I now find I need to call a basic program to do some work to setup the result set I need. I have built and tested the program which does some updating and sets @hstmt using SQLExecDirect(). Using a simple third party OLEDB client (ADO Query Tool http://www.gpoulose.com/), the CALL to the program returns the expected row set. However, if I try the same query from within SSMS it bombs out with an error. Using ADO QueryTool: Works: CALL ZSELECT_CUST(1) Using MSSQL Management Studio: Works: select * from openquery(UVServer,'SELECT * FROM CUST SLIST QQQ') Doesn't work:select * from openquery(UVServer,'CALL ZSELECT_CUST(1)') And returns the error: Cannot get the column information from OLE DB provider IBM.UniOLEDB for linked server UVServer. The other possibility might be running as a 4 part exec - which also isn't working for me. Exec UVServer...[ZSELECT_CUST(1)] Which returns Msg 7411, Level 16, State 1, Line 1 Server 'UVServer' is not configured for RPC. In the meanwhile I can work around the issue by SELECTING from an I type which runs the setup program... but that's not what I would like to do. Anyone have any experience with getting this type of thing going? Cheers, Stuart Boydell ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UVSQL CALL with MSSQL Openquery against linked UV server.
Hi David, The CALL DATE syntax didn't work in SSMS. I tried global cataloguing *ZSELECT_CUST which also didn't work. Looks like SSMS is not playing nicely so I don't think I'll spend too much more time on this. Many thanks, Stuart -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Tuesday, 17 May 2011 11:44 To: 'U2 Users List' Subject: Re: [U2] UVSQL CALL with MSSQL Openquery against linked UV server. Hi Stuart, I've used SQLExecDirect with UV before, we always allocate and prepare for each of the required parameter markers. Then call UV BASIC subroutines via SQLExecDirect. I would hazard a guess that QueryTool is doing a SQLExec and Transact-SQL pass-through is doing a SQLExecDirect. The later which requires the parameters to be pre-declared using SQLPrepare in order for the query result set to be returned successfully. You could test this by calling DATE using both tools and see what happens. As it has no parameters - I suspect both queries should work. Whereas, anything requiring parameters is likely to fail where the tool is using SQLExecDirect. Finally, is your ZSELECT_CUST a BASIC subroutine? Is it globally catalogued? If not, try cataloguing it as *ZSELECT_CUST and then call it like CALL *ZSELECT_CUST(1), etc. Hope this helps... :) Regards, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: Monday, 16 May 2011 5:48 PM To: U2 Users List Subject: [U2] UVSQL CALL with MSSQL Openquery against linked UV server. Hi, Just wondering if anyone has used the SQL CALL statement from MSSQL against a linked UV server and got it working. I have a linked server set up in MSSQL using UniOLEDB which works for most SQL queries. I now find I need to call a basic program to do some work to setup the result set I need. I have built and tested the program which does some updating and sets @hstmt using SQLExecDirect(). Using a simple third party OLEDB client (ADO Query Tool http://www.gpoulose.com/), the CALL to the program returns the expected row set. However, if I try the same query from within SSMS it bombs out with an error. Using ADO QueryTool: Works: CALL ZSELECT_CUST(1) Using MSSQL Management Studio: Works: select * from openquery(UVServer,'SELECT * FROM CUST SLIST QQQ') Doesn't work:select * from openquery(UVServer,'CALL ZSELECT_CUST(1)') And returns the error: Cannot get the column information from OLE DB provider IBM.UniOLEDB for linked server UVServer. The other possibility might be running as a 4 part exec - which also isn't working for me. Exec UVServer...[ZSELECT_CUST(1)] Which returns Msg 7411, Level 16, State 1, Line 1 Server 'UVServer' is not configured for RPC. In the meanwhile I can work around the issue by SELECTING from an I type which runs the setup program... but that's not what I would like to do. Anyone have any experience with getting this type of thing going? Cheers, Stuart Boydell ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] XAdmin
Does the Eclipse-based XAdmin tool, provided by RS on the client CD, only work with UniData 7.2 and higher? I can't seem to connect to any UD v7.1 machines. Will I have to reinstall UniAdmin in order to access those machines? Thanks, Bill Haskett ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] XAdmin
I think so. I believe it's in the release notes. I was trying to get it to connect to a 7.1 windows machine but kept getting a message about an invalid account. I found a tech note saying there were some x... files that were required on the server - but they seemed to be already there. I didn't have time to take it any further. hth Colin Alfke Calgary, Canada From: wphaskett Subject: [U2] XAdmin Does the Eclipse-based XAdmin tool, provided by RS on the client CD, only work with UniData 7.2 and higher? I can't seem to connect to any UD v7.1 machines. Will I have to reinstall UniAdmin in order to access those machines? Thanks, Bill Haskett ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users