|
I ended up creating the printer as a lan printer. Before I had only created an outq. Right now it *is* printing, but in a quirky manner. The spool goes into *PND, then if you HOLD it, and release it prints fine. Perhaps someone is familiar or has been down this path. The system error message is CPI93B9, "Software problem data for QTVTNCSH has been logged" The Printer is set up as *LAN, 3812, Port 9100 (also tried 4000), Physical attachment, *WIRE4 (have tried the other options), Manufacturers model: *IBM4216, System Driver Program: *IBMPJLDRV. Please email if you need all of the option, these are the biggies. Thank you, Mike Tom Liotta <qsrvbas@xxxxxxxxxxxx> wrote: Vern: Well, rats. I was actually feeling intrigued at learning something new. Now I have to go back and re-read that whole set of posts about the query optimizer(s?) and the use of SQL INDEX vs. keyed LFs. We ought to be getting closer to this being a science, but it keeps feeling more like an art. Tom Liotta "The more things change, the more they remain insane." -- Johnny Carson midrange-l-request@xxxxxxxxxxxx wrote: > 8. RE: Indexing an SQL view (Vern Hamberg) > >I may have not been clear enough - the index is actually the LF itself - >key fields (K-specs) over the new calculated fields. An SQL index cannot be >created over an LF, as I just checked. > >But this is what we tools vendors are about, right? Selling things that >help people manage the increasingly unmanageable. > >At 10:02 PM 4/19/2004 -0400, you wrote: >> >> >Fortunately, Rick reports improvement. ;-) >> >>Yes, 'fortunately'. From some of the threads recently, I'm getting the >>feeling that educated DB2 DBAs are becoming more important. It seems that >>few are willing to assert "THIS is how it should work." As much as I >>recognize that environment significantly changes results, revelations such >>as the need for SQL INDEXes rather than keyed LFs seem to come out of >>nowhere. (Surprise!) >> >>A DBA supposedly could keep up. But generalist programmers have far too >>much in too many areas to keep up with. I've long been aware that SQL >>VIEWs over other VIEWs and even over LFs let you do some pretty slick >>stuff. But it never occurred to me to INDEX a LF -- much less grasp the >>implications if there are any. -- Tom Liotta The PowerTech Group, Inc. 19426 68th Avenue South Kent, WA 98032 Phone 253-872-7788 x313 Fax 253-872-7904 http://www.powertech.com __________________________________________________________________ Introducing the New Netscape Internet Service. Only $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp _______________________________________________ This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l. --------------------------------- Do you Yahoo!? Yahoo! Photos: High-quality 4x6 digital prints for 25¢
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
