<div dir="ltr"><div><div><div><div>After getting over the initial issues...<br><br></div>I am talking to the AS/400 via OBDC,,, I can read and write..<br><br></div>BUT I have an interesting issue... the quiz dialog is below and my notes are prefixed with lots of dashes<br>
<br></div><div><br><br></div><div>-------------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..<br>
</div><div><br><span style="font-family:courier new,monospace">> show files<br><br>PHTEST.CUSTOMER IN PHTEST<br>PHTEST.TEST_TABLE_LONGER_THEN IN PHTEST<br>
PHTEST.SYSCHKCST IN PHTEST<br>PHTEST.SYSCOLUMNS IN PHTEST<br>PHTEST.SYSCST IN PHTEST<br>
PHTEST.SYSCSTCOL IN PHTEST<br>PHTEST.SYSCSTDEP IN PHTEST<br>PHTEST.SYSINDEXES IN PHTEST<br>
PHTEST.SYSKEYCST IN PHTEST<br>PHTEST.SYSKEYS IN PHTEST<br>PHTEST.SYSPACKAGE IN PHTEST<br>
PHTEST.SYSREFCST IN PHTEST<br>PHTEST.SYSTABLEDEP IN PHTEST<br>PHTEST.SYSTABLES IN PHTEST<br>
PHTEST.SYSTRIGCOL IN PHTEST<br>PHTEST.SYSTRIGDEP IN PHTEST<br>PHTEST.SYSTRIGGERS IN PHTEST<br>
PHTEST.SYSTRIGUPD IN PHTEST<br>PHTEST.SYSVIEWDEP IN PHTEST<br>PHTEST.SYSVIEWS IN PHTEST<br>
<br>> acc customer in PHTEST<br>> show items<br><br> INPUT OUTPUT<br>CUSTOMER TYPE SCALE SCALE DEC PICTURE<br> NAME CHAR X(30)<br>
* NUMBER NUM 0 0 0 ^^,^^^<br> LAST_ACCESS DATE YYYY/MM/DD<br></span></div><div><span style="font-family:courier new,monospace">-------------- hey it works as just customer..<br>
</span></div><div><span style="font-family:courier new,monospace"><br>> rep all<br>> go<br>*E* Data access error. (CUSTOMER)<br>*E* DMS-E-GENERAL, A general exception has occurred during operation 'prepare<br>request'. (CUSTOMER)<br>
*E* DMS-E-RBI_TABLE, The table or view CUSTOMER was not found in the<br>dictionary. (CUSTOMER)<br><br>Records selected: 0<br><br></span></div><div><span style="font-family:courier new,monospace">-----------OK maybe not..<br>
</span></div><div><span style="font-family:courier new,monospace"><br>> access phtest.customer in phtest<br>> show items<br><br> INPUT OUTPUT<br>PHTEST.CUSTOMER TYPE SCALE SCALE DEC PICTURE<br>
NAME CHAR X(30)<br>* NUMBER NUM 0 0 0 ^^,^^^<br> LAST_ACCESS DATE YYYY/MM/DD<br><br>
<br>> rep all<br>> go<br>2013/05/23 TRUEOIL TEST ODBC Conection PAGE 1<br><br> Name Number Last<br> Access<br>
<br> Brian 1 2013/05/23<br></span></div><div><span style="font-family:courier new,monospace"> Snoopy 2 2013/05/02<br></span></div><div><span style="font-family:courier new,monospace"> LINUS 3 2013/05/24<br>
LUCY 4 2013/05/22<br> TEST 6 2010/01/01<br><br>--------------------------------------------------------------------------------------------<br><br></span></div>
<div><span style="font-family:courier new,monospace">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..<br>
<br></span></div><div><span style="font-family:courier new,monospace"><br><br clear="all"></span></div></div><div><div><div><div><div><div><div><div><div><br>-- <br>Thanks<br><br>Brian Stephens
</div></div></div></div></div></div></div></div></div></div>