Thanks for all the help yesterday....

[Brian Stephens]

After getting over the initial issues...

I am talking to the AS/400 via OBDC,,, I can read and write..

BUT I have an interesting issue... the quiz dialog is below and my notes
are prefixed with lots of dashes



-------------I created a Schema called PHTEST and a couple of test
tables... I get more tables then I was expecting (the others system views)
and they are prefixed with the SCHEMA.. Then I tried to just grab the name
of the table and it worked sortof..

> show files

PHTEST.CUSTOMER                                                  IN PHTEST
PHTEST.TEST_TABLE_LONGER_THEN                                    IN PHTEST
PHTEST.SYSCHKCST                                                 IN PHTEST
PHTEST.SYSCOLUMNS                                                IN PHTEST
PHTEST.SYSCST                                                    IN PHTEST
PHTEST.SYSCSTCOL                                                 IN PHTEST
PHTEST.SYSCSTDEP                                                 IN PHTEST
PHTEST.SYSINDEXES                                                IN PHTEST
PHTEST.SYSKEYCST                                                 IN PHTEST
PHTEST.SYSKEYS                                                   IN PHTEST
PHTEST.SYSPACKAGE                                                IN PHTEST
PHTEST.SYSREFCST                                                 IN PHTEST
PHTEST.SYSTABLEDEP                                               IN PHTEST
PHTEST.SYSTABLES                                                 IN PHTEST
PHTEST.SYSTRIGCOL                                                IN PHTEST
PHTEST.SYSTRIGDEP                                                IN PHTEST
PHTEST.SYSTRIGGERS                                               IN PHTEST
PHTEST.SYSTRIGUPD                                                IN PHTEST
PHTEST.SYSVIEWDEP                                                IN PHTEST
PHTEST.SYSVIEWS                                                  IN PHTEST

> acc customer in PHTEST
> show items

                                             INPUT OUTPUT
CUSTOMER                                TYPE SCALE SCALE  DEC PICTURE
  NAME                                  CHAR                  X(30)
* NUMBER                                NUM     0     0    0   ^^,^^^
  LAST_ACCESS                           DATE                  YYYY/MM/DD
-------------- hey it works as just customer..

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

Records selected:  0

-----------OK maybe not..

> access phtest.customer in phtest
> show items

                                             INPUT OUTPUT
PHTEST.CUSTOMER                         TYPE SCALE SCALE  DEC PICTURE
  NAME                                  CHAR                  X(30)
* NUMBER                                NUM     0     0    0   ^^,^^^
  LAST_ACCESS                           DATE                  YYYY/MM/DD


> rep all
> go
2013/05/23                TRUEOIL TEST ODBC Conection
PAGE   1

  Name                             Number     Last
                                             Access

  Brian                                 1  2013/05/23
  Snoopy                                2  2013/05/02
  LINUS                                 3  2013/05/24
  LUCY                                  4  2013/05/22
  TEST                                  6  2010/01/01

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

So the questions are why does it find the table I am looking for and
describe it but not work with it... and why does it add the schema name in
the first place.. Hopefully that is AS/400 configuration I'll admit I know
how to log on and log off... I hope to learn more..




-- 
Thanks

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