Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 collection

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sachinbhavsar

New User


Joined: 15 Feb 2006
Posts: 9
Location: Stockholm,Sweden

PostPosted: Fri Apr 09, 2010 12:03 pm    Post subject: DB2 collection
Reply with quote

Hi,

I have 2 tables in online program with different collection ID's say one is WW and another is Z4.

Now, If I compile and try to check the data its not giving me correct data which is required from tables.

Can you pls suggest me the on this.?

Sachin
Back to top
View user's profile Send private message

Ranjithkumar

New User


Joined: 10 Sep 2008
Posts: 94
Location: India

PostPosted: Fri Apr 09, 2010 12:08 pm    Post subject: Reply to: DB2 collection
Reply with quote

Quote:
If I compile and try to check the data its not giving me correct data which is required from tables.


What data you are talking about? Dta from the table or data about the table? Provide more details on what is expected and what you've got.
Back to top
View user's profile Send private message
sachinbhavsar

New User


Joined: 15 Feb 2006
Posts: 9
Location: Stockholm,Sweden

PostPosted: Fri Apr 09, 2010 12:17 pm    Post subject:
Reply with quote

The data present in table is not abel to fetched.

I am trying to fetch data from two tales one is of WW other is OF Z4.

let me know if required more details
Back to top
View user's profile Send private message
Ranjithkumar

New User


Joined: 10 Sep 2008
Posts: 94
Location: India

PostPosted: Fri Apr 09, 2010 12:42 pm    Post subject: Reply to: DB2 collection
Reply with quote

Provide the query, the error message you've got, the sql code and any other information you have.
Back to top
View user's profile Send private message
sachinbhavsar

New User


Joined: 15 Feb 2006
Posts: 9
Location: Stockholm,Sweden

PostPosted: Fri Apr 09, 2010 12:52 pm    Post subject:
Reply with quote

Sql code is Zero....Even though Its througing problem while fetch operation.
Back to top
View user's profile Send private message
Ranjithkumar

New User


Joined: 10 Sep 2008
Posts: 94
Location: India

PostPosted: Fri Apr 09, 2010 1:00 pm    Post subject: Reply to: DB2 collection
Reply with quote

Sachin,

Unless you provide more input we cannot help you resolve the issue.

Quote:
If I compile and try to check the data its not giving me correct data which is required from tables.


What is correct data? Are you getting any data from your query? If yes, what is the data expected form the table and what you are getting? And how do you say that the data is not correct?

Quote:
Provide the query, the error message you've got, the sql code and any other information you have.


You haven't provided the query and any other information. How can we analyse anything from what you have provided?
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Fri Apr 09, 2010 5:00 pm    Post subject:
Reply with quote

a table is not in a collection.
Maybe you mean qualifier/schema/owner/creator ?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Apr 09, 2010 8:37 pm    Post subject:
Reply with quote

Hello,

Quote:
Sql code is Zero....Even though Its througing problem while fetch operation.
How can there be "througing problem" if the sql code is zero.

You need to post what we need to help, not what you believe should be posted. You also need to use standard teminology, not something that only has local meaning.

Quote:
The data present in table is not abel to fetched.

I am trying to fetch data from two tales one is of WW other is OF Z4.
If the data is present in a table it can be "fetched". . . I suspect no one here has heard of a WW table (or a Z4 table for that matter).

If you take the time to more clearly explain what you have and what exactly is not working, someone should be able to help.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts understand about collection ID and pa... arjun.h DB2 8 Fri Mar 15, 2013 1:56 pm
No new posts Error for NULLID collection gylbharat DB2 5 Fri Oct 19, 2012 11:49 am
No new posts Collection ID in the package grayWolf DB2 2 Fri Nov 19, 2010 10:16 am
No new posts Collection of dataset in JCL using REXX expat CLIST & REXX 18 Fri Jun 26, 2009 10:13 pm
This topic is locked: you cannot edit posts or make replies. Regarding packages, Collection & ... sushanth bobby DB2 11 Wed Nov 12, 2008 4:40 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us