Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
marinalamarra
Partner
Partner

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