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: 
Not applicable

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

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

13 Replies
jvitantonio
Luminary Alumni
Luminary Alumni

Could you please provide us with the error?

Not applicable
Author

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

Error.jpg

multiview
Creator II
Creator II

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

Not applicable
Author

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

jvitantonio
Luminary Alumni
Luminary Alumni

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.

multiview
Creator II
Creator II

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

Not applicable
Author

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.

multiview
Creator II
Creator II

SAPPTFCOM_NUMCOM is not the correct column name?!

Not applicable
Author

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