Re-directing the output of the CA-IDMS Server sample programs.

Products

• IDMS
• IDMS - Database
• IDMS - ADS

Issue/Introduction

Introduction:

The install of CA-IDMS/Server provides two sample programs, IdmsJcf and IdmsExample.java. They both generally allow the use to enter an ad-hoc SQL query and view the output. What else can I do with the output?

Instructions:

IdmsJcf

This is a program that uses the Windows GUI to allow the end user to interactively enter an SQL statement and have that statement executed via CA-IDMS/Server and see the result immediately. This output is displayed in the Windows dialog. It cannot be cut-and-paste at a text level so there is not much more that can be done with that data.

IdmsExample.java

This has much the same functionality as IdmsJcf but it doesn't use the Windows GUI. It runs is a DOS-box ("Command Prompt"), effectively a "batch" program. The SQL statements can be provided either as terminal input to the program or in an input file. The output is written as standard output to the terminal. As it runs as a DOS program, the output can be redirected like any other DOS program could be.

For example:

java example.IdmsExample url=jdbc:idms://usilca31:3765/appldb uid=XXXXXXX sqlin.txt > sqlout.txt

This will take the input SQL from file "sqlin.txt" and write the output to file "sqlout.txt".

Additional Information:

For more information, see the manual "CA IDMS Server User Guide r17"

Environment

Release: IDADSO00100-18.5-ADS-for CA-IDMS
Component: