MohammedNawazuddin613134

How to reduce time to move data from Automic vara to Text file

Discussion created by MohammedNawazuddin613134 on Jul 4, 2018
Latest reply on Jul 12, 2018 by FrankMuffke

In Automic vara I have 18,000 records which I need to move to text file.

I am using Automic scripting which is taking more than 4 hours to move data to Text file

 

:SET &QUERY_VAR# = &RESULT_VARA#

:SET &QUERY_VARA_COLUMN# = "2"
:SET &COLUMN#="COLNAME"
:SET &HND1# = CREATE_PROCESS(NEW)
:SET &LINE# = "LEGACY_PART_NUMBER"
:SET &LINE1# = ""
:SET &RET# = PUT_PROCESS_LINE(&HND1#,&LINE#)
:SET &RET# = PUT_PROCESS_LINE(&HND1#,&LINE1#)
:SET &PREFIX# = ""
:SET &HND2#=PREP_PROCESS_VAR(&QUERY_VAR#)
:PROCESS &HND2#
: PSET &VAL# = GET_PROCESS_LINE(&HND2#, &QUERY_VARA_COLUMN#)

: PSET &VAL2# = "&VAL#"
: SET &RET# = PUT_PROCESS_LINE(&HND1#,&VAL2#)


:ENDPROCESS
: PSET &FILEPATH# = "D:\AutomicFileStore\Spare Parts list active in CONA &DATE1#.txt"

:SET &RET# = WRITE_PROCESS(&HND1#,&FILEPATH#,AE_WIN01, AE01_WIN.LOGIN,OVERWRITE)

 

 

 

I am using the above scripting which is taking more than 4 hours.

 

Is there any logic so that time can be reduced to minutes in the above scripting.

Outcomes