Hi Mukesh,
IBM module names contain a prefix which relates to a component and product. The "IDC" in IDCAMS is the prefix IBM has assigned to Access Method Services (AMS), which is part of DFSMSdfp. The "AMS" is an abbreviation for Access Method Services.
Thanks,
Reddy
Search found 14 matches
- Fri Oct 27, 2006 11:53 am
- Forum: VSAM - File system
- Topic: full form of idcams
- Replies: 5
- Views: 15515
- Tue Oct 17, 2006 5:08 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: DB2 Certification
- Replies: 3
- Views: 9566
Hi Jack,
Please refer to the IBM website for test information and books.
http://www-03.ibm.com/certify/tests/test_index.shtml
Thanks,
Reddy
Please refer to the IBM website for test information and books.
http://www-03.ibm.com/certify/tests/test_index.shtml
Thanks,
Reddy
- Tue Oct 17, 2006 12:28 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Inserting NULL
- Replies: 5
- Views: 21755
Hi, I have executed the following statement and I didn't see any error in execution... If you are talking about wording then I will agree with you... CREATE GLOBAL TEMPORARY TABLE TEST(EMPNO INTEGER,ENAME CHAR(10)); ---------+---------+---------+---------+---------+---------+----- DSNE616I STATEMENT...
- Mon Oct 16, 2006 5:20 pm
- Forum: JCL
- Topic: Tracking of JCL that calls the proc
- Replies: 1
- Views: 6545
Hi, You can use SEARCH tool of ISPF. > Go to 3.14 > Enter Procedure name in single quotes like 'PROC1' > Enter the PDS where JCL's are located > Then press Enter > Result will be stored at SRCHFOR.LIST You can copy this to another data set or enter another name in SEARCH panel before searching. Than...
- Mon Oct 16, 2006 5:14 pm
- Forum: JCL
- Topic: ISPF question
- Replies: 3
- Views: 11305
- Mon Oct 16, 2006 5:10 pm
- Forum: JCL
- Topic: What is the command in mainframe avoid auto signout(TIMEOUT)
- Replies: 10
- Views: 37629
- Mon Oct 16, 2006 4:46 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Inserting NULL
- Replies: 5
- Views: 21755
- Mon Oct 16, 2006 4:40 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: date -updation
- Replies: 2
- Views: 8102
- Wed Oct 11, 2006 5:58 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Stored procedure parm limit
- Replies: 1
- Views: 10183
Hi Jack, A stored procedure parameter is also a DB2 Data Type. So the size limit will be same as normal DB2 data types. The following is the summary of data types in DB2. CHAR[(n)] [FOR BIT DATA] CHARACTER[(n)] [FOR BIT DATA] 1 to 254 characters VARCHAR(n) [FOR BIT DATA] CHARACTER VARYING(n) [FOR BI...
- Sat Oct 07, 2006 4:43 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: SQL update query - need help urgently please
- Replies: 2
- Views: 12990
Hi Prabhakar, I dont think we can update a derived column directly in DB2. Instead we need to update base column from which the new column is derived. For example a column ANNUAL_SALRY is derived from a base column salary as SAL*12. Then if we modify the ANNUAL_SALARY it will not effect on base colu...
- Sat Oct 07, 2006 4:30 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Reg:Performance of a DB2 query
- Replies: 3
- Views: 10633
- Sat Oct 07, 2006 4:26 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: doubt in db2
- Replies: 2
- Views: 9413
Hi Supriya, Please refer to the following syntax to get the result. SELECT '*' FROM SYSIBM.SYSDUMMY1 UNION SELECT '**' FROM SYSIBM.SYSDUMMY1 UNION SELECT '***' FROM SYSIBM.SYSDUMMY1; ---------+---------+---------+---------+---------+---------+---------+---------+ ---------+---------+---------+------...
- Sat Oct 07, 2006 4:25 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: db2 doubt
- Replies: 2
- Views: 9258
Hi Krishna, Please refer to the following syntax to get the result. SELECT '*' FROM SYSIBM.SYSDUMMY1 UNION SELECT '**' FROM SYSIBM.SYSDUMMY1 UNION SELECT '***' FROM SYSIBM.SYSDUMMY1; ---------+---------+---------+---------+---------+---------+---------+---------+ ---------+---------+---------+------...
- Sat Oct 07, 2006 4:17 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: current date,time
- Replies: 2
- Views: 11640
---------+---------+---------+---------+---------+--------- SELECT CURRENT DATE FROM SYSIBM.SYSDUMMY1; ---------+---------+---------+---------+---------+--------- ---------+---------+---------+---------+---------+--------- 10/07/2006 DSNE610I NUMBER OF ROWS DISPLAYED IS 1 DSNE616I STATEMENT EXECUTIO...