DSXchange

Hi All,

If date column is having null value how to check and then insert (null value with date column) in to a oracle table. Similarly with varchar values also

Thanks in advance

input is oracle and date column has a null value and target is also oralce table. Iam using IsNull() function. When i execute the job, job is aborted with this error. APT_CombinedOperatorController,0: Fatal Error: Null value on the accessor interfacing to field "start_date". node_node1: Pl...

Hi,

I have input in a .csv file as dd/mm/yyyy, output is oracle table datatype is date output should be yyyy-mm-dd.

Hi,

Iam getting this warning
When checking operator: When validating export schema: Unrecognized top level format property: nocheck

How do we check whether a column value is a numeric value or not


for example :
col1
----
101 (is a valid)
1A2 (is invalid)

Hi,

I have a column in a sequential file, where that column data is 101523 (10hrs 15mins 23secs) populating to oracle table column data type is date.

How to populate this data to oracle table as 10:15:23

Suggest some solutions.

Hi All,

Iam using seqfile--> transformer --> oracleenterprise

iam getting this warning.

When checking operator: When validating export schema: Unrecognized top level format property: nocheck

In oracle enterprise stage when I click on view data iam getting this error Error executing View Data command ##E TDOR 000172 15:15:30(002) <Oracle_Enterprise_0> Access to sys.dba_extents is required but not available; please ##I TFCN 000001 15:15:29(000) <main_program> Ascential DataStage(tm) Enter...

Hi, We installed datastage 7.5.2 on solaris 10. We created a some jobs. We are able to compile the jobs successfully but when we run it throws an error. bash-3.00$ dsjob -run dataconv abc Error running job Status code = -14 DSJE_TIMEOUT Thanks Even from director and also designer.

yes I have resolved the CC compiler. Now when iam using oracle enterprised stage in that when iam trying to import metadata iam getting error that 'UNABLE TO INITIALIZE PLUGIN'[

Hi, Just installed datastage 7.5.2 on solaris 10. and created a sample job Iam using seq->transformer->seq when iam compiling iam getting this error Output from transformer compilation follows: ##I TFCN 000001 14:34:54(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5.2 Copyright (c...

The above mentioned solutions are not working. Please give the solution

Hi,

write method = upsert
upsert order = insert then update
upsert mode = user defined update and insert


if I use upsert order as 'update then insert' its throwing an error that

'cannot recognize - update first'

thanks

I don't have any key columns, normal update