Transaction Connection

Transaction Connection

Table of Contents

Transaction Connection

About This Book

Trademarks and Service Marks

Transaction Connection Overview

Transaction, Remote Validation, or Data Request Modes

Transaction Mode

Remote Validation Mode

Data Request Mode

Routing Incoming Transactions/Requests for Processing

Running Scripts Based on Time-Related Events

Elements of the TC Script Language

Using White Space, Blank Lines and Comments in TC Scripts

Using Environment Variables in TC Commands

Script Control Using If/Else

Script Control Using Do...While

Using AND, OR and NOT operators in If and While Statements

Delimited Transaction Fields

Check_XXX Command Logic Modes

Web Services

Web Services Setup

Web Services Examples

Logon and Logoff Scripts

SQL Statement Generation

Insert Statement

Update Statement

Select Statement

Free-Form SQL Statements

Using User Variables and Transaction Fields in SQL Statements

:sqlCurrentTime Macro

SQL Statement Lifetimes

Limit on SQL Statement Size

Binding to the Database

Using ODBC Database Connection(s)

ODBC Performance and Deadlocks

Configuring an ODBC Data Source

Handling Differences Between Database Types When Using ODBC

Adding Support for Other Database types to DBTYPE.INI

Using DBTYPE in an If Command

How TC Handles SQL Errors

10 SQL Error Handling Actions

RC_DB2.INI and RC_ODBC.INI

On Error Strings

Specifying SQLSTATE values

Fatal SQL Errors

Processing when the Database or Host Is Unavailable

Recommended Design Rules

TC User Variable Naming

Why Use Delimited Transaction Fields

Transaction Version Number

Inquiry ID tags

Creating the Script Command File

TC Script Examples

Inserting a Record into a Table

Updating a Record in a Table

Querying the Database Table

Using Free-Form SQL

Multiple ODBC Connections

Handling Remote Validation Request

Using the Utility IMBEDSCR.EXE to Create a Single Listing File

Starting Transaction Connection

Starting TC from the OS/2 STARTUP.CMD

Starting TC from a Command Line

Multiple TC Sessions

TC Session Window

Stopping Transaction Connection

Measuring and Improving Performance of TC Scripts

Execution Performance Timings

Increasing Processing Speed

Execution Information Display

Multiple TC Sessions

Database Performance

Sending Data to the Host Screen

Multiple DCT Transactions to a Host Screen

Testing and Debugging Your Scripts Using the Trace Command

Using TC to Generate Reports

Creating Reports from Host Screens

Creating Reports from the Database

Sending Reports to a DCT

Using One TC Session to Monitor / Control Other TC Sessions and the DCConnect Server

Script Commands

Database Insert Functions

Database Query (Select) Functions

Database Update Functions

DCConnect Interface Functions

Free-Form SQL Functions

Miscellaneous Database Functions

File Logging Functions

Flow-of-Control Functions

Host Screen Interaction Functions

Operating Mode Switches

Response to Terminal Functions

TC Control and Monitoring Functions

Transaction/Validation/Data Request Sorting Functions

User Variable Functions

Web Service Functions

Miscellaneous Functions

Command Reference

Append / Append_UV_Kbd_Data

Append_UV_Ctrl_ID

Append_UV_Cntlr_ID

Append_UV_Data_Part

Append_UV_File_Data

Append_UV_Host_Data

Append_UV_Kbd_Data / Append

Append_UV_Select_Data / Append_UV_Select_Data2

Append_UV_Seq_Num

Append_UV_Xact_Data

Begin_Select / Begin_Select2 / Begin_SQL / Begin_SQL2

Call_Subroutine

Change_Term_State / Change_Terminal_State

Check_Highlight

Close_Cursor / Close_Cursor2

Close_File_Data

Close_When_Complete

Commit_Changes / Commit_Changes2

Communication_Connect

Communication_Disconnect

Cycle_DCC/2_Export / Cycle_Mailbox

Deadlock_Timeout

Define_Large_UV_Size

Define_On_Error_String

Dont_Maintain_Window_Position

EndFunctionGroup / EndCluster

End_SQL / End_SQL2 / End_Select / End_Select2

EndSub / EndSubroutine

End_WS / EndWebService

Forward_Data_Request

Get_Application_List

Get_DCConnect_Status

Get_Mailbox_List

Get_Term_List / Get_Terminal_List

Get_Term_UV_Data / Get_Named_Term_UV_Data / Get_Terminal_UV_Data / Get_Named_Terminal_UV_Data

Initiate_Term_Event / Initiate_Terminal_Event

Insert_DB_Table

LDAP_AdminUnbind

LDAP_ChangePassword

LDAP_ValidateUser

Load_Term / Load_Terminal

Mailbox / Export

Make_Data_Request

Multi_Release_Mode

No_Display_Execute

No_Terminate_From_DCConnect

Perform_Fetch / Perform_Fetch2

Perform_Insert / Perform_Insert2

Quit_Subroutines

Reenable_Trace_Via_Restart

Reply_To_Data_Request

Report_Term_State / Report_Terminal_State

Report_Term_Version / Report_Terminal_Version

Resize_Both_Panes

Resize_Execution_Pane_Only

Resize_Messages_Pane_Only

Rollback_Changes / Rollback_Changes2

Run_Without_Connect

Run_Without_Session

Select_From_DB_Table

Select_Group_By

Select_Order_By

Send_Host_Data_Part

Send_Host_Kbd_Data

Send_Host_UV_Data

Send_Host_Xact_Data

Send_Named_Term_UV_Data / Send_Named_Terminal_UV_Data

Send_Term_Data / Send_Terminal_Data

Send_Term_IResp / Send_Terminal_IResp

Send_Term_UV_Data / Send_Terminal_UV_Data

Send_Term_VResp / Send_Terminal_VResp

Session_Connect

Set / Set_UV_Kbd_Data

Set_Emulator_Window

Set_UV_Cntlr_ID

Set_UV_Data_Part

Set_UV_File_Data

Set_UV_Host_Data

Set_UV_Kbd_Data / Set

Set_UV_Select_Data / Set_UV_Select_Data2

Set_UV_Xact_Data

Set_Xact_Time_Of_Origin

Setup_Insert_Field

Setup_Update_Field

Show_Thread_Messages

Shutdown_DCConnect

SQL_Buffer_Size

Start_Application

StartCluster / StartFunctionGroup

StartSubroutine

Start_WS / StartWebService

Submit_Client_Files

Submit_Validation

TC_Get_Active_Sessions

TC_Get_Session_Values

TC_Send_Session_Command

Trace

Trace_Delay_Limit

Update_DB_Table

Use_Adjusted_Xact_Time

Wait_Until_Unlocked

While (Do...While)

Workstation_Profile / WS_Profile

Write_To_Event_Log

Write_Xact / Write_Xact2x

WS_AddAttribute

WS_AddHTTPHeader

WS_Cleanup / WSCleanup

WS_CreateElement / CreateWSElement

WS_CreateRequest / CreateWSRequest

WS_CreateResponse / CreateWSResponse

WS_DefineNamespace

WS_DisplayExecutePopups

WS_EnterElement / WS_EnterElementXPATH / EnterWSElement

WS_GetAttribute

WS_GetElement / WS_GetElementXPATH / GetWSElement

WS_GetLastErrorText

WS_LeaveElement / LeaveWSElement

WS_NamespacePop

WS_NamespacePush

WS_SendRequest / SendWSRequest

WS_SendResponse / SendWSResponse

WS_SetElement / WS_SetElementXPATH / SetWSElement

WS_SetHTTPParameter

XML_AddAttribute

XML_CopyElement

XML_CreateElement

XML_DefineNamespace

XML_EnterElement

XML_GetField / XML_GetField2

XML_LeaveElement

XML_LoadLoggingParameters

XML_RedefineNamespaces

Commands Quick Reference

Using Oracle Stored Procedures/Functions

Using SQL Server Stored Procedures/Functions

Creating a Badge File at 4:00 a.m.

Verifying a Badge against the Database

Compile/Run Error Messages