AS400 CDC extract

Four Stars

AS400 CDC extract

Hi All,

We are doing CDC extract from AS400 and running the below command

ftp>open <<<Ftp_Server>>>


ftp>user <user_name> *********
230 <user_name> logged on.

ftp>cd CDC_DIR
250 "CDC_DIR" is current library.

ftp>quote rcmd "CDC_DIR/RUNCDC FILE(Sub/table) LIBOUT(CDC_DIR) MODE(*DETACHED) MBROPT(*ADD)"


ftp>quit

This command is using ftp utlitity to run the CDC command.  But our server is not ftp enabled.  Can we run the same command using sftp utility?

 

Thanks,

Arunachalam. S

 

Moderator

Re: AS400 CDC extract

Hello,

Usually, it is automatically executed via FTP by the Studio to install the RUNCDC program, restore the CDC library (the CDC database) and create the TSUBSCRIBERS table.

Do you want to manually call the RUNCDC program by yourself to write changes to the CDC table and use sftp utlitity instead?

Best regards

Sabrina

 
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: AS400 CDC extract

Hi,

Thanks for your reply.  FTP is not enabled between job server and AS400.  Waiting for SFTP access between those servers.  Once it is provided I am planning to use tSSH component to check on this.

 

Expecting this will work.

 

Thanks,

Arunachalam. S

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch