Search found 14 matches

by ovreddy
Fri Oct 27, 2006 11:53 am
Forum: VSAM - File system
Topic: full form of idcams
Replies: 5
Views: 11725

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
by ovreddy
Tue Oct 17, 2006 5:08 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: DB2 Certification
Replies: 3
Views: 5953

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
by ovreddy
Tue Oct 17, 2006 12:28 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Inserting NULL
Replies: 5
Views: 15615

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...
by ovreddy
Mon Oct 16, 2006 5:20 pm
Forum: JCL
Topic: Tracking of JCL that calls the proc
Replies: 1
Views: 4365

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...
by ovreddy
Mon Oct 16, 2006 5:14 pm
Forum: JCL
Topic: ISPF question
Replies: 3
Views: 8058

Hi Bhimalraj,

Also remember to remove filter for job names (if any) as follows...

> Goto SPOOL (SD;ST;)
> Type command as OWNER * (which means list jobs from all the owners)
> Type command PRE * (which means it lists all the jobs)

Thanks,
Reddy
by ovreddy
Mon Oct 16, 2006 5:10 pm
Forum: JCL
Topic: What is the command in mainframe avoid auto signout(TIMEOUT)
Replies: 10
Views: 29615

Hi Rajendra,

Go to SDSF and give &n where n is number of seconds to refresh.

For example &10 will refresh every 10 seconds. You can come out of this by pressing SHIFT+ESC or ATTENTION KEY of your mainframe.

Thanks,
Reddy
by ovreddy
Mon Oct 16, 2006 4:46 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Inserting NULL
Replies: 5
Views: 15615

Hi Srinivas,

In SPUFI like tool we can use directly NULL to insert null values..

Ex: INSERT INTO TABLE1(COL1,COL2) VALUES (102,NULL);

This will insert a null value into second column of the table.

Also we can use same type of syntax for UPDATE.

Thanks,
Reddy
by ovreddy
Mon Oct 16, 2006 4:40 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: date -updation
Replies: 2
Views: 5130

Hi Amar,

Following query will do that

UPDATE EMP_TABLE SET DATE_OF_JOINING='2006-10-30';

or

UPDATE EMP_TABLE SET DATE_OF_JOINING= DATE_OF_JOINING + 8 DAYS;

Regards,
Reddy.
by ovreddy
Wed Oct 11, 2006 5:58 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Stored procedure parm limit
Replies: 1
Views: 7461

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...
by ovreddy
Sat Oct 07, 2006 4:43 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: SQL update query - need help urgently please
Replies: 2
Views: 10287

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...
by ovreddy
Sat Oct 07, 2006 4:30 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Reg:Performance of a DB2 query
Replies: 3
Views: 7240

Hi,

EXPLAIN statement inserts a row into PLAN TABLE usually named as PLAN_TABLE. This table contains several columns used to estimate cost for executing a query.

After executing EXPLAIN. Use select statement on PLAN_TABLE to see the cost of execution.

Thanks,
Reddy.
by ovreddy
Sat Oct 07, 2006 4:26 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: doubt in db2
Replies: 2
Views: 6293

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; ---------+---------+---------+---------+---------+---------+---------+---------+ ---------+---------+---------+------...
by ovreddy
Sat Oct 07, 2006 4:25 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: db2 doubt
Replies: 2
Views: 6259

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; ---------+---------+---------+---------+---------+---------+---------+---------+ ---------+---------+---------+------...
by ovreddy
Sat Oct 07, 2006 4:17 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: current date,time
Replies: 2
Views: 8213

---------+---------+---------+---------+---------+--------- SELECT CURRENT DATE FROM SYSIBM.SYSDUMMY1; ---------+---------+---------+---------+---------+--------- ---------+---------+---------+---------+---------+--------- 10/07/2006 DSNE610I NUMBER OF ROWS DISPLAYED IS 1 DSNE616I STATEMENT EXECUTIO...