× Discuss about Archiving, Close of Business, Delivery Setup, Security Management System, Global Processing etc…

TAFJ copy command

  • farainesuh
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 5 months ago #24199 by farainesuh
TAFJ copy command was created by farainesuh
can someone assist,

is this command working in TAFJ, how do i use it now

COPY FROM <folder> TO <folder>

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
More
1 year 5 months ago #24200 by VK
Replied by VK on topic TAFJ copy command
Hi
COPY FROM <data file> TO <folder> works
COPY FROM <folder> TO <folder> does not - gives the error "** Error [ 201 ] ** Unable to open file <folder>"

Why not use OS command instead?
 

Cheers
VK

Please Log in or Create an account to join the conversation.

  • farainesuh
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 4 months ago #24201 by farainesuh
Replied by farainesuh on topic TAFJ copy command
thank VK
am using this command on DBtools
COPY FROM F.AA.OVERDUE.SERVICE.FEES TO F.AA.OVERDUE.SERVICE.FEES.HIS

and am geting this below result, is there anything that im missing
T24@192.168.0.136:T24DB>COPY FROM F.AA.OVERDUE.SERVICE.FEES TO F.AA.OVERDUE.SERVICE.FEES.HIS

DBTools JQL P1:1 C1:1
Statement failed

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
More
1 year 4 months ago #24202 by VK
Replied by VK on topic TAFJ copy command
Hi
in COPY command you need to specify record @ID (or ALL for all records or to have an active saved list with required @IDs).

Cheers
VK

Please Log in or Create an account to join the conversation.

More
1 year 4 months ago - 1 year 4 months ago #24203 by kripesh
Replied by kripesh on topic TAFJ copy command
For COPY command here are few examples

COPY FROM TEST.BP TO UAT.BP  HELLO.WORLD.RTN - Copies the HELLO.WORLD.RTN record from Directory TEST.BP to UAT.BP

COPY FROM TEST.BP TO UAT.BP ALL - Copies all the records from Directory TEST.BP to UAT.BP

COPY FROM TEST.BP TO UAT.BP ALL OVERWRITING - Copies all the records from Directory TEST.BP to UAT.BP and if any records already exists in UAT.BP it will be overwritten

COPY FROM TEST.BP TO UAT.BP ALL OVERWRITING DELETING - Copies all the records from Directory TEST.BP to UAT.BP and if any records already exists in UAT.BP it will be overwritten. Additionally the records from the Source directory TEST.BP will be Deleted as well on successful copy.

COPY FROM TEST.BP TO UAT.BP SubRtn1,SubRtn2 - Copies the record SurRtn1 from Directory TEST.BP into another name SubRtn2.

Hope all the explanations above for COPY command is sufficient.

Have a great day !
Last edit: 1 year 4 months ago by kripesh.
The following user(s) said Thank You: farainesuh

Please Log in or Create an account to join the conversation.

  • farainesuh
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 4 months ago #24206 by farainesuh
Replied by farainesuh on topic TAFJ copy command
thanks VK

Please Log in or Create an account to join the conversation.

  • farainesuh
  • Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 4 months ago #24208 by farainesuh
Replied by farainesuh on topic TAFJ copy command
thanks VK, i have tried it has worked, thanks lots

Please Log in or Create an account to join the conversation.

Time to create page: 0.085 seconds