mainframe
文章平均质量分 70
假装80后
一个不念过去,不畏将来的程序员
展开
-
Usage of mainframe DB2 trigger
General Trigger Creation Syntax$ cat create_trigger.sql--#SET TERMINATOR #DROP TRIGGER #CREATE TRIGGER AFTER [UPDATE|INSERT|DELETE] ON REFERENCING [NEW|NEW_TABLE] AS N [OL原创 2016-11-04 22:17:17 · 831 阅读 · 0 评论 -
IDCAMS IF-THEN-ELSE statement
IDCAMS IF-THEN-ELSE StructureIF {LASTCC | MAXCC} {operator} {numeric value} THEN {command} | DO{command set}END[ELSE {command} | DO{command set}END]原创 2016-10-20 21:59:29 · 731 阅读 · 0 评论 -
IDCAMS create dataset
#### HOWTO: Create a fixed length record sequential dataset//TESTIDCC JOB CLASS=A,MSGCLASS=X,MSGLEVEL=(1,1),NOTIFY=&SYSUID//*----------------------------------------------------------------原创 2016-10-20 21:58:36 · 648 阅读 · 0 评论 -
IDCAMS LASTCC and MAXCC
1. What’s LASTCC and MAXCC?They are IDCAMS return codes, (or condition codes); they can only be used in IDCAMS control card.- LASTCC stores the condition code for the previous原创 2016-10-20 21:57:18 · 702 阅读 · 0 评论 -
Download dataset from mainframe on a linux
Suppose1. mainframe $HOST2. mainframe $USER/$PASSWORD3. mainframe source dataset $USER.TEST.DATA.FILE4. local destination file: local.data// Step 1: Get a text file, for example a CO原创 2016-10-20 21:56:17 · 515 阅读 · 0 评论 -
DB2 DECIMAL data type
Describe DB2 z/OS DECIMAL data typeUsage FormatDECIMAL(PRECISION, SCALE)PRECISION refers to the maximum number of digits that are present in the number, andSCALE refers to the ma原创 2016-11-11 23:35:59 · 1237 阅读 · 0 评论 -
Generate DB2 table definition COPYBOOK
When accessing DB2 table in a COBOL program, usually we need know the table definition COPYBOOK.Utility DCLGEN could be used to generate this COPYBOOK file.For example: when table was defined原创 2016-11-11 22:55:54 · 668 阅读 · 0 评论 -
DB2 mainframe create table DDL
Sample JCL to create DB2 table on mainframe//CREATBL JOB (DSNTEP4),'CREATBL',REGION=0M,CLASS=2,MSGCLASS=X,// NOTIFY=&SYSUID//*=========================================================原创 2016-10-29 09:26:55 · 849 阅读 · 0 评论 -
DB2 mainframe table operation DML
Sample JCL to operate a DB2 table.//OPERTBL JOB (DSNTEP4),'OPERTBL',REGION=0M,CLASS=2,MSGCLASS=X,// NOTIFY=&SYSUID//*============================================================//STE原创 2016-10-29 09:32:08 · 599 阅读 · 0 评论 -
DSNUTILB UNLOAD DB2 TABLE INTO DATASET
Like DSNTIAUL, another utility DSNUTILB can also be used to unload a table into a dataset.//UNUTTAB JOB (DSNTEP4),'UNUTTAB',REGION=0M,CLASS=2,MSGCLASS=X,// NOTIFY=&SYSUID//DEL原创 2016-10-20 22:04:32 · 1015 阅读 · 0 评论 -
DSNTIAUL UNLOAD DB2 TABLE INTO DATASET
DB2 Utility DSNTIAUL can be used to unload a table to a dataset.Suppose table is defined as: CREATE TABLE TAB( ID DECIMAL(4, 0) NOT NULL, NAME原创 2016-10-20 22:03:25 · 1153 阅读 · 0 评论 -
DB2 BLOB data type
SQL samples of INSERT/SELECT DB2 BLOB data type.db2 => drop table db2 => create table (a varchar(4), b varchar(4) for bit data, c blob(4))db2 => describe select * from Column Inform原创 2016-11-06 20:06:30 · 2406 阅读 · 0 评论 -
DB2 Passing transition tables from trigger to stored procedure
欢迎使用Markdown编辑器写博客本Markdown编辑器使用StackEdit修改而来,用它写博客,将会带来全新的体验哦:Markdown和扩展Markdown简洁的语法代码块高亮图片链接和图片上传LaTex数学公式UML序列图和流程图离线写博客导入导出Markdown文件丰富的快捷键快捷键加粗 Ctrl + B 斜体 Ctrl + I 引用 Ctrl原创 2016-11-04 22:38:33 · 500 阅读 · 0 评论 -
DB2 mainframe support UNICODE
1. Create tableCREATE TABLE TAB(ID DECIMAL(4, 0) NOT NULL, NAME CHAR(06) NOT NULL, ADDRESS VARCHAR(10) NOT NULL, EMAIL VARCHAR(06), PHONE CHAR(04), PRIMARY KEY(原创 2016-10-20 22:01:30 · 1094 阅读 · 0 评论