Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
marinalamarra
Partner - Contributor
Partner - Contributor

iseries stored procedures

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:)

 

 

 

Labels (1)
0 Replies