=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEARCH390.COM | Expert Questions of the Week Tip November 7, 2002
Answers to your technical questions and expert advice for the 390 community. =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSORS: - Don't just get the latest information...see the future! http://search390.techtarget.com/content/0,290959,sid10_gci850485,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. Expert Questions of the Week - Getting error when using FETCH statement in DB2? - How to get storage from COBOL? - How to create MQSeries client-server version of CICS system? 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Welcome DB2 expert Craig Mullins! - Featured Topic: Ready or not, here comes z/OS - Discussion: Can you solve IP PrintWay output dilemma? - Poll: Are you dealing with mainframe security issues? ___________________________________________________________________ SPONSORED BY: Data Center Futures Newsletter If you pride yourself on knowing everything about your data center, you probably go to great lengths to keep up to date with the latest skills and technologies. Don't just get the latest information...see the future! Twice a month, the Data Center Futures newsletter gives you the lowdown on all you need to know to be prepared for the future. >> CLICK for more info: http://search390.techtarget.com/content/0,290959,sid10_gci850485,00.html ___________________________________________________________________ =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= GETTING ERROR WHEN USING FETCH STATEMENT IN DB2? | by Craig Mullins Dear Ask the Expert, We are using DB2 V7 on OS/390 and trying scrollable cursors in a stored procedure. When we try to use the FETCH statement (FETCH ABSOLUTE FROM INTO ;), it throws for the host variable and says "variable should be zero scale." I had declared the variable as an INTEGER and I even tried it with DECIMAL(n,0), but I get the same error. >> CLICK for Craig's expert response: http://www.search390.com/ateQuestionNResponse/0,289625,sid10_cid498951_tax285651,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= HOW TO GET STORAGE FROM COBOL? | by Tom Ross Dear Ask the Expert, I would like to move an area in working storage to the linkage section and acquire the storage as needed. Is this possible? If so how? >> CLICK for Tom's expert response: http://search390.techtarget.com/ateQuestionNResponse/0,289625,sid10_cid500420_tax285603,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= HOW TO CREATE MQSERIES VERSION OF CICS SYSTEM? | by Robert Harris Dear Ask the Expert, We have a system selling passenger train tickets. This system is running under OS/390 and uses CICS TS V1R2 and DB2 V5.2. Now we want to develop a client-server version of our system using MQSeries. We want to change the client's part of our system. The system's kernel must stay the same. (The new version must support our legacy system.) Where do we begin? >> CLICK for part 1 of Robert's expert response: http://search390.techtarget.com/ateQuestionNResponse/0,289625,sid10_cid500406_tax289214,00.html >> CLICK for part 2 of Robert's expert response: http://search390.techtarget.com/ateQuestionNResponse/0,289625,sid10_cid500405_tax289214,00.html ___________________________________________________________________ :::::::::: DON'T MISS THESE IMPORTANT MESSAGES AND LINKS ::::::::: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ASK THE EXPERT | Welcome DB2 expert Craig Mullins! Craig Mullins is our newest 390 mainframe guru, available to answer your DB2 questions. He has extensive experience in the field of database management, having worked as an application developer, a DBA and an instructor with multiple database management systems, including DB2, Oracle and SQL Server. If you need help with DB2 and database management, send your questions to Craig today. >> CLICK to view Craig's full bio: http://search390.techtarget.com/ateExpertBio/0,289623,sid10_cid500556,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEARCH390.COM FEATURED TOPIC | Ready or not, here comes z/OS Mixed feelings about upgrading from a 31-bit to a 64-bit architecture? Some have already upgraded, but others feel forced now that IBM will no longer support some earlier releases of OS/390. Is that you? If so, we can help with this Featured Topic. >> CLICK for full Featured Topic: http://search390.techtarget.com/featuredTopic/0,290042,sid10_gci860486,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= OPERATING SYSTEMS FORUM | Can you solve IP PrintWay output dilemma? Search390.com user "BlueKnight" posted the following in the Operating Systems forum and needs your help: "We are running OS/390 2.9, CICS/TS 1.3 and IP PrintWay on a Multiprise 3000 series box. One of our user departments intermittently has IP printer output printing out of sequence and would like it corrected. I thought I had seen somewhere a configuration option for PrintWay that specified how to handle output sequencing. Our System Programmer says not so. Does anyone know of a parameter for PrintWay or even NetSpool that would keep output in the proper order?" Think you can help? If so, please share your suggestions: http://search390.discussions.techtarget.com/WebX?msgInContext@;233.tJoJaFbKtC1.1@.ee83ff6/456!viewtype=convdate&skip=&expand= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= TAKE OUR POLL | Search390.com How many mainframe security "issues" have you had to deal with because of internal misuse in the past year? >> CLICK to post your response: http://search390.techtarget.com/poll ___________________________________________________________________ :::::::::::::::::::::: SEARCH390.COM CONTACTS ::::::::::::::::::::: BJ RAMA, Site Editor (mailto:brama@;techtarget.com) >> Send us your original articles and best practices. ROBYN LORUSSO, Assistant Editor (mailto:rlorusso@;techtarget.com) >> Send your white papers and best web links. DAVID GABEL, Executive Tech Editor (mailto:dgabel@;techtarget.com) >> Send me your technical tips and tip ideas. TIM KEOUGH (mailto:tkeough@;techtarget.com) >> Sponsor this or any other TechTarget tip/newsletter. ____________________________________________________________________ ************************ ABOUT THIS NEWSLETTER ********************* Created by TechTarget (http://www.techtarget.com) TechTarget - The Most Targeted IT Media Copyright 2002, All Rights Reserved. Unsubscribe from 'Expert question of the week' - Simply Reply to this Email with REMOVE within the Body or Subject > or - Go to: http://search390.techtarget.com/register - Log in to edit your profile. - Click on the link to Edit email subscriptions. - Uncheck the box next to the newsletter you wish to unsubscribe from. - When finished, click "Save Changes to My Profile."
