DSXchange

I have two output links and I've a constraint on each. Say, for first output link, I mention that Len(cust_id)=0. If I want to write all records which fail this constraint to the other output link, instead of using a constraint such as Len(cust_id)<>0, do I have any other way to achieve the same.

Hi,

How can use the 'Otherwise' option in constraints?

Thanks,
Sumesh

Hi,

I used

Oconv(@DATE,'D-YMD'):Oconv(@TIME,'MTS') to populate the current datetime into the Oracle table. How can I achieve the same result using TimeDate function.

Thanks,
Sumesh

Thanks Craig.

Hi All, I got the DS dev environment ready...but I'm unable to save a job. I get an error as Error while creating job CustLoad Error on CREATE.FILE command (User does not have WRITE permissions to current directory. I checked the file permissions and found that the groups differ for dsadm and the de...

Hi All,

I want to populate todays's date as '11/05/2008 12:00:00'. How can I do other than hardcoding as
OConv(@DATE,"D-YMD"):'12:00:00'

Thanks,
Sumesh

I am using three stages in my job. Dataset as a input, then transformer and then oracle stage.I am generating a sequence for one of the column in a transformer. so need to use round robin partition. But I am getting following warning : X_Clearance: Input dataset 0 has a partitioning method other tha...

If I give Null Field Value=' ' (22) spaces it gives a diff warning saying no default value defined for a nullable field.

What could be causing this warning.

Hi, I have a situation where in i am reading from a sequential file and after some processing writing to a sequential file. It is a '|' delimited file. I have decimal fields which are nullable.ex;UNIT_RETAIL(20,4) Warning: When validating export schema: At field "UNIT_RETAIL": "null_f...

Hi, I have a similar situation where in i am reading from a sequential file and after some processing writing to a sequential file. It is a '|' delimited file. I have decimal fields which are nullable.ex;UNIT_RETAIL(20,4) Warning: When validating export schema: At field "UNIT_RETAIL": &quo...

Dear All,

I want to apply Trim function in the transformer for 65 columns. I was looking for any functionality in PX where I can specify Trim for one column and let it be cascaded to other columns. Do we have anything like that? Any help on this would be appreciated.


Cheers,
Sumesh

The paramters are correctly specified in the sequencer. Still I get the records not inserted into the table. What could be the cause?

Hi All, I'm inserting records into an Oracle table using Oracle Enterprise stage and the Write method is Upsert. I've mentioned the Update SQL and Insert SQL statements correctly. When I run the job records are getting inserted into the table successfully. But when I run the job through sequencer, r...

Hi All, In my job, source is a data set. These records are transformed in the transformer and then loaded into an Oracle table. When I run the job I get error as main_program: Fatal Error: Caught ORCHESTRATE exception in main program: APT_ParseError: Parsing parameters "max=0" for schema t...

Hi All, In my job, source is a data set. These records are transformed in the transformer and then loaded into an Oracle table. When I run the job I get error as main_program: Fatal Error: Caught ORCHESTRATE exception in main program: APT_ParseError: Parsing parameters "max=0" for schema t...