Re: [U2] How to check data dictionary?
Dattatraya,
As others have said it sounds like you need more background knowledge of
unidata in general. Unidata comes with some good pdfs for this kind of
thing - certainly explaining basic concepts such as dictionary items.
Try looking in UDTD.pdf - Using Unidata. This is available for download,
try googling for it.
To answer your question:
You can list the data in the n'th attribute (field) of a file with
LIST filename F1 F2 Fn
These generic Fn dictionary items live in the VOC. The VOC being a
central file defining a whole bunch of things including dictionary items
that can then be used against any file.
If you get a message saying 'Illegal attribute name: Fn' then you won't
have the Fn item set up. You can add it manually by, for example
attribute 2:
AE VOC F2
Top of New F2 in VOC.
*--: I
001= D
002= 2
003=
004=
005= 10L
006= M
*--: FI
Filed F2 in file VOC.
:
Note that to enter the blank lines (lines 3 and 4) you need to use the
backquote character (`)- the key to the left of the 1 key on UK (
international?) keyboards.
Alternatively, you can look at data in individual records with a couple
of commands:
Try CT filename recordname to Copy to Terminal the contents of the
record.
Try AE filename recordname to edit the record - press Penter to see
lines. Press ? for help on all other commands.
Hope this helps
Edward
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya
Walgude
Sent: 07 October 2009 04:58
To: U2 Users List
Subject: Re: [U2] How to check data dictionary?
The following command is not showing all data columns.
LIST filename ALL
The LISTDICT filename - Not showing all column names
Now, from one of the filename, I have to extract data from hidden 3
columns which I can not see the names of column. Requesting you to
suggest me in such cases how to extract/see data.
I will be thankful to you, if you provide me all steps in details. This
is urgent matter my work is stuck.
Thanks in advance.
Dattatraya Walgude
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Tuesday, October 06, 2009 10:47 PM
To: U2 Users List
Subject: Re: [U2] How to check data dictionary?
I think he is getting caught with a file that doesn't have a very
well defined DICT file, whereas with SQL You can't really add anything
to a table without being able to see a description of it.
Life in UV is not like life in SQL.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Norman Bauer
Sent: Tuesday, October 06, 2009 12:41 PM
To: U2 Users List
Subject: Re: [U2] How to check data dictionary?
Along the lines of what David suggested, I would also recoment reading
the System Description PDF that is provided in the documentation as
well as the Guide to Retrieve.
I am not sure exactly what you are asking, but the only way that I
know of to check the dictionary (in UniVerse, not sure about UniData)
is:
LIST.DICT filename
Which will give you all the information on what data is stored in the
file as well as information of I-Descriptors, which are virtual fields
and I suspect that is what has you hung up. The Systems Description
guide goes into detail about I-Descriptors as well.
Norm
On Tue, Oct 6, 2009 at 3:42 AM, Dattatraya Walgude
dattatraya.walg...@rsystems.com wrote:
Dear ALL
We are working on UNIDATA version 6 and we need your guide line.
One of the table is having many multivalve columns but by LISTDICT I
can
not see. These columns have data but vendor program is showing all
columns data. As I do not know column name then let me know how to
see
the other columns? May I need to update dictionary to table to see
column name or suggest any other ways
By LISTDICT I can not see all column names.
My questions are:-
1) How to check data dictionary?
2) How to select / extract data form this tables ( for all columns
like
oracle select * from )?
3) How to remove extra space from column ( like oracle Trim() )
Your suggestions are most well-come and waiting for your positive
reply.
Regards
Dattatraya
Thanks Regards,
Dattatraya Walgude
DBA Team
Rsystems International Ltd, Pune,
* : +91-20-22909212
Disclaimer *
This mail, including any attachments contains confidential and
privileged information for the sole use of the addressee(s). If you
are
not the intended recipient,
please notify the sender by e-mail and delete the original message.
Any unauthorized review, use, disclosure, dissemination, forwarding,
printing
Re: [U2] Unidata Indexing Problems
Do you know if this is still a problem (too busy to trawl through the readme files)? Thanks David Kevin King-2 wrote: Come to find out the problem was that the user never logged off. Apparently Unidata keeps some information about indexes in the file buffer and because that file buffer was open at the time we rebuilt the index, that session didn't see the new indexes we had created. Once that user had logged off and back on again, we're golden. On Mon, Oct 5, 2009 at 11:48 PM, Colin Alfke alfke...@hotmail.com wrote: Check the release notes. I recall there being a problem with the sort.exe program on (I thought) a later version of UD 5 (5.2.4?) on windows. Same symptoms. Fix was to upgrade workaround was to grab the exe from a later version (6.0.12) and use it. Definately run it past support before you try it hth Colin Alfke Calgary, Canada From: Kevin We have a customer firmly ensconced on Unidata 5.1 on HP-UX (i.e. upgrading is not an option at this time) who is experiencing a strange indexing issue. We created a regular Unidata index (CREATE.INDEX) on a normal data field (attribute 189), built the index, tested, all is well. Another process comes along later and dumps a bunch of information in the file but... the index is not updated! There are other indexes on that file that are being properly updated, but our new one is not. This is a dynamic file and permissions on all of the parts are appropriate, which isn't really applicable anyway knowing that other indexes are being properly updated. Any ideas of something I could look for? There are no errors being logged in Unidata's logs, btw. -Kevin _ New! Open Messenger faster on the MSN homepage http://go.microsoft.com/?linkid=9677405 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- View this message in context: http://www.nabble.com/Unidata-Indexing-Problems-tp25762715p25783773.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Migrating both OS and Universe Database
Morning All, Looking for some pointers/information/guidance from anyone that may have already been through what we're going to be doing over the next few months. We will be migrating both our OS and Universe Database to a new physical server as detailed below: Current Future Sun Solaris 2.6 (SunOS 5.6) Sun Solaris 10 Universe 9.5.2.1 Universe 10 (at least) I remember many, many moons ago migrating from PiOpen to Universe and it was a weekend of hell, if my memory serves me correctly, and I want to cut down the level of hell during this migration if at all possible. We have many, many files, programs subroutines that make up our application, built up over the last 20 years or so which will mostly be moving. I also have a colleague that will be attending the U2 University in Liverpool next week and will gladly listen to any helpful information any of you, also attending, may have. Thanks in Advance, Louise Blair ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to check data dictionary?
Dattatraya, What do you mean by the 3 hidden columns? Are they fields that exist in the DATA files but have no DICT that defines the fields? If that is the case, you should determine what program is updating these fields, what type of data it is, then build the missing Dicts. This is simply an oversight on whoever wrote the program(s). It is sloppy coding, but we have all done it at one time or another. Or, as Edward wrote, simply build three generic Dicts that point to these fields and figure out what they are later. Just to clarify what Edward wrote about the generic Dicts, be sure there is nothing in fields 3 and 4. This will simply dump the raw data out (so if it is a date or time, you will get the internal date or time). Again, U2 is not SQL. It is better in a lot of ways, not as good in others. Don't get too bogged down trying to treat them as the same thing. Similar, yes, but not the same. Good luck. John Israel Senior Programmer/Analyst Dayton Superior Corporation 721 Richard St. Miamisburg, OH 45342 937-866-0711 x44380 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown Sent: Wednesday, October 07, 2009 6:21 AM To: U2 Users List Subject: Re: [U2] How to check data dictionary? Dattatraya, As others have said it sounds like you need more background knowledge of unidata in general. Unidata comes with some good pdfs for this kind of thing - certainly explaining basic concepts such as dictionary items. Try looking in UDTD.pdf - Using Unidata. This is available for download, try googling for it. To answer your question: You can list the data in the n'th attribute (field) of a file with LIST filename F1 F2 Fn These generic Fn dictionary items live in the VOC. The VOC being a central file defining a whole bunch of things including dictionary items that can then be used against any file. If you get a message saying 'Illegal attribute name: Fn' then you won't have the Fn item set up. You can add it manually by, for example attribute 2: AE VOC F2 Top of New F2 in VOC. *--: I 001= D 002= 2 003= 004= 005= 10L 006= M *--: FI Filed F2 in file VOC. : Note that to enter the blank lines (lines 3 and 4) you need to use the backquote character (`)- the key to the left of the 1 key on UK ( international?) keyboards. Alternatively, you can look at data in individual records with a couple of commands: Try CT filename recordname to Copy to Terminal the contents of the record. Try AE filename recordname to edit the record - press Penter to see lines. Press ? for help on all other commands. Hope this helps Edward -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya Walgude Sent: 07 October 2009 04:58 To: U2 Users List Subject: Re: [U2] How to check data dictionary? The following command is not showing all data columns. LIST filename ALL The LISTDICT filename - Not showing all column names Now, from one of the filename, I have to extract data from hidden 3 columns which I can not see the names of column. Requesting you to suggest me in such cases how to extract/see data. I will be thankful to you, if you provide me all steps in details. This is urgent matter my work is stuck. Thanks in advance. Dattatraya Walgude -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, October 06, 2009 10:47 PM To: U2 Users List Subject: Re: [U2] How to check data dictionary? I think he is getting caught with a file that doesn't have a very well defined DICT file, whereas with SQL You can't really add anything to a table without being able to see a description of it. Life in UV is not like life in SQL. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Norman Bauer Sent: Tuesday, October 06, 2009 12:41 PM To: U2 Users List Subject: Re: [U2] How to check data dictionary? Along the lines of what David suggested, I would also recoment reading the System Description PDF that is provided in the documentation as well as the Guide to Retrieve. I am not sure exactly what you are asking, but the only way that I know of to check the dictionary (in UniVerse, not sure about UniData) is: LIST.DICT filename Which will give you all the information on what data is stored in the file as well as information of I-Descriptors, which are virtual fields and I suspect that is what has you hung up. The Systems Description guide goes into detail about I-Descriptors as well. Norm On Tue, Oct 6, 2009 at 3:42 AM, Dattatraya Walgude
Re: [U2] How to check data dictionary?
Well look at that - you learn something new every day. That'll learn me to look at the manual/help/instructions even when I think I know what I'm doing :) -Original Message- From: Edward Brown Note that to enter the blank lines (lines 3 and 4) you need to use the backquote character (`)- the key to the left of the 1 key on UK ( international?) keyboards. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to check data dictionary?
How do you know? What are you doing that you can see the data that you can't find? I'm with the other posters that believe that you're simply missing dictionary items (the UniData dictionary is DEescriptive *NOT* PREsriptive like Oracle). However, if they are in multi-value columns there are a couple of things that could be giving you grief: 1. The dicts are not properly associated or marked as multi-value 2. You're looking at the file through SQL and the multi-value data is setup in a subtable/view. Hth Colin Alfke Calgary, Canada -Original Message- From: Dattatraya Walgude The following command is not showing all data columns. LIST filename ALL The LISTDICT filename - Not showing all column names Now, from one of the filename, I have to extract data from hidden 3 columns which I can not see the names of column. Requesting you to suggest me in such cases how to extract/see data. I will be thankful to you, if you provide me all steps in details. This is urgent matter my work is stuck. Thanks in advance. Dattatraya Walgude ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to check data dictionary?
Here is an unlikely reason for the missing Dicts (I am assuming they are missing): Whoever created the fields did not want people to easily access them. For example, un-encrypted passwords. I seriously doubt this is the situation, but I thought I would just throw it out. My vote is still simply missing Dicts. John Israel Senior Programmer/Analyst Dayton Superior Corporation 721 Richard St. Miamisburg, OH 45342 937-866-0711 x44380 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Alfke Sent: Wednesday, October 07, 2009 10:05 AM To: 'U2 Users List' Subject: Re: [U2] How to check data dictionary? How do you know? What are you doing that you can see the data that you can't find? I'm with the other posters that believe that you're simply missing dictionary items (the UniData dictionary is DEescriptive *NOT* PREsriptive like Oracle). However, if they are in multi-value columns there are a couple of things that could be giving you grief: 1. The dicts are not properly associated or marked as multi-value 2. You're looking at the file through SQL and the multi-value data is setup in a subtable/view. Hth Colin Alfke Calgary, Canada -Original Message- From: Dattatraya Walgude The following command is not showing all data columns. LIST filename ALL The LISTDICT filename - Not showing all column names Now, from one of the filename, I have to extract data from hidden 3 columns which I can not see the names of column. Requesting you to suggest me in such cases how to extract/see data. I will be thankful to you, if you provide me all steps in details. This is urgent matter my work is stuck. Thanks in advance. Dattatraya Walgude ___ 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
Re: [U2] How to check data dictionary?
Missing dicts seems likely to me also. In our system we tend to create dicts only for fields we report / select on. File layouts are maintained in a bespoke editor, which in turn ties in with the way we use records from these files programmatically. So programmers tend to maintain the file layouts and dictionaries are usually an afterthought. Edward -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: 07 October 2009 15:09 To: U2 Users List Subject: Re: [U2] How to check data dictionary? Here is an unlikely reason for the missing Dicts (I am assuming they are missing): Whoever created the fields did not want people to easily access them. For example, un-encrypted passwords. I seriously doubt this is the situation, but I thought I would just throw it out. My vote is still simply missing Dicts. John Israel Senior Programmer/Analyst Dayton Superior Corporation 721 Richard St. Miamisburg, OH 45342 937-866-0711 x44380 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Alfke Sent: Wednesday, October 07, 2009 10:05 AM To: 'U2 Users List' Subject: Re: [U2] How to check data dictionary? How do you know? What are you doing that you can see the data that you can't find? I'm with the other posters that believe that you're simply missing dictionary items (the UniData dictionary is DEescriptive *NOT* PREsriptive like Oracle). However, if they are in multi-value columns there are a couple of things that could be giving you grief: 1. The dicts are not properly associated or marked as multi-value 2. You're looking at the file through SQL and the multi-value data is setup in a subtable/view. Hth Colin Alfke Calgary, Canada -Original Message- From: Dattatraya Walgude The following command is not showing all data columns. LIST filename ALL The LISTDICT filename - Not showing all column names Now, from one of the filename, I have to extract data from hidden 3 columns which I can not see the names of column. Requesting you to suggest me in such cases how to extract/see data. I will be thankful to you, if you provide me all steps in details. This is urgent matter my work is stuck. Thanks in advance. Dattatraya Walgude ___ 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 --- 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 http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata Indexing Problems
I believe Colin was referring to a problem with BUILD.INDEX during the phase that udtsort.exe is used to sort the temp files before applying to the index. As Colin indicated - this is ancient history (in terms of UniData releases). Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of inquieti Sent: Wednesday, October 07, 2009 4:28 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Unidata Indexing Problems Do you know if this is still a problem (too busy to trawl through the readme files)? Thanks David Kevin King-2 wrote: Come to find out the problem was that the user never logged off. Apparently Unidata keeps some information about indexes in the file buffer and because that file buffer was open at the time we rebuilt the index, that session didn't see the new indexes we had created. Once that user had logged off and back on again, we're golden. On Mon, Oct 5, 2009 at 11:48 PM, Colin Alfke alfke...@hotmail.com wrote: Check the release notes. I recall there being a problem with the sort.exe program on (I thought) a later version of UD 5 (5.2.4?) on windows. Same symptoms. Fix was to upgrade workaround was to grab the exe from a later version (6.0.12) and use it. Definately run it past support before you try it hth Colin Alfke Calgary, Canada From: Kevin We have a customer firmly ensconced on Unidata 5.1 on HP-UX (i.e. upgrading is not an option at this time) who is experiencing a strange indexing issue. We created a regular Unidata index (CREATE.INDEX) on a normal data field (attribute 189), built the index, tested, all is well. Another process comes along later and dumps a bunch of information in the file but... the index is not updated! There are other indexes on that file that are being properly updated, but our new one is not. This is a dynamic file and permissions on all of the parts are appropriate, which isn't really applicable anyway knowing that other indexes are being properly updated. Any ideas of something I could look for? There are no errors being logged in Unidata's logs, btw. -Kevin _ New! Open Messenger faster on the MSN homepage http://go.microsoft.com/?linkid=9677405 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- View this message in context: http://www.nabble.com/Unidata-Indexing-Problems-tp25762715p25783773.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ 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
Re: [U2] How to check data dictionary?
Dattatrava, Unfortunately, when my compatriots are so engrained in using AE/ED, paragraphs, procs and such we cannot see the forest through the trees. Let us as a group stop teaching the newbie's the esoteric commands and have them use our neat new tools. The Basic Developer Toolkit (BDT) is free if you are using Unidata 7.2 or Universe 10.3. Using BDT would only have to right click on the U2 Resource and pick the menu item Open Dictionary. Using XLr8Editor which is available for Unidata 6.0 or above or Universe 9.6 or above, all you would have to do is right click on the file in the Project Explorer, pick Open Dictionary Editor and voilà the dictionary would show up in the main panel. Life can be easy when using tools... Regards, Doug www.u2logic.com [ad] To all of those of you who have not tried our XLr8Editor, free trials are available. See www.u2logic.com/pdfs/XLr8EditorInstallation.pdf for instructions.[/ad] -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya Walgude Sent: Tuesday, October 06, 2009 9:58 PM To: U2 Users List Subject: Re: [U2] How to check data dictionary? The following command is not showing all data columns. LIST filename ALL The LISTDICT filename - Not showing all column names Now, from one of the filename, I have to extract data from hidden 3 columns which I can not see the names of column. Requesting you to suggest me in such cases how to extract/see data. I will be thankful to you, if you provide me all steps in details. This is urgent matter my work is stuck. Thanks in advance. Dattatraya Walgude ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to check data dictionary?
however, if the dict definition doesn't exist, will those tools create one? He is still stuck with either sifting through the programming to figure out what data is put in those attributes, or analyzing the data itself to figure out what kind of data it is (purpose, not data types). George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Doug Sent: Wednesday, October 07, 2009 11:40 AM To: 'U2 Users List' Subject: Re: [U2] How to check data dictionary? Dattatrava, Unfortunately, when my compatriots are so engrained in using AE/ED, paragraphs, procs and such we cannot see the forest through the trees. Let us as a group stop teaching the newbie's the esoteric commands and have them use our neat new tools. The Basic Developer Toolkit (BDT) is free if you are using Unidata 7.2 or Universe 10.3. Using BDT would only have to right click on the U2 Resource and pick the menu item Open Dictionary. Using XLr8Editor which is available for Unidata 6.0 or above or Universe 9.6 or above, all you would have to do is right click on the file in the Project Explorer, pick Open Dictionary Editor and voilà the dictionary would show up in the main panel. Life can be easy when using tools... Regards, Doug www.u2logic.com [ad] To all of those of you who have not tried our XLr8Editor, free trials are available. See www.u2logic.com/pdfs/XLr8EditorInstallation.pdf for instructions.[/ad] -Original Message- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to check data dictionary?
Both tools allow dictionary item creation. Of course, you would know that if you had tried either one. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, October 07, 2009 9:59 AM To: U2 Users List Subject: Re: [U2] How to check data dictionary? however, if the dict definition doesn't exist, will those tools create one? He is still stuck with either sifting through the programming to figure out what data is put in those attributes, or analyzing the data itself to figure out what kind of data it is (purpose, not data types). George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Doug Sent: Wednesday, October 07, 2009 11:40 AM To: 'U2 Users List' Subject: Re: [U2] How to check data dictionary? Dattatrava, Unfortunately, when my compatriots are so engrained in using AE/ED, paragraphs, procs and such we cannot see the forest through the trees. Let us as a group stop teaching the newbie's the esoteric commands and have them use our neat new tools. The Basic Developer Toolkit (BDT) is free if you are using Unidata 7.2 or Universe 10.3. Using BDT would only have to right click on the U2 Resource and pick the menu item Open Dictionary. Using XLr8Editor which is available for Unidata 6.0 or above or Universe 9.6 or above, all you would have to do is right click on the file in the Project Explorer, pick Open Dictionary Editor and voilà the dictionary would show up in the main panel. Life can be easy when using tools... Regards, Doug www.u2logic.com [ad] To all of those of you who have not tried our XLr8Editor, free trials are available. See www.u2logic.com/pdfs/XLr8EditorInstallation.pdf for instructions.[/ad] -Original Message- ___ 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
Re: [U2] How to check data dictionary?
Correct, I have not used either. but even if they do allow creation, you still have to know what the data is, it's purpose in life to accurately define a dict item. Do those programs also scan the entire file to determine what the highest attribute number is? (I use an idesc dcount(@record,char(254)), then list the file by.dsnd) otherwise, he may have more than 3 hidden fields. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Doug Sent: Wednesday, October 07, 2009 12:03 PM To: 'U2 Users List' Subject: Re: [U2] How to check data dictionary? Both tools allow dictionary item creation. Of course, you would know that if you had tried either one. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to check data dictionary?
Veering a little off-topic here! I've not used the unidata dev environment although I edit my programs in a windows editor, in common with almost all the programmers here, and have tools to quickly identify and compile up any modified source files, plus loads of other bespoke bits and pieces that make development relatively straightforward efficient. It works well for me and I suspect a lot of Pick developers are in a similar solution. There's something to be said for if it aint broke don't fix it. Also, fundamentally, unless tools like the unidata dev environment are dangled right in front of our noses and we're told to use them (or else!) then we're unlikely to seek them out. This was the case with Subversion - a success btw. Maybe the original poster would let us know if the suggestions so far have helped, and if not a little more direction on what he's trying to do? Ed -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: 07 October 2009 17:15 To: U2 Users List Subject: Re: [U2] How to check data dictionary? Correct, I have not used either. but even if they do allow creation, you still have to know what the data is, it's purpose in life to accurately define a dict item. Do those programs also scan the entire file to determine what the highest attribute number is? (I use an idesc dcount(@record,char(254)), then list the file by.dsnd) otherwise, he may have more than 3 hidden fields. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Doug Sent: Wednesday, October 07, 2009 12:03 PM To: 'U2 Users List' Subject: Re: [U2] How to check data dictionary? Both tools allow dictionary item creation. Of course, you would know that if you had tried either one. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- 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 http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] wIntegrate Query Builder
Is it possible to use the query builder by itself, without installing wIntegrate? I can use the AccuTerm Transfer Wizard via the web; it has a .cab file that will install along with AccuTerm 2K2 (IE version). The query builder would be a fine product to be able to use via the web. Bill Haskett Advantos Systems, Inc. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to check data dictionary?
And if you are using UniData 6 or older all those fancy tools supposedly don't work anyway. Unfortunately we don't all have the luxury to always work with the latest release like Doug obviously does. Edward Brown wrote: Veering a little off-topic here! I've not used the unidata dev environment although I edit my programs in a windows editor, in common with almost all the programmers here, and have tools to quickly identify and compile up any modified source files, plus loads of other bespoke bits and pieces that make development relatively straightforward efficient. It works well for me and I suspect a lot of Pick developers are in a similar solution. There's something to be said for if it aint broke don't fix it. Also, fundamentally, unless tools like the unidata dev environment are dangled right in front of our noses and we're told to use them (or else!) then we're unlikely to seek them out. This was the case with Subversion - a success btw. Maybe the original poster would let us know if the suggestions so far have helped, and if not a little more direction on what he's trying to do? Ed -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: 07 October 2009 17:15 To: U2 Users List Subject: Re: [U2] How to check data dictionary? Correct, I have not used either. but even if they do allow creation, you still have to know what the data is, it's purpose in life to accurately define a dict item. Do those programs also scan the entire file to determine what the highest attribute number is? (I use an idesc dcount(@record,char(254)), then list the file by.dsnd) otherwise, he may have more than 3 hidden fields. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Doug Sent: Wednesday, October 07, 2009 12:03 PM To: 'U2 Users List' Subject: Re: [U2] How to check data dictionary? Both tools allow dictionary item creation. Of course, you would know that if you had tried either one. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- 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 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
Re: [U2] How to check data dictionary?
Mecki, That is not true, XLr8Editor does work on Unidata release 6.0 and up. Regards, Doug www.u2logic.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Wednesday, October 07, 2009 10:38 AM To: U2 Users List Subject: Re: [U2] How to check data dictionary? And if you are using UniData 6 or older all those fancy tools supposedly don't work anyway. Unfortunately we don't all have the luxury to always work with the latest release like Doug obviously does. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] .Net Data Provider
Mike: Sure it is. On the main page, at the bottom... Related Products Client Tools http://www.rocketsoftware.com/u2/tools/ U2 Client Tools are designed to fully leverage the power of the extended relational model supported by UniData and UniVerse. U2.NET http://www.rocketsoftware.com/u2/products/u2-net/ UniData and UniVerse Add-ins for Visual Studio provides an ADO.NET provider and Microsoft™ Visual Studio add-ins for MultiValue-centric programming in a .NET framework. HTH, Bill Mike Randall said the following on 10/1/2009 10:19 AM: Anyone have any idea what happens to the .Net Data Provider for U2 in the Rocket Universe? The product was labeled as a DB2 data provider on the IBM site with U2 being part of the functionality. No mention of it anywhere on the Rocket site. Thanks, Mike Randall ___ 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
Re: [U2] Migrating both OS and Universe Database
Get the new hardware, plan the steps for install/conversion, create test cases, run a test conversion, adjust conversion procedures, run your test cases and, once all issues are resolved and documented, schedule downtime, blow away the target system so you have a clean platform again and pull the trigger. You run in to the same problems (maybe more because you have time to find them) but you aren't under the pressure of a downtime window to fix them. You can also get your users to do acceptance on the system before the real conversion (spread the responsibility). That makes the actual conversion much less stressful and more successful. On Wed, Oct 7, 2009 at 4:48 AM, Louise Blair (DHL GB) louise.bl...@dhl.comwrote: Morning All, Looking for some pointers/information/guidance from anyone that may have already been through what we're going to be doing over the next few months. We will be migrating both our OS and Universe Database to a new physical server as detailed below: Current Future Sun Solaris 2.6 (SunOS 5.6) Sun Solaris 10 Universe 9.5.2.1 Universe 10 (at least) I remember many, many moons ago migrating from PiOpen to Universe and it was a weekend of hell, if my memory serves me correctly, and I want to cut down the level of hell during this migration if at all possible. We have many, many files, programs subroutines that make up our application, built up over the last 20 years or so which will mostly be moving. I also have a colleague that will be attending the U2 University in Liverpool next week and will gladly listen to any helpful information any of you, also attending, may have. Thanks in Advance, Louise Blair ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Kyle Moore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to check data dictionary?
Sorry Doug, I don't like using ED either, but XLr8Editor probably won't work on our UD release at work, since we don't even have 6.0. And for quick data fixes and looking at raw data from TCL with select lists ED/AE just can't be beat. Nevertheless at least for maintaining Basic code I use Brian's MV Developer, and that one works even with UD 5.2 :-) But since we have an old PRC 3.9 controlled SB+ application everything needs to be edited eventually using Server side tools to be tracked properly :-(. Doug wrote: Mecki, That is not true, XLr8Editor does work on Unidata release 6.0 and up. Regards, Doug www.u2logic.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Wednesday, October 07, 2009 10:38 AM To: U2 Users List Subject: Re: [U2] How to check data dictionary? And if you are using UniData 6 or older all those fancy tools supposedly don't work anyway. Unfortunately we don't all have the luxury to always work with the latest release like Doug obviously does. ___ 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] Anybody familiar with Storis software?
I have been talking to a company about some programming work. They are running a software package called Storis. Is the source code included with this software? What is the GUI front end written in (Revision 8.5)? Thank you. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] hpux to linux; Solaris 2.6 to Solaris 10
Just out of curiosity, why are you moving to windows? Are there specific benefits? Thanks. On 10/07/2009 10:55 AM, jpb-u2ug wrote: We have moved from Unix V5 on Motorola, to Solaris 2.6, to Solaris 8, to RH Linux AS3, and are now in the process of moving to Windows 2008. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 is now Rocket U2
I wonder if (when) the U2 Solution portal... http://www.ibm.com/developerworks/wikis/display/im/U2+Solution+Portal+-+Home ...and the U2 Developer works portal... http://www.ibm.com/developerworks/views/data/libraryview.jsp?search_by=U2 ...will be coming over soon? I couldn't find them in the knowledge base; fortunately, they're still active on the IBM site. Bill Ross Morrissey said the following on 9/30/2009 10:41 PM: http://www.rocketsoftware.com/u2/ is up, with trial version requests, certification, U2U, and a letter to the U2 Community A number of questions over the past couple of weeks appear to have been answered. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 is now Rocket U2
Bill, I spoke to some IBMers... er... Rocketeers yesterday on that topic. They are still porting over tons of web material. While final dates were not communicated, they are working on it. - Chuck Bill Haskett wrote: I wonder if (when) the U2 Solution portal... http://www.ibm.com/developerworks/wikis/display/im/U2+Solution+Portal+-+Home ...and the U2 Developer works portal... http://www.ibm.com/developerworks/views/data/libraryview.jsp?search_by=U2 ...will be coming over soon? I couldn't find them in the knowledge base; fortunately, they're still active on the IBM site. Bill Ross Morrissey said the following on 9/30/2009 10:41 PM: http://www.rocketsoftware.com/u2/ is up, with trial version requests, certification, U2U, and a letter to the U2 Community A number of questions over the past couple of weeks appear to have been answered. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.421 / Virus Database: 270.14.5/2419 - Release Date: 10/07/09 05:18:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] U2 is now Rocket U2 - what to call them?
I spoke to some IBMers... er... Rocketeers Maybe I missed this in the days after the announcement, but has the critical question of what to call Rocket Software employees been discussed? I kinda like Rocketeers but wonder if they'd prefer something else like Rocketers, Rocketmen (gender bias noted) or maybe even Rockettes? g What do you say, Rocket Software employees? Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] .Net Data Provider
Brian: Mike could go to the horses mouth and contact BlueFinity about mv.NET. It's a very good product at a very reasonable price (except, of course, the Reporting Services module). HTH, Bill br...@brianleach.co.uk said the following on 10/6/2009 3:41 AM: Hi Mike I raised this with the U2 team when the announcement was first made, and with (then) IBM in a U2UG board meeting. At that time they weren't able to comment and even the engineers didn't know what would happen to it. I have been promised a response when the dust settles, so I'll post then if nobody gets to hear first. It is the only part of the product that I can think of that is not separated out from other IBM stuff. I hope it won't be frozen or made unavailable because it was shaping into a nice product. Brian On 01 October 2009 at 19:19 Mike Randall mike.rand...@comcast.net wrote: Anyone have any idea what happens to the .Net Data Provider for U2 in the Rocket Universe? The product was labeled as a DB2 data provider on the IBM site with U2 being part of the functionality. No mention of it anywhere on the Rocket site. Thanks, Mike Randall ___ 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-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] U2 University - Liverpool
Hi all. I'm not sure how common the knowledge is, or indeed whether I should particularly be sharing it out, but there are a limited number of day passes available for day 1 of the U2 University in Liverpool next Tuesday. These cost 100 GBP (about 100 Euros and not too many more USD at the moment) per delegate and allow access to the full agenda of the first day - including a keynote speech by Susie Siegesmund (U2) and Andy Youniss (Rocket), the product roadmaps and the gala dinner event on the evening. If, like me, you balked at the cost of the three days but are keen to find out the latest about what's going on then I think this represents pretty decent value. You apply using the link below, but make sure that you let IBM know that you only want the day pass because the website will want to charge you for all three days - there's a comments section that I've used, but I also emailed them to be sure. As Les Hewkin (hello big feller!) said a couple of weeks ago - I'll be in the bar... http://www-304.ibm.com/jct03001c/services/learning/ites.wss/zz/en?pageType=pagec=F531480R19349Q30 Best regards Colin. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Getting to the OS
I can't remember how it works in the Unidata world, but on our Universe systems we create a bunch of VOC items called F1, F2, F3, etc. Each one looks a bit like this: Top of F1 in VOC, 6 lines, 11 characters. *--: P 001: D 002: 1 003: 004: 005: 15T 006: S Bottom. Anytime we just want to see the data in a file without worrying about field names and conversions and such we use those attribute names. LIST FILENAME F2 F5 F7 or whatever. Dave Barrett This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please delete it and advise me (by return e-mail or otherwise) immediately. Ce courrier électronique est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est interdite. Si vous recevez ce courrier électronique par erreur, veuillez le supprimer et m'en aviser immédiatement, par retour de courrier électronique ou par un autre moyen. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to check data dictionary?
Symeon,
As a long time Pickie, I thought that I would point out that there is a
short-cut that is supported on most multi-value flavours which saves some
concatenation, for instance :
CRT SPACE(15):AREC.HDR1,1'R#10 ':AREC.HDR1,2'R#10 ':AREC.HDR1,3'R#10
':AREC.HDR1,4'R#10 ' ':AREC.HDR1,5'R#10'
CRT Attribute :X'R#4 ':ARECX,1'R#10 ':ARECX,2'R#10 ':ARECX,3'R#10
':ARECX,4'R#10 ':ARECX,5'R#10'
You can add the space after the format string and save yourself some
keystrokes.
Mike
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen
Sent: Tuesday, October 06, 2009 8:48 PM
To: 'U2 Users List'
Subject: Re: [U2] How to check data dictionary?
Maybe not exactly what you are looking for - here is a program that will
analyse all data in a file and give a resume of which attributes/columns
have data and what kind of data. You could easily enhance this to tell you
if there is any mv or sub valued data in an attribute. After running this
you will then know what definitions are missing from your dictionary
* Save in BP as ANALYSEFILE and compile and catalog
* to analyse a data file and give a resume of what attributes are used
* Usage - ANALYSEFILE {file name}
s...@sentence
IF Sen[1,4]=RUN THEN Sen=Sen[5,999]
IF Sen[1,11]#ANALYSEFILE THEN CRT Verb must be called
ANALYSEFILE;STOP
FN=TRIM(Sen[12,99])
IF FN='' THEN
CRT ENTER FILE NAME ::
PROMPT ''
INPUT FN
END
AREC='' ;*VAL1= No of blank recs, 2=num numeric, 3= num text, 4=min
length, 5=max length
AREC.HDR=Null:@VM:Numeric:@VM:Text:@VM:Min len:@VM:Max
len:@VM:'# with MVs'
OPEN FN TO FIL ELSE CRT Can not open file :FN;STOP
SELECT FIL
cnt=0
LOOP WHILE READNEXT ID DO
cnt+=1
READ REC FROM FIL,ID ELSE REC=''
MAX=DCOUNT(REC,@AM)
FOR X = 1 TO MAX
REC.NULL=CHANGE(CHANGE(RECX,@VM,''),@SVM,'')='' ;*i.e. all
vals and subvals null
IF COUNT(RECX,@VM) THEN ARECX,6+=1
IF REC.NULL THEN
ARECX,1+=1
END ELSE
IF NUM(RECX,1,1) THEN ARECX,2+=1 ELSE ARECX,3+=1
REC.LEN=LEN(RECX,1,1)
IF ARECX,4='' THEN
ARECX,4=REC.LEN
END ELSE
IF REC.LEN ARECX,4 THEN ARECX,4=REC.LEN
END
IF REC.LEN ARECX,5 THEN ARECX,5=REC.LEN
END
NEXT X
REPEAT
CRT
CRT Analysis for :cnt: records of :FN
CRT
CRT SPACE(15):AREC.HDR1,1'R#10':' ':AREC.HDR1,2'R#10':'
':AREC.HDR1,3'R#10':' ':AREC.HDR1,4'R#10':' ':AREC.HDR1,5'R#10'
MAX=DCOUNT(AREC,@AM)
FOR X=1 TO MAX
CRT Attribute :X'R#4':' ':ARECX,1'R#10':' ':ARECX,2'R#10':'
':ARECX,3'R#10':' ':ARECX,4'R#10':' ':ARECX,5'R#10'
NEXT X
CRT Finished.
END
HTH
Symeon
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dattatraya
Walgude
Sent: 06 October 2009 08:43
To: u2-users@listserver.u2ug.org
Subject: [U2] How to check data dictionary?
Dear ALL
We are working on UNIDATA version 6 and we need your guide line.
One of the table is having many multivalve columns but by LISTDICT I can
not see. These columns have data but vendor program is showing all
columns data. As I do not know column name then let me know how to see
the other columns? May I need to update dictionary to table to see
column name or suggest any other ways
By LISTDICT I can not see all column names.
My questions are:-
1) How to check data dictionary?
2) How to select / extract data form this tables ( for all columns like
oracle select * from )?
3) How to remove extra space from column ( like oracle Trim() )
Your suggestions are most well-come and waiting for your positive reply.
Regards
Dattatraya
Thanks Regards,
Dattatraya Walgude
DBA Team
Rsystems International Ltd, Pune,
* : +91-20-22909212
Disclaimer *
This mail, including any attachments contains confidential and privileged
information for the sole use of the addressee(s). If you are not the
intended recipient,
please notify the sender by e-mail and delete the original message. Any
unauthorized review, use, disclosure, dissemination, forwarding, printing or
copying of
this email or any action taken in reliance on this e-mail is strictly
prohibited and are unlawful. This e-mail may contain viruses. R Systems
International Limited has
taken every reasonable precaution to minimize this risk. R Systems
International Limited is not liable for any damage you may sustain as a
result of any virus in this e-mail.
Before opening the e-mail or attachment, You should carry out your own virus
checks. R Systems International Limited reserves the right to record,
monitor, and inspect
all email communications
[U2] [UV] Storing / Displaying the Euro symbol
Hello, Anyone here had to display the Unicode Euro symbol on the terminal ? I'd like to store it in a data item and be able to display it. I've looked at the UNICHARS command without luck. Jacques G. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 is now Rocket U2
I wonder what is the marketing idea behind the name Rocket ? To me it invokes late 1950 - 1960's Sputnik/Apollo technology to an epoch when cars designs were made to look like rockets, when there was a hockey player nicknamed Maurice The Rocket Richard and people watched Flash Gordon on a black and white television. When I hear Rocket I think retro like a LP Player, a typewriter, a PDP-1. Wouldn't one want a software product to sound more state of the art ? Sci-fi hasn't used the term Rocketship in decades. Jacques ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Storing / Displaying the Euro symbol
On Wed, 7 Oct 2009, Jacques G. wrote: Hello, Anyone here had to display the Unicode Euro symbol on the terminal ? I'd like to store it in a data item and be able to display it. I've looked at the UNICHARS command without luck. If you're talking about an actual (dumb) terminal, good luck with that. If you're talking about a terminal emulator, you will surely be dependent on the capabilities of the emulator. Our emulators, Anzio Lite and AnzioWin, can display the full range of Unicode characters. There are some configuration settings that must be correct; we could help you with that. Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Storing / Displaying the Euro symbol
We are using terminal emulators. Putty and HostAccess are the most frequently used. - Original Message From: Bob Rasmussen r...@anzio.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, October 7, 2009 4:06:48 PM Subject: Re: [U2] [UV] Storing / Displaying the Euro symbol On Wed, 7 Oct 2009, Jacques G. wrote: Hello, Anyone here had to display the Unicode Euro symbol on the terminal ? I'd like to store it in a data item and be able to display it. I've looked at the UNICHARS command without luck. If you're talking about an actual (dumb) terminal, good luck with that. If you're talking about a terminal emulator, you will surely be dependent on the capabilities of the emulator. Our emulators, Anzio Lite and AnzioWin, can display the full range of Unicode characters. There are some configuration settings that must be correct; we could help you with that. Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA ___ 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] I need your eyes
All, Doug Henschen at Intelligent Enterprise has posted this article: http://intelligent-enterprise.informationweek.com/channels/information_management/showArticle.jhtml?articleID=220301557 I have a bet with him that there is enough interest in MV stories that he should do more of them. He'd like to see how many unique (not the same person looking over over) page views this gets. Let's see if we can show the mainstream some legitimate interest. - Charles Barouch, Author ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 is now Rocket U2
Funny you should ask. Andy Youniss, Rocket's CEO, was asked the question of the origination of Rocket last night at dinner, and the short answer was that at the time 20 years ago, he liked it. Although it may feel retro to some, I disagree that it carries a negative connotation. One of the leading companies in the commercialization of space today, Space Exploration Technologies, uses the term in its material on http://www.spacex.com. In addition, NASA is a Rocket customer. The reason that rocketship has not been used in science fiction in decades is for decades it has been fact, not fiction. Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jacques G. Sent: Wednesday, October 07, 2009 1:03 PM To: U2 Users List Subject: Re: [U2] U2 is now Rocket U2 I wonder what is the marketing idea behind the name Rocket ? To me it invokes late 1950 - 1960's Sputnik/Apollo technology to an epoch when cars designs were made to look like rockets, when there was a hockey player nicknamed Maurice The Rocket Richard and people watched Flash Gordon on a black and white television. When I hear Rocket I think retro like a LP Player, a typewriter, a PDP-1. Wouldn't one want a software product to sound more state of the art ? Sci-fi hasn't used the term Rocketship in decades. Jacques ___ 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
Re: [U2] Anybody familiar with Storis software?
http://www.storis.com/ --- On Wed, 10/7/09, Steve Kunzman skunz...@comcast.net wrote: From: Steve Kunzman skunz...@comcast.net Subject: [U2] Anybody familiar with Storis software? To: u2-users@listserver.u2ug.org Date: Wednesday, October 7, 2009, 2:16 PM I have been talking to a company about some programming work. They are running a software package called Storis. Is the source code included with this software? What is the GUI front end written in (Revision 8.5)? Thank you. ___ 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
Re: [U2] Anybody familiar with Storis software?
I am truly impressed with your ability to find this gem. What I'd like to know is why the sudden change in the treatment of the Personal Editions of UV/UD from their new owner. IBM were happy to let anyone have a copy for the non-commercial use required in the agreement. I get the impression with Rocket it is now only for 'evaluation'. Would anyone from Rocket care to comment? Clive On Wed, Oct 7, 2009 at 9:59 PM, Address mrparkl...@yahoo.com wrote: http://www.storis.com/ --- On Wed, 10/7/09, Steve Kunzman skunz...@comcast.net wrote: From: Steve Kunzman skunz...@comcast.net Subject: [U2] Anybody familiar with Storis software? To: u2-users@listserver.u2ug.org Date: Wednesday, October 7, 2009, 2:16 PM I have been talking to a company about some programming work. They are running a software package called Storis. Is the source code included with this software? What is the GUI front end written in (Revision 8.5)? Thank you. ___ 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 -- Clive ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] I need your eyes
Nice article man! On Wed, Oct 7, 2009 at 2:14 PM, Results resu...@keyally.com wrote: All, Doug Henschen at Intelligent Enterprise has posted this article: http://intelligent-enterprise.informationweek.com/channels/information_management/showArticle.jhtml?articleID=220301557 I have a bet with him that there is enough interest in MV stories that he should do more of them. He'd like to see how many unique (not the same person looking over over) page views this gets. Let's see if we can show the mainstream some legitimate interest. - Charles Barouch, Author ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 is now Rocket U2
I'm impressed that they actually used the MultiValue[TM] word on this page. That it is still a trademark of Spectrum, right? I don't recall them using that when they were IBM, although they might have. --dawn On Thu, Oct 1, 2009 at 12:41 AM, Ross Morrissey u...@rossmorrissey.com wrote: http://www.rocketsoftware.com/u2/ is up, with trial version requests, certification, U2U, and a letter to the U2 Community A number of questions over the past couple of weeks appear to have been answered. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Dawn M. Wolthuis Take and give some delight today ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How to check data dictionary?
For those of you using PRC, we have spoke with Susan at U2 University. She says if you want to use our XLr8Editor she needs our editor to call the check out function during edit mode and the call the check in mode on finish. We told her that would not be a problem. She said all PRC's customer have to do is request that from her and we will make it work. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Wednesday, October 07, 2009 12:05 PM To: U2 Users List Subject: Re: [U2] How to check data dictionary? Sorry Doug, I don't like using ED either, but XLr8Editor probably won't work on our UD release at work, since we don't even have 6.0. And for quick data fixes and looking at raw data from TCL with select lists ED/AE just can't be beat. Nevertheless at least for maintaining Basic code I use Brian's MV Developer, and that one works even with UD 5.2 :-) But since we have an old PRC 3.9 controlled SB+ application everything needs to be edited eventually using Server side tools to be tracked properly :-(. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Migrating both OS and Universe Database
In message 663c35400910071056r188989b1x40a2e0b34083c...@mail.gmail.com, Kyle Moore kmo...@mooreimages.com writes Get the new hardware, plan the steps for install/conversion, create test cases, run a test conversion, adjust conversion procedures, run your test cases and, once all issues are resolved and documented, schedule downtime, blow away the target system so you have a clean platform again and pull the trigger. You run in to the same problems (maybe more because you have time to find them) but you aren't under the pressure of a downtime window to fix them. You can also get your users to do acceptance on the system before the real conversion (spread the responsibility). That makes the actual conversion much less stressful and more successful. Seeing as it's a migration FROM Solaris/UV TO Solaris/UV it shouldn't be a problem. Though the advice usually is upgrade one component at a time, so you should really look at upgrading to UV 10 on your old machine, bedding it in, then moving to your new Solaris and machine. That said, I wouldn't expect any problems doing it your way. Make sure your new machine is configured as closely as possible to the old machine, in particular all the paths for the UV system directory and accounts directories. Just copy all the accounts across. Make sure they have entries in the UV.ACCOUNT file. Make sure that anything in the global catalog is catalog'd on the new system - I think the command is MAKE.MAP.FILE - this will create an MAP file that lists all the catalog'd routines. Run that on the old system and go through it - make sure there's nothing there that will surprise you. Then hopefully you're all fit to go! There are some tricks - if you've lost the source/binary to a catalog'd routine I'm pretty sure you can extract it from the catalog - I'm not quite sure how, though. Cheers, Wol On Wed, Oct 7, 2009 at 4:48 AM, Louise Blair (DHL GB) louise.bl...@dhl.comwrote: Morning All, Looking for some pointers/information/guidance from anyone that may have already been through what we're going to be doing over the next few months. We will be migrating both our OS and Universe Database to a new physical server as detailed below: Current Future Sun Solaris 2.6 (SunOS 5.6) Sun Solaris 10 Universe 9.5.2.1 Universe 10 (at least) I remember many, many moons ago migrating from PiOpen to Universe and it was a weekend of hell, if my memory serves me correctly, and I want to cut down the level of hell during this migration if at all possible. We have many, many files, programs subroutines that make up our application, built up over the last 20 years or so which will mostly be moving. I also have a colleague that will be attending the U2 University in Liverpool next week and will gladly listen to any helpful information any of you, also attending, may have. Thanks in Advance, Louise Blair ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Anthony W. Youngman pi...@thewolery.demon.co.uk 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] @NV or @VALUE.COUNT
Does anyone know how to use @NV or @VALUE.COUNT in a dictionary, thanks, Brad ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Storing / Displaying the Euro symbol
On Wed, 7 Oct 2009, Jacques G. wrote: We are using terminal emulators. Putty and HostAccess are the most frequently used. So you should call them for tech support ... yeah, that'll work ;-) Seriously, if you'd like to consider using Anzio, we'll work with you on that. I don't know the nuances of configuring UV for international output, but I can learn. Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 is now Rocket U2 - what to call them?
Boosters? Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com Sent: Thursday, 8 October 2009 5:53 AM To: U2 Users List Subject: [U2] U2 is now Rocket U2 - what to call them? I spoke to some IBMers... er... Rocketeers Maybe I missed this in the days after the announcement, but has the critical question of what to call Rocket Software employees been discussed? I kinda like Rocketeers but wonder if they'd prefer something else like Rocketers, Rocketmen (gender bias noted) or maybe even Rockettes? g What do you say, Rocket Software employees? Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ 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
Re: [U2] hpux to linux
I did a migration from SGI IRIX (RISC CPU) to RH AS 3 about 6 years ago. I've also done 2 other migrations from earlier to later versions of UV and the underlying OS just for hardware upgrades. The only differences with the OS change were: 1) As others have mentioned, I had to run fnuxi since I did an OS-level backup/restore. This was trivial, though. I just wrote a script that did the restore and executed fnuxi * in all the UV directories immediately afterward 2) I had to modify a number of shell scripts due to subtle changes in some of the OS-level command options. Most notably the echo command. There are other issues to consider that I always run into with any UV upgrade, regardless of platform. We have a number of customized VOC entries that differ from the installed versions and get wiped out by a UV upgrade. I have a file named VOC.MOD that I keep on the OS partition where copies of all the modified entries are stored. I copy that file onto the new platform and copy its entries into the UV VOC after the upgrade (and each test run). I keep similar files for any BPs and PROCs that need modification to work correctly on the new platform. It's typically utilities that end up in here. IBM changed the number of digits in spooler file IDs last time, for example, and it broke a number of our custom spooler utilities. It's hard for me to give a difficulty rating somewhere between easy and really hard. I guess I would say it's easy but time consuming. We have a different batch process for the first 3 weekends of each month as well as a month-end process. Testing each of those involves wiping out the UV data on the new server, restoring, and running the batch process (I change the SP.ASSIGN command so all the spooler files go to a dummy queue). When something breaks mid-way, I have to fix it and start all over. There's also a fairly long checklist of user applications that have to be tested. None of this is rocket science, but it does take quite a bit of time. I've done all the upgrades solo, and IIRC, it typically takes me a little over a month. Hope that helps. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Tuesday, October 06, 2009 9:38 AM To: U2 Users List Subject: [U2] hpux to linux We have Rocket's Universe 10.2 over hpux 11.11 but are considering moving to a linux box. Has anyone ported a U2 app from hpux to linux? I am trying to estimate for management how long such a porting might take. Just an opinion would be helpful, like 'easy', 'medium', 'hard', 'really hard'. Thanks- Harold Oaks Clark County This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ 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] UniObject .NET Session and Common Block Bug
Hi All,
I am trying to call 2 subroutines using the same session in UniObject .NET but
have an issue when the second subroutine Inserts a larger common block.
I call the first subroutine without any issues. But when I call the second
subroutine I get the following error.
[IBM U2][UODOTNET - UNICLIENT][ErrorCode=30105] Unable to load the subroutine
on the server
I only have this issue in .NET and not in VB6.
I believe that the .net UniSession is storing the Common Block variables and
when I try to call another subroutine with a different common block it fails to
load.
I have read in another post on the web that people have created a Common Block
loading subroutine to load all Common Blocks when they create the session.
This way when ever they call any subroutine they know the common block does not
increase.
This seems a like a hack to me.
I am worried that when ever a developer creates a new Common Block that they
have to remember to update the Common Block loading Subroutine.
Also we have thousands of Subroutines that may or may not include some common
blocks.
If a subroutine has the same variable name as a variable used in common block
it does not insert will its value change.
The other hack is to close and open the session every time I want to call a
subroutine.
But once again this is not suitable for my application.
Here is my common blocks in universe
- BP AH.COMMON1 ---
COMMON AHCOMMON1
- BP AH.COMMON2 ---
COMMON AHCOMMON2
Here are my two subroutines.
- BP SR.AHTEST.CALL1 -
SUBROUTINE SR.AHTEST.CALL1
$INSERT AH.COMMON1
RETURN
END
- BP SR.AHTEST.CALL2 -
SUBROUTINE SR.AHTEST.CALL2
$INSERT AH.COMMON1
$INSERT AH.COMMON2
RETURN
END
Here is the C# .net code
- C# .NET
UniSession ahsession = UniObjects.OpenSession(HOST, USERNAME,
PASSWORD, ACCOUNT, uvcs);
UniSubroutine ahsub1 =
ahsession.CreateUniSubroutine(SR.AHTEST.CALL1, 0);
ahsub1.Call(); // No Error on this call
UniSubroutine ahsub2 =
ahsession.CreateUniSubroutine(SR.AHTEST.CALL2, 0);
try
{
ahsub2.Call(); // Throws and exception
}
catch (UniSubroutineException ex)
{
MessageBox.Show(ex.Message); //Displays [ErrorCode=30105]
Unable to load the subroutine on the server
}
MessageBox.Show(Done);
If I write the same code in VB6 using the UniObject for VB6 I get no errors
- C# .NET
Dim objSession As Object
Set objSession = CreateObject(UniObjects.unioaifctrl)
objSession.UserName = USERNAME
objSession.Password = PASSWORD
objSession.AccountPath = ACCOUNT
objSession.HostName = HOST
objSession.Connect
Dim ahsub1 As Object
Set ahsub1 = objSession.Subroutine(SR.AHTEST.CALL1, 0)
ahsub1.Call
Dim ahsub2 As Object
Set ahsub2 = objSession.Subroutine(SR.AHTEST.CALL2, 0)
ahsub2.Call
MsgBox (Done)
Adrian Halid
Senior Analyst/Programmer
IT Vision Australia Pty Ltd (ABN: 34 309 336 904)
PO Box 881, Canning Bridge WA 6153
Level 3, Kirin Centre, 15 Ogilvie Road, Applecross, WA, 6153
P: (08) 9315 7000 F: (08) 9315 7088
E: adrian.ha...@itvision.com.au W: http://www.itvision.com.au
___
NOTICE : This e-mail and any attachments are intended for the addressee(s) only
and may
contain confidential or privileged material. Any unauthorised review, use,
alteration,
disclosure or distribution of this e-mail (including any attachments) by an
unintended recipient
is prohibited. If you are not the intended recipient please contact the sender
as soon as
possible by return e-mail and then delete both messages.
___
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 is now Rocket U2
What's in a name? BTW: I never liked Ardent Software...thank goodness that name hasn't been brought back... yet! :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Henry Unger Sent: Thursday, 8 October 2009 7:26 AM To: 'U2 Users List' Subject: Re: [U2] U2 is now Rocket U2 Funny you should ask. Andy Youniss, Rocket's CEO, was asked the question of the origination of Rocket last night at dinner, and the short answer was that at the time 20 years ago, he liked it. Although it may feel retro to some, I disagree that it carries a negative connotation. One of the leading companies in the commercialization of space today, Space Exploration Technologies, uses the term in its material on http://www.spacex.com. In addition, NASA is a Rocket customer. The reason that rocketship has not been used in science fiction in decades is for decades it has been fact, not fiction. Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com ** 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] hpux to linux; Solaris 2.6 to Solaris 10
A company decision to make everything Microsoft. -- From: Jeff Powell j...@powellclan.com Sent: Wednesday, October 07, 2009 1:25 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] hpux to linux; Solaris 2.6 to Solaris 10 Just out of curiosity, why are you moving to windows? Are there specific benefits? Thanks. On 10/07/2009 10:55 AM, jpb-u2ug wrote: We have moved from Unix V5 on Motorola, to Solaris 2.6, to Solaris 8, to RH Linux AS3, and are now in the process of moving to Windows 2008. ___ 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
Re: [U2] UniObject .NET Session and Common Block Bug
Hi Adrian I don't have problem with named commons. There is a problem if you update the parameters in a named common and you do not compile all the subroutines with the named common. If you call a routine that has not been recompiled you get a fatal, named common mismatch. Is that a possible issue for you. This is a general basic issue and is not an issue with .Net API. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniObject .NET Session and Common Block Bug
Try ahsub1.Dispose(); after ahsub1.Call();
Regards
Adrian Halid wrote:
Hi All,
I am trying to call 2 subroutines using the same session in UniObject .NET
but have an issue when the second subroutine Inserts a larger common
block.
I call the first subroutine without any issues. But when I call the second
subroutine I get the following error.
[IBM U2][UODOTNET - UNICLIENT][ErrorCode=30105] Unable to load the
subroutine on the server
I only have this issue in .NET and not in VB6.
I believe that the .net UniSession is storing the Common Block variables
and when I try to call another subroutine with a different common block it
fails to load.
I have read in another post on the web that people have created a Common
Block loading subroutine to load all Common Blocks when they create the
session.
This way when ever they call any subroutine they know the common block
does not increase.
This seems a like a hack to me.
I am worried that when ever a developer creates a new Common Block that
they have to remember to update the Common Block loading Subroutine.
Also we have thousands of Subroutines that may or may not include some
common blocks.
If a subroutine has the same variable name as a variable used in common
block it does not insert will its value change.
The other hack is to close and open the session every time I want to call
a subroutine.
But once again this is not suitable for my application.
Here is my common blocks in universe
- BP AH.COMMON1 ---
COMMON AHCOMMON1
- BP AH.COMMON2 ---
COMMON AHCOMMON2
Here are my two subroutines.
- BP SR.AHTEST.CALL1 -
SUBROUTINE SR.AHTEST.CALL1
$INSERT AH.COMMON1
RETURN
END
- BP SR.AHTEST.CALL2 -
SUBROUTINE SR.AHTEST.CALL2
$INSERT AH.COMMON1
$INSERT AH.COMMON2
RETURN
END
Here is the C# .net code
- C# .NET
UniSession ahsession = UniObjects.OpenSession(HOST,
USERNAME, PASSWORD, ACCOUNT, uvcs);
UniSubroutine ahsub1 =
ahsession.CreateUniSubroutine(SR.AHTEST.CALL1, 0);
ahsub1.Call(); // No Error on this call
UniSubroutine ahsub2 =
ahsession.CreateUniSubroutine(SR.AHTEST.CALL2, 0);
try
{
ahsub2.Call(); // Throws and exception
}
catch (UniSubroutineException ex)
{
MessageBox.Show(ex.Message); //Displays [ErrorCode=30105]
Unable to load the subroutine on the server
}
MessageBox.Show(Done);
If I write the same code in VB6 using the UniObject for VB6 I get no
errors
- C# .NET
Dim objSession As Object
Set objSession = CreateObject(UniObjects.unioaifctrl)
objSession.UserName = USERNAME
objSession.Password = PASSWORD
objSession.AccountPath = ACCOUNT
objSession.HostName = HOST
objSession.Connect
Dim ahsub1 As Object
Set ahsub1 = objSession.Subroutine(SR.AHTEST.CALL1, 0)
ahsub1.Call
Dim ahsub2 As Object
Set ahsub2 = objSession.Subroutine(SR.AHTEST.CALL2, 0)
ahsub2.Call
MsgBox (Done)
Adrian Halid
Senior Analyst/Programmer
IT Vision Australia Pty Ltd (ABN: 34 309 336 904)
PO Box 881, Canning Bridge WA 6153
Level 3, Kirin Centre, 15 Ogilvie Road, Applecross, WA, 6153
P: (08) 9315 7000 F: (08) 9315 7088
E: adrian.ha...@itvision.com.au W: http://www.itvision.com.au
___
NOTICE : This e-mail and any attachments are intended for the addressee(s)
only and may
contain confidential or privileged material. Any unauthorised review, use,
alteration,
disclosure or distribution of this e-mail (including any attachments) by
an unintended recipient
is prohibited. If you are not the intended recipient please contact the
sender as soon as
possible by return e-mail and then delete both messages.
___
___
U2-Users mailing list
Re: [U2] Security Measure. WAS: Migrating both OS and Universe Database
On Wed, October 7, 2009 4:28 pm, Anthony W. Youngman wrote: In message 663c35400910071056r188989b1x40a2e0b34083c...@mail.gmail.com, Kyle Moore kmo...@mooreimages.com writes lots deleted Just copy all the accounts across. Make sure they have entries in the UV.ACCOUNT file. If all the accounts are in the same directory, in the same filesystem, they don't need to be entered into UV.ACCOUNT. That's an 'undocumented feature' of UV that has been exploited to allow for privacy between accounts. If you have /u1/uvclientaccts1/... /u1(or 2, etc.)/uvclientaccts2/... and in each directory, several accounts setup, including source code/object code, database and application, the users who are in uvclientaccts1 can't logto the accounts in uvclientaccts2 without an absolute path and using the CHDIR command to do it. If you disable the CHDIR command (put a wrapper around it, for example) and DO NOT enter the accounts into UV.ACCOUNT, you have virtual account/client separation, thus meeting many security requirements. You have to _wrap_ SH, etc. too, of course. Just an FYI. Karl ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] hpux to linux
My apologies. It should be ipcs in every case, not icps... KLP On Wed, October 7, 2009 11:37 pm, Karl Pearson wrote: One other gotcha from traditional Unix to Linux, for administrators, is the icps command, which didn't use to exist, and which took 2 commands to replicate on Linux. I used the ipcs -mop command to retrieve information about the shared memory segments being used. The command in Linux doesn't use those switches. Your mileage may vary. Does anyone know for sure? I'm about the leave the U2 world as work is taking me a different direction. Actually, I was laid off and am seeking employment and it seems the opportunities in the U2 field are almost non-existent for someone who has to stay around to care for aging parents. Karl On Wed, October 7, 2009 7:58 pm, John Hester wrote: I did a migration from SGI IRIX (RISC CPU) to RH AS 3 about 6 years ago. I've also done 2 other migrations from earlier to later versions of UV and the underlying OS just for hardware upgrades. The only differences with the OS change were: 1) As others have mentioned, I had to run fnuxi since I did an OS-level backup/restore. This was trivial, though. I just wrote a script that did the restore and executed fnuxi * in all the UV directories immediately afterward 2) I had to modify a number of shell scripts due to subtle changes in some of the OS-level command options. Most notably the echo command. There are other issues to consider that I always run into with any UV upgrade, regardless of platform. We have a number of customized VOC entries that differ from the installed versions and get wiped out by a UV upgrade. I have a file named VOC.MOD that I keep on the OS partition where copies of all the modified entries are stored. I copy that file onto the new platform and copy its entries into the UV VOC after the upgrade (and each test run). I keep similar files for any BPs and PROCs that need modification to work correctly on the new platform. It's typically utilities that end up in here. IBM changed the number of digits in spooler file IDs last time, for example, and it broke a number of our custom spooler utilities. It's hard for me to give a difficulty rating somewhere between easy and really hard. I guess I would say it's easy but time consuming. We have a different batch process for the first 3 weekends of each month as well as a month-end process. Testing each of those involves wiping out the UV data on the new server, restoring, and running the batch process (I change the SP.ASSIGN command so all the spooler files go to a dummy queue). When something breaks mid-way, I have to fix it and start all over. There's also a fairly long checklist of user applications that have to be tested. None of this is rocket science, but it does take quite a bit of time. I've done all the upgrades solo, and IIRC, it typically takes me a little over a month. Hope that helps. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Tuesday, October 06, 2009 9:38 AM To: U2 Users List Subject: [U2] hpux to linux We have Rocket's Universe 10.2 over hpux 11.11 but are considering moving to a linux box. Has anyone ported a U2 app from hpux to linux? I am trying to estimate for management how long such a porting might take. Just an opinion would be helpful, like 'easy', 'medium', 'hard', 'really hard'. Thanks- Harold Oaks Clark County This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ 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 --- Karl Pearson ka...@ourldsfamily.com Owner/Administrator of the sites at http://ourldsfamily.com --- To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote. --Benjamin Franklin --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Karl Pearson ka...@ourldsfamily.com Owner/Administrator of the sites at http://ourldsfamily.com --- To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote. --Benjamin Franklin --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org
