Re: ODBC problem when I load more than six columns... - Qlik Community

Report Inappropriate Content · ‎2012-11-23

Hi everybody,

I've a problem in my request, it works without problem in sql devlopper, but in QV, it returns a ODBC problem, but when I reduce the number of columns loaded in the sql select to six, it works, has anybody meet this problem befor?

FI: I use the version 9.

Here you are my script fot this request:

load

// "SAPLIGCOM_IDEODSART",

// "SAPPTFCOM_NUMCOM",

"ODSREFTPSJOU_DAT",

"SAPPTFCOM_IDEODSART",

"SAPPTFCOM_NUMCOM",

"SAPPTFCOM_QTECOM",

"SAPPTFCOM_MNTPST",

"SAPPTFCOM_QTECON",

"SAPPTFCOM_QTECOM"-"SAPPTFCOM_QTECON" as QT_RUPT;

SQL SELECT "SAPPTFCOM_QTECOM", "SAPPTFCOM_MNTPST", "SAPPTFCOM_QTECON","SAPPTFCOM_NUMCOM","SAPPTFCOM_IDEODSART","ODSREFTPSJOU_DAT"/*,"SAPLIGCOM_IDEODSART","SAPPTFCOM_NUMCOM",*/

FROM SAP_LIGCOM,ODS_REFTPS_JOU,SAP_PTFCOM,SAP_MAG

//where ODS_REFTPS_JOU.ODSREFTPSJOU_DAT between to_date('20/11/2012','DD/MM/YYYY') and sysdate

where ODS_REFTPS_JOU.ODSREFTPSJOU_DAT=to_date('22/11/2012','DD/MM/YYYY')

and ODS_REFTPS_JOU.ODSREFTPSJOU_IDE=SAP_PTFCOM.SAPPTFCOM_IDEODSDATPTF

and SAP_LIGCOM.SAPLIGCOM_IDEODS=SAP_PTFCOM.SAPPTFCOM_IDEODSLIGCOM

and SAP_LIGCOM.SAPLIGCOM_IDEODSMAG=SAP_MAG.SAPMAG_IDEODS

and SAP_LIGCOM.SAPLIGCOM_IDEODSDATCOM=ODS_REFTPS_JOU.ODSREFTPSJOU_IDE

and SAP_LIGCOM.SAPLIGCOM_IDEODSDIV=8

and SAP_LIGCOM.SAPLIGCOM_CODSTALIVCOM in ('A','B')

and (SAP_LIGCOM.SAPLIGCOM_CODSTACRE is null or SAP_LIGCOM.SAPLIGCOM_CODSTACRE='A' or SAP_LIGCOM.SAPLIGCOM_CODSTACRE='D')

and SAP_LIGCOM.SAPLIGCOM_IDEODSRAIREJCOM=1

and SAP_LIGCOM.SAPLIGCOM_IDEODSBLOLIV not in (20,22,23,24,48483)

and SAP_LIGCOM.SAPLIGCOM_IDEODSCANDIS in (15,16)

and (SAPMAG_CODMAG like 'MY%' or sapmag_codmag like 'A%' or sapmag_codmag like 'S%')

and SAP_PTFCOM.SAPPTFCOM_QTECON < SAP_PTFCOM.SAPPTFCOM_QTECOM;

Thanks you.

ZM

jvitantonio · ‎2012-11-23

Could you please provide us with the error?

Report Inappropriate Content · ‎2012-11-23

Thank's for your reply, here you are the error:

Anonymous · ‎2012-11-23

I can't read that error becaus its not in English. Why dont you use OLEDB? That's faster and less translation than ODBC?

I hope this helps!

MutliView

Report Inappropriate Content · ‎2012-11-23

The problem is not the ODBC, because when a reduce the number of columns, it works.

jvitantonio · ‎2012-11-23

Hi could you please attach the log file?

Open your QVW file. Go to Setting, Document Properties and check "Generate logfile". Then reload the file and a log file will be created in the same locationas yout qvw file. Post the results here please.

Anonymous · ‎2012-11-23

OK Let us start the analysis. Could you please provide the table details, columns, data types, length ?

e.g

COLUMN DATA TYPE LENGTH

ODSREFTPSJOU_DAT Varchar 2000

Regards

MultiView

Report Inappropriate Content · ‎2012-11-23

The result of the log:

23/11/2012 10:42:28: Début de l'exécution

23/11/2012 10:42:28: QlikView Version:9.00.7502.8

23/11/2012 10:42:28: 0002 SET ThousandSep=' '

23/11/2012 10:42:28: 0003 SET DecimalSep=','

23/11/2012 10:42:28: 0004 SET MoneyThousandSep=' '

23/11/2012 10:42:28: 0005 SET MoneyDecimalSep=','

23/11/2012 10:42:28: 0006 SET MoneyFormat='# ##0,00 €;-# ##0,00 €'

23/11/2012 10:42:28: 0007 SET TimeFormat='hh:mm:ss'

23/11/2012 10:42:28: 0008 SET DateFormat='DD/MM/YYYY'

23/11/2012 10:42:28: 0009 SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]'

23/11/2012 10:42:28: 0010 SET MonthNames='janv.;févr.;mars;avr.;mai;juin;juil.;août;sept.;oct.;nov.;déc.'

23/11/2012 10:42:28: 0011 SET DayNames='lun.;mar.;mer.;jeu.;ven.;sam.;dim.'

23/11/2012 10:42:28: 0015 CONNECT*Provider*XPassword*

23/11/2012 10:42:28: 0019 load SAPLIGCOM_NUMCOM,

23/11/2012 10:42:28: 0020 ODSREFTPSJOU_DAT,

23/11/2012 10:42:28: 0021 SAPPTFCOM_IDEODSART,

23/11/2012 10:42:28: 0022 SAPPTFCOM_QTECOM,

23/11/2012 10:42:28: 0023 SAPPTFCOM_QTECON,

23/11/2012 10:42:28: 0024 SAPPTFCOM_MNTPST,

23/11/2012 10:42:28: 0025 SAPPTFCOM_QTECOM-SAPPTFCOM_QTECON as QT_RUPT

23/11/2012 10:42:28: 0026 SQL SELECT SAP_LIGCOM.SAPPTFCOM_NUMCOM,

23/11/2012 10:42:28: 0027 ODS_REFTPS_JOU.ODSREFTPSJOU_DAT,

23/11/2012 10:42:28: 0028 SAP_PTFCOM.SAPPTFCOM_IDEODSART,

23/11/2012 10:42:28: 0029 SAP_PTFCOM.SAPPTFCOM_QTECOM,

23/11/2012 10:42:28: 0030 SAP_PTFCOM.SAPPTFCOM_QTECON,

23/11/2012 10:42:28: 0031 SAP_PTFCOM.SAPPTFCOM_MNTPST

23/11/2012 10:42:28: 0032 FROM SAP_PTFCOM,SAP_LIGCOM,ODS_REFTPS_JOU,SAP_MAG

23/11/2012 10:42:28: 0033 where ODS_REFTPS_JOU.ODSREFTPSJOU_DAT between to_date('22/11/2012','DD/MM/YYYY') and sysdate

23/11/2012 10:42:28: 0034

23/11/2012 10:42:28: 0035 and ODS_REFTPS_JOU.ODSREFTPSJOU_IDE=SAP_PTFCOM.SAPPTFCOM_IDEODSDATPTF

23/11/2012 10:42:28: 0036 and SAP_LIGCOM.SAPLIGCOM_IDEODS=SAP_PTFCOM.SAPPTFCOM_IDEODSLIGCOM

23/11/2012 10:42:28: 0037 and SAP_LIGCOM.SAPLIGCOM_IDEODSMAG=SAP_MAG.SAPMAG_IDEODS

23/11/2012 10:42:28: 0038 and SAP_LIGCOM.SAPLIGCOM_IDEODSDATCOM=ODS_REFTPS_JOU.ODSREFTPSJOU_IDE

23/11/2012 10:42:28: 0039 and SAP_LIGCOM.SAPLIGCOM_IDEODSDIV=8

23/11/2012 10:42:28: 0040 and SAP_LIGCOM.SAPLIGCOM_CODSTALIVCOM in ('A','B')

23/11/2012 10:42:28: 0041 and (SAP_LIGCOM.SAPLIGCOM_CODSTACRE is null or SAP_LIGCOM.SAPLIGCOM_CODSTACRE='A' or SAP_LIGCOM.SAPLIGCOM_CODSTACRE='D')

23/11/2012 10:42:28: 0042 and SAP_LIGCOM.SAPLIGCOM_IDEODSRAIREJCOM=1

23/11/2012 10:42:28: 0043 and SAP_LIGCOM.SAPLIGCOM_IDEODSBLOLIV not in (20,22,23,24,48483)

23/11/2012 10:42:28: 0044 and SAP_LIGCOM.SAPLIGCOM_IDEODSCANDIS in (15,16)

23/11/2012 10:42:28: 0045 and (SAPMAG_CODMAG like 'MY%' or sapmag_codmag like 'A%' or sapmag_codmag like 'S%')

23/11/2012 10:42:28: 0046 and SAP_PTFCOM.SAPPTFCOM_QTECON < SAP_PTFCOM.SAPPTFCOM_QTECOM

23/11/2012 10:42:29: Erreur: Erreur SQL :Une ou plusieurs erreurs se sont produites lors du traitement de la commande.

23/11/2012 10:42:29: ORA-00904: "SAP_LIGCOM"."SAPPTFCOM_NUMCOM": invalid identifier

23/11/2012 10:42:29:

23/11/2012 10:42:29: Ligne de script :SELECT SAP_LIGCOM.SAPPTFCOM_NUMCOM, ODS_REFTPS_JOU.ODSREFTPSJOU_DAT, SAP_PTFCOM.SAPPTFCOM_IDEODSART, SAP_PTFCOM.SAPPTFCOM_QTECOM, SAP_PTFCOM.SAPPTFCOM_QTECON, SAP_PTFCOM.SAPPTFCOM_MNTPST FROM SAP_PTFCOM,SAP_LIGCOM,ODS_REFTPS_JOU,SAP_MAG where ODS_REFTPS_JOU.ODSREFTPSJOU_DAT between to_date('22/11/2012','DD/MM/YYYY') and sysdate and ODS_REFTPS_JOU.ODSREFTPSJOU_IDE=SAP_PTFCOM.SAPPTFCOM_IDEODSDATPTF and SAP_LIGCOM.SAPLIGCOM_IDEODS=SAP_PTFCOM.SAPPTFCOM_IDEODSLIGCOM and SAP_LIGCOM.SAPLIGCOM_IDEODSMAG=SAP_MAG.SAPMAG_IDEODS and SAP_LIGCOM.SAPLIGCOM_IDEODSDATCOM=ODS_REFTPS_JOU.ODSREFTPSJOU_IDE and SAP_LIGCOM.SAPLIGCOM_IDEODSDIV=8 and SAP_LIGCOM.SAPLIGCOM_CODSTALIVCOM in ('A','B') and (SAP_LIGCOM.SAPLIGCOM_CODSTACRE is null or SAP_LIGCOM.SAPLIGCOM_CODSTACRE='A' or SAP_LIGCOM.SAPLIGCOM_CODSTACRE='D') and SAP_LIGCOM.SAPLIGCOM_IDEODSRAIREJCOM=1 and SAP_LIGCOM.SAPLIGCOM_IDEODSBLOLIV not in (20,22,23,24,48483) and SAP_LIGCOM.SAPLIGCOM_IDEODSCANDIS in (15,16) and (SAPMAG_CODMAG like 'MY%' or sapmag_codmag like 'A%' or sapmag_codmag like 'S%') and SAP_PTFCOM.SAPPTFCOM_QTECON < SAP_PTFCOM.SAPPTFCOM_QTECOM

23/11/2012 10:42:29: Erreur: Erreur SQL :Une ou plusieurs erreurs se sont produites lors du traitement de la commande.

23/11/2012 10:42:29: ORA-00904: "SAP_LIGCOM"."SAPPTFCOM_NUMCOM": invalid identifier

23/11/2012 10:42:29:

23/11/2012 10:42:29: Ligne de script :SELECT SAP_LIGCOM.SAPPTFCOM_NUMCOM, ODS_REFTPS_JOU.ODSREFTPSJOU_DAT, SAP_PTFCOM.SAPPTFCOM_IDEODSART, SAP_PTFCOM.SAPPTFCOM_QTECOM, SAP_PTFCOM.SAPPTFCOM_QTECON, SAP_PTFCOM.SAPPTFCOM_MNTPST FROM SAP_PTFCOM,SAP_LIGCOM,ODS_REFTPS_JOU,SAP_MAG where ODS_REFTPS_JOU.ODSREFTPSJOU_DAT between to_date('22/11/2012','DD/MM/YYYY') and sysdate and ODS_REFTPS_JOU.ODSREFTPSJOU_IDE=SAP_PTFCOM.SAPPTFCOM_IDEODSDATPTF and SAP_LIGCOM.SAPLIGCOM_IDEODS=SAP_PTFCOM.SAPPTFCOM_IDEODSLIGCOM and SAP_LIGCOM.SAPLIGCOM_IDEODSMAG=SAP_MAG.SAPMAG_IDEODS and SAP_LIGCOM.SAPLIGCOM_IDEODSDATCOM=ODS_REFTPS_JOU.ODSREFTPSJOU_IDE and SAP_LIGCOM.SAPLIGCOM_IDEODSDIV=8 and SAP_LIGCOM.SAPLIGCOM_CODSTALIVCOM in ('A','B') and (SAP_LIGCOM.SAPLIGCOM_CODSTACRE is null or SAP_LIGCOM.SAPLIGCOM_CODSTACRE='A' or SAP_LIGCOM.SAPLIGCOM_CODSTACRE='D') and SAP_LIGCOM.SAPLIGCOM_IDEODSRAIREJCOM=1 and SAP_LIGCOM.SAPLIGCOM_IDEODSBLOLIV not in (20,22,23,24,48483) and SAP_LIGCOM.SAPLIGCOM_IDEODSCANDIS in (15,16) and (SAPMAG_CODMAG like 'MY%' or sapmag_codmag like 'A%' or sapmag_codmag like 'S%') and SAP_PTFCOM.SAPPTFCOM_QTECON < SAP_PTFCOM.SAPPTFCOM_QTECOM

23/11/2012 10:42:41: Fin de l'exécution.

Anonymous · ‎2012-11-23

SAPPTFCOM_NUMCOM is not the correct column name?!

Report Inappropriate Content · ‎2012-11-23

I have four tables:

SAP_PTFCOM:

Nom NULL Type

------------------------- -------- ------------

SAPPTFCOM_IDEODS NOT NULL NUMBER

SAPPTFCOM_IDEODSDATPTF NOT NULL NUMBER

SAPPTFCOM_NUMCOM VARCHAR2(10)

SAPPTFCOM_NUMPOS NUMBER

SAPPTFCOM_IDEODSCONEXP NUMBER

SAPPTFCOM_IDEODSORGCOM NUMBER

SAPPTFCOM_IDEODSCANDIS NUMBER

SAPPTFCOM_IDEODSAGECOM NUMBER

SAPPTFCOM_IDEODSGRPVEN NUMBER

SAPPTFCOM_IDEODSZONDIS NUMBER

SAPPTFCOM_IDEODSDONORD NUMBER

SAPPTFCOM_IDEODSCLILIV NOT NULL NUMBER

SAPPTFCOM_IDEODSDATLIV NUMBER

SAPPTFCOM_IDEODSLIGCOM NUMBER

SAPPTFCOM_IDEODSLIEEXP NUMBER

SAPPTFCOM_NOMDONORD VARCHAR2(50)

SAPPTFCOM_REFCOM VARCHAR2(20)

SAPPTFCOM_IDEODSDATCRE NOT NULL NUMBER

SAPPTFCOM_IDEODSTYPCOM NUMBER

SAPPTFCOM_IDEODSRAICOM NUMBER

SAPPTFCOM_BL VARCHAR2(5)

SAPPTFCOM_MTCOM NUMBER

SAPPTFCOM_IDEODSDEV NUMBER

SAPPTFCOM_CRE VARCHAR2(3)

SAPPTFCOM_T_PO VARCHAR2(4)

SAPPTFCOM_IDEODSART NUMBER

SAPPTFCOM_DES VARCHAR2(50)

SAPPTFCOM_CODEAN VARCHAR2(20)

SAPPTFCOM_RE VARCHAR2(5)

SAPPTFCOM_QTECOM NUMBER

SAPPTFCOM_UVE VARCHAR2(5)

SAPPTFCOM_MNTPST NUMBER

SAPPTFCOM_IDEODSDATLIVPRE NUMBER

SAPPTFCOM_B VARCHAR2(5)

SAPPTFCOM_QTECON NUMBER

SAPPTFCOM_QTEBONLIV NUMBER

SAPPTFCOM_QTEPRE NUMBER

SAPPTFCOM_QTESOR NUMBER

SAPPTFCOM_QTEFAC NUMBER

SAPPTFCOM_TYPCOM VARCHAR2(13)

SAPPTFCOM_QTEENC NUMBER

SAPPTFCOM_MNTENC NUMBER

SAPPTFCOM_DONQTEPRE NUMBER

SAPPTFCOM_DONQTEBLO NUMBER

SAPPTFCOM_MNTBLO NUMBER

IDEDWHTRTCRE NOT NULL NUMBER

IDEDWHTRTMAJ NOT NULL NUMBER

SAP_LIGCOM:

Nom NULL Type

------------------------- -------- ------------

SAPLIGCOM_IDEODS NOT NULL NUMBER

SAPLIGCOM_NUMCOM VARCHAR2(10)

SAPLIGCOM_NUMLIGCOM NUMBER(6)

SAPLIGCOM_IDEODSORI NOT NULL NUMBER

SAPLIGCOM_IDEODSDIV NOT NULL NUMBER

SAPLIGCOM_IDEODSTYPCOM NOT NULL NUMBER

SAPLIGCOM_IDEODSCLIPAR NOT NULL NUMBER

SAPLIGCOM_IDEODSDATCREENR NUMBER

SAPLIGCOM_IDEODSDATLIVSOU NUMBER

SAPLIGCOM_IDEODSDOMCOM NOT NULL NUMBER

SAPLIGCOM_IDEODSGRPVEN NOT NULL NUMBER

SAPLIGCOM_IDEODSAGECOM NOT NULL NUMBER

SAPLIGCOM_IDEODSART NOT NULL NUMBER

SAPLIGCOM_UNIBAS VARCHAR2(3)

SAPLIGCOM_UNIVEN VARCHAR2(3)

SAPLIGCOM_IDEODSDEV NOT NULL NUMBER

SAPLIGCOM_VALCES NUMBER(15,2)

SAPLIGCOM_TAUCHA NUMBER(20,8)

SAPLIGCOM_PRINET NUMBER(13,2)

SAPLIGCOM_QUACOMUNIVEN NUMBER(15,3)

SAPLIGCOM_CODSTALIGCOM VARCHAR2(1)

SAPLIGCOM_CODSTAFAC VARCHAR2(1)

SAPLIGCOM_CODSTAINCLIGCOM VARCHAR2(1)

SAPLIGCOM_SOUTOT1 NUMBER(15,2)

SAPLIGCOM_SOUTOT2 NUMBER(15,2)

SAPLIGCOM_SOUTOT3 NUMBER(15,2)

SAPLIGCOM_SOUTOT4 NUMBER(15,2)

SAPLIGCOM_SOUTOT5 NUMBER(15,2)

SAPLIGCOM_SOUTOT6 NUMBER(15,2)

SAPLIGCOM_PRINETLIGCOM NUMBER(15,2)

SAPLIGCOM_NUMDOCREF VARCHAR2(10)

SAPLIGCOM_NUMLIGDOCREF NUMBER(6)

SAPLIGCOM_NUMCOMORI VARCHAR2(35)

SAPLIGCOM_IDEODSDATCOMORI NUMBER

SAPLIGCOM_CODTYPLIGCOM VARCHAR2(4)

SAPLIGCOM_IDEODSSOC NOT NULL NUMBER

SAPLIGCOM_IDEODSMAG NOT NULL NUMBER

SAPLIGCOM_IDEODSCENPRO NOT NULL NUMBER

SAPLIGCOM_SIG NUMBER(1)

SAPLIGCOM_IDEODSDATCOM NUMBER

SAPLIGCOM_IDEODSRAICOM NOT NULL NUMBER

SAPLIGCOM_IDEODSRAIREJCOM NOT NULL NUMBER

SAPLIGCOM_QUAUNIBAS NUMBER(15,3)

SAPLIGCOM_IDEODSNUMLOT NOT NULL NUMBER

SAPLIGCOM_NUMLOT VARCHAR2(10)

SAPLIGCOM_INDSUP VARCHAR2(1)

SAPLIGCOM_IDEODSDATSUP NUMBER

SAPLIGCOM_IDEODSLIEEXP NOT NULL NUMBER

SAPLIGCOM_IDEODSBLOLIV NOT NULL NUMBER

SAPLIGCOM_CODBLOFACCOM VARCHAR2(2)

SAPLIGCOM_CODBLOFACLIGCOM VARCHAR2(2)

SAPLIGCOM_IDEODSPRILIV NOT NULL NUMBER

SAPLIGCOM_CODSTACOM VARCHAR2(1)

SAPLIGCOM_CODSTAREJCOM VARCHAR2(1)

SAPLIGCOM_CODSTALIVCOM VARCHAR2(1)

SAPLIGCOM_CODSTACRE VARCHAR2(1)

SAPLIGCOM_CODSTABLOCOM VARCHAR2(1)

SAPLIGCOM_CODSTALIVLIGCOM VARCHAR2(1)

SAPLIGCOM_IDEODSREPVEN NOT NULL NUMBER

SAPLIGCOM_QAUDEL NUMBER(13,2)

IDEDWHTRTCRE NOT NULL NUMBER

IDEDWHTRTMAJ NOT NULL NUMBER

SAPLIGCOM_SOUMISSION VARCHAR2(10)

SAPLIGCOM_NUMCOMREC VARCHAR2(35)

SAPLIGCOM_NUMCOMCLI VARCHAR2(35)

SAPLIGCOM_REFCLIEXT VARCHAR2(12)

SAPLIGCOM_CODCONDPAY VARCHAR2(4)

SAPLIGCOM_UTICRE VARCHAR2(12)

SAPLIGCOM_IDEODSDATLIVPRE NUMBER

SAPLIGCOM_IDEODSCLILIV NUMBER

SAPLIGCOM_IDEODSCLIDONORD NUMBER

SAPLIGCOM_IDEODSCLIPAY NUMBER

SAPLIGCOM_IDEODSCLIFAC NUMBER

SAPLIGCOM_IDEODSCANDIS NUMBER

SAPLIGCOM_IDEODSORGCOM NUMBER

SAPLIGCOM_IDEODSFOUTRANS NUMBER

SAPLIGCOM_CODTAXART1 VARCHAR2(1)

SAPLIGCOM_IDEODSDATEPRIX NUMBER

SAPLIGCOM_IDEODSGRPCLI NUMBER

SAPLIGCOM_QUACIB NUMBER(20,8)

SAPLIGCOM_NUMLIGCOMORI VARCHAR2(20)

SAPLIGCOM_CODUTI VARCHAR2(3)

SAPLIGCOM_LIBUTI VARCHAR2(35)

SAPLIGCOM_NUMCOMHBL VARCHAR2(12)

SAPLIGCOM_REFRECHBL VARCHAR2(12)

SAPLIGCOM_NUMPOSCOMREFHBL VARCHAR2(6)

SAPLIGCOM_VER VARCHAR2(12)

SAP_MAG:

Nom NULL Type

---------------- -------- ------------

SAPMAG_IDEODS NOT NULL NUMBER

SAPMAG_CODMAG NOT NULL VARCHAR2(4)

SAPMAG_IDEODSDIV NOT NULL NUMBER

SAPMAG_LIB VARCHAR2(16)

IDEDWHTRTCRE NOT NULL NUMBER

IDEDWHTRTMAJ NOT NULL NUMBER

ODS_REFTPS_JOU

Nom NULL Type

------------------------- -------- -----------

ODSREFTPSJOU_IDE NOT NULL NUMBER

ODSREFTPSJOU_DAT DATE

ODSREFTPSJOU_NUMJOU NUMBER(2)

ODSREFTPSJOU_LIBJOU VARCHAR2(2)

ODSREFTPSJOU_NUMSEMANN NUMBER(2)

ODSREFTPSJOU_NUMMOI NUMBER(2)

ODSREFTPSJOU_NUMTRIMST NUMBER(1)

ODSREFTPSJOU_NUMSEMMST NUMBER(1)

ODSREFTPSJOU_NUMQUADRIMST NUMBER(1)

ODSREFTPSJOU_ANN NUMBER(4)

ODSREFTPSJOU_NUMSEMISO NUMBER(2)

ODSREFTPSJOU_ANNSEMISO NUMBER(4)

ODSREFTPSJOU_FLGMOI NUMBER(1)

ODSREFTPSJOU_FLGTRI NUMBER(1)

ODSREFTPSJOU_FLGQUA NUMBER(1)

ODSREFTPSJOU_FLGSEM NUMBER(1)

ODSREFTPSJOU_FLGANN NUMBER(1)

ODSREFTPSJOU_FLGOUV VARCHAR2(1)

ODSREFTPSJOU_PERIODE VARCHAR2(6)

ODSREFTPSJOU_CYCVEN VARCHAR2(6)

Thank's

Regards

ZM

ODBC problem when I load more than six columns in the sql select