Move all records from a table to other enviroment

Hey all, i want to ask.
How to move all records from a table to other enviroment? Its same function with DL.DEFINE, but
DL.DEFINE we must define per record.

Example:
table CUSTOMER.
ID Name
001 A
002 B
003 C
004 d


if using DL.DEFINE we must define id customer
CUSTOMER
001
CUSTOMER
002
....
CUSTOMER
004

have t24 tools for make a pack table customer with all records?. because i want to move table customer with all records to another environment.

Thx

Create a local folder
jsh--> mkdir CUSTOMER.MOVE

Give full rights to local folder
jsh--> chmod -R 777 CUSTOMER.MOVE

Then copy the data from CUSTOMER to your new folder.

jsh--> SELECT FBNK.CUSTOMER
> COPY FROM FBNK.CUSTOMER TO CUSTOMER.MOVE

This will copy all data to this folder. Use some FTP utility to copy the CUSTOMER.MOVE to another environment and use the same command to move the data to CUSTOMER.

If you want to have an exact copy you might need to delete all the records from your second environment before you copy them. You should also make a backup before do this in case you get error that customers are missing.

Hi, jpb
OFS.BUILD.RECORD generate the OFS message without the NOINPUT fields, but there applications where there are fields that does not have this NOINPUT mark and even though they can not be update through OFS, because is updated by the core ACCOUNT application. For example, in ACCOUNT, field CURRENCY.MARKET (IN2&&NOCHANGE).
Do you know a work around to identify this kind of fields in an application?

BR

I think you can do this with the utility COPY.RECORDS.IHLD which is a mainline subroutine in T24. Long since I have used it.

Hi, kripesh
can you explain how it is used?
thanks
BR

Hi, kripesh
I have found references that indicate this is a very old tool used by TEMENOS when creating multi-company books. It was used before DL.DEFINE appears.
BR

Hi, jpb
I agree with your statement. And I tried that already, but faced the problem that some NOCHANGE fields need to be populate on OFS and others no.
For example, in ACCOUNT , you find in SS the following fields definition POSITION.TYPE (IN2SSS&&NOCHANGE), CURRENCY (IN2CCY&&NOCHANGE), CURRENCY.MARKET (IN2&&NOCHANGE).
If you generate the OFS with OFS.BUILD.RECORD it will included these 3 fields, but when the OFS message is processed CURRENCY.MARKET will launch an error, cause it can not be updated.
If you filter the NOCHANGE fields out of the generated OFS message, then you will get that CURRENCY is missing and that is a problem for no internal accounts.
That's why a made a post in here, trying to get a workaround
BR.

Yes. The OFS.SOURCE I'm using have FIELD.VAL to YES.

Hi, jpb
I'm using a regular comma version with NO.OF.AUTH = 0, EXC.INC.RTN = NO, GTS.CONTROL = NULL.

This is an example of what is going on. When generating OFS message using OFS.BUILD.RECORD, I can not exclude the NOCHANGE fields because I will loose CURRENCY and POSITION.TYPE, and both are needed. As a result I will have CURRENCY.MARKET in the message too, and that launch an error when it gets process.

This is an example:
jsh train ~ -->tSS OFSTELNET
<tSS version="1.1"><t24version>R13</t24version><t24pid>21865</t24pid><t24ofssource>OFSTELNET</t24ofssource><clientIP/></tSS>
ACCOUNT,/I/PROCESS/1/0/,INPUTT/123456/CU0010001/////,026999,CUSTOMER:1:1="3",CATEGORY:1:1="1000",ACCOUNT.TITLE.1:1:1="ACCOUNT TITLE",SHORT.TITLE:1:1="SHORT TITLE",POSITION.TYPE:1:1="TR",CURRENCY:1:1="USD",CURRENCY.MARKET:1:1="1",ACCOUNT.OFFICER:1:1="6901",OTHER.OFFICER:1:1="1102",LOCAL.REF:2:1="402010161",LOCAL.REF:3:1="S",PASSBOOK:1:1="NO",OPENING.DATE:1:1="20140717",ALLOW.NETTING:1:1="NO",HVT.FLAG:1:1="NO",
026999//-1/NO,CURRENCY.MARKET:1:1=NOINPUT FIELD
EXIT
jsh train ~ -->

These is the OFS.SOURCE definition
SOURCE.NAME....... OFSTELNET

---

1 DESCRIPTION....... OFSTELNET
2 SOURCE.TYPE....... TELNET
3. 1 LOGIN.ID....... any
5 MAX.CONNECTIONS... 10
14 LOG.DETAIL.LEVEL.. NONE
24 SYNTAX.TYPE....... OFS
26 GENERIC.USER...... INPUTTER
31 FIELD.VAL......... YES

BR