Re: ProData RDBConnect error "RDB9999 null"

[Peter Dow <petercdow@xxxxxxxxx>]

Hi Eric,

Yes, the RDBIMPORT command got results. Funny they don't have an 
RDBEXPORT command.

Anyway, the problem has been resolved -- I forgot to do a RDBExec that 
SELECTs the file I'm going to add records to. A little counterintuitive, 
but they need some way to relate the connection ID to the table you want 
to add records to, so it actually makes sense.

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx> /

On 5/11/2012 3:01 PM, DeLong, Eric wrote:
> Do you get any results if you try the RDBIMPORT command?  Is the remote table on another IBM i?  I had problems with their stock DB2I connection type, and had to create my own JDBC driver and connection string to get date and time formats to function correctly...
>
> -Eric DeLong
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Peter Dow
> Sent: Friday, May 11, 2012 3:44 PM
> To: RPG programming on the AS400 / iSeries
> Subject: ProData RDBConnect error "RDB9999 null"
>
> On a v5r4 machine running Prodata's RDBConnect software (RDB30), I'm
> trying to use RDBConnect to copy a table from one database to another.
> The RDBAddRec procedure gets an error and RDBError returns an error code
> of RDB9999 and error text of "null".  From looking at RDBMSGF, RDB9999
> is a general purpose message like CPF9898 or CPF9897.  The "null" isn't
> too helpful, but implies that some field is null.
>
> The table in question does have a field named MEMO, type G, which allows
> nulls. However, per the RDBConnect manual, I'm using a data structure
> that matches the output of the RDBFIELDS command, which omits the MEMO
> field.
>
> Has anyone used RDBConnect to add a record to a table that has a
> null-capable field?  I tried the Prodata community forum but no one has
> posted since 2008, and in any case, registration on the forum is disabled.
>
> --
> *Peter Dow* /
> Dow Software Services, Inc.
> 909 793-9050
> petercdow@xxxxxxxxx<mailto:petercdow@xxxxxxxxx>  /