Search found 62 matches

by abhinavsuri
Wed May 16, 2018 7:37 am
Forum: General
Topic: creating hash file from sequential file
Replies: 9
Views: 4580

These hash files will be used as lookups in other jobs downstream.
by abhinavsuri
Tue May 15, 2018 1:26 pm
Forum: General
Topic: creating hash file from sequential file
Replies: 9
Views: 4580

just to add more details , I am using RCP to create a seq. file from the table. Now I need to use this seq. file to create a hash file but I need to define the keys
by abhinavsuri
Tue May 15, 2018 10:07 am
Forum: General
Topic: creating hash file from sequential file
Replies: 9
Views: 4580

All these files will have different sets of columns and also different key fields since the data is from different tables for each file. Can you point me in a direction where I can get information on how to create the hash file while defining teh metadata and keys?
by abhinavsuri
Mon May 14, 2018 2:39 pm
Forum: General
Topic: creating hash file from sequential file
Replies: 9
Views: 4580

Craig, can you guide me to any basic commands that can be used to do that? Reason we want to replace with the routine so that we do not have to write hundreds of jobs. Instead we want to create a utility which can be passed a parameter and will do the needful. We do something similar for some other ...
by abhinavsuri
Mon May 14, 2018 8:55 am
Forum: General
Topic: creating hash file from sequential file
Replies: 9
Views: 4580

creating hash file from sequential file

I am looking to create a hash file from a sequential file in a server routine(or any other generic way). Basically I neeed the data to be copied from the sequential file to the hash file without having to create a datastage job. Is this even possible? If it is possibe could you please guide me as to...
by abhinavsuri
Thu Mar 24, 2016 12:17 pm
Forum: General
Topic: Need access to QualityStage
Replies: 2
Views: 1873

Need access to QualityStage

I am looking for a trial or SAAS version of InfoSphere QualityStage so that I can try it out. Is there any service available?

I know the 8.1 on Amazon ec2 doesnt work
by abhinavsuri
Tue Nov 17, 2015 2:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Restful web service
Replies: 9
Views: 11278

However, in the log I see below message Peek_15,0: success:false errorMessage:CDIER0961E: The REST step is unable to invoke the REST service, cause=org.apache.http.conn.ConnectTimeoutException: Connect to welcome.coremetrics.com:443 timed out faultHttpStatusCode: faultHttpBody: httpVersion:NULL stat...
by abhinavsuri
Tue Nov 17, 2015 2:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Restful web service
Replies: 9
Views: 11278

This is the output of test assembly <?xml version="1.0" encoding="UTF-8"?><top> <InputLinks/> <result isOutputEnrichmentRoot="true"> <GETResponse> <callStatus> <success>false</success> <errorMessage>CDIER0410E: Error in step=REST, cause=java.lang.NoSuchMethodError: org....
by abhinavsuri
Tue Nov 17, 2015 2:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Restful web service
Replies: 9
Views: 11278

Yes I am able to get it working in the browser. I cant see the second portion of your post :(
by abhinavsuri
Tue Nov 17, 2015 1:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Restful web service
Replies: 9
Views: 11278

OK I managed to fix that one by marking all the output columns as NULLable. NOw I am able to Run , Test Assembly and it completes succeffully. However, wehen I check the response it says the test failed with below error. How can I fix this? Any help would be appreciated. success, errorMessage, fault...
by abhinavsuri
Fri Nov 13, 2015 3:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Restful web service
Replies: 9
Views: 11278

Restful web service

I am using a hierachical stage to call a restful webservice and am trying to write to sequential file. I configured the restful and general step but am getting below error. Anyone who could help me interpret this would be of great help Hierarchical_POST,0: Fatal Error: 2015-11-13 16:32:34,571 Fatal ...
by abhinavsuri
Mon Dec 17, 2012 10:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RCP and NZ connector
Replies: 1
Views: 1934

I also observe that if I pass only a single key column instead of two key columns teh job works correctly
by abhinavsuri
Sun Dec 16, 2012 2:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RCP and NZ connector
Replies: 1
Views: 1934

RCP and NZ connector

I have a job which reads from a file and writes to a NZ connector. The columns in the source and target are exactly the same. However, the target table doesn't have one column defined in the columns tab because I am using Acton column property in NZ connector. I am also using RCP so that I do not ha...
by abhinavsuri
Sun Dec 16, 2012 12:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unique key Column property in Netezza connector
Replies: 2
Views: 2730

Thanks asorrell.

It makes sense now. The name of the property is kinda akin to the Oracle Unique constraint and hence the confusion. I am clear now