powerh-l Digest, Vol 96, Issue 8

Wed Jul 10 16:32:21 CDT 2013

Hi Brian.
I'm on OpenVMS and Oracle Rdb so work with Logicals so I may be way off base here but... Have you considered "Execution-Time Parameters"? I know zilch about Powerhouse for Windows or how it behaves with ODBC, but in PhD there's an "ETP" sub-screen off the System screen in the Dictionary manager.
Just throwing it out there...

Martyn

-----Original Message-----
From: powerh-l-bounces+martyn.thomson=hpadvancedsolutions.com at lists.sowder.com [mailto:powerh-l-bounces+martyn.thomson=hpadvancedsolutions.com at lists.sowder.com] On Behalf Of powerh-l-request at lists.sowder.com
Sent: July-10-13 8:13 AM
To: powerh-l at lists.sowder.com
Subject: powerh-l Digest, Vol 96, Issue 8

Send powerh-l mailing list submissions to
	powerh-l at lists.sowder.com

To subscribe or unsubscribe via the World Wide Web, visit
	http://lists.sowder.com/mailman/listinfo/powerh-l
or, via email, send a message with subject or body 'help' to
	powerh-l-request at lists.sowder.com

You can reach the person managing the list at
	powerh-l-owner at lists.sowder.com

When replying, please edit your Subject line so it is more specific than "Re: Contents of powerh-l digest..."

Today's Topics:

   1. DB2 one more time.. (Brian Stephens)
   2. Re:DB2 one more time.. (Bob Deskin)

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

Message: 1
Date: Wed, 10 Jul 2013 11:03:09 -0400
From: Brian Stephens <bws001 at gmail.com>
Subject: DB2 one more time..
To: powerh-l at lists.sowder.com
Message-ID:
	<CAPxvv-XLxJNxT4KfPNULaZBziqRN3HW-ib_FG11-0NLPN0E0wg at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

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-0001.htm>

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

Message: 2
Date: Wed, 10 Jul 2013 11:14:14 -0400
From: Bob Deskin <Bob.Deskin at ca.ibm.com>
Subject: Re: DB2 one more time..
To: Brian Stephens <bws001 at gmail.com>
Cc: powerh-l-bounces+bob.deskin=ca.ibm.com at lists.sowder.com,
	powerh-l at lists.sowder.com
Message-ID:
	<OF56D18774.1F130252-ON85257BA4.00534D11-85257BA4.0053B469 at ca.ibm.com>
Content-Type: text/plain; charset="us-ascii"

Just a shot in the dark here but what is the owner name for the database. 
Based on what I see for QSHOW listing SQL Server, the table names are qualified with the owner. For example, I see

dbo.Billings

and I know that dbo is the owner.

Try specifying the OWNER on the DATABASE statement.

Bob

From:   Brian Stephens <bws001 at gmail.com>
To:     powerh-l at lists.sowder.com, 
Date:   2013-07-10 11:04 AM
Subject:        DB2 one more time..
Sent by:        powerh-l-bounces+bob.deskin=ca.ibm.com at lists.sowder.com