IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DB2 collection


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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: 93
Location: India

PostPosted: Fri Apr 09, 2010 12:08 pm
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
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: 93
Location: India

PostPosted: Fri Apr 09, 2010 12:42 pm
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
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: 93
Location: India

PostPosted: Fri Apr 09, 2010 1:00 pm
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
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

Moderator Emeritus


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

PostPosted: Fri Apr 09, 2010 8:37 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts understand about collection ID and pa... DB2 8
No new posts Error for NULLID collection DB2 5
No new posts Collection ID in the package DB2 2
No new posts Collection of dataset in JCL using REXX CLIST & REXX 18
This topic is locked: you cannot edit posts or make replies. Regarding packages, Collection & ... DB2 11
Search our Forums:

Back to Top