 |
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 16 matches |
| Author | Message |
|---|---|
 Topic: sql query needed based on count(*) |
|
| mvenkatesha Replies: 14 Views: 7836 |
 Forum: Database Posted: Mon Dec 18, 2006 7:30 am Subject: sql query needed based on count(*) |
| Kolusu,
I went to my friend's project where DB2 Version 7 was used. I was able to get the result for the above query and it worked perfetly. Thanks a lot for your detailed explination. : ... |
|
| Topic: sql query needed based on count(*) |
|
| mvenkatesha Replies: 14 Views: 7836 |
Forum: Database Posted: Mon Dec 18, 2006 6:45 am Subject: sql query needed based on count(*) |
| The query runs fine on my system and we are running DB2 version 7. Run the following query in spufi
SELECT NAME FROM SYSIBM.SYSTABLES WHERE CREATOR = 'SYSIBM' ORDER BY NAME; From the r ... |
|
| Topic: sql query needed based on count(*) |
|
| mvenkatesha Replies: 14 Views: 7836 |
Forum: Database Posted: Thu Dec 14, 2006 10:05 am Subject: sql query needed based on count(*) |
| mvenkatesha,
what is your DB2 version ? The older version of DB2 (< version 7) does not support and update and select statement on the same object within a single query. Hope this helps... ... |
|
| Topic: sql query needed based on count(*) |
|
| mvenkatesha Replies: 14 Views: 7836 |
Forum: Database Posted: Thu Dec 14, 2006 4:44 am Subject: sql query needed based on count(*) |
| kolusu
I am trying each topic posted on MVS forms. On this topic I have found some errors. Can you please find the query below and please let me know why I am getting SQLCODE = -118. ... |
|
| Topic: Problem with wild character in DB2 select |
|
| mvenkatesha Replies: 3 Views: 2336 |
Forum: Database Posted: Thu Dec 14, 2006 2:22 am Subject: Problem with wild character in DB2 select |
| sriramla / kolusu
Thanks a lot for your explanation. You have explained the problem if such a fashion I will remember this in my dreams. Once again Thanks a lot. |
|
| Topic: Problem with wild character in DB2 select |
|
| mvenkatesha Replies: 3 Views: 2336 |
Forum: Database Posted: Mon Dec 11, 2006 8:24 am Subject: Problem with wild character in DB2 select |
| I am not sure why the below query is not returning any records. Can anyone please explain the problem. I have already searched the MVS FORMS but I coudnt get any help for this.
Please let me know ... |
|
| Topic: FILE MASTER DOCUMENT |
|
| mvenkatesha Replies: 1 Views: 1740 |
Forum: Utilities Posted: Fri Dec 08, 2006 2:40 am Subject: FILE MASTER DOCUMENT |
| Hi,
Currently I am having FILE MASTER in our project can any one please help me providing FILE MASTER Document and how to use. I was able to found a lot on File Master in the MVSFORMS an ... |
|
| Topic: Problem with Foreign Key Contraint |
|
| mvenkatesha Replies: 2 Views: 3005 |
Forum: Database Posted: Thu Dec 07, 2006 7:40 am Subject: Problem with Foreign Key Contraint |
| Bauer
Thanks a lot for your information. I was able to correct my Query and able to run. |
|
| Topic: Problem with Foreign Key Contraint |
|
| mvenkatesha Replies: 2 Views: 3005 |
Forum: Database Posted: Thu Dec 07, 2006 12:56 am Subject: Problem with Foreign Key Contraint |
 I was preparing for DB2 700 exam and surprised why I am getting foreign key constraint SQLCODE = -530. Can anyone please let me know what I am doing wrong because I feel record must be inserted but ... |
|
| Topic: IMS DB and DC documents. |
|
| mvenkatesha Replies: 6 Views: 4176 |
Forum: IMS Posted: Wed Nov 08, 2006 11:45 am Subject: IMS DB and DC documents. |
| vjkumk
Thanka a lof for the link. It has given me the knowledge what I wanted on IMS. I really appreciate your help and time. Venkat |
|
| Topic: IMS DB and DC documents. |
|
| mvenkatesha Replies: 6 Views: 4176 |
Forum: IMS Posted: Tue Oct 17, 2006 7:45 am Subject: IMS DB and DC documents. |
| Hi
I have experienced inmainframe but recently i have started learning IMS. Can any one please provide me a simple documents to start with. Please send it to it will be of great help. |
|
| Topic: Screen Defination Fecility to design maps. |
|
| mvenkatesha Replies: 3 Views: 2458 |
Forum: CICS and Middleware Posted: Tue Oct 17, 2006 6:13 am Subject: Screen Defination Fecility to design maps. |
| ofer71
SDF is available in our project software. So i wanted to try and learn and we dont have any documentation on this. |
|
| Topic: Mainframe Simulator |
|
| mvenkatesha Replies: 4 Views: 9402 |
Forum: Tools and Downloads Posted: Tue Oct 17, 2006 6:04 am Subject: Mainframe Simulator |
| Hi I heard mainframe simulators on ZO's is available can anyone let me know how to purchase a home licence of the mainframe simulator or how to buy them. | |
| Topic: Screen Defination Fecility to design maps. |
|
| mvenkatesha Replies: 3 Views: 2458 |
Forum: CICS and Middleware Posted: Tue Oct 17, 2006 1:05 am Subject: Screen Defination Fecility to design maps. |
| Hello,
I am having SDF fecility in our mainframes. can any one please provide a documentation how to use and compile a maps using SDF. |
|
| Topic: How to calculate space for a LRECL=500,FB and max 10000 recs |
|
| mvenkatesha Replies: 43 Views: 85022 |
Forum: Job Control Language(JCL) Posted: Wed Oct 11, 2006 2:02 am Subject: How to calculate space for a LRECL=500,FB and max 10000 recs |
| Johann,
The first posting by you is great help for me. This really helped me to allocate the datasets of sufficient size and handling memory efficiently. Can I get more theoretical informat ... |
|
All times are GMT - 5 Hours |