DSXchange

Hi Everyone, When I am tring to apply the MOD function , Its removing decimal spaces . Can anyone hellp me in this. EX: Source Data ( X = -12.90 ) Expected Data = 5.43 The Given Logic should be apply in my job : -------------------------------------------------- ABS(X) MOD 7.47 ---------------------...

What values can you expect in the source FIELD-1? If just the digits 1-10 then a simple transform IF-THEN-ELSE construct would do the trick. Also, must this be a parallel job, it would be an almost tr ... Hi ArndW, I may get any kind of data from source file , not only numberics. what I posted in m...

Hi All, Here I had question , I have an FLAT FILE as SOURCE and DB2 as Target , DB2 field names and data types FILED-1 CHAR 10 No BIT FIELD-2 CHAR 10 No BIT When I am inserting data into DB2 I need to insert the data as HEXIDECIMAL DATA. EX : ----- SOURCE(EBCDIC) =========== TARGET(HEXA-DECIMAL) ---...

Finally I wrote a unix script and resolved the issue

Thanks

Aravind

We are also facing similar kind of issue, any body who faced this issue and resolved it.

Thanks

I need to create header and footer in the Sequential file and XML (target files) from the source DB like DB2. Please, let me know the process of doing it. Also I would appreciate if you can help me the error handling techniques to deal when we use sequential and XML files as a source and DB2 as Targ...

Hi, I am runing parrale job, my source is orcale , it's not showing preveiw data. it's showing this error. could u tell me wt is the reson. thanks gvr ##I TFCN 000001 17:13:12(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5 Copyright (c) 2004, 1997-2004 Ascential Software Corporat...

Hi all,
I didn't find MATCH Function in version 8. could any one help me

thank you
gvstrao

Hi ,

I am new to Quality Stage, I want to know

How Can We Categorize the records on the source file for Investigation.

Can we do investigation on the whole record in a single source file.

Can anyone help me in this.

GVSTRAO

Thanks Everyone

JoshGeorge, Your logic is working fine for me.

Thank you
Regards

GVSTRAO

Hi Everyone, I am using Flat file as a source, DB2 as a target stages in PX. I am getting the date data as given below. SOURCE = > 1/30/2006 12:00:00 AM I need the data like given below. How can I make out this. Could anyone help me to fix this. TARGET => 2006-01-30 Thanks in advance. GVSTRAO

Thanks Ray

Hi Eveyone,

I am extracting the Hungarian data from DB2 server. Data looks like the given below.

György
Richárd
Balázs
István
Zoltán

How can I convert this data to English language.

Could anyone help me in this.

Thank you,
Regards

GVSTRAO

Hi, When Iam running an SAP IDOC load job Iam getting an warning and Error saying that Warning : Doc_Load_PACK_for_SAP_R_3_5,0: trc file: "/home/dsadm/Ascential/DataStage/DSSAPConnections/RFC_TRACE/CPICTRC49824", trc level: 1, release: "640" Fatal Error : IDoc_Load_PACK_for_SAP_R...

Hi , Thanks for the reply. I tried to convert the date from varchar to date in transformer using String to Date function . String to Date ( Employee_Hire Date , "%yyyy-%mm-%dd") but Iam getting warnings and I got warning as Transformer_13,0: Conversion error calling conversion routine date...