Printilan Ab Initio

dalam insert table ke database teradata mendapatkan error:

**** 13:19:16 Current CLI or RDBMS allows maximum row size: 64K
atau
========= Too many load/unload tasks running: try again later


hal tersebut dikarenakan bug di workload management Teradata


solusi sementara di Ab Inition


isi di parameter komponen input table
SLEEP = 30
TENACITY = 1


========session_error=================





**** 11:28:52 Teradata Database Release: 13.00.00.14
**** 11:28:52 Teradata Database Version: 13.00.00.15
**** 11:28:52 Current CLI or RDBMS allows maximum row size: 64K
**** 11:28:52 Character set for this job: ASCII
**** 11:31:54 CLI Error 301: CLI2: SESSOVER(301): Exceeded max number
              of sessions allowed.
**** 11:31:57 Number of FastLoad sessions requested = *
**** 11:31:57 Number of FastLoad sessions connected = 298
**** 11:31:57 FDL4808 LOGON successful


======== session di komponen table usahakan jangan bintang "*" kasih 16 aja atau 1 1 (1 space 1), karena kalau bintang akan meminta banyak session jika server tidak mencukupi maka akan muncul error seperti di atas=========



====penggunaan separator antar karakter===========



record
  decimal("\x07",0, maximum_length=15, sign_reserved) subs_no = NULL("") /*DECIMAL(14)*/;
  date("YYYY-MM-DD")("\x07") ddate = NULL("") /*DATE*/;
  utf8 string("\x07", maximum_length=400) topic = NULL("") /*VARCHAR(200) CHARACTER SET LATIN*/;
  utf8 string("\x07", maximum_length=1000) comments = NULL("") /*VARCHAR(500) CHARACTER SET LATIN*/;
  utf8 string("\x07", maximum_length=100) region = NULL("") /*VARCHAR(50) CHARACTER SET LATIN*/;
  string(1) newline = "\n";
end;


===============pemisah ditandai dengan karakter "\x07" biasanya "\x01", apapun boleh lah yang penting bisa mendapatkan data yg di inginkan====================






====komponen run program====
${SERIAL_DIR} -> is a directory in ab initio
${LANDING_DIR} -> is a directory in ab initio


find ${SERIAL_DIR}${LANDING_DIR} -size +22c -name 'Filename_*.zip' -exec ls {} \;


====getting file_list==========


to run command in abinitio klik F8 and write "echo ${SERIAL_DIR}"




===================================



In this example, string_filter_out compares the input strings "Apt. #2" and ".#,%". The function filters "." and "#" from the first string, returning "Apt 2":
string_filter_out("Apt. #2", ".#,%")   "Apt 2" 


====================================