AS/400 >> 36E to Client Access

by Stuart Meier » Sun, 29 Feb 2004 08:32:54 GMT

I need to access some 36 data files and copy them to a PC. When I was
using S/36 I could use Client access to reach these files if I had them
defined/Linked in a Data Dictionary. Does anyone know how to do this
with 36E files ?



AS/400 >> 36E to Client Access

by arrowcomputer » Mon, 01 Mar 2004 20:37:21 GMT


Depends what you want to do with them on the PC. You can use client
access RTOPC or FTP to copy them, as you would any other AS/400 file.
The problem is: They come across a one large field, eg no field
definitions. I haven't tried using IDDU-defined files this way.

One possbile option is to create a new AS/400 file with the fields
defined. Then just CPYF the 36E file to the new file with
FMTOPT(*NOCHK). If you have defined the fields in the new file in the
correct sequence, type, and length, you now have a database file you
can do anything with.

AS/400 >> 36E to Client Access

by Stuart Meier » Tue, 02 Mar 2004 09:33:28 GMT

I've used the cpyf method when we had S/36 "subsystems" on the AS400. I surprised that IDDU
won't work with the fields described. We need to move the data into different apps.

AS/400 >> 36E to Client Access

by Peter Kinsman » Wed, 03 Mar 2004 02:20:49 GMT

If you use stridd you can create field, format and file definitions and then
use lnkdtadfn to link a file data definition to the actual file, but I think
file transfer will still treat it as a single field. As long as there are
no packed fields, you could use query to split the file into fields and file
transfer will pick up the individual fields or you could use cpytoimpf to
copy it to a csv file in the IFS. Presumably the files are in QS36F at
present. In the past, I have copied files from the AS/400 to a PC with no
conversion and then run a VB program which uses the field descriptions from
RPGII F & I specs to create a corresponding Access table. I can let you
have details if you are interested.

Peter Kinsman



surprised that IDDU
different apps.



them

Similar Threads

1. client access screen covers windows taskbar - but only client access does this

hadnt seen this before.

when a particular user has client access open, she now longer sees her 
windows taskbar at the bottom of the screen.

but - for all OTHER applications, the taskbar is there.

taskbar is not on autohide.

the screen is just black at the bottom.

anybody seen this before?

not a big issue, and she can of course do alt-tab to alternate between 
screens, but whe really likes just clicking on the different screens with 
her mouse to switch between applicatons.

gary


2. Client Access Download To Excel - Excel Format? - AS/400

3. HLLAPI and Client Access Express

We have an application running under NT and Client Access  that
"screen scrapes" information into an AS/400 using HLLAPI.

This application was recently upgraded to run under Windows 2000 and
Clients Access Express 5.1.

The application runs OK with the exception that the GBP (pound) sign
crashes the AS/400 application with the message "Character less than
Hex 40"

I would assume that something is going amiss with translation tables
but I do not know where to start looking.

Any advice or pointers would be gratefully received.

If it is of any relevance, 5250 emulation running on the same PC can
quite happily handle the Pound sign


Thanks for any help

4. Client Access Printing with Arial Font - AS/400

5. Client access connection problems - CWBCO1008

I am having trouble connecting to my 270 using client access through a
linksys router on my home network. Although I dont think the linksys
router has anything to do with the problem. I am able to connect with
mochasoft and telnet. But when I do a verify connection in client
access I get the following:
-----------------------------------------------------------------------------------------------------------------------------------
System name is a valid address
           CWBCO1044 - Remote address 192.168.1.110
           CWBCO1040 - Using remote port lookup mode: Always use remote
server mapper
           Attempting to establish a connection...

           CWBCO1045 - Local address 192.168.1.101:3501
           Connected to as-svrmap (192.168.1.110:449)
           Successfully connected to iSeries server mapper
           CWBCO1022 - Remote port 8470 will be used
           Attempting to establish a connection...

           CWBCO1045 - Local address 192.168.1.101:3502
           Connected to as-central (192.168.1.110:8470)
           Security validation in progress...
           CWBCO1008 - Unable to connect to server application Central
Client, returned 8007
      CWBCO1008 - Unable to connect to server application Network File,
returned 8007
------------------------------------------------------------------------------------------------------------------------------------
It seems to fail during the security validation. I have already checked
the QUSER id as per IBM's documentation which looks fine. The only
message I can find on the 270 is this:
------------------------------------------------------------------------------------------------------------------------------------
Job 001651/QUSER/QZRCSRVSD started on 02/25/06 at 11:55:01 in subsystem

  QSYSWRK in QSYS. Job entered system on 02/25/06 at 11:55:01.

Job 001651/QUSER/QZRCSRVSD submitted.

Object changed.

Object changed.

Host server communications error occurred on SSL_Init_Application().

Host server error occurred with reason code 5.

Host server error occurred with reason code 5.

-------------------------------------------------------------------------------------------------------------------------------------
This IBM program relates to secure sockets which I dont want to use and
cant find any reference to in the client access config on the PC.
When I try to connect if I check the TCP/IP connection status screen on
the 270 I can see my PC's IP address in a Time-Wait status.
--------------------------------------------------------------------------------------------------------------------------------
192.168.1.101    2556       as-svrmap  000:00:17  Time-wait
192.168.1.101    2558       as-svrmap  000:00:03  Time-wait
192.168.1.101    2560       as-svrmap  000:00:03  Time-wait
---------------------------------------------------------------------------------------------------------------------------------

The SSL_Init_Application() error is calling for the feature 5722-AC3 to
be loaded which I dont have. Is it mandatory to have this feature
loaded to connect using client access,

I sure would appreciate any help on this as I have run out of things to
try. 

Thanks in advance,

Terry Hole

6. Client Access printer - OKI 320 - AS/400

7. Whats the name of client Access Express's API who transfer files between PC- AS400

Hello friends,
     Thanks for helping me out in my NetServer problems. Now i have
some queries regarding client Access Express's APIs.
1... I want to know the exact name of client Access Express API that
does the file transfer from PC to AS400 and vice versa. I want to
transfer programmingly AFP resources from PC to AS400 through client
Access Express transfer routines.

2... Can Client Access Express Transfer routines also transfer AFP
resources as, apprarently from client Access's transfer utility's UI,
we can only transfer database files.

As before, yr kind suggestions would be very helpful for a person like
me who is new in AS400 world. Thanks in advance for yr concern and
help.

kind regards,
Umer

8. AS/400 newbie - Client Access Toolkit - CWBSO_OpenList/CWBSO_GetListSize takes forever - AS/400