Contact your system administrator for assistance. Post Your Answer Discard By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of service , privacy policy and cookie policy , and that your continued use of the website is subject to these policies. Richard has raised some issues to which I can add some technical information. In regards to the issues of arrays, redefinitions and multiple record definitions it is a matter of finding the best solution to meet your needs as the relational model does not support these structures. The SQL data model here is not distorted.

Uploader: Nelkree
Date Added: 25 March 2010
File Size: 35.46 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 31716
Price: Free* [*Free Regsitration Required]

Relativity will allow either model unrolled or spreadand has tools in the Designer to easily accomplish either. Thanks again, Cosmark RE: That should be enough to keep you going. I speculate liany this is due to the fact that the C programming language treats a binary zero character as the termination of a character string.

Register now while it’s still free!

Liant Relativity v12.04 Data Manager

Can any one help me with this plz? As an example assume a very simple example: Although some of the issues Richard mentions date back to the first releases of Relativity I do not think they are true any more. They do not have in-house support for RM Cobol they rely on outside Software houses for support, which is expensive but they have in-house knowledge in database design and development in MS Access. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.


c# – Confusion when creating ODBC Conecction string – Stack Overflow

Liant also has a CEO who takes customer feedback quite seriously. Please also let me add to the above the issue of support. However, this does not produce a very good relational data model. Close this window and log in. Please contact your system administrator for assistance.

Hi Cosmark, I am kind of suprised by Richards replies. Well, the company, a small, producing company, computerised their operations Accounting, Payroll, Stock control etc. Client-Server is appropriate to reduce network traffic: To “bring the system to the new century” is their expression.

Post as a guest Name. We have been working with big arrays and multiple record definitions and we are satisfied with the performance. The relational model does not have an analog multiple row types?!

I have been relativitg by a company which uses software developed in the early 80’s in RM Cobol and still uses the system in its original black-and-white form to “bring their system to the new century”.

Cosmark, Is there any reason why you need to keep the Cobol data files? In fact, Relativity’s preferred mode of operation would be to produce 12 rows informally called unrolling a table with a column for beginning-balance, payments-applied, ending-balance, Liatn another column based upon the occurance number implied by the definition — four columns in all.

Cosmark, from your description I think Relativity will do the job you want.

What happens if you try: By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies. Ljant Here to join Tek-Tips and talk with other members! Poorly constructed joins can cause any database to slow to a crawl.


ODBC Driver for RM/Cobol files (Relativity ONLY ?) – COBOL General discussion – Tek-Tips

If that error message is correct, you need to change the port number to the correct one, or fix the problem on the server side. In my opinion, it is best to set this up as two columns in the table i.

It would be better to produce 12 rows, with three columns. They have looked at various enterprise solutions, such as the SAP, but the cost and the anticipated interruption was prohibitive.

SELECT statements used in the application; it is unclear from your description whether your client has access to these. When you say “bring their system to the new century”, do you mean let them still use the Cobol data capture screens and let them use Access etc.