DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
Lamont Lockwood



Group memberships:
Premium Members

Joined: 11 Jan 2002
Posts: 3

Points: 25

Post Posted: Thu Dec 07, 2017 3:51 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: Constrain custom query works for simple; 0 rows for complex
11.5.0.2: We are trying to pull all column information for a particular stage type in a project.

We used the Stage Column asset type and built a nice report for Column-Link-Stage-Stage Type-Job-Project hierarchy. It returned about 800,000 rows to the console. We added Constraints on the Project or Stage Type and it returned 0 rows. We added Constraints on the Column Name and it worked fine (not useful for us but shows that some constraints work and others don't).

We were able to use istool to dump the unconstrained .csv on a small project but it failed on the larger project. Any ideas on how to fix the constraints or how to spend my idle time waiting for istool to dump 1,000,000 rows? What can I set to help istool process 1M rows? Wink

Also, why do IGC query files have the first stubby line of the .csv that always has to be filtered out?

Thanks!

Lamont
eostic

Premium Poster



Group memberships:
Premium Members

Joined: 17 Oct 2005
Posts: 3745

Points: 29966

Post Posted: Mon Dec 11, 2017 3:22 pm Reply with quote    Back to top    

There is a lot going on here, Lamont.....Conditions should work, but check which path your assets are in....and check begins_with as well as contains....and start initially without going as deep as ou ...

_________________
Ernie Ostic

blogit!
Open IGC is Here!
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours