Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How do I upload data to the AS/400 using the FileTransfer/OCX?

April 26, 2017Data filetransfer ocx upload

0

Posted

How do I upload data to the AS/400 using the FileTransfer/OCX?

1 Answer

0

Posted

You can upload data to the AS/400 using the TECA FileTransfer/OCX by using an SQL replace statement in the Buffer property of the TECA FileTansfer/OCX. For instance, to upload a source file to the AS/400 you could enter the following SQL statement in the TECA FileTransfer/OCX buffer property: REPLACE * INTO qgpl/qrpgsrc(member1) filetype(source) rcdlen(80) crtmbr(*yes) After setting the Buffer property you can set the ConvertAuto property to TF_TRUE, the FullFile property to TF_TRUE and the PCFile property to the name of your desired PC input file. Then evoke the SendRequest method followed by the SendRecords method. The member1 member will be created in the file qgpl/qrpgsrc. This simple example shows one option for uploading data to the AS/400. Many other options are also possible.