In my last blog entry I posted about DSNTEP2, the batch SQL program. But there is another batch SQL program named DSNTIAD that is less widely-known and used.DSNTIAD is an assembler application program that can issue the same DB2 dynamic SQL statements as DSNTEP2, with the exception of the SELECT statement. For this reason, applications programmers almost always prefer to use DSNTEP2 rather than DSNTIAD.DSNTAID is written in Assembler language. Because DSNTIAD is a sample program, its source code could be modified to accept SELECT statements if...
Friday, 31 March 2006
Friday, 24 March 2006
DSNTEP2 aka Batch SPUFI
Posted on 21:30 by Unknown
DSNTEP2 is an application program that can be used to issue DB2 dynamic SQL statements. It is sometimes referred to as “Batch SPUFI” because it allows you to submit SQL in batch similar to how SPUFI allows online SQL execution.The following sample JCL demonstrates the capability of DSNTEP2 to issue DCL, DDL, and DML dynamically.//DB2JOBU JOB (BATCHSQL),'DB2 SAMPLE SQL',MSGCLASS=X,// CLASS=X,NOTIFY=USER//*//***********************************//*//* DB2 SAMPLE SQL PROGRAM//*//***********************************//*//JOBLIB DD DSN=DSN810.DSNLOAD,DISP=SHR//BATCHSQL...
Tuesday, 21 March 2006
IBM Announces z/OS V1.8
Posted on 11:29 by Unknown
On February 28, 2006 IBM announced the latest planned upgrade of its stalwart mainframe operating system, z/OS. IBM has announced some interesting new functionality for the new version, V1.8. Planned are improvements in scale, availability, security, and resource optimization. Also, there is an increased focus on simplification to make z/OS easier to use.The actual IBM announcement can be read here.Further details can be found in this handy summary of z/OS futures planning put together by Jim Schesvold, a technical editor for IBM Systems Magazine.IBM...
Tuesday, 14 March 2006
DB2 Versions, Service, and Such
Posted on 12:42 by Unknown
Keeping up-to-date with the latest and greatest DB2 versions and functionality can be a time-consuming task. Every 18 to 36 months IBM announces a new version of DB2 with even more features and functionality than ever before. DB2 will soon celebrate its 25th anniversary. The basis for DB2 began with IBM’s System R research project. In 1982, IBM delivered SQL/DS on VM and VSE, and then a year later in 1983, IBM released DB2 for MVS Version 1. Through subsequent versions and releases IBM has improved the functionality and performance of DB2.Functionality...
Thursday, 9 March 2006
Returning Only Numeric Data
Posted on 18:18 by Unknown
I frequently get e-mail from folks asking about ways to accomplish things in DB2 and SQL. A recent question I got went something like this:Is there any option to check whether data “IS NUMERIC” in a DB2 table? We want to examine CHAR data but return only those where the entire data consists only of numbers. For example, can we write a query like this?SELECT *FROM TABLENAMEWHERE VAR IS NUMERIC.The VAR variable is defined as a CHAR(5) column and it will contain data like below.123aa2234a3425632102add91Out of the above 5 records we would want only...
Wednesday, 1 March 2006
SHARE in Seattle, WA - Week of March 5, 2006
Posted on 12:43 by Unknown
Just a quick post to promote the upcoming SHARE conference in Seattle, WA. For those who don't know, SHARE Inc. is an independent, volunteer run association providing IBM customers with user focused education, professional networking, and industry influence. SHARE is the longest-running, functional computer user group having been founded in 1955, just two years after the release of IBM's first computer.SHARE holds two conferences annually, one in the spring and one in the fall. And I regularly attend and speak at each conference. The next conference...
Subscribe to:
Posts (Atom)
