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



Joined: 02 Jun 2017
Posts: 2

Points: 36

Post Posted: Fri Jun 02, 2017 3:21 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Windows
1. CSV file loaded in IA through thin client via file engine connector.
2. Ran profile in thin client.
3. now in thick client/workbench -->When try to run 'Rules', it says executed completed (no error).
4. But when I try to see the test results, it give message like ' no rules have been ran' please run the rules.

Can you please point me in correct direction where I can see the test results. Which step I am missing.

Also, while I load file thru thick client, it gives red icon at host name is this expected?

In thin client we cannot create a new rule definition right? we can only bind existing rule in thin client is my understanding right?

thank you
rjdickson
Participant



Joined: 16 Jun 2003
Posts: 378
Location: Chicago, USA
Points: 2531

Post Posted: Wed Jun 07, 2017 7:47 am Reply with quote    Back to top    

Hi,

Are you talking about a Data Rule? Can you please be more specific about where you see the error? Can you please try to create the Data Rule in the Thin Client?

As for the red icon, yes, that is expected. The Thick Client does not know about those source types (File Connector), so it does not know how to represent it.

As of Fixpack 2, data rule definitions must be created in the Thick Client (or the API). This 'gap' will be closed in a future release (date unknown Smile) Data Rules can be created in both thick and thin.

Generally speaking, I would advise to do as much work as possible in the thin client.

_________________
Regards,
Robert
Rate this response:  
datajan
Participant



Joined: 02 Jun 2017
Posts: 2

Points: 36

Post Posted: Fri Jun 09, 2017 12:52 pm Reply with quote    Back to top    

Thank you rjdickson. I am seeing the error in thick client when clicked on 'view test results'. But we cannot create a new rule definition in thin client right? Smile

One more finding:
when I create rule definition in thick client as 'if jan is_numeric then jan matches_format '99.99''
Where jan is variable name.

And in INI file I have define Jan as numeric.
When I try to bind (in thick client) that with the corresponding column it gives error 'one of the variable in the rule logic is bound to an invalid data type'. I get that as under 'Resolve Bindings' the third column is data type as string. How does it has string. How to change that, is that editable? any pointes will be very helpful.

Razz Razz Smile Smile Smile
Rate this response:  
rjdickson
Participant



Joined: 16 Jun 2003
Posts: 378
Location: Chicago, USA
Points: 2531

Post Posted: Mon Jun 12, 2017 6:12 pm Reply with quote    Back to top    

My initial guess would be that 'matches format' inputs must be string.

You may want to try:
if jan is_numeric then tostring(jan) matches_format '99.99'

_________________
Regards,
Robert
Rate this response:  
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