DB2 for z/OS

Comment

Comment by Rodolfo on May 4, 2010 at 12:11pm

Weiler, here it is the requestes SQL

SELECT SUBSTR(COLUMN,LOCATE('-',COLUMN,LOCATE('-',COLUMN)+1)+1,(LOCATE('-',COLUMN,LOCATE('-',COLUMN,LOCATE('-',COLUMN)+1)+1))-(LOCATE('-',COLUMN,LOCATE('-',COLUMN)+1)+1)) FROM SCHEMA.TABLE;

Comment by Rodolfo on May 4, 2010 at 11:43am

Hello everyone,

Does anyone in here is 000-737: IBM Certified System Administrator - DB2 9 for z/OS?

I passed on that exam, so I'm looking forward to know how was it for you?

For me, it was not that hard, although you need to study to be better prepared.

Comment by Weiler Gonçalves Monteiro Junior on March 11, 2010 at 9:44am

Hellow Word!
Gostaria de saber como fazer uma consulta e retornar o conteúdo que está entre traços.
ex:
1º 2º 3º
XXYYY-XXXYYY-12345-XXXYYYZZZ
no caso acima gostaria saber como fazer uma consulta para retornar os valores que estão entre o 2º traço e o 3º traço.
no caso acima o resultado seria 12345. mas poderia ser qualquer outro valor.
como fazer uma consulta para ter esses valores, independente do tanto de caracteres que possua entre os traços... em um caso poderia ser 5 caracteres como no caso acima, mas em outro poderia ser 10 caracteres... por isso me interessa o resultado que exista entre os traços.
desde já agradeço.

Weiler

Comment by Weiler Gonçalves Monteiro Junior on November 18, 2009 at 7:56am

Hi,
I install an simulator of the mainframe(Hercules). that have 13 GB.
Now I want configure DB2 for start with mainframe and put in prod.
God by!

Comment by Surekha Parekh on October 19, 2009 at 7:50am

Don't Miss Upcoming web event on Nov 3rd 2009
Reduce CPU & Stay one step ahead - DB2 X for z/OS Technical Preview

Broadcast Date: November 3, 2009 at 11:00 a.m. Eastern Standard Time, 4:00 p.m. UTC

Developed for: IT Managers, Application Architects, DBA, System Administrator, System Programmer System architects.

Technical Level: Intermediate

DB2 X has a lot for everyone. Your organization needs to lower operating costs thru CPU cycle reductions while still building a strong foundation for SOA and XML initiatives. Database Administrators (DBAs) will find improved database performance, scalability, and availability. Memory management is dramatically reduced, so growth is much simpler. DBAs also get more flexible security to help with regulatory compliance. A wide range of enhancements improve ERP application and data warehouse functionality and performance. Large object (LOB) performance and flexibility are improved. Many DBA tasks are simplified.

Application developers will be most excited by the second release of pureXML, which improves the SQL and XML interface to access XML data stored in a native format. Application developers need powerful new SQL enhancements. Improved SQL and data definition compatibility with other DB2 platforms makes porting much easier.

Speaker: Jeff Josten, Distinguished Engineer, DB2 for z/OS Development

Comment by Weiler Gonçalves Monteiro Junior on October 2, 2009 at 6:35am

Friends
someone has anything about Power Center of enterprise CA ? may be pdf, apresentation, dvd, etc... tool free seem that make same thing.

Comment by Sabine Kaschta on March 5, 2009 at 10:23am

Insterested in learning more about XML? Come visit our two different XML workshops!
1) CV120: DB2 9 for z/OS - Query XML data (http://www-304.ibm.com/jct03001c/services/learning/ites.wss/zz/en?pageType=tp_search_results&rowStart=0&rowsToReturn=20&searchString=cv12)
2) CV260: DB2 9 for z/OS - Manage XML data (http://www-304.ibm.com/jct03001c/services/learning/ites.wss/zz/en?pageType=tp_search_results&country=zz&rowStart=0&rowsToReturn=20&searchString=cv26)

Comment by Sabine Kaschta on February 20, 2009 at 4:23am

The first US teach for brand new 3-day course 'CV970 - DB2 9 for z/OS - Spotlight on zParms' will be held starting May 13, 2009 in Santa Clara, CA.
To enroll and to learn more abou it, follow this link:
http://www-304.ibm.com/jct03001c/services/learning/ites.wss/us/en?pageType=course_description&courseCode=CV970

Comment by Surekha Parekh on January 13, 2009 at 6:36am

We have 2 new web events for DB2 for z/OS coming up in Jan & Feb - please feel free to register. Here are the URLs
1. Business Benefits of DB2 Stored Procedure & Web 2.0; Jan 27, 2009
http://www-01.ibm.com/software/os/systemz/telecon/jan27/

Reduce costs, increase capacity & availability with DB2 Data Sharing! Feb 24, 2009
http://www-01.ibm.com/software/os/systemz/webcast/feb24/

I am planning webcasts for 2009 so please let me know what you would like us to present on in 2009.