Search found 515 matches
- Wed Feb 03, 2016 11:13 pm
- Forum: TSO, ISPF & REXX (Do you still do CLIST?!).
- Topic: Debugging REXX programs like the COBOL programs.
- Replies: 5
- Views: 891
Re: Debugging REXX programs like the COBOL programs.
I double Enrico said there are plenty of options along with Trace...
- Mon Jan 25, 2016 4:34 pm
- Forum: IBM DB2 and IMS DB/DC
- Topic: NULL and SQLCODE -305.
- Replies: 5
- Views: 2863
Re: NULL and SQLCODE -305.
You might also need to follow your company standard procedure for all the validations that needs to be done.. Talk to your team or check the existing programs and that should answer your question
- Mon Jan 25, 2016 3:42 pm
- Forum: IBM DB2 and IMS DB/DC
- Topic: Reducing the time of RUNSTAT job.
- Replies: 1
- Views: 461
Re: Reducing the time of RUNSTAT job.
Is it one job or is it based on Partition?
- Fri Jan 22, 2016 5:04 pm
- Forum: IBM DB2 and IMS DB/DC
- Topic: Don't allow DELETE for a DB2 table.
- Replies: 2
- Views: 642
Re: Don't allow DELETE for a DB2 table.
You could check on this link for REVOKE but most shops only DBA has authority over this command
http://publibz.boulder.ibm.com/cgi-bin/ ... 0325102208
http://publibz.boulder.ibm.com/cgi-bin/ ... 0325102208
- Fri Jan 22, 2016 4:13 pm
- Forum: IBM DB2 and IMS DB/DC
- Topic: What is "incremental" in DB2?
- Replies: 3
- Views: 544
Re: What is "incremental" in DB2?
http://www-01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.ugref/src/tpc/db2z_incrementalimagecopies.html A very good link to start... If you need to know incremental image copy http://www-01.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.ugref/src/tpc/db2z_utl_...
- Mon Jan 04, 2016 5:08 pm
- Forum: TSO, ISPF & REXX (Do you still do CLIST?!).
- Topic: Cancel TSO Session using JCL?
- Replies: 11
- Views: 1751
Re: Cancel TSO Session using JCL?
what do you mean by hanged?
Are you executing any foreground programs that is in loop?
Also if you just wanted to reconnect
Try
Are you executing any foreground programs that is in loop?
Also if you just wanted to reconnect
Try
Code: Select all
TSO <USERID> RECONNECT
- Mon Jan 04, 2016 4:34 pm
- Forum: IBM DB2 and IMS DB/DC
- Topic: Help needed in SQLCODE -401.
- Replies: 4
- Views: 774
Re: Help needed in SQLCODE -401.
Try
Code: Select all
WHERE DATE(TIMESTAMP_COLUMN) > CURRENT DATE - 7 YEARS;
- Wed Dec 30, 2015 10:32 am
- Forum: Interview Questions.
- Topic: Get the first 5 characters of a column in DB2?
- Replies: 3
- Views: 504
Re: Get the first 5 characters of a column in DB2?
Thanks for sharing the link , It would help people future
- Tue Dec 29, 2015 2:07 pm
- Forum: Interview Questions.
- Topic: Find the number of records fetched in a cursor.
- Replies: 9
- Views: 1803
Re: Find the number of records fetched in a cursor.
Suntles,
You could do a count(*) and find the number of records and then process the cursor.
You could do a count(*) and find the number of records and then process the cursor.
- Mon Dec 28, 2015 12:42 pm
- Forum: IBM DB2 and IMS DB/DC
- Topic: Insert data from one table to another in DB2 on mainframes.
- Replies: 4
- Views: 628
Re: Insert data from one table to another in DB2 on mainframes.
As Nicc mentioned you could use insert statement
But if there are more records it is better to have frequent commits or as an alternative you could unload and load data
But if there are more records it is better to have frequent commits or as an alternative you could unload and load data
- Mon Dec 28, 2015 12:34 pm
- Forum: IBM DB2 and IMS DB/DC
- Topic: In DB2, is there a difference between inner join and self join?
- Replies: 3
- Views: 500
Re: In DB2, is there a difference between inner join and self join?
Corrected the typo it is equi join
- Mon Dec 28, 2015 12:33 pm
- Forum: TSO, ISPF & REXX (Do you still do CLIST?!).
- Topic: Allocate EXEC libraries to my TSO or ISPF session?
- Replies: 9
- Views: 1871
Re: Allocate EXEC libraries to my TSO or ISPF session?
In that case there should be someone from the client team or Technical support or system admin who would have definitely done this.. check with themnarinderc wrote:There is not much support here. Most of the seniors guys have left the organization.
- Wed Dec 23, 2015 3:46 pm
- Forum: IBM DB2 and IMS DB/DC
- Topic: In DB2, is there a difference between inner join and self join?
- Replies: 3
- Views: 500
Re: In DB2, is there a difference between inner join and self join?
Innerjoin ,selfjoin and equi join are all same
- Wed Dec 23, 2015 3:23 pm
- Forum: IBM DB2 and IMS DB/DC
- Topic: Insert data from one table to another in DB2 on mainframes.
- Replies: 4
- Views: 628
Re: Insert data from one table to another in DB2 on mainframes.
Also you could try UNLOAD and LOAD
- Wed Dec 23, 2015 3:03 pm
- Forum: TSO, ISPF & REXX (Do you still do CLIST?!).
- Topic: Allocate EXEC libraries to my TSO or ISPF session?
- Replies: 9
- Views: 1871
Re: Allocate EXEC libraries to my TSO or ISPF session?
You could copy your rexx scripts to SYSEXEC or SYSPROC library
- Tue Dec 22, 2015 1:07 am
- Forum: You are a Guest.
- Topic: Debugging using COBOL display statement.
- Replies: 5
- Views: 3939
Re: Debugging using COBOL display statement.
For past few years I have stopped using debugging tools, As Robert said adding Display after each Paragraph or section helps in narrowing down to the problem.... Also it helps in understanding the program flow much easier by executing it with the test input rather than starring at the piece of code ...
- Tue Dec 22, 2015 12:45 am
- Forum: Interview Questions.
- Topic: Find the number of records fetched in a cursor.
- Replies: 9
- Views: 1803
Re: Find the number of records fetched in a cursor.
If you could elaborate you could get better reply
I would normally do a Count(*)
I would normally do a Count(*)
- Tue Dec 15, 2015 10:51 pm
- Forum: IBM DB2 and IMS DB/DC
- Topic: Pre-compilation when DB2 is down.
- Replies: 8
- Views: 1998
Re: Pre-compilation when DB2 is down.
Hi Priya
Just to check did it solve your problem
Just to check did it solve your problem
- Tue Dec 15, 2015 3:03 pm
- Forum: JCL - Job Control Language.
- Topic: FTP with trailing spaces
- Replies: 3
- Views: 3861
Re: FTP with trailing spaces
Anuj If I remember correctly TRAIL is shortform for TRAILINGBLANKS in Mainframe and TS had done that I guess
TRAILingblanks Specifies that the FTP server preserves the trailing blanks in a fixed format data set when the data is sent to a foreign host.
- Sun Dec 13, 2015 12:50 pm
- Forum: Other Databases on zOS.
- Topic: IDMS Version 18.5 manuals
- Replies: 0
- Views: 1449