DB2 one more time..

[Brian Stephens]

I am still trying to get PH on windows to talk to DB2 on ISeries thru OBDC..

Everything we have read says that we should be able the set the ODBC driver
to access a default schema..

However is appears that PH requires it to be fully qualified..

Using the sample database in QSHOW


I see


> show records in sample
2013/07/10                 TEST ODBC Connection                Page    1
                        R E C O R D   S U M M A R Y
                 For DICTIONARY:  C:\TEST.pdc
Record Name                      File Name/                     Record Size
                                   Open Name                      (bytes)
SAMPLE.DEPT                      SAMPLE                              66
                                   DSN=SAMPLE;
SAMPLE.EMP                       SAMPLE                              79
                                   DSN=SAMPLE;
SAMPLE.EMP_ACT                   SAMPLE                              25
                                   DSN=SAMPLE;
SAMPLE.EMPACT                    SAMPLE                              25
                                   DSN=SAMPLE;
SAMPLE.PROJ                      SAMPLE                              58
                                   DSN=SAMPLE;
SAMPLE.ACT                       SAMPLE                              30
                                   DSN=SAMPLE;
SAMPLE.CL_SCHED                  SAMPLE                              17
                                   DSN=SAMPLE;
SAMPLE.DEPARTMENT                SAMPLE                              66
                                   DSN=SAMPLE;
SAMPLE.EMP_PHOTO                 SAMPLE                            1080
                                   DSN=SAMPLE;


I have set the default schema in OBDC to SAMPLE.. So i should be able to
find it without it...

But if I try to access the table unqualified I get

> access emp in sample
> rep all
> go
*E* Data access error. (EMP)
*E* DMS-E-GENERAL, A general exception has occurred during operation
'prepare
request'. (EMP)
*E* DMS-E-RBI_TABLE, The table or view EMP was not found in the dictionary.
(EMP)

Records selected:  0


What's more bizarre is that if I show items.. Powerhouse has indeed found
the records..

> show items

                                             INPUT OUTPUT
EMP                                     TYPE SCALE SCALE  DEC PICTURE
* EMPNO                                 CHAR                  X(6)
  FIRSTNME                              VARCHAR               X(12)
  MIDINIT                               CHAR                  X(1)
  LASTNAME                              VARCHAR               X(15)
* WORKDEPT                              CHAR                  X(3)
  PHONENO                               CHAR                  X(4)
  HIREDATE                              DATE                  YYYY/MM/DD
  JOB                                   CHAR                  X(8)
  EDLEVEL                               NUM     0     0    0   ^^,^^^
  SEX                                   CHAR                  X(1)
  BIRTHDATE                             DATE                  YYYY/MM/DD
  SALARY                                NUM     2     0    2   ^,^^^,^^^.^^
  BONUS                                 NUM     2     0    2   ^,^^^,^^^.^^
  COMM                                  NUM     2     0    2   ^,^^^,^^^.^^


Does powerhouse not take into account the ODBC setting???

Has anyone else ever done this and gotten it to work..



It's saying that EMP is not in the dictionary does that mean I could add it
to the PDL? How would I.. Refines is a big issue with this project.



Fully qualifying sorta takes away the benefit of being able to pass
variables to the open name..

PS It does work fully qualified...

> access sample.emp in sample
> rep all
> go
2013/07/10                TRUEOIL TEST ODBC Conection
PAGE   1

  Empno   Firstnme      Midinit  Lastname         Workdept  Phoneno
Hiredate

  Job       Edlevel  Sex   Birthdate      Salary         Bonus

       Comm

  000010  CHRISTINE        I     HAAS               A00      3978
1965/01/01
  PRES           18   F   1933/08/24      52,750.00       1,000.00
       4,220.00
  000020  MICHAEL          L     THOMPSON           B01      3476
1973/10/10
  MANAGER        18   M   1948/02/02      41,250.00         800.00
       3,300.00
  000030  SALLY            A     KWAN               C01      4738
1975/04/05
  MANAGER        20   F   1941/05/11      38,250.00         800.00
       3,060.00
  000050  JOHN             B     GEYER              E01      6789
1949/08/17
  MANAGER        16   M   1925/09/15      40,175.00         800.00
       3,214.00
  000060  IRVING           F     STERN              D11      6423
1973/09/14
  MANAGER        16   M   1945/07/07      32,250.00         500.00
       2,580.00




-- 
Thanks

Brian Stephens
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20130710/ecaed911/attachment.htm>