DSXchange

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 condition is linkname.columnname=2 AND (linkname.columnname=\'A\'OR linkname.columnname=\'M\') even the simple ...

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 (from a parallel job) it is still loading 2 records for one address. How do i remove that new line characte...

sh: orchadmin: not found.

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 orchamdin command. Would be a great help if you can guide me through the configuration details. Thanks, R...

Sainath.Srinivasan wrote: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 ouput tab. Do you think of any other work around.

Thanks for your immediate response.

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 in advance.

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 is working fine and producing the desired output for ex 'ABCD' If i pass this output to a paraemter in th...

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.

Thanks in advance.

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 job. RT_SC258/OshExecuter.sh[25]: 2396384 Segmentation fault(coredump) this is a multiple instance job a...

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 loop so i want the execution be separated for each iteration.

Thanks in advance...

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 not sure why it is dropping the records.

pls do respond asap with your suggestions.

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.

Thanks in advance..

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.

Pls let me know of any configuration settings to get connect to my server.

Thanks in advance

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 you pls eloborate the use of this and where can i find this etc....it would be a great help for me. Thanks,

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 does not have the option of specifying the default values at the time of creation. I need to specify th...