Use the Debugger EBCDIC Tool

The Debugger EBCDIC tool enables you to

Access databases in EBCDIC format
Convert text files
Change Languages
Access various windows by using the Windows menu option

Access databases in EBCDIC format

Data sets are encoded in EBCDIC format for all AB Suite applications built on the MCP platform. The EBCDIC tool enables you to

View EBCDIC data sets in ASCII format.
Add data sets directly to a database.
Update/modify data in a database.
Delete data sets directly from a database.
Query data sets present in a database.

Viewing EBCDIC Data Sets in ASCII format

To view data sets from the Debugger EBCDIC tool menu, perform the following:

Open the Debugger EDCDIC Tool.
The Debugger EBCDIC tool menu appears.
Select Open Table on the Database menu option of the EBCDIC tool menu.
The Open Table dialog box appears.
Select a server from the Server Name list of the Open Table dialog box.
Note: By default, the server is local.
Select a database from the Database list of the Open Table dialog box.
Select a table from the Table list of the Open Table dialog box.
Click Open.
The selected table appears in ASCII format.

Adding Data

To add data sets directly to a database, perform the following:

Open the Debugger EDCDIC Tool.
The Debugger EBCDIC tool menu appears.
Select Open Table on the Database menu option of the EBCDIC tool menu.
The Open Table dialog box appears.
Select a server from the Server Name list of the Open Table dialog box.
Note: By default, the server is local.
Select a database from the Database list of the Open Table dialog box.
Select a table from the Table list of the Open Table dialog box.
Click Open.
The selected table appears.
Select Add on the Database menu option of the EBCDIC tool menu, or click on the Debugger EBCDIC Toolbar.
A new row is added to the open table.
Enter data directly into the table.
Select Save on the Database menu option of the EBCDIC tool menu, or click on the Debugger EBCDIC Toolbar.
The newly added data is saved in the database.

Updating/Modifying Data

To update/modify data sets in the database, perform the following:

Open the Debugger EDCDIC Tool.
The Debugger EBCDIC tool menu appears.
Select Open Table on the Database menu option of the EBCDIC tool menu.
The Open Table dialog box appears.
Select a server from the Server Name list of the Open Table dialog box.
Note: By default, the server is local.
Select a database from the Database list of the Open Table dialog box.
Select a table from the Table list of the Open Table dialog box.
Click Open.
The selected table appears.
Select the row that you want to update/modify in the open table.
Update/modify the necessary data.
Select Save on the Database menu option of the EBCDIC tool menu or click on the Debugger EBCDIC Toolbar.
The updated data is saved in the database.

Deleting Data

To delete data sets directly from a database, perform the following:

Open the Debugger EDCDIC Tool.
The Debugger EBCDIC tool menu appears.
Select Open Table on the Database menu option of the EBCDIC tool menu.
The Open Table dialog box appears.
Select a server from the Server Name list of the Open Table dialog box.
Note: By default, the server is local.
Select a database from the Database list of the Open Table dialog box.
Select a table from the Table list of the Open Table dialog box.
Click Open.
The selected table appears.
Select one or more rows that you want to delete in the open table.
Select Delete on the Database menu option of the EBCDIC tool menu, or click on the Debugger EBCDIC Toolbar.
The selected rows are deleted.
Select Save on the Database menu option of the EBCDIC tool menu, or click on the Debugger EBCDIC Toolbar.
The changes are saved in the database.

Querying the Database

To query data sets present in a database, perform the following:

Open the Debugger EDCDIC Tool.
The Debugger EBCDIC tool menu appears.
Select New Query on the Database menu option of the EBCDIC tool menu.
The Connect to Database dialog box appears.
Select a server from the Server Name list of the Connect to Database dialog box.
Select a database from the Database list of the Connect to Database dialog box.
Click Connect.
A database connection is established.
Enter the query in the Query window.
Select Execute SQL on the Database menu option of the EBCDIC tool menu, or click on the Debugger EBCDIC Toolbar.
The result set of the query appears on the Query window.

Converting Data Files

The EBCDIC tool enables you to, perform the following:

Create a new text file.
Update/Modify an existing text file.
Convert text files from EBCDIC to ASCII/Unicode and vice-versa.

Note: If you create a text file by using the EBCDIC tool, by default the file is saved in the EBCDIC format. To view the contents of the file in ASCII, you must open the relevant file using the EBCDIC tool.

Creating a New Text File

To create a new text file, perform the following:

Open the Debugger EDCDIC Tool.
The Debugger EBCDIC tool menu appears.
Select New File on the Extract File menu option of the EBCDIC tool menu.
A new window appears.
Enter text in the editor.
Select Save as on the Extract File menu option of the EBCDIC tool menu, or click on the Debugger EBCDIC Toolbar.
Enter a file name in the File Name list of the Save File As dialog box.
The new file is saved in the default location.
Note: To save a file in a different location, browse to the desired location and save the file.

Updating/Modifying an Existing Text File

To update/modify an existing text file, perform the following:

Open the Debugger EBCDIC tool.
The Debugger EBCDIC tool menu appears.
Select Open on the Extract File menu option of the EBCDIC tool menu.
The Open EBCDIC Extract File dialog box appears.
Browse to the location and select the file.
Click Open.
The content of the selected file appears on the editor.
Modify the content and select Save on the Extract File menu option of the EBCDIC tool menu, or click on the Debugger EBCDIC Toolbar.
The updated content is saved.

Converting Text Files

Text files can be converted from one format to another by using the EBCDIC Debugger tool or the Command line interface.

Notes:

The following is the list of input and the output file formats:

EBCDIC V24-K
UNICODE
ASCII
EBCDIC V24+K(Japanese)

Using the EBCDIC Debugger Tool

To convert files by using the EBCDIC Debugger Tool, perform the following:

Open the Debugger EBCDIC Tool.
The Debugger EBCDIC Tool menu appears.
Select Convert File on the Extract File menu option of the EBCDIC tool menu.
The Convert Extract File dialog box appears.
Click Browse to select the Input Extract File.
Select the Input file format.
Click Browse to specify a location and file name where the Output Extract file is available.
Select the Output file format.
Click Convert to convert the file.
The converted file is saved in the Output Extract file location.
Click Close.
The converted text file is saved.

Using the Command line Interface

To convert files by using the Command line Interface, perform the following:

Point to the bottom-left corner of the screen to enable the Start icon, click Start, and then click Run.
Type cmd in the Run dialog box and press Enter to open a Command Prompt.
In the command prompt, change the working directory to the folder where the text files are present.
Run the following command to convert the files:
```
EBCDICTool.exe /c <InputFile> <InputCharSet> <OutputFile> <OutputCharSet>   
```
Where:
- InputCharSet and OutputCharSet can be in any one of the following formats:
  - EBCDIC V24-K
  - UNICODE
  - ASCII
  - EBCDIC V24+K(Japanese)
- InputFile is the file to be converted.
- OutputFile is the converted file.
- The converted text file is saved.

Setting a Language

The EBCDIC tool enables the user to set a language by using the Options menu option of the EBCDIC tool menu. The two available languages are EBCDIC (V24-K) and Japanese (V24+K).

To change to a specific language, perform the following:

Open the Debugger EBCDIC Tool.
The Debugger EBCDIC Tool menu appears.
Select Settings on the Options menu option of the EBCDIC Tool menu.
The Settings dialog box appears.
Select a language from the displayed Character Set Mode.
Note: By default, the language is V24-K (EBCDIC).
Click OK.
The new language is set.

Accessing the Windows Menu Option

The windows menu option enables you to navigate to various open windows. It also enables you to close all the windows instantly. The windows menu option allows you to

Close all the windows.
Activate and close the opened windows.

Closing all windows

To close all windows, perform the following:

Select Close All Windows on the Window menu option of the EBCDIC Tool menu.
All open windows are closed.
Note: The application does not exit and only the opened windows are closed.

Activating and closing the opened windows

To activate and close the opened windows, perform the following:

On the Window menu option of the EBCDIC Tool menu, select Windows….
The Windows dialog box appears.
To open a particular window, select a window from the Windows dialog box and click Activate.
To close a window, select a window from the Windows dialog box and click Close Window(s).