Keyboard Mapping for Telnet T24 Classic

Ctrl + U =  F1
Ctrl + B = F2
Ctrl + F = F3
Ctrl + E = F4
Ctrl + V = F5

Report Generator (REPGEN)

The Report Generator utility provides a mechanism for defining and producing ad-hoc reports, which can be run on-line or within the Close of Business Batch process.

Creating the Report steps :
ex: creating ACCT.LIST.DAUS
1. REPGEN.CREATE
REPORT.NAME……. ACCT.LIST.DAUS
——————————————————————————
1. 1 REPORT.TITLE… LIST OF ACCOUNT
3 USING.132.COLUMNS. Y
4. 1 LANGUAGE.CODE.. 1 English
5. 1 READ.FILE…… ACCOUNT
11. 1 DEFINE.MNEMONIC ACC.NUM
13. 1. 1 MNEMON.FIELD 1 CUSTOMER
14. 1. 1 MODIFICATION REPLACE
15. 1. 1 MODIF.FILE.. CUSTOMER CUSTOMER
16. 1. 1 MODIF.FIELD. 2 XX.LL.SHORT.NAME
19. 1 NUMBER.OF.CHAR. 35
23. 1 DISPLAY.TYPE… 2 LINE
11. 2 DEFINE.MNEMONIC CUS.NUM
13. 2. 1 MNEMON.FIELD 1 CUSTOMER
19. 2 NUMBER.OF.CHAR. 6
20. 2 SPECIAL.MASK… R######
21. 2 MASK……….. R######
22. 2 KEY.TYPE……. 1 SEQUENCE CONTROL
23. 2 DISPLAY.TYPE… 2 LINE
11. 3 DEFINE.MNEMONIC CUS.NAME
13. 3. 1 MNEMON.FIELD 3 ACCOUNT.TITLE.1
19. 3 NUMBER.OF.CHAR. 35
23. 3 DISPLAY.TYPE… 2 LINE
11. 4 DEFINE.MNEMONIC ACCT.BALANCE
13. 4. 1 MNEMON.FIELD 27 WORKING.BALANCE
19. 4 NUMBER.OF.CHAR. 8
20. 4 SPECIAL.MASK… R########
21. 4 MASK……….. R########
23. 4 DISPLAY.TYPE… 2 LINE
76 SORT.FILE.TYPE…. 2
77 SORT.FILE.MODULO.. 11
83 SPECIAL.HEADING… STANDARD
86 DATE.TIME.COMPILER 27 JUN 08 14:44
87. 1 CO.CODE.SORT… GB-001-0001
88. 1 DATE.TIME.SORT. 27 JUN 08 14:59
95 CURR.NO……….. 2
96. 1 INPUTTER……. 32_USER,___OFS_BROWSERTC
97. 1 DATE.TIME…… 27 JUN 08 14:38
98 AUTHORISER…….. 34_ATIDAUS2
99 CO.CODE……….. GB-001-0001 R8 MODEL BANK
100 DEPT.CODE……… 1
After commit it, then authorize.

2. REPGEN.SORT
KEY…………… ACCT.LIST.DAUS
——————————————————————————
1. 1 DESCRIPTION…. Account List by Daus
2 REPORT.NAME……. ACCT.LIST.DAUS LIST OF ACCOUNT
3 DATE.TIME.COMPILER 27 JUN 08 14:44
4 DATE.TIME.SORT…. 27 JUN 08 14:59
10. 1 DATE.TIME…… 27 JUN 08 14:59
11 AUTHORISER…….. 37_ATIDAUS2
12 CO.CODE……….. GB-001-0001 R8 MODEL BANK
Commit it.

3. REPGEN.OUTPUT
KEY…………… ACCT.LIST.DAUS
——————————————————————————
1. 1 DESCRIPTION…. Account List by Daus
2 DISPLAY.OR.PRINT.. DISPLAY
3 REPORT.NAME……. ACCT.LIST.DAUS LIST OF ACCOUNT
4 DATE.TIME.COMPILER 27 JUN 08 14:44
5 DATE.TIME.SORT…. 27 JUN 08 14:59
13. 1 DATE.TIME…… 27 JUN 08 15:00
14 AUTHORISER…….. 37_ATIDAUS2
15 CO.CODE……….. GB-001-0001 R8 MODEL BANK
Commit it.

4. Logout and login again

5. REPGEN.SOURCE

6. Verify ACCT.LIST.DAUS record of REPGEN.SORT and REPGEN.OUTPUT (at Classic)

7. The output result will show

For more detail see on Report Generator.pdf

Data Library: Moving Data between T24 Environment

Step:
Ex: Data library ACCOUNT
1. LRT I ACCOUNT
2. Note all local ref table
3. Then check the local table with LT <no local ref table> , and note if there is application vetting
4. Do it until finish
5. DL.DEFINE
6. Input the DL Name (ex: LTACCT) and Input all local table with File Name = LOCAL.TABLE, record name follow each local table number
7. Commit -> Verify -> Commit (Operation field will automatically change from S to R)
8. Copy folder which name similar to DL Name (ex: ALSA001-LTACCT) from F.DL.DATA to other environment folder (F.DL.DATA > DL.RESTORE)
9. Log to classic
10. DL.PARAMETER V SYSTEM
11. Input DL folder name (ALSA001-LTACCT) to field no 6.1
12. Commit
13. DL.DEFINE V ALSA001-LTACCT –> Commit
14. DL table will be HLD status, after Commit it the status will be INAU. It must be authorized.

To simplify making DL, create list file first and put it into &SAVEDLIST& folder, and at field 6 (SELECT.LIST) of DL.DEFINE input the list file that you’ve created.

New Template Programming at T24 R08

There are 2 template programming files must be created:
ex : BI.H.BANKER.CHEQUE and BI.H.BANKER.CHEQUE.FIELDS

At the .FIELDS file to add define a fields use the function below :
– Table.addfield()
– Table.addFieldDefinition() –> it can be use to set the length of field

To develop the template programming was created, use EB.DEV.HELPER application. It will create :
– PGM.FILE
– FILE.CONTROL
– INSERT
– CREATE FILE
at once.

EAF: Create Automatic Authorize or Other Function

Steps for automatic authorize record with equal INAU

1. EAF I <EAF Name>

– Selection : WITH RECORD.STATUS EQ INAU

– Function : A

– Sample.size : 1

– 1. Input.buffer : ID

– 2. Input.buffer : F5

2. EAF V <EAF name>

3. Commit and Y

Enquiry Report (Text File)

Step :

1. create routine at .BP folder (ex: BSMI.BP)

2. SS,

3. Enquiry

4. REPORT.CONTROL

5. ENQUIRY.REPORT (Verify)

6. See Hold Control List (at desktop: Menu Report->List of Report->K.USER LK …DAUS…)

Template Programming T24 > R7

Template programming Step
1. FILE.CONTROL
2. CREATE.FILES (at t24 classic)
3. Template Code
4. EB.COMPILE
5. PGM.FILE
6. FILE.LAYOUT (at JBase shell)
7. SS,

Create version: (for eMerge DDL from excel file)

VI BI.LOCATION.CODE, (at desktop)

Field contain :

-Records per page = 1
-Field per line = 1
-No Of Auth = 0

Create FILE.CONTROL via shell :

COPY FROM F.FILE.CONTROL TO F.FILE.CONTROL <APP SOURCE>,<APP TARGET> OVERWRITING

For editing :
JED F.FILE.CONTROL <APP>