Frequently Asked Question


What is this?
Why I need Client Access?
Why I got errors about missing CWBAD.dll or CWBCO.dll files?
Why I get four (or more) different signon dialogs at the start?
Why I get error about "QCMDEXC" when opening an object?
Why I get "InternalError #6002" when opening application?
On complex query, Why I sometimes get error on "Create As/400 output" command?
Why only COBOL and not RPG?
Can I have source for this application?
Why development of this applications is so slow?
Could you implement the <something useful> feature?


=========================================================================
What is this?     Top
The main target for this application is to simplify handling of As/400 database files. I've started it as a project to re-create DDS for existing files. I've then integrated a lot of my other tools, as the Sql Query, source uploader, Cobol copy generator, Data file editor, Remote command launcher. A lot of other feature could be added (spool file handling, data queue editor, joblog check and so on), but the primary intent is to keep it simple and as faster as possible. In others word I do not want to rewrite Client Access.

Why I need Client Access?     Top
As400Expert use the Client Access (now known as ISeries Access) API to access As/400 objects.

Why I got errors about missing CWBAD.dll or CWBCO.dll files    Top
As stated in Faq 1 As400Expert use CA API, Especially the Data Access component. If you got message about missing .DLL, please relaunch the Client Access setup and make sure that Data Access component is selected.

Why I get four (or more) different signon dialogs at the startup    Top
This problem is caused by a configuration error. To solve:
Go to the menu File -> Config. Select General in the left tree. Please select an As/400 system from the dropdown combo.

Why i get error about "QCMDEXC" when opening an object?    Top
This problem is caused by a configuration error. To solve:
Go to the menu File -> Config. Select General in the left tree. Please select SQL (library.table) or SYS (library/object) on the "naming convention" field.

Why I get "InternalError #6002" when opening application?    Top
The As/400 error code "6002" means some missing configurations. Please open "ISeries Navigator" program and verify that you have at least one configured connection to As/400.

On complex query, Why I sometimes get error on "Create As/400 output" command?    Top
This is a known issues. When submitting query on the As400, sometimes the local Sql parser does not recognize the correct naming convention for the involved tables. This could be temporarly resolved using same naming convention in As400Expert and on the remote AS/400 (usually SYSTEM).

Why only COBOL copy and not RPG?    Top
I do not know RPG (and I do not want to learn it!).

Can I have source for this application?     Top
I'm currently working on this. I'd like to publish this application in a Open Source way. But it's a very difficult task, because the high number of customized components and functions I've used. For now, if you are interested in some specific area (for example "how did you make CAWIN32 works on Delphi 6?"), please ask and I'll try to extract the specific snippet of code.

Why development of this application is so slow?     Top
Please remember that I develop this application mostly during launch times (it's so difficult to program with a sandwich in a hand!) or unpaid overtime. I do not have any AS/400 at home to try.

Could you implement the <something useful> feature?     Top
As stated before, I don't have lot of time to implement new feature, but ask anyway and I'll try to do it when possible.