DSXchange

Hi Ernie, The structure I want in the output is <Details> <Officecode> <DEP> </DEP> </Officecode> <Details> Now I will give you the actual data. 01,FIN 03,SLS 01,FIN 01,TEC 02,TEC 01,FEC 02,HUR 03,MRT One Office can have multiple DEP's and there are many offices.(as you can see in the sample data) T...

Hi , I want to build a complex xml document using datastage. I also have gone through the XmlBestPractices.doc. My job design is like given below. file---->transformer------>xmlo/pDEP------------>join-----xmlo/pcombine ------->xmlo/pofficecode----> I am extracting data from a file which has officeco...

I have faced same issue while taking data from the teradata.Is the column you are picking form teradata table defined as time(8) in the table T1 and T2 . If not you need to cast this to proper time format as per datstge requirement while picking it . Hi, I casted the data from teh source to varchar...

Your transform stage input column HEUR_RELV_SOLD_PP is defined as Char(8), perhaps you inadvertantly redefined it in the sort or join stage. Without an explicit conversion, i.e. StringToTime(), DataSt ... hi ArndW, it is defined as time across all the stages. It is not defined as character in any s...

ray.wurlod wrote:You have not specified either a default time format or an explicit time format. Do either or both of these things. ...

Hi Ray,

where do we specify either a default time format or an explicit time format
and how do we do it.

It would be great if you could give us a hint on this.

Thanks,
Samyam

Hi, I have job like described below. table1-->sort-->join(Left join T1-T2)-->transformer--table3 table2-->sort--> the tables are teradata tables. we have a column HEUR_RELV_SOLD_PP which is in time format 'hh:mi:ss' format in table1. this columns is mapped to table3 through sort,join,transformer. th...

The job design goes like this.

seqfilestage-----> columnimport------->transformer---------->filter------->funnel -------->dataset

the exact error message is given below.

From previous run
DataStage Job 57 Phantom 25321
Attempting to Cleanup after ABORT raised in stage JxXXXXXXXXX.

DataStage Phantom Aborting with @ABORT.CODE = 3

there is no clue on why it is aborting.

Thanks
Samyam

Does this have to do anything with partitioning

Thanks,
Samyam

There is no error message id in the warning.

or where will i find it?

Thanks,
Samyam

Tr_DAT_MAJ_SOCLE: When checking operator: Dropping component "DAT_MAJ_SOCL" because of a prior component with the same name.

it is a warning.

Thanks
Samyam

no its refered only once.

dataset does not have dat_maj_socl
in transformer we are adding teh column dat_maj_socl with StringToTimestamp(L_TIMESTAMP,"%yyyy-%mm-%dd %hh:%nn:%ss")

in teradata we load dat_maj_socl which is comming from transformer.

Thanks,
Samyam

the job design is as given below. [dataset] ----> [Transformer] --------> [Teradata enterprise stage] the error message is "Tr_DAT_MAJ_SOCLE: When checking operator: Dropping component "DAT_MAJ_SOCL" because of a prior component with the same name" The column dat_maj_socl is not ...

Hi All, Has anyone encountered the following error while running a Datastage PX 7.5.2 Job before? U_ILLEGAL_ARGUMENT_ERROR encountered followed by Conversion problem in import method, trying to import:. followed by Operator terminated abnormally: received signal SIGSEGV. The source file format seems...

it worked for only one dsx file but now i am facing the same problem again. this time there is lot of space available. DS_AUDIT has permissions too. I am not able to run the UV command to check whats in the DS_AUDIT table. I am still getting the error on file DS_AUDIT cannot be written Program "...