Hallo zusammen ,

hat jemand erfahrung wie man von einem SQLRPGLE auf eine DB2(linux) zugreift.

WrkRDBDIRE eintrag vorhanden .
SQLPACKAGE auch auf beiden System vorhanden .
SQl Connect funktioniert auch nur ich bekomme keine Daten .


Hab mal 2 Wege aufprobiert .

Beim SQl: Select Count(*) into :Counter from Libaa.filebb
erhalte ich folgende Fehlermeldung

Message ID . . . . . . : SQL0727 Severity . . . . . . . : 30

Message . . . . : Evaluation of global variable *N in *N failed.
Cause . . . . . : An error occurred during evaluation of the DEFAULT clause
of global variable *N in *N. The SQLCODE associated with the failure is
204. The SQLSTATE is 42704. The message tokens are LIBaa.Filebb.
This failure may also indicate an error occurred on a system other than
DB2 for IBM i during implicit system action 5.
Recovery . . . : Refer to the joblog or see the product documentation for
more information regarding the detected error. Correct the error and try
the request again.


Bei

String1 = 'Select Max(PK) from Database.Libaa.FileBB';
Exec SQL Prepare DynCsrC1 From :String1;

erhalte ich folgendes

Message ID . . . . . . : SQL0204 Severity . . . . . . . : 30
Message type . . . . . : Diagnostic
Date sent . . . . . . : 08.07.15 Time sent . . . . . . : 10:46:25

Message . . . . : filebb in Libaa type *N not found.
Cause . . . . . : Filebb in Libaa type *N was not found. If the member
name is *ALL, the table is not partitioned. If this is an ALTER TABLE
statement and the type is *N, a constraint or partition was not found. If
this is not an ALTER TABLE statement and the type is *N, a function,
procedure, trigger or sequence object was not found.
If a function was not found, Fileaa is the service program that
contains the function. The function will not be found unless the external
name and usage name match exactly. Examine the job log for a message that
gives more details on which function name is being searched for and the name
that did not match.
Recovery . . . : Change the name and try the request again. If the object


Per STRSQl funktioniert es .


Gruss