iseries stored procedures

marinalamarra — Sat, 16 Nov 2024 20:51:44 GMT

buongiono,

ho una connesione Isiries, ( vedi sotto) nel momento in cui lancio uan stored procedures, non restituisce nulla:

qualcuno mi puo aiurare ?

esempio di script:

la stgringa di commessione e'

OLEDB CONNECT TO [Provider=IBMDA400.DataSource.1;
Persist Security Info=True;
User ID=XXXXXX;
Password=XXXXXXX;
Data Source=XXX.XXX.XXX.XXX;
Protection Level=None;
Extended Properties="";
Initial Catalog="";

Transport Product=Client Access;
SSL=DEFAULT;
Force Translate=65535;
Default Collection="";
Convert Date Time To Char=TRUE;
Catalog Library List="";
Cursor Sensitivity=3;

Use SQL Packages=TRUE;

SQL Package Library Name="";
SQL Package Name="";
Add statements to SQL package=True;
Unusable SQL Package Action=1;

Block Fetch=True;
Data Compression=False;
Sort Sequence=0;
Sort Table="";
Sort Language ID="";
Query Options File Library="";
Trace=0;
Hex Parser Option=0;
Maximum Decimal Precision=31;
Maximum Decimal Scale=31;
Minimum Divide Scale=0;
Library List="";

Naming Convention=1;

Query Optimize Goal=0;
Query Storage Limit=-1;
Handle Numeric Data Errors=1;
Keep Trailing Blanks=False;
Application Name=QvConnect32.EXE;
Decfloat Rounding Mode=0;
Decfloat Error Option=0;
Client User ID="";
Client WorkStation Name="";
Client Program ID="";
Client Accounting="";
Block Size=0]
(mode is write);

TAB:

SQL CALL XXXXX

( XXXX e' ina procedura si Isiries)

( non mi restituisce nulla in TAB:)

topic iseries stored procedures in QlikView

iseries stored procedures