Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Donate Today!

Do you enjoy these
technical forums?
Donate Today! Click Here

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

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

Lizard (TechnicalUser) (OP)
18 Sep 01 10:15
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" _
        & "<PATH>\Upload_scheme.dtt")"

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

If I use the executable "cwbtf.exe" 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 (MIS)
18 Sep 01 11:51
Which is it ?  "/f" or "/t" ?  You've included both in your post ?

Bill.
Lizard (TechnicalUser) (OP)
19 Sep 01 2:48
Hi Bill,

It seems that "cwbuisxe.exe /f" and "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 [[[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 [[[filename] [/C] [...]] | [[/F] [list file]]]

Hope it will help others.

Olivier
ronze (Programmer)
19 Sep 01 8:35
Oliver,

Can you post the link you found for this info?

thanks
Christina
Lizard (TechnicalUser) (OP)
19 Sep 01 9:39
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 (Programmer)
18 Feb 02 5:39
Create .DTT or DTF file from the client access utility and set the autorun propperty true as show below

and execute "cwbtf.exe samp.dtt"

[Properties]
Check4Untrans=0
Convert65535=0
UseAlias=1
Notify=1
SQLStmt=0
AutoRun=1
AutoClose=1
ShowWarnings=0
UserOption=0
Guest (Visitor)
17 Jun 02 10:16
Hi,

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

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close