DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 23 matches
Author Message
 Topic: passing a hard coded filter condition for a job parameter
cparru

Replies: 2
Views: 2547

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Apr 23, 2012 6:48 pm   Subject: passing a hard coded filter condition for a job parameter
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Additional info: passing a hard coded filter condition for a job parameter
Hi,

I am passing a hard coded filter condition to the job parameter and there by using it as a constraint in the transformer stage. but it is giving an error saying missing =..

the actual condit ...
Resolved
 Topic: Need to handle new line termination for a field
cparru

Replies: 11
Views: 3799

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 04, 2012 6:18 pm   Subject: broken address
Hi Guys,

I tried this solution tp load the address data which is broken into 2 lines. I was able to view the data in shared container/sequential file stage, but while loading it into the table (fro ...
 Topic: Orchestate commands
cparru

Replies: 3
Views: 2426

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Aug 24, 2009 7:05 pm   Subject: sh: orchadmin: not found.
sh: orchadmin: not found.
 Topic: Orchestate commands
cparru

Replies: 3
Views: 2426

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Aug 24, 2009 6:08 pm   Subject: Orchestate commands
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Additional info: orchestate commands setip
Hi,

I was trying to debug the data set files but i found that the ORCHADMIN commands are not available. I see the orchamdin in PEEngine dir but was unable to execute it.

How do i make use of the ...
 Topic: aggregator issue
cparru

Replies: 4
Views: 2213

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Aug 19, 2009 3:27 pm   Subject: aggregator issue
The output column derived is defined to be dfloat (Decimal).

Convert it as Timestamp. ...

Hi,

I tried that too.. but its the same error.

MAX_LAST_UPD_DT was defined as TIMESTAMP on the oup ...
 Topic: aggregator issue
cparru

Replies: 4
Views: 2213

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Aug 19, 2009 2:41 pm   Subject: aggregator issue
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Additional info: aggregator issue with timestamp field
Hi,

I was trying to do a MAX(TIMESTAMP_FIELD). and the job is failing with the error "No default type conversion from type "timestamp" to type "dfloat"."

Pls help me in resolving this.

Thanks ...
 Topic: Controller problem: Error calling DSSetParam(TEAM_VAR), code
cparru

Replies: 1
Views: 5780

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Aug 17, 2009 11:48 am   Subject: Controller problem: Error calling DSSetParam(TEAM_VAR), code
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Additional info: sequence job failure
Controller problem: Error calling DSSetParam(TEAM_VAR), code=-4
[ParamValue/Limitvalue is not appropriate]

I am executing a unix script using execute command sequence stage. If i ran it alone it i ...
 Topic: compiling shared container
cparru

Replies: 1
Views: 1446

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Nov 20, 2008 9:40 pm   Subject: compiling shared container
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Additional info: how to compiling shared container
hi,

I was supposed to make changes to the code that some else has written and i was unable to compile one of the shared containers.

please let me know of how to compile the shared containers.
...
 Topic: main_program: Received SIGPIPE signal caused by closing of
cparru

Replies: 1
Views: 4991

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Aug 28, 2008 12:11 pm   Subject: main_program: Received SIGPIPE signal caused by closing of
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
I was executing a job and got the following error -

main_program: Received SIGPIPE signal caused by closing of the socket on port 13,400.
No output will be sent to port 13,400 for the rest of the ...
 Topic: invocation id in sequence job
cparru

Replies: 4
Views: 2387

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Aug 08, 2008 12:55 pm   Subject: invocation id in sequence job
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Additional info: invocation id in sequence job
some of the job activities have the invocation id and some do not? is there a reason for that?

what do i need to do to get the invocation id in every job activity. Because, my sequence runs in a lo ...
 Topic: APT_CombinedOperatorController(0),1: Field 'EWO' from input
cparru

Replies: 2
Views: 1897

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jul 25, 2008 9:30 am   Subject: APT_CombinedOperatorController(0),1: Field 'EWO' from input
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Additional info: APT_CombinedOperatorController(0),1: Field 'EWO' from input
i was getting the following error -

APT_CombinedOperatorController(0),1: Field 'ABC' from input dataset '0' is NULL. Record dropped.

i have the field ABC defind to handle NULL(nullable=yes). but ...
 Topic: help about various oechadmin commands
cparru

Replies: 1
Views: 1035

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jul 15, 2008 9:01 am   Subject: help about various oechadmin commands
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Additional info: need the info related to orchadmin commands for debugging th
need the info related to orchadmin commands for debugging the data set information. Pls respond asap with either the list of commands and options or how can i find the information related to it.

Th ...
 Topic: connecting to the specific datastage server
cparru

Replies: 2
Views: 1430

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jul 14, 2008 7:34 am   Subject: connecting to the specific datastage server
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Additional info: I installed DS 8 and was trying to connect to one of the ser
I installed DS 8 and was trying to connect to one of the developemnt servers. I mentioned the server name in the hosts file but i was still unable to connect to it. Is there any thing that i miss out. ...
 Topic: how to specify default values for the environment variables
cparru

Replies: 5
Views: 1779

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu May 08, 2008 10:26 am   Subject: how to specify default values for the environment variables
I think you may need to use DSAddEnvVar from the Datastage Dev Kit

As you say, you don't get the option of setting defaults when you add a new user-defined env var through the Designer GUI


can ...
 Topic: how to specify default values for the environment variables
cparru

Replies: 5
Views: 1779

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu May 08, 2008 9:38 am   Subject: how to specify default values for the environment variables
How did you create the environment variables? I think you may need to use DSAddEnvVar from the Datastage Dev Kit


I created them using the datastage designer and from the properties window. But it ...
 

 Jump to:   



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