support: Customer Portal
Focused on delivering choice, investment protection and flexibility to organizations with valuable COBOL assets
 

Veryant Knowledge Base
Home > All Categories > Data Access > How to access files on a different server
Question Title How to access files on a different server

Question:

Can we run a program in server 1 and update the data to database sitting on server 2?

Answer:

Yes!
If you are accessing an RDBM you can use the iscobol.jdbc.url property to point to the data server.
For instance, your url to connect to a SQL Server database on server 2 might look like this:

   iscobol.jdbc.url=
   jdbc:sqlserver://server2-ip-address:1433;user=sa;password=sa;encrypt=false;DatabaseName=master
If you are using indexed, sequential or relative files you can use the isCOBOL File Server to access your data files on server 2 from your programs on server 1.
Here are the steps:
  • Start the File Server on server 2.
    Your command might look like this:
       iscserver -fs -hostname server2-ip-address
    
  • Set the iscobol.file.prefix property using remote isf protocol.
    The setting might look like this:
    iscobol.file.prefix=isf://server-ip-address:/path/to/data
    
There are many additional options and settings for running the file server and using remote isf protocol.
Please check the documentation for the isCOBOL File Server in the isCOBOL Application Server documentation.

Authored by: Veryant Support This question has been viewed 105 times so far.
Click Here to View all the questions in Data Access category.
File Attachments File Attachments
There are no attachment file(s) related to this question.
How helpful was this article to you?
User Comments User Comments Add Comment
There are no user comments for this question. Be the first to post a comment. Click Here
Related Questions Related Questions
  1. File Types Comparison : isCOBOL - Micro Focus COBOL - ACUCOBOL-GT - RM/COBOL
  2. How do I interpret file status 9? and other EXFS extended file status codes (e.g. 9i,105)?
  3. What format does isCOBOL use for ORGANIZATION RELATIVE files?
  4. What is 9l,10 error and why is it happening?
  5. Does isCOBOL support Data General file status codes?
  6. Can we use Micro Focus data format and indexed files directly or do they need some type of conversion?
  7. Can I install the UDBC 32 bit on my 64 bit computer in order to have the Veryant * driver for ODBC32 bits Administrator?
  8. Can I call from an isCobol program a stored procedure?
  9. Why do I get the error message “java.lang.ClassNotFoundException: ctree2" ?
  10. Are Veryant's isCOBOL JISAM data format the same as Faircom's c-treeRTG?
  11. Why do I get 'ct_init ERROR 19:133:0' ?
  12. Did you know you can use an alias to map a different disk file name to an existing "assign to" clause of the select statement without source code changes?
  13. Did you know you can encrypt an indexed file?
  14. Handling the extension on indexed data files
  15. How to hide the user and password used to connect to an RDBMS
  16. Can we use Micro Focus format data and indexed files directly or do they need some form of conversion?
  17. How to create, write, and read to files without a program
Article Information Additional Information
Article Number: 333
Created: 2022-11-07 8:05 AM
Rating: No Rating
 
Article Options Article Options
Print Question Print this Question
Email Question Email Question to Friend
Export to Adobe PDF Export to PDF File
Export to MS Word Export to MS Word
Bookmark Article
Subscribe to Article Subscribe to Article
 
Search Knowledge Base Search Knowledge Base



 
 

© Veryant - All Rights Reserved
Veryant and isCOBOL are trademarks or registered marks of Veryant in the United States and other countries. All other marks are the property of their respective owners.