 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 11 matches |
| Author | Message |
|---|---|
 Topic: PL/1 Sample programs |
|
| mf_learner Replies: 6 Views: 27247 |
 Forum: Application Programming Posted: Tue Oct 10, 2006 4:35 pm Subject: Compile PL/I pgm |
| Hi,
I am new to PL/I and need to write a new program on PL/I for doing a simple select from DB2 tables and preparing a report from that. The above is going to create a great reference ground for ... |
|
| Topic: Retaining first duplicate in my cursor fetch in a SP |
|
| mf_learner Replies: 3 Views: 1996 |
Forum: Database Posted: Sun Aug 27, 2006 2:48 pm Subject: Retaining first duplicate in my cursor fetch in a SP |
| Hi,
This has been fixed. We have used ROW_NUMBER() . Like as below - select loc, item, res, sun_start_dt, sum_quantity from ( select t.*, row_number() over (partition by l ... |
|
| Topic: Retaining first duplicate in my cursor fetch in a SP |
|
| mf_learner Replies: 3 Views: 1996 |
Forum: Database Posted: Sat Aug 26, 2006 8:18 pm Subject: Retaining first duplicate in my cursor fetch in a SP |
| Thanks Kolusu for the reply.
I am posting the cursor below. Only thing is that it is defined inside a Stored Proc. This is how the cursor is defined : ---------------------------------- ... |
|
| Topic: Retaining first duplicate in my cursor fetch in a SP |
|
| mf_learner Replies: 3 Views: 1996 |
Forum: Database Posted: Sat Aug 26, 2006 10:48 am Subject: Retaining first duplicate in my cursor fetch in a SP |
| Hi,
I think this is more of a Sql tuning query. I have a cursor defined in my Stored Proc which returns data as following - Col1 Col2 Col3 Col4 Col5 ----- ------ ------ ------ ... |
|
| Topic: How to track last DDL timestamp on any DB2 objects |
|
| mf_learner Replies: 1 Views: 1883 |
Forum: Database Posted: Thu Jul 20, 2006 4:00 pm Subject: How to track last DDL timestamp on any DB2 objects |
| Hi,
Are there any tables(SYSIBM) maintained in DB2 where we can check the last DDL timestamp on any particular table. Something like all_objects or dba_objects as maintaned in ORACLE where we can ... |
|
| Topic: Erroring out while invoking AOPPRINT for mailing |
|
| mf_learner Replies: 0 Views: 1848 |
Forum: Job Control Language(JCL) Posted: Wed May 24, 2006 3:37 am Subject: Erroring out while invoking AOPPRINT for mailing |
| Hi,
I am using AOPPRINT as in the below JCL for emailing a file to users defined instream in the JCL itself. //STEP0100 EXEC AOPPRINT,PRINTER='mail', // OPTIONS='attributes=//DD:M ... |
|
| Topic: Subject not displayed in the mail sent via SMTP |
|
| mf_learner Replies: 6 Views: 4785 |
Forum: Job Control Language(JCL) Posted: Thu May 18, 2006 2:00 am Subject: Subject not displayed in the mail sent via SMTP |
| Opening this thread once again because I am getting the same problem of not getting the Subject line displayed when I am using the data through card instead of passing instream(which had worked). The ... | |
| Topic: Subject not displayed in the mail sent via SMTP |
|
| mf_learner Replies: 6 Views: 4785 |
Forum: Job Control Language(JCL) Posted: Tue May 16, 2006 8:20 am Subject: Subject not displayed in the mail sent via SMTP |
| This issue is also resolved now.
I had to add a blank line before the mail body and after the second DD * statement. I am now getting the Subject as well as the body. //SYSUT1 DD * HELO MVSB ... |
|
| Topic: Subject not displayed in the mail sent via SMTP |
|
| mf_learner Replies: 6 Views: 4785 |
Forum: Job Control Language(JCL) Posted: Tue May 16, 2006 7:58 am Subject: Subject not displayed in the mail sent via SMTP |
| It worked with a little change, Kolusu. But, there is a problem that still persists.
I had to do a little bit of modification, because with the second instream data, the body of the mail was coming ... |
|
| Topic: Subject not displayed in the mail sent via SMTP |
|
| mf_learner Replies: 6 Views: 4785 |
Forum: Job Control Language(JCL) Posted: Tue May 16, 2006 7:04 am Subject: Subject not displayed in the mail sent via SMTP |
| I checked out that as well.....There arent any garbage values in 73-80 bytes on the subject line. All are blank.
Am I missing any params?......I believe Subject is not getting resolved itself..... |
|
| Topic: Subject not displayed in the mail sent via SMTP |
|
| mf_learner Replies: 6 Views: 4785 |
Forum: Job Control Language(JCL) Posted: Tue May 16, 2006 3:50 am Subject: Subject not displayed in the mail sent via SMTP |
| Hi,
I am using the following JCL for sending mail via SMTP. I am getting the mails, but the Subject line is not getting resolved and is displayed as blank. //MAIL001 EXEC PGM=IEBGENER ... |
|
All times are GMT - 5 Hours |