 |
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 13 matches |
| Author | Message |
|---|---|
 Topic: default count(*) of 0 when row not found |
|
| misi Replies: 1 Views: 1976 |
 Forum: Database Posted: Wed Feb 07, 2007 10:45 pm Subject: default count(*) of 0 when row not found |
| I want to display the count as 0 even though the select retrieves no rows .
i am running this query select cust_id,count(*) from cust_info where cust_amt_spent > 2000 if no rows f ... |
|
| Topic: compile date of pgm |
|
| misi Replies: 3 Views: 2514 |
Forum: Application Programming Posted: Mon Jun 21, 2004 4:38 am Subject: compile date of pgm |
| how can i find out when the pgm is compiled? i am having problem when my team member compiled the same pgm | |
| Topic: first and last record of a file |
|
| misi Replies: 3 Views: 5212 |
Forum: Job Control Language(JCL) Posted: Thu May 06, 2004 2:57 am Subject: first and last record of a file |
| I have a huge file and I just want the first record in a seperate file and the last record in another file. I dont want to write any programs ,how to do it in jcl
misi |
|
| Topic: ADRDSSU utility Documentation |
|
| misi Replies: 5 Views: 493164 |
Forum: Job Control Language(JCL) Posted: Thu Apr 29, 2004 8:42 am Subject: ADRDSSU utility Documentation |
| I am searching for ADRDSSU utility documentation. Can any one send if they have any?
Tia misi |
|
| Topic: dayname |
|
| misi Replies: 4 Views: 3103 |
Forum: Database Posted: Thu Apr 29, 2004 8:40 am Subject: dayname |
| Can I get the dayname using sql or in a pgm? I am reading a db2 table which has a date column and I want to know the dayname on which this date falls. The date can be any date. My processing differs a ... | |
| Topic: how to find if last month has 30 or 31 days from the current |
|
| misi Replies: 1 Views: 1913 |
Forum: Database Posted: Wed Apr 21, 2004 11:48 am Subject: how to find if last month has 30 or 31 days from the current |
| I have a program which should generate monthly report. The report can be run on any day of the month. The SQl query should retrieve all records which has been inserted for the last 1 month from the cu ... | |
| Topic: GdG version Create Date without recalling |
|
| misi Replies: 8 Views: 12589 |
Forum: Job Control Language(JCL) Posted: Tue Apr 20, 2004 10:43 am Subject: GdG version Create Date without recalling |
| Is there a way to know when the gdg versions are created? We have a gdg base with 100 generations. Most of the generations are in migrated status and it takes a long time to recall them to see the cre ... | |
| Topic: Primary and Foreign Key |
|
| misi Replies: 3 Views: 3073 |
Forum: Database Posted: Tue Apr 20, 2004 10:41 am Subject: Primary and Foreign Key |
| Thanks for the links, but I am getting a -551 error when running the queries. can you help me?
misi |
|
| Topic: max size |
|
| misi Replies: 2 Views: 3269 |
Forum: Application Programming Posted: Tue Apr 20, 2004 10:40 am Subject: max size |
| Thanks
misi |
|
| Topic: Current date and time in Dataset name |
|
| misi Replies: 46 Views: 84254 |
Forum: Job Control Language(JCL) Posted: Tue Apr 20, 2004 10:40 am Subject: Current date and time in Dataset name |
| Thanks superk and kolusu
We need the 4 digit year part in our dataset name. Is it possible. Thanks misi |
|
| Topic: max size |
|
| misi Replies: 2 Views: 3269 |
Forum: Application Programming Posted: Tue Apr 20, 2004 4:44 am Subject: max size |
| what is the maximum number of lines in a cobol program? and is there a limit for the maximum number of files that a program can process?
misi |
|
| Topic: Current date and time in Dataset name |
|
| misi Replies: 46 Views: 84254 |
Forum: Job Control Language(JCL) Posted: Tue Apr 20, 2004 4:41 am Subject: Current date and time in Dataset name |
| I need to have the current date and time as a part of my dataset. can any body help me?
I want USERID.YYYYMMDD.HHMMSS misi |
|
| Topic: Primary and Foreign Key |
|
| misi Replies: 3 Views: 3073 |
Forum: Database Posted: Tue Apr 20, 2004 4:35 am Subject: Primary and Foreign Key |
| How to find out priamry key in a db2 table . Also how to find the foreign key of the table?
misi |
|
All times are GMT - 5 Hours |