Trying to launch an IBM Client Access Upload to AS/400 from VBA

[Lizard]

Hello,

I need to be able to launch an upload of a text file to a physical file on an AS/400. I'm using a VBA procedure that executes the following command line :

"Shell ("C:\Program Files\IBM\Client Access\cwbuisxe.exe /t" _
& &quot;<PATH>\Upload_scheme.dtt&quot&quot;

Unfortunately, It seems that it doesn't do anything. When I use the same executable &quot;cwbuisxe.exe&quot; with the option /f, I can run a download without problem (it accepts the specified parameters).

If I use the executable &quot;cwbtf.exe&quot; with the option /f, it launches the Client Access interface, but doesn't pick up the parameters.

Could anyone advice on this issue ?

Thanks.

Olivier

 

[bjverzal]

Which is it ? &quot;/f&quot; or &quot;/t&quot; ? You've included both in your post ?

Bill.

 

[Lizard]

Hi Bill,

It seems that &quot;cwbuisxe.exe /f&quot; and &quot;cwbtf.exe /t are both launching a download and taking into account the parameters. Using the same commands and inversing the options should logically launch the upload. Unfortunately, it doesn't.

However, I found the solution by searching the IBM support website. The executable to use are :
For the UPLOAD :
RFROMPCB [/S] [[[filename] [/C] [...]] | [[/F] [list file]]]
/S Show transfer statistics filename
A PC to AS/400 file transfer request (.TFR), a Rumba file transfer request (.RTO), or a Windows 3.1 transfer request (*.dt) file.
/C Process next file independent of previous file.
/F Process files within list file (one filename per line).
list file=A file containing a list of transfer files to process.

For the DOWNLOAD :
RTOPCB [/S] [[[filename] [/C] [...]] | [[/F] [list file]]]

Hope it will help others.

Olivier

 

[ronze]

Oliver,

Can you post the link you found for this info?

thanks
Christina

 

[Lizard]

Hi Christina,

The URL is

http://www.as400.ibm.com/tstudio/ca400/dtbtch2.htm

This site contains much more info than you can expect from the (very limited) Client Access Help.

Hope it helps.

Olivier

 

[rajeshsurve]

Create .DTT or DTF file from the client access utility and set the autorun propperty true as show below

and execute &quot;cwbtf.exe samp.dtt&quot;

[Properties]
Check4Untrans=0
Convert65535=0
UseAlias=1
Notify=1
SQLStmt=0
AutoRun=1
AutoClose=1
ShowWarnings=0
UserOption=0

 

[Guest_imported]

Hi,

How do you assess whether the transfer was sucessful from your VBA code?