<div dir="ltr"><div><div><div><div><div><div>I am still trying to get PH on windows to talk to DB2 on ISeries thru OBDC..<br><br></div>Everything we have read says that we should be able the set the ODBC driver to access a default schema..<br>
<br></div>However is appears that PH requires it to be fully qualified..<br><br></div>Using the sample database in QSHOW<br><br><br></div>I see<br><br></div><br><span style="font-family:courier new,monospace">> show records in sample<br>
2013/07/10 TEST ODBC Connection Page 1<br> R E C O R D S U M M A R Y<br> For DICTIONARY: C:\TEST.pdc<br>Record Name File Name/ Record Size<br>
Open Name (bytes)<br>SAMPLE.DEPT SAMPLE 66<br> DSN=SAMPLE;<br>SAMPLE.EMP SAMPLE 79<br>
DSN=SAMPLE;<br>SAMPLE.EMP_ACT SAMPLE 25<br> DSN=SAMPLE;<br>SAMPLE.EMPACT SAMPLE 25<br>
DSN=SAMPLE;<br>SAMPLE.PROJ SAMPLE 58<br> DSN=SAMPLE;<br>SAMPLE.ACT SAMPLE 30<br>
DSN=SAMPLE;<br>SAMPLE.CL_SCHED SAMPLE 17<br> DSN=SAMPLE;<br>SAMPLE.DEPARTMENT SAMPLE 66<br>
DSN=SAMPLE;<br>SAMPLE.EMP_PHOTO SAMPLE 1080<br> DSN=SAMPLE;</span><br><br><br></div>I have set the default schema in OBDC to SAMPLE.. So i should be able to find it without it... <br>
<div><div><br>But if I try to access the table unqualified I get<div><div><div><div><div><div><div><br>> access emp in sample<br>> rep all<br>> go<br>*E* Data access error. (EMP)<br>*E* DMS-E-GENERAL, A general exception has occurred during operation 'prepare<br>
request'. (EMP)<br>*E* DMS-E-RBI_TABLE, The table or view EMP was not found in the dictionary.<br>(EMP)<br><br>Records selected: 0<br><br><br></div><div>What's more bizarre is that if I show items.. Powerhouse has indeed found the records..<br>
<br></div><div>> show items<br><br><span style="font-family:courier new,monospace"> INPUT OUTPUT<br>EMP TYPE SCALE SCALE DEC PICTURE<br>* EMPNO CHAR X(6)<br>
FIRSTNME VARCHAR X(12)<br> MIDINIT CHAR X(1)<br> LASTNAME VARCHAR X(15)<br>* WORKDEPT CHAR X(3)<br>
PHONENO CHAR X(4)<br> HIREDATE DATE YYYY/MM/DD<br> JOB CHAR X(8)<br> EDLEVEL NUM 0 0 0 ^^,^^^<br>
SEX CHAR X(1)<br> BIRTHDATE DATE YYYY/MM/DD<br> SALARY NUM 2 0 2 ^,^^^,^^^.^^<br>
BONUS NUM 2 0 2 ^,^^^,^^^.^^<br> COMM NUM 2 0 2 ^,^^^,^^^.^^</span><br><br><br></div><div>Does powerhouse not take into account the ODBC setting??? <br>
</div><div><br></div><div>Has anyone else ever done this and gotten it to work..<br></div><div><br><br><br></div><div>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.<br>
</div><div><br><br><br></div><div>Fully qualifying sorta takes away the benefit of being able to pass variables to the open name..<br></div><div><br></div><div>PS It does work fully qualified... <br><br><span style="font-family:courier new,monospace">> access sample.emp in sample<br>
> rep all<br>> go<br>2013/07/10 TRUEOIL TEST ODBC Conection PAGE 1<br><br> Empno Firstnme Midinit Lastname Workdept Phoneno Hiredate<br><br> Job Edlevel Sex Birthdate Salary Bonus<br>
<br> Comm<br><br> 000010 CHRISTINE I HAAS A00 3978 1965/01/01<br> PRES 18 F 1933/08/24 52,750.00 1,000.00<br> 4,220.00<br> 000020 MICHAEL L THOMPSON B01 3476 1973/10/10<br>
MANAGER 18 M 1948/02/02 41,250.00 800.00<br> 3,300.00<br> 000030 SALLY A KWAN C01 4738 1975/04/05<br> MANAGER 20 F 1941/05/11 38,250.00 800.00<br>
3,060.00<br> 000050 JOHN B GEYER E01 6789 1949/08/17<br> MANAGER 16 M 1925/09/15 40,175.00 800.00<br> 3,214.00<br> 000060 IRVING F STERN D11 6423 1973/09/14<br>
MANAGER 16 M 1945/07/07 32,250.00 500.00<br> 2,580.00<br></span></div><div><br><br><br><br>-- <br>Thanks<br><br>Brian Stephens
</div></div></div></div></div></div></div></div></div></div>